I_CUSTOMERCONTACTRELATION

CDS View

Customer Contact Relation

I_CUSTOMERCONTACTRELATION is a CDS View in S/4HANA. Customer Contact Relation. It contains 2 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 2 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_P2pCctAttrRel view inner COMPOSITE Promise To Pay and Customer Contact
P_PromiseToPay0 view left_outer COMPOSITE Promise To Pay 0
R_CustomerContactRelationTP view_entity from TRANSACTIONAL Customer Contact Relation

Fields (2)

KeyField CDS FieldsUsed in Views
KEY CustomerContactUUID CustomerContactUUID 2
CustomerCntctFollowUpObjStatus CustomerCntctFollowUpObjStatus 1 
@AbapCatalog: { sqlViewName: 'ICCTREL',
                compiler: { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #NOT_REQUIRED }
@EndUserText: { label: 'Customer Contact Relation' }
@VDM: { viewType: #BASIC,
        lifecycle: { contract: { type: #PUBLIC_LOCAL_API } } }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType: { serviceQuality: #A,
                             sizeCategory: #L,
                             dataClass: #TRANSACTIONAL },
                semanticKey: ['CustomerContactUUID', 'CaseUUID' ],
                representativeKey: 'CaseUUID' }

define view I_CustomerContactRelation
  as select from udm_cct_rel

  // VDM Associations

  association [0..1] to I_CustomerContactAttribute as _CustomerContactAttribute on $projection.CustomerContactUUID = _CustomerContactAttribute.CustomerContactUUID

{

      // VDM Fields

      @ObjectModel: { foreignKey: { association: '_CustomerContactAttribute' } }
  key cct_guid      as CustomerContactUUID,

  key obj_guid      as CaseUUID,
      obj_qualifier as CustomerCntctFollowUpObjType,
      obj_invalid   as CustomerCntctFollowUpObjStatus,

      // Exposed Associations

      _CustomerContactAttribute

}

Learn More