SAP table PKHD (Control Cycle)

SAP table PKHD has 2 primary key fields being MANDT,PKNUM.

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
PKNUM Control Cycle CHAR 7 0 PKNUM
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
PRVBE Production Supply Area CHAR 10 0 PVBE PRVBE
BEHAZ Number of Kanban Containers NUMC 3 0 BEHAZ
BEHMG Container Quantity QUAN 13 3 BEHMG
VERID Production Version CHAR 4 0 MKAL VERID
SIGAZ Maximum Number of Empty Kanban Containers NUMC 3 0 SIGAZ
RGVER Person Responsible for Supply Source CHAR 3 0 T024D QUVER
PKOSA Cost Collector for Production Process CHAR 12 0 AUFK PKOSA_D
PKSTE Control Cycle Replenishment Strategy for In-House Production CHAR 4 0 TPK01 PKSTE
BERKZ Material Staging Indicator for Production Supply CHAR 1 0 BERKZ
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 T300 LGNUM
LGTYP Storage Type CHAR 3 0 T301 LGTYP
LGPLA Storage Bin CHAR 10 0 LAGP LGPLA
NKDYN Indicator: dynamic destination bin CHAR 1 0 T333_NKDYN
PKSTF Replenishment Strategy of Control Cycle - Ext. Procurement CHAR 4 0 TPK02 PKSTF
PKSTU Control Cycle Replenishment Strategy for Stock Transfer CHAR 4 0 TPK03 PKSTU
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EBELN Agreement Number CHAR 10 0 EKKO EVRTN
EBELP Agreement Item NUMC 5 0 EKPO EVRTP
ANSWB Replenishment Controlled Independently By Supply Source CHAR 1 0 ANSWB
PKBHT Container Material CHAR 40 0 MARA PKBHT
QUFKT Separate GR If Status Changed to Full CHAR 1 0 QUFKT
UMLGO Storage location CHAR 4 0 T001L LGORT_D
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
RKSTA Control Cycle Category CHAR 1 0 RKSTAT
KOSTL Cost Center CHAR 10 0 KOSTL
VBPRN Spool Output Device CHAR 4 0 SYPDEST
VBQUE Print Queue CHAR 32 0 APOC_PRINT_QUEUE
CC_PRINT_QUEUE Print Queue CHAR 32 0 APOC_PRINT_QUEUE
PKDRS Kanban Card Print Control CHAR 1 0 PKDRS
0 No printing
1 print at replenishment
2 print at goods receipt
PKUMW Issuing Plant in Kanban Processing CHAR 4 0 T001W PKUMW
PKADR Kanban Delivery Address CHAR 10 0 PKADR
PKSFG Status Sequence Kanban CHAR 4 0 TPKSF PKSFG
PKLOG Logic for Setting Kanban to Empty CHAR 1 0 PKLOG
Normal (at status "empty")
1 At status "in use"
2 At status "wait"
3 At trigger quantity
ALSMG Kanban Trigger Quantity QUAN 13 3 ALSMG
ABLAD Storing Position CHAR 25 0 STLPL
KCART Ind.: Whether and How a Kanban Control Cycle is Calculated CHAR 1 0 KCART
No calculation
1 Calculation of the number of kanbans
2 Calculation of the quantity per kanban
KCSAF Safety Factor for Kanban Calculation DEC 5 3 KCSAF
KCCON Constant for Kanban Calculation INT1 3 0 KCCON
PKRMG Rounding Quantity QUAN 13 3 PKRMG
PKFMG Fixed Kanban Quantity QUAN 13 3 PKFMG
KCPRF Kanban Calculation Profile CHAR 4 0 TPKBP KCPRF
KWBZD Replenishment Lead Time in Workdays DEC 3 0 KWBZD
KWBZM Replenishment Lead Time in Hours/Minutes DEC 11 0 KWBZM
VBELN SD Scheduling Agreement (Sales Doc.) in Kanban Processing CHAR 10 0 VBELN_PK
VBELP SD Scheduling Agreement Item in Kanban Processing NUMC 6 0 VBELP_PK
QUPVB Source Production Supply Area for Kanban Stock Transfers CHAR 10 0 QUPVB
PABPRF JIT Call Profile CHAR 4 0 CPABPRF PABPRF
PACKV Unique internal packing object number CHAR 22 0 PL_PACKNR
ANZLT Number of Load Carriers NUMC 3 0 ANZLT
RKFORM Card for Printing Control Cycle Data CHAR 16 0 RKFORM
KBFORM Form Template CHAR 30 0 APOC_FORM_TEMPLATE_ID
CC_PRINT_FORM Form Template CHAR 30 0 APOC_FORM_TEMPLATE_ID
ZPUNKT Reporting Point CHAR 4 0 SA_ZPUNKT
LCM_STATUS Lifecycle Status of Control Cycle CHAR 1 0 LCM_STATUS
1 In Preparation
2 Ready for Release
3 Released
4 Locked
CRE_DATE Creation Date of Control Cycle DATS 8 0 CRE_DATE
RLS_DATE Release Date for Control Cycle DATS 8 0 RLS_DATE
RELEASE_TIME Release Time for Control Cycle TIMS 6 0 RELEASE_TIME
OBS_DATE Control Cycle Lock Date DATS 8 0 OBS_DATE
LOCK_TIME Control Cycle Lock Time TIMS 6 0 LOCK_TIME
LASTCHANGE_DATETIME Last Change Timestamp DEC 21 7 PK_LASTCHANGE_DATETIME
LASTCHANGE_USER ID of the user that performed the last changes CHAR 12 0 PK_LASTCHANGE_USER
PINTVD Pull Interval in Workdays DEC 3 0 PINTVD
JIT_ACTION_CONTROL Action Control CHAR 10 0 NJIT_ACT_CNTRL
PARTIAL_GR_ALLOWED_IND Indicator that states if partial goods receipt is allowed CHAR 1 0 PK_PARTIAL_GR_ALLOWED_IND
MAX_NUMBER_OPEN_CALLS Maximum Number of Open Calls INT4 10 0 PK_MAX_NUMBER_OPEN_CALLS
REPL_QTY_LOWER_TOLERANCE_LVL Lower tolerance lvl betw. requested qty and replenished qty DEC 5 2 PK_RPL_QTY_LOWER_TOLERANCE_LVL
SUPL_QTY_UPPER_TOLERANCE_LVL Upper tolerance lvl betw. requested qty and supplied qty DEC 5 2 PK_SPL_QTY_UPPER_TOLERANCE_LVL
SUPL_QTY_LOWER_TOLERANCE_LVL Lower tolerance lvl betw. requested qty and supplied qty DEC 5 2 PK_SPL_QTY_LOWER_TOLERANCE_LVL
JIT_STCK_TRANSFER_REPL_STRAT Just-In-Time replenishment strategy for stock transfer CHAR 4 0 NJIT_STCK_TRANSFER_REPL_STRAT
JIT_EXT_PROC_REPL_STRAT Just-In-Time replenishment strategy for external procurement CHAR 4 0 NJIT_EXT_PROC_REPL_STRAT
COMMUNICATION_GROUP Communication Group CHAR 10 0 NJIT_COMMUNICATION_GROUP
OFFSET_FROM_START_OF_PRODN Offset from Start of Production DEC 11 0 PK_OFFSET_FROM_START_OF_PRODN
DUMMY_NJIT_CCYC_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
DUMMY_KANBAN_CCYC_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
PINTVM Pull Interval in Hours and Minutes DEC 11 0 PINTVM
KNFZD Refill Time in Days DEC 5 2 KNFZD
KNFZM Refill Time in Hours/Minutes DEC 11 0 KNFZM
KWTZD Wait Time in Days DEC 5 2 KWTZD
KWTZM Wait Time in Hours/Minutes DEC 11 0 KWTZM
KITZD Transportation Time in Days DEC 5 2 KITZD
KITZM Transportation Time in Hours/Minutes DEC 11 0 KITZM
KDMBUF Requirement Buffer in Percent DEC 3 0 KDMBUF
KSPBUF Supply Source Buffer in Percent DEC 3 0 KSPBUF
NTREL Number of Kanbans Flagged for Unlocking NUMC 3 0 NTREL
TRIGAZ Trigger Point for Waiting Kanbans NUMC 3 0 TRIGAZ
TRIGGR Trigger Group CHAR 10 0 TRIGGR
CAPA_WRKCT Work Center for Consideration of Capacity CHAR 8 0 PK_CAPA_WRKCT
NLPLA Destination Storage Bin CHAR 18 0 /SCWM/LTAP_NLPLA
VLPLA Source Storage Bin CHAR 18 0 /SCWM/LTAP_VLPLA
PRCTY Warehouse Process Type CHAR 4 0 /SCWM/DE_PROCTY
FAZUS Combine Production Order CHAR 1 0 FAZUS
SAFETY_TIME_IN_DAYS Safety Time in Days DEC 5 2 PK_SAFETY_TIME_IN_DAYS
SAFETY_TIME_IN_MINUTES Safety Time in Minutes DEC 8 0 PK_SAFETY_TIME_IN_MINUTES
PLNG_PROCEDURE Planning Procedure for Replenishment CHAR 1 0 PK_PLNG_PROCEDURE
0 Not Relevant for Planning
1 Demand-Driven Planning
2 Consumption-Based Planning
SUMRST2 Replenishment Strategy External Procurement for SumJC CHAR 4 0 TSUM02 SUMRST2
SUMRST3 Replenishment Strategy Stock Transfer for SumJC CHAR 4 0 TSUM03 SUMRST3
PLNG_HORIZON Planning Horizon for Automatic Supply-to-Production DEC 11 0 S2L_PLNG_HORIZON
MIN_STOCK Minimum Stock for Automatic Supply-to-Production QUAN 15 3 S2L_MIN_STOCK
LOT_SIZING_PROC Lot-Sizing Procedure for Automatic Supply-to-Production CHAR 1 0 S2L_LOT_SIZING_PROC
1 One Lot
2 Lot-for-lot Order Quantity
SCHEDULING_TYPE Scheduling Type for Automatic Supply-to-Production CHAR 1 0 S2L_SCHEDULING_TYPE
1 Immediate Requirement
2 First Material Shortage Date
SEQRST2 Replenishment Strategy External Procurement SeqJC CHAR 4 0 TSEQ02 SEQRST2
JITSCPRF JIT Scheduling Profile CHAR 4 0 TSUMSCP JITSCPRF
JITOTOL JIT Outbound: Name of the Tolerance Profile CHAR 4 0 CJITO_02 JITOTOL

