P_PurchaseOrderItemDateRange

DDL: P_PURCHASEORDERITEMDATERANGE SQL: PMMPOITMDR Type: view CONSUMPTION

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.

1 data source(s) 28 fields

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
KEY PurchaseOrderItem PurchaseOrderItem
PurchaseOrderItemUniqueID PurchaseOrderItemUniqueID
PurchaseOrderCategory PurchaseOrderCategory
MaterialGroup MaterialGroup
Material Material
CompanyCode CompanyCode
Plant Plant
Customer Customer
StorageLocation StorageLocation
CreatedByUser _PurchaseOrder CreatedByUser
CreationDate _PurchaseOrder CreationDate
PurchasingOrganization _PurchaseOrder PurchasingOrganization
Supplier _PurchaseOrder Supplier
PurchasingGroup _PurchaseOrder PurchasingGroup
_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 
@AbapCatalog.sqlViewName: 'PMMPOITMDR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType : #CONSUMPTION
@VDM.private : true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Purchage Order Item for Date Range'
define view P_PurchaseOrderItemDateRange
  with parameters
    P_StartDate : badat,
    P_EndDate   : badat
  as select from I_PurchaseOrderItem as _purchaseOrderItem
{
      //I_PurchaseOrderItem

  key PurchaseOrder,
  key PurchaseOrderItem,
      PurchaseOrderItemUniqueID,
      PurchaseOrderCategory,
      MaterialGroup,
      Material,
      CompanyCode,
      Plant,
      Customer,
      StorageLocation,
      _PurchaseOrder.CreatedByUser,
      _PurchaseOrder.CreationDate,
      _PurchaseOrder.PurchasingOrganization,
      _PurchaseOrder.Supplier,
      _PurchaseOrder.PurchasingGroup,

      /* Associations */
      //I_PurchaseOrderItem

      _CompanyCode,
      _Customer,
      _Material,
      _MaterialGroup,
      _Plant,
      _PurchaseOrder,
      _PurchaseOrderItemCalcFields,
      _PurchaseOrderPricingElement,
      _PurgDocumentCategory,
      _StorageLocation,
      _PurchaseOrder._Supplier,
      _PurchaseOrder._PurchasingGroup,
      _PurchaseOrder._PurchasingOrganization
}
where
      _purchaseOrderItem._PurchaseOrder.PurchaseOrderDate <= $parameters.P_EndDate
  and _purchaseOrderItem._PurchaseOrder.PurchaseOrderDate >= $parameters.P_StartDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CUSTOMER",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_PLANT",
"I_PURCHASEORDER",
"I_PURCHASEORDERITEMCALCFIELDS",
"I_PURCHASINGDOCUMENTCATEGORY",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_PURORDPRICINGELEMENT",
"I_STORAGELOCATION",
"I_SUPPLIER"
],
"BASE":
[
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More