I_COMPANYCODEASSET
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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
}