Skip to Content
avatar image
Former Member

Purchase order Delivery date based on PO doc no and PO item no

hi all

we have a requirement to bring Purchase order delivery date in to our report .

it is in EKET Table - field EINDT.

Is it possible to get this PO Delivery date in to our data source 2lis_02_itm which has PO Doc no(EBELN) and PO item.no (EBELP).

In EKET Table the primary key is based on 3 fields. PO Doc no(EBELN), PO Itm.no(EBLEP) and delivery schedule line counter (ETENR).

In EKET Table the data is like

PO.NO/PO itm no/ schline counter/delivery date

1000/10/1/1-1-2011

1000/10/2/5-1-2011

1000/20/1/2-2-2011

1000/20/2/2-2-2011

1000/20/3/5-2-2011

so on...

IF i enhance my datasource and populate the delivery date based on EBELN and EBELP we get only 1 delivery date for all the different schedule lines which is wrong.

I know there is a separate datasource for schedule line data for purchasing BUT IS IT POSSIBLE TO GET the delivery date based on the different schedules by using some ABAP CODE, SINCE in our datasource 2lis_02_itm we dont have ETENR( SCHEDULE LINE COUNTER FIELD).

if we use the standard data source (2lis_02_SCL )it is not fair to pull all that data since we only need 1 field from it.

Please suggest

Thanks & Regards.

Krishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 29, 2011 at 04:38 AM

    Hi,

    I think you can use 2LIS_02_SGR ds and the field SCLDT.

    Regards,

    Anil Kumar Sharma .P

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 28, 2011 at 02:11 PM

    Hi Krishna,

    Even though you plan to write some ABAP code or do any processing for a combination of PO document no. and Item no. you will always get multiple records with different schedule line items and it is really impossible to take the delivery date without knowing schedule line item no.

    And even when you said PO delivery date, it is actually means delivery date of any of the schedule line only. If you want to write some ABAP logic then you will have to decide like whether you want to display the First line item date or the last line item date etc. But which is again not a good idea.

    I think you can go for schedule line extractor.

    Regards,

    Durgesh.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 28, 2011 at 04:20 PM

    Hi Krishna,

    Item level is having lower granularity whereas schedule line is at higher granularity.

    1 Item can have multiple schedule lines ( 1: N ) relationship.

    Hence it is not possible to populate schedule line level character at item level, as you tend to get multiple values.

    You need to use 2LIS_02_SCL if you are particular about EINDT.

    Thanks,

    Krishnan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 29, 2011 at 02:45 AM

    Hi

    Pls check whether you can use these tables for your requirements as it has DELIVERY DATE...

    EKES

    EKKO

    EKPO

    If these are ok for your requirement, then create a GENERIC DS and extract to BI.

    hOpe this helps

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 30, 2011 at 01:54 PM

    no other way than using 2lis_02_scl.

    thanks for the replies.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      We can use 2lis_02_sgr instead of 2lis_02_scl rite ? As we will get the confirmed GR date's in 2lis_02_sgr rather than scl.....scl has only the initial dates of delivery while the PO was created....those are not fixed dates. Its the estimated dates suggested by the system.

      Thanks