R_CollsPromiseToPayInvoiceTP

DDL: R_COLLSPROMISETOPAYINVOICETP Type: view_entity TRANSACTIONAL
15 Fields 1 Data Sources 1 Associations

Promise To Pay Invoice

R_CollsPromiseToPayInvoiceTP is a Transactional CDS View that provides data about "Promise To Pay Invoice" in SAP S/4HANA. It reads from 1 data source (P_CollsPromiseToPayInvoice) and exposes 15 fields with key fields PromiseToPayUUID, LinkedInvoiceKey. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_CollsPromiseToPayInvoice P_CollsPromiseToPayInvoice from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Currency _Currency $projection.Currency = _Currency.Currency

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Promise To Pay Invoice view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.representativeKey LinkedInvoiceKey view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PromiseToPayUUID PromiseToPayUUID Internal Key
KEY LinkedInvoiceKey LinkedInvoiceKey Key
CompanyCode CompanyCode Receiver Company Code
AccountingDocument AccountingDocument Journal Entry
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocumentItem AccountingDocumentItem Posting View Item
NetDueDate NetDueDate Net Due Date
OverdueDays
OpenAmountInDocumentCurrency OpenAmountInDocumentCurrency
PromisedAmount PromisedAmount Promised Amount
Currency Currency Valuation Crcy
_CollectionsInvoice _CollectionsInvoice
_CompanyCode _CompanyCode
_Currency _Currency
_CollsPromiseToPayTP _CollsPromiseToPayTP

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_CollsPromiseToPayInvoiceTP.
-- 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_CollsPromiseToPayInvoiceTP AS
SELECT
  PromiseToPayUUID,
  LinkedInvoiceKey,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  NetDueDate,
  case when OverdueDays <= -100000 then -9999 else cast(OverdueDays as coll_p2p_days_in_arrears) end AS OverdueDays,
  OpenAmountInDocumentCurrency,
  PromisedAmount,
  Currency
FROM P_CollsPromiseToPayInvoice
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
;

Learn More