I_PubSecCompanyCodeVH

DDL: I_PUBSECCOMPANYCODEVH SQL: IPSMCCVH Type: view BASIC

Company Code with FM Area

I_PubSecCompanyCodeVH is a Basic CDS View that provides data about "Company Code with FM Area" in SAP S/4HANA. It reads from 1 data source (t001) and exposes 3 fields with key field CompanyCode.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
t001 t001 from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IPSMCCVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Company Code with FM Area view
VDM.viewType #BASIC view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey CompanyCode view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode t001 bukrs
FinancialManagementArea t001 fikrs
CompanyCodeName t001 butxt 
@AbapCatalog.sqlViewName: 'IPSMCCVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Company Code with FM Area'
@VDM.viewType: #BASIC

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'CompanyCode'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M

@Search.searchable: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true
define view I_PubSecCompanyCodeVH as select from t001 {

  @ObjectModel.text.element: ['CompanyCodeName']
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.8
  @Search.ranking: #HIGH
  key t001.bukrs    as CompanyCode,
  
  t001.fikrs as FinancialManagementArea,
  
  @Semantics.text: true
  @Search: { defaultSearchElement: true, ranking: #LOW }
  t001.butxt    as CompanyCodeName
    
}
where fikrs <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More