I_ProdCmplncWayOfAppl

DDL: I_PRODCMPLNCWAYOFAPPL Type: view_entity BASIC
11 Fields 1 Data Sources 3 Associations

Ways of Application

I_ProdCmplncWayOfAppl is a Basic CDS View that provides data about "Ways of Application" in SAP S/4HANA. It reads from 1 data source (ehfndd_way_of_ap) and exposes 11 fields with key field ProdCmplncWayOfApplUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ehfndd_way_of_ap ehfndd_way_of_ap from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ProdCmplncUse _ProdCmplncUse $projection.ProdCmplncUseUUID = _ProdCmplncUse.ProdCmplncUseUUID -- Admin data - Created by
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID -- Admin data - Last changed by
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Ways of Application view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProdCmplncWayOfApplUUID uuid Waste Partner UUID
ProdCmplncUseUUID use_uuid Use
ProdCmplncWayOfApplPhraseUUID way_of_appl
ProdCmplncUseRating rating Use of Data
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_ProdCmplncUse _ProdCmplncUse

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 I_ProdCmplncWayOfAppl.
-- 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.

CREATE VIEW I_ProdCmplncWayOfAppl AS
SELECT
  uuid AS ProdCmplncWayOfApplUUID,
  use_uuid AS ProdCmplncUseUUID,
  way_of_appl AS ProdCmplncWayOfApplPhraseUUID,
  rating AS ProdCmplncUseRating,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM ehfndd_way_of_ap
LEFT OUTER JOIN I_ProdCmplncUse AS _ProdCmplncUse ON ProdCmplncUseUUID = _ProdCmplncUse.ProdCmplncUseUUID  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;

Learn More