m_v_phl_ekbe_C

DDL: M_V_PHL_EKBE_C SQL: CDS_M_PHL_EKBE_C Type: view

m_v_phl_ekbe_C is a CDS View in SAP S/4HANA. It reads from 1 data source (M_V_PHL_EKBE) and exposes 28 fields with key fields ebeln, ebelp, zekkn, vgabe.

Data Sources (1)

SourceAliasJoin Type
M_V_PHL_EKBE ekbe from

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CDS_M_PHL_EKBE_C view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY ebeln M_V_PHL_EKBE ebeln Source PurchDoc
KEY ebelp M_V_PHL_EKBE ebelp Item pur. doc.
KEY zekkn M_V_PHL_EKBE zekkn Account Assgmt No.
KEY vgabe M_V_PHL_EKBE vgabe Transact. Type
bedat M_V_PHL_EKBE bedat Start date
meins M_V_PHL_EKBE meins Valuation Unit
pstyp M_V_PHL_EKBE pstyp Item Category
vrtkz M_V_PHL_EKBE vrtkz Distribution
bewtp M_V_PHL_EKBE bewtp PO History Cat.
menge M_V_PHL_EKBE menge WarrCountValue
dmbtr M_V_PHL_EKBE dmbtr Loc. amount
arewr M_V_PHL_EKBE arewr Ord.GRIR.Val
wesbs_a M_V_PHL_EKBE wesbs_a GR Bl.St. OUn
shkzg M_V_PHL_EKBE shkzg Returns
elikz M_V_PHL_EKBE elikz Delivery Completion
matnr M_V_PHL_EKBE matnr Vehicle Model
lifnr M_V_PHL_EKBE lifnr Vendor no.
ekorg M_V_PHL_EKBE ekorg Purchasing Org.
ekgrp M_V_PHL_EKBE ekgrp Sub. purchasing grp
bstyp M_V_PHL_EKBE bstyp Source doc.cat.
bsart M_V_PHL_EKBE bsart Stnd purch.ord.
werks M_V_PHL_EKBE werks Receiving Plant
fplnr M_V_PHL_EKBE fplnr Invoicing plan
hswae M_V_PHL_EKBE hswae Local currency
rtype M_V_PHL_EKBE rtype Role type
kschl M_V_PHL_EKBE kschl Tax Item Type
tbtkz M_V_PHL_EKBE tbtkz Subseq. Dr/Cr
shkzg_factor M_V_PHL_EKBE shkzg_factor

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 m_v_phl_ekbe_C.
-- 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: CDS_M_PHL_EKBE_C

CREATE VIEW m_v_phl_ekbe_C AS
SELECT
  ekbe.ebeln AS ebeln,
  ekbe.ebelp AS ebelp,
  ekbe.zekkn AS zekkn,
  ekbe.vgabe AS vgabe,
  ekbe.bedat AS bedat,
  ekbe.meins AS meins,
  ekbe.pstyp AS pstyp,
  ekbe.vrtkz AS vrtkz,
  ekbe.bewtp AS bewtp,
  ekbe.menge AS menge,
  ekbe.dmbtr AS dmbtr,
  ekbe.arewr AS arewr,
  ekbe.wesbs_a AS wesbs_a,
  ekbe.shkzg AS shkzg,
  ekbe.elikz AS elikz,
  ekbe.matnr AS matnr,
  ekbe.lifnr AS lifnr,
  ekbe.ekorg AS ekorg,
  ekbe.ekgrp AS ekgrp,
  ekbe.bstyp AS bstyp,
  ekbe.bsart AS bsart,
  ekbe.werks AS werks,
  ekbe.fplnr AS fplnr,
  ekbe.hswae AS hswae,
  ekbe.rtype AS rtype,
  ekbe.kschl AS kschl,
  ekbe.tbtkz AS tbtkz,
  ekbe.shkzg_factor AS shkzg_factor
FROM M_V_PHL_EKBE AS ekbe
;