R_POInvoicingPlanItem

DDL: R_POINVOICINGPLANITEM Type: view_entity BASIC
16 Fields 2 Data Sources

Purchase Order Invoicing Plan Item

R_POInvoicingPlanItem is a Basic CDS View that provides data about "Purchase Order Invoicing Plan Item" in SAP S/4HANA. It reads from 2 data sources (P_BillingPlanItem, R_PurchaseOrderInvoicingPlan) and exposes 16 fields with key fields PurchaseOrder, PurchaseOrderItem, InvoicingPlanItem, InvoicingPlan.

Data Sources (2)

SourceAliasJoin Type
P_BillingPlanItem P_BillingPlanItem from
R_PurchaseOrderInvoicingPlan R_PurchaseOrderInvoicingPlan inner

Annotations (9)

NameValueLevelField
EndUserText.label Purchase Order Invoicing Plan Item view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey InvoicingPlanItem view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder R_PurchaseOrderInvoicingPlan PurchaseOrder Purchasing Document
KEY PurchaseOrderItem R_PurchaseOrderInvoicingPlan PurchaseOrderItem Purchasing Document Item
KEY InvoicingPlanItem P_BillingPlanItem BillingPlanItem Item
KEY InvoicingPlan P_BillingPlanItem BillingPlan Bill. Plan No.
InvoicingPlanSettlementFromDte P_BillingPlanItem BillingPlanServiceStartDate
InvoicingPlanSettlementToDte P_BillingPlanItem BillingPlanServiceEndDate
InvoicingPlanInvoicingDate P_BillingPlanItem BillingPlanBillingDate Conf.req.date
InvoicingPlanAmount P_BillingPlanItem BillingPlanAmount Billing Value
TransactionCurrency P_BillingPlanItem TransactionCurrency Transaction Currency
InvoicingPlanAmountPercent P_BillingPlanItem BillingPlanAmountPercent InvoicePercentg
PurchasingOrganization R_PurchaseOrderInvoicingPlan PurchasingOrganization Purchasing Organization
PurchasingGroup R_PurchaseOrderInvoicingPlan PurchasingGroup Purchasing Group
PurchaseOrderType R_PurchaseOrderInvoicingPlan PurchaseOrderType PO Type
Plant R_PurchaseOrderInvoicingPlan Plant Valuation Area
_TransactionCurrency P_BillingPlanItem _TransactionCurrency
_PurchaseOrder R_PurchaseOrderInvoicingPlan _PurchaseOrder

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_POInvoicingPlanItem.
-- 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_POInvoicingPlanItem AS
SELECT
  R_PurchaseOrderInvoicingPlan.PurchaseOrder AS PurchaseOrder,
  R_PurchaseOrderInvoicingPlan.PurchaseOrderItem AS PurchaseOrderItem,
  P_BillingPlanItem.BillingPlanItem AS InvoicingPlanItem,
  P_BillingPlanItem.BillingPlan AS InvoicingPlan,
  P_BillingPlanItem.BillingPlanServiceStartDate AS InvoicingPlanSettlementFromDte,
  P_BillingPlanItem.BillingPlanServiceEndDate AS InvoicingPlanSettlementToDte,
  P_BillingPlanItem.BillingPlanBillingDate AS InvoicingPlanInvoicingDate,
  P_BillingPlanItem.BillingPlanAmount AS InvoicingPlanAmount,
  P_BillingPlanItem.TransactionCurrency AS TransactionCurrency,
  P_BillingPlanItem.BillingPlanAmountPercent AS InvoicingPlanAmountPercent,
  R_PurchaseOrderInvoicingPlan.PurchasingOrganization AS PurchasingOrganization,
  R_PurchaseOrderInvoicingPlan.PurchasingGroup AS PurchasingGroup,
  R_PurchaseOrderInvoicingPlan.PurchaseOrderType AS PurchaseOrderType,
  R_PurchaseOrderInvoicingPlan.Plant AS Plant,
  P_BillingPlanItem._TransactionCurrency AS _TransactionCurrency,
  R_PurchaseOrderInvoicingPlan._PurchaseOrder AS _PurchaseOrder
FROM P_BillingPlanItem
INNER JOIN R_PurchaseOrderInvoicingPlan ON /* join condition not captured in parsed metadata */
;

Learn More