Hey Vanessa,
Sorry for the delayed response and thank you for the screenshots.
If you record a Transaction script in ZVIV, go up to the screen where you see the Total, click once on the field value to place your cursor there, then click the Out button (Yellow one next to the back button).
Once you're returned to your mapper, see if the field name for Total was captured as the value of the BDC_CURSOR position.
If it captured a field name from where you left your cursor, you can Add New Row in that section, and enter the value captured from that cursor position as the field name, and then you can map that as a download field to a spreadsheet.
Sometimes that works to be able to read values from those dynamic reports.
------------------------------
James Lofgren | Solutions Engineer
Winshuttle North America | [City] |
------------------------------
Original Message:
Sent: 10-04-2019 14:05
From: Vanessa Kutasi
Subject: ZVIV or Z005 Net Price
Hi James
Z005 is a pricing condition under VK11 that adds a $ discount. ZVIV is a way for the net value to be loaded into the customer master via a button "special price". SAP then does a calculation on the back end that compares the material list price and then creates the Z005 discount value.
Most people load the discount value but for this process, since they are contracted prices, the file is sent with the contractual price.
So VK13, will display the discount, ZVIV (custom t-code) will display the list price, discount and then net value. We are looking to report out on the net value to validate that the request was entered correctly. Right now it is a very manual process that has to be done one account at a time.
I have attached additional screenshots in case they help. XD01/2 is how we create/update customer masters but that is not where the pricing is done.
------------------------------
Vanessa Kutasi | Application Analyst II
IDEXX | New England WUG Leader
Original Message:
Sent: 10-04-2019 12:57
From: James Lofgren
Subject: ZVIV or Z005 Net Price
Hey Vanessa,
Hope things are going well! Are there standard SAP t-codes that would be similar in functionality to these Z-codes? I'm trying to take a look in our systems over here, but I don't have ZVIV, Z005, or ZICN.
------------------------------
James Lofgren | Solutions Engineer
Winshuttle North America | [City] |
Original Message:
Sent: 09-25-2019 10:11
From: Vanessa Kutasi
Subject: ZVIV or Z005 Net Price
Hello,
Has anyone been able to pull customer specific net pricing? We enter via ZVIV and Z005. I am able to pull the discount but I am looking to pull the net (actual customer cost). SE16N shows discount but not net. The view via ZICN provides a net value however, due to being a string, I cannot Query it. Transaction doesn't seem to be the right answer either. I have looked into BAPI but am not familiar enough with BAPIs to know what to look for.
Thank you!
------------------------------
Vanessa Kutasi | Application Analyst II
IDEXX | New England WUG Leader
------------------------------