How many fields does I_CmmdtyCoCodePrftCtrVH have?

I_CmmdtyCoCodePrftCtrVH has 4 fields. Key fields: CompanyCode, ProfitCenter.

I_CmmdtyCoCodePrftCtrVH

Q: Which tables does I_CmmdtyCoCodePrftCtrVH use?

I_CmmdtyCoCodePrftCtrVH reads from 3 data source(s): I_CompanyCode, I_ProfitCenter, I_ProfitCenterText.

DDL: I_CMMDTYCOCODEPRFTCTRVH SQL: ICMMDTYCOCODEPFC Type: view BASIC

View for Company Code and Profit Center

I_CmmdtyCoCodePrftCtrVH is a Basic CDS View that provides data about "View for Company Code and Profit Center" in SAP S/4HANA. It reads from 3 data sources (I_CompanyCode, I_ProfitCenter, I_ProfitCenterText) and exposes 4 fields with key fields CompanyCode, ProfitCenter.

Data Sources (3)

Source	Alias	Join Type
I_CompanyCode	CompanyCode	from
I_ProfitCenter	ProfitCenter	left_outer
I_ProfitCenterText	ProfitCenterText	left_outer

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	ICMMDTYCOCODEPFC	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	View for Company Code and Profit Center	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.dataCategory	#VALUE_HELP	view
Metadata.ignorePropagatedAnnotations	true	view
Search.searchable	true	view
Consumption.ranked	true	view

Fields (4)

Key	Field	Source Table	Source Field
KEY	CompanyCode	I_CompanyCode	CompanyCode
KEY	ProfitCenter	I_ProfitCenter	ProfitCenter
	CompanyCodeName	I_CompanyCode	CompanyCodeName
	ProfitCenterName	I_ProfitCenterText	ProfitCenterName

@AbapCatalog.sqlViewName: 'ICMMDTYCOCODEPFC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'View for Company Code and Profit Center'
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.dataCategory:#VALUE_HELP
@Metadata.ignorePropagatedAnnotations:true
@Search.searchable: true
@Consumption.ranked: true

define view I_CmmdtyCoCodePrftCtrVH
  as select from    I_CompanyCode      as CompanyCode

    left outer join I_ProfitCenter     as ProfitCenter     on  ProfitCenter.ControllingArea   = CompanyCode.ControllingArea
                                                           and ProfitCenter.ValidityEndDate   >= $session.system_date
                                                           and ProfitCenter.ValidityStartDate <= $session.system_date
    left outer join I_ProfitCenterText as ProfitCenterText on  ProfitCenterText.Language          = $session.system_language
                                                           and ProfitCenterText.ControllingArea   = ProfitCenter.ControllingArea
                                                           and ProfitCenterText.ProfitCenter      = ProfitCenter.ProfitCenter
                                                           and ProfitCenterText.ValidityEndDate   >= $session.system_date
                                                           and ProfitCenterText.ValidityStartDate <= $session.system_date
{
//  @Search:{defaultSearchElement:true,ranking:#LOW,fuzzinessThreshold:0.7}  

  key CompanyCode.CompanyCode             as CompanyCode, 
  @Search:{defaultSearchElement:true,ranking:#HIGH,fuzzinessThreshold:0.7}
  key ProfitCenter.ProfitCenter           as ProfitCenter,
  @Search:{defaultSearchElement:true,ranking:#LOW,fuzzinessThreshold:0.7}  
      CompanyCode.CompanyCodeName         as CompanyCodeName,
  @Search:{defaultSearchElement:true,ranking:#LOW,fuzzinessThreshold:0.7}     
      ProfitCenterText.ProfitCenterName   as ProfitCenterName

}

Depth:

I_CmmdtyCoCodePrftCtrVH view