SAP table TPK01 (Key for Controlling the Control Cycle; In-House Production)
SAP table TPK01 has 3 primary key fields being MANDT,WERKS,PKSTE.
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 | |||||||||||||||||
PKSTE | Control Cycle Replenishment Strategy for In-House Production | CHAR | 4 | 0 | PKSTE | ||||||||||||||||||
PKSAE | Control Type | CHAR | 1 | 0 | PKSAR |
|
|||||||||||||||||
AUART | Order Type | CHAR | 4 | 0 | T003O | AUFART | |||||||||||||||||
AUSSP | Signal Locking Time in Minutes | NUMC | 3 | 0 | AUSSP | ||||||||||||||||||
KZQUO | Indicator: check quota arrangement | CHAR | 1 | 0 | KZQUO | ||||||||||||||||||
BWAWE | Movement Type for Goods Receipt | CHAR | 3 | 0 | T156 | SA_BWARTWE | |||||||||||||||||
PKFRM | Form for printing a kanban (card) | CHAR | 16 | 0 | PKFRM | ||||||||||||||||||
PKWZW | Cross-Plant kanban | CHAR | 1 | 0 | PKWZW | ||||||||||||||||||
CNSCC | Post consumption of kanban material to cost center | CHAR | 1 | 0 | CNSCC |
|
|||||||||||||||||
BWACC | Movement type: post consumption to cost center | CHAR | 3 | 0 | T156 | BWACC | |||||||||||||||||
DRUFB | Function module for printing kanbans | CHAR | 30 | 0 | TFDIR | DRUFB | |||||||||||||||||
SDDKZ | Indicator for Kanban with SD scheduling agreement | CHAR | 1 | 0 | SDDKZ |
|
|||||||||||||||||
REDST | Reducing Planned Orders in Backflushing for Repetitive mfg | CHAR | 1 | 0 | PK_REDST |
|
|||||||||||||||||
REDHZ | Reduction period for planned orders | DEC | 3 | 0 | PK_REDHZ | ||||||||||||||||||
PLGEN | Planned ord. - create for amount of reversal - GR - quantity | CHAR | 1 | 0 | PK_PLGEN |
|
|||||||||||||||||
VPACK | Use of Packing Instructions in the Kanban Control Cycle | CHAR | 1 | 0 | PKVPACK | ||||||||||||||||||
RKFORM | Card for Printing Control Cycle Data | CHAR | 16 | 0 | RKFORM | ||||||||||||||||||
RKDRUFB | Function Module for Printing a Control Cycle | CHAR | 30 | 0 | TFDIR | RKDRUFB | |||||||||||||||||
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 | ||||||||||||||||||
REUSEST | Reuse Strategy for Planned Orders | CHAR | 1 | 0 | PK_REUSEST |
|
|||||||||||||||||
REUSEHZ | Reuse Horizon for Planned Orders | DEC | 3 | 0 | PK_REUSEHZ | ||||||||||||||||||
ACT_CAPA | Consideration of Capacity in Control Cycle Calculation | CHAR | 1 | 0 | PK_ACT_CAPA |
TPK01 foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 TPK01 | AUART | T003O | Order Types | AUART |
1 TPK01 | BWACC | T156 | Movement Type | MANDT |
1 TPK01 | BWACC | T156 | Movement Type | BWART |
0 TPK01 | BWAWE | T156 | Movement Type | MANDT |
0 TPK01 | BWAWE | T156 | Movement Type | BWART |
1 TPK01 | DRUFB | TFDIR | Function Module | FUNCNAME |
0 TPK01 | RKDRUFB | TFDIR | Function Module | FUNCNAME |
1 TPK01 | WERKS | T001W | Plants/Branches | WERKS |