WBRP

Settlement Management Document Item | #transactional | Component: Settlement Management
Column Name Description
MANDT FK Client
WBELN FK Document Number
POSNR Document Item
Column Name Description
NETPR Net Price in Document Currency
NETWR Net Amount of the Item in Document Currency
BRTWR Gross Amount of the Item in Document Currency
KZWI1 Subtotal 1 from Pricing Procedure for Price Element
KZWI2 Subtotal 2 from Pricing Procedure for Price Element
KZWI3 Subtotal 3 from Pricing Procedure for Price Element
KZWI4 Subtotal 4 from Pricing Procedure for Price Element
KZWI5 Subtotal 5 from Pricing Procedure for Price Element
KZWI6 Subtotal 6 from Pricing Procedure for Price Element
BONBA Rebate Basis 1
EFFWR Effective Amount of Item
SKFBP Amount eligible for cash discount in document currency
NETWRD Net Amount of the Item in Document Currency (Customer-Side)
BRTWRD Gross Amount of Item in Document Currency (Customer-Side)
KZWI1D Subtotal 1 from Pricing Procedure for Price Element
KZWI2D Subtotal 2 from Pricing Procedure for Price Element
KZWI3D Subtotal 3 from Pricing Procedure for Price Element
KZWI4D Subtotal 4 from Pricing Procedure for Price Element
KZWI5D Subtotal 5 from Pricing Procedure for Price Element
KZWI6D Subtotal 6 from Pricing Procedure for Price Element
BONBAD Rebate Basis 1
SKFBPD Amount Eligible for Cash Discount in Doc. Curr. (Cust.-Side)
EFFWRD Effective Value of the Item (Customer-Side)
MWSBPD Tax Amount in Document Currency (Customer-Side)
MWSBP Tax Amount in Document Currency
NAVNW Non-deductible input tax
MWERT_IM Inventory Value in Home Currency
MWERT_PR Price Difference Value in Home Currency
MWERT_UM Revaluation Value on Back-Posting to a Previous Period
GRWRT Statistical value for foreign trade
GRWRTD Statistical Value for Foreign Trade (Customer-Side)
Column Name Description
📏 Unit of Measure of Settlement Management Doc Item Quantity (WFKME):
MENGE Quantity of Settlement Management Document Item
📏 Weight Unit (GEWEI):
NTGEW Net Weight
BRGEW Gross Weight
📏 Volume unit (VOLEH):
VOLUM Volume
📏 Points Unit (PUNEI):
ANZPU Number of Points
📏 Parallel Unit of Measure (CWM_MEINS):
CWM_MENGE Quantity in Parallel Unit of Measure
📏 Unit of Measure of Settlement Doc Item Reference Quantity (REF_WFKME):
REF_MENGE Reference Quantity
Column Name Description
PRSDT Date for Pricing and Exchange Rate
ERDAT Date on which the record was created
ERZET Entry time
FBUDA Date of Services Rendered
_DATAAGING Data Filter Value for Data Aging
SETTL_DATE_I Rebates: Settlement Date
TXDAT_FROM_BV Valid-From Date of the Tax Rate from Business Volume
REF_SETTL_DATE_I Reference Date for a Delta Settlement
ACT_SETTL_DATE_I Actual Settlement Date
SETTL_START_DATE_I Start Date of Settlement Period
TXDAT_FROM_K Valid-From Date of the Supplier Tax Rate
TXDAT_FROM_D Valid-From Date of the Customer Tax Rate
Column Name Description
KOWRR Statistical Property of Settlement Management Item Show values
SKTOF Cash Discount Indicator Show values
LFTYPV Document Category of Source Document Show values
EBONF Item Relevant to Subsequent (Period-End Rebate) Settlement Show values
WUVPRS Indicator that Pricing Determination for Item is Incomplete Show values
FTYPV_V Document Category of Preceding Document Show values
ITEMCAT Item Category Show values
CONTRACT_TYPE Contract Category of Related Contract Show values
ITEM_STATUS Item Status Show values
ITEM_CANCELED Item Was Canceled Show values
SETTL_STATUS_I_V Settlement Status - Item - Supplier Show values
SETTL_STATUS_I_C Settlement Status - Item - Customer Show values
SETTL_ITEM_REL Item Settlement Relevance Show values
J_1BMATUSE Usage of the material Show values
J_1BMATORG Origin of the material Show values
J_1BOWNPRO Produced in-house Show values
J_1BINDUST Material CFOP category Show values
IV_CHECK_TYPE_I Type of Check (Item) Show values
SETTL_DATE_TYPE_I Rebates: Settlement Date Type Show values
POSNR_SUB_EXIST Subitems Exist Show values
DISTRIB_STATUS Status Distribution of Item Show values
NO_TEXT_I No Texts Exist Show values
CWM_UOM_TYPE Type of the Parallel Unit of Measure Show values
REF_TYPE Reference Document Category in Settlement Management Show values
ITEM_INTRA_REL Document Item is Relevant for Intrastat Declarations Show values
WEIGHT_VOLUME Level on which You Enter Weight and Volume Show values
COLL_STATUS_I Status for Collection of Settlement Document Item Show values
COLL_REL Collective Settlement Relevance of Settlement Documents Show values
REF_TYPE_2 Additional Reference Document Category Show values
Column Name Description Domain name
PEINH Price Unit of Settlement Management Document Item DEC5
UMREZ Numerator Converting Qty in Settlement Document to Base Unit UMBSZ
UMREN Denominator Converting Qty in Settlement Doc. to Base Unit UMBSN
FPUMZ Numerator for Converting Billing UoM to Billing Price UoM UMBSZ
FPUMN Denominator for Converting Billing UoM to Billing Price UoM UMBSZ
ERNAM Name of Person Responsible for Creating the Object USNAM
WBELNV Document Number of the Source Document CHAR10
POSNRV Item Number of the Source Document Item NUMC6
GJAHRV Fiscal Year GJAHR
ARKTX Short Text TEXT40
IDNLF Material Number Used by Supplier IDNEX
BONUS Settlement Group 1 (Purchasing) EBONU
EBON2 Settlement Group 2 (Rebate Settlement, Purchasing) EBONU
EBON3 Settlement Group 3 (Rebate Settlement, Purchasing) EBONU
EKKOL Condition Group with Supplier CHAR4
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
KOSTL Cost Center KOSTL
PRCTR Profit Center PRCTR
WBELN_V Preceding Document of the Settlement Management Document CHAR10
POSNR_V Preceding Document Item in the Settlement Management Doc. NUMC6
MATBF Material in Respect of Which Stock is Managed MATNR
CONTRACT Related Contract in the Settlement Management Doc. WCONTRACT
CONTRACT_ITEM Related Contract Item in the Settlement Management Doc. NUMC6
GUID_REF GUID of Reference Document
CUOBJ Configuration CUOBJ
ENTITY_TAG_ITEM Entity Tag of a Settlement Management Document Item WLF_ENTITY_TAG
DUMMY_WBRP_INCL_EEW_PS Dummy Data Element for Settlmt Mgmt Doc Item Extensibility WBRP_INCL_EEW
SERVCONF_ITEM FSL: Service Confirmation Item FSL_SERVCONF_ITEM
REFSITE Reference Site For Purchasing WERKS_W
GJAHR CCS: Fiscal Year of Settlement GJAHR
SETTL_DATE_SEQ_ID_I Settlement Date - Sequential ID WB2_SETTLEMENT_DATE_SEQ_ID
POSNR_MAIN Main Item for Item WPOSNR
REF_DOC_NR_1 Reference Document for Settlement Management WLF_REF_DOC_NUMBER
REF_DOC_YEAR_1 Year of Reference Document for Settlement Management GJAHR
REF_LOG_SYS_1 Logical System of Reference Document for Smt Mgmt LOGSYS
REF_ITEM_NUMBER Reference Document Item for Settlement Management Document WLF_REF_ITEM_NUMBER
REF_DOC_TYPE_1 Type of Reference Document for Settlement Management WLF_REF_DOC_TYPE
T2CCODE_CRCY_CONV_FACTOR_K Factor for Tax Amount in Company Code Currency FINS_T2ANY_CRCY_CONV_FACTOR
T2CNTRY_CRCY_CONV_FACTOR_K Factor for Calculating Tax Amount in Reporting Currency FINS_T2ANY_CRCY_CONV_FACTOR
T2CCODE_CRCY_CONV_FACTOR_D Factor for Calculating Amount in Co.Code Currency (Customer) FINS_T2ANY_CRCY_CONV_FACTOR
T2CNTRY_CRCY_CONV_FACTOR_D Factor for Calculating Tax Amount in Reporting Curr. (Cust.) FINS_T2ANY_CRCY_CONV_FACTOR
INCO2_P Incoterms (Part 2) INCO2
INCO2_L_P Incoterms Location 1 INCO_L
INCO3_L_P Incoterms Location 2 INCO_L
PAOBJNRD Customer Profitability Segment Number (CO-PA) RKEOBJNR
DISPUTE_CASE Dispute Case GUID SYSUUID_C
TXJCD_IC Tax Jurisdiction for Intercompany Posting TXJCD
STCEG_I Supplier VAT Registration Number STCEG
STCEGD_I Customer VAT Registration Number STCEG
INVC_ITEM_ID BusinessTransactionDocumentItemID CHAR10
REFERENCE_ID BusinessTransactionDocumentID
REF_ITEM_ID BusinessTransactionDocumentItemID CHAR10
SCHEME_ID Identifier for the ID Scheme CHAR60
SCHEME_A_ID ID of the Organization that Maintains the ID Scheme CHAR60
AGENCY_ID_CODE Agency of Standard ID for Invoice Document CHAR3
REF_DOC_NR_2 Additional Reference Document for Settlement Management WLF_REF_DOC_NUMBER
REF_DOC_YEAR_2 Year of Additional Reference Document for Smt Mgmt GJAHR
REF_LOG_SYS_2 Logical System of Additional Reference Document for Smt Mgmt LOGSYS
REF_ITEM_NUM_2 Additional Reference Doc Item for Settlement Mgmt. Document WLF_REF_ITEM_NUMBER
REF_DOC_TYPE_2 Type of Additional Reference Document for Settlmt Mgmt WLF_REF_DOC_TYPE
Master Data Relations Join Conditions
Promotion
  • Promotion
  • Client
  • WBRP.AKTNR == WAKH.AKTNR
  • WBRP.MANDT == WAKH.MANDT
