R_PPS_PurOrdPaytPlanItmTP

DDL: R_PPS_PURORDPAYTPLANITMTP Type: view_entity TRANSACTIONAL
25 Fields 1 Data Sources 7 Associations

PPS Pur Order Payment Plan Item - TP

R_PPS_PurOrdPaytPlanItmTP is a Transactional CDS View that provides data about "PPS Pur Order Payment Plan Item - TP" in SAP S/4HANA. It reads from 1 data source (I_PPS_PurOrdPaytPlanItm) and exposes 25 fields with key fields PaymentPlan, PaymentPlanItem, PurchaseOrder, PurchaseOrderItem. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PPS_PurOrdPaytPlanItm I_PPS_PurOrdPaytPlanItm from

Associations (7)

CardinalityTargetAliasCondition
[1..1] R_PPS_PurchaseOrderTP _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] R_PPS_PurchaseOrderItemTP _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
[0..1] I_Bpsddaterule _PaytPlnDateDesc $projection.PaymentPlanDateDescriptionCode = _PaytPlnDateDesc.BillingPlanBillingDateRule
[0..1] I_BillingBlockReason _BillingBlockReason $projection.PaymentPlanBlockReason = _BillingBlockReason.BillingBlockReason
[0..1] I_PPS_PaytPlanInvoiceStatusVH _PaytPlanInvoiceStatusVH $projection.PaymentPlanInvoiceStatus = _PaytPlanInvoiceStatusVH.DomainValue
[0..1] I_PPS_PaymentPlanInvoiceRule _PaytPlanInvoiceRule $projection.PaymentPlanInvoiceRule = _PaytPlanInvoiceRule.DomainValue
[0..1] I_PPS_PaymentPlanDateCategory _PaytPlanInvoiceDateCategory $projection.PaymentPlanDateCategory = _PaytPlanInvoiceDateCategory.PaymentPlanDateCategory

Annotations (9)

NameValueLevelField
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label PPS Pur Order Payment Plan Item - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY PaymentPlan PaymentPlan Paym.Ca.Pl.No.
KEY PaymentPlanItem PaymentPlanItem Item
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PaymentPlanDateDescriptionCode PaymentPlanDateDescriptionCode Date Descript.
PaymentPlanItemAmountPercent PaymentPlanItemAmountPercent InvoicePercentg
PaymentPlanItemAmount PaymentPlanItemAmount Billing Value
PaymentPlanCurrency PaymentPlanCurrency Currency
PaymentPlanSettlementFromDate PaymentPlanSettlementFromDate Sett. Date
PaymentPlanSettlementToDate PaymentPlanSettlementToDate Sett. date
PaymentPlanInvoiceDate PaymentPlanInvoiceDate Billing Date
PaymentPlanInvoiceStatus PaymentPlanInvoiceStatus Billing status
PaymentPlanBlockReason PaymentPlanBlockReason Billing block
PaymentPlanManualDateCode PaymentPlanManualDateCode Manually
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_PurOrdPaytPlanTP _PurOrdPaytPlanTP
PaymentPlanDateCategory PaymentPlanDateCategory Date category
PaytPlnDteCrtnIsAutomatic PaytPlnDteCrtnIsAutomatic CreateDatesAut.
PaymentPlanInvoiceRule PaymentPlanInvoiceRule Billing Rule
_PaytPlnDateDesc _PaytPlnDateDesc
_PaytPlanInvoiceStatusVH _PaytPlanInvoiceStatusVH
_BillingBlockReason _BillingBlockReason
_PaytPlanInvoiceRule _PaytPlanInvoiceRule
_PaytPlanInvoiceDateCategory _PaytPlanInvoiceDateCategory

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_PPS_PurOrdPaytPlanItmTP.
-- 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_PPS_PurOrdPaytPlanItmTP AS
SELECT
  PaymentPlan,
  PaymentPlanItem,
  PurchaseOrder,
  PurchaseOrderItem,
  PaymentPlanDateDescriptionCode,
  PaymentPlanItemAmountPercent,
  PaymentPlanItemAmount,
  PaymentPlanCurrency,
  PaymentPlanSettlementFromDate,
  PaymentPlanSettlementToDate,
  PaymentPlanInvoiceDate,
  PaymentPlanInvoiceStatus,
  PaymentPlanBlockReason,
  PaymentPlanManualDateCode,
  PaymentPlanDateCategory,
  PaytPlnDteCrtnIsAutomatic,
  PaymentPlanInvoiceRule
FROM I_PPS_PurOrdPaytPlanItm
LEFT OUTER JOIN R_PPS_PurchaseOrderTP AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN R_PPS_PurchaseOrderItemTP AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_Bpsddaterule AS _PaytPlnDateDesc ON PaymentPlanDateDescriptionCode = _PaytPlnDateDesc.BillingPlanBillingDateRule  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _BillingBlockReason ON PaymentPlanBlockReason = _BillingBlockReason.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_PPS_PaytPlanInvoiceStatusVH AS _PaytPlanInvoiceStatusVH ON PaymentPlanInvoiceStatus = _PaytPlanInvoiceStatusVH.DomainValue  -- association [0..1]
LEFT OUTER JOIN I_PPS_PaymentPlanInvoiceRule AS _PaytPlanInvoiceRule ON PaymentPlanInvoiceRule = _PaytPlanInvoiceRule.DomainValue  -- association [0..1]
LEFT OUTER JOIN I_PPS_PaymentPlanDateCategory AS _PaytPlanInvoiceDateCategory ON PaymentPlanDateCategory = _PaytPlanInvoiceDateCategory.PaymentPlanDateCategory  -- association [0..1]
;

Learn More