PP-CO TABLES

[Former Member]

HELLO EXPERTS,

I AM SEARCHING TABLE RELTED TO PP-CO IN WHICH I CAN FIND TOTAL PLAN QUANTITY AND TOTAL ACTUAL QUANTITY.

I

[Former Member · Accepted solution]

Hi,

Check this Table MCKALKW.

Regards,

Padmam.

[Former Member · Accepted solution]

hi apdman,

i have found but in this table material quantity is give but not activity plan quantity and actual quantity.

[Former Member · Accepted solution]

Follow following steps:

1) Define actual quantity under each industrial order

SELECT  AUFNR  SHKZG MENGE

FROM AUFM

INTO CORRESPONDING FIELDS OF TABLE  IT_PP_FACT

WHERE BUDAT = P_BUDAT
             WERKS = P_WERKS.

LOOP AT IT_PP_FACT INTO WA_PP_FACT.

IF SHKZG = 'S'.

MENGE = (-1) * MENGE.

ENDIF.

COLLECT WA_PP_FACT TO IT_PP_FACT_ALL.

ENDLOOP.

2) We define number of scheduled need

SELECT RSNUM  FROM  AFKO

INTO CORRESPONDING FIELDS IT_RSNUM

FOR ALL ENTRIES IN IT_PP_FACT_ALL

WHERE AUFNR  =  IT_PP_FACT_ALL-AUFNR.

3) We define scheduled norms on the industrial order

SELECT AUFNR SHKZG ESMNG  FROM RESB

INTO CORRESPONDING FIELDS IT_PP_PLAN

FOR ALL ENTRIES IN IT_RSNUM

WHERE RSNUM = IT_RSNUM-RSNUM.

LOOP AT IT_PP_PLAN INTO WA_PP_PLAN.

IF SHKZG = 'S'.

ESMNG = (-1) * ESMNG.

ENDIF.

READ TABLE IT_PP_FACT INTO WA_PP_FACT

WITH KEY AUFNR = WA_PP_PLAN-AUFNR.

IF SY-SUBRC = 0.

PLAN_MENGE = ESMNG * MENGE.

COLLECT WA_PP_PLAN TO IT_PP_PLAN.

ENDIF.

ENDLOOP.

[Former Member]

hi,

the following are the pp related tables

MAST Material BOM

STKO BOM Header

STPO BOM Positions (detail)

MAPL Assignment fo Task Lists to Materials

PLKO Routing Group Header

PLSO Routing Group Sequence

PLPO Routing Group Operations

AFKO Production Order Header

AFPO Production Order Position (details)

here in afpo-pgmng - total planned order quantity

afko-gamng - total order quantity.

please reward points if useful.

regards

sandhya