| 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 | DARPROF_ID | ID of a user-spec. profile in the table for option profiles | nvarchar | 10 | 0 | CHAR | (N' ') | No | | DARPROF_ID | Allow NULL? |
| 3 | HIEVER | Cumulate capacity requirements using work center hierarchy | char | 1 | 0 | CHAR | (N' ') | No | | HIEVER | Allow NULL? |
| 4 | HIEAUF | Explode hierarchy | char | 1 | 0 | CHAR | (N' ') | No | | HIEAUF | Allow NULL? |
| 5 | KUMUL | Indicator, whether cumulated display is desired | char | 1 | 0 | CHAR | (N' ') | No | | KUMULD | Allow NULL? |
| 6 | MINBEL | Minimum load that will be displayed | decimal | 3 | 0 | DEC | ((0)) | No | | MINBELA | |
| 7 | MAXBEL | Maximum load that will be displayed | decimal | 3 | 0 | DEC | ((0)) | No | | MAXBELA | |
| 8 | RUECKDAT | Offset (in days) of dispatch date for backlog to curr. date | decimal | 5 | 0 | DEC | ((0)) | No | | RDATUM_CNT | |
| 9 | PEINHEIT | Unit in which the period duration is specified (day, week..) | char | 1 | 0 | CHAR | (N' ') | No | | DAPER | Allow NULL? |
| 10 | PDAUER | Duration of a period (units as specified in period type) | decimal | 3 | 0 | DEC | ((0)) | No | | DAPED | |
| 11 | LIBART | Requirements category (scheduled or remaining) | char | 1 | 0 | CHAR | (N' ') | No | | CY_SBART | Allow NULL? |
| 12 | ZAPER | Type of date specification | char | 1 | 0 | CHAR | (N' ') | No | | CY_ZAPER | Allow NULL? |
| 13 | LIDAVCNT | Offset (in days) of start date for lists to current date | decimal | 5 | 0 | DEC | ((0)) | No | | CY_DCNTV | |
| 14 | LIDABCNT | Offset (in days) of end date for lists to current date | decimal | 5 | 0 | DEC | ((0)) | No | | CY_DCNTB | |
| 15 | LIEINH | Unit of of measure for displaying capacity requirements | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | CY_KEINH | Allow NULL? |
| 16 | DAVAP | Distribution according to key in work center or operation | char | 1 | 0 | CHAR | (N' ') | No | | DAVAP | Allow NULL? |
| 17 | HNAME | Name of hierarchy | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CR_HNAME | Allow NULL? |
| 18 | HWERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 19 | VERTL1 | Distribution of capacity requirements (Planned/prod.order) | nvarchar | 8 | 0 | CHAR | (N' ') | No | TC29 | CR_VERTL | Allow NULL? |
| 20 | VERTLN | Distr.cap.reqmts (plant maint.,process order, network) | nvarchar | 8 | 0 | CHAR | (N' ') | No | TC29 | CR_VERTLN | Allow NULL? |
| 21 | POOLKAP | Indicator: Cumulated view of the rqmts of pooled capacity | char | 1 | 0 | CHAR | (N' ') | No | | CY_POOLKAP | Allow NULL? |
| 22 | TT_FAUFT | Indicator: Branch to production order - change or display | char | 1 | 0 | CHAR | (N' ') | No | | CY_TTFAUFT | Allow NULL? |
| 23 | TT_PAUFT | Indicator: Branch to planned order display or maintenance | char | 1 | 0 | CHAR | (N' ') | No | | CY_TTPAUFT | Allow NULL? |
| 24 | TT_ARBPL | Switch: Branch to work center - change or display | char | 1 | 0 | CHAR | (N' ') | No | | CY_TTARBPL | Allow NULL? |
| 25 | ANVER | Cumulate available capacity using work center hierarchy | char | 1 | 0 | CHAR | (N' ') | No | | CY_ANVER | Allow NULL? |
| 26 | DATEFROM | Start date for output of capacity evaluations | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CY_DATEF | Allow NULL? |
| 27 | DATETO | Finish date for output of capacity evaluations | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CY_DATET | Allow NULL? |
| 28 | RDATE_TYPE | Type of date specification | char | 1 | 0 | CHAR | (N' ') | No | | CY_RDATETY | Allow NULL? |
| 29 | RDATE | Date of backlog dispatching | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CY_RDATE | Allow NULL? |
| 30 | MRPP | PPC planning calendar | nvarchar | 3 | 0 | CHAR | (N' ') | No | T439G | MRPPP | Allow NULL? |
| 31 | UNITSOURCE | Origin of unit of measure for available cap. and cap.reqmts | char | 1 | 0 | CHAR | (N' ') | No | | CY_UNITSRC | Allow NULL? |
| 32 | PPSWERK | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
