C_PPS_PurOrdPaytPlanItmTP_2

DDL: C_PPS_PURORDPAYTPLANITMTP_2 Type: view_entity CONSUMPTION
22 Fields 1 Data Sources

PPS Pur Order Payment Plan Item - TP

C_PPS_PurOrdPaytPlanItmTP_2 is a Consumption CDS View that provides data about "PPS Pur Order Payment Plan Item - TP" in SAP S/4HANA. It reads from 1 data source (R_PPS_PurOrdPaytPlanItmTP) and exposes 22 fields with key fields PaymentPlan, PaymentPlanItem, PurchaseOrder, PurchaseOrderItem.

Data Sources (1)

SourceAliasJoin Type
R_PPS_PurOrdPaytPlanItmTP R_PPS_PurOrdPaytPlanItmTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label PPS Pur Order Payment Plan Item - TP view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view

Fields (22)

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.
PaymentPlanDateDescriptionText
PaymentPlanItemAmountPercent PaymentPlanItemAmountPercent InvoicePercentg
PaymentPlanItemAmount PaymentPlanItemAmount Billing Value
PaymentPlanCurrency PaymentPlanCurrency Currency
PaymentPlanSettlementFromDate PaymentPlanSettlementFromDate Sett. Date
PaymentPlanSettlementToDate PaymentPlanSettlementToDate Sett. date
PaymentPlanInvoiceDate PaymentPlanInvoiceDate Billing Date
virtualPaymentPlanInvoiceStatusfksaf
PaymentPlanBlockReason PaymentPlanBlockReason Billing block
PaymentPlanBlockReasonText
PaymentPlanManualDateCode PaymentPlanManualDateCode Manually
PaymentPlanInvoiceRule PaymentPlanInvoiceRule Billing Rule
PaymentPlanInvoiceRuleText
PaytPlnDteCrtnIsAutomatic PaytPlnDteCrtnIsAutomatic CreateDatesAut.
PaymentPlanDateCategory PaymentPlanDateCategory Date category
PaymentPlanDateCategoryText
UICT_PARTPAYMENTPLAN

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_PurOrdPaytPlanItmTP_2.
-- 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_PurOrdPaytPlanItmTP_2 AS
SELECT
  PaymentPlan,
  PaymentPlanItem,
  PurchaseOrder,
  PurchaseOrderItem,
  PaymentPlanDateDescriptionCode,
  _PaytPlnDateDesc._Text[1:Language = $session.system_language].BillingPlanBillingDateText AS PaymentPlanDateDescriptionText,
  PaymentPlanItemAmountPercent,
  PaymentPlanItemAmount,
  PaymentPlanCurrency,
  PaymentPlanSettlementFromDate,
  PaymentPlanSettlementToDate,
  PaymentPlanInvoiceDate,
  virtual PaymentPlanInvoiceStatus : fksaf AS virtualPaymentPlanInvoiceStatusfksaf,
  PaymentPlanBlockReason,
  _BillingBlockReason._Text[1:Language = $session.system_language].BillingBlockReasonDescription AS PaymentPlanBlockReasonText,
  PaymentPlanManualDateCode,
  PaymentPlanInvoiceRule,
  _PaytPlanInvoiceRule._Text[1:Language = $session.system_language].PaymentPlanInvoiceRuleText AS PaymentPlanInvoiceRuleText,
  PaytPlnDteCrtnIsAutomatic,
  PaymentPlanDateCategory,
  _PaytPlanInvoiceDateCategory._Text[1:Language = $session.system_language].PaymentPlanDateCategoryText AS PaymentPlanDateCategoryText
FROM R_PPS_PurOrdPaytPlanItmTP
;

Learn More