I_CompanyCodeStdVH

DDL: I_COMPANYCODESTDVH SQL: IFICC__VH Type: view BASIC Package: FIN_COMPANY_CODE_VDM

Company Code

I_CompanyCodeStdVH is a Basic CDS View that provides data about "Company Code" in SAP S/4HANA. It reads from 1 data source (t001) and exposes 2 fields with key field CompanyCode. It is exposed through 13 OData services (C_BILLOFEXCHANGEREQUEST_SD, MANAGE_SEPA_MANDATE, UI_BANKSTATEMENT_MONITOR, ...). It is used in 3 Fiori applications: Event-Based Revenue Recognition - Sales Orders (Version 2), Manage SEPA Mandates, Event-Based Revenue Recognition - Service Documents. Part of development package FIN_COMPANY_CODE_VDM.

1 data source(s) Exposed by 13 service(s) Used in 3 Fiori app(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
t001 t001 from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IFICC__VH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey CompanyCode view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.modelingPattern #VALUE_HELP_PROVIDER view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Company Code view

OData Services (13)

ServiceBindingVersionContractRelease
C_BILLOFEXCHANGEREQUEST_SD C_BILLOFEXCHANGEREQUEST_SRV V4 C1 NOT_RELEASED
MANAGE_SEPA_MANDATE MANAGE_SEPA_MANDATE V2 C1 NOT_TO_BE_RELEASED_STABLE
UI_BANKSTATEMENT_MONITOR UI_BANKSTATEMENT_MONITOR V4 C1 NOT_RELEASED
UI_BILLINGDOCUMENT_MANAGE UI_BILLINGDOCUMENT_MANAGE V4 C1 NOT_RELEASED
UI_CADUNNINGVOLUME_ANALYSIS UI_CADUNNINGVOL_ANALYSIS V2 C1 NOT_RELEASED
UI_CONCURINCOMINGDOCUMENTTP UI_CONCURINCOMINGDOCUMENTTP V4 C1 NOT_RELEASED
UI_CRCYADJUSTMENT_VERIFY UI_CRCYADJUSTMENT_VER V4 C1 NOT_RELEASED
UI_FINS_TRR_SD_MON UI_FINS_TRR_SD_MON V2 C1 NOT_TO_BE_RELEASED_STABLE
UI_FINS_TRR_SVD_MON UI_FINS_TRR_SVD_MON V2 C1 NOT_TO_BE_RELEASED_STABLE
UI_JOURNALENTRY_VERIFY UI_JOURNALENTRY_VER V4 C1 NOT_RELEASED
UI_MANAGEPAYMENTPLAN UI_MANAGEPAYMENTPLAN_O2 V2 C1 NOT_RELEASED
UI_ORGANIZATIONALCHANGE UI_ORGANIZATIONALCHANGE_O2 V2 C1 NOT_TO_BE_RELEASED_STABLE
UI_UPLOADOPENARITEMS UI_UPLOADOPENARITEMS V4 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (3)

App IDApp NameTypeDescription
F2441A Event-Based Revenue Recognition - Sales Orders (Version 2) Transactional
F5158 Manage SEPA Mandates Transactional Manage SEPA Mandates is to to create, display, or change SEPA mandates for a customer or a business partner, navigating to the Create SEPA Mandates app, the Display SEPA Mandates app, and the Change SEPA Mandates app.
F6007 Event-Based Revenue Recognition - Service Documents Transactional

Event-Based Revenue Recognition - Sales Orders (Version 2)

Business Role: Cost Accountant - Sales

Manage SEPA Mandates

Business Role: Accounts Receivable Accountant

Event-Based Revenue Recognition - Service Documents

Business Role: Cost Accountant - Sales

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode t001 bukrs
CompanyCodeName t001 butxt 
//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 

  on 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