@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":""
}
}*/