P_REQNTOORDERCYCLETIME2
P_REQNTOORDERCYCLETIME2 is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ReqnToOrderCycleTime | view | from | CONSUMPTION | Requisition To Order Cycle Time |
@AbapCatalog.sqlViewName: 'PMMREQORDCYCL2'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@VDM.private : true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_ReqnToOrderCycleTime2
with parameters
P_DisplayCurrency : displaycurrency,
P_StartDate : badat,
P_EndDate : badat
as select from P_PurchaseReqnItms (
P_StartDate : $parameters.P_StartDate,
P_EndDate : $parameters.P_EndDate ) as PurchaseReqItem
inner join P_PRToFirstPurchasOrder1(P_StartDate : $parameters.P_StartDate,
P_EndDate : $parameters.P_EndDate) as PurchaseOrderItem on PurchaseOrderItem.PurchaseRequisition = PurchaseReqItem.PurchaseRequisition
and PurchaseOrderItem.PurchaseRequisitionItem = PurchaseReqItem.PurchaseRequisitionItem
inner join P_PurchaseOrderOutputStatus1 as MessageHeader on PurchaseOrderItem.PurchaseOrder = MessageHeader.PurchaseOrder
// left outer to one join I_CalendarDate as CalendarDate on PurchaseReqItem.PurReqCreationDate = CalendarDate.CalendarDate
association [0..1] to I_Supplier as _Supplier on $projection.FixedSupplier = _Supplier.Supplier
{
key PurchaseReqItem.PurchaseRequisition,
key PurchaseReqItem.PurchaseRequisitionItem,
PurchaseOrderItem.PurchaseOrder,
/* Org Data */
PurchaseReqItem.PurchasingGroup,
PurchaseReqItem.PurchasingOrganization,
/* Supplier */
cast(PurchaseReqItem.FixedSupplier as md_supplier) as Supplier,
FixedSupplier,
cast( _Supplier._StandardAddress._Country.Country as mm_a_supplier_country ) as SupplierCountry,
/* Item Data */
PurchaseReqItem.Material,
PurchaseReqItem.MaterialGroup,
PurchaseReqItem.Plant,
PurchaseReqItem.ReleaseCode,
PurchaseReqItem.PurchaseRequisitionStatus,
PurchaseReqItem.ReleaseStrategy,
PurchaseReqItem.AccountAssignmentCategory,
PurchaseReqItem.MultipleAcctAssgmtDistribution,
/*Dates*/
PurReqCreationDate,
PurchaseReqItem.CreatedByUser,
PurchaseRequisitionType,
PurchaseReqItem.PurReqnItemCurrency,
PurchaseReqItem.PurReqnPriceQuantity,
PurchaseReqItem.RequestedQuantity,
// case when PurReqnPriceQuantity > 0 and PurReqnItemCurrency != ''
// then
cast(currency_conversion(
amount => PurchaseRequisitionPrice ,
source_currency => PurReqnItemCurrency,
target_currency => :P_DisplayCurrency,
exchange_rate_date => PurchaseReqItem.PurReqCreationDate,
exchange_rate_type => 'M'
) as abap.curr(21,5) ) *
division (RequestedQuantity, PurchaseReqItem.PurReqnPriceQuantity,5) as PurchaseRequisitionPrice, //2897312
// else 0
// end
// CalendarDate.CalendarWeek,
// CalendarDate.CalendarMonth,
// CalendarDate.CalendarQuarter,
// CalendarDate.CalendarYear,
MessageHeader.PostingDate as ProcessingDate,
case when PurReqCreationDate is not null
then (dats_days_between(PurReqCreationDate, MessageHeader.PostingDate))
else 0
end as CycleTime
}
where
PurReqnPriceQuantity > 0 and PurReqnItemCurrency != ''
union all select from P_PurchaseReqnItms (
P_StartDate : $parameters.P_StartDate,
P_EndDate : $parameters.P_EndDate ) as PurchaseReqItem
inner join P_PRToFirstPurchasOrder1(P_StartDate : $parameters.P_StartDate,
P_EndDate : $parameters.P_EndDate) as PurchaseOrderItem on PurchaseOrderItem.PurchaseRequisition = PurchaseReqItem.PurchaseRequisition
and PurchaseOrderItem.PurchaseRequisitionItem = PurchaseReqItem.PurchaseRequisitionItem
inner join P_PurchaseOrderOutputStatus1 as MessageHeader on PurchaseOrderItem.PurchaseOrder = MessageHeader.PurchaseOrder
// left outer to one join I_CalendarDate as CalendarDate on PurchaseReqItem.PurReqCreationDate = CalendarDate.CalendarDate
association [0..1] to I_Supplier as _Supplier on $projection.FixedSupplier = _Supplier.Supplier
{
key PurchaseReqItem.PurchaseRequisition,
key PurchaseReqItem.PurchaseRequisitionItem,
PurchaseOrderItem.PurchaseOrder,
/* Org Data */
PurchaseReqItem.PurchasingGroup,
PurchaseReqItem.PurchasingOrganization,
/* Supplier */
cast(PurchaseReqItem.FixedSupplier as md_supplier) as Supplier,
FixedSupplier,
cast( _Supplier._StandardAddress._Country.Country as mm_a_supplier_country ) as SupplierCountry,
/* Item Data */
PurchaseReqItem.Material,
PurchaseReqItem.MaterialGroup,
PurchaseReqItem.Plant,
PurchaseReqItem.ReleaseCode,
PurchaseReqItem.PurchaseRequisitionStatus,
PurchaseReqItem.ReleaseStrategy,
PurchaseReqItem.AccountAssignmentCategory,
PurchaseReqItem.MultipleAcctAssgmtDistribution,
/*Dates*/
PurReqCreationDate,
PurchaseReqItem.CreatedByUser,
PurchaseRequisitionType,
PurchaseReqItem.PurReqnItemCurrency,
PurchaseReqItem.PurReqnPriceQuantity,
PurchaseReqItem.RequestedQuantity,
0 as PurchaseRequisitionPrice,
// CalendarDate.CalendarWeek,
// CalendarDate.CalendarMonth,
// CalendarDate.CalendarQuarter,
// CalendarDate.CalendarYear,
MessageHeader.PostingDate as ProcessingDate,
case when PurReqCreationDate is not null
then (dats_days_between(PurReqCreationDate, MessageHeader.PostingDate))
else 0
end as CycleTime
}
where
PurReqnPriceQuantity <= 0 or PurReqnItemCurrency = ''
// as select from P_ReqnToOrderCycleTime1( P_DisplayCurrency: $parameters.P_DisplayCurrency,
// P_StartDate : $parameters.P_StartDate,
// P_EndDate : $parameters.P_EndDate ) as PurchaseRequisitionItem
//
// // inner join I_PurchaseOrderItem as PurchaseOrderItem on PurchaseOrderItem.PurchaseRequisition = PurchaseRequisitionItem.PurchaseRequisition
// // and PurchaseOrderItem.PurchaseRequisitionItem = PurchaseRequisitionItem.PurchaseRequisitionItem
// inner join P_PurchaseOrderOutputStatus1 as MessageHeader on PurchaseRequisitionItem.PurchaseOrder = MessageHeader.PurchaseOrder
//
// left outer join I_CalendarDate as CalendarDate on PurchaseRequisitionItem.PurReqCreationDate = CalendarDate.CalendarDate
//
// association [0..1] to I_Supplier as _Supplier on $projection.Supplier = _Supplier.Supplier
//
//{
// key PurchaseRequisitionItem.PurchaseRequisition,
// key PurchaseRequisitionItem.PurchaseRequisitionItem,
// // key PurchaseRequisitionItem.AccountAssignmentNumber ,
// cast( PurchaseRequisitionItem.PurchaseOrder as vdm_purchaseorder ) as PurchaseOrder,
// // cast( min( PurchaseOrderItem.PurchaseOrderItem ) as vdm_purchaseorderitem ) as PurchaseOrderItem,
// PurchaseRequisitionItem.PurchasingGroup,
// PurchaseRequisitionItem.PurchasingOrganization,
// PurchaseRequisitionItem.Supplier,
// cast( _Supplier._StandardAddress._Country.Country as mm_a_supplier_country ) as SupplierCountry,
// PurchaseRequisitionItem.Material,
// PurchaseRequisitionItem.MaterialGroup,
// PurchaseRequisitionItem.Plant,
// PurchaseRequisitionItem.PurReqCreationDate,
// //PurchaseRequisitionItem.CreationDate, NOT Required
// PurchaseRequisitionType,
// MessageHeader.PostingDate as ProcessingDate,
//// PurchaseRequisitionItem.CostCenter,
// PurchaseRequisitionItem.CreatedByUser,
// PurchaseRequisitionItem.PurchaseRequisitionPrice,
// CalendarDate.CalendarWeek,
// CalendarDate.CalendarMonth,
// CalendarDate.CalendarQuarter,
// CalendarDate.CalendarYear,
//
// case when PurReqCreationDate is not null
// then (dats_days_between(PurReqCreationDate, MessageHeader.PostingDate))
// else 0
// end as CycleTime
//
//}
//where PurchaseOrderItem.PurchasingDocumentDeletionCode = ''
//
//group by
// PurchaseRequisitionItem.PurchaseRequisition,
// PurchaseRequisitionItem.PurchaseRequisitionItem,
// PurchaseRequisitionItem.AccountAssignmentNumber ,
// PurchaseRequisitionItem.PurchaseOrder,
// PurchaseRequisitionItem.PurchasingGroup,
// PurchaseRequisitionItem.PurchasingOrganization,
// PurchaseRequisitionItem.Supplier,
// PurchaseRequisitionItem.SupplierCountry,
// PurchaseRequisitionItem.Material,
// PurchaseRequisitionItem.MaterialGroup,
// PurchaseRequisitionItem.Plant,
// PurchaseRequisitionItem.PurReqCreationDate,
// PurchaseRequisitionType,
// MessageHeader.PostingDate,
// PurchaseRequisitionItem.CostCenter,
// PurchaseRequisitionItem.CreatedByUser,
// PurchaseRequisitionItem.PurchaseRequisitionPrice,
// PurchaseRequisitionItem.CalendarWeek,
// PurchaseRequisitionItem.CalendarMonth,
// PurchaseRequisitionItem.CalendarQuarter,
// PurchaseRequisitionItem.CalendarYear