P_CNTRLPURFUTURESPEND

DDL: P_CNTRLPURFUTURESPEND SQL: PCNTRLPOSPND Type: view CONSUMPTION
32 Fields 1 Data Sources

Central PO Future Spend

P_CNTRLPURFUTURESPEND is a Consumption CDS View that provides data about "Central PO Future Spend" in SAP S/4HANA. It reads from 1 data source (P_CntrlPurchasingSpend) and exposes 32 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine, ProcurementHubSourceSystem.

Data Sources (1)

SourceAliasJoin Type
P_CntrlPurchasingSpend P_CntrlPurchasingSpend from

Parameters (2)

NameTypeDefault
P_StartDate bedat
P_EndDate bedat

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PCNTRLPOSPND view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Central PO Future Spend view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY ScheduleLine ScheduleLine Schedule Line
KEY ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
Supplier Supplier Supplier
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
SchedLineStscDeliveryDate SchedLineStscDeliveryDate Stat. Del. Date
PurchaseOrderDate PurchaseOrderDate PO Date
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
PurchaseOrderType PurchaseOrderType PO Type
CreatedByUser CreatedByUser User Name
CreatedByUserName CreatedByUserName Person Resp.
IsReturnsItem IsReturnsItem Returns Item
AnalyticalReportingCurrency AnalyticalReportingCurrency
AnalyticalReportingCurrency2 AnalyticalReportingCurrency2
DocumentCurrency DocumentCurrency Document Currency
OrderQuantityUnit OrderQuantityUnit Sales Unit
NetAmountInReportingCurrency NetAmountInReportingCurrency
NetAmountInReportingCurrency2 NetAmountInReportingCurrency2
NetAmount NetAmount Stated Amount
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
OrderQuantity OrderQuantity Quantity
ReturnItems
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
NetPriceQuantity NetPriceQuantity Price Unit

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_CNTRLPURFUTURESPEND.
-- 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: PCNTRLPOSPND
-- Parameters: P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_CNTRLPURFUTURESPEND AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  ScheduleLine,
  ProcurementHubSourceSystem,
  Supplier,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  Material,
  MaterialGroup,
  Plant,
  ScheduleLineDeliveryDate,
  SchedLineStscDeliveryDate,
  PurchaseOrderDate,
  PurchasingDocumentItemCategory,
  PurchaseOrderType,
  CreatedByUser,
  CreatedByUserName,
  IsReturnsItem,
  AnalyticalReportingCurrency,
  AnalyticalReportingCurrency2,
  DocumentCurrency,
  OrderQuantityUnit,
  NetAmountInReportingCurrency,
  NetAmountInReportingCurrency2,
  NetAmount,
  ScheduleLineOrderQuantity,
  OrderQuantity,
  cast(case when IsReturnsItem = 'X' then -1 else 1 end as abap.dec( 2, 0 ) ) AS ReturnItems,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  NetPriceQuantity
FROM P_CntrlPurchasingSpend
;

Learn More