P_PurOrdSchedFutureExtnd

DDL: P_PURORDSCHEDFUTUREEXTND SQL: PPOSCHFUTREXTND Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
47 Fields 1 Data Sources

Sched Future PO from Extnd Anlytc Table

P_PurOrdSchedFutureExtnd is a Consumption CDS View that provides data about "Sched Future PO from Extnd Anlytc Table" in SAP S/4HANA. It reads from 1 data source (I_PurgDocScheduleLineEnhanced) and exposes 47 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine. Part of development package ODATA_MM_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
I_PurgDocScheduleLineEnhanced PurgDocEnhanced from

Parameters (2)

NameTypeDefault
P_Date sydatum
P_DisplayCurrency displaycurrency

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPOSCHFUTREXTND view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Sched Future PO from Extnd Anlytc Table view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchasingDocumentItem Purchasing Doc. Item
KEY ScheduleLine ScheduleLine Schedule Line
PURCHASEORDERCATEGORY I_PurgDocScheduleLineEnhanced PurchasingDocumentCategory Doc. Category
PURCHASEORDERITEMCATEGORY I_PurgDocScheduleLineEnhanced PurchasingDocumentItemCategory Item Category
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
PURCHASEORDERTYPE I_PurgDocScheduleLineEnhanced PurchasingDocumentType RFQ Type
PurchaseOrderDate PurchasingDocumentOrderDate PO Date
Supplier Supplier Supplier
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingOrganization PurchasingOrganization Purchasing Organization
CompanyCode CompanyCode Receiver Company Code
PurgDocHdrCompanyCode PurgDocHdrCompanyCode Company Code
MaterialGroup MaterialGroup Product Group
Material Material Vehicle Model
Plant Plant Valuation Area
ProductType ProductTypeCode Product Type Group
ServicePerformer 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 CreatedByUser User Name
PurchaseContract PurchaseContract Purchasing Doc.
PurchaseContractItem PurchaseContractItem Item
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution Distribution
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
PurchaseOrderQuantityUnit PurgDocOrderQuantityUnit Purchasing Document Order Qty Unit
DisplayCurrency
Currency DocumentCurrency Document Currency
PurOrdNetAmountInDisplayCrcy NetAmountInReportingCurrency Net Amt Rpting Crcy1
NetAmountInReportingCurrency2 NetAmountInReportingCurrency2 Net Amt Rpting Crcy2
NetAmount NetAmount Stated Amount
NetPriceInReportingCurrency NetPriceInReportingCurrency Net Price: Re. Cu. 1
NetPriceInReportingCurrency2 NetPriceInReportingCurrency2 Net Price: Re. Cu. 2
NetPriceAmount Net Price
AnalyticalReportingCurrency AnalyticalReportingCurrency Reporting Currency 1
AnalyticalReportingCurrency2 AnalyticalReportingCurrency2 Reporting Currency 2
NetPriceQuantity NetPriceQuantity Price Unit
DocumentCurrency DocumentCurrency Document Currency
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
ReturnsItem

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_PurOrdSchedFutureExtnd.
-- 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: PPOSCHFUTREXTND
-- Parameters: P_Date : sydatum, P_DisplayCurrency : displaycurrency

CREATE VIEW P_PurOrdSchedFutureExtnd AS
SELECT
  cast( PurchasingDocument as vdm_purchaseorder) AS PurchaseOrder,
  PurchasingDocumentItem AS PurchaseOrderItem,
  ScheduleLine,
  PurgDocEnhanced.PurchasingDocumentCategory AS PURCHASEORDERCATEGORY,
  PurgDocEnhanced.PurchasingDocumentItemCategory AS PURCHASEORDERITEMCATEGORY,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurgDocEnhanced.PurchasingDocumentType AS PURCHASEORDERTYPE,
  PurchasingDocumentOrderDate AS PurchaseOrderDate,
  Supplier,
  PurchasingGroup,
  PurchasingOrganization,
  CompanyCode,
  PurgDocHdrCompanyCode,
  MaterialGroup,
  Material,
  Plant,
  ProductTypeCode AS ProductType,
  ServicePerformer,
  ScheduleLineDeliveryDate,
  SchedLineStscDeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  ScheduleLineDeliveryTime,
  ScheduleLineOrderQuantity,
  RoughGoodsReceiptQty,
  CreatedByUser,
  PurchaseContract,
  PurchaseContractItem,
  MultipleAcctAssgmtDistribution,
  AccountAssignmentCategory,
  PurgDocOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  cast( :P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  DocumentCurrency AS Currency,
  NetAmountInReportingCurrency AS PurOrdNetAmountInDisplayCrcy,
  NetAmountInReportingCurrency2,
  NetAmount,
  NetPriceInReportingCurrency,
  NetPriceInReportingCurrency2,
  cast(NetPriceAmount as abap.curr(21,5)) AS NetPriceAmount,
  AnalyticalReportingCurrency,
  AnalyticalReportingCurrency2,
  NetPriceQuantity,
  DocumentCurrency,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  cast( case when IsReturnsItem = 'X' then -1 else 1 end as int2 ) AS ReturnsItem
FROM I_PurgDocScheduleLineEnhanced AS PurgDocEnhanced
;

Learn More