TPKBP SAP (Kanban calculation profile) Table details
Dictionary Type: Table
Description: Kanban calculation profile
Description: Kanban calculation profile
Table field list including key, data, relationships and ABAP select examples
TPKBP is a standard SAP Table which is used to store Kanban calculation profile data and is available within R/3 SAP systems depending on the version and release level.
The TPKBP table consists of various fields, each holding specific information or linking keys about Kanban calculation profile data available in SAP. These include WERKS (Plant), KCPRF (Kanban Calculation Profile), KCART (Ind.: Whether and How a Kanban Control Cycle is Calculated), KCSAF (Safety Factor for Kanban Calculation).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = TPKPT
SAP TPKBP table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| KCPRF | Kanban Calculation Profile | KCPRF | CHAR | 4 | KCPRF | ||||
| KCART | Ind.: Whether and How a Kanban Control Cycle is Calculated | KCART | CHAR | 1 | KCART | ||||
| KCSAF | Safety Factor for Kanban Calculation | KCSAF | DEC | 5(3) | DEC2_3 | ||||
| KCCON | Constant for Kanban Calculation | KCCON | INT1 | 3 | INT1 | ||||
| KCGLA | Smoothing Type for Requirements for Kanban Calculation | KCGLA | CHAR | 1 | KCGLA | ||||
| VERTI | MRP Distribution Key | SA_VERTL | CHAR | 4 | T437V | SA_VERTL | |||
| TSTRID | Time stream: External ID | TSTRID | CHAR | 10 | TTSTR | TSTRID | |||
| SCHGRUP | Grouping for Shift Definitions and Shift Sequences | SCHGRUP | CHAR | 2 | TC39A | SCHGRUP | |||
| SPROG | Key for the shift sequence | SCHPROG | CHAR | 4 | TC38A | SCHPROG | |||
| FABKL | Factory calendar key | FABKL | CHAR | 2 | TFACD | WFCID | |||
| KWBZD | Replenishment Lead Time in Workdays | KWBZD | DEC | 3 | DEC3 | ||||
| KWBZM | Replenishment Lead Time in Hours/Minutes | KWBZM | DEC | 11 | TSTRN | TSTRDURAN | |||
| SCHGRUPV | Grouping for Shift Definition and Sequences (Consumer) | SCHGRUPV | CHAR | 2 | TC39A | SCHGRUP | |||
| SPROGV | Key for Shift Sequence (Consumer) | SCHPROGV | CHAR | 4 | TC38A | SCHPROG | |||
| FABKLV | Key for Factory Calendar (Consumer) | FABKLV | CHAR | 2 | TFACD | WFCID | |||
| PINTVD | Pull Interval in Workdays | PINTVD | DEC | 3 | DEC3 | ||||
| PINTVM | Pull Interval in Hours and Minutes | PINTVM | DEC | 11 | TSTRN | TSTRDURAN | |||
| KDMBUF | Requirement Buffer in Percent | KDMBUF | DEC | 3 | DEC3 | ||||
| KSPBUF | Supply Source Buffer in Percent | KSPBUF | DEC | 3 | DEC3 | ||||
| KDMVOL | Take Requirement Fluctuations into Account | KDMVOL | CHAR | 1 | XFELD | ||||
| TSTRIDV | Time stream: External ID | TSTRID | CHAR | 10 | TTSTR | TSTRID | |||
| MRPPP | PPC planning calendar | MRPPP | CHAR | 3 | T439G | MRPPP | |||
| ABFTB | Consider Nonworking Days | ABFTB | CHAR | 1 | ABFTB |
| Key field | Non-key field |
How do I retrieve data from SAP table TPKBP using ABAP code
The following ABAP code Example will allow you to do a basic selection on TPKBP to SELECT all data from the tableDATA: WA_TPKBP TYPE TPKBP.
SELECT SINGLE *
FROM TPKBP
INTO CORRESPONDING FIELDS OF WA_TPKBP
WHERE...
How to access SAP table TPKBP
Within an ECC or HANA version of SAP you can also view further information about TPKBP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects