SAP table JBTKREG (Costing Rule)

SAP table JBTKREG has 2 primary key fields being MANDT,RKALRG.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
RKALRG Costing Rule CHAR 8 0 JBRKALRG
SGSART Type of Transaction (Costing-Based) CHAR 2 0 JBSGSART
01 Customer Transaction
02 Own-Account Trading
03 Non-Interest-Bearing Position
04 Service
05 Variable Transaction
AA Volume Costing for Nodes (Actual/Planned Line Items)
SKALRT Costing Rule Category CHAR 1 0 JBSKALRT
1 Single Transaction
2 Single Position
SAKPAS Asset/Liability Indicator CHAR 1 0 JBSAKPAS
1 Asset
2 Liability
SBILRL Balance Sheet Relevance CHAR 1 0 JBSBILRL
1 On-Balance Sheet
2 Off-Balance Sheet
SZSTRM Cash Flow for Costing Rule CHAR 1 0 JBSZSTRM
0 No, Costing with Average Positions
1 Yes, Calculation/Costing with Cash Flow
8 Yes, Transfer/Costing with Cash Flow
SDSVOL Average Volume CHAR 2 0 JBSDSVOL
1 Value Date Balance
2 Posting Balance
3 Credit Line Not Drawn Upon
4 Periodic Effective Capital for Markup Rates
5 Transfer from FI
6 Calculate from Cash Flow
7 Transaction: Transfer; Opportunity: From Cash Flow
8 Transfer
9 User Exit
SZINKO SAP Banking: Net Interest Margin Contribution CHAR 1 0 JBSZINKO
0 No Calculation
1 Interest/Opportunity Contribution
2 Fixed Margin
8 Transfer
9 User Exit
SZINBE Interest Contribution CHAR 1 0 JBSZINBE
0 No Calculation: Interest Contribution = 0
1 Tied-up Effective Capital
2 Calculation with Daily Values
3 Calculation with Average Values
4 Linear Distribution between Two Payment Dates
5 Transfer of Simulated Interest from BCA
6 Transfer of Interest from BCA Processes
8 Transfer
9 User Exit
SOPPBE Opportunity Contribution CHAR 1 0 JBSOPPBE
0 No Calculation: Opportunity Contribution = 0
1 Tied-up Effective Capital
2 Calculation with Daily Values
3 Calculation with Average Values
4 Linear Distribution between Two Payment Dates
8 Transfer
9 User Exit
SOPPZS Opportunity Interest Rate CHAR 2 0 JBSOPPZS
1 Fixed Assignment of an Interest Rate
11 Assignment Using Additional Opportunity Interest Rate
12 Weighted Adjustment
13 Weighted Independent Tranches
2 Fixed Assignment of an Int. Rate for a Fixed Rate Interval
3 Daily Adjustment
4 Average of an Interest Rate
5 Weighted Assignment based on Several Fixed Interest Rates
6 Effective Interest Rate of Altern.Trans.(Matched Maturities)
7 Opportunity Interest Rate for Core Deposits Products
8 Transfer
9 User Exit
NOZZTE Number of Time Units for Interest Rate INT2 5 0 JBNOZZTE
XOZZTE Time Unit for Interest Rate CHAR 1 0 JBXOZZTE
NOZDSP Number of Reporting Periods for Determining OI Average INT2 5 0 JBNOZDSP
BSTRA Valuation Strategy (SAP Banking / Profitability) CHAR 3 0 TKEVAS JBBSTRAT
SRUECK Control of Backdated Transactions CHAR 1 0 JBSRUECK
0 Do not re-run costing
1 Run costing again and overwrite old results
2 Run costing again and display correction fields
SSALBL Balance Formation CHAR 1 0 JBSSALBL
0 No Balance Formation in IS-B, Transfer Daily Balances
1 Balance Formation for Account Turnovers
9 User Exit
SEZDUR Average Customer Interest Rate CHAR 1 0 JBSEZDUR
1 Calculate Average Customer Interest Rate
2 Calculate Effective Interest Rate
8 Transfer
9 User Exit
SWATRA Currency Translation Contribution CHAR 1 0 JBSWATRA
0 No Currency Translation Contribution
1 Currency Translation Contribution for Period
2 Curr.Transl.Contrib.for Period w.Separate Determ.of OI in LC
8 Transfer
9 User Exit
SMINRK Reserve Requirement Costs CHAR 1 0 JBSMINRK
0 No Calculation
1 Basis: Average Volume
3 Adjusted Opportunity Interest Rate
4 Calculation without Reduction of NIM Contribution
5 Calculation with Reduction of NIM Contribution
8 Transfer
9 User Exit
SMBWPR Distribution to Periods CHAR 1 0 JBSMBWPR
0 No Distribution to Periods
1 Distribution of NPV Margin to Periods
2 Distribution to Periods using Duration
3 Transfer Interest/Opportunity Contribution
4 Distribution to Periods based on Average Volume
9 User Exit
SBWVOL NPV of Average Effective Capital CHAR 1 0 JBSBWVOL
0 No Calculation
1 Calculate - Standard
2 Calculate - Integration
8 Transfer
9 User Exit
SABRKA Settlement calculation CHAR 1 0 JBSABRKA
0 No Settlement Costing
1 Settlement Costing For Final Settlement Only
2 Settlement Costing in each Reporting Period
3 Alternative Settlement Costing in Every Reporting Period
SMARBW NPV Margin CHAR 1 0 JBSMARBW
0 No Calculation
1 Calculate NPV Margin
2 Calculate NPV Margin for Single Tranche
8 Transfer
9 User Exit
SWTBBW NPV of Currency Translation Contribution CHAR 1 0 JBSWTBBW
0 No NPV of Currency Transformation Contribution
1 NPV of Currency Transformation Contribution
8 Transfer
9 User Exit
SKNVOL Contract Volume CHAR 1 0 JBSKNVOL
0 No Contract Volume
1 Calculate Contract Volume
2 Calculate Contract Volume and Average
8 Transfer
9 User exit
SMKVOL Market Volume CHAR 1 0 JBSMKVOL
0 No Market Volume
1 Calculate market volume
2 Calculate market volume and average
8 Transfer
9 User Exit
SOPVOL Opportunity Volume CHAR 1 0 JBSOPVOL
0 No Opportunity Volume
1 Calculate opportunity volume
2 Calculate opportunity volume and average
3 Calculate opportunity volume (in local currency)
8 Transfer
9 User Exit
SOPKOS Opportunity Expense/Revenue in Own-Account Trading CHAR 1 0 JBSOPKOS
0 No opportunity expense and revenue
1 Calculate opportunity expense and revenue (daily basis)
2 Calculate opportunity revenue (daily basis)
3 Calculate opportunity expense and revenue (average basis)
4 Calculate opportunity revenue (average basis)
8 Transfer
9 User exit
SKVBER Purchases and Sales within the Period CHAR 1 0 JBSKVBER
0 Do not calculate totals
1 Calculate total market values
2 Calculate total market value in local currency
8 Transfer
9 User Exit
SGLDKR Position Calculation CHAR 1 0 JBSGLDKR
1 Calculate position values from single transactions
2 Transfer postion values and floating average price
SRKUGV Realized Price Gains and Losses CHAR 1 0 JBSRKUGV
0 No Price Gains and Losses
1 Calculate
8 Transfer
9 User Exit
SSKUGV Unrealised Price Gains and Losses CHAR 1 0 JBSSKUGV
SANLF Procedure Group NUMC 3 0 JBSVERFG
010 Stocks
020 Bonds
030 Listed Options
040 Futures
060 Swap
070 Investments
080 FRA
090 Forward Exchange
100 Forward Commodity
110 Spot Exchange
120 Foreign Notes and Coins
130 Commodities
140 Loans
150 Money Market
160 Subscription Rights
170 Warrants
180 Mutual Fund
190 Cap/Floor
200 OTC Options
400 Variable Transaction
410 Bank Customer Accounts
500 Generic Transaction
SERTRZ Own-account revenues CHAR 1 0 JBSERTRZ
0 No Revenues
1 Calculate Revenues
2 Calculate and Accrue Revenues
8 Transfer
9 User Exit
SHKOBE Trading Terms Contribution CHAR 1 0 JBSHKOBE
0 No Trading Terms Contribution
1 Transfer reference rate
2 Calculate reference rate (net present value)
8 Transfer trading terms contribution
9 User Exit
SDISAB Discount Accrual/Deferral CHAR 1 0 JBSDISAB
0 No discount accrued
1 Calculate discount accrued
8 Transfer
9 User exit
RKURSA Exchange Rate Indicator for Market Valuation CHAR 2 0 TW56 JBRKURSA
RKURST Exchange Rate Type for Foreign Currency Valuation CHAR 4 0 TCURV JBRKURST
RKURSG Exchange Rate Type: Bid CHAR 4 0 TCURV JBRKURSG
RKURSB Exchange Rate Type: Ask CHAR 4 0 TCURV JBRKURSB
SZKART Yield Curve Type NUMC 4 0 JBD14 JBSZKART
SZKAT1 Yield Curve Type - Bid NUMC 4 0 JBD14 JBSZKATG
SZKAT2 Yield Curve Type - Ask NUMC 4 0 JBD14 JBSZKATB
SLEIST Cash Flow Disturbance CHAR 1 0 JBSLEIST
0 No Calculation
1 Calculation of Type 1 Cash Flow Disturbances
2 Deferral of a Payment (Type 2 Cash Flow Disturbance)
3 Calculation of Type 1 and/or Type 2 Cash Flow Disturbance
9 User Exit
RUKRST Exchange Rate Type CHAR 4 0 TCURV JBRUKRST
SOPPSU Interpolation of Opportunity Interest Rates CHAR 1 0 JBSOPPSU
0 Interpolate Interest Rate
1 Read Grid Value
BEINWE Purchase Price CHAR 1 0 JBSEINWE
0 No purchase price
1 Calculate purchase price
8 Transfer
SOPPKD Yield Curve Validity Date CHAR 1 0 JBSOPPKD
1 Costing Key Date
2 Fixed Assignment
3 Date of Market Interest Rate
RVOLAG Volatility Type: Bid CHAR 3 0 ATVO1 JBRVOLAG
RVOLAB Volatility Type: Ask CHAR 3 0 ATVO1 JBRVOLAB
SFEVER Control Indicator for Executing Fixed Procedures CHAR 1 0 JBSFEVE
0 Do not execute fixed procedures
1 Execute fixed procedures
SEFFZS Control Indicator for Calculating Effective Interest Rate CHAR 1 0 JBSEFFZ
0 Do not calculate effective interest rate
1 Calculate effective interest rate
SOPPBH Opportunity Contribution in Local Currency CHAR 1 0 JBSOPPBH
2 Calculation with daily values
3 Calculation with average values
8 Transfer
9 User exit
SOPPZH Opportunity Interest Rate in Local Currency CHAR 2 0 JBSOPPZH
1 Fixed Assignment of an Interest Rate
12 Weighted Adjustment
13 Weighted Independent Tranches
2 Fixed Assignment of an Int. Rate for a Fixed Rate Interval
3 Daily Adjustment
4 Average of an Interest Rate
5 Weighted Assignment based on Several Fixed Interest Rates
8 Transfer
9 User Exit
NOZZTH Number of Time Units for Opportunity Interest Rate in LC INT2 5 0 JBNOZZTH
XOZZTH Time Unit for Opportunity Interest Rate in Local Currency CHAR 1 0 JBXOZZTH
NOZDSH Number of Reporting Periods for OI LC Average INT2 5 0 JBNOZDSH
SPRPAY Control Indicator for Calculating Prepayments CHAR 1 0 JBSPRPAY
0 Do not calculate prepayments
1 Calculate prepayments
2 Calculate Prepayments using BADI - SAP Solution
3 Calculate Prepayments using BADI - External Solution
SDURAT Control Indicator for Calculating Additional OI CHAR 1 0 JBSDURAT
0 No Calculation
1 Calculate using Duration
2 Calculate using Cash Flow
3 Calculate using Weighted Repayments
8 Transfer
9 User Exit
SOPPER Control Indicator for Transfer of Opportunity Interest Rate CHAR 1 0 JBSOPPER
0 Periodically transferred OI rates not taken into account
1 Periodically transferred OI rates taken into account
AUSWT Risk Management Evaluation Type CHAR 4 0 JBTKREVAL
SRKUGVB Realized Price Gains/Losses (Position) CHAR 1 0 JBSRKUGVB
0 No Price Gains and Losses
1 Calculation of Transactions and Position Changes
2 Calculation for Position Changes
8 Transfer
9 User Exit
SUXAL1 Control Indicator for User Exit before Fixed Procedures CHAR 1 0 JBSUXAL1
SUXAL2 Control Indicator for User Exit after Fixed Procedures CHAR 1 0 JBSUXAL2
SUXAL3 Control Indicator for User Exit before Flexible Procedures CHAR 1 0 JBSUXAL3
SUXAL4 Control Indicator for User Exit after Flexible Procedures CHAR 1 0 JBSUXAL4
RHANDPL Exchange CHAR 10 0 TWH01 VVRHANDPL
SNOMOZ Gap Determination of Nominal OI Rate using STC CHAR 1 0 JBSNOMOZ
0 Do not calculate
1 Calculate
SKUGVS Split Price Gains and Losses CHAR 1 0 JBSKUGVS
1 Calculate securites and forex trading result
2 Calculate securities trading result only
SOPBAS Base Values for Opportunity Revenue / Expense CHAR 1 0 JBSOPBAS
1 Opportunity Based on Opportunity Volume
2 Opportunity Based on Market Volume
SSPRDS Control Indicator for Markups and Markdowns on Opp. Interest CHAR 1 0 JBSSPRDS
0 No Calculation of Markups/Markdowns on Opportunity Interest
1 Calculate Markups/Markdowns on Opportunity Interest
SEGEPBW NPV Charges/Commission CHAR 1 0 JBSEGEPBW
0 Do not calculate NPV of charges/commission
1 Calculate NPV of charges/commission
SEGEPBE Charges/Commission Contribution (in Period) CHAR 1 0 JBSEGEPBE
0 Do not distribute charges/commission to periods
1 Distribute charges/commission to periods
2 Transfer of Charges and Commission from BCA Processes
ORIGIN Origin of Transaction CHAR 1 0 JBORIGIN
1 Data Pool
2 Operational SAP Application
INTINV_ENABLED Calculate Int. Earnings from Interim Investment CHAR 1 0 JBT_DTE_INTINV_ENABLED
INTINV_YILDCRVTP Yield Curve Type for Interim Investment NUMC 4 0 JBT_DTE_INTINV_YIELD_CURV_TYPE
INTINV_TRMNRUNTS Term of Interim Investment - Number of Time Units INT4 10 0 JBT_DTE_INTINV_TERM_NR_UNITS
INTINV_TRMUNIT Time Unit CHAR 1 0 TIMEUNIT
1 Day
2 Month
3 Year
INTINV_INTRPLT Yield Curve Interpolation for Interim Investment CHAR 1 0 JBT_DTE_INTINV_IF_INTERPOLATE
INTINV_INCLINTCO Include Int. Earnings from Interim Inv. in Int. Contr. Cal. CHAR 1 0 JBT_DTE_INTINV_INCLDE_IN_INTCO
PERIOD_COMM_INTR Committment Interest (in Period) CHAR 1 0 JBT_DTE_PERIOD_COMMITMENT_INTR

