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 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 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.