EWA_ALY_I_YYC

DDL: EWA_ALY_I_YYC SQL: EWAALYIYYC Type: view
10 Fields 1 Data Sources 1 Associations

Yardlist Yardcheckerstatus

EWA_ALY_I_YYC is a CDS View that provides data about "Yardlist Yardcheckerstatus" in SAP S/4HANA. It reads from 1 data source (EWA_ALY_P_EWW) and exposes 10 fields with key fields weighingnr, wdplantnr. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
EWA_ALY_P_EWW proc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner $projection.kunnr = _BusinessPartner.BusinessPartner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName EWAALYIYYC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Yardlist Yardcheckerstatus view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY weighingnr EWA_ALY_P_EWW weighingnr Weighing Trans.
KEY wdplantnr wdplantnr WD Facility
description description Well Code Des.
waste waste Waste
license_num license_num License Plate
tare_wdate tare_wdate Date Tare
tare_wtime tare_wtime Time Tare
processtype processtype Type
kunnr EWA_ALY_P_EWW kunnr Stock customer
_BusinessPartner _BusinessPartner

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 EWA_ALY_I_YYC.
-- 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: EWAALYIYYC

CREATE VIEW EWA_ALY_I_YYC AS
SELECT
  proc.weighingnr AS weighingnr,
  wdplantnr,
  description,
  waste,
  license_num,
  tare_wdate,
  tare_wtime,
  processtype,
  proc.kunnr AS kunnr
FROM EWA_ALY_P_EWW AS proc
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON kunnr = _BusinessPartner.BusinessPartner  -- association [0..1]
;

Learn More