C_PPS_PurOrdPaytPlanTP

DDL: C_PPS_PURORDPAYTPLANTP Type: view_entity CONSUMPTION
17 Fields 1 Data Sources 1 Associations

Purchase Order Payment Plan Consumption

C_PPS_PurOrdPaytPlanTP is a Consumption CDS View that provides data about "Purchase Order Payment Plan Consumption" in SAP S/4HANA. It reads from 1 data source (R_PPS_PurOrdPaytPlanTP) and exposes 17 fields with key fields PaymentPlan, PurchaseOrder, PurchaseOrderItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_PPS_PurOrdPaytPlanTP R_PPS_PurOrdPaytPlanTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_PPS_PaymentPlanTypeValueHelp _PaymentPlanTypeVH $projection.PaymentPlanType = _PaymentPlanTypeVH.PaymentPlanType

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
EndUserText.label Purchase Order Payment Plan Consumption view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey PaymentPlan view
Metadata.ignorePropagatedAnnotations true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PaymentPlan PaymentPlan Paym.Ca.Pl.No.
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PaymentPlanType PaymentPlanType Payment Plan Type
PaytPlnHrznDateDetermineRule PaytPlnHrznDateDetermineRule Horizon
PaymentPlanNextInvoiceDateRule PaymentPlanNextInvoiceDateRule Next Bill. Date
PaymentPlanStartDate PaymentPlanStartDate Start date
PaymentPlanStartDateRule PaymentPlanStartDateRule OriginStartDate
PaymentPlanEndDate PaymentPlanEndDate End date
FactoryCalendar FactoryCalendar Factory Calendar
PaymentPlanTotalAmount PaymentPlanTotalAmount Distributed Amount
PaymentPlanTotalAmountPercent PaymentPlanTotalAmountPercent Distributed Percentage
PaymentPlanCurrency PaymentPlanCurrency Currency
virtualPaymentPlanHorizonDatehoriz
virtualUICT_HdeNnPartPymntPlnboolean
virtualUICT_HdeNnPerdcPymntPlnboolean
_PaymentPlanTypeVH _PaymentPlanTypeVH

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 C_PPS_PurOrdPaytPlanTP.
-- 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 C_PPS_PurOrdPaytPlanTP AS
SELECT
  PaymentPlan,
  PurchaseOrder,
  PurchaseOrderItem,
  PaymentPlanType,
  PaytPlnHrznDateDetermineRule,
  PaymentPlanNextInvoiceDateRule,
  PaymentPlanStartDate,
  PaymentPlanStartDateRule,
  PaymentPlanEndDate,
  FactoryCalendar,
  PaymentPlanTotalAmount,
  PaymentPlanTotalAmountPercent,
  PaymentPlanCurrency,
  virtual PaymentPlanHorizonDate : horiz AS virtualPaymentPlanHorizonDatehoriz,
  virtual UICT_HdeNnPartPymntPln : boolean AS virtualUICT_HdeNnPartPymntPlnboolean,
  virtual UICT_HdeNnPerdcPymntPln : boolean AS virtualUICT_HdeNnPerdcPymntPlnboolean
FROM R_PPS_PurOrdPaytPlanTP
LEFT OUTER JOIN C_PPS_PaymentPlanTypeValueHelp AS _PaymentPlanTypeVH ON PaymentPlanType = _PaymentPlanTypeVH.PaymentPlanType  -- association [1..1]
;

Learn More