C_CollsResubmissionDraft

DDL: C_COLLSRESUBMISSIONDRAFT Type: view_entity CONSUMPTION
31 Fields 1 Data Sources

Resubmission Drafts

C_CollsResubmissionDraft is a Consumption CDS View that provides data about "Resubmission Drafts" in SAP S/4HANA. It reads from 1 data source (R_CollsResubmissionDraftTP) and exposes 31 fields with key field ResubmissionUUID.

Data Sources (1)

SourceAliasJoin Type
R_CollsResubmissionDraftTP R_CollsResubmissionDraftTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Resubmission Drafts view
ObjectModel.representativeKey ResubmissionUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ResubmissionUUID ResubmissionUUID Resubmission Key
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 IsActiveEntity Is active
HasActiveEntity HasActiveEntity TRUE
DraftCreationDateTime DraftCreationDateTime Time Stamp
DraftLastChangedDateTime DraftLastChangedDateTime Time Stamp
BusinessPartnerName _BusinessPartner BusinessPartnerName Extracted Customer Name
CreatedByUserName _CreatedByContactCard UserDescription Full Name
ChangedByUserName _ChangedByContactCard UserDescription Full Name
virtualCompanyCodebukrs
virtualCompanyCodeNamebutxt
virtualAccountingDocumentfarp_belnr_d
virtualFiscalYearfis_gjahr
virtualAccountingDocumentItemfis_buzei
_BusinessPartner _BusinessPartner
_CollectionSegment _CollectionSegment
_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 C_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 C_CollsResubmissionDraft AS
SELECT
  ResubmissionUUID,
  DraftUUID,
  BusinessPartner,
  CollectionSegment,
  ResubmissionDueDate,
  CollResubmissionDateTime,
  NoCntctUntilResubmsnDateIsReq,
  ResubmissionReason,
  ResubmissionStatus,
  CreatedByUser,
  CreationDateTime,
  ChangedBy,
  ChangedOnDateTime,
  ObjectType,
  ObjectKey,
  IsActiveEntity,
  HasActiveEntity,
  DraftCreationDateTime,
  DraftLastChangedDateTime,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _CreatedByContactCard.UserDescription AS CreatedByUserName,
  _ChangedByContactCard.UserDescription AS ChangedByUserName,
  virtual CompanyCode : bukrs AS virtualCompanyCodebukrs,
  virtual CompanyCodeName : butxt AS virtualCompanyCodeNamebutxt,
  virtual AccountingDocument : farp_belnr_d AS virtualAccountingDocumentfarp_belnr_d,
  virtual FiscalYear : fis_gjahr AS virtualFiscalYearfis_gjahr,
  virtual AccountingDocumentItem : fis_buzei AS virtualAccountingDocumentItemfis_buzei
FROM R_CollsResubmissionDraftTP
;

Learn More