JBTKREG SAP (Costing Rule) Table details
Dictionary Type: Table
Description: Costing Rule
Description: Costing Rule
Table field list including key, data, relationships and ABAP select examples
JBTKREG is a standard SAP Table which is used to store Costing Rule data and is available within R/3 SAP systems depending on the version and release level.
The JBTKREG table consists of various fields, each holding specific information or linking keys about Costing Rule data available in SAP. These include RKALRG (Costing Rule), SGSART (Type of Transaction (Costing-Based)), SKALRT (Costing Rule Category), SAKPAS (Asset/Liability Indicator).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = JBTKRET
SAP JBTKREG table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| RKALRG | Costing Rule | JBRKALRG | CHAR | 8 | JBRKALRG | JB7 | |||
| SGSART | Type of Transaction (Costing-Based) | JBSGSART | CHAR | 2 | JBSGSART | ||||
| SKALRT | Costing Rule Category | JBSKALRT | CHAR | 1 | JBSKALRT | ||||
| SAKPAS | Asset/Liability Indicator | JBSAKPAS | CHAR | 1 | JBSAKPAS | ||||
| SBILRL | Balance Sheet Relevance | JBSBILRL | CHAR | 1 | JBSBILRL | ||||
| SZSTRM | Cash Flow for Costing Rule | JBSZSTRM | CHAR | 1 | JBSZSTRM | ||||
| SDSVOL | Average Volume | JBSDSVOL | CHAR | 2 | JBSDSVOL | ||||
| SZINKO | SAP Banking: Net Interest Margin Contribution | JBSZINKO | CHAR | 1 | JBSZINKO | ||||
| SZINBE | Interest Contribution | JBSZINBE | CHAR | 1 | JBSZINBE | ||||
| SOPPBE | Opportunity Contribution | JBSOPPBE | CHAR | 1 | JBSOPPBE | ||||
| SOPPZS | Opportunity Interest Rate | JBSOPPZS | CHAR | 2 | JBSOPPZS | ||||
| NOZZTE | Number of Time Units for Interest Rate | JBNOZZTE | INT2 | 5 | NZEITINT | ||||
| XOZZTE | Time Unit for Interest Rate | JBXOZZTE | CHAR | 1 | TIMEUNIT | ||||
| NOZDSP | Number of Reporting Periods for Determining OI Average | JBNOZDSP | INT2 | 5 | NZEITINT | ||||
| BSTRA | Valuation Strategy (SAP Banking / Profitability) | JBBSTRAT | CHAR | 3 | TKEVAS | COBESTRAT | |||
| SRUECK | Control of Backdated Transactions | JBSRUECK | CHAR | 1 | JBSRUECK | ||||
| SSALBL | Balance Formation | JBSSALBL | CHAR | 1 | JBSSALBL | ||||
| SEZDUR | Average Customer Interest Rate | JBSEZDUR | CHAR | 1 | JBSEZDUR | ||||
| SWATRA | Currency Translation Contribution | JBSWATRA | CHAR | 1 | JBSWATRA | ||||
| SMINRK | Reserve Requirement Costs | JBSMINRK | CHAR | 1 | JBSMINRK | ||||
| SMBWPR | Distribution to Periods | JBSMBWPR | CHAR | 1 | JBSMBWPR | ||||
| SBWVOL | NPV of Average Effective Capital | JBSBWVOL | CHAR | 1 | JBSBWVOL | ||||
| SABRKA | Settlement calculation | JBSABRKA | CHAR | 1 | JBSABRKA | ||||
| SMARBW | NPV Margin | JBSMARBW | CHAR | 1 | JBSMARBW | ||||
| SWTBBW | NPV of Currency Translation Contribution | JBSWTBBW | CHAR | 1 | JBSWTBBW | ||||
| SKNVOL | Contract Volume | JBSKNVOL | CHAR | 1 | JBSKNVOL | ||||
| SMKVOL | Market Volume | JBSMKVOL | CHAR | 1 | JBSMKVOL | ||||
| SOPVOL | Opportunity Volume | JBSOPVOL | CHAR | 1 | JBSOPVOL | ||||
| SOPKOS | Opportunity Expense/Revenue in Own-Account Trading | JBSOPKOS | CHAR | 1 | JBSOPKOS | ||||
| SKVBER | Purchases and Sales within the Period | JBSKVBER | CHAR | 1 | JBSKVBER | ||||
| SGLDKR | Position Calculation | JBSGLDKR | CHAR | 1 | JBSGLDKR | ||||
| SRKUGV | Realized Price Gains and Losses | JBSRKUGV | CHAR | 1 | JBSRKUGV | ||||
| SSKUGV | Unrealised Price Gains and Losses | JBSSKUGV | CHAR | 1 | JBSRKUGV | ||||
| SANLF | Procedure Group | JBSVERFG | NUMC | 3 | JBSVERFG | ||||
| SERTRZ | Own-account revenues | JBSERTRZ | CHAR | 1 | JBSERTRZ | ||||
| SHKOBE | Trading Terms Contribution | JBSHKOBE | CHAR | 1 | JBSHKOBE | ||||
| SDISAB | Discount Accrual/Deferral | JBSDISAB | CHAR | 1 | JBSDISAB | ||||
| RKURSA | Exchange Rate Indicator for Market Valuation | JBRKURSA | CHAR | 2 | TW56 | VVSKURSART | |||
| RKURST | Exchange Rate Type for Foreign Currency Valuation | JBRKURST | CHAR | 4 | TCURV | KURST | |||
| RKURSG | Exchange Rate Type: Bid | JBRKURSG | CHAR | 4 | TCURV | KURST | |||
| RKURSB | Exchange Rate Type: Ask | JBRKURSB | CHAR | 4 | TCURV | KURST | |||
| SZKART | Yield Curve Type | JBSZKART | NUMC | 4 | JBD14 | JBSZKART | KURVENART | ||
| SZKAT1 | Yield Curve Type - Bid | JBSZKATG | NUMC | 4 | JBD14 | JBSZKART | |||
| SZKAT2 | Yield Curve Type - Ask | JBSZKATB | NUMC | 4 | JBD14 | JBSZKART | |||
| SLEIST | Cash Flow Disturbance | JBSLEIST | CHAR | 1 | JBSLEIST | ||||
| RUKRST | Exchange Rate Type | JBRUKRST | CHAR | 4 | TCURV | KURST | |||
| SOPPSU | Interpolation of Opportunity Interest Rates | JBSOPPSU | CHAR | 1 | JBSOPPSU | ||||
| BEINWE | Purchase Price | JBSEINWE | CHAR | 1 | JBSEINWE | ||||
| SOPPKD | Yield Curve Validity Date | JBSOPPKD | CHAR | 1 | JBSOPPKD | ||||
| RVOLAG | Volatility Type: Bid | JBRVOLAG | CHAR | 3 | ATVO1 | T_VOLART | |||
| RVOLAB | Volatility Type: Ask | JBRVOLAB | CHAR | 3 | ATVO1 | T_VOLART | |||
| SFEVER | Control Indicator for Executing Fixed Procedures | JBSFEVE | CHAR | 1 | JBSFEVE | ||||
| SEFFZS | Control Indicator for Calculating Effective Interest Rate | JBSEFFZ | CHAR | 1 | JBSEFFZ | ||||
| SOPPBH | Opportunity Contribution in Local Currency | JBSOPPBH | CHAR | 1 | JBSOPPBH | ||||
| SOPPZH | Opportunity Interest Rate in Local Currency | JBSOPPZH | CHAR | 2 | JBSOPPZH | ||||
| NOZZTH | Number of Time Units for Opportunity Interest Rate in LC | JBNOZZTH | INT2 | 5 | NZEITINT | ||||
| XOZZTH | Time Unit for Opportunity Interest Rate in Local Currency | JBXOZZTH | CHAR | 1 | TIMEUNIT | ||||
| NOZDSH | Number of Reporting Periods for OI LC Average | JBNOZDSH | INT2 | 5 | NZEITINT | ||||
| SPRPAY | Control Indicator for Calculating Prepayments | JBSPRPAY | CHAR | 1 | JBSPRPAY | ||||
| SDURAT | Control Indicator for Calculating Additional OI | JBSDURAT | CHAR | 1 | JBSDURAT | ||||
| SOPPER | Control Indicator for Transfer of Opportunity Interest Rate | JBSOPPER | CHAR | 1 | JBSOPPER | ||||
| AUSWT | Risk Management Evaluation Type | JBTKREVAL | CHAR | 4 | Assigned to domain | JBREVAL | |||
| SRKUGVB | Realized Price Gains/Losses (Position) | JBSRKUGVB | CHAR | 1 | JBSRKUGVB | ||||
| SUXAL1 | Control Indicator for User Exit before Fixed Procedures | JBSUXAL1 | CHAR | 1 | JBSUSALG | ||||
| SUXAL2 | Control Indicator for User Exit after Fixed Procedures | JBSUXAL2 | CHAR | 1 | JBSUSALG | ||||
| SUXAL3 | Control Indicator for User Exit before Flexible Procedures | JBSUXAL3 | CHAR | 1 | JBSUSALG | ||||
| SUXAL4 | Control Indicator for User Exit after Flexible Procedures | JBSUXAL4 | CHAR | 1 | JBSUSALG | ||||
| RHANDPL | Exchange | VVRHANDPL | CHAR | 10 | TWH01 | VVRHANDPL | WHP | ||
| SNOMOZ | Gap Determination of Nominal OI Rate using STC | JBSNOMOZ | CHAR | 1 | JBSNOMOZ | ||||
| SKUGVS | Split Price Gains and Losses | JBSKUGVS | CHAR | 1 | JBSKUGVS | ||||
| SOPBAS | Base Values for Opportunity Revenue / Expense | JBSOPBAS | CHAR | 1 | JBSOPBAS | ||||
| SSPRDS | Control Indicator for Markups and Markdowns on Opp. Interest | JBSSPRDS | CHAR | 1 | JBSSPRDS | ||||
| SEGEPBW | NPV Charges/Commission | JBSEGEPBW | CHAR | 1 | JBSEGEPBW | ||||
| SEGEPBE | Charges/Commission Contribution (in Period) | JBSEGEPBE | CHAR | 1 | JBSEGEPBE | ||||
| ORIGIN | Origin of Transaction | JBORIGIN | CHAR | 1 | JBORIGIN | ||||
| INTINV_ENABLED | Calculate Int. Earnings from Interim Investment | JBT_DTE_INTINV_ENABLED | CHAR | 1 | JBT_INTINV_ENABLED | ||||
| INTINV_YILDCRVTP | Yield Curve Type for Interim Investment | JBT_DTE_INTINV_YIELD_CURV_TYPE | NUMC | 4 | Assigned to domain | JBSZKART | |||
| INTINV_TRMNRUNTS | Term of Interim Investment - Number of Time Units | JBT_DTE_INTINV_TERM_NR_UNITS | INT4 | 10 | INT4 | ||||
| INTINV_TRMUNIT | Time Unit | TIMEUNIT | CHAR | 1 | TIMEUNIT | ||||
| INTINV_INTRPLT | Yield Curve Interpolation for Interim Investment | JBT_DTE_INTINV_IF_INTERPOLATE | CHAR | 1 | JBSOPPSU | ||||
| INTINV_INCLINTCO | Include Int. Earnings from Interim Inv. in Int. Contr. Cal. | JBT_DTE_INTINV_INCLDE_IN_INTCO | CHAR | 1 | JBT_INTINV_INCLDE_IN_INTCO | ||||
| PERIOD_COMM_INTR | Committment Interest (in Period) | JBT_DTE_PERIOD_COMMITMENT_INTR | CHAR | 1 | JBT_PERIOD_COMMITMENT_INTR |
| Key field | Non-key field |
How do I retrieve data from SAP table JBTKREG using ABAP code
The following ABAP code Example will allow you to do a basic selection on JBTKREG to SELECT all data from the tableDATA: WA_JBTKREG TYPE JBTKREG.
SELECT SINGLE *
FROM JBTKREG
INTO CORRESPONDING FIELDS OF WA_JBTKREG
WHERE...
How to access SAP table JBTKREG
Within an ECC or HANA version of SAP you can also view further information about JBTKREG and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects