C_ChmlCmplncBrnddProdNameTP

DDL: C_CHMLCMPLNCBRNDDPRODNAMETP Type: view_entity CONSUMPTION Package: EHFND_CNS_CCI
9 Fields 1 Data Sources 2 OData Services

Branded Product Name

C_ChmlCmplncBrnddProdNameTP is a Consumption CDS View that provides data about "Branded Product Name" in SAP S/4HANA. It reads from 1 data source (R_ChmlCmplncBrnddProdNameTP) and exposes 9 fields with key field ChmlCmplncBrnddProdNameUUID. It is exposed through 2 OData services (ASQL_F8407, UI_EHS_FND_COMPLIANCE_VIEW_MAN). Part of development package EHFND_CNS_CCI.

Data Sources (1)

SourceAliasJoin Type
R_ChmlCmplncBrnddProdNameTP R_ChmlCmplncBrnddProdNameTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Branded Product Name view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey ChmlCmplncBrnddProdNameUUID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
Search.searchable true view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F8407 ASQL_F8407 C2 NOT_RELEASED
UI_EHS_FND_COMPLIANCE_VIEW_MAN UI_EHS_FND_COMPLIANCE_VIEW_MAN V4 C1 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncBrnddProdNameUUID BrnddProdName ChmlCmplncBrnddProdNameUUID
ChmlCmplncInfoUUID BrnddProdName ChmlCmplncInfoUUID Chemical Compliance Information PP
Language BrnddProdName Language Report Text Language
LanguageNameasLanguageNamelocalized
ChmlCmplncBrnddProdName BrnddProdName ChmlCmplncBrnddProdName
CreationDateTime BrnddProdName CreationDateTime Timestamp
CreatedByUser BrnddProdName CreatedByUser User Name
LastChangeDateTime BrnddProdName LastChangeDateTime Timestamp
LastChangedByUser BrnddProdName LastChangedByUser User Name

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_ChmlCmplncBrnddProdNameTP.
-- 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_ChmlCmplncBrnddProdNameTP AS
SELECT
  BrnddProdName.ChmlCmplncBrnddProdNameUUID AS ChmlCmplncBrnddProdNameUUID,
  BrnddProdName.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  BrnddProdName.Language AS Language,
  _Language._Text.LanguageName as LanguageName : localized AS LanguageNameasLanguageNamelocalized,
  BrnddProdName.ChmlCmplncBrnddProdName AS ChmlCmplncBrnddProdName,
  BrnddProdName.CreationDateTime AS CreationDateTime,
  BrnddProdName.CreatedByUser AS CreatedByUser,
  BrnddProdName.LastChangeDateTime AS LastChangeDateTime,
  BrnddProdName.LastChangedByUser AS LastChangedByUser
FROM R_ChmlCmplncBrnddProdNameTP
;

Learn More