| 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 | * | MANDT | Allow NULL? |
| 2 | OPERAND | Operand | nvarchar | 10 | 0 | CHAR | (N' ') | No | | E_OPERAND | Allow NULL? |
| 3 | SPARTE | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TESPT | SPARTE | Allow NULL? |
| 4 | OPTYP | Operand category | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TE375 | E_OPTYP | Allow NULL? |
| 5 | MASS | Unit of Measurement | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | E_MASS | Allow NULL? |
| 6 | ORGWERT | Indicator: second value is permitted | char | 1 | 0 | CHAR | (N' ') | Yes | | ORGWERT | Allow NULL? |
| 7 | TAZUORD | Indicator: allocation to a rate type is required | char | 1 | 0 | CHAR | (N' ') | Yes | | TAZUORD | Allow NULL? |
| 8 | RUNDUNG | Starting Point for Rounding | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | E_RUNDUNG | Allow NULL? |
| 9 | RUNDART | Rounding Category | char | 1 | 0 | CHAR | (N' ') | Yes | | RUNDART | Allow NULL? |
| 10 | LEISTALL | Control of which demand values are used | char | 1 | 0 | CHAR | (N' ') | Yes | | LEISTALL | Allow NULL? |
| 11 | LEISTMONAT | Control of demand validity period | char | 1 | 0 | CHAR | (N' ') | Yes | | LEISTMONAT | Allow NULL? |
| 12 | BZGART | Type of reference value | char | 1 | 0 | CHAR | (N' ') | Yes | | BZGART | Allow NULL? |
| 13 | UMZUGKZ | Control of Whether Values are Kept in Move-In/Out | char | 1 | 0 | CHAR | (N' ') | Yes | | UMZUGKZ | Allow NULL? |
| 14 | HISTSTEU | Control of historical maintainability of operand values | char | 1 | 0 | CHAR | (N' ') | Yes | | HISTSTEU | Allow NULL? |
| 15 | ABLESGRUP | MR group for controlling decimal places to be read | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TE017 | ABLESGRUP | Allow NULL? |
| 16 | GEWKEY | Weighting key for proration of operands | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TE266 | GEWKEY_PR | Allow NULL? |
| 17 | SELCONTROL | Access control for operands | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SELCONTROL | Allow NULL? |
| 18 | PEAK_NO | Number of demand peaks | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PEAK_NO | Allow NULL? |
| 19 | SEASONFLAG | Indicator: determination of demand is season-related | char | 1 | 0 | CHAR | (N' ') | Yes | | SEASONFLAG | Allow NULL? |
| 20 | FRAN_TYPE | Franchise Fee Category | char | 1 | 0 | CHAR | (N' ') | Yes | | FRAN_TYPE | Allow NULL? |
| 21 | REG_OPERAND | Indicator: operand is a register operand | char | 1 | 0 | CHAR | (N' ') | Yes | | REG_OPERAND | Allow NULL? |
| 22 | DEMAND_AS_IS | Indicator: bill demand as it is in the facts (unchanged) | char | 1 | 0 | CHAR | (N' ') | Yes | | DEMAND_AS_IS | Allow NULL? |
| 23 | ALLHISTORY | Indicator: complete history is permissible | char | 1 | 0 | CHAR | (N' ') | Yes | | ALLHISTORY | Allow NULL? |
| 24 | USE_UDEFVAL1 | Use value 1 for operand category USERDEF | char | 1 | 0 | CHAR | (N' ') | Yes | | USE_UDEFVAL1 | Allow NULL? |
| 25 | USE_UDEFVAL2 | Use value 2 for operand category USERDEF | char | 1 | 0 | CHAR | (N' ') | Yes | | USE_UDEFVAL2 | Allow NULL? |
| 26 | USE_UDEFVAL3 | Use value 3 for operand category USERDEF | char | 1 | 0 | CHAR | (N' ') | Yes | | USE_UDEFVAL3 | Allow NULL? |
| 27 | USE_UDEFVAL4 | Use value 4 for operand category USERDEF | char | 1 | 0 | CHAR | (N' ') | Yes | | USE_UDEFVAL4 | Allow NULL? |
| 28 | OPGROUP | Operand group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | EOPGROUP | OPGROUP | Allow NULL? |
| 29 | ACTFACTIND | "Demand active" can be maintained in the facts | char | 1 | 0 | CHAR | (N' ') | Yes | | ACTFACTIND | Allow NULL? |
| 30 | NODIALOGINST | Not Permissible to Maintain Operand for Installation | char | 1 | 0 | CHAR | (N' ') | Yes | | NODIALOGINST | Allow NULL? |
| 31 | NODIALOGRCAT | Not Permissible to Maintain Operand for Rate Category | char | 1 | 0 | CHAR | (N' ') | Yes | | NODIALOGRCAT | Allow NULL? |
| 32 | NODIALOGRATE | Not permissible to maintain operand for rate | char | 1 | 0 | CHAR | (N' ') | Yes | | NODIALOGRATE | Allow NULL? |
| 33 | CONREL | Contract-Relevant Operand | char | 1 | 0 | CHAR | (N' ') | Yes | | CONREL | Allow NULL? |
| 34 | RTPOPERAND | Operand from RTP interface | char | 1 | 0 | CHAR | (N' ') | Yes | | RTPOPERAND | Allow NULL? |
| 35 | PRODREL | Product-Related Operand | char | 1 | 0 | CHAR | (N' ') | Yes | | PRODREL | Allow NULL? |
| 36 | WASTEREL | Operand with Special Provision of Values | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WASTEREL | Allow NULL? |
| 37 | CONSTYPE | Consumption Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE222 | E_CONSTYPE | Allow NULL? |
| 38 | BWREL | Operand is BW-Relevant | char | 1 | 0 | CHAR | (N' ') | Yes | | E_BWREL | Allow NULL? |
| 39 | PRORATE_DAILY | Daily Proration in Billing | char | 1 | 0 | CHAR | (N' ') | Yes | | PRORATE_DAILY | Allow NULL? |
| 40 | ERCHVREL | Supply Using ERCHV | char | 1 | 0 | CHAR | (N' ') | Yes | | E_ERCHVREL | Allow NULL? |
| 41 | CONDIREL | Filled During Conditional Billing | char | 1 | 0 | CHAR | (N' ') | Yes | | E_CONDIREL | Allow NULL? |