SAP table TPKBP (Kanban calculation profile)

SAP table TPKBP has 3 primary key fields being MANDT,WERKS,KCPRF.

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
KCPRF Kanban Calculation Profile CHAR 4 0 KCPRF
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
KCGLA Smoothing Type for Requirements for Kanban Calculation CHAR 1 0 KCGLA
No smoothing
1 Smoothing within a week
2 Smoothing using distribution function
3 Smoothing Within a Month
4 Smoothing Within a Quarter
VERTI MRP Distribution Key CHAR 4 0 T437V SA_VERTL
TSTRID Time stream: External ID CHAR 10 0 TTSTR TSTRID
SCHGRUP Grouping for Shift Definitions and Shift Sequences CHAR 2 0 TC39A SCHGRUP
SPROG Key for the Shift Sequence CHAR 4 0 TC38A SCHPROG
FABKL Factory calendar key CHAR 2 0 TFACD FABKL
KWBZD Replenishment Lead Time in Workdays DEC 3 0 KWBZD
KWBZM Replenishment Lead Time in Hours/Minutes DEC 11 0 KWBZM
SCHGRUPV Grouping for Shift Definition and Sequences (Consumer) CHAR 2 0 TC39A SCHGRUPV
SPROGV Key for Shift Sequence (Consumer) CHAR 4 0 TC38A SCHPROGV
FABKLV Key for Factory Calendar (Consumer) CHAR 2 0 TFACD FABKLV
PINTVD Pull Interval in Workdays DEC 3 0 PINTVD
PINTVM Pull Interval in Hours and Minutes DEC 11 0 PINTVM
KDMBUF Requirement Buffer in Percent DEC 3 0 KDMBUF
KSPBUF Supply Source Buffer in Percent DEC 3 0 KSPBUF
KDMVOL Take Requirement Fluctuations into Account CHAR 1 0 KDMVOL
TSTRIDV Time stream: External ID CHAR 10 0 TTSTR TSTRID
MRPPP PPC Planning Calendar CHAR 3 0 T439G MRPPP
ABFTB Consider Nonworking Days CHAR 1 0 ABFTB
X Consider Nonworking Days

TPKBP foreign key relationships

Table Field Check Table Check Field
0 TPKBP MRPPP T439G PP Planning periods: header table MANDT
0 TPKBP MRPPP T439G PP Planning periods: header table WERKS
1 TPKBP SCHGRUP TC39A Grouping shift definitions and shift sequences MANDT
1 TPKBP SCHGRUP TC39A Grouping shift definitions and shift sequences SCHGRUP
0 TPKBP SCHGRUPV TC39A Grouping shift definitions and shift sequences MANDT
0 TPKBP SCHGRUPV TC39A Grouping shift definitions and shift sequences SCHGRUP
1 TPKBP SPROG TC38A Shift sequence MANDT
1 TPKBP SPROG TC38A Shift sequence SPROG
1 TPKBP SPROG TC38A Shift sequence SCHNR
0 TPKBP SPROGV TC38A Shift sequence MANDT
0 TPKBP SPROGV TC38A Shift sequence SPROG
0 TPKBP SPROGV TC38A Shift sequence SCHNR
1 TPKBP TSTRID TTSTR Time stream: Administration table MANDT
1 TPKBP TSTRID TTSTR Time stream: Administration table TSTRTYPE
1 TPKBP TSTRID TTSTR Time stream: Administration table TSTREAMID
1 TPKBP TSTRID TTSTR Time stream: Administration table CALENDARID
0 TPKBP TSTRIDV TTSTR Time stream: Administration table MANDT
0 TPKBP TSTRIDV TTSTR Time stream: Administration table TSTRTYPE
0 TPKBP TSTRIDV TTSTR Time stream: Administration table TSTREAMID
0 TPKBP TSTRIDV TTSTR Time stream: Administration table CALENDARID
1 TPKBP VERTI T437V Distribution key in MRP MANDT
1 TPKBP VERTI T437V Distribution key in MRP WERKS
0 TPKBP WERKS T001W Plants/Branches WERKS