1. Home
  2. Resources
  3. SAP Tables
  4. IBROSTMP - ISCD: Broker Report - Item Data

SAP Table IBROSTMP

ISCD: Broker Report - Item Data

IBROSTMP (ISCD: Broker Report - Item Data) 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 IBROSTMP to other SAP tables.

IBROSTMP table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT CLNT 3 0
IDENT Broker Report Identification STMIDENT_BRO CHAR 12 0
POSNUMB Item Number for a Broker Report Item POSNUMB_BRO NUMC 6 0
POSCAT Category in the Broker Report POSCAT_BRO CHAR 2 0
SUBPOSCAT Subcategory in the Broker Report SUBPOSCAT_BRO TIBRSUBPOSCAT CHAR 2 0
SUBPOSNUMB Assignment Key for Broker Report Item SUBPOSNUMB_BRO NUMC 6 0
XSEL Indicates Whether Selections Exist/Were Changed Manually SELFLAG_BRO CHAR 1 0
X Selections exist
U Selection exists amd changed manually
NULL No selections exist
XSELMULTIPL Indicator: Multiple Groups in Selected Open Items SELFLAG_MULTI_BRO CHAR 1 0
XCOINS Flag: Item Contains Coinsurance Shares XCOINS_BRO CHAR 1 0
X Yes
NULL No
POST_STATUS Posting Status of Broker Report Item POST_STAT_BRO CHAR 2 0
NULL Not Posted
02 Item is Posted and Needs to Be Reworked
03 Completely Posted
04 Reversed
90 Not Posted, Taxes (Italy) Must Be Recalculated First
CONF_STATUS Broker Report with Web: Confirmation Status Broker Rep. Item CONF_STAT_BRO CHAR 1 0
NULL Open
1 Confirmed
2 Confirmed with Changes
3 Rejected
4 New
BROKER Assigned Broker ASSGNBROKERPA_BRO CHAR 10 0
BROOBJ Assigned Broker Contract ASSGNBROOBJ_BRO CHAR 20 0
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
INSOBJECT Identification for an Insurance Object INSOBJECT_MD CHAR 20 0
INSOBJECTTYP IO: Internal Insurance Object Category INSOBJECTTYP_MD CHAR 2 0
ACCOUNT Contract Account Number VKONT_KK CHAR 12 0
AMNTTR Reported amount in transaction currency AMNTTR_BRO CURR 13 2
AMNTH Amount In Local Currency With +/- Signs BETRH_KK CURR 13 2
AMNTPROPTR Default Amount in Transaction Currency AMNTPROPTR_BRO CURR 13 2
AMNTPROPTR_ORIG Initial Proposed Amount in Transaction Currency AMNTPROPTR_ORIG_BRO CURR 13 2
AMNTPROPH Default amount in local currency AMNTPROPH_BRO CURR 13 2
QAMNTPROPTR Withholding Tax to Be Transferred Acc. to Selected Items QAMNTPROPTR_BRO CURR 13 2
SKTAMNTPROPTR Cash Discount Amount Granted According to Selected Items SKTAMNTPROPTR_BRO CURR 13 2
COAMNTPROPTR Share for Participating Coinsurer COAMNTPROPTR_BRO CURR 13 2
CURR Currency Key WAERS TCURC CUKY 5 0
CURR_ORIG Broker Report: Initial Proposed Currency CURR_PROP_ORIG_BRO CUKY 5 0
EXCHRATE Exchange rate KURSF DEC 9 5
FIKEY Reconciliation Key for General Ledger FIKEY_KK CHAR 12 0
COMPCODE Company Code BUKRS T001 CHAR 4 0
BUISAREA Business Area GSBER TGSB CHAR 4 0
CLEARACC Premium/Benefit Clearing Account CLEARACC_BRO SKB1 CHAR 10 0
XBRTRCO Flag: Broker Transfers Coinsurance Shares XBRTRCO_BRO CHAR 1 0
X Yes
NULL No
DOCTYPE Document Type BLART_KK TFK003 CHAR 2 0
POSTDATE Posting Date in the Document BUDAT_KK DATS 8 0
DOCDATE Document Date in Document BLDAT DATS 8 0
VALDATE Value date VALUT DATS 8 0
CLEARREAS Clearing Reason AUGRD_KK TFK001A CHAR 2 0
XCLARIFIED Line item included in clarification worklist XCLAR_KK CHAR 1 0
X Yes
NULL No
CLARREAS Clarification Code CLARREAS_BRO TIBRCLARREAS CHAR 2 0
CLARAMNTTR Remaining Amount to Be Clarified in Transaction Currency CLARAMNTTR_BRO CURR 13 2
CLARAMNTH Remaining amount to clarify in local currency CLARAMNTH_BRO CURR 13 2
COMMAMNTTR Remaining Amount on Commissions Account After Posting Item COMMAMNTTR_BRO CURR 13 2
COMMAMNTH Remaining Amt (Local Curr.) on Comm. Acct After Posting Item COMMAMNTH_BRO CURR 13 2
CLARACC Clarification Account CLARACC_BRO CHAR 10 0
CLARCONTRACC Subledger Clarification Account for Broker CLARCONTRACC_BRO CHAR 12 0
CLARDOC Number of Generated Clarification Document CLARDOC_BRO CHAR 12 0
CLARDOC2 Number of Generated Clarification Document CLARDOC_BRO CHAR 12 0
DOCNUMB Number of created document DOCNUMB_BRO CHAR 12 0
DOCNUMB2 Number of created document DOCNUMB_BRO CHAR 12 0
INFOFLD Additional information INFOFLD_BRO CHAR 30 0
XAPPDX Indicator: Appendix (Note Object) Exists for Item XAPPDX_BRO CHAR 1 0
X Yes
NULL No
XMOREDOC Further Document Numbers Exist for Item XDOC_BRO CHAR 1 0
X Yes
NULL No
XQUICK Indicator: Item Created in Fast Entry XQUICK_BRO CHAR 1 0
X Yes
NULL No
XWDWORKLIST Item in Web Dynpro Worklist XWDWORKLIST_BRO CHAR 1 0
X Yes
NULL No
QUENTRYIND Broker Report: Line Indicator Fast Entry QUENTRYIND_BRO NUMC 6 0
CHGRS Change Reason for Broker Report Item CHGRS_BRITEM_BRO TIBRBRITEMCHGRS CHAR 3 0
CHNGNAME Name of Person Who Changed Object AENAM CHAR 12 0
CHNGDATE Changed On AEDAT DATS 8 0
CHNGTIME Time at Which the Object Was Last Changed AETIM_KK TIMS 6 0
PROCINFO Processing Info PROCINFO_BRO CHAR 50 0
SELT1 Selection Category for Broker Report SELT_BRO TIBRSELTYP CHAR 1 0
SELV1 Field value to be selected SELWC_KK CHAR 35 0
SELT2 Selection Category for Broker Report SELT_BRO TIBRSELTYP CHAR 1 0
SELV2 Field value to be selected SELWC_KK CHAR 35 0
SELT3 Selection Category for Broker Report SELT_BRO TIBRSELTYP CHAR 1 0
SELV3 Field value to be selected SELWC_KK CHAR 35 0
SELT4 Selection Category for Broker Report SELT_BRO TIBRSELTYP CHAR 1 0
SELV4 Field value to be selected SELWC_KK CHAR 35 0
SELT5 Selection Category for Broker Report SELT_BRO TIBRSELTYP CHAR 1 0
SELV5 Field value to be selected SELWC_KK CHAR 35 0