Order Number
  • Order Number
  • Client
  • WBRP.AUFNR == AUFK.AUFNR
  • WBRP.MANDT == AUFK.MANDT
Order for Customer related Account Assignment
  • Order for Customer related Account Assignment
  • Client
  • WBRP.AUFNRD == AUFK.AUFNR
  • WBRP.MANDT == AUFK.MANDT
Accounting Indicator
  • WBRP.MANDT == TBMOT.MANDT
  • WBRP.BEMOT == TBMOT.BEMOT
Company Code
  • WBRP.MANDT == T001.MANDT
  • WBRP.BUKRS_I == T001.BUKRS
Valuation Type
  • WBRP.MANDT == T149D.MANDT
  • WBRP.BWTAR == T149D.BWTAR
Valuation Category
  • Valuation Category
  • Client
  • WBRP.BWTTY == T149C.BWTTY
  • WBRP.MANDT == T149C.MANDT
Batch Number
  • Material Number
  • Client
  • Batch Number
  • WBRP.MATNR == MCH1.MATNR
  • WBRP.MANDT == MCH1.MANDT
  • WBRP.CHARG == MCH1.CHARG
Reason for Collective Settlement Item Block
  • Reason for Collective Settlement Item Block
  • Client
  • WBRP.COLL_BLOCK_I == TMSB.SETTLEMENT_BLOCK
  • WBRP.MANDT == TMSB.MANDT
Condition Contract Type
Customer
  • WBRP.MANDT == KNA1.MANDT
  • WBRP.CUSTOMER == KNA1.KUNNR
Settlement Management Document Item Price Unit
  • WBRP.MANDT == T006.MANDT
  • WBRP.FPRME == T006.MSEHI
Weight Unit
  • WBRP.MANDT == T006.MANDT
  • WBRP.GEWEI == T006.MSEHI
Business Area
  • WBRP.MANDT == TGSB.MANDT
  • WBRP.GSBER == TGSB.GSBER
Customer Business Area
  • WBRP.MANDT == TGSB.MANDT
  • WBRP.GSBERD == TGSB.GSBER
Identification Object Type for Material
  • WBRP.MANDT == TMVMT.MANDT
  • WBRP.IDNLF_TYPE == TMVMT.IDNLF_TYPE
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • WBRP.INCO1_P == TINC.INCO1
  • WBRP.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • WBRP.INCOV_P == TINCV.INCOV
  • WBRP.MANDT == TINCV.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • WBRP.INFNR == EINA.INFNR
  • WBRP.MANDT == EINA.MANDT
CFOP Code and Extension
  • CFOP Code and Extension
  • Client
Brazilian NCM Code
  • Brazilian NCM Code
  • Client
  • ?
  • WBRP.J_1BNBM == T604F.STEUC
  • WBRP.MANDT == T604F.MANDT
  • WBRP.[column in domain "LAND1"] == T604F.LAND1
