P_PurchaseOrderItemDateRange

DDL: P_PURCHASEORDERITEMDATERANGE SQL: PMMPOITMDR Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
28 Fields 1 Data Sources

Purchage Order Item for Date Range

P_PurchaseOrderItemDateRange is a Consumption CDS View that provides data about "Purchage Order Item for Date Range" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 28 fields with key fields PurchaseOrder, PurchaseOrderItem. Part of development package ODATA_MM_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItem _purchaseOrderItem from

Parameters (2)

NameTypeDefault
P_StartDate badat
P_EndDate badat

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMMPOITMDR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Purchage Order Item for Date Range view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchaseOrderItemUniqueID PurchaseOrderItemUniqueID Document Item
PurchaseOrderCategory PurchaseOrderCategory Doc. Category
MaterialGroup MaterialGroup Product Group
Material Material Vehicle Model
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
Customer Customer Sold-to Party
StorageLocation StorageLocation StorageLocation
CreatedByUser _PurchaseOrder CreatedByUser User Name
CreationDate _PurchaseOrder CreationDate Time Stamp
PurchasingOrganization _PurchaseOrder PurchasingOrganization Purchasing Organization
Supplier _PurchaseOrder Supplier Supplier
PurchasingGroup _PurchaseOrder PurchasingGroup Purchasing Group
_CompanyCode _CompanyCode
_Customer _Customer
_Material _Material
_MaterialGroup _MaterialGroup
_Plant _Plant
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItemCalcFields _PurchaseOrderItemCalcFields
_PurchaseOrderPricingElement _PurchaseOrderPricingElement
_PurgDocumentCategory _PurgDocumentCategory
_StorageLocation _StorageLocation
_Supplier _PurchaseOrder _Supplier
_PurchasingGroup _PurchaseOrder _PurchasingGroup
_PurchasingOrganization _PurchaseOrder _PurchasingOrganization

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_PurchaseOrderItemDateRange.
-- 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: PMMPOITMDR
-- Parameters: P_StartDate : badat, P_EndDate : badat

CREATE VIEW P_PurchaseOrderItemDateRange AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseOrderItemUniqueID,
  PurchaseOrderCategory,
  MaterialGroup,
  Material,
  CompanyCode,
  Plant,
  Customer,
  StorageLocation,
  _PurchaseOrder.CreatedByUser AS CreatedByUser,
  _PurchaseOrder.CreationDate AS CreationDate,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrder._Supplier AS _Supplier,
  _PurchaseOrder._PurchasingGroup AS _PurchasingGroup,
  _PurchaseOrder._PurchasingOrganization AS _PurchasingOrganization
FROM I_PurchaseOrderItem AS _purchaseOrderItem
;

Learn More