IBROSTMP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
IBROSTMP BUISAREA IBROSTMP CLIENT TGSB Business Areas MANDT
IBROSTMP BUISAREA IBROSTMP BUISAREA TGSB Business Areas GSBER
IBROSTMP CHGRS IBROSTMP CLIENT TIBRBRITEMCHGRS Broker Collections: Change Reasons Broker Report Items MANDT
IBROSTMP CHGRS IBROSTMP CHGRS TIBRBRITEMCHGRS Broker Collections: Change Reasons Broker Report Items CHGRS
IBROSTMP CLARREAS IBROSTMP CLARREAS TIBRCLARREAS Clarification Codes for Broker Report CLARREAS
IBROSTMP CLARREAS IBROSTMP CLIENT TIBRCLARREAS Clarification Codes for Broker Report CLIENT
IBROSTMP CLEARACC IBROSTMP CLIENT SKB1 G/L account master (company code) MANDT
IBROSTMP CLEARACC IBROSTMP COMPCODE SKB1 G/L account master (company code) BUKRS
IBROSTMP CLEARACC IBROSTMP CLEARACC SKB1 G/L account master (company code) SAKNR
IBROSTMP CLEARREAS IBROSTMP CLEARREAS TFK001A Clearing Reasons AUGRD
IBROSTMP COMPCODE IBROSTMP CLIENT T001 Company Codes MANDT
IBROSTMP COMPCODE IBROSTMP COMPCODE T001 Company Codes BUKRS
IBROSTMP CURR IBROSTMP CURR TCURC Currency Codes WAERS
IBROSTMP CURR IBROSTMP CLIENT TCURC Currency Codes MANDT
IBROSTMP DOCTYPE IBROSTMP CLIENT TFK003 Document types MANDT
IBROSTMP DOCTYPE IBROSTMH APPLC TFK003 Document types APPLK
IBROSTMP DOCTYPE IBROSTMP DOCTYPE TFK003 Document types BLART
IBROSTMP SELT1 SYST MANDT TIBRSELTYP Selection Categories for Broker Report CLIENT
IBROSTMP SELT1 IBROSTMP SELT1 TIBRSELTYP Selection Categories for Broker Report SELTX
IBROSTMP SELT2 SYST MANDT TIBRSELTYP Selection Categories for Broker Report CLIENT
IBROSTMP SELT2 IBROSTMP SELT2 TIBRSELTYP Selection Categories for Broker Report SELTX
IBROSTMP SELT3 IBROSTMP SELT3 TIBRSELTYP Selection Categories for Broker Report SELTX
IBROSTMP SELT3 SYST MANDT TIBRSELTYP Selection Categories for Broker Report CLIENT
IBROSTMP SELT4 SYST MANDT TIBRSELTYP Selection Categories for Broker Report CLIENT
IBROSTMP SELT4 IBROSTMP SELT4 TIBRSELTYP Selection Categories for Broker Report SELTX
IBROSTMP SELT5 SYST MANDT TIBRSELTYP Selection Categories for Broker Report CLIENT
IBROSTMP SELT5 IBROSTMP SELT5 TIBRSELTYP Selection Categories for Broker Report SELTX
IBROSTMP SUBPOSCAT IBROSTMP CLIENT TIBRSUBPOSCAT Broker Collections: Subcategories MANDT
IBROSTMP SUBPOSCAT IBROSTMP POSCAT TIBRSUBPOSCAT Broker Collections: Subcategories POSCAT
IBROSTMP SUBPOSCAT IBROSTMP SUBPOSCAT TIBRSUBPOSCAT Broker Collections: Subcategories SUBPOSCAT