Shipment Details

[Former Member]

Hi Friends,

The invoice header data will be stored in the table called VBRK. Same way the item details will be stored in the table called VBRP. Say I want to retrieve item details for an invoice I can do so using vbeln which is a common field in both vbrk and vbrp tables. But if I want to retrieve shipment details for a specific invoice how can I do so ?

<b>Points for sure.</b>

Cheers,

Ben.

Message was edited by: Daniel Ben

[Former Member · Accepted solution]

Deniel,

check below tables u may get some idea

http://www.sapgenie.com/abap/tables_sd.htm

i think this would be useful for u

Regards

Naveen

[Former Member · Accepted solution]

HI Navven,

Thank you very much my friend. You help has very useful to me. So far I have been wondering where the flow of SD will help an ABAPer to do the tasks. IN this scenario you have proved me that knowing the flow is more important than coding stuff.

I appreciate your help.

Tanveer , your help is no less.

Thank you very much.

Thanks and Regards,

Ben.

Message was edited by: Daniel Ben

[Former Member]

Hi,

I have mailed you the documents.

Regards,

Tanveer.

If your question is answered, please close the thread and please mark if found helpful

[Former Member]

Hi Daniel,

Welcome to SDN.

The Shippment details are stored in table

VEPO (SD DOC: Shipping Item Content)

VEPO (SD DOC: Shipping Unit Header)

VTTP (Shipping Item)

VTTK (Shippment header)

They are all linked using VBELN.

The VBRP table has relation with table LIPS using VBELN.

LIPS has relation with table LIKP using VBELN.

LIKP has relation with table VEPO using VBELN.

VEPO has relation with table VEKP using VBELN.

VTTP has relation with LIKP using VBELN.

I shall mail you the relation diagrams amongest these tables.

Send me your email id.

Regards,

Tanveer.

Please mark helpful answers.

[Former Member]

Hi Tanveer shaik,

My mail Id is daniel.ben@hotmail.com

Regards,

Ben.