SAP table TPK02 (Key for Controlling Control Cycle: External Replenishment)

SAP table TPK02 has 3 primary key fields being MANDT,WERKS,PKSTF.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
WERKS Plant CHAR 4 0 T001W WERKS_D
PKSTF Replenishment Strategy of Control Cycle - Ext. Procurement CHAR 4 0 PKSTF
PKSAF Control Type CHAR 1 0 PKSAF
1 Working with purchase orders
2 Working with scheduling agreements
3 Working with stock transport order
4 Working with stock transport scheduling agreements
5 Working via source list
6 Replenishment using containers / MRP
7 Working with summarized JIT calls
MDUEA Message transfer type for external replenishment CHAR 1 0 MDUEA
KZQUO Indicator: check quota arrangement CHAR 1 0 KZQUO
KZORB Indicator: check source list CHAR 1 0 KZORB
BWAWE Movement Type for Goods Receipt CHAR 3 0 T156 SA_BWARTWE
AUSSP Signal Locking Time in Minutes NUMC 3 0 AUSSP
PKFRM Form for printing a kanban (card) CHAR 16 0 PKFRM
BSART Order Type (Purchasing) CHAR 4 0 T161 BSART
CNSCC Post consumption of kanban material to cost center CHAR 1 0 CNSCC
1 Post withdrawal to cost center
2 Post procurement to cost center
BWACC Movement type: post consumption to cost center CHAR 3 0 T156 BWACC
UTTRM Exact-to-the-Min. Forw. Scheduling f. Kanban Summ. JIT Calls CHAR 1 0 UTTRM
DRUFB Function module for printing kanbans CHAR 30 0 TFDIR DRUFB
SDDKZ Indicator for Kanban with SD scheduling agreement CHAR 1 0 SDDKZ
1 Delivery when stat. at "full", GI when stat. at "in use"
2 Delivery when status at "in use", GI manual
RKFORM Card for Printing Control Cycle Data CHAR 16 0 RKFORM
RKDRUFB Function Module for Printing a Control Cycle CHAR 30 0 TFDIR RKDRUFB
VPACK Use of Packing Instructions in the Kanban Control Cycle CHAR 1 0 PKVPACK
KNTTP Cost Center Account Assignment Category CHAR 1 0 T163K PK_KNTTP
ALERT Indicator for Alerts in Kanban CHAR 1 0 PKALERT
KANB_FORM_PDF Name of PDF-Based Form CHAR 30 0 FORM_PDF
FORM_TYPE Form Type CHAR 1 0 FORM_TYPE
CC_FORM_PDF Name of PDF-Based Form CHAR 30 0 FORM_PDF
CC_FORM_TYPE Form Type CHAR 1 0 FORM_TYPE
CC_PRINT_FORM Form Template CHAR 30 0 APOC_FORM_TEMPLATE_ID
KBFORM Form Template CHAR 30 0 APOC_FORM_TEMPLATE_ID
POST_SYNC_EWM_IM Indicator if goods movements are posted synchronously CHAR 1 0 POST_SYNC_EWM_IM
KZAKB Scheduling According to Calculation Profile CHAR 1 0 KZAKB
AUTOGR Automatic Goods Receipt on Receipt of Shipping Notification CHAR 1 0 AUTOGR
X Automatic Goods Receipt on Receipt of Shipping Notification

TPK02 foreign key relationships

Table Field Check Table Check Field
0 TPK02 BSART T161 Purchasing Document Types MANDT
1 TPK02 BWACC T156 Movement Type MANDT
1 TPK02 BWACC T156 Movement Type BWART
0 TPK02 BWAWE T156 Movement Type MANDT
0 TPK02 BWAWE T156 Movement Type BWART
1 TPK02 DRUFB TFDIR Function Module FUNCNAME
0 TPK02 KNTTP T163K Account Assignment Categories in Purchasing Document MANDT
0 TPK02 KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
1 TPK02 RKDRUFB TFDIR Function Module FUNCNAME
0 TPK02 WERKS T001W Plants/Branches WERKS