R_MaintNotifPartnerDraft

DDL: R_MAINTNOTIFPARTNERDRAFT Type: view_entity BASIC
17 Fields 1 Data Sources 5 Associations

Draft query view for maint notif partner

R_MaintNotifPartnerDraft is a Basic CDS View that provides data about "Draft query view for maint notif partner" in SAP S/4HANA. It reads from 1 data source (ntfpartner_d) and exposes 17 fields with key fields MaintenanceNotification, PartnerFunction, NotificationPartnerObjectNmbr, DraftUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ntfpartner_d ntfpartner_d from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_PartnerFunction _PartnerFunction _PartnerFunction.PartnerFunction = $projection.PartnerFunction
[0..1] I_ContactPerson _ContactPerson _ContactPerson.ContactPerson = $projection.Partner
[0..1] I_Customer _Customer _Customer.Customer = $projection.Partner
[0..1] I_WorkforcePerson _Employee _Employee.PersonExternalID = $projection.Partner
[0..1] I_Supplier _Supplier _Supplier.Supplier = $projection.Partner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Draft query view for maint notif partner view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification maintenancenotification Notification
KEY PartnerFunction partnerfunction Partner Functn
KEY NotificationPartnerObjectNmbr notificationpartnerobjectnmbr Counter
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
Partner partner With Partner
MaintenancePartner maintenancepartner Partner
HasActiveEntity hasactiveentity TRUE
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
_ContactPerson _ContactPerson
_Customer _Customer
_Employee _Employee
_PartnerFunction _PartnerFunction
_Supplier _Supplier

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 R_MaintNotifPartnerDraft.
-- 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 R_MaintNotifPartnerDraft AS
SELECT
  MaintenanceNotification,
  PartnerFunction,
  NotificationPartnerObjectNmbr,
  DraftUUID,
  ParentDraftUUID,
  Partner,
  MaintenancePartner,
  HasActiveEntity,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode
FROM ntfpartner_d
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON _PartnerFunction.PartnerFunction = PartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_ContactPerson AS _ContactPerson ON _ContactPerson.ContactPerson = Partner  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = Partner  -- association [0..1]
LEFT OUTER JOIN I_WorkforcePerson AS _Employee ON _Employee.PersonExternalID = Partner  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Partner  -- association [0..1]
;

Learn More