Skip to Content
avatar image
Former Member

Delivery date and GR date

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Apr 07, 2016 at 02:58 PM

    Hi,

    you can check these field in 0ic_c03 cube

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 07, 2016 at 03:03 PM

    Hi Jyothi,

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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2016 at 03:05 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 07, 2016 at 03:12 PM

    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 ?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 08, 2016 at 09:41 AM

    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

    Add comment
    10|10000 characters needed characters exceeded