How to Link Between PLKO and PLPO for Routine in SAP
Link between PLKO and PLPO for Routine in SAP will be explain in this post with the definition of each tables involved and a sample ABAP Code to retrieve for a Production Version the Routine.
SAP Routines Tables
Let first introduce the SAP Tables used for Production:
- PLKO:?Task list – header
- PLPO:?Task list – operation/activity
- PLMZ:?Allocation of bill of material items to operations
- PLAS:?Task list – selection of operations/activities
- PLAB:?Relationships
- PLAF:?Planned order
- PLFH:?Task list – production resources/tools
- PLFL:?Task list – sequences
- PLFT:?Process Instructions
- PLFV:?PI Characteristics/Sub-Operation Parameter Values
- PLKV:?View of planned order header data
- PLKZ:?Task list: main header
- PLMK:?Inspection plan characteristics
- PLMW:?MAPL-Dependent Charac. Specifications (Inspection Plan)
- PLPH:?CAPP: Sub-operations
- PLPB:?Long-term planning: Independent requirements versions
- PLPW:?Index of the production/delivery plant in the planned order
- PLSR:?Scheduling results
- PLST:?Status table for planned order processing
- PLZU:?Routing data for group
The next step is how to link between theses SAP main tables in SAP PP.
Main Keys fields for
The Main keys fields for are:
- PLNTY Task List Type Number (for orders from AFKO, for notifications from QMIH)
- PLNNR Group (for orders from AFKO, for notifications from QMIH)
- PLNAL Group Counter (for orders from AFKO, for notifications from QMIH)
Link between PLKO and PLPO
This section will cover the relationship between PLPO and PLKO.
The link between PLKO : Routine Header and PLPO Routine Post is done in the table PLAS.
An example of SAP Select how to retrieve PLAS ? Link between PLPO and PLKO
1 2 3 4 5 6 7 8 9 10 11 12 13 | *----------------------------------------------------* * READ PLAS *----------------------------------------------------* IF NOT lt_plko[] IS INITIAL. SELECT * FROM plas INTO TABLE lt_plas FOR ALL ENTRIES IN lt_plko WHERE plnty = lt_plko-plnty AND plnnr = lt_plko-plnnr AND plnal = lt_plko-plnal AND loekz NE 'X'. DELETE ADJACENT DUPLICATES FROM lt_plas COMPARING ALL FIELDS. ENDIF. |
An example SAP Select to retrieve the PLPO with the PLAS-link to PLKO.
1 2 3 4 5 6 7 8 9 10 11 12 | *----------------------------------------------------* * READ PLPO *----------------------------------------------------* IF NOT lt_plas[] IS INITIAL. SELECT * FROM plpo INTO TABLE lt_plpo FOR ALL ENTRIES IN lt_plas WHERE plnty = lt_plas-plnty AND plnnr = lt_plas-plnnr AND plnkn = lt_plas-plnkn AND zaehl = lt_plas-zaehl. DELETE ADJACENT DUPLICATES FROM lt_plpo COMPARING ALL FIELDS. ENDIF. |
An ABAP sample code to retrieve the different link between PLKO and PLPO using PLAS can be :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | READ TABLE lt_plko INTO ls_plko WITH KEY plnnr = IV_plnnr " Input plnty = IV_plnty " Input . IF sy-subrc = 0 . " write your ABAP Custom Logic ENDIF. " LINK BETWEEN PLKO AND PLPO -> PLAS LOOP AT lt_plas INTO ls_plas WHERE plnnr = ls_plko-plnnr AND plnty = ls_plko-plnty. READ TABLE lt_plpo INTO ls_plpo WITH KEY plnty = ls_plas-plnty plnnr = ls_plas-plnnr plnkn = ls_plas-plnkn zaehl = ls_plas-zaehl. IF sy-subrc = 0 . " CUSTOM LOGIC HERE ENDIF. ENDLOOP |
Link Between PLKO and PLMZ
PLPO is the SAP Table Routine lines and PLMZ Table stores the relationship between the Routine line and the BOM Component.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | *----------------------------------------------------* * READ PLMZ *----------------------------------------------------* IF NOT lt_plpo[] IS INITIAL. SELECT * FROM plmz INTO TABLE lt_plmz FOR ALL ENTRIES IN lt_plpo WHERE plnty = lt_plpo-plnty AND plnnr = lt_plpo-plnnr AND loekz NE 'X' AND plnkn = lt_plpo-plnkn. DELETE ADJACENT DUPLICATES FROM lt_plmz COMPARING ALL FIELDS. ENDIF. LOOP AT lt_plmz INTO ls_plmz WHERE plnnr = ls_plko-plnnr AND plnty = ls_plko-plnty. READ TABLE lt_plpo INTO ls_plpo_2 WITH KEY plnty = ls_plmz-plnty plnnr = ls_plmz-plnnr plnkn = ls_plmz-plnkn. IF SY-SUBRC = 0. ENDIF. ENDLOOP |
PLPO Table in SAP,?PLKO Table in SAP, PLPO & PLKO Link, PLOK Task List