P_PurOrdSchedAcct1

DDL: P_PURORDSCHEDACCT1 SQL: PMMPOSCHEACCT1 Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
43 Fields 3 Data Sources

Scheduled Purchase Orders

P_PurOrdSchedAcct1 is a Consumption CDS View that provides data about "Scheduled Purchase Orders" in SAP S/4HANA. It reads from 3 data sources (I_PurchaseOrder, I_PurchaseOrderItem, I_PurchaseOrderScheduleLine) and exposes 43 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine. Part of development package ODATA_MM_ANALYTICS.

Data Sources (3)

SourceAliasJoin Type
I_PurchaseOrder PurchaseOrder inner
I_PurchaseOrderItem PurchaseOrderItem from
I_PurchaseOrderScheduleLine ScheduleLine inner

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate bedat
P_EndDate bedat

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PMMPOSCHEACCT1 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Scheduled Purchase Orders view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.preserveKey true view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderItem PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY ScheduleLine I_PurchaseOrderScheduleLine ScheduleLine Schedule Line
PurchaseOrderCategory I_PurchaseOrderItem PurchaseOrderCategory Doc. Category
PurchaseOrderItemCategory I_PurchaseOrderItem PurchaseOrderItemCategory Item Category
PurchaseRequisition I_PurchaseOrderItem PurchaseRequisition Requisition
PurchaseRequisitionItem I_PurchaseOrderItem PurchaseRequisitionItem Requisn. item
PurchaseOrderType PurchaseOrderType PO Type
PurchaseOrderDate I_PurchaseOrder PurchaseOrderDate PO Date
Supplier I_PurchaseOrder Supplier Supplier
CompanyCode I_PurchaseOrder CompanyCode Receiver Company Code
ReceivingCompanyCode I_PurchaseOrderItem CompanyCode Receiver Company Code
PurchasingGroup I_PurchaseOrder PurchasingGroup Purchasing Group
PurchasingOrganization I_PurchaseOrder PurchasingOrganization Purchasing Organization
MaterialGroup I_PurchaseOrderItem MaterialGroup Product Group
Material I_PurchaseOrderItem Material Vehicle Model
Plant I_PurchaseOrderItem Plant Valuation Area
ProductType I_PurchaseOrderItem ProductType Product Type Group
ServicePerformer I_PurchaseOrderItem ServicePerformer Service Performer
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
SchedLineStscDeliveryDate SchedLineStscDeliveryDate Stat. Del. Date
PerformancePeriodStartDate PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate PerformancePeriodEndDate End of Performance Period
ScheduleLineDeliveryTime ScheduleLineDeliveryTime Time
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
RoughGoodsReceiptQty RoughGoodsReceiptQty Delivered
CreatedByUser I_PurchaseOrder CreatedByUser User Name
PurchaseContract I_PurchaseOrderItem PurchaseContract Purchasing Doc.
PurchaseContractItem I_PurchaseOrderItem PurchaseContractItem Item
MultipleAcctAssgmtDistribution I_PurchaseOrderItem MultipleAcctAssgmtDistribution Distribution
AccountAssignmentCategory I_PurchaseOrderItem AccountAssignmentCategory Acct Assgmt Cat
PurchaseOrderQuantityUnit I_PurchaseOrderItem PurchaseOrderQuantityUnit Order Unit
DisplayCurrency
Currency I_PurchaseOrderItem DocumentCurrency Document Currency
ReturnsItem
NetPriceAmount Net Price
NetPriceQuantity NetPriceQuantity Price Unit
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr Equal To
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr Denominator
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
_PurchaseRequisition I_PurchaseOrderItem _PurchaseRequisition
_PurchaseRequisitionItem I_PurchaseOrderItem _PurchaseRequisitionItem

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 P_PurOrdSchedAcct1.
-- 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.
-- SQL view name: PMMPOSCHEACCT1
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_PurOrdSchedAcct1 AS
SELECT
  PurchaseOrderItem.PurchaseOrder AS PurchaseOrder,
  PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  ScheduleLine.ScheduleLine AS ScheduleLine,
  PurchaseOrderItem.PurchaseOrderCategory AS PurchaseOrderCategory,
  PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  PurchaseOrderItem.PurchaseRequisition AS PurchaseRequisition,
  PurchaseOrderItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurchaseOrderType,
  PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder.CompanyCode AS CompanyCode,
  PurchaseOrderItem.CompanyCode AS ReceivingCompanyCode,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  PurchaseOrderItem.Material AS Material,
  PurchaseOrderItem.Plant AS Plant,
  PurchaseOrderItem.ProductType AS ProductType,
  PurchaseOrderItem.ServicePerformer AS ServicePerformer,
  ScheduleLineDeliveryDate,
  SchedLineStscDeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  ScheduleLineDeliveryTime,
  ScheduleLineOrderQuantity,
  RoughGoodsReceiptQty,
  PurchaseOrder.CreatedByUser AS CreatedByUser,
  PurchaseOrderItem.PurchaseContract AS PurchaseContract,
  PurchaseOrderItem.PurchaseContractItem AS PurchaseContractItem,
  PurchaseOrderItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  PurchaseOrderItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  cast( :P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  PurchaseOrderItem.DocumentCurrency AS Currency,
  cast( case when PurchaseOrderItem.IsReturnsItem = 'X' then -1 else 1 end as int2 ) AS ReturnsItem,
  cast(NetPriceAmount as abap.curr(21,5)) AS NetPriceAmount,
  NetPriceQuantity,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  PurchaseOrderItem._PurchaseRequisition AS _PurchaseRequisition,
  PurchaseOrderItem._PurchaseRequisitionItem AS _PurchaseRequisitionItem
FROM I_PurchaseOrderItem AS PurchaseOrderItem
INNER JOIN I_PurchaseOrder AS PurchaseOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchaseOrderScheduleLine AS ScheduleLine ON /* join condition not captured in parsed metadata */
;

Learn More