V_WB2_EKKO_EKPO_1

CCS: Business Volume from Purchase Order | view: VWB2_EKKO_EKPO_1 | TRAN | Extraction: Not supported | Component: Chargeback

Tables used: EKKO, EKPO, T001W

🔑 Keys (2)
💰 Amounts (9)
∑ Quantities (5)
📅 Dates (3)
☰ Categorical (1)
Other (5)
🔗 Relations (23)

Column Name	Description
ebeln	Purchasing Document Number
ebelp	Item Number of Purchasing Document

Column Name	Description
💲 Currency Key (waers):
netwr	Net Order Value in PO Currency
brtwr	Gross order value in PO currency
bonba	Rebate Basis 1
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
📏 Purchase Order Unit of Measure (meins):
menge	Purchase Order Quantity
📏 Points Unit (punei):
anzpu	Number of Points
📏 Unit of Weight (gewei):
ntgew	Net weight
brgew	Gross weight
📏 Volume unit (voleh):
volum	Volume

Column Name	Description
bedat	Purchasing Document Date
prdat	Date of Price Determination
txdat_from	Valid-From Date of the Tax Rate

Column Name	Description
retpo	Returns Item	Show values

Column Name	Description	Domain name
stceg	VAT Registration Number	STCEG
ekkol	Condition Group with Supplier	CHAR4
gsber	Business area reported to the partner	GSBER
tax_country	Tax Reporting Country/Region	LAND1
stceg_l	Country/Region of Sales Tax ID Number	LAND1

Master Data Relations	Join Conditions
Promotion Client Promotion	`V_WB2_EKKO_EKPO_1.MANDT == WAKH.MANDT` `V_WB2_EKKO_EKPO_1.AKTNR == WAKH.AKTNR`
Purchasing Document Type Client Purchasing Document Type ?	`V_WB2_EKKO_EKPO_1.MANDT == T161.MANDT` `V_WB2_EKKO_EKPO_1.BSART == T161.BSART` `V_WB2_EKKO_EKPO_1.[column in domain "BSTYP"] == T161.BSTYP`
Company Code Company Code Client	`V_WB2_EKKO_EKPO_1.BUKRS == T001.BUKRS` `V_WB2_EKKO_EKPO_1.MANDT == T001.MANDT`
Purchasing Group Client Purchasing Group	`V_WB2_EKKO_EKPO_1.MANDT == T024.MANDT` `V_WB2_EKKO_EKPO_1.EKGRP == T024.EKGRP`
Purchasing organization Client Purchasing organization	`V_WB2_EKKO_EKPO_1.MANDT == T024E.MANDT` `V_WB2_EKKO_EKPO_1.EKORG == T024E.EKORG`
Unit of Weight Client Unit of Weight	`V_WB2_EKKO_EKPO_1.MANDT == T006.MANDT` `V_WB2_EKKO_EKPO_1.GEWEI == T006.MSEHI`
Prior Supplier Client Prior Supplier	`V_WB2_EKKO_EKPO_1.MANDT == LFA1.MANDT` `V_WB2_EKKO_EKPO_1.KOLIF == LFA1.LIFNR`
Vendor's account number Client Vendor's account number	`V_WB2_EKKO_EKPO_1.MANDT == LFA1.MANDT` `V_WB2_EKKO_EKPO_1.LIFNR == LFA1.LIFNR`
Goods Supplier Client Goods Supplier	`V_WB2_EKKO_EKPO_1.MANDT == LFA1.MANDT` `V_WB2_EKKO_EKPO_1.LLIEF == LFA1.LIFNR`
Supplier Subrange Supplier Subrange Client Prior Supplier	`V_WB2_EKKO_EKPO_1.LTSNR == WYT1.LTSNR` `V_WB2_EKKO_EKPO_1.MANDT == WYT1.MANDT` `V_WB2_EKKO_EKPO_1.KOLIF == WYT1.LIFNR`
Material Group Client Material Group	`V_WB2_EKKO_EKPO_1.MANDT == T023.MANDT` `V_WB2_EKKO_EKPO_1.MATKL == T023.MATKL`
Material Number Client Material Number	`V_WB2_EKKO_EKPO_1.MANDT == MARA.MANDT` `V_WB2_EKKO_EKPO_1.MATNR == MARA.MATNR`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`V_WB2_EKKO_EKPO_1.MANDT == T006.MANDT` `V_WB2_EKKO_EKPO_1.MEINS == T006.MSEHI`
Material type Client Material type	`V_WB2_EKKO_EKPO_1.MANDT == T134.MANDT` `V_WB2_EKKO_EKPO_1.MTART == T134.MTART`
Tax on sales/purchases code Client Tax on sales/purchases code ?	`V_WB2_EKKO_EKPO_1.MANDT == T007A.MANDT` `V_WB2_EKKO_EKPO_1.MWSKZ == T007A.MWSKZ` `V_WB2_EKKO_EKPO_1.[column in domain "KALSM_D"] == T007A.KALSM`
Profit Center Client Profit Center Purchasing Document Date ?	`V_WB2_EKKO_EKPO_1.MANDT == CEPC.MANDT` `V_WB2_EKKO_EKPO_1.PRCTR == CEPC.PRCTR` `V_WB2_EKKO_EKPO_1.BEDAT == CEPC.DATBI` `V_WB2_EKKO_EKPO_1.[column in domain "KOKRS"] == CEPC.KOKRS`
Points Unit Client Points Unit	`V_WB2_EKKO_EKPO_1.MANDT == T006.MANDT` `V_WB2_EKKO_EKPO_1.PUNEI == T006.MSEHI`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`V_WB2_EKKO_EKPO_1.MANDT == MARA.MANDT` `V_WB2_EKKO_EKPO_1.SATNR == MARA.MATNR`
Tax Jurisdiction Client ? Tax Jurisdiction	`V_WB2_EKKO_EKPO_1.MANDT == TTXJ.MANDT` `V_WB2_EKKO_EKPO_1.[column in domain "TAX_KALSM"] == TTXJ.KALSM` `V_WB2_EKKO_EKPO_1.TXJCD == TTXJ.TXJCD`
Volume unit Client Volume unit	`V_WB2_EKKO_EKPO_1.MANDT == T006.MANDT` `V_WB2_EKKO_EKPO_1.VOLEH == T006.MSEHI`
Currency Key Client Currency Key	`V_WB2_EKKO_EKPO_1.MANDT == TCURC.MANDT` `V_WB2_EKKO_EKPO_1.WAERS == TCURC.WAERS`
Plant Client Plant	`V_WB2_EKKO_EKPO_1.MANDT == T001W.MANDT` `V_WB2_EKKO_EKPO_1.WERKS == T001W.WERKS`