cancel
Showing results for 
Search instead for 
Did you mean: 

How To get Open inbound delivery Quantity from Tables

sarat_malladi
Explorer
0 Kudos

Dear All,

My requirement is to Get Quantity on inbound deliveries not PGR/PGI, (WMPP minus, HOD/HID plus) Select Delivery lines for Sales Org, ID type, Sold to,  Sum by material/sloc.

Selection screen of the report contains: Sales Org, inbound delivery type, Sold to,  material & Storage location.

Aim of the report is to compute the stock buckets to get the "ATP" quantity. (Available to promise) (one of the stock bucket is open inbound delivery quantity).

Regards,

Sarat

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member233510
Active Contributor
0 Kudos

The delivery tables are LIPS & LIKP but you can't get the open quantity value directly from these tables. You need to go for an enhancement. Get sales document number VBELN from the table VBAK, pass it to the table LIPS to get the delivery document number.From the delivery documents you've to calculate the total delivered quantity & differentiate it with the sale order quantity.

Former Member
0 Kudos

Hi,

Check LIPS table