| 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 | REPLACEMETHOD | Replacement Value Procedure | nvarchar | 10 | 0 | CHAR | (N' ') | No | | E_REPLACE | Allow NULL? |
| 3 | REPLACEFUNC | Function Module for Creation of Replacement Values | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | E_ERSATZFUNC | Allow NULL? |
| 4 | REFZEITFUNC | Function Module for Determination of Reference Period | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | E_REFZEITFUNC | Allow NULL? |
| 5 | PROFILE | Reference Profile | nvarchar | 18 | 0 | NUMC | (N'000000000000000000') | Yes | EPROFHEAD | E_REPLACE_PROFILE | Allow NULL? |
| 6 | PROFROLE | Profile allocation role | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | EPROFASSROLE | PROFROLE | Allow NULL? |
| 7 | HISTORY | Start of Reference Period | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | E_HISTORIC_START | Allow NULL? |
| 8 | HISTORYPERIOD | Duration of Reference Period | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | E_HISTORIC_READ_PERIOD | Allow NULL? |
| 9 | HISTORYREPLACE | Reference Period Corresponds to Replacement Period | char | 1 | 0 | CHAR | (N' ') | Yes | | E_HISTORIC_FLAG | Allow NULL? |
| 10 | CONSUMPTION | Replacement Value Procedure Valid for Consumption Profiles | char | 1 | 0 | CHAR | (N' ') | Yes | | E_CONSUMPTION_FLAG | Allow NULL? |
| 11 | DEMAND | Replacement Value Procedure Valid for Demand Profiles | char | 1 | 0 | CHAR | (N' ') | Yes | | E_DEMAND_FLAG | Allow NULL? |
| 12 | ESTIMATE | Procedure Valid for Interpolation of Profile Values | char | 1 | 0 | CHAR | (N' ') | Yes | | E_ESTIMATE_FLAG | Allow NULL? |
| 13 | FORECAST | Procedure Valid for Extrapolation of Profile Values | char | 1 | 0 | CHAR | (N' ') | Yes | | E_FORECAST_FLAG | Allow NULL? |
| 14 | MANUAL | Replacement Value Procedure Requires Manual Entry | char | 1 | 0 | CHAR | (N' ') | Yes | | E_MANUAL_FLAG | Allow NULL? |
| 15 | REPLACECUSTSTAT | User Status | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | VEDM_STAT_CUST | E_REPLACECUSTSTATUS | Allow NULL? |
