| 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 | RPLANV | Planning Variant | nvarchar | 12 | 0 | CHAR | (N' ') | No | JBAPLANV | JBRPLANV | Allow NULL? |
| 3 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | CHAR | (N' ') | No | JBRSI | JBRSICHTID | Allow NULL? |
| 4 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | NUMC | (N'000') | No | JBRPH | JBRPHID | Allow NULL? |
| 5 | NAME | Object name | nvarchar | 30 | 0 | CHAR | (N' ') | No | | SEU_NAME | Allow NULL? |
| 6 | SSIMTYP | Simulation Category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | JBASIMT | JBSSIMT | Allow NULL? |
| 7 | RMBEWREG | Valuation Rule | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JBRBEWREG | JBRBEWREG_ | Allow NULL? |
| 8 | ABREG | Write-Down Rule | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JBRABREGTAB | JBRABREG | Allow NULL? |
| 9 | SZBMETH | Interest Calculation Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SZBMETH | Allow NULL? |
| 10 | SANZW | Indicator for Evaluation or Transaction Currency | char | 1 | 0 | CHAR | (N' ') | Yes | | JBRWAERS | Allow NULL? |
| 11 | SVRLAB | Planning Basis | char | 1 | 0 | CHAR | (N' ') | Yes | | JBSVRLAB | Allow NULL? |
| 12 | SMGELA | Indicator: Spread or Elasticity | char | 1 | 0 | CHAR | (N' ') | Yes | | JBSMGELA | Allow NULL? |
| 13 | PRODZINS | Product Rate as a Parameter in Individual Simulation | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBRPRODZINS | |
| 14 | PRODZINS_PAS | Product Rate as a Parameter in Individual Simulation | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBRPRODZINS | |
| 15 | ELA_AKT_MARGE | Spread (Individual Simulation) | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBIMARGE | |
| 16 | ELA_PAS_MARGE | Spread (Individual Simulation) | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBIMARGE | |
| 17 | ELA_AKTIV_POS | Elasticity (Individual Simulation) | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBIELAST | |
| 18 | ELA_AKTIV_NEG | Elasticity (Individual Simulation) | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBIELAST | |
| 19 | ELA_PASSIV_POS | Elasticity (Individual Simulation) | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBIELAST | |
| 20 | ELA_PASSIV_NEG | Elasticity (Individual Simulation) | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBIELAST | |
| 21 | DELAY | Time Lag for Condition Adjustment | decimal | 3 | 0 | DEC | ((0)) | Yes | | TIME_LAG | |
| 22 | DIMENSION | Time Unit | char | 1 | 0 | CHAR | (N' ') | Yes | | TIMEUNIT | Allow NULL? |
| 23 | ABLAUFFIKT | Due Date Scenario | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | JBRALFD | JBSALFD | Allow NULL? |
| 24 | BRUTNET | Gross or Net Display | char | 1 | 0 | CHAR | (N' ') | Yes | | JBSBRUTNET | Allow NULL? |
