SAP table WBRP (Settlement Management Document Item)

SAP table WBRP has 3 primary key fields being MANDT,WBELN,POSNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
WBELN Document Number CHAR 10 0 WBRK WBELN_AG
POSNR Document Item NUMC 6 0 WPOSNR_LF
MATNR Material Number CHAR 40 0 MARA MATNR
MATKL Material Group CHAR 9 0 T023 MATKL
WERKS Plant CHAR 4 0 T001W WERKS_D
MWSKZ Tax Code (Input Tax) CHAR 2 0 T007A MWSKZ_LF
MWSK2 Tax Code (Output Tax) CHAR 2 0 T007A MWSKZ_RB
PRSDT Date for Pricing and Exchange Rate DATS 8 0 PRSDT
MENGE Quantity of Settlement Management Document Item QUAN 13 3 WFIMG
NETPR Net Price in Document Currency CURR 11 2 WNETPR
PEINH Price Unit of Settlement Management Document Item DEC 5 0 WEINH
WFKME Unit of Measure of Settlement Management Doc Item Quantity UNIT 3 0 T006 WFKME
UMREZ Numerator Converting Qty in Settlement Document to Base Unit DEC 5 0 UMWFZ
UMREN Denominator Converting Qty in Settlement Doc. to Base Unit DEC 5 0 UMWFN
FPRME Settlement Management Document Item Price Unit UNIT 3 0 T006 WFPRME
FPUMZ Numerator for Converting Billing UoM to Billing Price UoM DEC 5 0 WPUMZ
FPUMN Denominator for Converting Billing UoM to Billing Price UoM DEC 5 0 WPUMN
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
NTGEW Net Weight QUAN 15 3 WLF_NTGEW_15
BRGEW Gross Weight QUAN 15 3 WLF_BRGEW_15
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
VOLUM Volume QUAN 15 3 WLF_VOLUM_15
VOLEH Volume unit UNIT 3 0 T006 VOLEH
STAFO Update Group for statistics update CHAR 6 0 TMCB STAFO
MTART Material type CHAR 4 0 T134 MTART
NETWR Net Amount of the Item in Document Currency CURR 15 2 NETWR_LFP
BRTWR Gross Amount of the Item in Document Currency CURR 15 2 BRTWR_LFP
KZWI1 Subtotal 1 from Pricing Procedure for Price Element CURR 13 2 KZWI1
KZWI2 Subtotal 2 from Pricing Procedure for Price Element CURR 13 2 KZWI2
KZWI3 Subtotal 3 from Pricing Procedure for Price Element CURR 13 2 KZWI3
KZWI4 Subtotal 4 from Pricing Procedure for Price Element CURR 13 2 KZWI4
KZWI5 Subtotal 5 from Pricing Procedure for Price Element CURR 13 2 KZWI5
KZWI6 Subtotal 6 from Pricing Procedure for Price Element CURR 13 2 KZWI6
BONBA Rebate Basis 1 CURR 13 2 BONBA
EFFWR Effective Amount of Item CURR 13 2 WLF_EFFWR
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZET Entry time TIMS 6 0 ERZET
KOWRR Statistical Property of Settlement Management Item CHAR 1 0 WKOWRR
Item Transferred to Header Totals and Accounting
X Header Totals Adjusted, not Relevant to Accounting
Y Not Header Totals and not Relevant to Accounting
SKTOF Cash Discount Indicator CHAR 1 0 SKTOF
SKFBP Amount eligible for cash discount in document currency CURR 13 2 SKFBP
NETWRD Net Amount of the Item in Document Currency (Customer-Side) CURR 15 2 NETWRD_LFP
BRTWRD Gross Amount of Item in Document Currency (Customer-Side) CURR 15 2 BRTWRD_LFP
KZWI1D Subtotal 1 from Pricing Procedure for Price Element CURR 13 2 KZWI1
KZWI2D Subtotal 2 from Pricing Procedure for Price Element CURR 13 2 KZWI2
KZWI3D Subtotal 3 from Pricing Procedure for Price Element CURR 13 2 KZWI3
KZWI4D Subtotal 4 from Pricing Procedure for Price Element CURR 13 2 KZWI4
KZWI5D Subtotal 5 from Pricing Procedure for Price Element CURR 13 2 KZWI5
KZWI6D Subtotal 6 from Pricing Procedure for Price Element CURR 13 2 KZWI6
BONBAD Rebate Basis 1 CURR 13 2 BONBA
SKFBPD Amount Eligible for Cash Discount in Doc. Curr. (Cust.-Side) CURR 13 2 SKFBPD
EFFWRD Effective Value of the Item (Customer-Side) CURR 13 2 EFFWRD
MWSBPD Tax Amount in Document Currency (Customer-Side) CURR 13 2 MWSBPD
WBELNV Document Number of the Source Document CHAR 10 0 WBELNV
POSNRV Item Number of the Source Document Item NUMC 6 0 WPOSNRV
LFTYPV Document Category of Source Document CHAR 2 0 WFTYPV
01 External Document
02 External Delivery Note
03 External Sales Order
04 External Purchase Order
05 External Invoice
10 Trading Contract
11 Settlement Management Document
12 Sales Order/Contract
13 Delivery
14 Billing Document
15 Inbound Delivery
16 Goods Receipt
17 Purchase Order
18 Shipment Document
20 Pro Forma Customer Sales Document
30 Incoming Invoice
31 Service Entry Sheet
40 Enterprise SOA Purchase Order
41 Enterprise SOA Sales Order
42 Enterprise SOA Inbound Delivery
43 Enterprise SOA Outbound Delivery
44 Enterprise SOA Original Invoice
45 Enterprise SOA Customer Invoice
46 Enterprise SOA Incoming Invoice
47 eSOA Basis Customer Invoice (Doc. in a Collective Invoice)
48 Enterprise SOA Original Credit Memo
49 Enterprise SOA Customer Credit Memo
50 Enterprise SOA Credit Memo
51 eSOA Basis Cust. Credit Memo (Doc. in a Collective Invoice)
60 Nomination
71 Claim Request Document
72 Claim Resolution Document
99 External Document
GJAHRV Fiscal Year NUMC 4 0 GJAHR
AKTNR Promotion CHAR 10 0 WAKH WAKTION
LFGRU Activity Reason for Document Creation CHAR 3 0 TMLFG WFGRU
ARKTX Short Text CHAR 40 0 TXZ01
INFNR Number of purchasing info record CHAR 10 0 EINA INFNR
IDNLF Material Number Used by Supplier CHAR 35 0 IDNLF
MWSBP Tax Amount in Document Currency CURR 13 2 MWSBP
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
EBONF Item Relevant to Subsequent (Period-End Rebate) Settlement CHAR 1 0 EBONY
BONUS Settlement Group 1 (Purchasing) CHAR 2 0 EBONU
EBON2 Settlement Group 2 (Rebate Settlement, Purchasing) CHAR 2 0 EBON2
EBON3 Settlement Group 3 (Rebate Settlement, Purchasing) CHAR 2 0 EBON3
LTSNR Supplier Subrange CHAR 6 0 WYT1 LTSNR
EKKOL Condition Group with Supplier CHAR 4 0 EKKOG
PUNEI Points Unit UNIT 3 0 T006 PUNEI
ANZPU Number of Points QUAN 13 3 ANZPU
KOLIF Prior Supplier CHAR 10 0 LFA1 KOLIF
NAVNW Non-deductible input tax CURR 13 2 NAVNW
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
BWTTY Valuation Category CHAR 1 0 T149C BWTTY_D
GSBER Business Area CHAR 4 0 TGSB GSBER
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
KOSTL Cost Center CHAR 10 0 KOSTL
PRCTR Profit Center CHAR 10 0 PRCTR
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
CHARG Batch Number CHAR 10 0 MCH1 CHARG_D
WUVPRS Indicator that Pricing Determination for Item is Incomplete CHAR 1 0 WUVPRS
WBELN_V Preceding Document of the Settlement Management Document CHAR 10 0 WBELN_V
POSNR_V Preceding Document Item in the Settlement Management Doc. NUMC 6 0 POSNR_V
FTYPV_V Document Category of Preceding Document CHAR 2 0 WFTYP_V
01 Invoice
02 Invoice Reversal
03 Credit Memo
04 Credit Memo Reversal
05 Invoice List
06 Credit Memo List
07 Settlement Management Document with Journal Entry
10 Trading Contract
11 Settlement Management Document
12 Sales Order/Contract
13 Delivery
14 Billing Document
15 Inbound Delivery
16 Goods Receipt
17 Purchase Order/Contract
18 Shipment Document
19 Internal Order (CO)
20 Pro Forma Customer Sales Document
21 CRM Billing Document
30 Incoming Invoice
31 Service Entry Sheet
60 Nomination
61 Nomination Item
70 Condition Contract
71 Claim Request Document
72 Claim Resolution Document
80 Freight Settlement
81 Freight Order
82 Internal Settlement Document
99 External Document
ITEMCAT Item Category CHAR 1 0 WSHKZG
Standard Item
1 Returns Item
2 Text Item
MATBF Material in Respect of Which Stock is Managed CHAR 40 0 MATBF
MWERT_IM Inventory Value in Home Currency CURR 15 2 WLF_MWERT_IM
MWERT_PR Price Difference Value in Home Currency CURR 15 2 WLF_MWERT_PR
MWERT_UM Revaluation Value on Back-Posting to a Previous Period CURR 15 2 WLF_MWERT_UM
CONTRACT Related Contract in the Settlement Management Doc. CHAR 10 0 WCONTRACT
CONTRACT_TYPE Contract Category of Related Contract CHAR 1 0 WCONTRACT_TYPE
1 Condition Contract
2 Trading Contract
3 Purchasing Document/Contract
4 Billing Document
CONTRACT_ITEM Related Contract Item in the Settlement Management Doc. NUMC 6 0 WCONTRACT_ITEM
IDNLF_TYPE Identification Object Type for Material CHAR 4 0 TMVMT WLF_IDNLF_TYPE
ITEM_STATUS Item Status CHAR 1 0 WLF_ITEM_STATUS
Item Is active
1 Item Is Inactive (Collective Document Has Been Generated)
2 Item Is Inactive (Settlement Document Has Been Generated)
ITEM_CANCELED Item Was Canceled CHAR 1 0 WLF_ITEM_CANCELED
is Active
1 Completed by Means of Item Cancellation
GUID_REF GUID of Reference Document RAW 16 0 WLF_GUID_REFERENCE
BEMOT Accounting Indicator CHAR 2 0 TBMOT BEMOT
AUFNR Order Number CHAR 12 0 AUFK AUFNR
SETTL_STATUS_I_V Settlement Status - Item - Supplier CHAR 1 0 WLF_SETTLEMENT_STATUS_ITEM_V
SETTL_STATUS_I_C Settlement Status - Item - Customer CHAR 1 0 WLF_SETTLEMENT_STATUS_ITEM_C
SETTL_BLOCK_I_V Reason for Supplier Settlement Block at Item CHAR 2 0 TMSB WLF_SETTLEMENT_BLOCK_ITEM_V
SETTL_BLOCK_I_C Reason for Customer Settlement Block at Item CHAR 2 0 TMSB WLF_SETTLEMENT_BLOCK_ITEM_C
SETTL_ITEM_REL Item Settlement Relevance CHAR 1 0 WLF_SETTLEMENT_ITEM_RELEVANCE
Standard
1 Only Supplier Side
2 Only Customer Side
3 None
CUOBJ Configuration NUMC 18 0 CUOBJ_VA
FBUDA Date of Services Rendered DATS 8 0 WLF_FBUDA
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
ENTITY_TAG_ITEM Entity Tag of a Settlement Management Document Item NUMC 4 0 WLF_ENTITY_TAG_ITEM
DUMMY_WBRP_INCL_EEW_PS Dummy Data Element for Settlmt Mgmt Doc Item Extensibility CHAR 1 0 WBRP_INCL_EEW
J_1BNBM Brazilian NCM Code CHAR 16 0 T604F J_1BNBMCO1
J_1BMATUSE Usage of the material CHAR 1 0 J_1BMATUSE
0 Resale
1 Industrialisation
2 Consumption
3 Asset
4 Consumption for Main Activity
J_1BMATORG Origin of the material CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
J_1BOWNPRO Produced in-house CHAR 1 0 J_1BOWNPRO
J_1BINDUST Material CFOP category CHAR 2 0 J_1BINDUS3
00 material
01 electricity
02 communication
03 transportation
04 animal
J_1BCFOP CFOP Code and Extension CHAR 10 0 J_1BAG J_1BCFOP
J_1BTXSDC SD tax code CHAR 2 0 J_1BTXSDC J_1BTXSDC_
J_1BTAXLW1 Tax law: ICMS CHAR 3 0 J_1BATL1 J_1BTAXLW1
J_1BTAXLW2 Tax law: IPI CHAR 3 0 J_1BATL2 J_1BTAXLW2
J_1BTAXLW3 ISS Tax Law CHAR 3 0 J_1BATL3 J_1BTAXLW3
J_1BTAXLW4 COFINS Tax Law CHAR 3 0 J_1BATL4A J_1BTAXLW4
J_1BTAXLW5 PIS Tax Law CHAR 3 0 J_1BATL5 J_1BTAXLW5
SAKTO G/L Account Number CHAR 10 0 SKA1 SAKNR
SERVCONF_ITEM FSL: Service Confirmation Item NUMC 10 0 FSL_SERVCONF_ITEM
STATUS FSL: User Status for Item CHAR 4 0 FSL_STAT_CUST FSL_STATUS
IV_CHECK_TYPE_I Type of Check (Item) CHAR 1 0 WLF_IV_CHECK_TYPE_ITEM
Not Checked
1 Item Checked
REFSITE Reference Site For Purchasing CHAR 4 0 WREFSITE
GJAHR CCS: Fiscal Year of Settlement NUMC 4 0 WB2_CCS_GJAHR
MWSKZ_BV Tax Code from Business Volume CHAR 2 0 T007A WB2_MWSKZ_BV
SETTL_DATE_I Rebates: Settlement Date DATS 8 0 WB2_SETTLEMENT_DATE
SETTL_DATE_SEQ_ID_I Settlement Date - Sequential ID NUMC 1 0 WB2_SETTLEMENT_DATE_SEQ_ID
WAERS_BV Currency from Business Volume CUKY 5 0 TCURC WB2_WAERS_BV
TXDAT_FROM_BV Valid-From Date of the Tax Rate from Business Volume DATS 8 0 WB2_TXDAT_FROM_BV
CONTR_TYPE_I Condition Contract Type CHAR 4 0 TWCBCONTRTYPE WCB_CONTRACT_TYPE
PROCESS_VARIANT_I Condition Contract Process Variant CHAR 4 0 WCB_C_PROC_VAR WCB_PROCESS_VARIANT
REF_SETTL_DATE_I Reference Date for a Delta Settlement DATS 8 0 WB2_REF_SETTLEMENT_DATE
SETTL_DATE_TYPE_I Rebates: Settlement Date Type CHAR 1 0 WB2_SETTLEMENT_DATE_TYPE
Final Settlement
1 Partial Settlement
2 Delta Settlement
3 Delta Accruals
4 Accruals Deferral
ACT_SETTL_DATE_I Actual Settlement Date DATS 8 0 WB2_ACTUAL_SETTLEMENT_DATE
SETTL_START_DATE_I Start Date of Settlement Period DATS 8 0 WB2_SETTLEMENT_START_DATE
KSCHL_SETTLEMENT Settlement Condition Type CHAR 4 0 T685 WB2_KSCHL_SETTLEMENT
POSNR_MAIN Main Item for Item NUMC 6 0 WLF_POSNR_MAIN
POSNR_SUB_EXIST Subitems Exist CHAR 1 0 WLF_POSNR_SUB_EXIST
DISTRIB_STATUS Status Distribution of Item CHAR 1 0 WLF_DISTRIBUTION_STATUS
Distribution Is Not Active
1 Relevant for Distribution
2 Not Relevant for Distribution
3 Distribution Incomplete
4 Distribution Carried Out
5 Distribution Carried Out - No Items Generated
9 Item is Distribution Item
NO_TEXT_I No Texts Exist CHAR 1 0 WLF_NO_TEXT
CWM_MENGE Quantity in Parallel Unit of Measure QUAN 13 3 WLF_CWM_MENGE
CWM_MEINS Parallel Unit of Measure UNIT 3 0 * WLF_CWM_MEINS
CWM_UOM_TYPE Type of the Parallel Unit of Measure CHAR 1 0 WLF_CWM_UOM_TYPE
Base Unit of Measure is Valuation Unit of Measure
1 Parallel Unit of Measure is Valuation Unit of Measure
REF_DOC_NR_1 Reference Document for Settlement Management CHAR 20 0 WLF_REF_DOC_NUMBER
REF_DOC_YEAR_1 Year of Reference Document for Settlement Management NUMC 4 0 WLF_REF_DOC_YEAR
REF_LOG_SYS_1 Logical System of Reference Document for Smt Mgmt CHAR 10 0 * WLF_REF_LOG_SYS
REF_ITEM_NUMBER Reference Document Item for Settlement Management Document NUMC 10 0 WLF_REF_ITEM_NUMBER
REF_TYPE Reference Document Category in Settlement Management CHAR 2 0 WLF_REF_TYPE
01 Invoice
02 Invoice Reversal
03 Credit Memo
04 Credit Memo Reversal
05 Settlement Document List
06 Credit Memo List
10 Trading Contract
11 Settlement Management Document
12 Sales Order/Contract
13 Delivery
14 Billing Document
15 Inbound Delivery
16 Goods Receipt
17 Purchase Order/Contract
18 Shipment Document
19 Internal Order (CO)
20 Pro Forma Customer Sales Document
21 CRM Billing Document
22 Provider Contract
23 Convergent Invoicing
24 Service Document
25 Billable Item
30 Incoming Invoice
31 Service Entry Sheet
40 Journal Entry
60 Nomination
61 Nomination Item
70 Condition Contract
71 Claim Request Document
72 Claim Resolution Document
80 Freight Settlement
81 Freight Order
82 Internal Settlement Document
99 External Document
REF_COMPANY_CODE_1 Company Code of Reference Document for Settlement Management CHAR 4 0 T001 WLF_REF_COMPANY_CODE
REF_DOC_TYPE_1 Type of Reference Document for Settlement Management CHAR 4 0 WLF_REF_DOC_TYPE
ITEM_INTRA_REL Document Item is Relevant for Intrastat Declarations CHAR 1 0 WLF_ITEM_INTRASTAT_RELEVANT
Document item is not relevant
1 Document item is relevant
GRWRT Statistical value for foreign trade CURR 13 2 GRWRT
GRWRTD Statistical Value for Foreign Trade (Customer-Side) CURR 13 2 GRWRTD
POSTING_RULE_K_I Creditor Posting Rule - Item CHAR 2 0 TMPR WLF_POSTING_RULE_K_ITEM
POSTING_RULE_D_I Debtor Posting Rule - Item CHAR 2 0 TMPR WLF_POSTING_RULE_D_ITEM
WEIGHT_VOLUME Level on which You Enter Weight and Volume CHAR 1 0 WLF_WEIGHT_VOLUME_LEVEL
Billing Unit
1 Total Quantity
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
T2CCODE_CRCY_CONV_FACTOR_K Factor for Tax Amount in Company Code Currency DEC 31 14 WLF_T2CCODE_CRCY_CONV_FACTOR
T2CNTRY_CRCY_CONV_FACTOR_K Factor for Calculating Tax Amount in Reporting Currency DEC 31 14 WLF_T2CNTRY_CRCY_CONV_FACTOR
T2CCODE_CRCY_CONV_FACTOR_D Factor for Calculating Amount in Co.Code Currency (Customer) DEC 31 14 WLF_T2CCODE_CRCY_CONV_FACTOR_D
T2CNTRY_CRCY_CONV_FACTOR_D Factor for Calculating Tax Amount in Reporting Curr. (Cust.) DEC 31 14 WLF_T2CNTRY_CRCY_CONV_FACTOR_D
INCO1_P Incoterms (Part 1) CHAR 3 0 TINC INCO1
INCO2_P Incoterms (Part 2) CHAR 28 0 INCO2
INCOV_P Incoterms Version CHAR 4 0 TINCV INCOV
INCO2_L_P Incoterms Location 1 CHAR 70 0 INCO2_L
INCO3_L_P Incoterms Location 2 CHAR 70 0 INCO3_L
KOKRSD Customer Controlling Area CHAR 4 0 TKA01 WLF_KOKRS_CUSTOMER
PRCTRD Alternative Customer Profit Center CHAR 10 0 CEPC WLF_PRCTR_CUSTOMER
KOSTLD Customer Cost Center CHAR 10 0 CSKS WLF_KOSTL_CUSTOMER
PAOBJNRD Customer Profitability Segment Number (CO-PA) NUMC 10 0 WLF_PAOBJNR_CUSTOMER
AUFNRD Order for Customer related Account Assignment CHAR 12 0 AUFK WLF_AUFNR_CUSTOMER
PS_PSP_PNRD Customer Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS WLF_PS_PSP_PNR_CUSTOMER
GSBERD Customer Business Area CHAR 4 0 TGSB WLF_GSBER_CUSTOMER
COLL_STATUS_I Status for Collection of Settlement Document Item CHAR 1 0 WLF_COLLECTION_STATUS_ITEM
Not Relevant
1 Open
2 Locked
3 Settled
6 Completed Through Cancellation
COLL_BLOCK_I Reason for Collective Settlement Item Block CHAR 2 0 TMSB WLF_COLLECTION_BLOCK_ITEM
COLL_REL Collective Settlement Relevance of Settlement Documents CHAR 1 0 WLF_COLLECTION_RELEVANCE
Standard
1 Exclude
CUSTOMER Customer CHAR 10 0 KNA1 WLF_CUSTOMER
MVGR1 Material Group 1 CHAR 3 0 TVM1 MVGR1
MVGR2 Material Group 2 CHAR 3 0 TVM2 MVGR2
MVGR3 Material Group 3 CHAR 3 0 TVM3 MVGR3
MVGR4 Material Group 4 CHAR 3 0 TVM4 MVGR4
MVGR5 Material Group 5 CHAR 3 0 TVM5 MVGR5
PRODH Product hierarchy CHAR 18 0 T179 PRODH_D
DISPUTE_CASE Dispute Case GUID CHAR 32 0 WLF_DISPUTE_CASE_GUID
TXDAT_FROM_K Valid-From Date of the Supplier Tax Rate DATS 8 0 WLF_FOT_TXDAT_FROM_K
TXDAT_FROM_D Valid-From Date of the Customer Tax Rate DATS 8 0 WLF_FOT_TXDAT_FROM_D
VKORG_I Sales Organization CHAR 4 0 TVKO WLF_VKORG_ITEM
VTWEG_I Distribution Channel CHAR 2 0 TVTW WLF_VTWEG_ITEM
SPART_I Division CHAR 2 0 TSPA WLF_SPART_ITEM
PROVG Commission Group CHAR 2 0 TVPR PROVG
KONDM Material Price Group CHAR 2 0 T178 KONDM
REBATE_GRP Sales Volume Rebate Group CHAR 2 0 TVBO WLF_REBATE_GRP_SLS
BUPLA Business Place CHAR 4 0 PBUSINESSPLACE BUPLA
BUPLA_IC Business Place for Intercompany Posting CHAR 4 0 PBUSINESSPLACE WLF_BUPLA_IC
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 T005 FOT_TAX_COUNTRY
TAX_COUNTRY_IC Tax Reporting Country/Region for Intercompany Processes CHAR 3 0 T005 WLF_FOT_TAX_COUNTRY
TXJCD_IC Tax Jurisdiction for Intercompany Posting CHAR 15 0 * WLF_TXJCD_IC
REF_MENGE Reference Quantity QUAN 13 3 WLF_REFERENCE_QUANTITY
REF_WFKME Unit of Measure of Settlement Doc Item Reference Quantity UNIT 3 0 T006 WLF_REFERENCE_QUANTITY_UNIT
LANDTX_I Tax Departure Country/Region CHAR 3 0 T005 WLF_D_LANDTX
LAND1TX_I Tax Destination Country/Region CHAR 3 0 T005 WLF_D_LAND1TX
STCEG_I Supplier VAT Registration Number CHAR 20 0 WLF_SUPLR_STCEG
STCEGD_I Customer VAT Registration Number CHAR 20 0 WLF_CUST_STCEG
BUKRS_I Company Code CHAR 4 0 T001 WLF_BUKRS_ITEM
INVC_ITEM_ID BusinessTransactionDocumentItemID CHAR 10 0 WLF_BTD_ITEM_ID
REFERENCE_ID BusinessTransactionDocumentID CHAR 35 0 WLF_REF_ID
REF_ITEM_ID BusinessTransactionDocumentItemID CHAR 10 0 WLF_REF_ITEM_ID
SCHEME_ID Identifier for the ID Scheme CHAR 60 0 WLF_SCHEME_ID
SCHEME_A_ID ID of the Organization that Maintains the ID Scheme CHAR 60 0 WLF_SCHEME_A_ID
AGENCY_ID_CODE Agency of Standard ID for Invoice Document CHAR 3 0 WLF_AGENCY_ID_CODE
REF_DOC_NR_2 Additional Reference Document for Settlement Management CHAR 20 0 WLF_REF_DOC_NUMBER_2
REF_DOC_YEAR_2 Year of Additional Reference Document for Smt Mgmt NUMC 4 0 WLF_REF_DOC_YEAR_2
REF_LOG_SYS_2 Logical System of Additional Reference Document for Smt Mgmt CHAR 10 0 * WLF_REF_LOG_SYS_2
REF_ITEM_NUM_2 Additional Reference Doc Item for Settlement Mgmt. Document NUMC 10 0 WLF_REF_ITEM_NUMBER_2
REF_TYPE_2 Additional Reference Document Category CHAR 2 0 WLF_REF_TYPE_2
01 Invoice
02 Invoice Reversal
03 Credit Memo
04 Credit Memo Reversal
05 Settlement Document List
06 Credit Memo List
07 Settlement Management Document with Journal Entry
10 Trading Contract
11 Settlement Management Document
12 Sales Order/Contract
13 Delivery
14 Billing Document
15 Inbound Delivery
16 Goods Receipt
17 Purchase Order/Contract
18 Shipment Document
19 Internal Order (CO)
20 Pro Forma Customer Sales Document
21 CRM Billing Document
22 Provider Contract
23 Convergent Invoicing
24 Service Document
25 Billable Item
30 Incoming Invoice
31 Service Entry Sheet
60 Nomination
61 Nomination Item
70 Condition Contract
71 Claim Request Document
72 Claim Resolution Document
80 Freight Settlement
81 Freight Order
82 Internal Settlement Document
99 External Document
REF_DOC_TYPE_2 Type of Additional Reference Document for Settlmt Mgmt CHAR 4 0 WLF_REF_DOC_TYPE_2

