Skip to Content
0
Former Member
Dec 22, 2011 at 10:17 PM

Work Order & Activity Costs

343 Views

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?