P_CollsResubmissionDraft

DDL: P_COLLSRESUBMISSIONDRAFT Type: view COMPOSITE Package: ODATA_RESUBMISSION
45 Fields 2 Data Sources 9 Associations

Resubmission Drafts

P_CollsResubmissionDraft is a Composite CDS View that provides data about "Resubmission Drafts" in SAP S/4HANA. It reads from 2 data sources (I_CollectionsResubmission, I_CollsResubmissionDraft) and exposes 45 fields with key field ResubmissionUUID. It has 9 associations to related views. Part of development package ODATA_RESUBMISSION.

Data Sources (2)

SourceAliasJoin Type
I_CollectionsResubmission I_CollectionsResubmission from
I_CollsResubmissionDraft I_CollsResubmissionDraft union_all

Associations (9)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_CollectionSegment _CollectionSegment $projection.CollectionSegment = _CollectionSegment.CollectionSegment
[0..1] I_ResubmissionReason _ResubmissionReason $projection.ResubmissionReason = _ResubmissionReason.ResubmissionReason
[0..1] I_ResubmissionStatus _ResubmissionStatus $projection.ResubmissionStatus = _ResubmissionStatus.ResubmissionStatus
[0..1] I_User _CreatedBy $projection.CreatedByUser = _CreatedBy.UserID
[0..1] I_UserContactCard _CreatedByContactCard $projection.CreatedByUser = _CreatedByContactCard.ContactCardID
[0..1] I_User _ChangedBy $projection.ChangedBy = _ChangedBy.UserID
[0..1] I_UserContactCard _ChangedByContactCard $projection.ChangedBy = _ChangedByContactCard.ContactCardID
[0..1] I_CollsResubmissionDraft _CollsResubmissionDraft $projection.ResubmissionUUID = _CollsResubmissionDraft.ResubmissionUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PCOLLSRSMDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey ResubmissionUUID view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY ResubmissionUUID ResubmissionUUID Resubmission Key
DraftUUID _CollsResubmissionDraft DraftUUID UUID
BusinessPartnerendasBusinessPartner
CollectionSegmentendasCollectionSegment
CreatedByUserendasCreatedByUser
CreationDateTimeendasCreationDateTime
ChangedByendasChangedBy
ChangedOnDateTimeendasChangedOnDateTime
ObjectTypeendasObjectType
ObjectKeyendasObjectKey
HasActiveEntity TRUE
_BusinessPartner _BusinessPartner
_ChangedBy _ChangedBy
_ChangedByContactCard _ChangedByContactCard
_CollectionSegment _CollectionSegment
_CreatedBy _CreatedBy
_CreatedByContactCard _CreatedByContactCard
_ResubmissionReason _ResubmissionReason
ContactCardIDkeyResubmissionUUID
DraftUUID DraftUUID UUID
BusinessPartner BusinessPartner Issuing Authority
CollectionSegment CollectionSegment Segment
ResubmissionDueDate ResubmissionDueDate Resubmission Date
CollResubmissionDateTime CollResubmissionDateTime Time Stamp
NoCntctUntilResubmsnDateIsReq NoCntctUntilResubmsnDateIsReq Don't Contact Until Resubmission Date
ResubmissionReason ResubmissionReason Reason
ResubmissionStatus ResubmissionStatus Status
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
ChangedBy ChangedBy User Name
ChangedOnDateTime ChangedOnDateTime Last Changed At
ObjectType ObjectType Type
ObjectKey ObjectKey Object Key
IsActiveEntity
HasActiveEntity HasActiveEntity TRUE
DraftCreationDateTime DraftCreationDateTime Time Stamp
DraftLastChangedDateTime DraftLastChangedDateTime Time Stamp
_BusinessPartner _BusinessPartner
_ChangedBy _ChangedBy
_ChangedByContactCard _ChangedByContactCard
_CollectionSegment _CollectionSegment
_CreatedBy _CreatedBy
_CreatedByContactCard _CreatedByContactCard
_ResubmissionReason _ResubmissionReason
_ResubmissionStatus _ResubmissionStatus

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 P_CollsResubmissionDraft.
-- 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 P_CollsResubmissionDraft AS
SELECT
  ResubmissionUUID,
  _CollsResubmissionDraft.DraftUUID AS DraftUUID,
  case when _CollsResubmissionDraft.DraftUUID is null then BusinessPartner else _CollsResubmissionDraft.BusinessPartner end as BusinessPartner AS BusinessPartnerendasBusinessPartner,
  case when _CollsResubmissionDraft.DraftUUID is null then CollectionSegment else _CollsResubmissionDraft.CollectionSegment end as CollectionSegment AS CollectionSegmentendasCollectionSegment,
  case when _CollsResubmissionDraft.DraftUUID is null then CreatedByUser else _CollsResubmissionDraft.CreatedByUser end as CreatedByUser AS CreatedByUserendasCreatedByUser,
  case when _CollsResubmissionDraft.DraftUUID is null then CreationDateTime else _CollsResubmissionDraft.CreationDateTime end as CreationDateTime AS CreationDateTimeendasCreationDateTime,
  case when _CollsResubmissionDraft.DraftUUID is null then ChangedBy else _CollsResubmissionDraft.ChangedBy end as ChangedBy AS ChangedByendasChangedBy,
  case when _CollsResubmissionDraft.DraftUUID is null then ChangedOnDateTime else _CollsResubmissionDraft.ChangedOnDateTime end as ChangedOnDateTime AS ChangedOnDateTimeendasChangedOnDateTime,
  case when _CollsResubmissionDraft.DraftUUID is null then ObjectType else _CollsResubmissionDraft.ObjectType end as ObjectType AS ObjectTypeendasObjectType,
  case when _CollsResubmissionDraft.DraftUUID is null then ObjectKey else _CollsResubmissionDraft.ObjectKey end as ObjectKey AS ObjectKeyendasObjectKey,
  cast ( 'X' as boolean ) AS HasActiveEntity,
  BusinessPartner,
  CollectionSegment,
  ResubmissionDueDate,
  CollResubmissionDateTime,
  NoCntctUntilResubmsnDateIsReq,
  ResubmissionReason,
  ResubmissionStatus,
  CreatedByUser,
  CreationDateTime,
  ChangedBy,
  ChangedOnDateTime,
  ObjectType,
  ObjectKey,
  cast( '' as boolean ) AS IsActiveEntity,
  DraftCreationDateTime,
  DraftLastChangedDateTime
FROM I_CollectionsResubmission
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CollectionSegment AS _CollectionSegment ON CollectionSegment = _CollectionSegment.CollectionSegment  -- association [0..1]
LEFT OUTER JOIN I_ResubmissionReason AS _ResubmissionReason ON ResubmissionReason = _ResubmissionReason.ResubmissionReason  -- association [0..1]
LEFT OUTER JOIN I_ResubmissionStatus AS _ResubmissionStatus ON ResubmissionStatus = _ResubmissionStatus.ResubmissionStatus  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedBy ON CreatedByUser = _CreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByContactCard ON CreatedByUser = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedBy ON ChangedBy = _ChangedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedByContactCard ON ChangedBy = _ChangedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_CollsResubmissionDraft AS _CollsResubmissionDraft ON ResubmissionUUID = _CollsResubmissionDraft.ResubmissionUUID  -- association [0..1]
-- UNION ALL with additional select branch(es): I_CollsResubmissionDraft
;

Learn More