/IBS/TRB_SHCOL SAP table for – RBD IAS – Value Adjustment Collateral

Here we would like to draw your attention to /IBS/TRB_SHCOL 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_SHCOL is a SAP standard transp table used for storing RBD IAS – Value Adjustment Collateral related data in SAP. It comes under the package /IBS/RB.

SAP /IBS/TRB_SHCOL table

Table /IBS/TRB_SHCOL technical data

Table/IBS/TRB_SHCOL
Data storingRBD IAS – Value Adjustment Collateral
ModuleFS
Sub ModuleFS-RBD
SAP Package/IBS/RB
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP /IBS/TRB_SHCOL 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_SHCOL 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
  • POSIT : RBD: Sequence Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • .INCLUDE : Structure for RBD IAS – Expected Collateral in a Sheet
  • DUE_DATE : RBD: Date, Recovery Time
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CASHTYPE : RBD: Cash Category
    Its data type is CHAR (Character String) with field length 2
  • COLLTYPE : RBD: Collateral Type
    Its data type is CHAR (Character String) with field length 6
  • HEDGETYPE : RBD: Hedge Type for IAS Processing
    Its data type is CHAR (Character String) with field length 6
  • RATING : RBD: Credit Standing of Collateral Provider
    Its data type is CHAR (Character String) with field length 3
  • SIGN_MAN : RBD: Indicator for Manually Entered Collateral
    Its data type is CHAR (Character String) with field length 1
  • CURRENCY : RBD: Currency of Risk Provision
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • VALUE : RBD: Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 23
  • VEANT : RBD: Recoverable Proportion of Collateral in Percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • EXPECT : RBD: Expected Amount of Collateral Recovery
    Its data type is CURR (Currency Field) with field length 23
  • PRESENT_VAL : RBD: Net Present Value in Contract Currency
    Its data type is CURR (Currency Field) with field length 23
  • UNWINDING : RBD: Unwinding Amount
    Its data type is CURR (Currency Field) with field length 23
  • UNWINDING_MEM : RBD: Unwinding Amount
    Its data type is CURR (Currency Field) with field length 23
  • .INCLUDE : RBD: Semantic Key for CMS_RBL
  • CREDITSYSTEM : Credit System
    Its data type is CHAR (Character String) with field length 3
  • RECEIVABLE_ID : RBD: Receivable ID
    Its data type is CHAR (Character String) with field length 64
  • CAGMTID : Collateral Agreement ID
    Its data type is CHAR (Character String) with field length 40
  • RCCOL : RBD: Liquidation Costs Collateral (Amount)
    Its data type is CURR (Currency Field) with field length 23
  • VALUEVT : RBD: Collateral Value Including Liquidation Costs
    Its data type is CURR (Currency Field) with field length 23
  • .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