Tax law: ICMS
Tax law: IPI
ISS Tax Law
  • ISS Tax Law
  • Client
COFINS Tax Law
PIS Tax Law
SD tax code
Controlling Area
  • WBRP.MANDT == TKA01.MANDT
  • WBRP.KOKRS == TKA01.KOKRS
Customer Controlling Area
  • WBRP.MANDT == TKA01.MANDT
  • WBRP.KOKRSD == TKA01.KOKRS
Prior Supplier
  • WBRP.MANDT == LFA1.MANDT
  • WBRP.KOLIF == LFA1.LIFNR
Material Price Group
  • WBRP.MANDT == T178.MANDT
  • WBRP.KONDM == T178.KONDM
Customer Cost Center
  • Date for Pricing and Exchange Rate
  • Customer Cost Center
  • Customer Controlling Area
  • WBRP.MANDT == CSKS.MANDT
  • WBRP.PRSDT == CSKS.DATBI
  • WBRP.KOSTLD == CSKS.KOSTL
  • WBRP.KOKRSD == CSKS.KOKRS
Settlement Condition Type
  • Settlement Condition Type
  • Client
  • ?
  • ?
  • WBRP.KSCHL_SETTLEMENT == T685.KSCHL
  • WBRP.MANDT == T685.MANDT
  • WBRP.[column in domain "KVEWE"] == T685.KVEWE
  • WBRP.[column in domain "KAPPL"] == T685.KAPPL
Tax Destination Country/Region
  • Tax Destination Country/Region
  • Client
  • WBRP.LAND1TX_I == T005.LAND1
  • WBRP.MANDT == T005.MANDT
Tax Departure Country/Region
  • Tax Departure Country/Region
  • Client
  • WBRP.LANDTX_I == T005.LAND1
  • WBRP.MANDT == T005.MANDT
Activity Reason for Document Creation
  • Activity Reason for Document Creation
  • Client
  • WBRP.LFGRU == TMLFG.LFGRU
  • WBRP.MANDT == TMLFG.MANDT
Supplier Subrange
  • Supplier Subrange
  • Prior Supplier
  • Client
  • WBRP.LTSNR == WYT1.LTSNR
  • WBRP.KOLIF == WYT1.LIFNR
  • WBRP.MANDT == WYT1.MANDT
Client WBRP.MANDT == T000.MANDT
Material Group
  • WBRP.MANDT == T023.MANDT
  • WBRP.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • WBRP.MATNR == MARA.MATNR
  • WBRP.MANDT == MARA.MANDT
Base Unit of Measure
  • WBRP.MANDT == T006.MANDT
  • WBRP.MEINS == T006.MSEHI
Material type
  • WBRP.MANDT == T134.MANDT
  • WBRP.MTART == T134.MTART
Material Group 1
  • Material Group 1
  • Client
  • WBRP.MVGR1 == TVM1.MVGR1
  • WBRP.MANDT == TVM1.MANDT
Material Group 2
  • Material Group 2
  • Client
  • WBRP.MVGR2 == TVM2.MVGR2
  • WBRP.MANDT == TVM2.MANDT
Material Group 3
  • WBRP.MANDT == TVM3.MANDT
  • WBRP.MVGR3 == TVM3.MVGR3
Material Group 4
  • WBRP.MANDT == TVM4.MANDT
  • WBRP.MVGR4 == TVM4.MVGR4
Material Group 5
  • WBRP.MANDT == TVM5.MANDT
  • WBRP.MVGR5 == TVM5.MVGR5
Tax Code (Output Tax)
  • ?
  • Tax Code (Output Tax)
  • WBRP.MANDT == T007A.MANDT
  • WBRP.[column in domain "KALSM_D"] == T007A.KALSM
  • WBRP.MWSK2 == T007A.MWSKZ
Tax Code (Input Tax)
  • ?
  • Tax Code (Input Tax)
  • WBRP.MANDT == T007A.MANDT
  • WBRP.[column in domain "KALSM_D"] == T007A.KALSM
  • WBRP.MWSKZ == T007A.MWSKZ
