P_PromiseToPay1

DDL: P_PROMISETOPAY1 SQL: PPROMISETOPAY1 Type: view COMPOSITE Package: UDM_COLL_CDS
21 Fields 2 Data Sources

Promise To Pay 1

P_PromiseToPay1 is a Composite CDS View that provides data about "Promise To Pay 1" in SAP S/4HANA. It reads from 2 data sources (P_PromiseToPay0, I_CustomerContactAttribute) and exposes 21 fields with key field case_guid. Part of development package UDM_COLL_CDS.

Data Sources (2)

SourceAliasJoin Type
P_PromiseToPay0 p2p0 from
I_CustomerContactAttribute udm_cct_attr left_outer

Parameters (6)

NameTypeDefault
P_KeyDate sydate
P_DisplayCurrency vdm_v_display_currency
P_ExchangeRateType kurst_curr
P_NetDueInterval1InDays farp_due_interval1
P_NetDueInterval2InDays farp_due_interval2
P_NetDueInterval3InDays farp_due_interval3

Annotations (5)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PPROMISETOPAY1 view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY case_guid P_PromiseToPay0 case_guid UUID
CustomerContactUUID P_PromiseToPay0 CustomerContactUUID Customer Contact Key
GroupCurrency P_PromiseToPay0 GroupCurrency Ledger curr.
CompanyCode P_PromiseToPay0 CompanyCode Receiver Company Code
Customer P_PromiseToPay0 Customer Sold-to Party
PromisedAmount P_PromiseToPay0 PromisedAmount Promised Amount
PaidAmount P_PromiseToPay0 PaidAmount Paid Amount
SourceCurrency P_PromiseToPay0 SourceCurrency Valuation Crcy
DueDate P_PromiseToPay0 DueDate Promised For
CreationDate P_PromiseToPay0 CreationDate Time Stamp
Status P_PromiseToPay0 Status Workflow Status
CaseSystemStatus P_PromiseToPay0 CaseSystemStatus System Status
CustomerCntctFollowUpObjStatus P_PromiseToPay0 CustomerCntctFollowUpObjStatus
CollectionSpecialistUserName I_CustomerContactAttribute CollectionSpecialist Collection Specialist
CollectionSegment I_CustomerContactAttribute CollectionSegment Segment
PromiseToPayDueDays
DisplayCurrency
ExchangeRateType
NetDueInterval1InDays
NetDueInterval2InDays
NetDueInterval3InDays

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 P_PromiseToPay1.
-- 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.
-- SQL view name: PPROMISETOPAY1
-- Parameters: P_KeyDate : sydate, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr, P_NetDueInterval1InDays : farp_due_interval1, P_NetDueInterval2InDays : farp_due_interval2, P_NetDueInterval3InDays : farp_due_interval3

CREATE VIEW P_PromiseToPay1 AS
SELECT
  p2p0.case_guid AS case_guid,
  p2p0.CustomerContactUUID AS CustomerContactUUID,
  p2p0.GroupCurrency AS GroupCurrency,
  p2p0.CompanyCode AS CompanyCode,
  p2p0.Customer AS Customer,
  p2p0.PromisedAmount AS PromisedAmount,
  p2p0.PaidAmount AS PaidAmount,
  p2p0.SourceCurrency AS SourceCurrency,
  p2p0.DueDate AS DueDate,
  p2p0.CreationDate AS CreationDate,
  p2p0.Status AS Status,
  p2p0.CaseSystemStatus AS CaseSystemStatus,
  p2p0.CustomerCntctFollowUpObjStatus AS CustomerCntctFollowUpObjStatus,
  udm_cct_attr.CollectionSpecialist AS CollectionSpecialistUserName,
  udm_cct_attr.CollectionSegment AS CollectionSegment,
  dats_days_between(cast( :P_KeyDate as abap.dats(8)), p2p0.DueDate) AS PromiseToPayDueDays,
  :P_DisplayCurrency AS DisplayCurrency,
  :P_ExchangeRateType AS ExchangeRateType,
  :P_NetDueInterval1InDays AS NetDueInterval1InDays,
  :P_NetDueInterval2InDays AS NetDueInterval2InDays,
  :P_NetDueInterval3InDays AS NetDueInterval3InDays
FROM P_PromiseToPay0 AS p2p0
LEFT OUTER JOIN I_CustomerContactAttribute AS udm_cct_attr ON /* join condition not captured in parsed metadata */
;

Learn More