V_WB2_MKPF_MSEG_1

CCS: Business Volume from Goods Receipt | view: VWB2_MKPF_MSEG_1 | TRAN | Extraction: Not supported | Component: Chargeback
Tables used: MATDOC, EKKO, EKPO, T001W, T156
Column Name Description
mblnr Number of Material Document
mjahr Material Document Year
zeile Item in Material Document
Column Name Description
💲 Currency Key (waers):
bonba Rebate Basis 1
netwr Net Order Value in PO Currency
brtwr Gross order value in PO 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
Column Name Description
📏 Base Unit of Measure (meins):
menge Quantity
📏 Purchase Order Unit of Measure (bstme):
bstmg Goods receipt quantity in order unit
📏 Points Unit (punei):
erfmg Quantity in unit of entry
anzpu Number of Points
📏 Unit of Weight (gewei):
ntgew Net weight
brgew Gross weight
📏 Volume unit (voleh):
volum Volume
Column Name Description
budat Posting Date in the Document
prdat Date of Price Determination
txdat_from Valid-From Date of the Tax Rate
Column Name Description
shkzg Debit/Credit Indicator Show values
Column Name Description Domain name
lifnr Vendor's account number LIFNR
bukrs Company Code BUKRS
stceg VAT Registration Number STCEG
stceg_l Country/Region of Sales Tax ID Number LAND1
ekkol Condition Group with Supplier CHAR4
werks Plant WERKS
matnr Material Number MATNR
gsber Business Area GSBER
tax_country Tax Reporting Country/Region LAND1
Master Data Relations Join Conditions
Promotion
  • Client
  • Promotion
  • V_WB2_MKPF_MSEG_1.MANDT == WAKH.MANDT
  • V_WB2_MKPF_MSEG_1.AKTNR == WAKH.AKTNR
Purchasing Document Type
  • Purchasing Document Type
  • ?
  • Client
  • V_WB2_MKPF_MSEG_1.BSART == T161.BSART
  • V_WB2_MKPF_MSEG_1.[column in domain "BSTYP"] == T161.BSTYP
  • V_WB2_MKPF_MSEG_1.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • V_WB2_MKPF_MSEG_1.EKGRP == T024.EKGRP
  • V_WB2_MKPF_MSEG_1.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • V_WB2_MKPF_MSEG_1.MANDT == T024E.MANDT
  • V_WB2_MKPF_MSEG_1.EKORG == T024E.EKORG
Unit of Weight
  • Client
  • Unit of Weight
  • V_WB2_MKPF_MSEG_1.MANDT == T006.MANDT
  • V_WB2_MKPF_MSEG_1.GEWEI == T006.MSEHI
Goods Supplier
  • Goods Supplier
  • Client
  • V_WB2_MKPF_MSEG_1.LLIEF == LFA1.LIFNR
  • V_WB2_MKPF_MSEG_1.MANDT == LFA1.MANDT
Supplier Subrange
  • Supplier Subrange
  • Client
  • ?
  • V_WB2_MKPF_MSEG_1.LTSNR == WYT1.LTSNR
  • V_WB2_MKPF_MSEG_1.MANDT == WYT1.MANDT
  • V_WB2_MKPF_MSEG_1.[column in domain "LIFNR"] == WYT1.LIFNR
Material Group
  • Material Group
  • Client
  • V_WB2_MKPF_MSEG_1.MATKL == T023.MATKL
  • V_WB2_MKPF_MSEG_1.MANDT == T023.MANDT
Material type
  • Client
  • Material type
  • V_WB2_MKPF_MSEG_1.MANDT == T134.MANDT
  • V_WB2_MKPF_MSEG_1.MTART == T134.MTART
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • V_WB2_MKPF_MSEG_1.MANDT == T007A.MANDT
  • V_WB2_MKPF_MSEG_1.MWSKZ == T007A.MWSKZ
  • V_WB2_MKPF_MSEG_1.[column in domain "KALSM_D"] == T007A.KALSM
Profit Center
  • ?
  • Client
  • ?
  • Profit Center
  • V_WB2_MKPF_MSEG_1.[column in domain "KOKRS"] == CEPC.KOKRS
  • V_WB2_MKPF_MSEG_1.MANDT == CEPC.MANDT
  • V_WB2_MKPF_MSEG_1.[column in domain "DATBI"] == CEPC.DATBI
  • V_WB2_MKPF_MSEG_1.PRCTR == CEPC.PRCTR
Points Unit
  • Points Unit
  • Client
  • V_WB2_MKPF_MSEG_1.PUNEI == T006.MSEHI
  • V_WB2_MKPF_MSEG_1.MANDT == T006.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • V_WB2_MKPF_MSEG_1.MANDT == MARA.MANDT
  • V_WB2_MKPF_MSEG_1.SATNR == MARA.MATNR
Tax Jurisdiction
  • Client
  • Tax Jurisdiction
  • ?
  • V_WB2_MKPF_MSEG_1.MANDT == TTXJ.MANDT
  • V_WB2_MKPF_MSEG_1.TXJCD == TTXJ.TXJCD
  • V_WB2_MKPF_MSEG_1.[column in domain "TAX_KALSM"] == TTXJ.KALSM
Volume unit
  • Volume unit
  • Client
  • V_WB2_MKPF_MSEG_1.VOLEH == T006.MSEHI
  • V_WB2_MKPF_MSEG_1.MANDT == T006.MANDT
Currency Key
  • Client
  • Currency Key
  • V_WB2_MKPF_MSEG_1.MANDT == TCURC.MANDT
  • V_WB2_MKPF_MSEG_1.WAERS == TCURC.WAERS