Tax Code from Business Volume
  • ?
  • Tax Code from Business Volume
  • WBRP.MANDT == T007A.MANDT
  • WBRP.[column in domain "KALSM_D"] == T007A.KALSM
  • WBRP.MWSKZ_BV == T007A.MWSKZ
Debtor Posting Rule - Item
  • WBRP.MANDT == TMPR.MANDT
  • WBRP.POSTING_RULE_D_I == TMPR.POSTING_RULE
Creditor Posting Rule - Item
  • WBRP.MANDT == TMPR.MANDT
  • WBRP.POSTING_RULE_K_I == TMPR.POSTING_RULE
Alternative Customer Profit Center
  • Date for Pricing and Exchange Rate
  • Customer Controlling Area
  • Alternative Customer Profit Center
  • WBRP.MANDT == CEPC.MANDT
  • WBRP.PRSDT == CEPC.DATBI
  • WBRP.KOKRSD == CEPC.KOKRS
  • WBRP.PRCTRD == CEPC.PRCTR
Condition Contract Process Variant
Product hierarchy
  • Product hierarchy
  • Client
  • WBRP.PRODH == T179.PRODH
  • WBRP.MANDT == T179.MANDT
Commission Group
  • Commission Group
  • Client
  • WBRP.PROVG == TVPR.PROVG
  • WBRP.MANDT == TVPR.MANDT
Points Unit
  • WBRP.MANDT == T006.MANDT
  • WBRP.PUNEI == T006.MSEHI
Sales Volume Rebate Group
  • Sales Volume Rebate Group
  • Client
  • WBRP.REBATE_GRP == TVBO.BONUS
  • WBRP.MANDT == TVBO.MANDT
Company Code of Reference Document for Settlement Management
  • WBRP.MANDT == T001.MANDT
  • WBRP.REF_COMPANY_CODE_1 == T001.BUKRS
Unit of Measure of Settlement Doc Item Reference Quantity
  • WBRP.MANDT == T006.MANDT
  • WBRP.REF_WFKME == T006.MSEHI
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • WBRP.[column in domain "KTOPL"] == SKA1.KTOPL
  • WBRP.MANDT == SKA1.MANDT
  • WBRP.SAKTO == SKA1.SAKNR
Reason for Customer Settlement Block at Item
  • Reason for Customer Settlement Block at Item
  • Client
  • WBRP.SETTL_BLOCK_I_C == TMSB.SETTLEMENT_BLOCK
  • WBRP.MANDT == TMSB.MANDT
Reason for Supplier Settlement Block at Item
  • Reason for Supplier Settlement Block at Item
  • Client
  • WBRP.SETTL_BLOCK_I_V == TMSB.SETTLEMENT_BLOCK
  • WBRP.MANDT == TMSB.MANDT
Division
  • WBRP.MANDT == TSPA.MANDT
  • WBRP.SPART_I == TSPA.SPART
Update Group for statistics update
  • WBRP.MANDT == TMCB.MANDT
  • WBRP.STAFO == TMCB.STAFO
FSL: User Status for Item
  • FSL: User Status for Item
  • Client
Tax Reporting Country/Region
  • Tax Reporting Country/Region
  • Client
  • WBRP.TAX_COUNTRY == T005.LAND1
  • WBRP.MANDT == T005.MANDT
Tax Reporting Country/Region for Intercompany Processes
  • Tax Reporting Country/Region for Intercompany Processes
  • Client
  • WBRP.TAX_COUNTRY_IC == T005.LAND1
  • WBRP.MANDT == T005.MANDT
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • WBRP.MANDT == TTXJ.MANDT
  • WBRP.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • WBRP.TXJCD == TTXJ.TXJCD
Sales Organization
  • WBRP.MANDT == TVKO.MANDT
  • WBRP.VKORG_I == TVKO.VKORG
Volume unit
  • WBRP.MANDT == T006.MANDT
  • WBRP.VOLEH == T006.MSEHI
Distribution Channel
  • Distribution Channel
  • Client
  • WBRP.VTWEG_I == TVTW.VTWEG
  • WBRP.MANDT == TVTW.MANDT
Currency from Business Volume
  • WBRP.MANDT == TCURC.MANDT
  • WBRP.WAERS_BV == TCURC.WAERS
Plant
  • WBRP.MANDT == T001W.MANDT
  • WBRP.WERKS == T001W.WERKS
Unit of Measure of Settlement Management Doc Item Quantity
  • WBRP.MANDT == T006.MANDT
  • WBRP.WFKME == T006.MSEHI