C_ChmlContactData

DDL: C_CHMLCONTACTDATA Type: view CONSUMPTION
4 Fields 1 Data Sources

Contact Information Last Changed By User

C_ChmlContactData is a Consumption CDS View that provides data about "Contact Information Last Changed By User" in SAP S/4HANA. It reads from 1 data source (I_UserContactCard) and exposes 4 fields with key field ContactCardID.

Data Sources (1)

SourceAliasJoin Type
I_UserContactCard I_UserContactCard from

Annotations (10)

NameValueLevelField
EndUserText.label Contact Information Last Changed By User view
AbapCatalog.sqlViewName CCCONTACTUSER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ContactCardID ContactCardID User name
FullName FullName Name
EmailAddress EmailAddress E-Mail Address
PhoneNumber PhoneNumber Telephone no.

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_ChmlContactData.
-- 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_ChmlContactData AS
SELECT
  ContactCardID,
  FullName,
  EmailAddress,
  PhoneNumber
FROM I_UserContactCard
;

Learn More