JBTKREG foreign key relationships

Table Field Check Table Check Field
0 JBTKREG BSTRA TKEVAS CO-PA Valuation Strategies MANDT
1 JBTKREG MANDT T000 Clients MANDT
0 JBTKREG RHANDPL TWH01 Stock exchange table MANDT
0 JBTKREG RHANDPL TWH01 Stock exchange table RHANDPL
1 JBTKREG RKURSA TW56 Security price type MANDT
1 JBTKREG RKURSA TW56 Security price type SKURSART
0 JBTKREG RKURSB TCURV Exchange rate types for currency translation MANDT
0 JBTKREG RKURSB TCURV Exchange rate types for currency translation KURST
1 JBTKREG RKURSG TCURV Exchange rate types for currency translation MANDT
1 JBTKREG RKURSG TCURV Exchange rate types for currency translation KURST
0 JBTKREG RKURST TCURV Exchange rate types for currency translation MANDT
0 JBTKREG RKURST TCURV Exchange rate types for currency translation KURST
1 JBTKREG RUKRST TCURV Exchange rate types for currency translation MANDT
1 JBTKREG RUKRST TCURV Exchange rate types for currency translation KURST
0 JBTKREG RVOLAB ATVO1 Volatility Types 1 MANDT
0 JBTKREG RVOLAB ATVO1 Volatility Types 1 VOLART
1 JBTKREG RVOLAG ATVO1 Volatility Types 1 MANDT
1 JBTKREG RVOLAG ATVO1 Volatility Types 1 VOLART
0 JBTKREG SZKART JBD14 Yield Curve Types (Header Information) SZKART
1 JBTKREG SZKAT1 JBD14 Yield Curve Types (Header Information) SZKART
0 JBTKREG SZKAT2 JBD14 Yield Curve Types (Header Information) SZKART