Atpc_Cds_Eket

DDL: ATPC_CDS_EKET SQL: ATPC_EKET Type: view

CDS View on EKET Table for ATP

Atpc_Cds_Eket is a CDS View that provides data about "CDS View on EKET Table for ATP" in SAP S/4HANA. It reads from 1 data source (Atpc_Cds_Eket_1) and exposes 31 fields.

Data Sources (1)

SourceAliasJoin Type
Atpc_Cds_Eket_1 eket from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ATPC_EKET 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 on EKET Table for ATP view

Fields (31)

KeyFieldSource TableSource FieldDescription
atpcat Atpc_Cds_Eket_1 atpcat MRP Elmnt Ind.
mandt Atpc_Cds_Eket_1 mandt Editing Client
matnr Atpc_Cds_Eket_1 matnr Vehicle Model
werks Atpc_Cds_Eket_1 werks Receiving Plant
lgort Atpc_Cds_Eket_1 lgort Sublocation
charg Atpc_Cds_Eket_1 charg Chargeable Proc.
sgt_rcat Atpc_Cds_Eket_1 sgt_rcat Req. Segment
sgt_scat Atpc_Cds_Eket_1 sgt_scat Stock Segment
sobkz Atpc_Cds_Eket_1 sobkz Special Stock
sskey Atpc_Cds_Eket_1 sskey Special Stock
sskey_ext Atpc_Cds_Eket_1 sskey_ext Ext. SSKEY
lblkz Atpc_Cds_Eket_1 lblkz SC Supplier
emlif Atpc_Cds_Eket_1 emlif Supplier
vbeln Atpc_Cds_Eket_1 vbeln SD Sched. Agmt
vbelp Atpc_Cds_Eket_1 vbelp Schd. Agmt Item
ps_psp_pnr Atpc_Cds_Eket_1 ps_psp_pnr WBS Element
eindt Atpc_Cds_Eket_1 eindt Initial Entry
eldat Atpc_Cds_Eket_1 eldat Planned dates
atptime Atpc_Cds_Eket_1 atptime
retpo Atpc_Cds_Eket_1 retpo Returns Item
bstyp Atpc_Cds_Eket_1 bstyp Source doc.cat.
insmk Atpc_Cds_Eket_1 insmk Stock Type
MEINS Atpc_Cds_Eket_1 meins Valuation Unit
UMREZ Atpc_Cds_Eket_1 umrez Numerator
UMREN Atpc_Cds_Eket_1 umren Denominator
WEBAZ Atpc_Cds_Eket_1 webaz GR Proc. Time
bwtar Atpc_Cds_Eket_1 bwtar Valuation Type
knttp Atpc_Cds_Eket_1 knttp AcctAssgnCat:CC
reswk Atpc_Cds_Eket_1 reswk Supplying Plant
reslo Atpc_Cds_Eket_1 reslo Iss. Stor. Loc.
fixmg Atpc_Cds_Eket_1 fixmg Planned qty

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_Eket.
-- 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_EKET

CREATE VIEW Atpc_Cds_Eket AS
SELECT
  eket.atpcat AS atpcat,
  eket.mandt AS mandt,
  eket.matnr AS matnr,
  eket.werks AS werks,
  eket.lgort AS lgort,
  eket.charg AS charg,
  eket.sgt_rcat AS sgt_rcat,
  eket.sgt_scat AS sgt_scat,
  eket.sobkz AS sobkz,
  eket.sskey AS sskey,
  eket.sskey_ext AS sskey_ext,
  eket.lblkz AS lblkz,
  eket.emlif AS emlif,
  eket.vbeln AS vbeln,
  eket.vbelp AS vbelp,
  eket.ps_psp_pnr AS ps_psp_pnr,
  eket.eindt AS eindt,
  eket.eldat AS eldat,
  eket.atptime AS atptime,
  eket.retpo AS retpo,
  eket.bstyp AS bstyp,
  eket.insmk AS insmk,
  eket.meins AS MEINS,
  eket.umrez AS UMREZ,
  eket.umren AS UMREN,
  eket.webaz AS WEBAZ,
  eket.bwtar AS bwtar,
  eket.knttp AS knttp,
  eket.reswk AS reswk,
  eket.reslo AS reslo,
  eket.fixmg AS fixmg
FROM Atpc_Cds_Eket_1 AS eket
;