P_PurchasingGroupAnalysis1

DDL: P_PURCHASINGGROUPANALYSIS1 SQL: PMMPURGRPAN1 Type: view CONSUMPTION

Purchasing Group Analysis 1

P_PurchasingGroupAnalysis1 is a Consumption CDS View that provides data about "Purchasing Group Analysis 1" in SAP S/4HANA. It reads from 3 data sources (I_CalendarDate, I_PurchasingDocument, I_PurchasingDocumentItem) and exposes 20 fields with key fields PurchasingDocument, PurchasingDocumentItem.

3 data source(s) 20 fields

Data Sources (3)

SourceAliasJoin Type
I_CalendarDate CalendarDate inner
I_PurchasingDocument PurchaseDoc inner
I_PurchasingDocumentItem PurchaseItem from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate bedat
P_EndDate bedat

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMMPURGRPAN1 view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Purchasing Group Analysis 1 view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocumentItem PurchasingDocument
KEY PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem
PurchasingDocumentItemNo
PurchasingOrganization I_PurchasingDocument PurchasingOrganization
PurchasingGroup I_PurchasingDocument PurchasingGroup
CompanyCode I_PurchasingDocument CompanyCode
Plant I_PurchasingDocumentItem Plant
Supplier I_PurchasingDocument Supplier
Material I_PurchasingDocumentItem Material
MaterialGroup I_PurchasingDocumentItem MaterialGroup
PurchasingDocumentCategory I_PurchasingDocument PurchasingDocumentCategory
DocumentCurrency I_PurchasingDocumentItem DocumentCurrency
PurchasingDocumentStatus I_PurchasingDocument PurchasingDocumentOrigin
DisplayCurrency
CalendarYear I_CalendarDate CalendarYear
CalendarMonth I_CalendarDate CalendarMonth
CalendarQuarter I_CalendarDate CalendarQuarter
CalendarWeek I_CalendarDate CalendarWeek
IsReturnsItem IsReturnsItem
_Supplier _Supplier 
@AbapCatalog.sqlViewName: 'PMMPURGRPAN1'
@VDM.viewType: #CONSUMPTION
//@Analytics.dataCategory: #CUBE

@VDM.private : true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Purchasing Group Analysis 1'
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view P_PurchasingGroupAnalysis1
  with parameters
    P_DisplayCurrency : displaycurrency,
    P_StartDate       : bedat,
    P_EndDate         : bedat

  as select from I_PurchasingDocumentItem as PurchaseItem
    inner join   I_PurchasingDocument     as PurchaseDoc  on PurchaseItem.PurchasingDocument = PurchaseDoc.PurchasingDocument

    inner join   I_CalendarDate           as CalendarDate on PurchaseDoc.PurchasingDocumentOrderDate = CalendarDate.CalendarDate

  //        association[1..1] to essr

  //            on PurchaseItem.PurchasingDocument = essr.ebeln

  //            and PurchaseItem.PurchasingDocumentItem = essr.ebelp

  //

{

  key PurchaseItem.PurchasingDocument,
  key PurchaseItem.PurchasingDocumentItem,
      //     key essr.lblni,

      concat( PurchaseItem.PurchasingDocument , PurchaseItem.PurchasingDocumentItem  ) as  PurchasingDocumentItemNo,
      //  CONCAT(essr.ebeln,essr.ebelp) as ServiceEntrySheet,

      PurchaseDoc.PurchasingOrganization,
      PurchaseDoc.PurchasingGroup,
      PurchaseDoc.CompanyCode,
      PurchaseItem.Plant,
      PurchaseDoc.Supplier,
      PurchaseItem.Material,
      PurchaseItem.MaterialGroup,
      PurchaseDoc.PurchasingDocumentCategory,
      PurchaseItem.DocumentCurrency,
      PurchaseDoc.PurchasingDocumentOrigin                                             as  PurchasingDocumentStatus,
      :P_DisplayCurrency                                                               as  DisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      cast( currency_conversion(  amount             => PurchaseItem.NetAmount,
                             source_currency    => PurchaseItem.DocumentCurrency,
                             target_currency    => $parameters.P_DisplayCurrency,
                             exchange_rate_date => PurchaseDoc.PurchasingDocumentOrderDate,
                             exchange_rate_type => 'M'
       ) as mm_pur_ana_de_pur_net_amount ) * cast( case when IsReturnsItem = 'X' then -1 else 1 end as int2 ) as  NetAmountInDisplayCurrency,  //3074483



      CalendarDate.CalendarYear,
      CalendarDate.CalendarMonth,
      CalendarDate.CalendarQuarter,
      CalendarDate.CalendarWeek,
      IsReturnsItem,
      _Supplier

}
where
       PurchaseDoc.PurchasingDocumentDeletionCode  = ''
  and  PurchaseDoc.ReleaseIsNotCompleted           = ''
  and  PurchaseDoc.PurchasingCompletenessStatus    = ''
  and  PurchaseItem.PurchasingDocumentDeletionCode = ''
  and  PurchasingDocumentOrderDate                 <= $parameters.P_EndDate
  and  PurchasingDocumentOrderDate                 >= $parameters.P_StartDate
  and  PurchaseItem.IsEndOfPurposeBlocked          = ''
  and(
       PurchaseDoc.PurchasingDocumentCategory      = 'A'
    or PurchaseDoc.PurchasingDocumentCategory      = 'F'
    or PurchaseDoc.PurchasingDocumentCategory      = 'K'
    or PurchaseDoc.PurchasingDocumentCategory      = 'L'
    or PurchaseDoc.PurchasingDocumentOrigin        = 'A'
    or PurchaseDoc.PurchasingDocumentOrigin        = 'K'
  )
  and not ( PurchaseItem.IsStatisticalItem = 'X' and PurchaseItem.Material= '' )

Learn More