10-05-2007 2:17 PM
Hello All,
Could any one give me the relationship between the tables STPO and PLMZ related to PP Module.
i.e. Could any one let me know how the components are assigned to which operations, routings with these tables.
Thank You in advance.
10-05-2007 2:22 PM
1.First u can start with MAPL.
input Field: MATNR - your Header Material
WERKS - your BOM plant
Outfield for Next Table. PLNTY,PLNNR,PLNAL,LOEKZ (Not equal X).
2. TABLE: PLMZ
Input Field: PLNTY,PLNNR,PLNAL,LOEKZ,WERKS ( from previous tables)
output Field : STLTY,STLNR,STLKN, PLNFL.
3. Table: PLPO
Input Field: PLNTY,PLNNR,PLNAL,LOEKZ,WERKS.
output field :VORNR,MEINH,BMSCH,
4.Table: STPO
Input Field:STLTY,STLNR,STLKN (From table PLMZ )
output field: IDNRK,POSNR,POSTP.
5.Table MAKT.
Input Field: IDNRK
output field : MAKTX.
what i have given is a flow to fetch the data. Try it with abab`rs to develop report.
i hope the above tables give most of fields which you need in ca03 (com all view).
plz reward point all of them if u found usefull.
Murali Poli
10-05-2007 2:25 PM
http://www.sapgenie.com/abap/tables_pp.htm
http://www.sap-img.com/sap-download/sap-tables.zip
Please give me reward points
Thanks
Murali Poli
10-05-2007 2:29 PM
Try to connect their relation using this
plmz-stlty = stpo-stlty
stlnr = stpo-stlnr
stlkn = stpo-stlkn
plmz-plnty = plpo-plnty
plnnr = plpo-plnty