SAP WBRP Settlement Management Document Item Table

Overview

WBRP is a standard SAP S/4HANA table that stores Settlement Management Document Item data. There are total 207 fields in the WBRP table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table WBRP belongs to Settlement Management (LO-AB) module and is located in the package Settlement Management (Main Package) (WZRE).

In addition, following links provide an overview of foreign key relationships, if any, that link WBRP to other SAP tables and standard CDS views available based on WBRP table in S/4HANA 2020.

Techincal Settings of WBRP

Below are technical details of the table WBRP

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of WBRP Fields

The following table gives you an overview of the fields available in WBRP

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
WBELNDocument NumberWBELN_AGWBRKCHAR10
POSNRDocument ItemWPOSNR_LFNUMC6
MATNRMaterial NumberMATNRMARACHAR40
MATKLMaterial GroupMATKLT023CHAR9
WERKSPlantWERKS_DT001WCHAR4
MWSKZTax Code (Input Tax)MWSKZ_LFT007ACHAR2
MWSK2Tax Code (Output Tax)MWSKZ_RBT007ACHAR2
PRSDTDate for Pricing and Exchange RatePRSDTDATS8
MENGEQuantity of Settlement Management Document ItemWFIMGQUAN13
NETPRNet Price in Document CurrencyWNETPRCURR11
PEINHPrice Unit of Settlement Management Document ItemWEINHDEC5
WFKMEUnit of Measure of Settlement Management Doc Item QuantityWFKMET006UNIT3
UMREZNumerator Converting Qty in Settlement Document to Base UnitUMWFZDEC5
UMRENDenominator Converting Qty in Settlement Doc. to Base UnitUMWFNDEC5
FPRMESettlement Management Document Item Price UnitWFPRMET006UNIT3
FPUMZNumerator for Converting Billing UoM to Billing Price UoMWPUMZDEC5
FPUMNDenominator for Converting Billing UoM to Billing Price UoMWPUMNDEC5
MEINSBase Unit of MeasureMEINST006UNIT3
NTGEWNet WeightWLF_NTGEW_15QUAN15
BRGEWGross WeightWLF_BRGEW_15QUAN15
GEWEIWeight UnitGEWEIT006UNIT3
VOLUMVolumeWLF_VOLUM_15QUAN15
VOLEHVolume unitVOLEHT006UNIT3
STAFOUpdate Group for statistics updateSTAFOTMCBCHAR6
MTARTMaterial typeMTARTT134CHAR4
NETWRNet Amount of the Item in Document CurrencyNETWR_LFPCURR15
BRTWRGross Amount of the Item in Document CurrencyBRTWR_LFPCURR15
KZWI1Subtotal 1 from pricing procedure for conditionKZWI1CURR13
KZWI2Subtotal 2 from pricing procedure for conditionKZWI2CURR13
KZWI3Subtotal 3 from pricing procedure for conditionKZWI3CURR13
KZWI4Subtotal 4 from pricing procedure for conditionKZWI4CURR13
KZWI5Subtotal 5 from pricing procedure for conditionKZWI5CURR13
KZWI6Subtotal 6 from pricing procedure for conditionKZWI6CURR13
BONBARebate basis 1BONBACURR13
EFFWREffective Amount of ItemWLF_EFFWRCURR13
ERNAMName of Person who Created the ObjectERNAMCHAR12
ERDATDate on which the record was createdERDATDATS8
ERZETEntry timeERZETTIMS6
KOWRRStatistical Property of Settlement Management ItemWKOWRRCHAR1
SKTOFCash discount indicatorSKTOFCHAR1
SKFBPAmount eligible for cash discount in document currencySKFBPCURR13
NETWRDNet Amount of the Item in Document Currency (Customer-Side)NETWRD_LFPCURR15
BRTWRDGross Amount of Item in Document Currency (Customer-Side)BRTWRD_LFPCURR15
KZWI1DSubtotal 1 from pricing procedure for conditionKZWI1CURR13
KZWI2DSubtotal 2 from pricing procedure for conditionKZWI2CURR13
KZWI3DSubtotal 3 from pricing procedure for conditionKZWI3CURR13
KZWI4DSubtotal 4 from pricing procedure for conditionKZWI4CURR13
KZWI5DSubtotal 5 from pricing procedure for conditionKZWI5CURR13
KZWI6DSubtotal 6 from pricing procedure for conditionKZWI6CURR13
BONBADRebate basis 1BONBACURR13
SKFBPDAmount Eligible for Cash Discount in Doc. Curr. (Cust.-Side)SKFBPDCURR13
EFFWRDEffective Value of the Item (Customer-Side)EFFWRDCURR13
MWSBPDTax Amount in Document Currency (Customer-Side)MWSBPDCURR13
WBELNVDocument Number of the Source DocumentWBELNVCHAR10
POSNRVItem Number of the Source Document ItemWPOSNRVNUMC6
LFTYPVDocument Category of Source DocumentWFTYPVCHAR2
GJAHRVFiscal YearGJAHRNUMC4
AKTNRPromotionWAKTIONWAKHCHAR10
LFGRUActivity Reason for Document CreationWFGRUTMLFGCHAR3
ARKTXShort TextTXZ01CHAR40
INFNRNumber of purchasing info recordINFNREINACHAR10
IDNLFMaterial Number Used by SupplierIDNLFCHAR35
MWSBPTax amount in document currencyMWSBPCURR13
TXJCDTax JurisdictionTXJCDTTXJCHAR15
EBONFItem Relevant to Subsequent (Period-End Rebate) SettlementEBONYCHAR1
BONUSSettlement Group 1 (Purchasing)EBONUCHAR2
EBON2Settlement Group 2 (Rebate Settlement Purchasing)EBON2CHAR2
EBON3Settlement Group 3 (Rebate Settlement Purchasing)EBON3CHAR2
LTSNRSupplier SubrangeLTSNRWYT1CHAR6
EKKOLCondition Group with SupplierEKKOGCHAR4
PUNEIPoints UnitPUNEIT006UNIT3
ANZPUNumber of PointsANZPUQUAN13
KOLIFPrior SupplierKOLIFLFA1CHAR10
NAVNWNon-deductible input taxNAVNWCURR13
BWTARValuation TypeBWTAR_DT149DCHAR10
BWTTYValuation CategoryBWTTY_DT149CCHAR1
GSBERBusiness AreaGSBERTGSBCHAR4
PAOBJNRProfitability Segment Number (CO-PA)RKEOBJNRNUMC10
KOSTLCost CenterKOSTLCHAR10
PRCTRProfit CenterPRCTRCHAR10
KOKRSControlling AreaKOKRSTKA01CHAR4
CHARGBatch NumberCHARG_DMCH1CHAR10
WUVPRSIndicator that Pricing Determination for Item is IncompleteWUVPRSCHAR1
WBELN_VPreceding Document of the Settlement Management DocumentWBELN_VCHAR10
POSNR_VPreceding Document Item in the Settlement Management Doc.POSNR_VNUMC6
FTYPV_VDocument Category of Preceding DocumentWFTYP_VCHAR2
ITEMCATItem CategoryWSHKZGCHAR1
MATBFMaterial in Respect of Which Stock is ManagedMATBFCHAR40
MWERT_IMInventory Value in Home CurrencyWLF_MWERT_IMCURR15
MWERT_PRPrice Difference Value in Home CurrencyWLF_MWERT_PRCURR15
MWERT_UMRevaluation Value on Back-Posting to a Previous PeriodWLF_MWERT_UMCURR15
CONTRACTRelated Contract in the Settlement Management Doc.WCONTRACTCHAR10
CONTRACT_TYPEContract Category of Related ContractWCONTRACT_TYPECHAR1
CONTRACT_ITEMRelated Contract Item in the Settlement Management Doc.WCONTRACT_ITEMNUMC6
IDNLF_TYPEIdentification Object Type for MaterialWLF_IDNLF_TYPETMVMTCHAR4
ITEM_STATUSItem StatusWLF_ITEM_STATUSCHAR1
ITEM_CANCELEDItem Was CanceledWLF_ITEM_CANCELEDCHAR1
BEMOTAccounting IndicatorBEMOTTBMOTCHAR2
AUFNROrder NumberAUFNRAUFKCHAR12
SETTL_STATUS_I_VSettlement Status - Item - SupplierWLF_SETTLEMENT_STATUS_ITEM_VCHAR1
SETTL_STATUS_I_CSettlement Status - Item - CustomerWLF_SETTLEMENT_STATUS_ITEM_CCHAR1
SETTL_BLOCK_I_VReason for Supplier Settlement Block at ItemWLF_SETTLEMENT_BLOCK_ITEM_VTMSBCHAR2
SETTL_BLOCK_I_CReason for Customer Settlement Block at ItemWLF_SETTLEMENT_BLOCK_ITEM_CTMSBCHAR2
SETTL_ITEM_RELItem Settlement RelevanceWLF_SETTLEMENT_ITEM_RELEVANCECHAR1
CUOBJConfigurationCUOBJ_VANUMC18
FBUDADate of Services RenderedWLF_FBUDADATS8
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS8
ENTITY_TAG_ITEMEntity Tag of a Settlement Management Document ItemWLF_ENTITY_TAG_ITEMNUMC4
DUMMY_WBRP_INCL_EEW_PSDummy Data Element for Settlmt Mgmt Doc Item ExtensibilityWBRP_INCL_EEWCHAR1
J_1BNBMBrazilian NCM CodeJ_1BNBMCO1T604FCHAR16
J_1BMATUSEUsage of the materialJ_1BMATUSECHAR1
J_1BMATORGOrigin of the materialJ_1BMATORGCHAR1
J_1BOWNPROProduced in-houseJ_1BOWNPROCHAR1
J_1BINDUSTMaterial CFOP categoryJ_1BINDUS3CHAR2
J_1BCFOPCFOP Code and ExtensionJ_1BCFOPJ_1BAGCHAR10
J_1BTXSDCSD tax codeJ_1BTXSDC_J_1BTXSDCCHAR2
J_1BTAXLW1Tax law: ICMSJ_1BTAXLW1J_1BATL1CHAR3
J_1BTAXLW2Tax law: IPIJ_1BTAXLW2J_1BATL2CHAR3
J_1BTAXLW3ISS Tax LawJ_1BTAXLW3J_1BATL3CHAR3
J_1BTAXLW4COFINS Tax LawJ_1BTAXLW4J_1BATL4ACHAR3
J_1BTAXLW5PIS Tax LawJ_1BTAXLW5J_1BATL5CHAR3
SAKTOG/L Account NumberSAKNRSKA1CHAR10
SERVCONF_ITEMFSL: Service Confirmation ItemFSL_SERVCONF_ITEMNUMC10
STATUSFSL: User Status for ItemFSL_STATUSFSL_STAT_CUSTCHAR4
IV_CHECK_TYPE_IType of Check (Item)WLF_IV_CHECK_TYPE_ITEMCHAR1
REFSITEReference Site For PurchasingWREFSITECHAR4
GJAHRCCS: Fiscal Year of SettlementWB2_CCS_GJAHRNUMC4
MWSKZ_BVTax Code from Business VolumeWB2_MWSKZ_BVT007ACHAR2
SETTL_DATE_IRebates: Settlement DateWB2_SETTLEMENT_DATEDATS8
SETTL_DATE_SEQ_ID_ISettlement Date - Sequential IDWB2_SETTLEMENT_DATE_SEQ_IDNUMC1
WAERS_BVCurrency from Business VolumeWB2_WAERS_BVTCURCCUKY5
CONTR_TYPE_ICondition Contract TypeWCB_CONTRACT_TYPETWCBCONTRTYPECHAR4
PROCESS_VARIANT_ICondition Contract Process VariantWCB_PROCESS_VARIANTWCB_C_PROC_VARCHAR4
REF_SETTL_DATE_IReference Date for a Delta SettlementWB2_REF_SETTLEMENT_DATEDATS8
SETTL_DATE_TYPE_IRebates: Settlement Date TypeWB2_SETTLEMENT_DATE_TYPECHAR1
ACT_SETTL_DATE_IActual Settlement DateWB2_ACTUAL_SETTLEMENT_DATEDATS8
SETTL_START_DATE_IStart Date of Settlement PeriodWB2_SETTLEMENT_START_DATEDATS8
KSCHL_SETTLEMENTSettlement Condition TypeWB2_KSCHL_SETTLEMENTT685CHAR4
POSNR_MAINMain Item for ItemWLF_POSNR_MAINNUMC6
POSNR_SUB_EXISTSubitems ExistWLF_POSNR_SUB_EXISTCHAR1
DISTRIB_STATUSStatus Distribution of ItemWLF_DISTRIBUTION_STATUSCHAR1
NO_TEXT_INo Texts ExistWLF_NO_TEXTCHAR1
CWM_MENGEQuantity in Parallel Unit of MeasureWLF_CWM_MENGEQUAN13
CWM_MEINSParallel Unit of MeasureWLF_CWM_MEINS*UNIT3
CWM_UOM_TYPEType of the Parallel Unit of MeasureWLF_CWM_UOM_TYPECHAR1
REF_DOC_NR_1Reference Document for Settlement ManagementWLF_REF_DOC_NUMBERCHAR20
REF_DOC_YEAR_1Year of Reference Document for Settlement ManagementWLF_REF_DOC_YEARNUMC4
REF_LOG_SYS_1Logical System of Reference Document for Smt MgmtWLF_REF_LOG_SYS*CHAR10
REF_ITEM_NUMBERReference Document Item for Settlement Management DocumentWLF_REF_ITEM_NUMBERNUMC10
REF_TYPEReference Document Category in Settlement ManagementWLF_REF_TYPECHAR2
REF_COMPANY_CODE_1Company Code of Reference Document for Settlement ManagementWLF_REF_COMPANY_CODET001CHAR4
ITEM_INTRA_RELDocument Item is Relevant for Intrastat DeclarationsWLF_ITEM_INTRASTAT_RELEVANTCHAR1
GRWRTStatistical value for foreign tradeGRWRTCURR13
GRWRTDStatistical Value for Foreign Trade (Customer-Side)GRWRTDCURR13
POSTING_RULE_K_ICreditor Posting Rule - ItemWLF_POSTING_RULE_K_ITEMTMPRCHAR2
POSTING_RULE_D_IDebtor Posting Rule - ItemWLF_POSTING_RULE_D_ITEMTMPRCHAR2
WEIGHT_VOLUMELevel on which You Enter Weight and VolumeWLF_WEIGHT_VOLUME_LEVELCHAR1
PS_PSP_PNRWork Breakdown Structure Element (WBS Element)PS_PSP_PNRPRPSNUMC8
INCO1_PIncoterms (Part 1)INCO1TINCCHAR3
INCO2_PIncoterms (Part 2)INCO2CHAR28
INCOV_PIncoterms VersionINCOVTINCVCHAR4
INCO2_L_PIncoterms Location 1INCO2_LCHAR70
INCO3_L_PIncoterms Location 2INCO3_LCHAR70
KOKRSDCustomer Controlling AreaWLF_KOKRS_CUSTOMERTKA01CHAR4
PRCTRDAlternative Customer Profit CenterWLF_PRCTR_CUSTOMERCEPCCHAR10
KOSTLDCustomer Cost CenterWLF_KOSTL_CUSTOMERCSKSCHAR10
PAOBJNRDCustomer Profitability Segment Number (CO-PA)WLF_PAOBJNR_CUSTOMERNUMC10
AUFNRDOrder for Customer related Account AssignmentWLF_AUFNR_CUSTOMERAUFKCHAR12
PS_PSP_PNRDCustomer Work Breakdown Structure Element (WBS Element)WLF_PS_PSP_PNR_CUSTOMERPRPSNUMC8
GSBERDCustomer Business AreaWLF_GSBER_CUSTOMERTGSBCHAR4
COLL_STATUS_IStatus for Collection of Settlement Document ItemWLF_COLLECTION_STATUS_ITEMCHAR1
COLL_BLOCK_IReason for Collective Settlement Item BlockWLF_COLLECTION_BLOCK_ITEMTMSBCHAR2
COLL_RELCollective Settlement Relevance of Settlement DocumentsWLF_COLLECTION_RELEVANCECHAR1
CUSTOMERCustomerWLF_CUSTOMERKNA1CHAR10
MVGR1Material group 1MVGR1TVM1CHAR3
MVGR2Material group 2MVGR2TVM2CHAR3
MVGR3Material group 3MVGR3TVM3CHAR3
MVGR4Material group 4MVGR4TVM4CHAR3
MVGR5Material group 5MVGR5TVM5CHAR3
PRODHProduct hierarchyPRODH_DT179CHAR18
DISPUTE_CASEDispute Case GUIDWLF_DISPUTE_CASE_GUIDCHAR32
VKORG_ISales OrganizationWLF_VKORG_ITEMTVKOCHAR4
VTWEG_IDistribution ChannelWLF_VTWEG_ITEMTVTWCHAR2
SPART_IDivisionWLF_SPART_ITEMTSPACHAR2
PROVGCommission groupPROVGTVPRCHAR2
KONDMMaterial Price GroupKONDMT178CHAR2
REBATE_GRPSales Volume Rebate GroupWLF_REBATE_GRP_SLSTVBOCHAR2
BUPLABusiness PlaceBUPLAJ_1BBRANCHCHAR4
BUPLA_ICBusiness Place for Intercompany PostingWLF_BUPLA_ICJ_1BBRANCHCHAR4
TAX_COUNTRYTax Reporting CountryFOT_TAX_COUNTRYT005CHAR3
TAX_COUNTRY_ICTax Reporting Country for Intercompany ProcessesWLF_FOT_TAX_COUNTRYT005CHAR3
TXJCD_ICTax Jurisdiction for Intercompany PostingWLF_TXJCD_IC*CHAR15
LANDTX_ITax Departure CountryWLF_D_LANDTX*CHAR3
LAND1TX_ITax Destination CountryWLF_D_LAND1TX*CHAR3
STCEG_ISupplier VAT Registration NumberWLF_SUPLR_STCEGCHAR20
STCEGD_ICustomer VAT Registration NumberWLF_CUST_STCEGCHAR20
INVC_ITEM_IDBusinessTransactionDocumentItemIDWLF_BTD_ITEM_IDCHAR10
REF_ITEM_IDBusinessTransactionDocumentItemIDWLF_REF_ITEM_IDCHAR10
SCHEME_IDIdentifier for the ID SchemeWLF_SCHEME_IDCHAR60
SCHEME_A_IDID of the Organization that Maintains the ID SchemeWLF_SCHEME_A_IDCHAR60
AGENCY_ID_CODEAgency of Standard ID for Invoice DocumentWLF_AGENCY_ID_CODECHAR3
REF_DOC_NR_2Additional Reference Document for Settlement ManagementWLF_REF_DOC_NUMBER_2CHAR20
REF_DOC_YEAR_2Year of Additional Reference Document for Smt MgmtWLF_REF_DOC_YEAR_2NUMC4
REF_LOG_SYS_2Logical System of Additional Reference Document for Smt MgmtWLF_REF_LOG_SYS_2*CHAR10
REF_ITEM_NUM_2Additional Reference Doc Item for Settlement Mgmt. DocumentWLF_REF_ITEM_NUMBER_2NUMC10
REF_TYPE_2Additional Reference Document CategoryWLF_REF_TYPE_2CHAR2

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WBRP

