I_CustomerContactAttributeDrft

DDL: I_CUSTOMERCONTACTATTRIBUTEDRFT Type: view BASIC
31 Fields 1 Data Sources 6 Associations

Customer Contact Draft

I_CustomerContactAttributeDrft is a Basic CDS View that provides data about "Customer Contact Draft" in SAP S/4HANA. It reads from 1 data source (collcctdra) and exposes 31 fields with key field DraftUUID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
collcctdra collcctdra from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[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] I_CollectionSegment _CollectionSegment $projection.CollectionSegment = _CollectionSegment.CollectionSegment
[0..1] I_CustomerContactResult _CustomerContactResult $projection.CustomerContactResult = _CustomerContactResult.CustomerContactResult

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ICCTDRAFT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Customer Contact Draft view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey DraftUUID view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY DraftUUID draftuuid UUID
CustomerContactUUID customercontactuuid Customer Contact Key
BusinessPartner businesspartner Issuing Authority
CollectionSegment collectionsegment Segment
CollectionCustomerContact collectioncustomercontact Contact ID
CollectionSpecialist collectionspecialist Collection Specialist
ContactPerson Contact Person Key
ContactPersonName contactpersonname Full Name
ContactPersonEmailAddress contactpersonemailaddress Email
ContactPersonPhoneNumber contactpersonphonenumber Telephone No.
ContactPersonFaxNumber contactpersonfaxnumber Fax Number
ContactPersonFaxCountry contactpersonfaxcountry C/R of Fax No.
CustomerContactDirection customercontactdirection Contact Direction
CustomerContactType customercontacttype Contact Type
CustomerContactResult customercontactresult Result of Contact
CustomerIsReached customerisreached Reached
CustomerContactDateTime customercontactdatetime Customer Contact Time
CustContactDurationInMinutes custcontactdurationinminutes Duration
CreatedByUser createdbyuser User Name
CreationDateTime Timestamp
ChangedBy changedby User Name
ChangedOnDateTime Last Changed At
CollectionWorklistItemUUID collectionworklistitemuuid Technical Key
HasActiveEntity hasactiveentity TRUE
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
_BusinessPartner _BusinessPartner
_CollectionSpecialistCard _CollectionSpecialistCard
_CreatedByCard _CreatedByCard
_ChangedByCard _ChangedByCard
_CollectionSegment _CollectionSegment
_CustomerContactResult _CustomerContactResult

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CustomerContactAttributeDrft.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_CustomerContactAttributeDrft AS
SELECT
  DraftUUID,
  CustomerContactUUID,
  BusinessPartner,
  CollectionSegment,
  CollectionCustomerContact,
  CollectionSpecialist,
  cast( contactperson as parnr ) AS ContactPerson,
  ContactPersonName,
  ContactPersonEmailAddress,
  ContactPersonPhoneNumber,
  ContactPersonFaxNumber,
  ContactPersonFaxCountry,
  CustomerContactDirection,
  CustomerContactType,
  CustomerContactResult,
  CustomerIsReached,
  CustomerContactDateTime,
  CustContactDurationInMinutes,
  CreatedByUser,
  cast( creationdatetime as udmo_create_time preserving type ) AS CreationDateTime,
  ChangedBy,
  cast( changedondatetime as udmo_change_time preserving type ) AS ChangedOnDateTime,
  CollectionWorklistItemUUID,
  HasActiveEntity,
  DraftAdministrativeDataUUID
FROM collcctdra
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CollectionSpecialistCard ON CollectionSpecialist = _CollectionSpecialistCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CreatedByCard ON CreatedByUser = _CreatedByCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ChangedByCard ON ChangedBy = _ChangedByCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_CollectionSegment AS _CollectionSegment ON CollectionSegment = _CollectionSegment.CollectionSegment  -- association [0..1]
LEFT OUTER JOIN I_CustomerContactResult AS _CustomerContactResult ON CustomerContactResult = _CustomerContactResult.CustomerContactResult  -- association [0..1]
;

Learn More