| 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 | RSIMLFNR | Number of a Simulation Run or Planning Run | nvarchar | 12 | 0 | CHAR | (N' ') | No | | JBRSIMLFNR | Allow NULL? |
| 3 | SIMNR | Number of Simulation Activity | nvarchar | 12 | 0 | CHAR | (N' ') | No | | JBRSIMNR | Allow NULL? |
| 4 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | JBRPKNOTEN | Allow NULL? |
| 5 | NAME | Object name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | SEU_NAME | Allow NULL? |
| 6 | TEXT | Text | nvarchar | 75 | 0 | CHAR | (N' ') | Yes | | SIMGSCH_TEXT | Allow NULL? |
| 7 | STATUS | Status of Simulation Activity | char | 1 | 0 | CHAR | (N' ') | Yes | | JBASTATUS | Allow NULL? |
| 8 | SSIMTYP | Simulation Category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | JBSSIMT | Allow NULL? |
| 9 | SSIMART | Simulation Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | JBSSIMA | Allow NULL? |
| 10 | SIST_SIM | ALM Indicator: Simulation Based on Actual or Actual + Sim. | char | 1 | 0 | CHAR | (N' ') | Yes | | JBSIST_SIM | Allow NULL? |
| 11 | SONE_ALL | Simulation Based on One or All Scenario Progressions | char | 1 | 0 | CHAR | (N' ') | Yes | | JBSONE_ALL | Allow NULL? |
| 12 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 13 | LFDNR | RM Gap/ALM Sequence No. of a Scenario or Scen. Progression | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | JBRLFNR | Allow NULL? |
| 14 | RPLANV | Planning Variant | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | JBRPLANV | Allow NULL? |
| 15 | SICHTID | View of an Analysis Structure | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | JBRSICHTID | Allow NULL? |
| 16 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | JBRPHID | Allow NULL? |
| 17 | QUOTE | Quota in Percentage in Simulation | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | JBAQUOTE | |
| 18 | PMARGE | Margin in Percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | JBPMARGE | |
| 19 | NLAUFZ | Term in Days | int | 10 | 0 | INT4 | ((0)) | Yes | | JBNLAUFZ | Allow NULL? |
| 20 | RMBEWREG | Valuation Rule | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JBRBEWREG | JBRBEWREG_ | Allow NULL? |
| 21 | ABREG | Write-Down Rule | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | JBRABREG | Allow NULL? |
| 22 | SZBMETH | Interest Calculation Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SZBMETH | Allow NULL? |
| 23 | AZZRHYTM | Interest Payment Frequency in Months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | JBAZZRHYTM | Allow NULL? |
| 24 | DVON | Close From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JBDSCHLIESSVON | Allow NULL? |
| 25 | DBIS | Close To Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JBDSCHLIESSBIS | Allow NULL? |
| 26 | DHORIZONT | Horizon | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JBDHORIZONT | Allow NULL? |
| 27 | CLOSEWAERS | ALM: Target Currency when Closing Liquidity Gap | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | JBAWAERS | Allow NULL? |
| 28 | DELAY | Time Lag for Condition Adjustment | decimal | 3 | 0 | DEC | ((0)) | Yes | | TIME_LAG | |
| 29 | DIMENSION | Time Unit | char | 1 | 0 | CHAR | (N' ') | Yes | | TIMEUNIT | Allow NULL? |
| 30 | ABLAUFFIKT | Due Date Scenario | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | JBRALFD | JBSALFD | Allow NULL? |
| 31 | BRUTNET | Gross or Net Display | char | 1 | 0 | CHAR | (N' ') | Yes | | JBSBRUTNET | Allow NULL? |
| 32 | NLFDNR | Sequence Number | int | 10 | 0 | INT4 | ((0)) | Yes | | JBNLFDNR | Allow NULL? |
| 33 | AUSW | Gap Evaluation (Position, Outflow, CF, Liquidity) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | JBRGAPAUSW | Allow NULL? |
| 34 | SZKBIND | ALM Indicator: Interest Commitment/Capital Commitment | char | 1 | 0 | CHAR | (N' ') | Yes | | JBSZKBIND | Allow NULL? |
| 35 | SBIL | Balance Sheet Indicator (ALM) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | JBSBIL | Allow NULL? |
| 36 | SLIQ | ALM Indicator: Liquidity Levels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | JBSLIQ | Allow NULL? |
| 37 | SCASH | Indicator: Cash Flow Control (ALM) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | JBSCASH | Allow NULL? |
| 38 | FLAGSZ | Selection of Scenario or Scenario Progression | char | 1 | 0 | CHAR | (N' ') | Yes | | JBRSZENWAHL | Allow NULL? |
| 39 | SZENA | Scenario | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TV_SZENARI | Allow NULL? |
| 40 | SZVERLAUF | Scenario progression | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TV_SZVERL | Allow NULL? |
| 41 | SANZW | Indicator for Evaluation or Transaction Currency | char | 1 | 0 | CHAR | (N' ') | Yes | | JBRWAERS | Allow NULL? |
| 42 | SVRLAB | Planning Basis | char | 1 | 0 | CHAR | (N' ') | Yes | | JBSVRLAB | Allow NULL? |
| 43 | SMGELA | Indicator: Spread or Elasticity | char | 1 | 0 | CHAR | (N' ') | Yes | | JBSMGELA | Allow NULL? |
| 44 | PRODZINS | Product Rate as a Parameter in Individual Simulation | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBRPRODZINS | |
| 45 | PRODZINS_PAS | Product Rate as a Parameter in Individual Simulation | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBRPRODZINS | |
| 46 | ELA_AKT_MARGE | Spread (Individual Simulation) | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBIMARGE | |
| 47 | ELA_PAS_MARGE | Spread (Individual Simulation) | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBIMARGE | |
| 48 | ELA_AKTIV_POS | Elasticity (Individual Simulation) | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBIELAST | |
| 49 | ELA_AKTIV_NEG | Elasticity (Individual Simulation) | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBIELAST | |
| 50 | ELA_PASSIV_POS | Elasticity (Individual Simulation) | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBIELAST | |
| 51 | ELA_PASSIV_NEG | Elasticity (Individual Simulation) | decimal | 10 | 7 | DEC | ((0)) | Yes | | JBIELAST | |
| 52 | NANZGSCH | Number of Simulated Transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | JBNANZGSCH | Allow NULL? |
| 53 | SSIMFICT | ALM Indicator: Simulated or Fictitious | char | 1 | 0 | CHAR | (N' ') | Yes | | JBSSIMFICT | Allow NULL? |
