Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question