I_CtrlAreaCoCodeAssgmt

DDL: I_CTRLAREACOCODEASSGMT Type: view_entity BASIC

Assignment of Company Code to Controlling Area

I_CtrlAreaCoCodeAssgmt is a Basic CDS View that provides data about "Assignment of Company Code to Controlling Area" in SAP S/4HANA. It reads from 1 data source (tka02) and exposes 4 fields with key fields ControllingArea, CompanyCode. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
tka02 tka02 from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataExtraction.enabled true view
EndUserText.label Assignment of Company Code to Controlling Area view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey CompanyCode view
VDM.viewType #BASIC view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea
KEY CompanyCode tka02 bukrs
_ControllingArea _ControllingArea
_CompanyCode _CompanyCode
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics: {dataExtraction.enabled: true}
@EndUserText.label: 'Assignment of Company Code to Controlling Area'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: { usageType.sizeCategory: #S,
                usageType.dataClass:  #ORGANIZATIONAL,
                usageType.serviceQuality: #A,
                supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE],
                modelingPattern: #NONE,
                representativeKey: 'CompanyCode'
                 } 
@VDM.viewType: #BASIC
define view entity I_CtrlAreaCoCodeAssgmt as select from tka02
association [1..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [1..1] to I_CompanyCode     as _CompanyCode     on $projection.CompanyCode     = _CompanyCode.CompanyCode
{
@ObjectModel.foreignKey.association: '_ControllingArea'
 key cast( tka02.kokrs as fis_kokrs preserving type )              as ControllingArea,
@ObjectModel.foreignKey.association: '_CompanyCode'
 key tka02.bukrs as CompanyCode,
 
 _ControllingArea,
 _CompanyCode
}