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

View Entire Topic
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.