which ODS to use for 2LIS_02_SCL

[Former Member]

Hi everyone!

I'm using for my MM project ODS 0PUR_O01 and the infosource 2LIS_02_SCL.

When I looked on "SAP Library" it does not say that 0PUR_O01 is getting data from 2LIS_02_SCL -

SAP Library - Procurement

but on the other hand I saw in forums that BW people said they do use 0PUR_O01 to get data from 2LIS_02_SCL.

I would like your opinion on this dilemma.

And to which Cube this ODS goe's to??

thank you all.

[Former Member]

Hi!

I'm using 2LIS_02_SGR also in my project, I checked the fileds in 0PUR_DS03 and 0PUR_O01 but not all the files that I need in the DS exists in these two DSOs.

Is there another DSO that could be useful for me in GR?

the files that I need in the dso :

BELNR	Number of Material Document	EKBE	BELNR
BUZEI	Item in Material Document	EKBE	BUZEI
SCLQTY	Schedule Line Quantity	EKET	MENGE
GMVQTY	Goods Movement Quantity	EKBE	MENGE
OPNQTY	Open Quantity	calculated
TTLQTY	Assigned Quantity	calculated
MEINS	Base Unit of Measure	EKPO	MEINS
ROCANCEL	Cancellation of Data Record	hard-coded

EBELN	Document Number of Purchasing Document	EKET	EBELN
EBELP	Item Number of Purchasing Document	EKET	EBELP

SCLNR	Schedule line number in purchasing document
BELNR	Number of the material document used to post the goods movement
GMVPDT	Posting date of goods movement

TTLQTY

Total quantity of goods movements posted for a schedule line

hope you all cand helpme.

Regards,

ROB

[former_member186399]

Hi,

As per my knowledge there is no standard content which provides you the above details. You need to create a z dso or use the 0PUR dsos with modification by adding the required fields

regards

Gajesh

[Former Member]

Just a confirmation, DSO 0PUR_DS03 is used to get data from 2LIS_02_SCL and 2LIS_02_SGR.

Order Schedule Lines - Procurement - SAP Library

Rgds..

Shambhu

[former_member186399]

Dear Rob

Yes you are right.  By standard 0PUR_O01 is not connected to 2lis_02_scl. 0PUR_DS03 has the mapping with 2lis_02_scl datasource.

But still you can connect 0pur_o01 with 2lis_02_scl.

Regards

Gajesh