PKHD foreign key relationships

Table Field Check Table Check Field
0 PKHD EBELN EKKO Purchasing Document Header EBELN
1 PKHD EBELP EKPO Purchasing Document Item MANDT
1 PKHD EBELP EKPO Purchasing Document Item EBELN
0 PKHD EKORG T024E Purchasing Organizations EKORG
1 PKHD JITSCPRF TSUMSCP Calculation Profile for Summarized JIT Calls MANDT
1 PKHD JITSCPRF TSUMSCP Calculation Profile for Summarized JIT Calls WERKS
0 PKHD KCPRF TPKBP Kanban calculation profile MANDT
0 PKHD KCPRF TPKBP Kanban calculation profile WERKS
0 PKHD KCPRF TPKBP Kanban calculation profile KCPRF
1 PKHD LGNUM T300 WM Warehouse Numbers MANDT
1 PKHD LGNUM T300 WM Warehouse Numbers LGNUM
0 PKHD LGPLA LAGP Storage bins MANDT
0 PKHD LGPLA LAGP Storage bins LGNUM
0 PKHD LGPLA LAGP Storage bins LGPLA
1 PKHD LGTYP T301 WM Storage Types MANDT
1 PKHD LGTYP T301 WM Storage Types LGNUM
1 PKHD LGTYP T301 WM Storage Types LGTYP
0 PKHD LIFNR LFA1 Supplier Master (General Section) MANDT
0 PKHD LIFNR LFA1 Supplier Master (General Section) LIFNR
1 PKHD MANDT T000 Clients MANDT
0 PKHD MATNR MARA General Material Data MANDT
0 PKHD MATNR MARA General Material Data MATNR
1 PKHD MEINS T006 Units of Measurement MANDT
1 PKHD MEINS T006 Units of Measurement MSEHI
0 PKHD PABPRF CPABPRF JIT call profile MANDT
1 PKHD PKBHT MARA General Material Data MANDT
1 PKHD PKBHT MARA General Material Data MATNR
0 PKHD PKOSA AUFK Order master data AUFNR
1 PKHD PKSFG TPKSF Kanban Status Sequences MANDT
1 PKHD PKSFG TPKSF Kanban Status Sequences PKSFG
0 PKHD PKSTE TPK01 Key for Controlling the Control Cycle; In-House Production MANDT
0 PKHD PKSTE TPK01 Key for Controlling the Control Cycle; In-House Production WERKS
1 PKHD PKSTF TPK02 Key for Controlling Control Cycle: External Replenishment MANDT
1 PKHD PKSTF TPK02 Key for Controlling Control Cycle: External Replenishment WERKS
0 PKHD PKSTU TPK03 Key for Controlling Control Cycle; Stock Transfer MANDT
0 PKHD PKSTU TPK03 Key for Controlling Control Cycle; Stock Transfer WERKS
1 PKHD PKUMW T001W Plants/Branches MANDT
1 PKHD PKUMW T001W Plants/Branches WERKS
0 PKHD PRVBE PVBE Production Supply Area MANDT
0 PKHD PRVBE PVBE Production Supply Area WERKS
0 PKHD PRVBE PVBE Production Supply Area PRVBE
1 PKHD RGVER T024D MRP Controllers MANDT
1 PKHD RGVER T024D MRP Controllers WERKS
1 PKHD RGVER T024D MRP Controllers DISPO
0 PKHD SEQRST2 TSEQ02 Replenishment Strategy External Procurement SeqJC MANDT
0 PKHD SEQRST2 TSEQ02 Replenishment Strategy External Procurement SeqJC WERKS
1 PKHD SUMRST2 TSUM02 Replenishment Strategy SumJC & External Procurement MANDT
1 PKHD SUMRST2 TSUM02 Replenishment Strategy SumJC & External Procurement WERKS
0 PKHD SUMRST3 TSUM03 Replenishment Strategy JIT Call Stock Transfer MANDT
0 PKHD SUMRST3 TSUM03 Replenishment Strategy JIT Call Stock Transfer WERKS
1 PKHD UMLGO T001L Storage Locations MANDT
1 PKHD UMLGO T001L Storage Locations WERKS
0 PKHD VERID MKAL Production Versions of Material WERKS
0 PKHD VERID MKAL Production Versions of Material VERID
1 PKHD WERKS T001W Plants/Branches MANDT
1 PKHD WERKS T001W Plants/Branches WERKS