V_WB2_EKKO_EKPO_1

DDL: V_WB2_EKKO_EKPO_1 SQL: VWB2_EKKO_EKPO_1 Type: view Package: WCB_CC_SETTL_BV_SEL

Business Volume from Purchase Order

V_WB2_EKKO_EKPO_1 is a CDS View that provides data about "Business Volume from Purchase Order" in SAP S/4HANA. It reads from 2 data sources (ekko, ekpo) and exposes 38 fields with key fields ebeln, ebelp. Part of development package WCB_CC_SETTL_BV_SEL.

Data Sources (2)

SourceAliasJoin Type
ekko ekko from
ekpo ekpo inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName VWB2_EKKO_EKPO_1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business Volume from Purchase Order view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY ebeln ekko ebeln Source PurchDoc
KEY ebelp ekpo ebelp Item pur. doc.
bukrs ekko bukrs Value
lifnr ekko lifnr Vendor no.
waers ekko waers Transaction Currency
ekorg ekko ekorg Purchasing Org.
ekgrp ekko ekgrp Sub. purchasing grp
bedat ekko bedat Start date
llief ekko llief Goods Supplier
bsart ekko bsart Stnd purch.ord.
stceg ekko stceg VAT Reg. No.
matnr ekpo matnr Vehicle Model
werks ekpo werks Receiving Plant
matkl ekpo matkl Product Sold Group
ekkol ekpo ekkol Condition Group
meins ekpo meins Valuation Unit
mwskz ekpo mwskz Tax Code
txjcd ekpo txjcd Tax Jurisdict.
kolif ekpo kolif Prior Supplier
ltsnr ekpo ltsnr Suppl. Subrange
mtart ekpo mtart Product Type
punei ekpo punei Points Unit
gewei ekpo gewei Weight Unit
voleh ekpo voleh Volume Unit
aktnr ekpo aktnr Promotion
retpo ekpo retpo Returns Item
gsber ekpo ko_gsber Bus.area:prtner
prctr ekpo ko_prctr Profit Center
kostl ekpo kostl Substitute CC
txdat_from ekpo txdat_from Tax Rate Valid-From
satnr ekpo satnr Cross-plant CM
ps_psp_pnr ekpo ps_psp_pnr WBS Element
bupla t001w j_1bbranch Business Place
tax_country ekpo tax_country Tax Ctry/Rgn
stceg_l ekko stceg_l Tax Dest. Cty/R
knttp ekpo knttp AcctAssgnCat:CC
kzbws ekpo kzbws Valuation
sobkz ekpo sobkz Special Stock

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view V_WB2_EKKO_EKPO_1.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: VWB2_EKKO_EKPO_1

CREATE VIEW V_WB2_EKKO_EKPO_1 AS
SELECT
  ekko.ebeln AS ebeln,
  ekpo.ebelp AS ebelp,
  ekko.bukrs AS bukrs,
  ekko.lifnr AS lifnr,
  ekko.waers AS waers,
  ekko.ekorg AS ekorg,
  ekko.ekgrp AS ekgrp,
  ekko.bedat AS bedat,
  ekko.llief AS llief,
  ekko.bsart AS bsart,
  ekko.stceg AS stceg,
  ekpo.matnr AS matnr,
  ekpo.werks AS werks,
  ekpo.matkl AS matkl,
  ekpo.ekkol AS ekkol,
  ekpo.meins AS meins,
  ekpo.mwskz AS mwskz,
  ekpo.txjcd AS txjcd,
  ekpo.kolif AS kolif,
  ekpo.ltsnr AS ltsnr,
  ekpo.mtart AS mtart,
  ekpo.punei AS punei,
  ekpo.gewei AS gewei,
  ekpo.voleh AS voleh,
  ekpo.aktnr AS aktnr,
  ekpo.retpo AS retpo,
  ekpo.ko_gsber AS gsber,
  ekpo.ko_prctr AS prctr,
  ekpo.kostl AS kostl,
  ekpo.txdat_from AS txdat_from,
  ekpo.satnr AS satnr,
  ekpo.ps_psp_pnr AS ps_psp_pnr,
  t001w.j_1bbranch AS bupla,
  ekpo.tax_country AS tax_country,
  ekko.stceg_l AS stceg_l,
  ekpo.knttp AS knttp,
  ekpo.kzbws AS kzbws,
  ekpo.sobkz AS sobkz
FROM ekko
INNER JOIN ekpo ON /* join condition not captured in parsed metadata */
;