Delivery date and GR date

[Former Member]

Hi All,

I am new to SAP BW and working on purchasing. I have to create a Late Delivery Report in which i need PO,vendor,GR date, Delivery date, created on date, recived qty, pending qty, recieved val and pending val. I need help with the source mappings.

Regards,

Mohit

[Former Member]

Hi Dear  Please check te following standard Dso I think it fulfil your requirement:- Purchase Orders Technical Name: 0PUR_O02 Use The ODS contains data on purchase orders based on the purchase order header from the InfoSource 2LIS_02_HDR, as well as aggregate information on purchase order items from the ODS 0PUR_O01. The ODS does not update deleted records. This takes place in the update start routine, where deleted records are converted to cancellations. You can identify deletion records via the characteristic 0HDR_DEL . InfoSources 2LIS_02_HDR Purchasing Data (Document Header Level) 0PUR_O01 Purchase Order Items Key Fields Key Field Description 0OI_EBELN Document number of purchasing document Data Fields Data Field Description 0DOC_ITEMS Number of document items 0PDVIEYCR Delivered early based on requested delivery date 0PDVVEYCR Value delivered early based on requested delivery date 0PDVILECR Delivered late based on requested delivery date 0PDVVLECR Value delivered late based on requested delivery date 0PDVIELCR Delivered early/late based on requested delivery date 0PDVVELCR Value delivered early/late based on requested delivery date 0PDVIOVER Overdelivery 0PDVVOVER Value overdelivery 0PDVIUNDR Underdelivery 0PDVVUNDR Value underdelivery 0PDVIEYSC Delivered early based on schedule line date 0PDVVEYSC Value delivered early based on schedule line date 0PDVILESC Delivered late based on schedule line date 0PDVVLESC Value delivered late based on schedule line date 0PDVIELSC Delivered early/late based on schedule line date 0PDLVVELSC Value delivered early/late based on schedule line date 0PICOASREQ Confirmed as requested 0PVCOASREQ Value confirmed as requested 0CREATEDON Date on which the record was added 0PUR_GROUP Purchasing group 0PURCH_ORG Purchasing organization 0VENDOR Vendor 0SUPPL_VEND Supplying vendor 0PARTNER Vendor to whom partner roles have been assigned 0SUPP_PLANT Supplying plant 0SUP_PLANT Supplying plant to which partner roles have been assigned 0SUPPLIER Goods supplier 0LOC_CURRCY Local currency 0FISCVARNT Fiscal year variant 0RECORDMODE BW delta procedure: Update mode

[Former Member]

Thanks Anindya.

I want GR date ,Delivery date and Created on
ekpo-posting date  gives delivery date

ekbe - posting date gives GR date

Is this correct ?

[anindya_bose]

PO Created Date you can get from EKKO/EKPO .   2LIS_02_ITM has those information along with PO quantity.

Good Received Date is probably BLDAT in EKBE.  BUDAT is posting date for financial document.

MENGE from EKBE is receipt quantity where MENGE from EKPO would be Order quantity.

By subtracting you can get Pending Quantity.   But you need good deal of effort in modeling the overall scenario.

Please have some consultation with functional guys.

Regards

Anindya

[Former Member]

Thanks Anindya

[anindya_bose]

EKKO, EKPO, EKBE are the main table for this requirement if you are looking for Purchase Order and Delivery

Check this DataSource Purchasing Data (Item Level) - Procurement - SAP Library

Regards

Anindya

[Former Member]

Hi Jyothi,

Thanks for replying
But i am unable for find GR date and Delivery date in 0IC_C03.

[Former Member]

Hi,

you can get those from 0PUR_C01

try to create a multiprovider using 0PUR_C01 and 0ic_c03 and see

[Former Member]

Hi,

you can check these field in 0ic_c03 cube