I_FIXEDASSET

@Analytics: {
      technicalName: 'IFIXASSET',
      dataCategory: #DIMENSION,
      dataExtraction: {
        enabled: true,
        delta.changeDataCapture: {
          mapping:
            [
              {
                table: 'FAAT_MD',
                role: #MAIN,
                viewElement: ['CompanyCode', 'MasterFixedAsset', 'FixedAsset'],
                tableElement: ['comp_code', 'asset_no', 'asset_subno']
              }
            ]
         }
      }
    }
@EndUserText.label: 'Fixed Asset'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: { sapObjectNodeType.name: 'FixedAsset',
                representativeKey: 'FixedAsset',
                compositionRoot:true,
                usageType.serviceQuality: #A,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MASTER,
                modelingPattern: #ANALYTICAL_DIMENSION,
                supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #EXTRACTION_DATA_SOURCE]
              }
@Metadata: {ignorePropagatedAnnotations: true, allowExtensions:true}

define view entity I_FixedAsset
  as select from           faat_md_root as root
    left outer to one join faat_md      as main on  main.comp_code   = root.comp_code
                                                and main.asset_no    = root.asset_no
                                                and main.asset_subno = root.asset_subno
    left outer to one join t001                 on t001.bukrs = root.comp_code
  // Association to children

  association [0..*] to I_FixedAssetAssgmt             as _FixedAssetAssgmt             on  $projection.CompanyCode      = _FixedAssetAssgmt.CompanyCode
                                                                                        and $projection.MasterFixedAsset = _FixedAssetAssgmt.MasterFixedAsset
                                                                                        and $projection.FixedAsset       = _FixedAssetAssgmt.FixedAsset
  association [0..*] to I_FixedAssetDeprArea           as _FixedAssetDeprArea           on  $projection.CompanyCode      = _FixedAssetDeprArea.CompanyCode
                                                                                        and $projection.MasterFixedAsset = _FixedAssetDeprArea.MasterFixedAsset
                                                                                        and $projection.FixedAsset       = _FixedAssetDeprArea.FixedAsset
  association [0..*] to I_AssetValuationForLedger      as _AssetValuationForLedger      on  $projection.CompanyCode      = _AssetValuationForLedger.CompanyCode
                                                                                        and $projection.MasterFixedAsset = _AssetValuationForLedger.MasterFixedAsset
                                                                                        and $projection.FixedAsset       = _AssetValuationForLedger.FixedAsset
  association [0..*] to I_FixedAssetForLedger          as _FixedAssetForLedger          on  $projection.CompanyCode      = _FixedAssetForLedger.CompanyCode
                                                                                        and $projection.MasterFixedAsset = _FixedAssetForLedger.MasterFixedAsset
                                                                                        and $projection.FixedAsset       = _FixedAssetForLedger.FixedAsset
  //Associations to Object Core Views

  association [0..1] to I_CompanyCode                  as _CompanyCode                  on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_MasterFixedAsset             as _MasterFixedAsset             on  $projection.CompanyCode      = _MasterFixedAsset.CompanyCode
                                                                                        and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
  association [0..1] to I_AssetClass                   as _AssetClass                   on  $projection.AssetClass = _AssetClass.AssetClass
  association [0..1] to I_Currency                     as _Currency                     on  $projection.Currency = _Currency.Currency
  association [0..1] to I_Globalcompany                as _PartnerCompany               on  $projection.PartnerCompany = _PartnerCompany.Company
  association [0..1] to I_AssetAcctDetermination       as _AssetAccountDetermination    on  $projection.AssetAccountDetermination = _AssetAccountDetermination.AssetAccountDetermination
  association [0..1] to I_Supplier                     as _Supplier                     on  $projection.Supplier = _Supplier.Supplier
  association [0..1] to I_Country                      as _AssetCountryOfOrigin         on  $projection.AssetCountryOfOrigin = _AssetCountryOfOrigin.Country
  association [0..1] to I_UnitOfMeasure                as _UnitOfMeasure                on  $projection.BaseUnit = _UnitOfMeasure.UnitOfMeasure

  association [0..1] to I_Group1AssetEvaluationKey     as _Group1AssetEvaluationKey     on  $projection.Group1AssetEvaluationKey = _Group1AssetEvaluationKey.Group1AssetEvaluationKey
  association [0..1] to I_Group2AssetEvaluationKey     as _Group2AssetEvaluationKey     on  $projection.Group2AssetEvaluationKey = _Group2AssetEvaluationKey.Group2AssetEvaluationKey
  association [0..1] to I_Group3AssetEvaluationKey     as _Group3AssetEvaluationKey     on  $projection.Group3AssetEvaluationKey = _Group3AssetEvaluationKey.Group3AssetEvaluationKey
  association [0..1] to I_Group4AssetEvaluationKey     as _Group4AssetEvaluationKey     on  $projection.Group4AssetEvaluationKey = _Group4AssetEvaluationKey.Group4AssetEvaluationKey
  association [0..1] to I_Group5AssetEvaluationKey     as _Group5AssetEvaluationKey     on  $projection.Group5AssetEvaluationKey = _Group5AssetEvaluationKey.Group5AssetEvaluationKey
  association [0..1] to I_InvestmentReason             as _InvestmentReason             on  $projection.InvestmentReason = _InvestmentReason.InvestmentReason
  association [0..1] to I_EnvrnmtlInvestmentReason     as _EnvrnmtlInvestmentReason     on  $projection.EnvrnmtlInvestmentReason = _EnvrnmtlInvestmentReason.EnvrnmtlInvestmentReason
  association [0..1] to I_FixedAssetFinDataCmpltns     as _FixedAssetFinDataCmpltns     on  $projection.FixedAssetFinDataCmpltns = _FixedAssetFinDataCmpltns.FixedAssetFinDataCmpltns
  association [0..1] to I_FixedAssetPropertyType       as _FixedAssetPropertyType       on  $projection.FixedAssetPropertyType = _FixedAssetPropertyType.FixedAssetPropertyType
  association [0..1] to I_ManualDepreciationReason     as _ManualDepreciationReason     on  $projection.ManualDepreciationReason = _ManualDepreciationReason.ManualDepreciationReason
  association [0..1] to I_FixedAssetGroup              as _FixedAssetGroup              on  $projection.FixedAssetGroup = _FixedAssetGroup.FixedAssetGroup
  association [0..1] to I_InternalOrder                as _InvestmentOrder              on  $projection.InvestmentOrder = _InvestmentOrder.InternalOrder
  association [0..1] to I_WBSElementBasicData          as _InvestmentWBSElement         on  $projection.InvestmentProjectWBSElement_2 = _InvestmentWBSElement.WBSElementInternalID
  association [0..1] to I_AssetLifecycleStatus         as _AssetLifecycleStatus         on  $projection.AssetLifecycleStatus = _AssetLifecycleStatus.AssetLifecycleStatus
  association [0..1] to I_AssetCompletenessStatus      as _AssetCompletenessStatus      on  $projection.AssetCompletenessStatus = _AssetCompletenessStatus.AssetCompletenessStatus
  association [0..1] to I_AssetUnderConstructionStatus as _AssetUnderConstructionStatus on  $projection.AssetUnderConstructionStatus = _AssetUnderConstructionStatus.AssetUnderConstructionStatus
  association [0..1] to I_AssetStatusAtPurchase        as _AssetStatusAtPurchase        on  $projection.AssetStatusAtPurchase = _AssetStatusAtPurchase.AssetStatusAtPurchase
  association [0..1] to I_FixedAssetCountryData        as _FixedAssetCountryData        on  $projection.CompanyCode      = _FixedAssetCountryData.CompanyCode
                                                                                        and $projection.MasterFixedAsset = _FixedAssetCountryData.MasterFixedAsset
                                                                                        and $projection.FixedAsset       = _FixedAssetCountryData.FixedAsset
  association [0..*] to I_GlobAssetAssignment          as _GlobAssetAssignment          on  $projection.CompanyCode      = _GlobAssetAssignment.CompanyCode
                                                                                        and $projection.MasterFixedAsset = _GlobAssetAssignment.MasterFixedAsset
                                                                                        and $projection.FixedAsset       = _GlobAssetAssignment.FixedAsset
  association [0..1] to I_Currency                     as _OriginalAcquisitionCurrency  on  $projection.OriginalAcquisitionCurrency = _OriginalAcquisitionCurrency.Currency

  // Association to Extension View

  association [1..1] to E_FixedAsset                   as _Extension                    on  $projection.MasterFixedAsset = _Extension.MasterFixedAsset
                                                                                        and $projection.FixedAsset       = _Extension.FixedAsset
                                                                                        and $projection.CompanyCode      = _Extension.CompanyCode
{
      //Key fields

      @ObjectModel.foreignKey.association: '_CompanyCode'
  key root.comp_code                                                                as CompanyCode,
      @ObjectModel.foreignKey.association: '_MasterFixedAsset'
  key root.asset_no                                                                 as MasterFixedAsset,
      @ObjectModel.text.element: ['FixedAssetDescription']
  key root.asset_subno                                                              as FixedAsset,

      //Relevant Fields

      case when root.asset_subno = '0000' then cast( concat(ltrim(root.asset_no, '0'), '-0' ) as fis_fixedasset_ext_id)
           when root.asset_subno <> '0000' then cast( concat(concat( ltrim(root.asset_no, '0') , '-' ), ltrim(root.asset_subno, '0' )) as fis_fixedasset_ext_id)
      end                                                                           as FixedAssetExternalID,

      @ObjectModel.foreignKey.association: '_AssetClass'
      main.asset_class                                                              as AssetClass,
      main.serial_number                                                            as AssetSerialNumber,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( 0 as am_menge )                                                         as Quantity, //Works in OP only, hence deprecated in cloud with CE1911

      @ObjectModel: { foreignKey.association: '_UnitOfMeasure' }
      main.base_unit                                                                as BaseUnit,
      main.inventory_number                                                         as Inventory,
      @Semantics.text:true
      main.description                                                              as FixedAssetDescription,
      @Semantics.text:true
      main.add_description                                                          as AssetAdditionalDescription,
      @ObjectModel: { foreignKey.association: '_Currency' }
      t001.waers                                                                    as Currency, //CompanyCodeCurrency!

      @Semantics.amount.currencyCode: 'Currency'
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( 0 as urwrt )                                                            as OriglAcqnAmtInCoCodeCrcy, //Works in OP only, hence deprecated in cloud with CE1911. Now OriginalAcquisitionAmount (in Transaction Currency) is provided

      @ObjectModel.foreignKey.association: '_PartnerCompany'
      main.trade_id                                                                 as PartnerCompany,
      main.manufacturer                                                             as AssetManufacturerName,
      main.inhouse_prod_percent                                                     as InHouseProdnPercent,
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '' as liefe )                                                           as AssetSupplierName,
      main.inventory_note                                                           as InventoryNote,
      @ObjectModel.foreignKey.association: '_Group1AssetEvaluationKey'
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '' as ord41 )                                                           as Group1AssetEvaluationKey,
      @ObjectModel.foreignKey.association: '_Group2AssetEvaluationKey'
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '' as ord42 )                                                           as Group2AssetEvaluationKey,
      @ObjectModel.foreignKey.association: '_Group3AssetEvaluationKey'
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '' as ord43 )                                                           as Group3AssetEvaluationKey,
      @ObjectModel.foreignKey.association: '_Group4AssetEvaluationKey'
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '' as ord44 )                                                           as Group4AssetEvaluationKey,
      @ObjectModel.foreignKey.association: '_Group5AssetEvaluationKey'
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '' as gdlgrp )                                                          as Group5AssetEvaluationKey,
      @ObjectModel.foreignKey.association: '_AssetAccountDetermination'
      main.gl_account_det                                                           as AssetAccountDetermination,
      cast( root.is_historical_managed as aneqk )                                   as HasHistory,
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '00000000' as aktivd )                                                  as AssetCapitalizationDate, //Works in OP only, hence deprecated in cloud with CE1911, use I_FixedAssetForLedger.AssetCapitalizationDate instead

      @Semantics.fiscal.year: true
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '0000' as dzujahr )                                                     as FirstAcquisitionFiscalYear,   //Works in OP only, hence deprecated in cloud with CE1911, use I_FixedAssetForLedger.FirstAcquisitionFiscalYear instead

      @Semantics.fiscal.period: true
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '000' as dzuper )                                                       as FirstAcquisitionFiscalPeriod, //Works in OP only, hence deprecated in cloud with CE1911, use I_FixedAssetForLedger.FirstAcquisitionFiscalPeriod instead

      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '00000000' as deakt )                                                   as AssetDeactivationDate, //Works in OP only, hence deprecated in cloud with CE1911, use I_FixedAssetForLedger.AssetDeactivationDate instead

      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '00000000' as gplab )                                                   as PlannedRetirementDate,
      main.purchase_order_date                                                      as FixedAssetOrderDate,
      main.original_asset                                                           as OriginalMasterFixedAsset,
      @ObjectModel.foreignKey.association: '_FixedAssetGroup'
      main.asset_super_no                                                           as FixedAssetGroup,
      @ObjectModel.foreignKey.association: '_InvestmentReason'
      main.invest_reason                                                            as InvestmentReason,
      main.real_estate_asset                                                        as AssetIsRealEstate,
      main.surface_area_unit                                                        as AreaSizeUnit,
      @ObjectModel.foreignKey.association: '_InvestmentOrder'
      main.investment_io_origin                                                     as InvestmentOrder,
      @ObjectModel.foreignKey.association: '_InvestmentWBSElement'
      //cast(main.investment_wbs_origin as fis_wbsint_no_conv preserving type) as InvestmentProjectWBSElement_2,

      cast( main.investment_wbs_origin as faa_inv_wbs_element_int preserving type ) as InvestmentProjectWBSElement_2,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:    'InvestmentProjectWBSElement_2'
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: 'InvestmentProjectWBSElement_2'
      main.investment_wbs_origin                                                    as InvestmentProjectWBSElement,
      main.inventory_indicator                                                      as InventoryIsCounted,
      main.inventory_date                                                           as LastInventoryDate,
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '' as aapm_act_change_pm )                                              as AssetSynchronizationRule,
      @Semantics.fiscal.year: true
      main.original_acq_year                                                        as OriginalAcquisitionFiscalYear,
      main.asset_type_name                                                          as AssetTypeName,
      @ObjectModel.foreignKey.association: '_Supplier'
      main.supplier_no                                                              as Supplier,
      @ObjectModel.foreignKey.association: '_AssetCountryOfOrigin'
      main.origin_country                                                           as AssetCountryOfOrigin,
      main.assessment_tax_number                                                    as NoticeOfAssessmentTaxID,
      main.assessment_date                                                          as LastAssessmentNoticeDate,
      @ObjectModel.foreignKey.association: '_EnvrnmtlInvestmentReason'
      main.environmental_investment                                                 as EnvrnmtlInvestmentReason,
      @Semantics.businessDate.at: true
      case when main.lastchange_datetime = 0 then cast( '00000000' as fis_aedat_anla )
           when main.lastchange_datetime <> 0 then cast( substring( cast( main.lastchange_datetime  as char17 ), 1, 8 ) as fis_aedat_anla)
      end                                                                           as LastChangeDate,

      @ObjectModel.foreignKey.association: '_FixedAssetFinDataCmpltns'
      cast(root.completeness_status as aneqs)                                       as FixedAssetFinDataCmpltns,
      case when root.lifecycle_status = '2' then cast( 'X' as xloev )
           when root.lifecycle_status <> '2' then cast( '' as xloev )
      end                                                                           as AccountIsMarkedForDeletion,
      cast( root.is_blocked as xspeb_anla )                                         as AccountIsBlockedForPosting,
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '00000000' as dzugdat )                                                 as AcquisitionValueDate, //Works in OP only, hence deprecated in cloud with CE1911, use I_FixedAssetForLedger.AcquisitionValueDate instead

      main.original_acq_date                                                        as OriginalFixedAssetValueDate,
      case when root.auc_status = '2' then cast( 'X' as im_xinvm )
           when root.auc_status <> '2' then cast( '' as im_xinvm )
      end                                                                           as AssetUnderConstIsInvmtMsr,
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '00000000' as abgdat )                                                  as LastRetirementValueDate, //Works in OP only, hence deprecated in cloud with CE1911, use I_AssetValuationForLedger.LastRetirementValueDate

      main.lastchange_user                                                          as LastChangedByUser,
      @ObjectModel.foreignKey.association: '_FixedAssetPropertyType'
      main.property_ind                                                             as FixedAssetPropertyType,
      @Semantics.businessDate.at: true
      cast( substring( cast( main.creation_datetime as char17 ), 1, 8 ) as erdat )  as CreationDate,
      main.creation_user                                                            as CreatedByUser,
      @ObjectModel.foreignKey.association: '_ManualDepreciationReason'
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '' as grund )                                                           as ManualDepreciationReason, //Works in OP only, hence deprecated in cloud with CE1911

      main.last_reorg_date                                                          as LastReorganizationDate,
      main.legacy_transfer_date                                                     as LegacyDataTransferDate,
      @VDM.lifecycle: {status: #DEPRECATED}
      cast( '' as xanlgr_1 )                                                        as IsGroupAsset, //Works in OP only, hence deprecated in cloud with CE1911

      case when root.auc_status = '1' then cast( 'X' as opvwa )
           when root.auc_status <> '1' then cast( '' as opvwa )
      end                                                                           as IsLineItemSettled,
      main.original_subasset                                                        as OriginalFixedAsset,
      cast( main.description as mcoa1 )                                             as MasterFixedAssetSearchTerm,
      @VDM.lifecycle: {status: #DEPRECATED, successor: 'AssetIsAcquiredUsed'}
      @ObjectModel: {foreignKey.association: '_AssetStatusAtPurchase'}
      case when main.asset_acquired_used = 'X' then cast( 'X' as fis_asset_purchased_new_or_usd )
           when not main.asset_acquired_used = 'X' then cast( 'N' as fis_asset_purchased_new_or_usd )
      end                                                                           as AssetStatusAtPurchase,
      main.asset_acquired_used                                                      as AssetIsAcquiredUsed,

      /* Added at CE1905 */
      root.is_main_asset                                                            as IsMainAsset,
      @ObjectModel.foreignKey.association: '_AssetLifeCycleStatus'
      root.lifecycle_status                                                         as AssetLifecycleStatus,
      @ObjectModel.foreignKey.association: '_AssetCompletenessStatus'
      root.completeness_status                                                      as AssetCompletenessStatus,
      @ObjectModel.foreignKey.association: '_AssetUnderConstructionStatus'
      root.auc_status                                                               as AssetUnderConstructionStatus,
      root.validity_date                                                            as AssetCreationValidityDate,
      main.creation_datetime                                                        as CreationDateTime,
      main.lastchange_datetime                                                      as LastChangeDateTime,
      main.screen_layout                                                            as AssetScreenLayout,
      @Semantics.amount.currencyCode: 'OriginalAcquisitionCurrency'
      main.original_acq_value                                                       as OriginalAcquisitionAmount,
      @ObjectModel: { foreignKey.association: '_OriginalAcquisitionCurrency' }
      main.original_acq_value_curr                                                  as OriginalAcquisitionCurrency,
      main.property_key                                                             as PropertyClass,
      main.land_tax_office                                                          as LocalTaxOffice,
      main.land_municipality                                                        as Municipality,
      main.land_register_of                                                         as LandRegisterDate,
      main.land_register_entry_number                                               as LandRegisterEntrySequence,
      main.land_register_entry                                                      as LandRegisterEntryDate,
      main.land_register_volume                                                     as LandRegisterVolume,
      main.land_register_page                                                       as LandRegisterPage,
      main.land_register_map_no                                                     as LandRegisterMap,
      main.land_plot_number                                                         as LandPlot,
      main.conveyance_date                                                          as ConveyanceDate,
      @Semantics.quantity.unitOfMeasure: 'AreaSizeUnit'
      main.surface_area                                                             as AreaSize,
      main.lease_company                                                            as LeaseSupplier,
      main.lease_agreement_no                                                       as LeaseAgreement,
      main.lease_agreement_date                                                     as LeaseAgreementDate,
      main.lease_notice_date                                                        as LeaseTermEndDate,
      main.lease_start_date                                                         as LeaseTermStartDate,
      main.lease_years                                                              as LeaseDurationInFiscalYears,
      main.lease_periods                                                            as LeaseDurationInFiscalPeriods,
      main.lease_type                                                               as LeaseType,
      main.lease_data_text                                                          as LeasedAssetNote,
      @VDM.lifecycle: {status: #DEPRECATED, successor: 'LegacyMasterFixedAsset'}
      cast( main.legacy_asset_no as faa_legacyasset )                               as LegacyAsset,
      main.legacy_comp_code                                                         as LegacyFixedAssetCompanyCode,
      main.legacy_asset_no                                                          as LegacyMasterFixedAsset,
      main.legacy_asset_subno                                                       as LegacyFixedAsset,
      main.legacy_transfer_seq_no                                                   as LegacyDataTransferSequence,
      root.is_post_capitalization                                                   as AssetIsForPostCapitalization,
      @Consumption.hidden: true
      @VDM.lifecycle.status: #DEPRECATED
      cast( 'NEW' as faa_authcntxt )                                                as AssetAuthorizationContext, //Needed for DCL

      @Consumption.hidden: true
      main.object_nr                                                                as ObjectInternalID,

      /* Associations */
      _FixedAssetAssgmt,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: '_AssetValuationForLedger'
      _FixedAssetDeprArea,
      _AssetValuationForLedger,
      _FixedAssetForLedger,

      _CompanyCode,
      _MasterFixedAsset,
      _AssetClass,
      _Currency,
      _UnitOfMeasure,
      _PartnerCompany,
      _Group1AssetEvaluationKey,
      _Group2AssetEvaluationKey,
      _Group3AssetEvaluationKey,
      _Group4AssetEvaluationKey,
      _Group5AssetEvaluationKey,
      _AssetAccountDetermination,
      _Supplier,
      _AssetCountryOfOrigin,
      _InvestmentReason,
      _EnvrnmtlInvestmentReason,
      _FixedAssetFinDataCmpltns,
      _FixedAssetPropertyType,
      _ManualDepreciationReason,
      _FixedAssetGroup,
      _InvestmentOrder,
      _InvestmentWBSElement,
      _AssetLifecycleStatus,
      _AssetCompletenessStatus,
      _AssetUnderConstructionStatus,
      _AssetStatusAtPurchase,
      _FixedAssetCountryData,
      _GlobAssetAssignment,
      _OriginalAcquisitionCurrency
}
where
      root.lifecycle_status <> '2'
  and root.lifecycle_status <> '8'