Link between Item and delivery

[Former Member]

Hi ,

I want to know the link between item and deliveyr. Like for example, an sales order item ( no. 10) containing 10 quantities can be delviered 5 times( each containing 2 quantities) and line item ( no. 20) can contain one single delivery. I am working on a report where i have to link all the line item to its delivery number. I am trying to achieve this through GENIl but i am not able to indetify as to how to differentiate the different deliveyr numbers. In other words, can some one help me as to how to link the delivery number to its corresponding items?

[Former Member · Accepted solution]

Thanks for your reply Banu but i would want to know it on the CRM side. I know the document flow data gets stored in VBFA table but in CRM is there a field in GENIL which indicates the linkage between item and delivery. In other words, do we have a field which indicates that this delivery number is for this item?

[Former Member · Accepted solution]

Go through the function module in CRM

CRM_DOC_FLOW_READ_OB

This is used to retrieve the document flow of business transaction.

[Former Member]

Thanks.

[Former Member]

Document flow is stored in the table VBFA in ECC.

VBELV fied is the sales order number and in POSNV specify the line item number and speicfy VBTYP_N = J (Delivery).

Regards,

Bhanu