R_CustomerContactAttributeTP

DDL: R_CUSTOMERCONTACTATTRIBUTETP Type: view_entity TRANSACTIONAL

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)

SourceAliasJoin Type
I_CustomerContactAttribute I_CustomerContactAttribute from

Associations (6)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/