| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | ITEM | Object of AISGENKF | nvarchar | 16 | 0 | CHAR | (N' ') | No | | SVAGEN_ITEM | Allow NULL? |
| 2 | ITEM_CATEGORY | Category of Items in Transaction AISGENKF | char | 1 | 0 | CHAR | (N' ') | Yes | | SVAGEN_ITEM_CATEGORY | Allow NULL? |
| 3 | AREA_SINGLEPOS | Relevant for Single Position | char | 1 | 0 | CHAR | (N' ') | Yes | | SVAGEN_AREA_POSITION | Allow NULL? |
| 4 | AREA_PH | Portfolio Hierarchy Area | char | 1 | 0 | CHAR | (N' ') | Yes | | SVAGEN_AREA_PH | Allow NULL? |
| 5 | REGELID_ALLOWED | Market Data Shift Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | SVAGEN_REGELID_ALLOWED | Allow NULL? |
| 6 | REF_DDIC_DTEL | Data element (semantic domain) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ROLLNAME | Allow NULL? |
| 7 | REF_CURR_ITEM | Object of AISGENKF | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SVAGEN_ITEM | Allow NULL? |
| 8 | REF_QUAN_ITEM | Object of AISGENKF | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SVAGEN_ITEM | Allow NULL? |
| 9 | FCAT_EXPONENT | Format of Key Figure without Currency Dependency | char | 1 | 0 | CHAR | (N' ') | Yes | | SVAGEN_OUTPUT_EXPONENT | Allow NULL? |
| 10 | FCAT_DECIMALS | Number of Decimal Places | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | DECIMALS | Allow NULL? |
| 11 | FCAT_NOOUT | ALV control: Column is not output | char | 1 | 0 | CHAR | (N' ') | Yes | | LVC_NOOUT | Allow NULL? |
| 12 | FCAT_DO_SUM | ALV control: Aggregate values of column | char | 1 | 0 | CHAR | (N' ') | Yes | | LVC_DOSUM | Allow NULL? |
| 13 | FCAT_OUTPUTLEN | ALV control: Column width in characters | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | LVC_OUTLEN | Allow NULL? |
| 14 | FCAT_KEY | ALV control: Key field | char | 1 | 0 | CHAR | (N' ') | Yes | | LVC_KEY | Allow NULL? |
| 15 | FIMA_METHODE | Calculation Method - Price Calculator - Internal Use Only | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | TV_METHODE | Allow NULL? |
| 16 | FIMA_BASE_POINT | Percentage Point Shift of Interest Rates/Yield Curves | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBBBP | |
| 17 | FIMA_REGELTYP | Rule Category for Shift Rule | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | JBRRTYP | Allow NULL? |
| 18 | SOURCE_FIELD | Component name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | NAME_KOMP | Allow NULL? |
| 19 | SOURCE_METHODE | Calculation Method - Price Calculator - Internal Use Only | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | TV_METHODE | Allow NULL? |
| 20 | METHOD_POS | Evaluation method of object | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SVAGEN_METHOD | Allow NULL? |
| 21 | METHOD_AGG_SEG | Evaluation method of object | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SVAGEN_METHOD | Allow NULL? |
| 22 | METHOD_AGG_PH | Evaluation method of object | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SVAGEN_METHOD | Allow NULL? |
| 23 | METHOD_PH | Evaluation method of object | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SVAGEN_METHOD | Allow NULL? |
| 24 | BASE_KEYFIGURE1 | Object of AISGENKF | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SVAGEN_ITEM | Allow NULL? |
| 25 | BASE_KEYFIGURE2 | Object of AISGENKF | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SVAGEN_ITEM | Allow NULL? |
| 26 | BASE_KEYFIGURE3 | Object of AISGENKF | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SVAGEN_ITEM | Allow NULL? |
| 27 | BASE_KEYFIGURE4 | Object of AISGENKF | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SVAGEN_ITEM | Allow NULL? |
| 28 | BASE_KEYFIGURE5 | Object of AISGENKF | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SVAGEN_ITEM | Allow NULL? |