cancel
Showing results for 
Search instead for 
Did you mean: 

Enhancing 2LIS_04_P_ARBPL with Shift

chris_robertson
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

chris_robertson
Participant
0 Kudos

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.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

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

Regards

TP

deepesh_kumar
Participant
0 Kudos

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,

chris_robertson
Participant
0 Kudos

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