I_CmmdtyCoCodePrftCtrVH

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.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
I_CompanyCode CompanyCode from
I_ProfitCenter ProfitCenter left_outer
I_ProfitCenterText ProfitCenterText left_outer

Annotations (14)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_PROFITCENTER",
"I_PROFITCENTERTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More