@AbapCatalog: { sqlViewName: 'CFASTBALANCE', compiler.compareFilter: true }
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType: #CONSUMPTION
@Analytics.query: true
@EndUserText.label: 'Asset Balances'
@AbapCatalog.buffering.status: #NOT_ALLOWED
@ObjectModel: { usageType.serviceQuality: #D,
usageType.sizeCategory: #XXL,
usageType.dataClass: #MIXED,
supportedCapabilities: [ #ANALYTICAL_QUERY ],
modelingPattern: #ANALYTICAL_QUERY }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
define view C_AssetBalance
with parameters
@Consumption.hidden: true
@Environment.systemField: #SYSTEM_LANGUAGE
P_Language : sylangu,
@Consumption.hidden: true
@Environment.systemField: #SYSTEM_DATE
P_KeyDate : fagl_keydate,
@Consumption.hidden: true
@Environment.systemField: #USER
P_BusinessUser : syuname,
@AnalyticsDetails.query.variableSequence : 10
@Consumption.valueHelpDefinition: { entity: { name: 'I_AssetBalancesKeyFigureSetVH', element: 'AssetAccountingKeyFigureSet' } }
@Consumption.defaultValue: 'ABS_DEF'
P_AssetAccountingKeyFigureSet : faa_key_figure_set,
@AnalyticsDetails.query.variableSequence : 20
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_CompanyCodeAsset', element: 'CompanyCode' }
} ]
@Consumption.derivation: { lookupEntity: 'I_UserSettingsForCompanyCode',
resultElement: 'CompanyCode',
binding: [ { targetElement : 'BusinessUser' , type : #PARAMETER, value : 'P_BusinessUser' } ] }
P_CompanyCode : fis_bukrs,
@AnalyticsDetails.query.variableSequence : 30
@Consumption.derivation: { lookupEntity: 'I_Ledger',
resultElement: 'Ledger', binding: [
{ targetElement : 'IsLeadingLedger' , type : #CONSTANT, value : 'X' } ]
}
P_Ledger : fis_rldnr,
@AnalyticsDetails.query.variableSequence : 40
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_DepreciationAreaForLedger', element: 'AssetDepreciationArea' },
additionalBinding: [ { localParameter: 'P_CompanyCode', element: 'CompanyCode' },
{ localParameter: 'P_Ledger', element: 'Ledger'} ]
} ]
P_AssetDepreciationArea : fis_afabe,
@AnalyticsDetails.query.variableSequence : 50
@Consumption.derivation: { lookupEntity: 'I_FiscalCalendarDateForLedger',
resultElement: 'FiscalYear', binding: [
{ targetElement : 'CalendarDate' , type : #PARAMETER, value : 'P_KeyDate' },
{ targetElement : 'CompanyCode', type : #PARAMETER, value : 'P_CompanyCode' },
{ targetElement : 'Ledger' , type : #PARAMETER, value : 'P_Ledger' }]
}
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_FiscalYearForCompanyCode', element: 'FiscalYear' },
additionalBinding: [ { localParameter: 'P_CompanyCode', element: 'CompanyCode' } ]
} ]
P_FiscalYear : fis_ryear,
@AnalyticsDetails.query.variableSequence : 60
@Consumption.derivation: {
lookupEntity : 'I_FsclCalDateFsclYrLastPeriod',
resultElement: 'FiscalPeriod', binding: [
{ targetElement : 'CompanyCode', type : #PARAMETER, value : 'P_CompanyCode' },
{ targetElement : 'Ledger' , type : #PARAMETER, value : 'P_Ledger' },
{ targetElement : 'CalendarDate' , type : #PARAMETER, value : 'P_KeyDate' }]
}
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_FiscalYearPeriodForLedger', element: 'FiscalPeriod' },
additionalBinding: [ { localParameter: 'P_CompanyCode', element: 'CompanyCode' },
{ localParameter: 'P_Ledger', element: 'Ledger' },
{ localParameter: 'P_FiscalYear', element: 'FiscalYear' } ]
} ]
P_FiscalPeriod : fis_period_to,
@AnalyticsDetails.query.variableSequence : 70
@Consumption.derivation: { lookupEntity: 'I_Ledgercompanycodecrcyroles',
resultElement: 'CompanyCodeCurrencyRole', binding: [
{ targetElement : 'Ledger' , type : #PARAMETER, value : 'P_Ledger' },
{ targetElement : 'CompanyCode' , type : #PARAMETER, value : 'P_CompanyCode' } ]
}
@Consumption.valueHelpDefinition: {
entity: { name: 'I_CurrencyRoleInLedgerCoCodeVH',
element: 'CurrencyRole'
}
}
P_CurrencyRole : fins_curtp,
@Consumption.hidden: true
@Consumption.derivation: { lookupEntity: 'I_FiscalYearPeriodForLedger',
resultElement: 'FiscalPeriodEndDate', binding: [
{ targetElement : 'Ledger' , type : #PARAMETER, value : 'P_Ledger' },
{ targetElement : 'CompanyCode' , type : #PARAMETER, value : 'P_CompanyCode' },
{ targetElement : 'FiscalYear' , type : #PARAMETER, value : 'P_FiscalYear' },
{ targetElement : 'FiscalPeriod' , type : #PARAMETER, value : 'P_FiscalPeriod' } ]
}
P_FiscalPeriodEndDate : fagl_keydate,
@Consumption.hidden: true
@Consumption.derivation: { lookupEntity: 'I_LdgrCoCodeSelectedCrcyBranch',
resultElement: 'SelectedCurrencyBranch', binding: [
{ targetElement : 'Ledger' , type : #PARAMETER, value : 'P_Ledger' },
{ targetElement : 'CompanyCode' , type : #PARAMETER, value : 'P_CompanyCode' },
{ targetElement : 'CurrencyRole' , type : #PARAMETER, value : 'P_CurrencyRole' } ]
}
P_SelectedCurrencyBranch : fis_curtp
as select from I_AssetBalanceCube( P_AssetAccountingKeyFigureSet: :P_AssetAccountingKeyFigureSet, P_FiscalYear: :P_FiscalYear , P_FiscalPeriod: :P_FiscalPeriod, P_KeyDate: :P_FiscalPeriodEndDate ) as AssetBal
{
//Rows:
//=====
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #ROWS
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetAccountDetermination,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #ROWS
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetClass,
// Columns (Key Figures):
//=======================
@AnalyticsDetails.query.axis: #COLUMNS
//@AnalyticsDetails.query.display: #TEXT <<<<<Do not use this annotation: sorting of the columns in the history sheet gets lost
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetAccountingSortedKeyFigure as AssetAccountingKeyFigure,
@Semantics.currencyCode:true
AssetBal.DisplayCurrency,
@AnalyticsDetails.query.axis: #COLUMNS
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
cast( AssetBal.AmountInDisplayCurrency as fis_balance_amount ) as AmountInDisplayCurrency,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@Semantics.unitOfMeasure:true
AssetBal.BaseUnit,
@AnalyticsDetails.query.hidden: true
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
AssetBal.Quantity,
//Free characteristics:
//=====================
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AcqnProdnCostGLAccount,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.ChartOfAccounts,
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.CompanyCode,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
@AnalyticsDetails.query.hidden: true
AssetBal.LedgerGroup,
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.Ledger,
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetDepreciationArea,
@Consumption.filter: {selectionType: #SINGLE, multipleSelections: false, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.ChartOfDepreciation,
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.FiscalYear,
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.FiscalPeriod,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.FinancialStatementVariant,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.ControllingArea,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetPlant,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.CostCenter,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.ProfitCenter,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.Segment,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.FundsCenter,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.BusinessArea,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.MasterFixedAsset,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.FixedAsset,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
cast( AssetBal.GroupMasterFixedAsset as fis_anlgr ) as GroupMasterFixedAsset,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
cast( AssetBal.GroupFixedAsset as fis_anlgr2 ) as GroupFixedAsset,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.PersonnelNumber,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetPersonnelNumber,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.FinancialManagementArea,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.Fund,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.GrantID,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.FunctionalArea,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.BudgetPeriod,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.SubLedgerAcctLineItemType,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetTransactionType,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.BusinessTransactionCategory,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.BusinessTransactionType,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.FinancialClosingStep,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetAcctTransClassfctn,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.FinancialAccountType,
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.AccountingDocumentCreationDate,
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.CreationTime,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.JointVentureCostRecoveryCode,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AccountingPrinciple,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.FiscalYearVariant,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.CountryChartOfAccounts,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.GLAccount,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AlternativeGLAccount,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetBusinessArea,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetCostCenter,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetWBSElementExternalID,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetProfitCenter,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetSegment,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetFunctionalArea,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetBudgetPeriod,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.AssetGrant,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.AssetFund,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.AssetLocation,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.AssetFundsCenter,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.REInternalFinNumber,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'REInternalFinNumber'
// @VDM.lifecycle.status: #DEPRECATED
// @VDM.lifecycle.successor: 'REInternalFinNumber'
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.RealEstateObject,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetCostCtrActivityType,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.FirstAcquisitionFiscalYear,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.FirstAcquisitionFiscalPeriod,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.AssetCapitalizationDate,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.AssetDeactivationDate,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.FixedAssetGroup,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.Supplier,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.AssetSupplierName,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.InvestmentOrder,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.InventoryIsCounted,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.LastInventoryDate,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.Inventory,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.Group1AssetEvaluationKey,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.Group2AssetEvaluationKey,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.Group3AssetEvaluationKey,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.Group4AssetEvaluationKey,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.Group5AssetEvaluationKey,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.AssetSerialNumber,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.InvestmentSupportMeasure,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.DepreciationStartDate,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.SpecialDeprStartDate,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.DepreciationKey,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.PlannedUsefulLifeInYears,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.PlannedUsefulLifeInPeriods,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.FixedAssetUsageObject,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.AssetRevaluationIndex,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.Country,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.NationalClassification,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
@AnalyticsDetails.query.display: #KEY_TEXT
AssetBal.TaxDepreciationGroup,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.AccountingDocument,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.Room,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.VehicleLicensePlateNumber,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.TaxJurisdiction,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.WBSElementExternalID,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.RU_AssetOKOF,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.RU_AssetDepreciationGroup,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.JP_PrptyTxRptCity,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.JP_PrptyTxRptClassfctnKey,
@Consumption.filter: {selectionType: #RANGE, multipleSelections: true, mandatory: false}
@AnalyticsDetails.query.axis: #FREE
@AnalyticsDetails.query.totals: #SHOW
AssetBal.AssetAdditionalDescription
}
where
CompanyCode = :P_CompanyCode
and Ledger = :P_Ledger
and AssetDepreciationArea = :P_AssetDepreciationArea
and(
AssetDeactivationDate > :P_FiscalPeriodEndDate
or AssetDeactivationDate = '00000000'
)
and SelectedCurrencyBranch = :P_SelectedCurrencyBranch
//The following properties of the where clause are used to enable the value help on the parameters by the analytical engine
and AssetAccountingKeyFigureSet = :P_AssetAccountingKeyFigureSet
and LedgerFiscalYear = :P_FiscalYear