I_CollsInvoiceRelatedResubmsn

DDL: I_COLLSINVOICERELATEDRESUBMSN Type: view COMPOSITE
22 Fields 1 Data Sources 2 Associations

Resubmission Related to Invoice

I_CollsInvoiceRelatedResubmsn is a Composite CDS View that provides data about "Resubmission Related to Invoice" in SAP S/4HANA. It reads from 1 data source (I_CollsInvoiceRelatedObject) and exposes 22 fields with key fields LogicalSystem, ObjectType, ObjectKey, RelationToLinkedObject, ResubmissionUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CollsInvoiceRelatedObject I_CollsInvoiceRelatedObject from

Associations (2)

CardinalityTargetAliasCondition
[0..1] R_RblsMgmtUserContactCard _CreatedByContactCard $projection.createdbyuser = _CreatedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ChangedByContactCard $projection.changedby = _ChangedByContactCard.ContactCardID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICOLLSINVRELRSM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Resubmission Related to Invoice view
VDM.viewType #COMPOSITE 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

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY LogicalSystem LogicalSystem Logical System
KEY ObjectType ObjectType Type
KEY ObjectKey ObjectKey Object Key
KEY RelationToLinkedObject RelationToLinkedObject Relationsh.Cat.
KEY ResubmissionUUID CaseUniqueID UUID
ObjectClassification ObjectClassification Step Classification
ObjectIsConfirmed ObjectIsConfirmed TRUE
ObjectIsVoided ObjectIsVoided TRUE
CompanyCode CompanyCode Receiver Company Code
AccountingDocument AccountingDocument Journal Entry
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocumentItem AccountingDocumentItem Posting View Item
CaseID CaseID Case ID
CreatedByUser _CollectionsResubmission CreatedByUser User Name
ChangedBy _CollectionsResubmission ChangedBy User Name
ResubmissionStatus _CollectionsResubmission ResubmissionStatus Status
ResubmissionDueDate _CollectionsResubmission ResubmissionDueDate Resubmission Date
CreationDateTime _CollectionsResubmission CreationDateTime Timestamp
_CaseAttribute _CaseAttribute
_CollectionsResubmission _CollectionsResubmission
_CreatedByContactCard _CreatedByContactCard
_ChangedByContactCard _ChangedByContactCard

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_CollsInvoiceRelatedResubmsn.
-- 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_CollsInvoiceRelatedResubmsn AS
SELECT
  LogicalSystem,
  ObjectType,
  ObjectKey,
  RelationToLinkedObject,
  CaseUniqueID AS ResubmissionUUID,
  ObjectClassification,
  ObjectIsConfirmed,
  ObjectIsVoided,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  CaseID,
  _CollectionsResubmission.CreatedByUser AS CreatedByUser,
  _CollectionsResubmission.ChangedBy AS ChangedBy,
  _CollectionsResubmission.ResubmissionStatus AS ResubmissionStatus,
  _CollectionsResubmission.ResubmissionDueDate AS ResubmissionDueDate,
  _CollectionsResubmission.CreationDateTime AS CreationDateTime
FROM I_CollsInvoiceRelatedObject
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CreatedByContactCard ON createdbyuser = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ChangedByContactCard ON changedby = _ChangedByContactCard.ContactCardID  -- association [0..1]
;

Learn More