R_CustomerContactInclDraft

DDL: R_CUSTOMERCONTACTINCLDRAFT Type: view COMPOSITE

Customer Contact with Draft

R_CustomerContactInclDraft is a Composite CDS View that provides data about "Customer Contact with Draft" in SAP S/4HANA. It reads from 2 data sources (I_CustomerContactAttribute, I_CustomerContactAttributeDrft) and exposes 10 fields with key field CustomerContactUUID. It has 2 associations to related views.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_CustomerContactAttribute I_CustomerContactAttribute from
I_CustomerContactAttributeDrft I_CustomerContactAttributeDrft union_all

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CustomerContactAttributeDrft _CustomerContactDraft $projection.CustomerContactUUID = _CustomerContactDraft.CustomerContactUUID
[0..1] I_DraftAdministrativeData _DraftAdministrativeData $projection.DraftAdministrativeDataUUID = _DraftAdministrativeData.DraftUUID and _DraftAdministrativeData.DraftEntityType = 'R_CUSTOMERCONTACTATTRIBUTETP'

Annotations (11)

NameValueLevelField
EndUserText.label Customer Contact with Draft view
AbapCatalog.sqlViewName RCCTDRAFT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CustomerContactUUID CustomerContactUUID
DraftAdministrativeDataUUID _CustomerContactDraft DraftAdministrativeDataUUID
BusinessPartner BusinessPartner
CollectionSegment CollectionSegment
_BusinessPartner _BusinessPartner
DraftAdministrativeDataUUID DraftAdministrativeDataUUID
BusinessPartner BusinessPartner
CollectionSegment CollectionSegment
_BusinessPartner _BusinessPartner
_CollectionSegment _CollectionSegment 
@EndUserText.label: 'Customer Contact with Draft'
@AbapCatalog: { sqlViewName: 'RCCTDRAFT',
                compiler: { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #MANDATORY }
@VDM: { viewType: #COMPOSITE,
        lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType: { serviceQuality: #X,
                             sizeCategory: #L,
                             dataClass: #TRANSACTIONAL } }

define view R_CustomerContactInclDraft
  as select from I_CustomerContactAttribute
  // Draft

  association [0..1] to I_CustomerContactAttributeDrft as _CustomerContactDraft on $projection.CustomerContactUUID = _CustomerContactDraft.CustomerContactUUID

{
  key CustomerContactUUID,
      _CustomerContactDraft.DraftAdministrativeDataUUID,
      BusinessPartner,
      CollectionSegment,

      _BusinessPartner,
      _CollectionSegment
}

union all select from I_CustomerContactAttributeDrft
association [0..1] to I_DraftAdministrativeData as _DraftAdministrativeData on  $projection.DraftAdministrativeDataUUID  = _DraftAdministrativeData.DraftUUID
                                                                            and _DraftAdministrativeData.DraftEntityType = 'R_CUSTOMERCONTACTATTRIBUTETP'
{
  key CustomerContactUUID,
      DraftAdministrativeDataUUID,
      BusinessPartner,
      CollectionSegment,

      _BusinessPartner,
      _CollectionSegment
}

where
      HasActiveEntity                             <> 'X'
  and _DraftAdministrativeData.DraftIsCreatedByMe =  'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMERCONTACTATTRIBUTE",
"I_CUSTOMERCONTACTATTRIBUTEDRFT",
"I_DRAFTADMINISTRATIVEDATA"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_COLLECTIONSEGMENT",
"I_CUSTOMERCONTACTATTRIBUTEDRFT"
],
"BASE":
[
"I_CUSTOMERCONTACTATTRIBUTE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More