R_CUSTOMERCONTACTATTRIBUTETP

CDS View

Customer Contact

R_CUSTOMERCONTACTATTRIBUTETP is a CDS View in S/4HANA. Customer Contact. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CustomerContactAttributeTP view_entity projection CONSUMPTION Customer Contact 
@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' } }
@Consumption: { dbHints: [ 'USE_HEX_PLAN' ] }

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

}

Learn More