C_ChmlCmplncInfoIdfrValNmbrTP

DDL: C_CHMLCMPLNCINFOIDFRVALNMBRTP Type: view_entity CONSUMPTION
23 Fields 1 Data Sources

Chml Cmplnc Identifier Numbers for CCI

C_ChmlCmplncInfoIdfrValNmbrTP is a Consumption CDS View that provides data about "Chml Cmplnc Identifier Numbers for CCI" in SAP S/4HANA. It reads from 1 data source (R_ChmlCmplncIdfrValNmbrTP) and exposes 23 fields with key field ChmlCmplncIdfrValueUUID.

Data Sources (1)

SourceAliasJoin Type
R_ChmlCmplncIdfrValNmbrTP R_ChmlCmplncIdfrValNmbrTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Chml Cmplnc Identifier Numbers for CCI view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey ChmlCmplncIdfrValueUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncIdfrValueUUID ChmlCmplncIdfrValueUUID
ChmlCmplncIdfrUUID ChmlCmplncIdfrUUID
CreationUTCDateTime CreationUTCDateTime Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeUTCDateTime LastChangeUTCDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
ChmlCmplncIdfrParentType ChmlCmplncIdfrParentType
ChmlCmplncIdfrType ChmlCmplncIdfrType
ChmlCmplncIdfrCategory ChmlCmplncIdfrCategory
Language Language Report Text Language
ProdCmplncLegalArea ProdCmplncLegalArea Legal Area
ChmlCmplncIdfrSequenceNumber ChmlCmplncIdfrSequenceNumber
ChmlCmplncIdfrValue ChmlCmplncIdfrValue
LanguageNameasLanguageNamelocalized
CreatedByUserName _CreatedByUser UserDescription Full Name
LastChangedByUserName _LastChangedByUser UserDescription Full Name
_ChmlCmplncIdfr _ChmlCmplncIdfr
_ChmlCmplncIdfrParentTypeTxt _ChmlCmplncIdfrParentTypeTxt
_ChmlCmplncIdfrTypeTxt _ChmlCmplncIdfrTypeTxt
_Language _Language
_ProdCmplncLegalAreaText _ProdCmplncLegalAreaText
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_ChmlCmplncInfoIdfrValNmbrTP.
-- 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_ChmlCmplncInfoIdfrValNmbrTP AS
SELECT
  ChmlCmplncIdfrValueUUID,
  ChmlCmplncIdfrUUID,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  ChmlCmplncIdfrParentType,
  ChmlCmplncIdfrType,
  ChmlCmplncIdfrCategory,
  Language,
  ProdCmplncLegalArea,
  ChmlCmplncIdfrSequenceNumber,
  ChmlCmplncIdfrValue,
  _Language._Text.LanguageName as LanguageName : localized AS LanguageNameasLanguageNamelocalized,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  _LastChangedByUser.UserDescription AS LastChangedByUserName
FROM R_ChmlCmplncIdfrValNmbrTP
;

Learn More