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