TPKBP (Kanban calculation profile) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TPKBP to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||||||
|
KCPRF
Kanban Calculation Profile
|
KCPRF |
CHAR
|
4 | 0 | ||||||||||||||
|
KCART
Ind.: Whether and How a Kanban Control Cycle is Calculated
|
KCART |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
KCSAF
Safety Factor for Kanban Calculation
|
KCSAF |
DEC
|
5 | 3 | ||||||||||||||
|
KCCON
Constant for Kanban Calculation
|
KCCON |
INT1
|
3 | 0 | ||||||||||||||
|
KCGLA
Smoothing Type for Requirements for Kanban Calculation
|
KCGLA |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
VERTI
MRP Distribution Key
|
SA_VERTL | T437V |
CHAR
|
4 | 0 | |||||||||||||
|
TSTRID
Time stream: External ID
|
TSTRID | TTSTR |
CHAR
|
10 | 0 | |||||||||||||
|
SCHGRUP
Grouping for Shift Definitions and Shift Sequences
|
SCHGRUP | TC39A |
CHAR
|
2 | 0 | |||||||||||||
|
SPROG
Key for the shift sequence
|
SCHPROG | TC38A |
CHAR
|
4 | 0 | |||||||||||||
|
FABKL
Factory calendar key
|
FABKL | TFACD |
CHAR
|
2 | 0 | |||||||||||||
|
KWBZD
Replenishment Lead Time in Workdays
|
KWBZD |
DEC
|
3 | 0 | ||||||||||||||
|
KWBZM
Replenishment Lead Time in Hours/Minutes
|
KWBZM |
DEC
|
11 | 0 | ||||||||||||||
|
SCHGRUPV
Grouping for Shift Definition and Sequences (Consumer)
|
SCHGRUPV | TC39A |
CHAR
|
2 | 0 | |||||||||||||
|
SPROGV
Key for Shift Sequence (Consumer)
|
SCHPROGV | TC38A |
CHAR
|
4 | 0 | |||||||||||||
|
FABKLV
Key for Factory Calendar (Consumer)
|
FABKLV | TFACD |
CHAR
|
2 | 0 | |||||||||||||
|
PINTVD
Pull Interval in Workdays
|
PINTVD |
DEC
|
3 | 0 | ||||||||||||||
|
PINTVM
Pull Interval in Hours and Minutes
|
PINTVM |
DEC
|
11 | 0 | ||||||||||||||
|
KDMBUF
Requirement Buffer in Percent
|
KDMBUF |
DEC
|
3 | 0 | ||||||||||||||
|
KSPBUF
Supply Source Buffer in Percent
|
KSPBUF |
DEC
|
3 | 0 | ||||||||||||||
|
KDMVOL
Take Requirement Fluctuations into Account
|
KDMVOL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TSTRIDV
Time stream: External ID
|
TSTRID | TTSTR |
CHAR
|
10 | 0 | |||||||||||||
|
MRPPP
PPC planning calendar
|
MRPPP | T439G |
CHAR
|
3 | 0 | |||||||||||||
|
ABFTB
Consider Nonworking Days
|
ABFTB |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TPKBP | FABKL | TPKBP | FABKL |
TFACD
Factory calendar definition
|
IDENT |
| TPKBP | FABKLV | TPKBP | FABKLV |
TFACD
Factory calendar definition
|
IDENT |
| TPKBP | MANDT | TPKBP | MANDT |
T000
Clients
|
MANDT |
| TPKBP | MRPPP | TPKBP | MANDT |
T439G
PPplanning periods: header table
|
MANDT |
| TPKBP | MRPPP | TPKBP | WERKS |
T439G
PPplanning periods: header table
|
WERKS |
| TPKBP | MRPPP | TPKBP | MRPPP |
T439G
PPplanning periods: header table
|
MRPPP |
| TPKBP | SCHGRUP | TPKBP | MANDT |
TC39A
Grouping shift definitions and shift sequences
|
MANDT |
| TPKBP | SCHGRUP | TPKBP | SCHGRUP |
TC39A
Grouping shift definitions and shift sequences
|
SCHGRUP |
| TPKBP | SCHGRUPV | TPKBP | MANDT |
TC39A
Grouping shift definitions and shift sequences
|
MANDT |
| TPKBP | SCHGRUPV | TPKBP | SCHGRUPV |
TC39A
Grouping shift definitions and shift sequences
|
SCHGRUP |
| TPKBP | SPROG | TPKBP | SPROG |
TC38A
Shift sequence
|
SPROG |
| TPKBP | SPROG | * |
TC38A
Shift sequence
|
SCHNR | |
| TPKBP | SPROG | TPKBP | MANDT |
TC38A
Shift sequence
|
MANDT |
| TPKBP | SPROG | TPKBP | SCHGRUP |
TC38A
Shift sequence
|
SCHGRUP |
| TPKBP | SPROGV | * |
TC38A
Shift sequence
|
SCHNR | |
| TPKBP | SPROGV | TPKBP | MANDT |
TC38A
Shift sequence
|
MANDT |
| TPKBP | SPROGV | TPKBP | SCHGRUPV |
TC38A
Shift sequence
|
SCHGRUP |
| TPKBP | SPROGV | TPKBP | SPROGV |
TC38A
Shift sequence
|
SPROG |
| TPKBP | TSTRID | TPKBP | MANDT |
TTSTR
Time stream: Administration table
|
MANDT |
| TPKBP | TSTRID | 'TS' |
TTSTR
Time stream: Administration table
|
TSTRTYPE | |
| TPKBP | TSTRID | TPKBP | TSTRID |
TTSTR
Time stream: Administration table
|
TSTREAMID |
| TPKBP | TSTRID | TPKBP | FABKL |
TTSTR
Time stream: Administration table
|
CALENDARID |
| TPKBP | TSTRIDV | TPKBP | MANDT |
TTSTR
Time stream: Administration table
|
MANDT |
| TPKBP | TSTRIDV | 'TS' |
TTSTR
Time stream: Administration table
|
TSTRTYPE | |
| TPKBP | TSTRIDV | TPKBP | TSTRIDV |
TTSTR
Time stream: Administration table
|
TSTREAMID |
| TPKBP | TSTRIDV | TPKBP | FABKLV |
TTSTR
Time stream: Administration table
|
CALENDARID |
| TPKBP | VERTI | TPKBP | MANDT |
T437V
Distribution key in MRP
|
MANDT |
| TPKBP | VERTI | TPKBP | WERKS |
T437V
Distribution key in MRP
|
WERKS |
| TPKBP | VERTI | TPKBP | VERTI |
T437V
Distribution key in MRP
|
VERTL |
| TPKBP | WERKS | TPKBP | MANDT |
T001W
Plants/Branches
|
MANDT |
| TPKBP | WERKS | TPKBP | WERKS |
T001W
Plants/Branches
|
WERKS |