I_CollsInvoiceRelatedPrms2P

DDL: I_COLLSINVOICERELATEDPRMS2P Type: view COMPOSITE
21 Fields 1 Data Sources 3 Associations

Promise To Pay Related to Invoice

I_CollsInvoiceRelatedPrms2P is a Composite CDS View that provides data about "Promise To Pay Related to Invoice" in SAP S/4HANA. It reads from 1 data source (I_CollsInvoiceRelatedObject) and exposes 21 fields with key fields LogicalSystem, ObjectType, ObjectKey, RelationToLinkedObject, CaseUniqueID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CollsInvoiceRelatedObject I_CollsInvoiceRelatedObject from

Associations (3)

CardinalityTargetAliasCondition
[0..1] R_RblsMgmtUserContactCard _CreatedByContactCard $projection.CaseCreatedBy = _CreatedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ChangedByContactCard $projection.CaseLastChangedBy = _ChangedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ClosedByContactCard $projection.CaseClosedBy = _ClosedByContactCard.ContactCardID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ICOLLSINVRELP2P view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Promise To Pay Related to Invoice view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey CaseUniqueID view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY LogicalSystem LogicalSystem Logical System
KEY ObjectType ObjectType Type
KEY ObjectKey ObjectKey Object Key
KEY RelationToLinkedObject RelationToLinkedObject Relationsh.Cat.
KEY CaseUniqueID 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
CaseCreatedBy _CollsPromiseToPay CaseCreatedBy Created By
CaseLastChangedBy _CollsPromiseToPay CaseLastChangedBy Changed By
CaseClosedBy _CollsPromiseToPay CaseClosedBy Closed By
_CaseAttribute _CaseAttribute
_CollsPromiseToPay _CollsPromiseToPay
_CreatedByContactCard _CreatedByContactCard
_ChangedByContactCard _ChangedByContactCard
_ClosedByContactCard _ClosedByContactCard

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_CollsInvoiceRelatedPrms2P.
-- 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_CollsInvoiceRelatedPrms2P AS
SELECT
  LogicalSystem,
  ObjectType,
  ObjectKey,
  RelationToLinkedObject,
  CaseUniqueID,
  ObjectClassification,
  ObjectIsConfirmed,
  ObjectIsVoided,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  CaseID,
  _CollsPromiseToPay.CaseCreatedBy AS CaseCreatedBy,
  _CollsPromiseToPay.CaseLastChangedBy AS CaseLastChangedBy,
  _CollsPromiseToPay.CaseClosedBy AS CaseClosedBy
FROM I_CollsInvoiceRelatedObject
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CreatedByContactCard ON CaseCreatedBy = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ChangedByContactCard ON CaseLastChangedBy = _ChangedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ClosedByContactCard ON CaseClosedBy = _ClosedByContactCard.ContactCardID  -- association [0..1]
;

Learn More