ESH_N_COMPANY_COMPANY

DDL: ESH_N_COMPANY_COMPANY SQL: ESH_L_COMPA_PANY Type: view

Global Company Data (for KONS Ledger)

ESH_N_COMPANY_COMPANY is a CDS View that provides data about "Global Company Data (for KONS Ledger)" in SAP S/4HANA. It reads from 1 data source (t880) and exposes 13 fields with key field rcomp. It has 3 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
t880 t880 from

Associations (3)

CardinalityTargetAliasCondition
[0..*] ESH_N_LAND1_3_LAND1 _LAND1_2_T880 $projection.cntry = _LAND1_2_T880.DOMVALUE_L
[0..*] ESH_N_SPRAS_3_SPRAS _SPRAS_2_T880 $projection.langu = _SPRAS_2_T880.DOMVALUE_L
[0..*] ESH_N_WAERS_WAERS _WAERS_2_T880 $projection.curr = _WAERS_2_T880.DOMVALUE_L

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ESH_L_COMPA_PANY 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 Global Company Data (for KONS Ledger) view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY rcomp rcomp
name1 name1
cntry cntry
langu langu
stret stret
pobox pobox
pstlc pstlc
city city
curr curr
rform rform
_LAND1_2_T880 _LAND1_2_T880
_SPRAS_2_T880 _SPRAS_2_T880
_WAERS_2_T880 _WAERS_2_T880 
-- Enterprise Search help view
-- This CDS view represents node COMPANY of search model COMPANY_H of search software component SAPAPPLH.
-- This CDS view represents: Global Company Data (for KONS Ledger).
-- CSS component (relevant to Customer Incidents): FI-GL
-- Package: BSESH_FI_GL
-- Software Component: S4CORE
@AbapCatalog.sqlViewName: 'ESH_L_COMPA_PANY'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #INHERITED
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Global Company Data (for KONS Ledger)'
define view ESH_N_COMPANY_COMPANY
as select from t880

  association [0..*] to ESH_N_LAND1_3_LAND1 as _LAND1_2_T880 on $projection.cntry = _LAND1_2_T880.DOMVALUE_L
  association [0..*] to ESH_N_SPRAS_3_SPRAS as _SPRAS_2_T880 on $projection.langu = _SPRAS_2_T880.DOMVALUE_L
  association [0..*] to ESH_N_WAERS_WAERS   as _WAERS_2_T880 on $projection.curr  = _WAERS_2_T880.DOMVALUE_L

{
  key rcomp,
  name1,
  cntry,
  langu,
  stret,
  pobox,
  pstlc,
  city,
  curr,
  rform,
  _LAND1_2_T880,
  _SPRAS_2_T880,
  _WAERS_2_T880
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T880"
],
"ASSOCIATED":
[
"ESH_N_LAND1_3_LAND1",
"ESH_N_SPRAS_3_SPRAS",
"ESH_N_WAERS_WAERS"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More