R_CollsPromiseToPayTP

DDL: R_COLLSPROMISETOPAYTP Type: view_entity TRANSACTIONAL
50 Fields 1 Data Sources 9 Associations

Promise To Pay

R_CollsPromiseToPayTP is a Transactional CDS View that provides data about "Promise To Pay" in SAP S/4HANA. It reads from 1 data source (I_CollsPromiseToPay) and exposes 50 fields with key field PromiseToPayUUID. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CollsPromiseToPay I_CollsPromiseToPay from

Associations (9)

CardinalityTargetAliasCondition
[0..*] I_CollsPrms2PInstallmentStatus _CollsPrms2PInstallmentStatus $projection.PromiseToPayUUID = _CollsPrms2PInstallmentStatus.PromiseToPayUUID
[0..*] I_CollsPromiseToPayPayment _CollsPromiseToPayPayment $projection.PromiseToPayUUID = _CollsPromiseToPayPayment.PromiseToPayUUID
[0..1] R_RblsMgmtUserContactCard _ChangedByContactCard $projection.CaseLastChangedBy = _ChangedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _CreatedByContactCard $projection.CaseCreatedBy = _CreatedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ClosedByContactCard $projection.CaseClosedBy = _ClosedByContactCard.ContactCardID
[0..1] R_CollectionsCustomerQuickView _CustomerQuickView $projection.Customer = _CustomerQuickView.Customer and $projection.CompanyCode = _CustomerQuickView.CompanyCode
[0..1] E_PromiseToPay _Extension $projection.PromiseToPayUUID = _Extension.PromiseToPayUUID
[0..*] R_CollsPromiseToPayInstlmntTP _CollsPromiseToPayInstlmntTP
[0..*] R_CollsPromiseToPayInvoiceTP _CollsPromiseToPayInvoiceTP

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Promise To Pay 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 PromiseToPayUUID view
ObjectModel.sapObjectNodeType.name PromiseToPay view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY PromiseToPayUUID PromiseToPayUUID Internal Key
CompanyCode CompanyCode Receiver Company Code
Customer Customer Sold-to Party
ObjectType ObjectType Type
LinkedInvoiceKey LinkedInvoiceKey Key
PromisedAmount PromisedAmount Promised Amount
PaidAmount PaidAmount Paid Amount
Currency Currency Valuation Crcy
DueDate DueDate Promised For
PromiseToPayDate PromiseToPayDate Promised On
LastPaymentDate LastPaymentDate Last Payment
PromiseToPayStatus PromiseToPayStatus State
PromiseToPayLevel PromiseToPayLevel Level
PromiseToPayGivenByPersonName PromiseToPayGivenByPersonName Promised By
ContactPersonEmailAddress ContactPersonEmailAddress Email
ContactPersonPhoneNumber ContactPersonPhoneNumber Telephone No.
ContactPersonFaxNumber ContactPersonFaxNumber Fax Number
ContactPersonFaxCountry ContactPersonFaxCountry C/R of Fax No.
ContactPerson ContactPerson Contact Person Key
NumberOfInstallments NumberOfInstallments Installments
PaidOnScheduleAmount PaidOnScheduleAmount Installment Amounts Paid on Schedule
PaidOffScheduleAmount PaidOffScheduleAmount Not on Schedule
NextInstallmentDueDate NextInstallmentDueDate Due Date of Next Open Installment
NextInstallmentAmount NextInstallmentAmount Open Amount
Prms2PToInvoiceGroupRefUUID Prms2PToInvoiceGroupRefUUID UUID
CaseID CaseID Case ID
CaseExternalReference CaseExternalReference External Reference
CaseCreatedBy CaseCreatedBy Created By
CaseCreatedOn CaseCreatedOn Created At
CaseLastChangedBy CaseLastChangedBy Changed By
CaseLastChangedOn CaseLastChangedOn Last Changed At
CaseClosedBy CaseClosedBy Closed By
CaseClosedTime CaseClosedTime Closed At
PromisedAmountForEdit PromisedAmount Promised Amount
IsCleared IsCleared Integer
_CaseAttribute _CaseAttribute
_ChangedByContactCard _ChangedByContactCard
_ClosedByContactCard _ClosedByContactCard
_CollsPromiseToPayStatus _CollsPromiseToPayStatus
_CompanyCode _CompanyCode
_Country _Country
_CreatedByContactCard _CreatedByContactCard
_Customer _Customer
_CollsPromiseToPayInstlmntTP _CollsPromiseToPayInstlmntTP
_CollsPromiseToPayInvoiceTP _CollsPromiseToPayInvoiceTP
_Currency _Currency
_CollsPrms2PInstallmentStatus _CollsPrms2PInstallmentStatus
_CollsPromiseToPayPayment _CollsPromiseToPayPayment
_CustomerQuickView _CustomerQuickView
_CustomerContact _CustomerContact

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_CollsPromiseToPayTP.
-- 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_CollsPromiseToPayTP AS
SELECT
  PromiseToPayUUID,
  CompanyCode,
  Customer,
  ObjectType,
  LinkedInvoiceKey,
  PromisedAmount,
  PaidAmount,
  Currency,
  DueDate,
  PromiseToPayDate,
  LastPaymentDate,
  PromiseToPayStatus,
  PromiseToPayLevel,
  PromiseToPayGivenByPersonName,
  ContactPersonEmailAddress,
  ContactPersonPhoneNumber,
  ContactPersonFaxNumber,
  ContactPersonFaxCountry,
  ContactPerson,
  NumberOfInstallments,
  PaidOnScheduleAmount,
  PaidOffScheduleAmount,
  NextInstallmentDueDate,
  NextInstallmentAmount,
  Prms2PToInvoiceGroupRefUUID,
  CaseID,
  CaseExternalReference,
  CaseCreatedBy,
  CaseCreatedOn,
  CaseLastChangedBy,
  CaseLastChangedOn,
  CaseClosedBy,
  CaseClosedTime,
  PromisedAmount AS PromisedAmountForEdit,
  IsCleared
FROM I_CollsPromiseToPay
LEFT OUTER JOIN I_CollsPrms2PInstallmentStatus AS _CollsPrms2PInstallmentStatus ON PromiseToPayUUID = _CollsPrms2PInstallmentStatus.PromiseToPayUUID  -- association [0..*]
LEFT OUTER JOIN I_CollsPromiseToPayPayment AS _CollsPromiseToPayPayment ON PromiseToPayUUID = _CollsPromiseToPayPayment.PromiseToPayUUID  -- association [0..*]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ChangedByContactCard ON CaseLastChangedBy = _ChangedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CreatedByContactCard ON CaseCreatedBy = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ClosedByContactCard ON CaseClosedBy = _ClosedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_CollectionsCustomerQuickView AS _CustomerQuickView ON Customer = _CustomerQuickView.Customer AND CompanyCode = _CustomerQuickView.CompanyCode  -- association [0..1]
LEFT OUTER JOIN E_PromiseToPay AS _Extension ON PromiseToPayUUID = _Extension.PromiseToPayUUID  -- association [0..1]
LEFT OUTER JOIN R_CollsPromiseToPayInstlmntTP AS _CollsPromiseToPayInstlmntTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CollsPromiseToPayInvoiceTP AS _CollsPromiseToPayInvoiceTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More