Iu2019m extracting the underlying SAP tables so I can populate a Data Warehouse with Work Orders information and I have identified the following SAP tables:
u2022 Work Order tables: AFFL, AFKO, AFPO, AFRU, AFVC, AFVU, AFVV, AUFK, AUFM
u2022 Bill of Material tables: MAPL, MAST, MKAL, PLAS, PLKO, PLPO, STAS, STLO, STPO
u2022 Activity Cost tables: CKIS, CKIT, COST
u2022 Other tables of interest: CHRD, CRTX, CSLA, CSLT, CSSL, JSTO, PLMZ, RESB, S022
With the Work Order & Bill of Material tables I can identify the actual & target materials quantities & costs and I can also identify the actual & target activity / resource time spend. The problem I have is that I canu2019t detect the join between the Work Order tables and the Activity Cost tables, so there must be a table (or two) missing that creates this link.
Will you help?