IBROSTMP SAP table for – ISCD: Broker Report – Item Data

Here we would like to draw your attention to IBROSTMP table in SAP. As we know it is being mainly used with the SAP FS-CD (Collections/Disbursements in FS) component which is coming under FS module (Financial Services). IBROSTMP is a SAP standard transp table used for storing ISCD: Broker Report – Item Data related data in SAP. It comes under the package ISCDBROK.

SAP IBROSTMP table

Table IBROSTMP technical data

TableIBROSTMP
Data storingISCD: Broker Report – Item Data
ModuleFS
Sub ModuleFS-CD
SAP PackageISCDBROK
Delivery ClassA – Application table (master and transaction data)
ComponentINSURANCE
Table CategoryTRANSP

SAP IBROSTMP 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 IBROSTMP table.

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • IDENT : Broker Report Identification
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • POSNUMB : Item Number for a Broker Report Item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • POSCAT : Category in the Broker Report
    Its data type is CHAR (Character String) with field length 2
  • SUBPOSNUMB : Assignment Key for Broker Report Item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • XSEL : Indicates Whether Selections Exist/Were Changed Manually
    Its data type is CHAR (Character String) with field length 1
  • XSELMULTIPL : Indicator: Multiple Groups in Selected Open Items
    Its data type is CHAR (Character String) with field length 1
  • XCOINS : Flag: Item Contains Coinsurance Shares
    Its data type is CHAR (Character String) with field length 1
  • POST_STATUS : Posting Status of Broker Report Item
    Its data type is CHAR (Character String) with field length 2
  • BROKER : Assigned Broker
    Its data type is CHAR (Character String) with field length 10
  • BROOBJ : Assigned Broker Contract
    Its data type is CHAR (Character String) with field length 20
  • PARTNER : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • INSOBJECT : Identification for an Insurance Object
    Its data type is CHAR (Character String) with field length 20
  • INSOBJECTTYP : IO: Internal Insurance Object Category
    Its data type is CHAR (Character String) with field length 2
  • ACCOUNT : Contract Account Number
    Its data type is CHAR (Character String) with field length 12
  • AMNTTR : Reported amount in transaction currency
    Its data type is CURR (Currency Field) with field length 13
  • AMNTH : Amount In Local Currency With +/- Signs
    Its data type is CURR (Currency Field) with field length 13
  • AMNTPROPTR : Default Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 13
  • AMNTPROPH : Default amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • QAMNTPROPTR : Withholding Tax to Be Transferred Acc. to Selected Items
    Its data type is CURR (Currency Field) with field length 13
  • SKTAMNTPROPTR : Cash Discount Amount Granted According to Selected Items
    Its data type is CURR (Currency Field) with field length 13
  • COAMNTPROPTR : Share for Participating Coinsurer
    Its data type is CURR (Currency Field) with field length 13
  • CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • EXCHRATE : Exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • FIKEY : Reconciliation Key for General Ledger
    Its data type is CHAR (Character String) with field length 12
  • COMPCODE : Company Code
    Its data type is CHAR (Character String) with field length 4
  • BUISAREA : Business Area
    Its data type is CHAR (Character String) with field length 4
  • CLEARACC : Premium/Benefit Clearing Account
    Its data type is CHAR (Character String) with field length 10
  • XBRTRCO : Flag: Broker Transfers Coinsurance Shares
    Its data type is CHAR (Character String) with field length 1
  • DOCTYPE : Document Type
    Its data type is CHAR (Character String) with field length 2
  • POSTDATE : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DOCDATE : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALDATE : Fixed Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CLEARREAS : Clearing Reason
    Its data type is CHAR (Character String) with field length 2
  • XCLARIFIED : Line item included in clarification worklist
    Its data type is CHAR (Character String) with field length 1
  • CLARREAS : Clarification Code
    Its data type is CHAR (Character String) with field length 2
  • CLARAMNTTR : Remaining Amount to Be Clarified in Transaction Currency
    Its data type is CURR (Currency Field) with field length 13
  • CLARAMNTH : Remaining amount to clarify in local currency
    Its data type is CURR (Currency Field) with field length 13
  • COMMAMNTTR : Remaining Amount on Commissions Account After Posting Item
    Its data type is CURR (Currency Field) with field length 13
  • COMMAMNTH : Remaining Amt (Local Curr.) on Comm. Acct After Posting Item
    Its data type is CURR (Currency Field) with field length 13
  • CLARACC : Clarification Account
    Its data type is CHAR (Character String) with field length 10
  • CLARCONTRACC : Subledger Clarification Account for Broker
    Its data type is CHAR (Character String) with field length 12
  • CLARDOC : Number of Generated Clarification Document
    Its data type is CHAR (Character String) with field length 12
  • CLARDOC2 : Number of Generated Clarification Document
    Its data type is CHAR (Character String) with field length 12
  • DOCNUMB : Number of created document
    Its data type is CHAR (Character String) with field length 12
  • DOCNUMB2 : Number of created document
    Its data type is CHAR (Character String) with field length 12
  • INFOFLD : Additional information
    Its data type is CHAR (Character String) with field length 30
  • XAPPDX : Indicator: Appendix (Note Object) Exists for Item
    Its data type is CHAR (Character String) with field length 1
  • XMOREDOC : Further Document Numbers Exist for Item
    Its data type is CHAR (Character String) with field length 1
  • XQUICK : Indicator: Item Created in Fast Entry
    Its data type is CHAR (Character String) with field length 1
  • QUENTRYIND : Broker Report: Line Indicator Fast Entry
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • CHNGNAME : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • CHNGDATE : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHNGTIME : Time at Which the Object Was Last Changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • .INCLUDE : Include: Selection Cats and Values in Broker Report Item
  • SELT1 : Selection Category for Broker Report
    Its data type is CHAR (Character String) with field length 1
  • SELV1 : Field value to be selected
    Its data type is CHAR (Character String) with field length 35
  • SELT2 : Selection Category for Broker Report
    Its data type is CHAR (Character String) with field length 1
  • SELV2 : Field value to be selected
    Its data type is CHAR (Character String) with field length 35
  • SELT3 : Selection Category for Broker Report
    Its data type is CHAR (Character String) with field length 1
  • SELV3 : Field value to be selected
    Its data type is CHAR (Character String) with field length 35
  • SELT4 : Selection Category for Broker Report
    Its data type is CHAR (Character String) with field length 1
  • SELV4 : Field value to be selected
    Its data type is CHAR (Character String) with field length 35
  • SELT5 : Selection Category for Broker Report
    Its data type is CHAR (Character String) with field length 1
  • SELV5 : Field value to be selected
    Its data type is CHAR (Character String) with field length 35
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes