Atpc_Cds_Ekub_D

DDL: ATPC_CDS_EKUB_D SQL: ATPC_EKUB_D Type: view

CDS View used as replacement of atp_ekub

Atpc_Cds_Ekub_D is a CDS View that provides data about "CDS View used as replacement of atp_ekub" in SAP S/4HANA. It reads from 1 data source (ekko) and exposes 35 fields.

Data Sources (1)

SourceAliasJoin Type
ekko ekko from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ATPC_EKUB_D view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label CDS View used as replacement of atp_ekub view

Fields (35)

KeyFieldSource TableSource FieldDescription
ebeln ekko ebeln Source PurchDoc
ebelp ekpo ebelp Item pur. doc.
etenr eket etenr Schedule Line
bstyp ekpo bstyp Source doc.cat.
matnr ekpo matnr Vehicle Model
reswk ekko reswk Supplying Plant
werks ekpo werks Receiving Plant
reslo ekpo reslo Iss. Stor. Loc.
charg eket charg Chargeable Proc.
sgt_rcat ekpo sgt_rcat Req. Segment
umsok ekpo umsok Special Stock
lblkz ekpo lblkz SC Supplier
emlif ekpo emlif Supplier
mbdat eket mbdat Mat.Avail.Date
dat01 eket dat01 Finish date
mng02 eket mng02 Scrap
eindt eket eindt Initial Entry
uzeit eket uzeit Time
plifz ekpo plifz Plnd Deliv.Time
menge eket menge WarrCountValue
fls_rsto ekpo fls_rsto Enh. Store Ret.
wamng eket wamng Issued
dabmg eket dabmg Qty Reduced
glmng eket glmng Qty Delivered
fixmg ekpo fixmg Planned qty
retpo ekpo retpo Returns Item
meins ekpo meins Valuation Unit
umrez ekpo umrez Numerator
umren ekpo umren Denominator
loekz ekpo loekz Status
elikz ekpo elikz Delivery Completion
stapo ekpo stapo Statistical
uptyp ekpo uptyp Subitem Cat.
eglkz ekpo eglkz Final Delivery
druhr ekpo druhr Time of Transmission

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 Atpc_Cds_Ekub_D.
-- 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: ATPC_EKUB_D

CREATE VIEW Atpc_Cds_Ekub_D AS
SELECT
  ekko.ebeln AS ebeln,
  ekpo.ebelp AS ebelp,
  eket.etenr AS etenr,
  ekpo.bstyp AS bstyp,
  ekpo.matnr AS matnr,
  ekko.reswk AS reswk,
  ekpo.werks AS werks,
  ekpo.reslo AS reslo,
  eket.charg AS charg,
  ekpo.sgt_rcat AS sgt_rcat,
  ekpo.umsok AS umsok,
  ekpo.lblkz AS lblkz,
  ekpo.emlif AS emlif,
  eket.mbdat AS mbdat,
  eket.dat01 AS dat01,
  eket.mng02 AS mng02,
  eket.eindt AS eindt,
  eket.uzeit AS uzeit,
  ekpo.plifz AS plifz,
  eket.menge AS menge,
  ekpo.fls_rsto AS fls_rsto,
  eket.wamng AS wamng,
  eket.dabmg AS dabmg,
  eket.glmng AS glmng,
  ekpo.fixmg AS fixmg,
  ekpo.retpo AS retpo,
  ekpo.meins AS meins,
  ekpo.umrez AS umrez,
  ekpo.umren AS umren,
  ekpo.loekz AS loekz,
  ekpo.elikz AS elikz,
  ekpo.stapo AS stapo,
  ekpo.uptyp AS uptyp,
  ekpo.eglkz AS eglkz,
  ekpo.druhr AS druhr
FROM ekko
;