P_PurReqnItemViaExternalSource

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PPRITMEXTSRC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private : true
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_PurReqnItemViaExternalSource
  with parameters
    P_StartDate : budat,
    P_EndDate   : budat

  as select from I_PurchaseRequisitionItemBasic as RequisitionItem
{

  key RequisitionItem.PurchaseRequisition,
  key RequisitionItem.PurchaseRequisitionItem,

      PurchasingGroup,

      PurchasingOrganization,
      FixedSupplier,
      MaterialGroup,

      Material,
      
      BaseUnit,
      RequestedQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @DefaultAggregation: #NONE
      PurReqnPriceQuantity,
      PurReqnItemCurrency,
      @Semantics.amount.currencyCode: 'PurReqnItemCurrency'
      PurchaseRequisitionPrice,

      Plant,
      PurchaseRequisitionType,
      CreatedByUser,
      PurReqnOrigin,

      CreationDate,
      cast ('10' as mm_a_pur_reqn_item_classfctn ) as PurReqnItemClassification,

      @DefaultAggregation: #SUM
      cast( 1 as abap.int4 )                       as PurReqnItemClassfctnCount,

      @DefaultAggregation: #SUM
      cast( 0 as nmbr_free_txt_via_fiori_appl )    as NmbrOfFreeTxtItmCrtedFrmSSP,

      @DefaultAggregation: #SUM
      cast( 0  as nmbr_material_via_fiori_appl )   as NmbrOfMaterialItmCrtedFrmSSP,

      @DefaultAggregation: #SUM
      cast( 0 as nmbr_catalog_via_fiori_appl )     as NmbrOfCatalogItmCrtedFrmSSP,

      @DefaultAggregation: #SUM
      cast( 0  as nmbr_material_via_me51n )        as NmbrOfMaterialItmCrtedManually,

      @DefaultAggregation: #SUM
      cast( 0 as nmbr_free_txt_via_me51n )         as NmbrOfFreeTxtItmCrtedManually,

      @DefaultAggregation: #SUM
      cast( 1 as nmbr_material_via_extnl_source )  as NmbrOfMatlItmCrtedFrmExtSrce

}
where
        not(
          PurReqnOrigin     = 'R'
          or PurReqnOrigin = 'S'
        )
  and   CreationDate        <= $parameters.P_EndDate
  and   CreationDate        >= $parameters.P_StartDate
  and   IsDeleted           = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEREQUISITIONITEMBASIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/