WBRP foreign key relationships

Table Field Check Table Check Field
0 WBRP AKTNR WAKH Promotion Header Data, IS-R MANDT
0 WBRP AKTNR WAKH Promotion Header Data, IS-R AKTNR
1 WBRP AUFNR AUFK Order master data AUFNR
0 WBRP AUFNRD AUFK Order master data AUFNR
1 WBRP BEMOT TBMOT Accounting indicators MANDT
1 WBRP BEMOT TBMOT Accounting indicators BEMOT
0 WBRP BUKRS_I T001 Company Codes BUKRS
1 WBRP BUPLA PBUSINESSPLACE Generated Table for View BUKRS
1 WBRP BUPLA PBUSINESSPLACE Generated Table for View BRANCH
0 WBRP BUPLA_IC PBUSINESSPLACE Generated Table for View BUKRS
0 WBRP BUPLA_IC PBUSINESSPLACE Generated Table for View BRANCH
1 WBRP BWTAR T149D Global Valuation Types MANDT
1 WBRP BWTAR T149D Global Valuation Types BWTAR
0 WBRP BWTTY T149C Global Valuation Categories BWTTY
1 WBRP CHARG MCH1 Batches (if Batch Management Cross-Plant) MANDT
0 WBRP COLL_BLOCK_I TMSB Settlement Blocks MANDT
0 WBRP COLL_BLOCK_I TMSB Settlement Blocks SETTLEMENT_BLOCK
1 WBRP CONTR_TYPE_I TWCBCONTRTYPE Condition Contract Type CLIENT
1 WBRP CONTR_TYPE_I TWCBCONTRTYPE Condition Contract Type CONTRACT_TYPE
0 WBRP CUSTOMER KNA1 General Data in Customer Master MANDT
0 WBRP CUSTOMER KNA1 General Data in Customer Master KUNNR
1 WBRP FPRME T006 Units of Measurement MANDT
1 WBRP FPRME T006 Units of Measurement MSEHI
0 WBRP GEWEI T006 Units of Measurement MANDT
0 WBRP GEWEI T006 Units of Measurement MSEHI
1 WBRP GSBER TGSB Business Areas MANDT
1 WBRP GSBER TGSB Business Areas GSBER
0 WBRP GSBERD TGSB Business Areas MANDT
0 WBRP GSBERD TGSB Business Areas GSBER
1 WBRP IDNLF_TYPE TMVMT Identification Object Types Material MANDT
0 WBRP INCO1_P TINC Customers: Incoterms INCO1
1 WBRP INCOV_P TINCV Incoterms Versions MANDT
1 WBRP INCOV_P TINCV Incoterms Versions INCOV
0 WBRP INFNR EINA Purchasing Info Record: General Data INFNR
1 WBRP J_1BCFOP J_1BAG CFOP MANDT
0 WBRP J_1BNBM T604F Import Processing: Control Code MANDT
0 WBRP J_1BNBM T604F Import Processing: Control Code LAND1
1 WBRP J_1BTAXLW4 J_1BATL4A Tax Laws COFINS MANDT
0 WBRP J_1BTAXLW5 J_1BATL5 PIS Tax Law MANDT
1 WBRP J_1BTXSDC J_1BTXSDC SD tax codes MANDT
0 WBRP KOKRS TKA01 Controlling Areas MANDT
1 WBRP KOKRSD TKA01 Controlling Areas MANDT
0 WBRP KOLIF LFA1 Supplier Master (General Section) MANDT
0 WBRP KOLIF LFA1 Supplier Master (General Section) LIFNR
1 WBRP KONDM T178 Conditions: Groups for Materials MANDT
1 WBRP KONDM T178 Conditions: Groups for Materials KONDM
0 WBRP KOSTLD CSKS Cost Center Master Record MANDT
0 WBRP KOSTLD CSKS Cost Center Master Record KOKRS
0 WBRP KOSTLD CSKS Cost Center Master Record DATBI
1 WBRP KSCHL_SETTLEMENT T685 Conditions: Types KAPPL
1 WBRP KSCHL_SETTLEMENT T685 Conditions: Types KSCHL
0 WBRP LAND1TX_I T005 Countries MANDT
0 WBRP LAND1TX_I T005 Countries LAND1
1 WBRP LANDTX_I T005 Countries MANDT
1 WBRP LANDTX_I T005 Countries LAND1
0 WBRP LFGRU TMLFG Activity Reasons MANDT
1 WBRP LTSNR WYT1 Vendor Subrange MANDT
1 WBRP LTSNR WYT1 Vendor Subrange LIFNR
1 WBRP LTSNR WYT1 Vendor Subrange LTSNR
0 WBRP MANDT T000 Clients MANDT
1 WBRP MATKL T023 Material Groups MATKL
0 WBRP MATNR MARA General Material Data MANDT
0 WBRP MATNR MARA General Material Data MATNR
1 WBRP MEINS T006 Units of Measurement MANDT
1 WBRP MEINS T006 Units of Measurement MSEHI
0 WBRP MTART T134 Material Types MANDT
0 WBRP MTART T134 Material Types MTART
1 WBRP MVGR1 TVM1 Material Pricing Group 1 MVGR1
0 WBRP MVGR2 TVM2 Material Pricing Group 2 MVGR2
1 WBRP MVGR3 TVM3 Material Pricing Group 3 MVGR3
0 WBRP MVGR4 TVM4 Material Pricing Group 4 MANDT
0 WBRP MVGR4 TVM4 Material Pricing Group 4 MVGR4
1 WBRP MVGR5 TVM5 Material Pricing Group 5 MANDT
1 WBRP MVGR5 TVM5 Material Pricing Group 5 MVGR5
0 WBRP MWSK2 T007A Tax Keys KALSM
0 WBRP MWSK2 T007A Tax Keys MWSKZ
1 WBRP MWSKZ T007A Tax Keys KALSM
1 WBRP MWSKZ T007A Tax Keys MWSKZ
0 WBRP MWSKZ_BV T007A Tax Keys KALSM
0 WBRP MWSKZ_BV T007A Tax Keys MWSKZ
1 WBRP POSTING_RULE_D_I TMPR Posting Rules POSTING_RULE
0 WBRP POSTING_RULE_K_I TMPR Posting Rules POSTING_RULE
1 WBRP PRCTRD CEPC Profit Center Master Data Table PRCTR
1 WBRP PRCTRD CEPC Profit Center Master Data Table DATBI
1 WBRP PRCTRD CEPC Profit Center Master Data Table KOKRS
0 WBRP PROCESS_VARIANT_I WCB_C_PROC_VAR Condition Contract Process Variant MANDT
1 WBRP PRODH T179 Materials: Product Hierarchies PRODH
0 WBRP PROVG TVPR Commission Groups MANDT
0 WBRP PROVG TVPR Commission Groups PROVG
1 WBRP PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 WBRP PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 WBRP PS_PSP_PNRD PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 WBRP PS_PSP_PNRD PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 WBRP PUNEI T006 Units of Measurement MANDT
0 WBRP REBATE_GRP TVBO Sales Rebate Groups MANDT
0 WBRP REBATE_GRP TVBO Sales Rebate Groups BONUS
1 WBRP REF_COMPANY_CODE_1 T001 Company Codes BUKRS
0 WBRP REF_WFKME T006 Units of Measurement MANDT
0 WBRP REF_WFKME T006 Units of Measurement MSEHI
1 WBRP SAKTO SKA1 G/L Account Master (Chart of Accounts) MANDT
1 WBRP SAKTO SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 WBRP SAKTO SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 WBRP SETTL_BLOCK_I_C TMSB Settlement Blocks MANDT
0 WBRP SETTL_BLOCK_I_C TMSB Settlement Blocks SETTLEMENT_BLOCK
1 WBRP SETTL_BLOCK_I_V TMSB Settlement Blocks MANDT
1 WBRP SETTL_BLOCK_I_V TMSB Settlement Blocks SETTLEMENT_BLOCK
0 WBRP SPART_I TSPA Organizational Unit: Sales Divisions MANDT
0 WBRP SPART_I TSPA Organizational Unit: Sales Divisions SPART
1 WBRP STAFO TMCB Update groups MANDT
1 WBRP STAFO TMCB Update groups STAFO
0 WBRP STATUS FSL_STAT_CUST FSL: User Status for Item MANDT
0 WBRP STATUS FSL_STAT_CUST FSL: User Status for Item STATUS
1 WBRP TAX_COUNTRY T005 Countries MANDT
1 WBRP TAX_COUNTRY T005 Countries LAND1
0 WBRP TAX_COUNTRY_IC T005 Countries MANDT
0 WBRP TAX_COUNTRY_IC T005 Countries LAND1
1 WBRP TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
1 WBRP TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
0 WBRP VKORG_I TVKO Organizational Unit: Sales Organizations MANDT
0 WBRP VKORG_I TVKO Organizational Unit: Sales Organizations VKORG
1 WBRP VOLEH T006 Units of Measurement MANDT
1 WBRP VOLEH T006 Units of Measurement MSEHI
0 WBRP VTWEG_I TVTW Organizational Unit: Distribution Channels MANDT
0 WBRP VTWEG_I TVTW Organizational Unit: Distribution Channels VTWEG
1 WBRP WAERS_BV TCURC Currency Codes MANDT
1 WBRP WAERS_BV TCURC Currency Codes WAERS
0 WBRP WBELN WBRK Settlement Management Document Header MANDT
0 WBRP WBELN WBRK Settlement Management Document Header WBELN
1 WBRP WERKS T001W Plants/Branches WERKS
0 WBRP WFKME T006 Units of Measurement MANDT
0 WBRP WFKME T006 Units of Measurement MSEHI