I_PPS_PurOrdPaytPlanItm

DDL: I_PPS_PURORDPAYTPLANITM Type: view_entity BASIC
17 Fields 1 Data Sources 2 Associations

PPS Purchase Order Payment Plan Item

I_PPS_PurOrdPaytPlanItm is a Basic CDS View that provides data about "PPS Purchase Order Payment Plan Item" in SAP S/4HANA. It reads from 1 data source (fplt) and exposes 17 fields with key fields PaymentPlan, PaymentPlanItem, PurchaseOrder, PurchaseOrderItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
fplt fplt from

Associations (2)

CardinalityTargetAliasCondition
[1] R_PurchasingDocumentItem _PurchasingDocumentItem fplt.fplnr = _PurchasingDocumentItem.InvoicingPlan
[1] I_PPS_PurchaseOrderPaymentPlan _PurchaseOrderPaymentPlan fplt.fplnr = _PurchaseOrderPaymentPlan.PaymentPlan

Annotations (9)

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

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PaymentPlan Invoicing plan
KEY PaymentPlanItem Item
KEY PurchaseOrder _PurchasingDocumentItem PurchasingDocument Purchasing Document
KEY PurchaseOrderItem _PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
PaymentPlanDateDescriptionCode tetxt Date Descript.
PaymentPlanItemAmountPercent fproz InvoicePercentg
PaymentPlanItemAmount fakwr Billing Value
PaymentPlanCurrency waers Transaction Currency
PaymentPlanSettlementFromDate fkdat Sett. Date
PaymentPlanSettlementToDate Sett. date
PaymentPlanInvoiceDate afdat Conf.req.date
PaymentPlanInvoiceStatus fksaf Billing status
PaymentPlanBlockReason faksp Billing block
PaymentPlanManualDateCode teman Manually
PaymentPlanInvoiceRule fareg Billing Rule
PaymentPlanDateCategory fpttp Object type
PaytPlnDteCrtnIsAutomatic _PurchaseOrderPaymentPlan PaytPlnDteCrtnIsAutomatic CreateDatesAut.

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_PPS_PurOrdPaytPlanItm.
-- 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_PPS_PurOrdPaytPlanItm AS
SELECT
  cast ( fplnr as rplnr ) AS PaymentPlan,
  cast ( fpltr as pps_e_paytplan_item preserving type ) AS PaymentPlanItem,
  _PurchasingDocumentItem.PurchasingDocument AS PurchaseOrder,
  _PurchasingDocumentItem.PurchasingDocumentItem AS PurchaseOrderItem,
  tetxt AS PaymentPlanDateDescriptionCode,
  fproz AS PaymentPlanItemAmountPercent,
  fakwr AS PaymentPlanItemAmount,
  waers AS PaymentPlanCurrency,
  fkdat AS PaymentPlanSettlementFromDate,
  cast ( nfdat as pps_e_paytplan_set_to_date preserving type ) AS PaymentPlanSettlementToDate,
  afdat AS PaymentPlanInvoiceDate,
  fksaf AS PaymentPlanInvoiceStatus,
  faksp AS PaymentPlanBlockReason,
  teman AS PaymentPlanManualDateCode,
  fareg AS PaymentPlanInvoiceRule,
  fpttp AS PaymentPlanDateCategory,
  _PurchaseOrderPaymentPlan.PaytPlnDteCrtnIsAutomatic AS PaytPlnDteCrtnIsAutomatic
FROM fplt
LEFT OUTER JOIN R_PurchasingDocumentItem AS _PurchasingDocumentItem ON fplt.fplnr = _PurchasingDocumentItem.InvoicingPlan  -- association [1]
LEFT OUTER JOIN I_PPS_PurchaseOrderPaymentPlan AS _PurchaseOrderPaymentPlan ON fplt.fplnr = _PurchaseOrderPaymentPlan.PaymentPlan  -- association [1]
;

Learn More