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

Enhancing 2LIS_04_P_ARBPL with Shift

We need to report production data by shift in our BW system. It is not available in the 2LIS_04_P_ARBPL datasource. I planned to costomize this extractor to include the shift from AFRU-KAPTPROG. But the 2LIS_04_P_ARBPL extractor did not have the confirmation number & and the counter needed to get the information from AFRU. I was able to enhance the 2LIS_04_P_ARBPL data source in LBWE to include the confirmation number. But the only counter availalble there is not the one needed to get the AFRU record.

Is there a way I can get the shift or the confirmation counter in this extract?

Thanks,

Chris

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2012 at 11:56 AM

    We ended up creating a view in AFRU joining it with a few other tables and then creating a custom extroactor on that view. Worst part is we don't have the good deltas. But doing a daily run on yesterdays create date and another on yesterdays change date seems to be working fine.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 18, 2012 at 01:14 PM

    Hi,

    If you just need the confirmation counter, that I guess is the number of Confirmation that happens after the TECO at the R/3 side (I guess you can check the same at the R3 side using Report COOIS). Have you considered the option of managing the same at the reporting level.

    At the Bex level you can get the number of confirmation (Counter) for a period. This can be achieved by multiple ways, the simples one is

    - Create one formula (while creation of formula give 1 in the Formula box then go to Aggregation tab in the formula then select reference infoobject as confirmation number then save, it will work)

    1 = Numeric one constant in the formula

    go to calculation tab then select as sum or total .

    There is another way please check

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/009819ab-c96e-2910-bbb2-c85f7bdec04a

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Sorry, I wasn't clear on the counter.

      Each confirmation has a Confirmation ID (AFRU-RUECK) and the Confirmation Counter (AFRU-RMZHL). Both of these together make the unqiue key for table AFRU, which is where the shift is stored.

      My problem is that the datasource knows the Confirmation ID but not the confirmation counter. So I'm unable to retreive the shift in a user exit.

      Thanks,

      Chris

      Edited by: Chris Robertson on Jan 19, 2012 5:38 PM

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2012 at 12:20 PM

    Hi

    can any body explain about what is conformation, conformation id & Shift .

    Regards

    TP

    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.