Sample Header Ad - 728x90

How do you extract discount data from SAP?

0 votes
1 answer
1062 views
I'm **not** a SAP developer. We already have a big SSIS package that pulls data from the SQL Server instance that our SAP installation uses and I need to add discount data to it. I've usually had pretty good luck looking through this package and the SAP UI and then using Google & [SAP Data Sheets](https://www.sapdatasheet.org/abap/) to figure out how the tables are laid out, but this time I'm totally lost. In the SAP UI, the data I'm searching for is listed under the order document conditions. The Googling I have done makes it pretty clear that I'm supposed to use VBAK.KNUMV and JOIN to KONV.KNUMV. Here's the problem: our server doesn't have KONV. I found a [forum post](https://archive.sap.com/discussions/thread/586011) that says that I can JOIN to KONP.KNUMH instead, but for the sample document I'm working on, there's no corresponding record in KONH. I can't find an explanation for why KONV doesn't exist, and I don't know why JOINing VBAK.KNUMV to KONH.KNUMH doesn't work. If anyone could guide me down the right path, I would appreciate it. I don't know SAP, so I am not really clear on what a cluster table is. They kind of sound like views, which is fine, but no object with the name KONV exists in SQL Server. Saying that KONV is a combination of KONH and KONP is also fine, but that doesn't appear to actually be true. I need to know where this data physically lives in SQL Sever and that's what I can't figure out.
Asked by nateirvin (756 rep)
Feb 9, 2017, 08:19 PM
Last activity: Aug 18, 2021, 05:01 PM