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
I can't find an explanation for why
KONV doesn't exist, and I don't know why JOINing
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.