P_PurOrdItemTimeVar

DDL: P_PURORDITEMTIMEVAR SQL: PPURORDITMTIMV Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS

Purchase Order Item for Time Variance

P_PurOrdItemTimeVar is a Consumption CDS View that provides data about "Purchase Order Item for Time Variance" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocument, I_PurchasingDocumentItem) and exposes 4 fields with key fields PurchaseOrder, PurchaseOrderItem. Part of development package ODATA_MM_ANALYTICS.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocument PurOrd from
I_PurchasingDocumentItem PurOrdItem inner

Parameters (2)

NameTypeDefault
P_StartDate bedat
P_EndDate bedat

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PPURORDITMTIMV view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
EndUserText.label Purchase Order Item for Time Variance view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.preserveKey true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchasingDocument PurchasingDocument
KEY PurchaseOrderItem I_PurchasingDocumentItem PurchasingDocumentItem
IsReturnsItem I_PurchasingDocumentItem IsReturnsItem
PurchasingDocumentCategory I_PurchasingDocument PurchasingDocumentCategory 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PPURORDITMTIMV'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType : #CONSUMPTION
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.private : true
@EndUserText.label: 'Purchase Order Item for Time Variance'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AbapCatalog.preserveKey:true
define view P_PurOrdItemTimeVar

  with parameters
    P_StartDate : bedat,
    P_EndDate   : bedat

  as select from I_PurchasingDocument     as PurOrd
    inner join   I_PurchasingDocumentItem as PurOrdItem on PurOrd.PurchasingDocument        = PurOrdItem.PurchasingDocument
                                                        and(
                                                          PurOrd.PurchasingDocumentCategory = 'F'
                                                        ) //  or PurOrd.PurchasingDocumentCategory = 'L' )

{

      //as select from I_PurchaseOrder as PurOrd

      //              inner join I_PurchaseOrderItem as PurOrdItem on PurOrd.PurchaseOrder = PurOrdItem.PurchaseOrder {

  key PurOrd.PurchasingDocument         as PurchaseOrder,
  key PurOrdItem.PurchasingDocumentItem as PurchaseOrderItem,
      PurOrdItem.IsReturnsItem,
      PurOrd.PurchasingDocumentCategory
}
where
         PurOrd.PurchasingCompletenessStatus      =  ''
  and    PurOrd.PurchasingDocumentDeletionCode    =  ''
  and    PurOrd.PurchasingDocumentOrderDate       >= $parameters.P_StartDate
  and    PurOrd.PurchasingDocumentOrderDate       <= $parameters.P_EndDate
  and    PurOrdItem.IsReturnsItem                 =  ''
  and    PurOrd.SupplyingPlant                    =  ''
  and(
         PurOrdItem.IsStatisticalItem             =  ''
    or   PurOrdItem.Material                      <> ''
  )
  and    not(
       PurOrdItem.ProductType                    =  '2'
       or(
            PurOrdItem.PurchasingDocumentItemCategory =  '9'
         or PurOrdItem.PurchasingDocumentItemCategory =  '1'
         or PurOrdItem.PurchasingDocumentItemCategory =  'A'
       )
     )

Learn More