cancel
Showing results for 
Search instead for 
Did you mean: 

Table for Delivery number

Former Member
0 Kudos
24,289

Hi All,

i've created a delivery for a STO order using VL10B.

Now i need a table which has the delivery number along with the STO doc number and item number so that i can fetch it for further processing.

Kindly help in this issue.

regards

Prabhu

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

check EKBE itself, here u will get both STO and Delivery.

Regards

Prabhu

Answers (5)

Answers (5)

Former Member
0 Kudos

You have to make the following join to retrieve the delivery and the STO corresponding to it.

Join LIKP, LIPS : LIKP-VBELN = LIPS-VBELN
Join EKPO, LIPS : EKKO-EBELN - LIPS-VGBEL AND EKPO-EBELP = LIPS-POSNR
Join EKKO, EKPO : EKKO-EBELN = EKPO-EBELN

More than one inbound delivery can be created with reference to a STO, so STO is referenced in the delivery at item level in LIPS-VGBEL.

Former Member
0 Kudos

Hi,

Try using the table VBFA (Sales Document Flow). where in if u give the preceding document it wil give u the subsequent and vise versa.

but u need to maintain the proper

VBTYP_N (Document category of subsequent document) and

VBTYP_V (Document category of preceding SD document)

Thanks !

Former Member
0 Kudos

Hey Prabhu,

The table that contains the Delivery Number is LIKP.

The Item details for the deliveries are contained in the table LIPS.

LIPS also contains the Sales Document number and Item corresponding to the Delivery Number and Item.

Reward points if useful.

Thanks,

Himanshu.

Former Member
0 Kudos

Hi Prabhu,

LTAP is a table for TO items. It contains delivery VBELN. LTAP-VBELN.

Br,

Laxmi

Former Member
0 Kudos

Hi Prabhu

jus refer the following link

http://allsaplinks.com/tables.html