How many fields does P_PurchasingGroupAnalysis1 have?

P_PurchasingGroupAnalysis1 has 20 fields. Key fields: PurchasingDocument, PurchasingDocumentItem.

P_PurchasingGroupAnalysis1

Q: Which tables does P_PurchasingGroupAnalysis1 use?

P_PurchasingGroupAnalysis1 reads from 3 data source(s): I_CalendarDate, I_PurchasingDocument, I_PurchasingDocumentItem.

DDL: P_PURCHASINGGROUPANALYSIS1 SQL: PMMPURGRPAN1 Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS

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. Part of development package ODATA_MM_ANALYTICS.

Data Sources (3)

Source	Alias	Join Type
I_CalendarDate	CalendarDate	inner
I_PurchasingDocument	PurchaseDoc	inner
I_PurchasingDocumentItem	PurchaseItem	from

Parameters (3)

Name	Type	Default
P_DisplayCurrency	displaycurrency
P_StartDate	bedat
P_EndDate	bedat

Annotations (6)

Name	Value	Level
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)

Key	Field	Source Table	Source Field
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= '' )

Depth:

P_PurchasingGroupAnalysis1 view