| 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 | SETTLPROCESS | Settlement Procedure | nvarchar | 10 | 0 | CHAR | (N' ') | No | | E_EDMSETTLPROCESS | Allow NULL? |
| 3 | WFD_TASK | Task ID | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | SWW_TASK | Allow NULL? |
| 4 | SETTLPROCESSINT | Settlement Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | E_SETTLPROCESSINT | Allow NULL? |
| 5 | ONLY_COMPL | Settlement for Complete Dataset Only | char | 1 | 0 | CHAR | (N' ') | Yes | | E_SETTLONLY_COMPL | Allow NULL? |
| 6 | LOG_LEVEL | Problem Class | char | 1 | 0 | CHAR | (N' ') | Yes | | E_SETTLLOG_LEVEL | Allow NULL? |
| 7 | DEL_BEFORE | Application Log: Keep log until expiry | char | 1 | 0 | CHAR | (N' ') | Yes | | DEL_BEFORE | Allow NULL? |
| 8 | EXPIRY_OFFSET | Offset for Expiration Date of Log | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | E_EXPIRY_OFFSET | Allow NULL? |
| 9 | SERVICE | Service Type for Settlement Procedure | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EEDMSETTLSERVICE | Allow NULL? |
| 10 | PROGNAME | ABAP Program Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PROGNAME | Allow NULL? |
| 11 | INTSIZEID | Interval Length ID | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | EPROFINTSIZE | E_EDMSETTLINTSIZEID | Allow NULL? |
| 12 | VERSREASON | Reason for Creating Profile Version | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | EVERSREASON | E_EDMSETTLVERSREASON | Allow NULL? |
| 13 | INACTIVE | Settlement Procedure is Inactive | char | 1 | 0 | CHAR | (N' ') | Yes | | E_EDMSETTLPROC_INACTIVE | Allow NULL? |
| 14 | NO_SETTLSELDOC | No Settlement Document for PoD Data Selection | char | 1 | 0 | CHAR | (N' ') | Yes | | E_EDM_NO_SETTLSELDOC | Allow NULL? |
| 15 | SELECT_GRID_ID | Grid Selection | char | 1 | 0 | CHAR | (N' ') | Yes | | E_EDMSELECT_GRID_ID | Allow NULL? |
| 16 | SETTLVIEW | Settlement View | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | EEDMSETTLVIEW | E_EDMSETTLVIEW | Allow NULL? |
| 17 | PREVSETTLPROCESS | Preliminary Settlement Procedure | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | E_EDMPREVSETTLPROCESS | Allow NULL? |
| 18 | RECALC_ALLOWED | Allow Reexecution of Completed Settlement | char | 1 | 0 | CHAR | (N' ') | Yes | | E_EDMSETTL_RECALC_ALLOWED | Allow NULL? |
| 19 | SETTLCHECKTYPE | Check Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | EEDMSETTLCHKTY | E_EDMSETTLCHECKTYPE | Allow NULL? |
| 20 | DAY_OFFSET | Day Offset | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | EEDMDAYOFFSET | EDM_DAY_OFFSET | Allow NULL? |