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

[rahul2000]

Dear Kuldeep,

U will have to use MDPB table...it is actually a database view...u will get what u want there...just c below for more...u will get all the fields that u require

TYPES:BEGIN OF TY_AFKO , "Order header data PP orders

AUFNR TYPE AFKO-AUFNR , "Order Number

GLTRP TYPE AFKO-GLTRP , "Basic finish date

GSTRP TYPE AFKO-GSTRP , "Basic start date

DISPO TYPE AFKO-DISPO , "MRP controller for the order

PLNBEZ TYPE AFKO-PLNBEZ , "Material Number

GAMNG TYPE AFKO-GAMNG , "Total order quantity

IGMNG TYPE AFKO-IGMNG , "Yield confirmed from order confirmation

PRUEFLOS TYPE AFKO-PRUEFLOS , "Inspection Lot Number

GLTRI TYPE AFKO-GLTRI ,

END OF TY_AFKO .

TYPES:BEGIN OF TY_MDPB , "Read View of Plnnd Ind. Reqmts for MRP

MATNR TYPE MDPB-MATNR , "Material Number

WERKS TYPE MDPB-WERKS , "Plant

PLNMG TYPE MDPB-PLNMG , "Planned quantity

PDATU TYPE MDPB-PDATU , "Delivery/order finish date

CUST TYPE KNA1-NAME1 , "Name 1

KBETR TYPE KONP-KBETR , "Rate (condition amount or percentage) where no scale exists

END OF TY_MDPB .

TYPES:BEGIN OF TY_PLAF , "Planned order

PLNUM TYPE PLAF-PLNUM , "Planned order number

MATNR TYPE PLAF-MATNR , "Planning material

DISPO TYPE PLAF-DISPO , "MRP controller

GSMNG TYPE PLAF-GSMNG , "Total planned order quantity

END OF TY_PLAF .

TYPES:BEGIN OF TY_QALS , "Inspection lot record

PRUEFLOS TYPE QALS-PRUEFLOS , "Inspection Lot Number

SELMATNR TYPE QALS-SELMATNR , "Material Number

WERK TYPE QALS-WERK , "Plant

AUFNR TYPE QALS-AUFNR , "Order Number

LMENGE01 TYPE QALS-LMENGE01 , "Quantity Posted to Unrestricted-Use Stock

PASTRTERM TYPE QALS-PASTRTERM,

END OF TY_QALS .

TYPES:BEGIN OF TY_AFPO , "Order item number

AUFNR TYPE AFPO-AUFNR , "Order Number

POSNR TYPE AFPO-POSNR , "Planned order number

PLNUM TYPE AFPO-PLNUM , "Planned order number

MATNR TYPE AFPO-MATNR , "Material Number for Order

PSMNG TYPE AFPO-PSMNG , "Order item quantity

PGMNG TYPE AFPO-PGMNG , "Total planned order quantity

LTRMP TYPE AFPO-LTRMP , "Actual delivery/finish date

END OF TY_AFPO .

Reward if helpful

Edited by: Rahul Bhat on Mar 22, 2008 6:45 PM