ESH_N_COMPANY_CODE_OMPANY_CODE
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)
| Source | Alias | Join Type |
|---|---|---|
| t001 | t001 | from |
Associations (6)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA