C_CustomerContactRelationTP

DDL: C_CUSTOMERCONTACTRELATIONTP Type: view_entity CONSUMPTION
6 Fields 1 Data Sources

Customer Contact Relation

C_CustomerContactRelationTP is a Consumption CDS View that provides data about "Customer Contact Relation" in SAP S/4HANA. It reads from 1 data source (R_CustomerContactRelationTP) and exposes 6 fields with key fields CustomerContactUUID, CaseUUID.

Data Sources (1)

SourceAliasJoin Type
R_CustomerContactRelationTP R_CustomerContactRelationTP projection

Annotations (8)

NameValueLevelField
Metadata.allowExtensions true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Customer Contact Relation view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey CaseUUID view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CustomerContactUUID CustomerContactUUID Customer Contact Key
KEY CaseUUID CaseUUID UUID
CustomerCntctFollowUpObjType CustomerCntctFollowUpObjType
CustomerCntctFollowUpObjStatus CustomerCntctFollowUpObjStatus
virtualCaseIDchar32
virtualSemanticObjectchar40

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_CustomerContactRelationTP.
-- 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_CustomerContactRelationTP AS
SELECT
  CustomerContactUUID,
  CaseUUID,
  CustomerCntctFollowUpObjType,
  CustomerCntctFollowUpObjStatus,
  virtual CaseID : char32 AS virtualCaseIDchar32,
  virtual SemanticObject : char40 AS virtualSemanticObjectchar40
FROM R_CustomerContactRelationTP
;

Learn More