Skip to Content
author's profile photo Former Member
Former Member

ROCANCEL and Purchasing

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2006 at 05:28 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • author's profile photo Former Member
    Former Member
    Posted on Jan 24, 2007 at 08:38 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 11, 2007 at 01:15 PM

    Hi Alex,

    Did you get any solution for your problem

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 11:22 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.