I_FIXEDASSETTMPPLANVAL

CDS View

Fixed Asset Temporary Plan Values

I_FIXEDASSETTMPPLANVAL is a CDS View in S/4HANA. Fixed Asset Temporary Plan Values. It contains 21 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_AssetBalanceWithTmpPlanVal view from COMPOSITE
P_FxdAstDBPlanWithTempPlanVal view union_all COMPOSITE
P_FxdAstPlanValWithTmpPlanVal view from COMPOSITE

Fields (21)

KeyField CDS FieldsUsed in Views
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn 1
KEY AssetDepreciationArea AssetDepreciationArea 2
KEY CompanyCode CompanyCode 3
KEY FiscalPeriod FiscalPeriod 1
KEY FiscalYear FiscalYear 1
KEY FixedAsset FixedAsset 1
KEY Ledger Ledger 3
KEY MasterFixedAsset MasterFixedAsset 1
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 1
CompanyCodeCurrency CompanyCodeCurrency 1
FreeDefinedCurrency1 FreeDefinedCurrency1 1
FreeDefinedCurrency2 FreeDefinedCurrency2 1
FreeDefinedCurrency3 FreeDefinedCurrency3 1
FreeDefinedCurrency4 FreeDefinedCurrency4 1
FreeDefinedCurrency5 FreeDefinedCurrency5 1
FreeDefinedCurrency6 FreeDefinedCurrency6 1
FreeDefinedCurrency7 FreeDefinedCurrency7 1
FreeDefinedCurrency8 FreeDefinedCurrency8 1
GlobalCurrency GlobalCurrency 1
LedgerGroup LedgerGroup 1
PlannedValueIsInclusive PlannedValueIsInclusive 2
@AbapCatalog: {sqlViewName: 'IFASSETTMPPV', preserveKey: true, compiler.compareFilter: true}
@EndUserText.label: 'Fixed Asset Temporary Plan Values'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: { usageType.serviceQuality: #X,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MIXED }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.buffering.status: #NOT_ALLOWED


define view I_FixedAssetTmpPlanVal

  as select from P_FixedAssetTmpPlanVal
    inner join   I_LedgerCompanyCodeCrcyRoles on  P_FixedAssetTmpPlanVal.Ledger      = I_LedgerCompanyCodeCrcyRoles.Ledger
                                              and P_FixedAssetTmpPlanVal.CompanyCode = I_LedgerCompanyCodeCrcyRoles.CompanyCode

  association [0..1] to I_ChartOfDeprForAcctgPrinciple as _ChartOfDeprForAcctgPrinciple on  $projection.AccountingPrinciple    = _ChartOfDeprForAcctgPrinciple.AccountingPrinciple
                                                                                        and P_FixedAssetTmpPlanVal.CompanyCode = _ChartOfDeprForAcctgPrinciple.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_Ledger                       as _Ledger                       on  $projection.Ledger = _Ledger.Ledger
  association [0..1] to I_LedgerGroup                  as _LedgerGroup                  on  $projection.LedgerGroup = _LedgerGroup.LedgerGroup
  association [0..*] to I_LedgerGroupAssignment        as _LedgerGroupAssignment        on  $projection.LedgerGroup = _LedgerGroupAssignment.LedgerGroup


  association [0..1] to I_FiscalYearForCompanyCode     as _FiscalYear                   on  $projection.FiscalYear  = _FiscalYear.FiscalYear
                                                                                        and $projection.CompanyCode = _FiscalYear.CompanyCode
  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_SubLedgerAccLineItemType     as _SubLedgerAccLineItemType     on  $projection.SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType
  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_ChartOfDepreciation          as _ChartOfDepreciation          on  $projection.chartofdepreciation = _ChartOfDepreciation.ChartOfDepreciation
  association [1]    to I_AccountingPrinciple          as _AccountingPrinciple          on  $projection.AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple
  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





{
  key  CreationDateTime,
  key  CreatedByUser,

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

       @ObjectModel.foreignKey.association: '_AccountingPrinciple'
       I_LedgerCompanyCodeCrcyRoles.AccountingPrinciple,

       @ObjectModel.foreignKey.association: '_ChartOfDepreciation'
       _ChartOfDeprForAcctgPrinciple.ChartOfDepreciation,


       PlannedValueIsInclusive,
       // Values.faa_use_val_ty                                                                                                                                   as  PlannedValueIsInclusive,

       @ObjectModel.foreignKey.association: '_Ledger'
       P_FixedAssetTmpPlanVal.Ledger,
       P_FixedAssetTmpPlanVal.IsRepresentativeLedger,
       @ObjectModel.foreignKey.association: '_LedgerGroup'
       LedgerGroup,
       GroupMasterFixedAsset,
       GroupFixedAsset,
       AssetAcctTransClassfctn,
       FinancialAccountType,
       @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,
       @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,

       AssetClass,
       AssetAccountDetermination,
       IsGroupAsset,
       JointVentureCostRecoveryCode,


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

}



//define view I_FixedAssetTmpPlanVal

//  as select from faat_d_pv_hdr    as Header

//    inner join   faat_d_pv_values as Values on Header.db_key = Values.root_key

//    inner join   I_CompanyCodeAsset         on Values.bukrs = I_CompanyCodeAsset.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_Ledger                       as _Ledger                   on  $projection.Ledger = _Ledger.Ledger

//  association [0..1] to I_LedgerGroup                  as _LedgerGroup              on  $projection.LedgerGroup = _LedgerGroup.LedgerGroup

//  association [0..*] to I_LedgerGroupAssignment        as _LedgerGroupAssignment    on  $projection.LedgerGroup = _LedgerGroupAssignment.LedgerGroup

//

//

//  association [0..1] to I_FiscalYearForCompanyCode     as _FiscalYear               on  $projection.FiscalYear  = _FiscalYear.FiscalYear

//                                                                                    and $projection.CompanyCode = _FiscalYear.CompanyCode

//  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_SubLedgerAccLineItemType     as _SubLedgerAccLineItemType on  $projection.SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType

//  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_DepreciationArea             as _DepreciationArea           on  $projection.ChartOfDepreciation   = _DepreciationArea.ChartOfDepreciation

//  //                                                                                      and $projection.AssetDepreciationArea = _DepreciationArea.AssetDepreciationArea

//  association [0..1] to I_ChartOfDepreciation          as _ChartOfDepreciation      on  $projection.ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation

//

//  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

//

//{

//

//  key Header.timestamp                                                                                                                                        as  CreationDateTime,

//  key Header.usera                                                                                                                                            as  CreatedByUser,

//      @ObjectModel.foreignKey.association: '_DepreciationArea'

//  key Values.afabe                                                                                                                                            as  AssetDepreciationArea,

//      @ObjectModel.foreignKey.association: '_CompanyCode'

//  key Values.bukrs                                                                                                                                            as  CompanyCode,

//      @ObjectModel.foreignKey.association: '_FiscalYear'

//  key Values.gjahr                                                                                                                                            as  FiscalYear,

//      @ObjectModel.foreignKey.association: '_MasterFixedAsset'

//  key Values.anln1                                                                                                                                            as  MasterFixedAsset,

//      @ObjectModel.foreignKey.association: '_FixedAsset'

//  key Values.anln2                                                                                                                                            as  FixedAsset,

//      @ObjectModel.foreignKey.association: '_SubledgerAccLineItemType'

//  key Values.slalittype                                                                                                                                       as  SubLedgerAcctLineItemType,

//      @ObjectModel.foreignKey.association: '_FiscalPeriod'

//  key Values.poper                                                                                                                                            as  FiscalPeriod,

//

//      //Carry balance forward values

//      case when Values.movcat = '00' then cast ( '1' as faa_use_val_ty)

//      //Planned values

//      else cast ('2' as faa_use_val_ty)

//      end                                                                                                                                                     as  PlannedValueIsInclusive,

//      // Values.faa_use_val_ty                                                                                                                                   as  PlannedValueIsInclusive,

//      @ObjectModel.foreignKey.association: '_Ledger'

//      _LedgerGroupAssignment[1: IsRepresentativeLedger = 'X' ].Ledger                                                                                         as  Ledger,

//      @ObjectModel.foreignKey.association: '_LedgerGroup'

//      Values.ldgrp                                                                                                                                            as  LedgerGroup,

//      Values.anlgr                                                                                                                                            as  GroupMasterFixedAsset,

//      Values.anlgr2                                                                                                                                           as  GroupFixedAsset,

//      Values.movcat                                                                                                                                           as  AssetAcctTransClassfctn,

//      cast('A' as fis_koart preserving type)                                                                                                                  as  FinancialAccountType,

//

//      @Semantics.currencyCode:true

//      @ObjectModel.foreignKey.association: '_CompanyCodeCurrency'

//      cast(Values.rhcur as fis_hwaer preserving type)                                                                                                         as  CompanyCodeCurrency,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }

//      cast(Values.hsl as fis_hsl preserving type)                                                                                                             as  AmountInCompanyCodeCurrency,

//

//      @Semantics.currencyCode:true

//      @ObjectModel.foreignKey.association: '_GlobalCurrency'

//      cast(Values.rkcur as fis_rkcur preserving type)                                                                                                         as  GlobalCurrency,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }

//      cast(Values.ksl as fis_ksl preserving type)                                                                                                             as  AmountInGlobalCurrency,

//

//      @Semantics.currencyCode:true

//      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency1'

//      cast(rocur as fis_rocur preserving type)                                                                                                                as  FreeDefinedCurrency1,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }

//      cast(osl as fis_osl preserving type)                                                                                                                    as  AmountInFreeDefinedCurrency1,

//

//      @Semantics.currencyCode:true

//      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency2'

//      cast(rvcur as fis_rvcur preserving type)                                                                                                                as  FreeDefinedCurrency2,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }

//      cast(vsl as fis_vsl preserving type)                                                                                                                    as  AmountInFreeDefinedCurrency2,

//

//      @Semantics.currencyCode:true

//      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency3'

//      rbcur                                                                                                                                                   as  FreeDefinedCurrency3,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }

//      cast(bsl as fis_bsl preserving type)                                                                                                                    as  AmountInFreeDefinedCurrency3,

//

//      @Semantics.currencyCode:true

//      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency4'

//      rccur                                                                                                                                                   as  FreeDefinedCurrency4,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }

//      cast(csl as fis_csl preserving type)                                                                                                                    as  AmountInFreeDefinedCurrency4,

//

//      @Semantics.currencyCode:true

//      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency5'

//      rdcur                                                                                                                                                   as  FreeDefinedCurrency5,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }

//      cast(dsl as fis_dsl preserving type)                                                                                                                    as  AmountInFreeDefinedCurrency5,

//

//

//      @Semantics.currencyCode:true

//      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency6'

//      recur                                                                                                                                                   as  FreeDefinedCurrency6,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }

//      cast(esl as fis_esl preserving type)                                                                                                                    as  AmountInFreeDefinedCurrency6,

//

//      @Semantics.currencyCode:true

//      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency7'

//      cast(rfcur as fis_rfcur preserving type)                                                                                                                as  FreeDefinedCurrency7,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }

//      cast(fsl as fis_fsl preserving type)                                                                                                                    as  AmountInFreeDefinedCurrency7,

//

//      @Semantics.currencyCode:true

//      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency8'

//      rgcur                                                                                                                                                   as  FreeDefinedCurrency8,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }

//      cast(gsl as fis_gsl preserving type)                                                                                                                    as  AmountInFreeDefinedCurrency8,

//

//      Values.anlkl                                                                                                                                            as  AssetClass,

//      Values.ktogr                                                                                                                                            as  AssetAccountDetermination,

//      Values.xanlgr                                                                                                                                           as  IsGroupAsset,

//      Values.recid                                                                                                                                            as  JointVentureCostRecoveryCode,

//

//      @ObjectModel.foreignKey.association: '_ChartOfDepreciation'

//      I_CompanyCodeAsset.ChartOfDepreciation,

//

//      _CompanyCode,

//      _Ledger,

//      _LedgerGroup,

//      _FiscalYear,

//      _FiscalPeriod,

//      _SubLedgerAccLineItemType,

//      _MasterFixedAsset,

//      _FixedAsset,

//      _DepreciationArea,

//      _ChartOfDepreciation,

//      _CompanyCodeCurrency,

//      _GlobalCurrency,

//      _FreeDefinedCurrency1,

//      _FreeDefinedCurrency2,

//      _FreeDefinedCurrency3,

//      _FreeDefinedCurrency4,

//      _FreeDefinedCurrency5,

//      _FreeDefinedCurrency6,

//      _FreeDefinedCurrency7,

//      _FreeDefinedCurrency8

//

//}

//where

//  (

//       hsl           <> 0.00

//    or ksl           <> 0.00

//    or osl           <> 0.00

//    or vsl           <> 0.00

//    or bsl           <> 0.00

//    or csl           <> 0.00

//    or csl           <> 0.00

//    or dsl           <> 0.00

//    or esl           <> 0.00

//    or fsl           <> 0.00

//    or gsl           <> 0.00

//  )

//  and(

//       Values.movcat =  '00'

//    or Values.movcat =  '06'

//    or Values.movcat =  '46'

//    or Values.movcat =  '61'

//    or movcat        =  '65'

//    or movcat        =  '66'

//  )

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHARTOFDEPRFORACCTGPRINCIPLE",
"I_LEDGERCOMPANYCODECRCYROLES",
"P_FIXEDASSETTMPPLANVAL"
],
"ASSOCIATED":
[
"I_ACCOUNTINGPRINCIPLE",
"I_CHARTOFDEPRECIATION",
"I_CHARTOFDEPRFORACCTGPRINCIPLE",
"I_COMPANYCODE",
"I_CURRENCY",
"I_DEPRECIATIONAREAFORLEDGER",
"I_FISCALYEARFORCOMPANYCODE",
"I_FISCALYEARPERIODFORCMPNYCODE",
"I_FIXEDASSET",
"I_LEDGER",
"I_LEDGERGROUP",
"I_LEDGERGROUPASSIGNMENT",
"I_MASTERFIXEDASSET",
"I_SUBLEDGERACCLINEITEMTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/