P_REQNAVGAPPROVALTIME

CDS View

Requisition Average Approval Time 1

P_REQNAVGAPPROVALTIME is a CDS View in S/4HANA. Requisition Average Approval Time 1. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ReqnAvgApprovalTime view from CONSUMPTION Requisition Average Approval Time 
@AbapCatalog.sqlViewName: 'PREQNAVGAPPTIME'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@VDM.private : true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Requisition Average Approval Time 1'
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_ReqnAvgApprovalTime 

with parameters  
  P_DisplayCurrency : displaycurrency,
  P_StartDate : badat,
  P_EndDate : badat


as select from P_PurReqnAvgApprvlCrcyConvrsn( P_DisplayCurrency: $parameters.P_DisplayCurrency,
                                         P_StartDate : $parameters.P_StartDate,
                                         P_EndDate : $parameters.P_EndDate  ) as P_PurReqnCurrencyConvrsn
 
{ 
    key P_PurReqnCurrencyConvrsn.PurchaseRequisition, 
    key P_PurReqnCurrencyConvrsn.PurchaseRequisitionItem,
//    P_PurReqnCurrencyConvrsn.PurchaseOrder,

//    P_PurReqnCurrencyConvrsn.PurchaseOrderItem,

    P_PurReqnCurrencyConvrsn.PurchasingGroup, 
    P_PurReqnCurrencyConvrsn.PurchasingOrganization, 
    P_PurReqnCurrencyConvrsn.Supplier, 
    P_PurReqnCurrencyConvrsn.SupplierCountry, 
    P_PurReqnCurrencyConvrsn.Material, 
    P_PurReqnCurrencyConvrsn.MaterialGroup, 
    P_PurReqnCurrencyConvrsn.Plant, 
    P_PurReqnCurrencyConvrsn.PurReqCreationDate,
    P_PurReqnCurrencyConvrsn.CreationDate, 
    P_PurReqnCurrencyConvrsn.CostCenter, 
    P_PurReqnCurrencyConvrsn.CreatedByUser, 
    P_PurReqnCurrencyConvrsn.PurchaseRequisitionPrice,
    P_PurReqnCurrencyConvrsn.CalendarWeek,
    P_PurReqnCurrencyConvrsn.CalendarMonth,
    P_PurReqnCurrencyConvrsn.CalendarQuarter,
    P_PurReqnCurrencyConvrsn.CalendarYear,
    PurchaseRequisitionType,
    
    max( case when PurReqCreationDate is not null 
              then ( dats_days_between( PurReqCreationDate , CreationDate ))
            else  0 
         end ) as ApprovalTime
}    
where  
    P_PurReqnCurrencyConvrsn.ReleaseCode != '' and
    P_PurReqnCurrencyConvrsn.PurchaseRequisitionStatus != '' and
    P_PurReqnCurrencyConvrsn.ReleaseStrategy != ''
group by
    P_PurReqnCurrencyConvrsn.PurchaseRequisition, 
    P_PurReqnCurrencyConvrsn.PurchaseRequisitionItem,
//    P_PurReqnCurrencyConvrsn.PurchaseOrder,

//    P_PurReqnCurrencyConvrsn.PurchaseOrderItem,

    P_PurReqnCurrencyConvrsn.PurchasingGroup, 
    P_PurReqnCurrencyConvrsn.PurchasingOrganization,     
    P_PurReqnCurrencyConvrsn.Supplier, 
    P_PurReqnCurrencyConvrsn.SupplierCountry, 
    P_PurReqnCurrencyConvrsn.Material, 
    P_PurReqnCurrencyConvrsn.MaterialGroup, 
    P_PurReqnCurrencyConvrsn.Plant, 
    P_PurReqnCurrencyConvrsn.PurReqCreationDate,
    P_PurReqnCurrencyConvrsn.CreationDate, 
    P_PurReqnCurrencyConvrsn.CostCenter, 
    P_PurReqnCurrencyConvrsn.CreatedByUser, 
    P_PurReqnCurrencyConvrsn.PurchaseRequisitionPrice,
    P_PurReqnCurrencyConvrsn.CalendarWeek,
    P_PurReqnCurrencyConvrsn.CalendarMonth,
    P_PurReqnCurrencyConvrsn.CalendarQuarter,
    PurchaseRequisitionType,
    P_PurReqnCurrencyConvrsn.CalendarYear
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PURREQNAVGAPPRVLCRCYCONVRSN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More