Skip to Content
0
Nov 09, 2012 at 01:51 PM

Opinon on this business requirment

38 Views

Hi experts,

Wha'ts your opinion on this business requirement:

Compsumptions: Combination of tables MKPF and MSEG

- If consumption is done for a Production Order (MSEG-AUFNR) --> go to CAUFV with AUFNR = MSEG-AUFNR and retrieve CAUFV-STLBEZ (material manufactured) --> go to MARA with MATNR = CAUFV-STLBEZ and retrieve MARA-EXTWG (external material group, program)

- If consumption is done for sales order (MSEG-KDAUF) --> go to VBAP with VBAP-VBELN = MSEG-KDAUF and VBAP-POSNR = MSEG-KDPOS and retrieve VBAP-ZPROG (program)

- If consumption is done for WBS (MSEG-PS_PSP_PNR) --> go to PRPS with PSPNR = MSEG-PS_PSP_PNR and retrieve PRPS-USR02

What's the more efficient option:

Looking for a standard extractor (I don't think it exist)

Building custom extractors on all concerned tables and doing the different treatments in BI (transformations level)

May be a better option?

Thanks for your ideas.

Amine