@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@AbapCatalog.sqlViewName: 'CMMPRNOTOUCH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Purchase Requisition No Touch Rate'
@VDM.viewType : #CONSUMPTION
@Analytics.dataCategory: #CUBE
@Metadata.allowExtensions:true
define view C_PurRequisitionNoTouch
with parameters
P_DisplayCurrency : displaycurrency,
P_StartDate : badat,
P_EndDate : badat
// P_PriceForLowCostItem : mm_a_low_cost_value,
//
// P_PriceForMediumCostItem : mm_a_medium_cost_value,
//
// P_PriceForHighCostItem : mm_a_high_cost_value
as select from P_PurRequisitionNoTouch1( P_DisplayCurrency: $parameters.P_DisplayCurrency,
P_StartDate: $parameters.P_StartDate,
P_EndDate: $parameters.P_EndDate) as Requisition
left outer join I_PurchasingCategoryMatlGroup as PurchasingCategoryMatlGroup on Requisition.MaterialGroup = PurchasingCategoryMatlGroup.MaterialGroup
association [1..1] to I_CalendarDate as _RelevantDates on $projection.CreationDate = _RelevantDates.CalendarDate
association [1..1] to I_Material as _Material on $projection.Material = _Material.Material
association [1..1] to I_MaterialGroup as _MaterialGroup on $projection.MaterialGroup = _MaterialGroup.MaterialGroup
association [1..1] to I_Supplier as _Supplier on $projection.Supplier = _Supplier.Supplier
association [1..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association [1..1] to I_PurchasingOrganization as _PurchasingOrganization on $projection.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization
association [1..1] to I_PurchasingGroup as _PurchasingGroup on $projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup
association [1..1] to I_PurReqnItemClassfctn as _PurReqnItemClassfctn on _PurReqnItemClassfctn.PurReqnItemClassification = $projection.PurReqnItemClassification
association [1..1] to I_PurReqnNoTouchType as _PurReqnNoTouchType on _PurReqnNoTouchType.PurReqnNoTouchType = $projection.PurReqnNoTouchType
{
key PurchaseRequisition,
key PurchaseRequisitionItem,
@ObjectModel.foreignKey.association: '_Supplier'
key Supplier,
@EndUserText.label: 'Touch Type'
@ObjectModel.foreignKey.association: '_PurReqnNoTouchType'
PurReqnNoTouchType,
@ObjectModel.foreignKey.association: '_PurchasingGroup'
PurchasingGroup,
@ObjectModel.foreignKey.association: '_PurchasingOrganization'
@Consumption.valueHelpDefinition: [{ entity: { name : 'C_PurchasingOrgValueHelp', element : 'PurchasingOrganization' } }]
PurchasingOrganization,
@ObjectModel.foreignKey.association: '_MaterialGroup'
Requisition.MaterialGroup,
@ObjectModel.foreignKey.association: '_Material'
Material,
@ObjectModel.foreignKey.association: '_Plant'
Requisition.Plant,
@ObjectModel.text.element: ['PurgCatName']
@Consumption.labelElement: 'PurgCatName'
PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory as PurchasingCategory,
@Semantics.text: true
PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName as PurgCatName,
CompanyCode,
CostCenter,
CreatedByUser,
CreationDate,
@Semantics.calendar.year: true
_RelevantDates.CalendarYear,
_RelevantDates.CalendarQuarter,
_RelevantDates.CalendarMonth,
_RelevantDates.CalendarWeek,
@ObjectModel.foreignKey.association:'_PurReqnItemClassfctn'
PurReqnItemClassification,
//Added for displaying PR value in document view
@Semantics.unitOfMeasure: true
BaseUnit,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
@EndUserText.label: 'Quantity Requested'
@DefaultAggregation: null
//@Analytics.hidden: true
RequestedQuantity,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
@EndUserText.label: 'Price Unit'
@DefaultAggregation: null
//@Analytics.hidden: true
PurReqnPriceQuantity,
@Semantics.currencyCode: true
PurReqnItemCurrency,
@EndUserText.label: 'Valuation Price'
@Semantics.amount.currencyCode: 'PurReqnItemCurrency'
@DefaultAggregation: #SUM
//@Analytics.hidden: true
PurchaseRequisitionPrice,
@DefaultAggregation: #SUM
@EndUserText.label: 'No Touch Count'
cast( case when PurReqnNoTouchType = 'N' then 1 else 0 end as abap.int4 ) as NmbrOfPurReqnWithNoTouch,
@DefaultAggregation: #SUM
@EndUserText.label: 'Low Touch Count'
cast( case when PurReqnNoTouchType = 'L' then 1 else 0 end as abap.int4 ) as NmbrOfPurReqnWithLow,
@DefaultAggregation: #SUM
@EndUserText.label: 'High Touch Count'
cast( case when PurReqnNoTouchType = 'H' then 1 else 0 end as abap.int4 ) as NmbrOfPurReqnWithHighTouch,
// @DefaultAggregation: #SUM
// @EndUserText.label: 'No Touch Count'
// NmbrOfPurReqnWithNoTouch,
//
// @DefaultAggregation: #SUM
// @EndUserText.label: 'Low Touch Count'
// NmbrOfPurReqnWithLow,
//
// @DefaultAggregation: #SUM
// @EndUserText.label: 'High Touch Count'
// NmbrOfPurReqnWithHighTouch,
@DefaultAggregation: #SUM
cast( 1 as abap.int4 ) as PurchaseRequisitionItemCount,
// //High Touch
// @DefaultAggregation: #SUM
// cast(case when PurchaseRequisitionPrice <= $parameters.P_PriceForLowCostItem
// then NmbrOfPurReqnWithHighTouch
// // else I_CalendarYear.NumberOfDays //3053587
// end as abap.int4 ) as HighTouchLowCostItemsValue,
//
// @DefaultAggregation: #SUM
// cast(case when PurchaseRequisitionPrice >$parameters.P_PriceForLowCostItem and PurchaseRequisitionPrice <= $parameters.P_PriceForMediumCostItem
// then NmbrOfPurReqnWithHighTouch
// // else I_CalendarYear.NumberOfDays //3053587
// end as abap.int4 ) as HighTouchMediumCostItemsValue,
//
// @DefaultAggregation: #SUM
// cast(case when PurchaseRequisitionPrice > $parameters.P_PriceForMediumCostItem and PurchaseRequisitionPrice <= $parameters.P_PriceForHighCostItem
// then NmbrOfPurReqnWithHighTouch
// // else I_CalendarYear.NumberOfDays //3053587
// end as abap.int4 ) as HighTouchHighCostItemsValue,
//
// @DefaultAggregation: #SUM
// cast(case when PurchaseRequisitionPrice > $parameters.P_PriceForHighCostItem
// then NmbrOfPurReqnWithHighTouch
// // else I_CalendarYear.NumberOfDays //3053587
// end as abap.int4 ) as HighTouchVeryHighCostItmsVal,
//
// // No Touch
// @DefaultAggregation: #SUM
// cast(case when PurchaseRequisitionPrice <= $parameters.P_PriceForLowCostItem
// then NmbrOfPurReqnWithNoTouch
// // else I_CalendarYear.NumberOfDays //3053587
// end as abap.int4 ) as NoTouchLowCostItemValue,
//
// @DefaultAggregation: #SUM
// cast(case when PurchaseRequisitionPrice >$parameters.P_PriceForLowCostItem and PurchaseRequisitionPrice <= $parameters.P_PriceForMediumCostItem
// then NmbrOfPurReqnWithNoTouch
// // else I_CalendarYear.NumberOfDays //3053587
// end as abap.int4 ) as NoTouchMediumCostItemValue,
//
// @DefaultAggregation: #SUM
// cast(case when PurchaseRequisitionPrice > $parameters.P_PriceForMediumCostItem and PurchaseRequisitionPrice <= $parameters.P_PriceForHighCostItem
// then NmbrOfPurReqnWithNoTouch
// // else I_CalendarYear.NumberOfDays //3053587
// end as abap.int4 ) as NoTouchHighCostItemValue,
//
// @DefaultAggregation: #SUM
// cast(case when PurchaseRequisitionPrice > $parameters.P_PriceForHighCostItem
// then NmbrOfPurReqnWithNoTouch
// // else I_CalendarYear.NumberOfDays //3053587
// end as abap.int4 ) as NoTouchVeryHighCostItemValue,
//
// //Low Touch
// @DefaultAggregation: #SUM
// cast(case when PurchaseRequisitionPrice <= $parameters.P_PriceForLowCostItem
// then NmbrOfPurReqnWithLow
// // else I_CalendarYear.NumberOfDays //3053587
// end as abap.int4 ) as LowTouchLowCostItemValue,
//
// @DefaultAggregation: #SUM
// cast(case when PurchaseRequisitionPrice >$parameters.P_PriceForLowCostItem and PurchaseRequisitionPrice <= $parameters.P_PriceForMediumCostItem
// then NmbrOfPurReqnWithLow
// // else I_CalendarYear.NumberOfDays //3053587
// end as abap.int4 ) as LowTouchMediumCostItemValue,
//
// @DefaultAggregation: #SUM
// cast(case when PurchaseRequisitionPrice > $parameters.P_PriceForMediumCostItem and PurchaseRequisitionPrice <= $parameters.P_PriceForHighCostItem
// then NmbrOfPurReqnWithLow
// // else I_CalendarYear.NumberOfDays //3053587
// end as abap.int4 ) as LowTouchHighCostItemValue,
//
// @DefaultAggregation: #SUM
// cast(case when PurchaseRequisitionPrice > $parameters.P_PriceForHighCostItem
// then NmbrOfPurReqnWithLow
// // else I_CalendarYear.NumberOfDays //3053587
// end as abap.int4 ) as LowTouchVeryHighCostItemValue,
_Material,
_MaterialGroup,
_Plant,
_Supplier,
_PurchasingGroup,
_PurchasingOrganization,
_PurReqnItemClassfctn,
_PurReqnNoTouchType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE",
"I_PURCHASINGCATEGORY",
"I_PURCHASINGCATEGORYMATLGROUP",
"P_PURREQUISITIONNOTOUCH1"
],
"ASSOCIATED":
[
"I_CALENDARDATE",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_PLANT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_PURREQNITEMCLASSFCTN",
"I_PURREQNNOTOUCHTYPE",
"I_SUPPLIER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/