| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | PEPRO_ID | Period profile for capacity leveling/extended evaluation | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CY_PEPRO | Allow NULL? |
| 3 | PEINHEIT | Unit in which the period duration is specified (day, week..) | char | 1 | 0 | CHAR | (N' ') | Yes | | DAPER | Allow NULL? |
| 4 | PDAUER | Duration of a period (units as specified in period type) | decimal | 3 | 0 | DEC | ((0)) | Yes | | DAPED | |
| 5 | ZEITRASTER | Period pattern key for available capacity | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TC35 | CR_ZRAST | Allow NULL? |
| 6 | KUMUL | Indicator, whether cumulated display is desired | char | 1 | 0 | CHAR | (N' ') | Yes | | KUMULD | Allow NULL? |
| 7 | DYNP_WIDTH | Indicator, width of the screen | char | 1 | 0 | CHAR | (N' ') | Yes | | CY_DYNPWID | Allow NULL? |
| 8 | AVAIL_CAP | Formula to calculate the rem.avail.cap. | char | 1 | 0 | NUMC | (N'0') | Yes | | CY_AVAICAP | Allow NULL? |
| 9 | SCHED_TIM | Dispatch time used in rescheduling | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CY_SCHETIM | Allow NULL? |
| 10 | REQ_VIEW | Reqmts to be displayed on cap.planning table (table form) | char | 1 | 0 | NUMC | (N'0') | Yes | | CY_REQVIEW | Allow NULL? |
| 11 | MRP_CAL | PPC planning calendar | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T439G | MRPPP | Allow NULL? |
| 12 | PPSWERK | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
