Skip to Content
0

Correct way to build DSO over 2LIS_02_SCL DS

Nov 07, 2016 at 06:25 PM

209

avatar image

Hi Experts,

Need advise to build a standard DSO over 2LIS_02_SCL extractor to capture PO details with PO, GR, IR amount and quantity with delta load. As much as I understand the key fields which I should be using are EBELN Purchasing Doc., EBELP Item and ETENR Schedule Line. I am using Key figure BWGEO BW:CValLocCrcy & BWGEOO BW: CValOrdCrcy with summation aggregation to capture PO /GR/ IR value. I have created 6 KF's to capture the three values PO, GR, IR values in both the currencies against a particular PO Item using rule type formula if Transfer process BWVORG is 1 fill PO value, 2 for GR value and 3 for IR value (similar use 3 KF for quantity against PO, GR and IR).

I need to know if this is the correct way of modelling and capturing the PO information. I wish to use 2LIS_02_SGR and 2LIS_06_INV DS to get the GR and IR documents against the corresponding PO, GR, IR values. Is any start routine is required here?

Please advise if my modelling approach will bring me good results. If not, what would be the correct approach. It will be greatly appreciated as even after searching for long I couldn't get the right answer however I guess this would be a common query for many.

Regards

Ani

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Frédéric Cincet Nov 09, 2016 at 08:39 AM
0

Hi Ani,

The correct approach will probably be to have a look at the business content. There, you wil find the structure of this kind of DSO (0PUR_DS03) and the way it is filled.

You should find a part of your answers.

Regards

Frederic


capture.png (75.0 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Fredric for your answer. You are right that the correct way would be to install the BI Content DSO 0PUR_DS03 and the data flow. However there are many standard InfoObjects associated with it and along with InfoSource which I do not wish to install as I am getting few unavoidable errors.

Is there a way to check the transformation logic without installation? I cannot find any documentation which mentions if there is any start routine or field routine involved in it.

Can you help me with an example of how the data would look like when stored in std 0PUR_DS03? Through RSTRANFIELD table I can gauge that for Transformation 0FGWQUWSOGBZ65XDNQCMI7OUFF9RGUYQ only 2 KF are involved in the DSO which are 0NETPRICE & 0BO_QTY.

Regards

Aniruddha

0
Frédéric Cincet Nov 10, 2016 at 03:57 PM
0

Then you will have to read the online help...

Regards,

Frederic

Share
10 |10000 characters needed characters left characters exceeded
Gajesh Nagesh Nov 15, 2016 at 09:20 AM
0

Hi Ani,

I think your modelling concept are correct. 2lis_02 extractor work with the concept of BWVORG . There is an SAP note which clearly gives which BWVORG represents PO, GR, & IR.

You will have a challenge in bringing GR & IR numbers using 2LIS_06_INV when you have multiple GR for the same PO line item.

Regards

Gajesh

Show 1 Share
10 |10000 characters needed characters left characters exceeded

That's correct. Since we have scenarios where multiple GR / IR documents are created against a single PO item, I am finding it challenging to bring the IR document no. from 2LIS_06_INV and combine it with PO details extracted from 2LIS_02_SCL DS. The INV DS do not have schedule line. Nor does it have movement type with which I can filter only documents Invoice type (The way I am filtering Transfer process BWVORG 003 while using in SCL DS)

Any suggestions on whats key fields I should use over INV DS DSO and how can I combine to get PO Item details with corresponding GR / IR document numbers with Amount and Qty?

0