I_COMPANYCODESTDVH

CDS View

Company Code

I_COMPANYCODESTDVH is a CDS View in S/4HANA. Company Code. It contains 2 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 2 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_CmmdtyHdgHdggArCompanyCodeVH view from CONSUMPTION Company Code
C_CmmdtyHdgPlngDataCoCodeVH view from CONSUMPTION Company Code
C_CmmdtyHdgSpecCompanyCodeVH view from CONSUMPTION CMM Commodity Hedge Spec Comp Code Values
C_CommodityHedgeCompanyCodeVH view from CONSUMPTION CMM Hedge Spec Company Code Values
C_CompanyCodeValueHelpProj view from CONSUMPTION Company Code Value Help
C_RunSettlmtActlCompanyCodeVH view from CONSUMPTION Run Settlement Actual Company Code
I_CmmdtyHedgeTransFlowActivity view inner COMPOSITE Financial Transaction Flow
P_InvtryPrChangeCompanyCodeVH view_entity from COMPOSITE Company Code for Inventory Price Change

Fields (2)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
CompanyCodeName CompanyCodeName 3 
//GENERATED:001:GlBfhyFV7jUzaDT}MP9DVm

@AbapCatalog.sqlViewName: 'IFICC__VH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
@VDM.viewType: #BASIC

@ObjectModel: { dataCategory: #VALUE_HELP,
                representativeKey: 'CompanyCode',
                usageType.sizeCategory: #S,
                usageType.dataClass: #ORGANIZATIONAL,
                usageType.serviceQuality: #A,
                supportedCapabilities: [#VALUE_HELP_PROVIDER, #SEARCHABLE_ENTITY],
                modelingPattern: #VALUE_HELP_PROVIDER }
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@Consumption.ranked: true
@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Company Code'
define view I_CompanyCodeStdVH as select from t001 // direct select from T001 as field f_obsolete to be used in where condition

  
left outer to one join  P_UserParameter
  on t001.mandt = P_UserParameter.mandt 
  and P_UserParameter.UserParameter = 'F_SHOW_OBSOLETE_T001'
{
  @ObjectModel.text.element: ['CompanyCodeName']
  @Search.defaultSearchElement: true
//  @Search.fuzzinessThreshold: 0.8

  @Search.ranking: #HIGH
  key t001.bukrs    as CompanyCode,
  @Semantics.text: true
  @Search: { defaultSearchElement: true, ranking: #LOW }
  t001.butxt    as CompanyCodeName
} where P_UserParameter.UserParameterValue = 'X' or t001.f_obsolete <> 'X'

Learn More