ROCANCEL and Purchasing

[Former Member]

Greetings Gurus,

I am trying to bring 2LIS_02_SCL into an ODS. In my unit testing I am seeing the value of ROCANCEL = "R" when I complete a delivery. I do no wish this behavior. I need to report on history.

In looking at OSS Note 578471, I see where SAP says "A position is considered statistical relevant when it has a purchasing order history (goods receipt, invoices, etc.), and/or has the final delivery flag set, and/or has the final invoice flag set."

I wish to see "purchase order history" and want ROCANCEL = " ". Is this something that is set in R/3 config?

Kind Regards,

Alex

[Former Member]

Hi Alex,

I am not sure that you can handle this in R3. But you may write a start routine, to eliminate records with recordmode 'R'.

(in 7.0 , DELETE SOURCE_PACKAGE where ... = 'R'.

in 3.5 delete data_package where ... ='R' or something like that)

This would technically solve your problem but I am not sure about the modelling and process view. make a good test.

Hope this helps.

Derya

[Former Member]

Hi Alex,

Did you get any solution for your problem

Regards

[Former Member]

Hil Alex,

I think that the field ROCANCEL "Cancelation of data record" contains 'R'(deletion of data record) when in R/3 you delete a position in the PO and an 'X' (Cancellation of data record) when a postion is completed

hope this helps

regards

Azael

[Former Member]

You want to see the table EKBE in BW, right? You will have to create your own datasource because standard there is no extractor that shows this info.

[Former Member]

Hi teamlid,

Not sure I understand, but EKBE is essentially the table, I guess. I really want to use the standard extractors for purchasing to get the data to BI, 2LIS_02_ITM and 2LIS_02_SCL. The only problem I have facing is that when delivery is complete for the purchase order, the extractor sends a "R" (reversal) in the record, which essentially removes visibility of this data once it is activated in the ODS layer and further processed to the cube.

Can I control how this is working in R/3 config is my question. Note 578471 illudes to this, but does not specify how.

Regards,

Alex

[former_member195940]

Hi Alex:

You can use std Bcnt extractors for 2LIS in your case but as you mentioned inorder to get the PO delivered values there will be some extra work.

You have to create generic datasource based on EKBE table and in BW you can populate the data from this generic DS to the 2LIS ITM ODS. you have to write some code in the update rules to populate the last item level data for each PO after delivery.

Assign Points if helpful

Thanks

Kalyan Dittakavi

[Former Member]

Hi Kalyan,

I guess I am not being clear on what my problem is. I am getting the delivered values and quantities through the standard BC via the Goods Receipts (GR) fileds and BWVORG (process key) = '002'. This is not the problem.

The issue is when I complete a delivery, that is on the schedule line (eg. PO Order QTY = 500 and then, at some future point, there is a GR = 500). SAP considers this complete, no open quantity. In this example, when looking at the records generated in RSA3 for this receipt, SAP issues a "R" in the ROCANCEL field. Because of this, I loose track of my original PO in BW.

My question is, can I somehow stop SAP from issuing the "R" in ROCANCEL?

I think this is a bug, and I've entered a message with SAP. I see inconsistent behavior with I receive other schedule lines on the same PO. Some testing issued the "R" and others issued an "X", but testing scenarios have been identical. To further complicate things, I am on the AFS industry solution, where I believe SAP invokes different logic than standard SAP.

[Former Member]

Dear Alex,

Your Infocube would have all the records I mean the status of the Orders aswell from time to time, but your ODS would Over Write them .So I think you can get a report on Infocube or the other possible solution can be build a custom ODS and Handle the data based on ROCANCEL.

Thanks,

Krish