I_LedgerCompanyCodeVH

DDL: I_LEDGERCOMPANYCODEVH Type: view COMPOSITE

Company Codes for Ledger

I_LedgerCompanyCodeVH is a Composite CDS View that provides data about "Company Codes for Ledger" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCodeVH, I_LedgerCompanyCodeCrcyRoles) and exposes 8 fields with key fields Ledger, CompanyCode.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_CompanyCodeVH I_CompanyCodeVH inner
I_LedgerCompanyCodeCrcyRoles I_LedgerCompanyCodeCrcyRoles from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IFILEDGERCCODE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Company Codes for Ledger view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.modelingPattern #VALUE_HELP_PROVIDER view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
Consumption.ranked true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_LedgerCompanyCodeCrcyRoles Ledger
KEY CompanyCode I_LedgerCompanyCodeCrcyRoles CompanyCode
CompanyCodeName I_CompanyCodeVH CompanyCodeName
ControllingArea I_CompanyCodeVH ControllingArea
ChartOfAccounts I_CompanyCodeVH ChartOfAccounts
CityName I_CompanyCodeVH CityName
Currency I_CompanyCodeVH Currency
FiscalYearVariant I_LedgerCompanyCodeCrcyRoles FiscalYearVariant 
@AbapCatalog: { sqlViewName: 'IFILEDGERCCODE',
                preserveKey: true,
                compiler.compareFilter: true }
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Company Codes for Ledger'
@ObjectModel: { dataCategory: #VALUE_HELP,
                usageType: { sizeCategory: #S,
                             dataClass:  #MIXED,
                             serviceQuality: #C },
                supportedCapabilities: [#VALUE_HELP_PROVIDER, #SEARCHABLE_ENTITY],
                modelingPattern: #VALUE_HELP_PROVIDER }
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true
@Consumption.ranked: true
@VDM: { lifecycle.contract.type: #PUBLIC_LOCAL_API,
        viewType: #COMPOSITE }

define view I_LedgerCompanyCodeVH as select from I_LedgerCompanyCodeCrcyRoles
inner join I_CompanyCodeVH on I_LedgerCompanyCodeCrcyRoles.CompanyCode = I_CompanyCodeVH.CompanyCode
 
{
key I_LedgerCompanyCodeCrcyRoles.Ledger,
@ObjectModel.text.element: ['CompanyCodeName']
@Search.defaultSearchElement:true
@Search.fuzzinessThreshold:0.8
@Search.ranking:#HIGH
key I_LedgerCompanyCodeCrcyRoles.CompanyCode,
@Semantics.text
@Search.defaultSearchElement:true
@Search.fuzzinessThreshold:0.8
@Search.ranking:#LOW
I_CompanyCodeVH.CompanyCodeName,
I_CompanyCodeVH.ControllingArea,
I_CompanyCodeVH.ChartOfAccounts,
I_CompanyCodeVH.CityName,
I_CompanyCodeVH.Currency,
I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant  

}
      

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

Learn More