1. Home
  2. Resources
  3. SAP Tables
  4. JBTKREG - Costing Rule

SAP Table JBTKREG

Costing Rule

JBTKREG (Costing Rule) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link JBTKREG to other SAP tables.

JBTKREG table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
RKALRG Costing Rule JBRKALRG CHAR 8 0
SGSART Type of Transaction (Costing-Based) JBSGSART CHAR 2 0
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 JBSKALRT CHAR 1 0
1 Single Transaction
2 Single Position
SAKPAS Asset/Liability Indicator JBSAKPAS CHAR 1 0
1 Asset
2 Liability
SBILRL Balance Sheet Relevance JBSBILRL CHAR 1 0
1 On-Balance Sheet
2 Off-Balance Sheet
SZSTRM Cash Flow for Costing Rule JBSZSTRM CHAR 1 0
0 No, Costing with Average Positions
1 Yes, Calculation/Costing with Cash Flow
8 Yes, Transfer/Costing with Cash Flow
SDSVOL Average Volume JBSDSVOL CHAR 2 0
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 JBSZINKO CHAR 1 0
0 No Calculation
1 Interest/Opportunity Contribution
2 Fixed Margin
8 Transfer
9 User Exit
SZINBE Interest Contribution JBSZINBE CHAR 1 0
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 JBSOPPBE CHAR 1 0
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 JBSOPPZS CHAR 2 0
1 Fixed Assignment of an Interest Rate
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
11 Assignment Using Additional Opportunity Interest Rate
12 Weighted Adjustment
13 Weighted Independent Tranches
NOZZTE Number of Time Units for Interest Rate JBNOZZTE INT2 5 0
XOZZTE Time Unit for Interest Rate JBXOZZTE CHAR 1 0
1 Day
2 Month
3 Year
NOZDSP Number of Reporting Periods for Determining OI Average JBNOZDSP INT2 5 0
BSTRA Valuation Strategy (SAP Banking / Profitability) JBBSTRAT TKEVAS CHAR 3 0
SRUECK Control of Backdated Transactions JBSRUECK CHAR 1 0
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 JBSSALBL CHAR 1 0
0 No Balance Formation in IS-B, Transfer Daily Balances
1 Balance Formation for Account Turnovers
9 User Exit
SEZDUR Average Customer Interest Rate JBSEZDUR CHAR 1 0
1 Calculate Average Customer Interest Rate
2 Calculate Effective Interest Rate
8 Transfer
9 User Exit
SWATRA Currency Translation Contribution JBSWATRA CHAR 1 0
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 JBSMINRK CHAR 1 0
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 JBSMBWPR CHAR 1 0
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 JBSBWVOL CHAR 1 0
0 No Calculation
1 Calculate - Standard
2 Calculate - Integration
8 Transfer
9 User Exit
SABRKA Settlement calculation JBSABRKA CHAR 1 0
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 JBSMARBW CHAR 1 0
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 JBSWTBBW CHAR 1 0
0 No NPV of Currency Transformation Contribution
1 NPV of Currency Transformation Contribution
8 Transfer
9 User Exit
SKNVOL Contract Volume JBSKNVOL CHAR 1 0
0 No Contract Volume
1 Calculate Contract Volume
2 Calculate Contract Volume and Average
8 Transfer
9 User exit
SMKVOL Market Volume JBSMKVOL CHAR 1 0
0 No Market Volume
1 Calculate market volume
2 Calculate market volume and average
8 Transfer
9 User Exit
SOPVOL Opportunity Volume JBSOPVOL CHAR 1 0
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 JBSOPKOS CHAR 1 0
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 JBSKVBER CHAR 1 0
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 JBSGLDKR CHAR 1 0
1 Calculate position values from single transactions
2 Transfer postion values and floating average price
SRKUGV Realized Price Gains and Losses JBSRKUGV CHAR 1 0
0 No Price Gains and Losses
1 Calculate
8 Transfer
9 User Exit
SSKUGV Unrealised Price Gains and Losses JBSSKUGV CHAR 1 0
0 No Price Gains and Losses
1 Calculate
8 Transfer
9 User Exit
SANLF Procedure Group JBSVERFG NUMC 3 0
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 JBSERTRZ CHAR 1 0
0 No Revenues
1 Calculate Revenues
2 Calculate and Accrue Revenues
8 Transfer
9 User Exit
SHKOBE Trading Terms Contribution JBSHKOBE CHAR 1 0
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 JBSDISAB CHAR 1 0
0 No discount accrued
1 Calculate discount accrued
8 Transfer
9 User exit
RKURSA Exchange Rate Indicator for Market Valuation JBRKURSA TW56 CHAR 2 0
RKURST Exchange Rate Type for Foreign Currency Valuation JBRKURST TCURV CHAR 4 0
RKURSG Exchange Rate Type: Bid JBRKURSG TCURV CHAR 4 0
RKURSB Exchange Rate Type: Ask JBRKURSB TCURV CHAR 4 0
SZKART Yield Curve Type JBSZKART JBD14 NUMC 4 0
SZKAT1 Yield Curve Type - Bid JBSZKATG JBD14 NUMC 4 0
SZKAT2 Yield Curve Type - Ask JBSZKATB JBD14 NUMC 4 0
SLEIST Cash Flow Disturbance JBSLEIST CHAR 1 0
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 JBRUKRST TCURV CHAR 4 0
SOPPSU Interpolation of Opportunity Interest Rates JBSOPPSU CHAR 1 0
0 Interpolate Interest Rate
1 Read Grid Value
BEINWE Purchase Price JBSEINWE CHAR 1 0
0 No purchase price
1 Calculate purchase price
8 Transfer
SOPPKD Yield Curve Validity Date JBSOPPKD CHAR 1 0
1 Costing Key Date
2 Fixed Assignment
3 Date of Market Interest Rate
RVOLAG Volatility Type: Bid JBRVOLAG ATVO1 CHAR 3 0
RVOLAB Volatility Type: Ask JBRVOLAB ATVO1 CHAR 3 0
SFEVER Control Indicator for Executing Fixed Procedures JBSFEVE CHAR 1 0
0 Do not execute fixed procedures
1 Execute fixed procedures
SEFFZS Control Indicator for Calculating Effective Interest Rate JBSEFFZ CHAR 1 0
0 Do not calculate effective interest rate
1 Calculate effective interest rate
SOPPBH Opportunity Contribution in Local Currency JBSOPPBH CHAR 1 0
2 Calculation with daily values
3 Calculation with average values
8 Transfer
9 User exit
SOPPZH Opportunity Interest Rate in Local Currency JBSOPPZH CHAR 2 0
1 Fixed Assignment of an Interest Rate
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
12 Weighted Adjustment
13 Weighted Independent Tranches
NOZZTH Number of Time Units for Opportunity Interest Rate in LC JBNOZZTH INT2 5 0
XOZZTH Time Unit for Opportunity Interest Rate in Local Currency JBXOZZTH CHAR 1 0
1 Day
2 Month
3 Year
NOZDSH Number of Reporting Periods for OI LC Average JBNOZDSH INT2 5 0
SPRPAY Control Indicator for Calculating Prepayments JBSPRPAY CHAR 1 0
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 JBSDURAT CHAR 1 0
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 JBSOPPER CHAR 1 0
0 Periodically transferred OI rates not taken into account
1 Periodically transferred OI rates taken into account
AUSWT Risk Management Evaluation Type JBTKREVAL CHAR 4 0
SRKUGVB Realized Price Gains/Losses (Position) JBSRKUGVB CHAR 1 0
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 JBSUXAL1 CHAR 1 0
0 Do not calculate
1 Calculate
2 BAdI verwenden
3 BAdI und U-Exit verwenden
SUXAL2 Control Indicator for User Exit after Fixed Procedures JBSUXAL2 CHAR 1 0
0 Do not calculate
1 Calculate
2 BAdI verwenden
3 BAdI und U-Exit verwenden
SUXAL3 Control Indicator for User Exit before Flexible Procedures JBSUXAL3 CHAR 1 0
0 Do not calculate
1 Calculate
2 BAdI verwenden
3 BAdI und U-Exit verwenden
SUXAL4 Control Indicator for User Exit after Flexible Procedures JBSUXAL4 CHAR 1 0
0 Do not calculate
1 Calculate
2 BAdI verwenden
3 BAdI und U-Exit verwenden
RHANDPL Exchange VVRHANDPL TWH01 CHAR 10 0
SNOMOZ Gap Determination of Nominal OI Rate using STC JBSNOMOZ CHAR 1 0
0 Do not calculate
1 Calculate
SKUGVS Split Price Gains and Losses JBSKUGVS CHAR 1 0
1 Calculate securites and forex trading result
2 Calculate securities trading result only
SOPBAS Base Values for Opportunity Revenue / Expense JBSOPBAS CHAR 1 0
1 Opportunity Based on Opportunity Volume
2 Opportunity Based on Market Volume
SSPRDS Control Indicator for Markups and Markdowns on Opp. Interest JBSSPRDS CHAR 1 0
0 No Calculation of Markups/Markdowns on Opportunity Interest
1 Calculate Markups/Markdowns on Opportunity Interest
SEGEPBW NPV Charges/Commission JBSEGEPBW CHAR 1 0
0 Do not calculate NPV of charges/commission
1 Calculate NPV of charges/commission
SEGEPBE Charges/Commission Contribution (in Period) JBSEGEPBE CHAR 1 0
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 JBORIGIN CHAR 1 0
1 Data Pool
2 Operational SAP Application
INTINV_ENABLED Calculate Int. Earnings from Interim Investment JBT_DTE_INTINV_ENABLED CHAR 1 0
0 No Calculation
1 Calculation from Average Volume
2 Calculation from Average Commited Effective Capital
INTINV_YILDCRVTP Yield Curve Type for Interim Investment JBT_DTE_INTINV_YIELD_CURV_TYPE NUMC 4 0
INTINV_TRMNRUNTS Term of Interim Investment - Number of Time Units JBT_DTE_INTINV_TERM_NR_UNITS INT4 10 0
INTINV_TRMUNIT Time Unit TIMEUNIT CHAR 1 0
1 Day
2 Month
3 Year
INTINV_INTRPLT Yield Curve Interpolation for Interim Investment JBT_DTE_INTINV_IF_INTERPOLATE CHAR 1 0
0 Interpolate Interest Rate
1 Read Grid Value
INTINV_INCLINTCO Include Int. Earnings from Interim Inv. in Int. Contr. Cal. JBT_DTE_INTINV_INCLDE_IN_INTCO CHAR 1 0
0 Do Not Include in Interest Contribution Calculation
1 Include in Interest Contribution Calculation
PERIOD_COMM_INTR Committment Interest (in Period) JBT_DTE_PERIOD_COMMITMENT_INTR CHAR 1 0
0 Do not Report Committment Interest Periodically
1 Report Committment Interest Periodically

JBTKREG foreign key relationships

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