Linking a Delivery Doc to Purchase Cost

[former_member604104]

When a Delivery Document is linked to a "Purchase Order" or similar purchase document (e.g., you could click relationship map, and it will show the Purchase Order it is linked to), how do I find that logic linked in SQL. The problem is that these items have varrying costs, so it is not constant, and the database is created in such an archaic way, that it is impossible to find the linkage.

For instance if I look at the SRI1 table, I have 4 records with that contain the EXACT [ItemCode] and [SysSerial]. This makes no sense why this would be the case? Shouldn't each item# only have 1 [SysSerial]? Two are references to who the items were purchased from, and two were references to who purchased. How do I determine which purchase line was associated with the corresponding sell line? There are other tables, but they seem to contain the same chaos and do not seem to point to the answer. I am not why SAP just didn't make this simplier and just use a unique key in the serial data to link to a PO. I guess that would be to easy.

[Abdul]

Dear

Its common if you are using serial number function then each unit of same item must have unique serial number for example you have 3 Huawei P30 phones in case on serial number item code will be same and serial number will be different as per IMEI number.

I think you want one item as one record then you need to go got batch number functionality because in serial number you cannot group each quantity unit is seperate

[former_member225732]

Dear Mr. Seth Knorr,

This tracking and report is only possible and correct if you are managing item by batch/serial and valuation method is Serial/batch.

Best Regards,

Sandesh Shinde

[former_member604104]

Yes, I have tried all of this, but there is no definitive linkage based on these answers. I have even run into duplicate internal system serial numbers.

[former_member280812]

Hi,

Try to use the "LineNum" column in the base document and the "BaseLine" column in the target document.

[msundararaja_perumal]

Hello,

You can use the SDK help to view all the table links.

The linkage is always based on the primary document rows data table in a document, for example if delivery(ODLN), the primary document row data table is DLN1 and the BaseType, BaseEntry and BaseLineNum will be link to Purchase Order, if the BaseType is 22

Thanks.