Which tables does P_CntrlContrRelDocnValues use?

P_CntrlContrRelDocnValues reads from 7 data source(s): R_CentralPurchaseContract, R_CentralPurchaseContract, I_CntrlPurchaseContractItem, I_CntrlPurchaseContractItem, I_CntrlPurContrClassification, I_CntrlPurContrDistribution, I_CntrlPurContrReleaseHistory.

P_CntrlContrRelDocnValues

Q: How many fields does P_CntrlContrRelDocnValues have?

P_CntrlContrRelDocnValues has 37 fields. Key fields: CentralPurchaseContract, CentralPurchaseContractItem, DistributionKey, CentralPurchaseContractItem, DistributionKey.

DDL: P_CNTRLCONTRRELDOCNVALUES SQL: PCCRELDOCVAL2 Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS

Central Contract Relaese Documentation Values

P_CntrlContrRelDocnValues is a Consumption CDS View that provides data about "Central Contract Relaese Documentation Values" in SAP S/4HANA. It reads from 7 data sources and exposes 37 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem, DistributionKey, CentralPurchaseContractItem, DistributionKey. It has 1 association to related views. Part of development package ODATA_MM_ANALYTICS.

Data Sources (7)

Source	Alias	Join Type
R_CentralPurchaseContract	CentralContract	inner
R_CentralPurchaseContract	CentralContract	inner
I_CntrlPurchaseContractItem	CentralContractItem	from
I_CntrlPurchaseContractItem	CentralContractItem	union_all
I_CntrlPurContrClassification	ContractClassification	left_outer
I_CntrlPurContrDistribution	Distribution	inner
I_CntrlPurContrReleaseHistory	ReleaseHistory	left_outer

Parameters (3)

Name	Type	Default
P_DisplayCurrency	displaycurrency
P_StartDate	bedat
P_EndDate	bedat

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_CntrlPurContrClassification	ContractClassification	`CentralContract.PurchaseContractType = ContractClassification.PurchasingDocumentType`

Annotations (5)

Name	Value	Level
AbapCatalog.sqlViewName	PCCRELDOCVAL2	view
VDM.viewType	#CONSUMPTION	view
VDM.private	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view

Fields (37)

Key	Field	Source Table	Source Field
KEY	CentralPurchaseContract	I_CntrlPurchaseContractItem	CentralPurchaseContract
KEY	CentralPurchaseContractItem	I_CntrlPurchaseContractItem	CentralPurchaseContractItem
KEY	DistributionKey	I_CntrlPurContrDistribution	DistributionKey
	PurchasingDocumentCategory	R_CentralPurchaseContract	PurchasingDocumentCategory
	PurchasingDocumentItemCategory		PurchasingDocumentItemCategory
	PurchasingOrganization	R_CentralPurchaseContract	PurchasingOrganization
	PurchasingGroup	R_CentralPurchaseContract	PurchasingGroup
	Supplier	R_CentralPurchaseContract	Supplier
	DocumentCurrency	R_CentralPurchaseContract	DocumentCurrency
	CreationDate	R_CentralPurchaseContract	CreationDate
	ValidityStartDate	R_CentralPurchaseContract	ValidityStartDate
	ValidityEndDate	R_CentralPurchaseContract	ValidityEndDate
	PurchaseContractType	R_CentralPurchaseContract	PurchaseContractType
	CompanyCode	R_CentralPurchaseContract	CompanyCode
	CreatedByUser	R_CentralPurchaseContract	CreatedByUser
	DisplayCurrency
	PurgDocChangeRequestStatus	R_CentralPurchaseContract	PurgDocChangeRequestStatus
	CentralPurchaseContract
KEY	CentralPurchaseContractItem	I_CntrlPurchaseContractItem	CentralPurchaseContractItem
KEY	DistributionKey
	PurchasingDocumentCategory	R_CentralPurchaseContract	PurchasingDocumentCategory
	PurchasingDocumentItemCategory		PurchasingDocumentItemCategory
	PurchasingOrganization	R_CentralPurchaseContract	PurchasingOrganization
	PurchasingGroup	R_CentralPurchaseContract	PurchasingGroup
	Supplier	R_CentralPurchaseContract	Supplier
	DocumentCurrency	R_CentralPurchaseContract	DocumentCurrency
	CreationDate	R_CentralPurchaseContract	CreationDate
	ValidityStartDate	R_CentralPurchaseContract	ValidityStartDate
	ValidityEndDate	R_CentralPurchaseContract	ValidityEndDate
	PurchaseContractType	R_CentralPurchaseContract	PurchaseContractType
	CompanyCode	R_CentralPurchaseContract	CompanyCode
	CreatedByUser	R_CentralPurchaseContract	CreatedByUser
	DisplayCurrency
	PurgDocChangeRequestStatus	R_CentralPurchaseContract	PurgDocChangeRequestStatus
	TargetAmount
	ReleaseOrderItemNetAmount
	PurchasingDocumentSubtype	R_CentralPurchaseContract	PurchasingDocumentSubtype

