| 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 | KEYDATE | Key Date in Results Databases | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | RDB_KEYDATE | Allow NULL? |
| 3 | PHTYPE | Portfolio Hierarchy Category | char | 1 | 0 | CHAR | (N' ') | No | | AFW_PHTYPE | Allow NULL? |
| 4 | PHNAME | Name of Portfolio Hierarchy | nvarchar | 7 | 0 | CHAR | (N' ') | No | | AFW_PHNAME | Allow NULL? |
| 5 | PHNODE | Portfolio Hierarchy Node | nvarchar | 8 | 0 | CHAR | (N' ') | No | | AFW_PHNODE | Allow NULL? |
| 6 | KEYFIGURE | Key Figure | nvarchar | 8 | 0 | CHAR | (N' ') | No | * | AFWKF_DEFINITION | Allow NULL? |
| 7 | SUMSTATE | Status of Final Result Record in Results Databases | char | 1 | 0 | CHAR | (N' ') | No | | RDB_SUMSTATE | Allow NULL? |
| 8 | RKNOTEN | RDB RA: Node of Risk Hierarchy | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | RDBRA_RKNOTEN | Allow NULL? |
| 9 | SIMIDX | RDB RA: Simulation Index (Block Index) | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | RDBRA_SIMIDX | Allow NULL? |
| 10 | VALUE01 | Key Figure Value in Results Databases | float | 15 | 16 | FLTP | ((0)) | Yes | | RDB_KEYFVALUE | |
| 11 | VALUE02 | Key Figure Value in Results Databases | float | 15 | 16 | FLTP | ((0)) | Yes | | RDB_KEYFVALUE | |
| 12 | VALUE03 | Key Figure Value in Results Databases | float | 15 | 16 | FLTP | ((0)) | Yes | | RDB_KEYFVALUE | |
| 13 | VALUE04 | Key Figure Value in Results Databases | float | 15 | 16 | FLTP | ((0)) | Yes | | RDB_KEYFVALUE | |
| 14 | VALUE05 | Key Figure Value in Results Databases | float | 15 | 16 | FLTP | ((0)) | Yes | | RDB_KEYFVALUE | |
| 15 | VALUE06 | Key Figure Value in Results Databases | float | 15 | 16 | FLTP | ((0)) | Yes | | RDB_KEYFVALUE | |
| 16 | VALUE07 | Key Figure Value in Results Databases | float | 15 | 16 | FLTP | ((0)) | Yes | | RDB_KEYFVALUE | |
| 17 | VALUE08 | Key Figure Value in Results Databases | float | 15 | 16 | FLTP | ((0)) | Yes | | RDB_KEYFVALUE | |
| 18 | VALUE09 | Key Figure Value in Results Databases | float | 15 | 16 | FLTP | ((0)) | Yes | | RDB_KEYFVALUE | |
| 19 | VALUE10 | Key Figure Value in Results Databases | float | 15 | 16 | FLTP | ((0)) | Yes | | RDB_KEYFVALUE | |
| 20 | EVALPROC2 | Procedure for Final Results | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | AFWGO_EVALPROC2 | AFWGO_EVALPROC_2 | Allow NULL? |
| 21 | CRUSER | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | RDB_CRUSER | Allow NULL? |
| 22 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | RDB_TIMESTP | Allow NULL? |
| 23 | UPUSER | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | RDB_UPUSER | Allow NULL? |
| 24 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | RDB_TIMESTP | Allow NULL? |