Table NameFieldCardinalityCheck Table
WBRPAKTNR1: CNWAKH
WBRPAUFNR:AUFK
WBRPAUFNRD:AUFK
WBRPBEMOT:TBMOT
WBRPBUPLA:J_1BBRANCH
WBRPBUPLA_IC:J_1BBRANCH
WBRPBWTAR1: CNT149D
WBRPBWTTY1: CNT149C
WBRPCHARGC: CNMCH1
WBRPCOLL_BLOCK_I:TMSB
WBRPCONTR_TYPE_I:TWCBCONTRTYPE
WBRPCUSTOMER:KNA1
WBRPFPRME1: CNT006
WBRPGEWEI1: CNT006
WBRPGSBERC: CNTGSB
WBRPGSBERD:TGSB
WBRPIDNLF_TYPEC: CNTMVMT
WBRPINCO1_P:TINC
WBRPINCOV_P:TINCV
WBRPINFNR1: CNEINA
WBRPJ_1BCFOP1: CNJ_1BAG
WBRPJ_1BNBM1: CNT604F
WBRPJ_1BTAXLW11: CNJ_1BATL1
WBRPJ_1BTAXLW21: CNJ_1BATL2
WBRPJ_1BTAXLW31: CNJ_1BATL3
WBRPJ_1BTAXLW41: CNJ_1BATL4A
WBRPJ_1BTAXLW51: CNJ_1BATL5
WBRPJ_1BTXSDC1: CNJ_1BTXSDC
WBRPKOKRSC: CNTKA01
WBRPKOKRSD:TKA01
WBRPKOLIF1: CNLFA1
WBRPKONDM:T178
WBRPKOSTLD:CSKS
WBRPKSCHL_SETTLEMENT:T685
WBRPLFGRU1: CNTMLFG
WBRPLTSNR1: NWYT1
WBRPMANDT1: CNT000
WBRPMATKL1: CNT023
WBRPMATNR1: CNMARA
WBRPMEINS1: CNT006
WBRPMTART1: CNT134
WBRPMVGR1:TVM1
WBRPMVGR2:TVM2
WBRPMVGR3:TVM3
WBRPMVGR4:TVM4
WBRPMVGR5:TVM5
WBRPMWSK21: CNT007A
WBRPMWSKZ1: CNT007A
WBRPMWSKZ_BV:T007A
WBRPPOSTING_RULE_D_I:TMPR
WBRPPOSTING_RULE_K_I:TMPR
WBRPPRCTRD:CEPC
WBRPPROCESS_VARIANT_I:WCB_C_PROC_VAR
WBRPPRODH:T179
WBRPPROVG:TVPR
WBRPPS_PSP_PNR1: CNPRPS
WBRPPS_PSP_PNRD:PRPS
WBRPPUNEI1: CNT006
WBRPREBATE_GRP:TVBO
WBRPREF_COMPANY_CODE_1:T001
WBRPSAKTO1: CNSKA1
WBRPSETTL_BLOCK_I_C:TMSB
WBRPSETTL_BLOCK_I_V:TMSB
WBRPSPART_I:TSPA
WBRPSTAFO1: CNTMCB
WBRPSTATUS:FSL_STAT_CUST
WBRPTAX_COUNTRY:T005
WBRPTAX_COUNTRY_IC:T005
WBRPTXJCD1: CNTTXJ
WBRPVKORG_I:TVKO
WBRPVOLEH1: CNT006
WBRPVTWEG_I:TVTW
WBRPWAERS_BV:TCURC
WBRPWBELN1: CNWBRK
WBRPWERKS:T001W
WBRPWFKME1: CNT006

Other References