ESH_N_COMPANY_CODE_OMPANY_CODE

DDL: ESH_N_COMPANY_CODE_OMPANY_CODE SQL: ESH_L_COMPA_CODE Type: view

Company Codes

ESH_N_COMPANY_CODE_OMPANY_CODE is a CDS View that provides data about "Company Codes" in SAP S/4HANA. It reads from 1 data source (t001) and exposes 15 fields with key field bukrs. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
t001 t001 from

Associations (6)

CardinalityTargetAliasCondition
[0..*] ESH_N_PROFIT_CENTER_CEPC_BUKRS _COMPANY_CODE2CEPC_BUKRS $projection.bukrs = _COMPANY_CODE2CEPC_BUKRS.BUKRS
[1..1] ESH_N_COMPANY_COMPANY _COMPANY_CODE2COMPANY $projection.rcomp = _COMPANY_CODE2COMPANY.RCOMP
[0..*] ESH_N_KKBER_KKBER _KKBER_2_T001 $projection.kkber = _KKBER_2_T001.DOMVALUE_L
[0..*] ESH_N_KTOPL_KTOPL _KTOPL_2_T001 $projection.ktopl = _KTOPL_2_T001.DOMVALUE_L
[0..*] ESH_N_LAND1_3_LAND1 _LAND1_2_T001 $projection.land1 = _LAND1_2_T001.DOMVALUE_L
[0..*] ESH_N_PERIV_PERIV _PERIV_2_T001 $projection.periv = _PERIV_2_T001.DOMVALUE_L

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ESH_L_COMPA_CODE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Company Codes view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY bukrs bukrs
butxt butxt
ort01 ort01
land1 land1
waers waers
ktopl ktopl
periv periv
rcomp rcomp
kkber kkber
_COMPANY_CODE2CEPC_BUKRS _COMPANY_CODE2CEPC_BUKRS
_COMPANY_CODE2COMPANY _COMPANY_CODE2COMPANY
_KKBER_2_T001 _KKBER_2_T001
_KTOPL_2_T001 _KTOPL_2_T001
_LAND1_2_T001 _LAND1_2_T001
_PERIV_2_T001 _PERIV_2_T001
-- Enterprise Search help view
-- This CDS view represents node COMPANY_CODE of search model COMPANY_CODE_H of search software component SAPAPPLH.
-- This CDS view represents: Company Codes.
-- CSS component (relevant to Customer Incidents): FI-GL
-- Package: BSESH_FI_GL
-- Software Component: S4CORE
@AbapCatalog.sqlViewName: 'ESH_L_COMPA_CODE'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #INHERITED
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Company Codes'
define view ESH_N_COMPANY_CODE_OMPANY_CODE
as select from t001

  association [0..*] to ESH_N_PROFIT_CENTER_CEPC_BUKRS as _COMPANY_CODE2CEPC_BUKRS on $projection.bukrs = _COMPANY_CODE2CEPC_BUKRS.BUKRS
  association [1..1] to ESH_N_COMPANY_COMPANY          as _COMPANY_CODE2COMPANY    on $projection.rcomp = _COMPANY_CODE2COMPANY.RCOMP
  association [0..*] to ESH_N_KKBER_KKBER              as _KKBER_2_T001            on $projection.kkber = _KKBER_2_T001.DOMVALUE_L
  association [0..*] to ESH_N_KTOPL_KTOPL              as _KTOPL_2_T001            on $projection.ktopl = _KTOPL_2_T001.DOMVALUE_L
  association [0..*] to ESH_N_LAND1_3_LAND1            as _LAND1_2_T001            on $projection.land1 = _LAND1_2_T001.DOMVALUE_L
  association [0..*] to ESH_N_PERIV_PERIV              as _PERIV_2_T001            on $projection.periv = _PERIV_2_T001.DOMVALUE_L

{
  key bukrs,
  butxt,
  ort01,
  land1,
  waers,
  ktopl,
  periv,
  rcomp,
  kkber,
  _COMPANY_CODE2CEPC_BUKRS,
  _COMPANY_CODE2COMPANY,
  _KKBER_2_T001,
  _KTOPL_2_T001,
  _LAND1_2_T001,
  _PERIV_2_T001
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T001"
],
"ASSOCIATED":
[
"ESH_N_COMPANY_COMPANY",
"ESH_N_KKBER_KKBER",
"ESH_N_KTOPL_KTOPL",
"ESH_N_LAND1_3_LAND1",
"ESH_N_PERIV_PERIV",
"ESH_N_PROFIT_CENTER_CEPC_BUKRS"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/