| 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 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | CHAR | (N' ') | No | TDPR_PRODUCT | TB_PR_PRODINT | Allow NULL? |
| 3 | O_DATE | ID for a Time Interval | varbinary | 16 | 0 | RAW | | No | | TB_FICO_IDATE | |
| 4 | RANTYP | Contract Type | char | 1 | 0 | CHAR | (N' ') | Yes | | RANTYP | Allow NULL? |
| 5 | SKOGRP | Condition Group | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | TZK04 | SKOGRP | Allow NULL? |
| 6 | O_CONTAB | Condition Table | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | VDCOT | TB_FICO_CONTAB | Allow NULL? |
| 7 | O_STATE | Status of Condition Assignment | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TB_FICO_STATE_ENTRY | Allow NULL? |
| 8 | F_SFGKZ | Internal Release Indicator in the Business Operation | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SFGKZ | Allow NULL? |
| 9 | D_VALIDFROM | Valid From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_FICO_DVALIDFROM | Allow NULL? |
| 10 | F_VALIDFROMINC | Inclusive Indicator for Valid-from Date | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_FICO_FVALIDFROMINC | Allow NULL? |
| 11 | F_VALIDFROMULT | Month-End Indicator for Valid-from Date | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_FICO_FVALIDFROMULT | Allow NULL? |
| 12 | D_VALIDTO | Valid To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_FICO_DVALIDTO | Allow NULL? |
| 13 | F_VALIDTOINC | Inclusive Indicator for Valid-to Date | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_FICO_FVALIDTOINC | Allow NULL? |
| 14 | F_VALIDTOULT | Month-End Indicator for Valid-to Date | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_FICO_FVALIDTOULT | Allow NULL? |
| 15 | O_TIMELIM | Reason for Time Limit | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TB_FICO_OTIMELIM | Allow NULL? |
| 16 | X_CREATEUSER | User Who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_FICO_XCREATEUSER | Allow NULL? |
| 17 | D_CREATEDATE | Date on Which the Object Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_FICO_DCREATEDATE | Allow NULL? |
| 18 | T_CREATETIME | Time at Which the Object Was Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_FICO_TCREATETIME | Allow NULL? |
| 19 | X_CHANGEUSER | Last User to Change the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_FICO_XCHANGEUSER | Allow NULL? |
| 20 | D_CHANGEDATE | Date on Which the Object Was Last Changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_FICO_DCHANGEDATE | Allow NULL? |
| 21 | T_CHANGETIME | Time at Which the Object Was Last Changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_FICO_TCHANGETIME | Allow NULL? |
| 22 | X_RELEASEUSER | User Who Released Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_FICO_XRELEASEUSER | Allow NULL? |
| 23 | D_RELEASEDATE | Date on Which Object Was Released | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_FICO_DRELEASEDATE | Allow NULL? |
| 24 | T_RELEASETIME | Time at Which Object Was Released | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_FICO_TRELEASETIME | Allow NULL? |
