I_CAPromiseToPayDueDate

DDL: I_CAPROMISETOPAYDUEDATE Type: view_entity BASIC
13 Fields 1 Data Sources 2 Associations

Promise To Pay Due Date

I_CAPromiseToPayDueDate is a Basic CDS View that provides data about "Promise To Pay Due Date" in SAP S/4HANA. It reads from 1 data source (dfkkppd) and exposes 13 fields with key fields CAPromiseToPay, CAPromisedPaymentDate. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
dfkkppd dfkkppd from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CAPromiseToPay _CAPromiseToPay $projection.CAPromiseToPay = _CAPromiseToPay.CAPromiseToPay
[1..1] I_Currency _CompanyCodeCurrency $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Promise To Pay Due Date view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CAPromiseToPay ppkey Promise to Pay
KEY CAPromisedPaymentDate prdat Valid to
CAPromisedAmountInTransCrcy pramt Amount
CAOpenPromisedAmtInTransCrcy pramo To Be Paid
CAPromisedAmountInLoclCrcy fddbt Amount
CAOpenPromisedAmountInLoclCrcy fddbo To Be Paid
CAInstlmntHasIntrstAndOrChrgs xadda Int. and Chrges
CompanyCode _CAPromiseToPay CompanyCode Receiver Company Code
PaymentCurrency _CAPromiseToPay PaymentCurrency Payment Currency
CompanyCodeCurrency
_CAPromiseToPay _CAPromiseToPay
_PaymentCurrency _CAPromiseToPay _PaymentCurrency
_CompanyCodeCurrency _CompanyCodeCurrency

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_CAPromiseToPayDueDate.
-- 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_CAPromiseToPayDueDate AS
SELECT
  ppkey AS CAPromiseToPay,
  prdat AS CAPromisedPaymentDate,
  pramt AS CAPromisedAmountInTransCrcy,
  pramo AS CAOpenPromisedAmtInTransCrcy,
  fddbt AS CAPromisedAmountInLoclCrcy,
  fddbo AS CAOpenPromisedAmountInLoclCrcy,
  xadda AS CAInstlmntHasIntrstAndOrChrgs,
  _CAPromiseToPay.CompanyCode AS CompanyCode,
  _CAPromiseToPay.PaymentCurrency AS PaymentCurrency,
  _CAPromiseToPay._CompanyCode.Currency AS CompanyCodeCurrency,
  _CAPromiseToPay._PaymentCurrency AS _PaymentCurrency
FROM dfkkppd
LEFT OUTER JOIN I_CAPromiseToPay AS _CAPromiseToPay ON CAPromiseToPay = _CAPromiseToPay.CAPromiseToPay  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
;

Learn More