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

[Former Member]

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

[Former Member · Accepted solution]

Hi,

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

Regards,

Anil Kumar Sharma .P

[Former Member]

no other way than using 2lis_02_scl.

thanks for the replies.

[former_member182467]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.