Skip to Content
avatar image
Former Member

How To get Open inbound delivery Quantity from Tables

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 23, 2015 at 12:36 PM

    Hi,

    Check LIPS table

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 23, 2015 at 02:00 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded