/IBS/TRB_SHEETH SAP table for – RBD IAS – Header Data of Valuation Sheet

Here we would like to draw your attention to /IBS/TRB_SHEETH table in SAP. As we know it is being mainly used with the SAP FS-RBD (Value Adjustment in FS) component which is coming under FS module (Financial Services). /IBS/TRB_SHEETH is a SAP standard transp table used for storing RBD IAS – Header Data of Valuation Sheet related data in SAP. It comes under the package /IBS/RB.

SAP /IBS/TRB_SHEETH table

Table /IBS/TRB_SHEETH technical data

Table/IBS/TRB_SHEETH
Data storingRBD IAS – Header Data of Valuation Sheet
ModuleFS
Sub ModuleFS-RBD
SAP Package/IBS/RB
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP /IBS/TRB_SHEETH Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in /IBS/TRB_SHEETH table.

  • MANDANT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SHEETNR : RBD: Fair Value Sheet
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • .INCLUDE : Structure for RBD IAS – Header Data of a Sheet
  • RBDID : RBD: RBD ID (RBD Area)
    Its data type is CHAR (Character String) with field length 4
  • RBDNR : RBD: Account Number
    Its data type is CHAR (Character String) with field length 13
  • DUE_DATE : RBD: Valuation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BEWME : RBD: Valuation Method
    Its data type is CHAR (Character String) with field length 2
  • MODID : RBD: Component ID Source System
    Its data type is CHAR (Character String) with field length 10
  • VERTV : RBD: Contract Number Source System
    Its data type is CHAR (Character String) with field length 100
  • LIBUE : RBD: Source Accounting Unit
    Its data type is CHAR (Character String) with field length 4
  • VKREF : RBD: Account Assignment Reference Source System
    Its data type is CHAR (Character String) with field length 8
  • PDAVS : RBD: Product Type Source System
    Its data type is CHAR (Character String) with field length 10
  • VEAVS : RBD: Contract Type Previous System
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RWBKNZ : RBD: Value Adjustment Indicator
    Its data type is CHAR (Character String) with field length 30
  • CURRENCY : RBD: Currency of Risk Provision
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ARREAR : RBD: Amount in Arrears in Contract Currency (IAS)
    Its data type is CURR (Currency Field) with field length 23
  • OBLIGO : RBD: Book Value for Srce System Contract in Contract Currncy
    Its data type is CURR (Currency Field) with field length 23
  • XINCL_RESTKAP : RBD: CF Position Rem. Capital at End of Fixed Int./Term
    Its data type is CHAR (Character String) with field length 1
  • DELFZ : RBD: End of Term for Source System Contract
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DEFSZ : RBD: End of Fixed Interest Period in Source System Contract
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DELINQ_SINCE : RBD: Date Since Which Contract Is in Arrears
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SUM_LOSSES : RBD: Total Loss Amount for Contract in Source System
    Its data type is CURR (Currency Field) with field length 23
  • REAL_DATE : RBD: Date, Recovery Time
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BRESTKAP : RBD: Remaining Capital at End of Cash Flow
    Its data type is CURR (Currency Field) with field length 23
  • INT_RATE : RBD: Initial Eff. Interest Rate in Source System Contract
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • PERC_CAF : RBD: Percentage Expectation Used for Cash Flow
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • INT_METH : RBD: Interest Calculation Method (Financial Mathematics)
    Its data type is CHAR (Character String) with field length 1
  • PROCTYPE : RBD: Processing Type
    Its data type is CHAR (Character String) with field length 2
  • PROCCAT : RBD: Processing Category for IAS
    Its data type is CHAR (Character String) with field length 1
  • XCF_DIFF : RBD: CF Position Remaining Capital on Valuation Key Date
    Its data type is CHAR (Character String) with field length 1
  • LAST_DUE_DATE : RBD: Valuation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • COLUP : RBD Indicator: Update Liquidation Dates
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Structure for RBD IAS – Totals Memory for Sheets
  • GJRBD : RBD: Fiscal Year RBD
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • WB_BESTAND : RBD: Value Adjustment Position Current Period
    Its data type is CURR (Currency Field) with field length 23
  • WB_BESTAND_UN : RBD: Position Unwinding Current Period (Val. Adj.)
    Its data type is CURR (Currency Field) with field length 23
  • WB_BESTAND_SU : RBD: Reserve Field
    Its data type is CURR (Currency Field) with field length 23
  • WB_BESTAND_VJ : RBD: Value Adjustment Position Previous Periods
    Its data type is CURR (Currency Field) with field length 23
  • WB_BESTAND_VJ_UN : RBD: Position Unwinding Previous Periods (Val. Adj.)
    Its data type is CURR (Currency Field) with field length 23
  • WB_BESTAND_VJ_SU : RBD: Reserve Field
    Its data type is CURR (Currency Field) with field length 23
  • WB_BESTAND_VB : RBD: Position Usage (Value Adjustment)
    Its data type is CURR (Currency Field) with field length 23
  • WB_BESTAND_DA : RBD: Position Direct Write-Off (Value Adjustment)
    Its data type is CURR (Currency Field) with field length 23
  • WB_AE_BESTAND_VJ : RBD: Change Balance Value Adjustment Previous Periods
    Its data type is CURR (Currency Field) with field length 23
  • WB_BEDARF : RBD: Change Requirements Value Adjustment Current Period
    Its data type is CURR (Currency Field) with field length 23
  • WB_BEDARF_UN : RBD: Requirement Unwinding (Value Adjustment)
    Its data type is CURR (Currency Field) with field length 23
  • WB_BEDARF_VJ : RBD: Change Requirement Value Adjustment Previous Periods
    Its data type is CURR (Currency Field) with field length 23
  • WB_BEDARF_VB : RBD: Change Requirement Usage (Value Adjustment)
    Its data type is CURR (Currency Field) with field length 23
  • WB_BEDARF_DA : RBD: Change Requirement Direct Write-Off (Value Adjustment)
    Its data type is CURR (Currency Field) with field length 23
  • SUM_SICH_AB : RBD: NPV of Expected Collateral Revenues Value Adjustment
    Its data type is CURR (Currency Field) with field length 23
  • SUM_CF_RATE : RBD: Total Cash Flow Positions (Installments)
    Its data type is CURR (Currency Field) with field length 23
  • SUM_CF_ERWA : RBD: Total Cash Flow Expectation (Value Adjustment)
    Its data type is CURR (Currency Field) with field length 23
  • SUM_CF_ABGE : RBD: Net Present Value of Expected Cash Flow (Val. Adj.)
    Its data type is CURR (Currency Field) with field length 23
  • SUM_AKT_UNW : RBD: Unwinding Amount
    Its data type is CURR (Currency Field) with field length 23
  • SUM_AKT_UNW_MEM : RBD: Unwinding Amount
    Its data type is CURR (Currency Field) with field length 23
  • OP_CH_UNW : RBD: Open Position Change Value Adjustment
    Its data type is CURR (Currency Field) with field length 23
  • BEST_UMB_AB : RBD: Balance Sheet Transfer – Retirement – Value Adjustment
    Its data type is CURR (Currency Field) with field length 23
  • BEST_UMB_ZU : RBD: Balance Sheet Transfer – Acquisition – Value Adjustment
    Its data type is CURR (Currency Field) with field length 23
  • RBDKL : RBD: Class
    Its data type is CHAR (Character String) with field length 8
  • RBDKL_OLD : RBD: Class (Old)
    Its data type is CHAR (Character String) with field length 8
  • VKREF_OLD : RBD: Account Assignment Reference Source System (Old)
    Its data type is CHAR (Character String) with field length 8
  • KZTRNS : RBD: Balance Sheet Transfer
    Its data type is CHAR (Character String) with field length 1
  • FLG_INIT : RBD: Checkbox for Initial Run
    Its data type is CHAR (Character String) with field length 1
  • WB_INIT : RBD: Initialization (Value Adjustment) for Current Period
    Its data type is CURR (Currency Field) with field length 23
  • WB_INIT_VJ : RBD: Initialization of Value Adjustment (Previous Periods)
    Its data type is CURR (Currency Field) with field length 23
  • MAN_LOSSES : RBD: Manual Loss Entry
    Its data type is CURR (Currency Field) with field length 23
  • OBLIGO_ORG : RBD: Orig. Book Value of Srce Syst. Contr. in Contract Crcy
    Its data type is CURR (Currency Field) with field length 23
  • .INCLUDE : Archiving Data
  • ARCHIVE_STATUS : Archiving Status
    Its data type is CHAR (Character String) with field length 1
  • ARCHIVE_FLUD : Resubmission Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : RBD: User Data (Entry / Change)
  • ANUSR : RBD: User Who Made First Entry
    Its data type is CHAR (Character String) with field length 12
  • ANDAT : RBD: Date of First Entry
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ANUHR : RBD: Time First Entry Was Made
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ANHER : RBD: Origin of First Entry
    Its data type is CHAR (Character String) with field length 20
  • AEUSR : RBD: User who Made the Change
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : RBD: Date of Last Change
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEUHR : RBD: Time of Last Change
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AEHER : RBD: Origin of Last Change
    Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : Structure for RBD Provisions IAS – Header Data of Sheet
  • RS_BASIS : RBD: Open Contingent Liability in Contract Currency
    Its data type is CURR (Currency Field) with field length 23
  • RS_PROP : RBD: Probability of Risk Provision Usage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • RS_PROP_DR : RBD: Usage Amount Contingent Liability
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • RS_PASSV : RBD: Indicator Prohibition of Liability Recognition (Reset)
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Structure for RBD Provision IAS – Totals Memory for Sheets
  • RS_BESTAND : RBD: Provision Balance Current Period
    Its data type is CURR (Currency Field) with field length 23
  • RS_BESTAND_UN : RBD: Position Unwinding Current Period (Reset)
    Its data type is CURR (Currency Field) with field length 23
  • RS_BESTAND_VJ : RBD: Provision Balance Previous Periods
    Its data type is CURR (Currency Field) with field length 23
  • RS_BESTAND_UN_VJ : RBD: Position Unwinding Previous Periods (Reset)
    Its data type is CURR (Currency Field) with field length 23
  • RS_BEDARF : RBD: Provision Requirement
    Its data type is CURR (Currency Field) with field length 23
  • RS_BEDARF_UN : RBD: Unwinding Requirements (Provision)
    Its data type is CURR (Currency Field) with field length 23
  • RS_AE_BESTAND_VJ : RBD: Change Balance Provision Previous Periods
    Its data type is CURR (Currency Field) with field length 23
  • RS_BEDARF_AJ : RBD: Change Requirement Provision Current Period
    Its data type is CURR (Currency Field) with field length 23
  • RS_BEDARF_VJ : RBD: Change Requirement Provision Previous Periods
    Its data type is CURR (Currency Field) with field length 23
  • RS_SUM_IA_ERWA : RBD: Defined Utilization (Total)
    Its data type is CURR (Currency Field) with field length 23
  • RS_SUM_IA_ABGE : RBD: NPV of Expected Utilization
    Its data type is CURR (Currency Field) with field length 23
  • RS_SUM_CF_ERWA : RBD: Total Cash Flow Expectation (Reset)
    Its data type is CURR (Currency Field) with field length 23
  • RS_SUM_CF_ABGE : RBD: NPV of Expected Cash Flows (Provision)
    Its data type is CURR (Currency Field) with field length 23
  • RS_SUM_SICH_AB : RBD: NPV of Expected Collateral Revenues (Reset)
    Its data type is CURR (Currency Field) with field length 23
  • RS_SUM_I_UNW : RBD: Unwinding Amount
    Its data type is CURR (Currency Field) with field length 23
  • RS_SUM_I_UNW_MEM : RBD: Unwinding Amount
    Its data type is CURR (Currency Field) with field length 23
  • RS_SUM_UNW : RBD: Unwinding Amount
    Its data type is CURR (Currency Field) with field length 23
  • RS_SUM_UNW_MEM : RBD: Unwinding Amount
    Its data type is CURR (Currency Field) with field length 23
  • RS_SHEETNR_REF : RBD: Fair Value Sheet Reference
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • RS_OP_CH_UNW : RBD: Open Position Change Provision
    Its data type is CURR (Currency Field) with field length 23
  • RS_BEST_UMB_AB : RBD: Balance Sheet Transfer – Retirement – Provision
    Its data type is CURR (Currency Field) with field length 23
  • RS_BEST_UMB_ZU : RBD: Balance Sheet Transfer – Acquisition – Provision
    Its data type is CURR (Currency Field) with field length 23
  • RS_INIT : RBD: Initialization (Provision) for Current Period
    Its data type is CURR (Currency Field) with field length 23
  • RS_INIT_VJ : RBD: Initialization of Provision (Previous Periods)
    Its data type is CURR (Currency Field) with field length 23