R_CustomerContactAttributeTP
Customer Contact
R_CustomerContactAttributeTP is a Transactional CDS View that provides data about "Customer Contact" in SAP S/4HANA. It reads from 1 data source (I_CustomerContactAttribute) and exposes 36 fields with key field CustomerContactUUID. It has 6 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CustomerContactAttribute | I_CustomerContactAttribute | from |
Associations (6)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_CollectionContact | _CollectionContact | $projection.BusinessPartner = _CollectionContact.BusinessPartnerCompany and $projection.CollectionSegment = _CollectionContact.CollectionSegment |
| [0..1] | R_RblsMgmtUserContactCard | _CollectionSpecialistCard | $projection.CollectionSpecialist = _CollectionSpecialistCard.ContactCardID |
| [0..1] | R_RblsMgmtUserContactCard | _CreatedByCard | $projection.CreatedByUser = _CreatedByCard.ContactCardID |
| [0..1] | R_RblsMgmtUserContactCard | _ChangedByCard | $projection.ChangedBy = _ChangedByCard.ContactCardID |
| [0..1] | R_BPCollectionsSgmtQuickView | _CollectionsBPQuickView | $projection.BusinessPartner = _CollectionsBPQuickView.BusinessPartner and $projection.CollectionSegment = _CollectionsBPQuickView.CollectionSegment |
| [0..*] | R_CustomerContactRelationTP | _CustomerContactRelation | |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| EndUserText.label | Customer Contact | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.representativeKey | CustomerContactUUID | view | |
| ObjectModel.modelCategory | #BUSINESS_OBJECT | view | |
| ObjectModel.transactionalProcessingEnabled | true | view | |
| ObjectModel.sapObjectNodeType.name | CollectionsCustomerContact | view |
Fields (36)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CustomerContactUUID | CustomerContactUUID | ||
| BusinessPartner | BusinessPartner | |||
| CollectionSegment | CollectionSegment | |||
| CollectionCustomerContact | CollectionCustomerContact | |||
| CollectionSpecialist | CollectionSpecialist | |||
| ContactPerson | ContactPerson | |||
| ContactPersonName | ContactPersonName | |||
| ContactPersonEmailAddress | ContactPersonEmailAddress | |||
| ContactPersonPhoneNumber | ContactPersonPhoneNumber | |||
| ContactPersonFaxNumber | ContactPersonFaxNumber | |||
| ContactPersonFaxCountry | ContactPersonFaxCountry | |||
| CustomerContactDirection | CustomerContactDirection | |||
| CustomerContactType | CustomerContactType | |||
| CustomerContactResult | CustomerContactResult | |||
| CustomerIsReached | CustomerIsReached | |||
| CustomerContactDateTime | CustomerContactDateTime | |||
| CustContactDurationInMinutes | CustContactDurationInMinutes | |||
| CreatedByUser | CreatedByUser | |||
| CreationDateTime | CreationDateTime | |||
| ChangedBy | ChangedBy | |||
| ChangedOnDateTime | ChangedOnDateTime | |||
| CollectionWorklistItemUUID | CollectionWorklistItemUUID | |||
| _BusinessPartner | _BusinessPartner | |||
| _ChangedByCard | _ChangedByCard | |||
| _CollectionSegment | _CollectionSegment | |||
| _CollectionSpecialistCard | _CollectionSpecialistCard | |||
| _CollectionWorklistItem | _CollectionWorklistItem | |||
| _Country | _Country | |||
| _CreatedByCard | _CreatedByCard | |||
| _CustomerContactDirection | _CustomerContactDirection | |||
| _CustomerContactRelation | _CustomerContactRelation | |||
| _CustomerContactResult | _CustomerContactResult | |||
| _CustomerContactType | _CustomerContactType | |||
| _CustomerContact | _CustomerContact | |||
| _CollectionContact | _CollectionContact | |||
| _CollectionsBPQuickView | _CollectionsBPQuickView |
@AccessControl: { authorizationCheck: #CHECK,
personalData: { blocking: #BLOCKED_DATA_EXCLUDED },
privilegedAssociations: [ '_CollectionSpecialistCard',
'_CreatedByCard',
'_ChangedByCard' ] }
@EndUserText: { label: 'Customer Contact' }
@VDM: { viewType: #TRANSACTIONAL,
lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ObjectModel: { usageType: { serviceQuality: #A,
sizeCategory: #L,
dataClass: #TRANSACTIONAL },
semanticKey: [ 'CustomerContactUUID',
'CollectionSegment' ],
representativeKey: 'CustomerContactUUID',
modelCategory: #BUSINESS_OBJECT,
transactionalProcessingEnabled: true,
sapObjectNodeType: { name: 'CollectionsCustomerContact' } }
define root view entity R_CustomerContactAttributeTP
as select from I_CustomerContactAttribute
// BO Associations
composition [0..*] of R_CustomerContactRelationTP as _CustomerContactRelation
//BO Colls Email hinzufügen, vorher root entity raus
// VDM Associations
// Collection Contact
association [0..*] to I_CollectionContact as _CollectionContact on $projection.BusinessPartner = _CollectionContact.BusinessPartnerCompany
and $projection.CollectionSegment = _CollectionContact.CollectionSegment
// Collection Specialist Contact Card
association [0..1] to R_RblsMgmtUserContactCard as _CollectionSpecialistCard on $projection.CollectionSpecialist = _CollectionSpecialistCard.ContactCardID
// Created By Contact Card
association [0..1] to R_RblsMgmtUserContactCard as _CreatedByCard on $projection.CreatedByUser = _CreatedByCard.ContactCardID
// Changed By Contact Card
association [0..1] to R_RblsMgmtUserContactCard as _ChangedByCard on $projection.ChangedBy = _ChangedByCard.ContactCardID
// Business Partner Quick View Facet
association [0..1] to R_BPCollectionsSgmtQuickView as _CollectionsBPQuickView on $projection.BusinessPartner = _CollectionsBPQuickView.BusinessPartner
and $projection.CollectionSegment = _CollectionsBPQuickView.CollectionSegment
{
// VDM Fields
key CustomerContactUUID,
@ObjectModel: { foreignKey: { association: '_CollectionsBPQuickView' } }
BusinessPartner,
CollectionSegment,
CollectionCustomerContact,
@ObjectModel: { foreignKey: { association: '_CollectionSpecialistCard' } }
CollectionSpecialist,
ContactPerson,
ContactPersonName,
ContactPersonEmailAddress,
ContactPersonPhoneNumber,
ContactPersonFaxNumber,
ContactPersonFaxCountry,
CustomerContactDirection,
CustomerContactType,
CustomerContactResult,
CustomerIsReached,
CustomerContactDateTime,
CustContactDurationInMinutes,
@ObjectModel: { foreignKey: { association: '_CreatedByCard' } }
CreatedByUser,
CreationDateTime,
@ObjectModel: { foreignKey: { association: '_ChangedByCard' } }
ChangedBy,
ChangedOnDateTime,
CollectionWorklistItemUUID,
// Exposed Associations
_BusinessPartner,
_ChangedByCard,
_CollectionSegment,
_CollectionSpecialistCard,
_CollectionWorklistItem,
_Country,
_CreatedByCard,
_CustomerContactDirection,
_CustomerContactRelation,
_CustomerContactResult,
_CustomerContactType,
_CustomerContact,
_CollectionContact,
_CollectionsBPQuickView
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMERCONTACTATTRIBUTE"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_COLLECTIONCONTACT",
"I_COLLECTIONSEGMENT",
"I_COLLECTIONWORKLISTITEM",
"I_COUNTRY",
"I_CUSTOMERCONTACT",
"I_CUSTOMERCONTACTDIRECTION",
"I_CUSTOMERCONTACTRESULT",
"I_CUSTOMERCONTACTTYPE",
"R_BPCOLLECTIONSSGMTQUICKVIEW",
"R_CUSTOMERCONTACTRELATIONTP",
"R_RBLSMGMTUSERCONTACTCARD"
],
"BASE":
[
"I_CUSTOMERCONTACTATTRIBUTE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA