I_COMPANYCODEASSET

CDS View

Company Code in Asset Accounting

I_COMPANYCODEASSET is a CDS View in S/4HANA. Company Code in Asset Accounting. It contains 3 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_FixedAssetWorklist view inner CONSUMPTION Fixed Asset Worklist
I_CompanyCodeAssetStdVH view from COMPOSITE Company Code in Asset Accounting
I_FxdAstCoCodeVH view from COMPOSITE Company Code in Asset Accounting
P_DepreciationAreaByCoCode view from COMPOSITE Depreciation Area By Company Code
P_DepreciationAreaByCoCode view union_all COMPOSITE Depreciation Area By Company Code

Fields (3)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
_ChartOfDepreciation _ChartOfDepreciation 1
ChartOfDepreciation ChartOfDepreciation 2
@AbapCatalog: {sqlViewName: 'ICOMPCODEASSET', preserveKey: true}
@EndUserText.label: 'Company Code in Asset Accounting'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType.serviceQuality: #A,
                usageType.sizeCategory: #S,
                usageType.dataClass: #CUSTOMIZING,
                modelingPattern: #NONE,
                supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #SEARCHABLE_ENTITY, #VALUE_HELP_PROVIDER]
              }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true

define view I_CompanyCodeAsset
  as select from faat_cmp

  association [1]    to I_CompanyCode         as _CompanyCode         on $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_ChartOfDepreciation as _ChartOfDepreciation on $projection.ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } } ]
      @ObjectModel.text.element: 'CompanyCodeName'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key comp_code as CompanyCode,

      @ObjectModel.foreignKey.association: '_ChartOfDepreciation'
      @VDM.lifecycle: {status: #DEPRECATED}
      cast('' as afapl) as ChartOfDepreciation, // !!! Do not use any longer !!! (Only supported in OP when business function FAA_CONFIG_REDESIGN_1 is not active (Like asset master worklist))


      @Semantics.text
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      _CompanyCode.CompanyCodeName,

      //* Asscociations *//

      _CompanyCode,
      _ChartOfDepreciation
}