m_v_poh_ekbz_c

DDL: M_V_POH_EKBZ_C SQL: CDS_M_POH_EKBZ_C Type: view

PO History: Table EKBZ with Calc. Fields

m_v_poh_ekbz_c is a CDS View that provides data about "PO History: Table EKBZ with Calc. Fields" in SAP S/4HANA. It reads from 1 data source (M_V_POH_EKBZ) and exposes 37 fields with key fields ebeln, ebelp, stunr, zaehk, vgabe.

Data Sources (1)

SourceAliasJoin Type
M_V_POH_EKBZ ekbz from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CDS_M_POH_EKBZ_C view
EndUserText.label PO History: Table EKBZ with Calc. Fields view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY ebeln M_V_POH_EKBZ ebeln Source PurchDoc
KEY ebelp M_V_POH_EKBZ ebelp Item pur. doc.
KEY stunr M_V_POH_EKBZ stunr Step Number
KEY zaehk M_V_POH_EKBZ zaehk Counter
KEY vgabe M_V_POH_EKBZ vgabe Transact. Type
KEY gjahr M_V_POH_EKBZ gjahr Settlement Year
KEY belnr M_V_POH_EKBZ belnr SD Document
KEY buzei M_V_POH_EKBZ buzei Posting View Item
bedat M_V_POH_EKBZ bedat Start date
meins M_V_POH_EKBZ meins Valuation Unit
pstyp M_V_POH_EKBZ pstyp Item Category
retpo M_V_POH_EKBZ retpo Returns Item
bewtp M_V_POH_EKBZ bewtp PO History Cat.
menge M_V_POH_EKBZ menge WarrCountValue
shkzg M_V_POH_EKBZ shkzg Returns
dmbtr M_V_POH_EKBZ dmbtr Loc. amount
arewr M_V_POH_EKBZ arewr Ord.GRIR.Val
shkko M_V_POH_EKBZ shkko Debit/Credit
tbtkz M_V_POH_EKBZ tbtkz Subseq. Dr/Cr
lifnr M_V_POH_EKBZ lifnr Vendor no.
ekgrp M_V_POH_EKBZ ekgrp Sub. purchasing grp
ekorg M_V_POH_EKBZ ekorg Purchasing Org.
matnr M_V_POH_EKBZ matnr Vehicle Model
elikz M_V_POH_EKBZ elikz Delivery Completion
bstyp M_V_POH_EKBZ bstyp Source doc.cat.
bsart M_V_POH_EKBZ bsart Stnd purch.ord.
werks M_V_POH_EKBZ werks Receiving Plant
fplnr M_V_POH_EKBZ fplnr Invoicing plan
hswae M_V_POH_EKBZ hswae Local currency
rtype M_V_POH_EKBZ rtype Role type
zekkn M_V_POH_EKBZ zekkn Account Assgmt No.
menge_f M_V_POH_EKBZ menge_f Qty (FP Number)
shkzg_factor M_V_POH_EKBZ shkzg_factor
shkzg_help M_V_POH_EKBZ shkzg_help
rewrb_od 0
wesbs
wamng

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_poh_ekbz_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_POH_EKBZ_C

CREATE VIEW m_v_poh_ekbz_c AS
SELECT
  ekbz.ebeln AS ebeln,
  ekbz.ebelp AS ebelp,
  ekbz.stunr AS stunr,
  ekbz.zaehk AS zaehk,
  ekbz.vgabe AS vgabe,
  ekbz.gjahr AS gjahr,
  ekbz.belnr AS belnr,
  ekbz.buzei AS buzei,
  ekbz.bedat AS bedat,
  ekbz.meins AS meins,
  ekbz.pstyp AS pstyp,
  ekbz.retpo AS retpo,
  ekbz.bewtp AS bewtp,
  ekbz.menge AS menge,
  ekbz.shkzg AS shkzg,
  ekbz.dmbtr AS dmbtr,
  ekbz.arewr AS arewr,
  ekbz.shkko AS shkko,
  ekbz.tbtkz AS tbtkz,
  ekbz.lifnr AS lifnr,
  ekbz.ekgrp AS ekgrp,
  ekbz.ekorg AS ekorg,
  ekbz.matnr AS matnr,
  ekbz.elikz AS elikz,
  ekbz.bstyp AS bstyp,
  ekbz.bsart AS bsart,
  ekbz.werks AS werks,
  ekbz.fplnr AS fplnr,
  ekbz.hswae AS hswae,
  ekbz.rtype AS rtype,
  ekbz.zekkn AS zekkn,
  ekbz.menge_f AS menge_f,
  ekbz.shkzg_factor AS shkzg_factor,
  ekbz.shkzg_help AS shkzg_help,
  0 AS rewrb_od,
  cast( '0' as abap.quan(19,3)) AS wesbs,
  cast( '0' as abap.quan(19,3)) AS wamng
FROM M_V_POH_EKBZ AS ekbz
;