@AbapCatalog.sqlViewName: 'PCCRELDOCVAL2'
@VDM.viewType: #CONSUMPTION
@VDM.private : true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view P_CntrlContrRelDocnValues
  with parameters
    P_DisplayCurrency : displaycurrency,
    P_StartDate       : bedat,
    P_EndDate         : bedat
  as select from    I_CntrlPurchaseContractItem   as CentralContractItem

    inner join      R_CentralPurchaseContract     as CentralContract on CentralContractItem.CentralPurchaseContract = CentralContract.CentralPurchaseContract

    inner join      I_CntrlPurContrDistribution   as Distribution    on  CentralContractItem.CentralPurchaseContract     = Distribution.CentralPurchaseContract
                                                                     and CentralContractItem.CentralPurchaseContractItem = Distribution.CentralPurchaseContractItem

    left outer join I_CntrlPurContrReleaseHistory as ReleaseHistory  on  CentralContractItem.CentralPurchaseContract     = ReleaseHistory.CentralPurchaseContract
                                                                     and CentralContractItem.CentralPurchaseContractItem = ReleaseHistory.CentralPurchaseContractItem
                                                                     and Distribution.DistributionKey                    = ReleaseHistory.DistributionKey

  association [1..1] to I_CntrlPurContrClassification as ContractClassification on CentralContract.PurchaseContractType = ContractClassification.PurchasingDocumentType


{
  key CentralContractItem.CentralPurchaseContract,

  key CentralContractItem.CentralPurchaseContractItem,

  key Distribution.DistributionKey,

      CentralContract.PurchasingDocumentCategory,

      PurchasingDocumentItemCategory,

      CentralContract.PurchasingOrganization,

      CentralContract.PurchasingGroup,

      CentralContract.Supplier,

      CentralContract.DocumentCurrency,

      CentralContract.CreationDate,

      CentralContract.ValidityStartDate,

      CentralContract.ValidityEndDate,

      CentralContract.PurchaseContractType,

      CentralContract.CompanyCode,

      CentralContract.CreatedByUser,

      :P_DisplayCurrency                        as DisplayCurrency,

      CentralContract.PurgDocChangeRequestStatus,


      @Semantics.amount.currencyCode: 'DisplayCurrency'

      cast( case when CreationDate is not null and CreationDate != '00000000'
                  and CentralContractItem.NetPriceQuantity > 0 and Distribution.TargetQuantity > 0
                  then cast(currency_conversion(
                                        amount => CentralContractItem.ContractNetPriceAmount ,
                                        source_currency => CentralContractItem.DocumentCurrency,
                                        target_currency => $parameters.P_DisplayCurrency,
                                        exchange_rate_date => CreationDate )
                   as mm_a_target_amount) *
                       cast( division( Distribution.TargetQuantity, CentralContractItem.NetPriceQuantity, 3 ) as ktmng )
             else 0 end as mm_a_target_amount ) as TargetAmount,


      @Semantics.amount.currencyCode: 'DisplayCurrency'
      @DefaultAggregation: #SUM
      case when ReleaseHistory.ReleaseOrderDate is not null and ReleaseHistory.ReleaseOrderDate != '00000000'
                  then  currency_conversion(  amount => ReleaseHistory.ReleaseOrderItemNetAmount,
                                              source_currency => ReleaseHistory.ReleaseOrderCurrency,
                                              target_currency => $parameters.P_DisplayCurrency,
                                              exchange_rate_date => ReleaseHistory.ReleaseOrderDate )
                  else   0 end                  as ReleaseOrderItemNetAmount,
       CentralContract.PurchasingDocumentSubtype

}

where

       CentralContract.ValidityEndDate                       >= $parameters.P_StartDate
  and  CentralContract.ValidityEndDate                       <= $parameters.P_EndDate
  and  CentralContractItem.PurchasingContractDeletionCode    = ''
  and(
       ContractClassification.PurchaseContractClassification = '1'
    or ContractClassification.PurchaseContractClassification = '0'
  )
  and ( CentralContract.PurgDocChangeRequestStatus = '' or CentralContract.PurgDocChangeRequestStatus = '1' )
  and  ( CentralContract.PurchasingDocumentSubtype = 'C' or CentralContract.PurchasingDocumentSubtype is initial )

union all  select from    I_CntrlPurchaseContractItem   as CentralContractItem

    inner join      R_CentralPurchaseContract     as CentralContract on CentralContractItem.CentralPurchaseContract = CentralContract.CentralPurchaseContract
    left outer join I_CntrlPurContrClassification as ContractClassification on CentralContract.PurchaseContractType = ContractClassification.PurchasingDocumentType

{
    key CentralContractItem.CentralPurchaseContract,

    key CentralContractItem.CentralPurchaseContractItem,

    key cast ('' as mm_purgdoc_distr_num) as DistributionKey,

      CentralContract.PurchasingDocumentCategory,

      PurchasingDocumentItemCategory,

      CentralContract.PurchasingOrganization,

      CentralContract.PurchasingGroup,

      CentralContract.Supplier,

      CentralContract.DocumentCurrency,

      CentralContract.CreationDate,

      CentralContract.ValidityStartDate,

      CentralContract.ValidityEndDate,

      CentralContract.PurchaseContractType,

      CentralContract.CompanyCode,

      CentralContract.CreatedByUser,

      :P_DisplayCurrency                        as DisplayCurrency,

      CentralContract.PurgDocChangeRequestStatus,


      @Semantics.amount.currencyCode: 'DisplayCurrency'

      cast( 0 as mm_a_target_amount ) as TargetAmount,


      @Semantics.amount.currencyCode: 'DisplayCurrency'
      @DefaultAggregation: #SUM
      cast( 0 as netwr ) as ReleaseOrderItemNetAmount,
      CentralContract.PurchasingDocumentSubtype
}
where
       CentralContract.ValidityEndDate                       >= $parameters.P_StartDate
  and  CentralContract.ValidityEndDate                       <= $parameters.P_EndDate
  and  CentralContract.PurchasingDocumentDeletionCode    = ''
  and CentralContract.PurchasingDocumentSubtype = 'H'
  and(
       ContractClassification.PurchaseContractClassification = '1'
    or ContractClassification.PurchaseContractClassification = '0'
  )

Depth:

P_CntrlContrRelDocnValues view

P_PurchaseContractExpiry2 view