on 07-28-2011 2:16 PM
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
Hi,
I think you can use 2LIS_02_SGR ds and the field SCLDT.
Regards,
Anil Kumar Sharma .P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
no other way than using 2lis_02_scl.
thanks for the replies.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.