| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PKNUM | Control cycle number | nvarchar | 7 | 0 | | | | Allow NULL? |
| 3 | KCEDT | Creation date of the change proposal | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | NEXDT | Date of the next change of a kanban control cycle | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | NEXAZ | Number of kanbans for the next change of the control cylce | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | NEXMG | Quantity per Kanban for Next Change of a Control Cycle | decimal | 13 | 3 | | | | |
| 7 | NEXTRI | Next Trigger Point of a Control Cycle | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | KCVDT | Start of evaluation period for kanban calculation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | KCBDT | End of evaluation period for kanban calculation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | PCMAA | Maximum number of kanbans in the evaluation period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | PCMAM | Maximum kanban quantity in the period of examination | decimal | 13 | 3 | | | | |
| 12 | PCMIA | Minimum number of kanbans in the period of examination | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | PCMIM | Minimum quantity per kanban in period of evaluation | decimal | 13 | 3 | | | | |
| 14 | PCMAA_RFT | Number of Kanbans Due to Refill Time | decimal | 5 | 2 | | | | |
| 15 | PCMAM_RFT | Kanban Quantity Due to Refill Time | decimal | 13 | 3 | | | | |
| 16 | PCMAA_WT | Number of Kanbans Due to Wait Time | decimal | 5 | 2 | | | | |
| 17 | PCMAM_WT | Kanban Quantity Due to Wait Time | decimal | 13 | 3 | | | | |
| 18 | PCMAA_ITT | Number of Kanbans Due to Transportation Time | decimal | 5 | 2 | | | | |
| 19 | PCMAM_ITT | Kanban Quantity Due to Transportation Time | decimal | 13 | 3 | | | | |
| 20 | PCMAA_PIT | Number of Kanbans Due to Pull Interval | decimal | 5 | 2 | | | | |
| 21 | PCMAM_PIT | Kanban Quantity Due to Pull Interval | decimal | 13 | 3 | | | | |
| 22 | PCMAA_CALBUF | Number of Kanbans Due to Calendar Buffer | decimal | 5 | 2 | | | | |
| 23 | PCMAM_CALBUF | Kanban Quantity Due to Calendar Buffer | decimal | 13 | 3 | | | | |
| 24 | PCMAA_VOLAT | Number of Kanbans Due to Requirement Fluctuations | decimal | 5 | 2 | | | | |
| 25 | PCMAM_VOLAT | Kanban Quantity Due to Requirement Fluctuations | decimal | 13 | 3 | | | | |
| 26 | PCMAA_DMBUF | Number of Kanbans Due to Requirement Buffer | decimal | 5 | 2 | | | | |
| 27 | PCMAM_DMBUF | Kanban Quantity Due to Requirement Buffer | decimal | 13 | 3 | | | | |
| 28 | PCMAA_SUPBUF | Number of Kanbans Due to Supply Source Buffer | decimal | 5 | 2 | | | | |
| 29 | PCMAM_SUPBUF | Kanban Quantity Due to Supply Source Buffer | decimal | 13 | 3 | | | | |
| 30 | PCMAA_NOPARA | Number of Kanbans Due to Replenishment Lead Time | decimal | 5 | 2 | | | | |
| 31 | PCMAM_NOPARA | Kanban Quantity Due to Replenishment Lead Time | decimal | 13 | 3 | | | | |
| 32 | PCMAA_SFC | Number of Kanbans Due to Safety Factor | decimal | 5 | 2 | | | | |
| 33 | PCMAM_SFC | Kanban Quantity Due to Safety Factor | decimal | 13 | 3 | | | | |
| 34 | PCMAA_CAPABUF | Number of Kanbans Due to Capacity Buffer | decimal | 5 | 2 | | | | |
| 35 | PCMAM_CAPABUF | Kanban Quantity Due to Capacity Buffer | decimal | 13 | 3 | | | | |
| 36 | CAPA_WRKCT | Work Center for Consideration of Capacity | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | TRIGGR | Trigger Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 38 | CAPA_UTL_T | Kanban Calculation: Capacity Utilization (Total) | decimal | 5 | 2 | | | | |
| 39 | CAPA_UTL_P | Kanban Calculation: Capacity Utilization (Production) | decimal | 5 | 2 | | | | |
| 40 | CAPA_UTL_S | Kanban Calculation: Capacity Utilization (Setup) | decimal | 5 | 2 | | | | |
| 41 | KIGDAYS | Number of Days Without Requirements to Be Ignored | decimal | 3 | 0 | | | | |
| 42 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | | | Allow NULL? |
| 43 | PCMAA_EXIT | Number of Kanbans Through User Exit | decimal | 5 | 2 | | | | |
| 44 | PCMAM_EXIT | Kanban Quantity Through User Exit | decimal | 13 | 3 | | | | |
