C_ProdCmplncUseTP

DDL: C_PRODCMPLNCUSETP Type: view_entity CONSUMPTION
26 Fields 1 Data Sources 1 Associations

Uses

C_ProdCmplncUseTP is a Consumption CDS View that provides data about "Uses" in SAP S/4HANA. It reads from 1 data source (R_ProdCmplncUseTP) and exposes 26 fields with key field ProdCmplncUseUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_ProdCmplncUseTP R_ProdCmplncUseTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_ProdCmplncUseHistory _ProdCmplncUseHistory R_ProdCmplncUseTP.ChmlCmplncInfoUUID = _ProdCmplncUseHistory.ChmlCmplncInfoUUID and R_ProdCmplncUseTP.ProdCmplncLegalArea = _ProdCmplncUseHistory.ProdCmplncLegalArea

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Uses view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey ProdCmplncUseUUID view
UI.headerInfo.typeImageUrl sap-icon: typeName: view
UI.headerInfo.typeNamePlural Uses view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.label Material Name view
UI.headerInfo.title.value ChmlCmplncInfoCombinedName view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ProdCmplncUseUUID ProdCmplncUseUUID Use
ActiveProdCmplncUseUUID ActiveProdCmplncUseUUID Use
ChmlCmplncInfoNavgnLink ChmlCmplncInfoUUID Chemical Compliance Information PP
ProdCmplncUseNavgnLinkUUID _ProdCmplncUseReld ProdCmplncUseUUID Use
ProdCmplncLegalArea ProdCmplncLegalArea Legal Area
ProdCmplncLegalAreaName
ProdCmplncUseProcgSts ProdCmplncUseProcgSts Status
ValidityStartDateTime ValidityStartDateTime Valid From Timestamp
ValidityEndDateTime ValidityEndDateTime Valid To Timestamp
ReleasedByUser ReleasedByUser Released By
Material _MaterialDataPrimary Material Vehicle Model
MaterialIsSold _ChmlCmplncInfo MaterialIsSold Is Sold
MaterialIsTransported _ChmlCmplncInfo MaterialIsTransported Is Transported
MaterialIsProduced _ChmlCmplncInfo MaterialIsProduced Is Produced
MaterialIsSourced _ChmlCmplncInfo MaterialIsSourced Is Purchased
MaterialIsDisposed _ChmlCmplncInfo MaterialIsDisposed Is Disposed
MaterialIsEmissionRelevant _ChmlCmplncInfo MaterialIsEmissionRelevant Emission Relevant
ChmlCmplncProdIsResearched _ChmlCmplncInfo ChmlCmplncProdIsResearched R&D Sample
ChmlCmplncInfoType _ChmlCmplncInfo ChmlCmplncInfoType Type of Chemical Compliance Information
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName
LastChangeUTCDateTime LastChangeDateTime Timestamp
_ChmlCmplncInfo _ChmlCmplncInfo
_ProdCmplncUseHistory _ProdCmplncUseHistory

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 C_ProdCmplncUseTP.
-- 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 C_ProdCmplncUseTP AS
SELECT
  ProdCmplncUseUUID,
  ActiveProdCmplncUseUUID,
  ChmlCmplncInfoUUID AS ChmlCmplncInfoNavgnLink,
  _ProdCmplncUseReld.ProdCmplncUseUUID AS ProdCmplncUseNavgnLinkUUID,
  ProdCmplncLegalArea,
  _ProdCmplncLegalArea._Text[1: Language= $session.system_language].ProdCmplncLegalAreaName AS ProdCmplncLegalAreaName,
  ProdCmplncUseProcgSts,
  ValidityStartDateTime,
  ValidityEndDateTime,
  ReleasedByUser,
  _MaterialDataPrimary.Material AS Material,
  _ChmlCmplncInfo.MaterialIsSold AS MaterialIsSold,
  _ChmlCmplncInfo.MaterialIsTransported AS MaterialIsTransported,
  _ChmlCmplncInfo.MaterialIsProduced AS MaterialIsProduced,
  _ChmlCmplncInfo.MaterialIsSourced AS MaterialIsSourced,
  _ChmlCmplncInfo.MaterialIsDisposed AS MaterialIsDisposed,
  _ChmlCmplncInfo.MaterialIsEmissionRelevant AS MaterialIsEmissionRelevant,
  _ChmlCmplncInfo.ChmlCmplncProdIsResearched AS ChmlCmplncProdIsResearched,
  _ChmlCmplncInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  CreationDateTime,
  CreatedByUser,
  LastChangedByUser,
  cast( _LastChangedByUser.UserDescription as ehfnd_bo_lchg_uname_enhanced preserving type ) AS LastChangedByUserName,
  LastChangeDateTime AS LastChangeUTCDateTime
FROM R_ProdCmplncUseTP
LEFT OUTER JOIN C_ProdCmplncUseHistory AS _ProdCmplncUseHistory ON R_ProdCmplncUseTP.ChmlCmplncInfoUUID = _ProdCmplncUseHistory.ChmlCmplncInfoUUID AND R_ProdCmplncUseTP.ProdCmplncLegalArea = _ProdCmplncUseHistory.ProdCmplncLegalArea  -- association [0..*]
;

Learn More