P_TimeVariance_OVP

DDL: P_TIMEVARIANCE_OVP SQL: PMMTIMEVARIOVP Type: view CONSUMPTION Package: ODATA_PRC_OVP

TimeVariance OVP

P_TimeVariance_OVP is a Consumption CDS View that provides data about "TimeVariance OVP" in SAP S/4HANA. It reads from 2 data sources (P_SupplierEvalByTime1, I_PurOrdScheduleLineEnhanced) and exposes 16 fields with key fields PurchaseOrder, PurchaseOrderItem, PurchaseOrderItem. Part of development package ODATA_PRC_OVP.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
P_SupplierEvalByTime1 P_SupplierEvalByTime1 union_all
I_PurOrdScheduleLineEnhanced PurchaseOrder from

Parameters (2)

NameTypeDefault
P_StartDate bedat
P_EndDate bedat

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMMTIMEVARIOVP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label TimeVariance OVP view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
PurgDocMigrtnIsCmpltdForAnlyts
Supplier Supplier
PurchasingOrganization PurchasingOrganization
Material Material
MaterialGroup MaterialGroup
P_StartDate
P_EndDateasPurchaseOrderkeyPurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
PurgDocMigrtnIsCmpltdForAnlyts
Supplier Supplier
PurchasingOrganization PurchasingOrganization
Material Material
MaterialGroup MaterialGroup
TimeVarianceScore TimeVarianceScore 
@AbapCatalog.sqlViewName: 'PMMTIMEVARIOVP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'TimeVariance OVP'
define view P_TimeVariance_OVP 
 with parameters
    P_StartDate: bedat,
    P_EndDate: bedat
  as select from I_PurOrdScheduleLineEnhanced as PurchaseOrder
  /*I_PurgAnalyticsConfiguration as MigrationStatus    
    inner join I_PurOrdScheduleLineEnhanced as PurchaseOrder on MigrationStatus.IsIntrastatReportingRelevant = 'X'
    //association[1..1] to I_PurchasingCategoryMatlGroup as _PurchasingCategoryMatlGroup on $projection.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup

      */
{ 
    /* Key fields*/  
    key PurchaseOrder,
    key PurchaseOrderItem,  
  cast ('X' as char1) as PurgDocMigrtnIsCmpltdForAnlyts,
    /* Supplier */
    Supplier,
    PurchasingOrganization,
    
    /* Material */
    Material,
    MaterialGroup,
    TimeVarianceScore
    
}  where PurchaseOrderDate >= $parameters.P_StartDate
     and PurchaseOrderDate <= $parameters.P_EndDate
    // and MigrationStatus.IsIntrastatReportingRelevant = 'X'

     and ( PurOrdItmFirstGRPostingDate > '00000000'  or PurOrdItmFirstGRPostingDate != '00000000' ) 
     
  union all select from P_SupplierEvalByTime1(  P_StartDate: $parameters.P_StartDate , P_EndDate: $parameters.P_EndDate ) as PurchaseOrder
  /* I_PurgAnalyticsConfiguration as MigrationStatus    
    inner join P_SupplierEvalByTime1(  P_StartDate: $parameters.P_StartDate , P_EndDate: $parameters.P_EndDate ) as PurchaseOrder on MigrationStatus.IsIntrastatReportingRelevant = ''
    */
{  
    /* Key fields*/ 
    key PurchaseOrder,
    key PurchaseOrderItem, 
  cast (' ' as char1) as PurgDocMigrtnIsCmpltdForAnlyts,
    /* Supplier */
    Supplier,
    PurchasingOrganization,
   
    /* Material */
    Material,
    MaterialGroup,
    
    TimeVarianceScore
    
}  
//where MigrationStatus.IsIntrastatReportingRelevant = ''

Learn More