I_FixedAssetPlanValue

@AbapCatalog: {sqlViewName: 'IFASSETPLAN',
               preserveKey: true,
               compiler.compareFilter: true}
@EndUserText.label: 'Fixed Asset Plan Values'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType.serviceQuality: #C,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MIXED }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view I_FixedAssetPlanValue
  as select from P_FixedAssetPlanValue

    inner join   I_LedgerCompanyCodeCrcyRoles as LedgerCompanyCodeCrcyRoles on  P_FixedAssetPlanValue.Ledger      = LedgerCompanyCodeCrcyRoles.Ledger
                                                                            and P_FixedAssetPlanValue.CompanyCode = LedgerCompanyCodeCrcyRoles.CompanyCode


  association [0..1] to I_DepreciationAreaForLedger    as _DepreciationArea             on  $projection.CompanyCode           = _DepreciationArea.CompanyCode
                                                                                        and $projection.Ledger                = _DepreciationArea.Ledger
                                                                                        and $projection.AssetDepreciationArea = _DepreciationArea.AssetDepreciationArea
  association [0..1] to I_CompanyCode                  as _CompanyCode                  on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_FiscalYearForCompanyCode     as _FiscalYear                   on  $projection.FiscalYear  = _FiscalYear.FiscalYear
                                                                                        and $projection.CompanyCode = _FiscalYear.CompanyCode
  association [0..1] to I_MasterFixedAsset             as _MasterFixedAsset             on  $projection.CompanyCode      = _MasterFixedAsset.CompanyCode
                                                                                        and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
  association [0..1] to I_FixedAsset                   as _FixedAsset                   on  $projection.CompanyCode      = _FixedAsset.CompanyCode
                                                                                        and $projection.FixedAsset       = _FixedAsset.FixedAsset
                                                                                        and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
  association [0..1] to I_SubLedgerAccLineItemType     as _SubLedgerAccLineItemType     on  $projection.SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType
  association [0..1] to I_FiscalYearPeriodForCmpnyCode as _FiscalPeriod                 on  $projection.FiscalYear   = _FiscalPeriod.FiscalYear
                                                                                        and $projection.FiscalPeriod = _FiscalPeriod.FiscalPeriod
                                                                                        and $projection.CompanyCode  = _FiscalPeriod.CompanyCode
  association [0..1] to I_Ledger                       as _Ledger                       on  $projection.Ledger = _Ledger.Ledger
  association [0..1] to I_LedgerGroup                  as _LedgerGroup                  on  $projection.LedgerGroup = _LedgerGroup.LedgerGroup

  association [0..1] to I_FinancialAccountType         as _FinancialAccountType         on  $projection.FinancialAccountType = _FinancialAccountType.FinancialAccountType
  association [0..1] to I_ChartOfDepreciation          as _ChartOfDepreciation          on  $projection.chartofdepreciation = _ChartOfDepreciation.ChartOfDepreciation
  association [0..1] to I_MovementCategory             as _AssetAcctTransClassfctn      on  $projection.AssetAcctTransClassfctn = _AssetAcctTransClassfctn.AssetAcctTransClassfctn
  association [0..1] to I_Currency                     as _CompanyCodeCurrency          on  $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
  association [0..1] to I_Currency                     as _GlobalCurrency               on  $projection.GlobalCurrency = _GlobalCurrency.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency1         on  $projection.FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency2         on  $projection.FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency3         on  $projection.FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency4         on  $projection.FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency5         on  $projection.FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency6         on  $projection.FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency7         on  $projection.FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency8         on  $projection.FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency
  association [1]    to I_AccountingPrinciple          as _AccountingPrinciple          on  $projection.AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple
  association [0..1] to I_ChartOfDeprForAcctgPrinciple as _ChartOfDeprForAcctgPrinciple on  $projection.AccountingPrinciple = _ChartOfDeprForAcctgPrinciple.AccountingPrinciple
                                                                                        and $projection.CompanyCode         = _ChartOfDeprForAcctgPrinciple.CompanyCode
{

       @ObjectModel.foreignKey.association: '_CompanyCode'
  key  P_FixedAssetPlanValue.CompanyCode,
       @ObjectModel.foreignKey.association: '_MasterFixedAsset'
  key  MasterFixedAsset,
       @ObjectModel.foreignKey.association: '_FixedAsset'
  key  FixedAsset,
       @ObjectModel.foreignKey.association: '_FiscalYear'
  key  FiscalYear,
       @ObjectModel.foreignKey.association: '_DepreciationArea'
  key  AssetDepreciationArea,
       @ObjectModel.foreignKey.association: '_FiscalPeriod'
  key  FiscalPeriod,
       @ObjectModel.foreignKey.association: '_SubledgerAccLineItemType'
  key  SubLedgerAcctLineItemType,

       @Semantics.fiscal.year: true
       LedgerFiscalYear,
       @ObjectModel.foreignKey.association: '_AccountingPrinciple'
       LedgerCompanyCodeCrcyRoles.AccountingPrinciple,

       cast('2' as faa_use_val_ty)             as PlannedValueIsInclusive,
       @ObjectModel.foreignKey.association: '_Ledger'
       P_FixedAssetPlanValue.Ledger,
       @ObjectModel.foreignKey.association: '_LedgerGroup'
       cast('' as faa_deprecated_target_ldgrp) as LedgerGroup,
       @ObjectModel.foreignKey.association: '_AssetAcctTransClassfctn'
       AssetAcctTransClassfctn,
       GroupMasterFixedAsset,
       GroupFixedAsset,
       @ObjectModel.foreignKey.association: '_FinancialAccountType'
       FinancialAccountType,
       JointVentureCostRecoveryCode,
       @ObjectModel.foreignKey.association: '_ChartOfDepreciation'
       _ChartOfDeprForAcctgPrinciple.ChartOfDepreciation,

       DepreciationIsDue,

       @Semantics.currencyCode:true
       @ObjectModel.foreignKey.association: '_CompanyCodeCurrency'
       CompanyCodeCurrency,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       AmountInCompanyCodeCurrency,

       @Semantics.currencyCode:true
       @ObjectModel.foreignKey.association: '_GlobalCurrency'
       GlobalCurrency,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
       AmountInGlobalCurrency,

       @Semantics.currencyCode:true
       @ObjectModel.foreignKey.association: '_FreeDefinedCurrency1'
       FreeDefinedCurrency1,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
       AmountInFreeDefinedCurrency1,

       @Semantics.currencyCode:true
       @ObjectModel.foreignKey.association: '_FreeDefinedCurrency2'
       FreeDefinedCurrency2,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
       AmountInFreeDefinedCurrency2,

       @Semantics.currencyCode:true
       @ObjectModel.foreignKey.association: '_FreeDefinedCurrency3'
       FreeDefinedCurrency3,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
       AmountInFreeDefinedCurrency3,

       @Semantics.currencyCode:true
       @ObjectModel.foreignKey.association: '_FreeDefinedCurrency4'
       FreeDefinedCurrency4,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
       AmountInFreeDefinedCurrency4,

       @Semantics.currencyCode:true
       @ObjectModel.foreignKey.association: '_FreeDefinedCurrency5'
       FreeDefinedCurrency5,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
       AmountInFreeDefinedCurrency5,

       @Semantics.currencyCode:true
       @ObjectModel.foreignKey.association: '_FreeDefinedCurrency6'
       FreeDefinedCurrency6,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
       AmountInFreeDefinedCurrency6,

       @Semantics.currencyCode:true
       @ObjectModel.foreignKey.association: '_FreeDefinedCurrency7'
       FreeDefinedCurrency7,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
       AmountInFreeDefinedCurrency7,

       @Semantics.currencyCode:true
       @ObjectModel.foreignKey.association: '_FreeDefinedCurrency8'
       FreeDefinedCurrency8,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
       AmountInFreeDefinedCurrency8,

       _CompanyCode,
       _FiscalYear,
       _MasterFixedAsset,
       _FixedAsset,
       _DepreciationArea,
       _SubLedgerAccLineItemType,
       _FiscalPeriod,
       _Ledger,
       _LedgerGroup,
       _FinancialAccountType,
       _ChartOfDepreciation,
       _AssetAcctTransClassfctn,
       _CompanyCodeCurrency,
       _GlobalCurrency,
       _FreeDefinedCurrency1,
       _FreeDefinedCurrency2,
       _FreeDefinedCurrency3,
       _FreeDefinedCurrency4,
       _FreeDefinedCurrency5,
       _FreeDefinedCurrency6,
       _FreeDefinedCurrency7,
       _FreeDefinedCurrency8,
       _AccountingPrinciple
}