SAP table TPK03 (Key for Controlling Control Cycle; Stock Transfer)

SAP table TPK03 has 3 primary key fields being MANDT,WERKS,PKSTU.

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
PKSTU Control Cycle Replenishment Strategy for Stock Transfer CHAR 4 0 PKSTU
PKSAU Control Type CHAR 1 0 PKSAU
1 Stock transfer with reservation
2 Direct stock transfer
3 Stock transfer with reservation / MRP
4 Direct transfer posting / MRP
5 Container control w/o res./stck trnsfr/ MRP
6 Transfer reqmts from a storage location controlled by WM
7 Delivery from an EWM-Controlled Storage Location
8 Stock Transfer with Warehouse Task
BWART Movement type (inventory management) CHAR 3 0 T156 BWART
AUSSP Signal Locking Time in Minutes NUMC 3 0 AUSSP
PKFRM Form for printing a kanban (card) CHAR 16 0 PKFRM
BWARK Follow-on mvmt type for transfer posting from consi. stock CHAR 3 0 T156 BWARK
RULES Stock Determination Rule CHAR 4 0 T434R BF_RULES
KALSM Search Procedure for Batch Determination CHAR 6 0 T683 KALSMA_CH
PKWZW Cross-Plant kanban CHAR 1 0 PKWZW
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
PKDIRTA Automatic TO Creation Immediately after TR Generation CHAR 1 0 PKDIRTA
PKKZDIF Difference Indicators CHAR 1 0 T336 PKKZDIF
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
UTTRM Exact-to-the-Min. Forw. Scheduling f. Kanban Summ. JIT Calls CHAR 1 0 UTTRM
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
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

TPK03 foreign key relationships

Table Field Check Table Check Field
0 TPK03 BWACC T156 Movement Type MANDT
0 TPK03 BWACC T156 Movement Type BWART
1 TPK03 BWARK T156 Movement Type MANDT
1 TPK03 BWARK T156 Movement Type BWART
0 TPK03 BWART T156 Movement Type MANDT
0 TPK03 BWART T156 Movement Type BWART
1 TPK03 DRUFB TFDIR Function Module FUNCNAME
0 TPK03 KALSM T683 Pricing procedures KAPPL
0 TPK03 KALSM T683 Pricing procedures KALSM
1 TPK03 PKKZDIF T336 Difference Indicators MANDT
1 TPK03 PKKZDIF T336 Difference Indicators LGNUM
0 TPK03 RKDRUFB TFDIR Function Module FUNCNAME
1 TPK03 RULES T434R Stock determination rule MANDT
0 TPK03 WERKS T001W Plants/Branches WERKS