I_FixedAssetCompanyCode

DDL: I_FIXEDASSETCOMPANYCODE Type: view_entity BASIC Package: FINS_FAA_CFG_CMP

Fixed Asset Company Code

I_FixedAssetCompanyCode is a Basic CDS View that provides data about "Fixed Asset Company Code" in SAP S/4HANA. It reads from 1 data source (faat_cmp) and exposes 6 fields with key field CompanyCode. It has 1 association to related views. Part of development package FINS_FAA_CFG_CMP.

Data Sources (1)

SourceAliasJoin Type
faat_cmp faat_cmp from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Fixed Asset Company Code view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode comp_code
FixedAssetCompanyCodeStatus status
IsLocked locked
LocalLastChangeDateTime local_last_changed_at
LastChangeDateTime last_changed_at
_CompanyCode _CompanyCode
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Fixed Asset Company Code'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
define root view entity I_FixedAssetCompanyCode 
  as select from faat_cmp
  association [0..1] to I_CompanyCode                  as _CompanyCode                on  $projection.CompanyCode = _CompanyCode.CompanyCode
{
  //key mandt as Mandt,

  key comp_code as CompanyCode,
  status as FixedAssetCompanyCodeStatus,
  locked as IsLocked,
  //_association_name // Make association public

  //local ETag field --> OData ETag

  @Semantics.systemDateTime.localInstanceLastChangedAt: true
  local_last_changed_at as LocalLastChangeDateTime,
  
//  total ETag field

  @Semantics.systemDateTime.lastChangedAt: true
  last_changed_at       as LastChangeDateTime,
//  

  _CompanyCode
}