SAP table IBROSTMP (ISCD: Broker Report - Item Data)

SAP table IBROSTMP has 3 primary key fields being CLIENT,IDENT,POSNUMB.

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

IBROSTMP foreign key relationships

Table Field Check Table Check Field
0 IBROSTMP BUISAREA TGSB Business Areas MANDT
0 IBROSTMP BUISAREA TGSB Business Areas GSBER
1 IBROSTMP CHGRS TIBRBRITEMCHGRS Broker Collections: Change Reasons Broker Report Items MANDT
0 IBROSTMP CLARREAS TIBRCLARREAS Clarification Codes for Broker Report CLARREAS
1 IBROSTMP CLEARACC SKB1 G/L account master (company code) MANDT
1 IBROSTMP CLEARACC SKB1 G/L account master (company code) BUKRS
0 IBROSTMP CLEARREAS TFK001A Clearing Reasons AUGRD
1 IBROSTMP COMPCODE T001 Company Codes BUKRS
0 IBROSTMP CURR TCURC Currency Codes MANDT
0 IBROSTMP CURR TCURC Currency Codes WAERS
1 IBROSTMP SELT1 TIBRSELTYP Selection Categories for Broker Report SELTX
0 IBROSTMP SELT2 TIBRSELTYP Selection Categories for Broker Report SELTX
1 IBROSTMP SELT3 TIBRSELTYP Selection Categories for Broker Report SELTX
0 IBROSTMP SELT4 TIBRSELTYP Selection Categories for Broker Report SELTX
1 IBROSTMP SELT5 TIBRSELTYP Selection Categories for Broker Report SELTX
0 IBROSTMP SUBPOSCAT TIBRSUBPOSCAT Broker Collections: Subcategories MANDT
0 IBROSTMP SUBPOSCAT TIBRSUBPOSCAT Broker Collections: Subcategories POSCAT
0 IBROSTMP SUBPOSCAT TIBRSUBPOSCAT Broker Collections: Subcategories SUBPOSCAT