SAP Table S029
KANBAN
S029 (KANBAN) 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 S029 to other SAP tables.
S029 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | 0 | |||
| VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | 0 | |||
| SPMON | Period to analyze - month | SPMON | NUMC | 6 | 0 | |||
| SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | 0 | |||
| SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | 0 | |||
| SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | 0 | |||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| PRVBE | Production Supply Area | PRVBE | PVBE | CHAR | 10 | 0 | ||
| LGORT | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| RGVRV | Person responsible for one or more supply areas | RGVER | T024D | CHAR | 3 | 0 | ||
| PERIV | Fiscal Year Variant | PERIV | T009 | CHAR | 2 | 0 | ||
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | 0 | |||
| BASME | Base Unit of Measure | MEINS | UNIT | 3 | 0 | |||
| AZBFF | Number of external replenishment operations | AFBFF | INT4 | 10 | 0 | |||
| AZ1N2 | Number of signals from status 1 to 2 | AZ1N2 | INT4 | 10 | 0 | |||
| AZBFE | Number of in-house production operations | AZBFE | INT4 | 10 | 0 | |||
| AZFEH | Number of errors in container processing | AZFEH | INT4 | 10 | 0 | |||
| AZLIG | Number of wait operations, status 5 to 1 or 2 | AZLIG | INT4 | 10 | 0 | |||
| AZ4N5 | Number of transfer operations, status 4 to 5 | AZ4N5 | INT4 | 10 | 0 | |||
| AZBFU | Number of replenishment operations for stock transfer | AZBFU | INT4 | 10 | 0 | |||
| AZ2N4 | Number of refill operations: status 2 to 4 | AZ2N4 | INT4 | 10 | 0 | |||
| AZWIB | Number of replenishment operations from status 2 to 5 | AZWIB | INT4 | 10 | 0 | |||
| AZWB0 | Number of replenishment operations on the same day | AZWB0 | INT4 | 10 | 0 | |||
| BEHAZ | Number of Kanban Containers | BEHAZ | NUMC | 3 | 0 | |||
| BEHMG | Kanban Quantity | BEHMG | QUAN | 13 | 3 | |||
| D1N2Z | Total trigger times from status 1 to 2 | D1N2Z | DEC | 9 | 2 | |||
| DFEHZ | Sum of the times in error status 9 | DFEHZ | DEC | 9 | 2 | |||
| SMIST | Total container quantity; actual | SMIST | QUAN | 15 | 3 | |||
| DLIGZ | Sum of the wait times from status 5 to 1 or 2 | DLIGZ | DEC | 9 | 2 | |||
| SMSOL | Total container quantity; target | SMSOL | QUAN | 15 | 3 | |||
| D4N5Z | Total of the times from status 4 to 5 | D4N5Z | DEC | 9 | 2 | |||
| D2N4Z | Sum of the refill times from status 2 to 4 | D2N4Z | DEC | 9 | 2 | |||
| DWIBZ | Sum of the total replenishment lead time from status 2 to 5 | DWIBZ | DEC | 9 | 2 | |||
S029 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| S029 | LGORT | S029 | MANDT | T001L | Storage Locations | MANDT |
| S029 | LGORT | S029 | WERKS | T001L | Storage Locations | WERKS |
| S029 | LGORT | S029 | LGORT | T001L | Storage Locations | LGORT |
| S029 | MANDT | S029 | MANDT | T000 | Clients | MANDT |
| S029 | MATNR | S029 | MANDT | MARA | General Material Data | MANDT |
| S029 | MATNR | S029 | MATNR | MARA | General Material Data | MATNR |
| S029 | PERIV | S029 | MANDT | T009 | Fiscal Year Variants | MANDT |
| S029 | PERIV | S029 | PERIV | T009 | Fiscal Year Variants | PERIV |
| S029 | PRVBE | S029 | PRVBE | PVBE | Production Supply Area | PRVBE |
| S029 | PRVBE | S029 | MANDT | PVBE | Production Supply Area | MANDT |
| S029 | PRVBE | S029 | WERKS | PVBE | Production Supply Area | WERKS |
| S029 | RGVRV | S029 | WERKS | T024D | MRP controllers | WERKS |
| S029 | RGVRV | S029 | RGVRV | T024D | MRP controllers | DISPO |
| S029 | RGVRV | S029 | MANDT | T024D | MRP controllers | MANDT |
| S029 | WERKS | S029 | MANDT | T001W | Plants/Branches | MANDT |
| S029 | WERKS | S029 | WERKS | T001W | Plants/Branches | WERKS |
