C_AT_StRpAuditAssetTransacQ

DDL: C_AT_STRPAUDITASSETTRANSACQ SQL: CATSTRAUDASTTRAQ Type: view CONSUMPTION Package: GLO_FIN_IS_AUDIT_AT

Austrian Audit Asset Transaction Query

C_AT_StRpAuditAssetTransacQ is a Consumption CDS View that provides data about "Austrian Audit Asset Transaction Query" in SAP S/4HANA. It reads from 1 data source (I_AssetBalanceCube) and exposes 97 fields. It has 4 associations to related views. Part of development package GLO_FIN_IS_AUDIT_AT.

1 data source(s) 97 fields

Data Sources (1)

SourceAliasJoin Type
I_AssetBalanceCube I_AssetBalanceCube from

Parameters (12)

NameTypeDefault
P_Language sylangu
P_KeyDate fagl_keydate
P_BusinessUser syuname
P_AssetAccountingKeyFigureSet faa_key_figure_set
P_CompanyCode fis_bukrs
P_Ledger fis_rldnr
P_AssetDepreciationArea fis_afabe
P_FiscalYear fis_gjahr
P_FiscalPeriod fis_period_to
P_CurrencyRole fins_curtp
P_FiscalPeriodEndDate fagl_keydate
P_SelectedCurrencyBranch fis_curtp

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_AssetKeyFigureSet _AssetKeyFigureSet _AssetKeyFigureSet.AssetAccountingKeyFigureSet = :P_AssetAccountingKeyFigureSet and _AssetKeyFigureSet.AssetAcctgKeyFigSetAnlytlCntxt = '02'
[0..1] I_CompanyCodeAsset _CompanyCodeAssetVH _CompanyCodeAssetVH.CompanyCode = :P_CompanyCode
[0..1] I_FiscalYearForCompanyCode _FiscalYearVH _FiscalYearVH.FiscalYear = :P_FiscalYear and _FiscalYearVH.CompanyCode = :P_CompanyCode
[0..1] I_FiscalYearPeriodForLedger _FiscalYearPeriodVH _FiscalYearPeriodVH.CompanyCode = :P_CompanyCode and _FiscalYearPeriodVH.Ledger = :P_Ledger and _FiscalYearPeriodVH.FiscalYear = :P_FiscalYear and _FiscalYearPeriodVH.FiscalPeriod = :P_FiscalPeriod

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CATSTRAUDASTTRAQ view
VDM.viewType #CONSUMPTION view
Analytics.query true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Austrian Audit Asset Transaction Query view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (97)

KeyFieldSource TableSource FieldDescription
lookupEntityI_UserSettingsForCompanyCode
resultElementCompanyCode
resultElementLedger
resultElementAssetDepreciationArea
resultElementFiscalYear
resultElementFiscalPeriod
resultElementCompanyCodeCurrencyRole
resultElementFiscalPeriodEndDate
resultElementSelectedCurrencyBranch
AssetAccountDetermination
AssetClass AssetBal AssetClass
AssetAccountingKeyFigure AssetBal AssetAccountingSortedKeyFigure
DisplayCurrency AssetBal DisplayCurrency
AmountInDisplayCurrency
AcqnProdnCostGLAccount AssetBal AcqnProdnCostGLAccount
ChartOfAccounts AssetBal ChartOfAccounts
CompanyCode AssetBal CompanyCode
LedgerGroup AssetBal LedgerGroup
Ledger AssetBal Ledger
AssetDepreciationArea AssetBal AssetDepreciationArea
ChartOfDepreciation AssetBal ChartOfDepreciation
FiscalYear AssetBal FiscalYear
FiscalPeriod AssetBal FiscalPeriod
FinancialStatementVariant AssetBal FinancialStatementVariant
ControllingArea AssetBal ControllingArea
AssetPlant AssetBal AssetPlant
CostCenter AssetBal CostCenter
ProfitCenter AssetBal ProfitCenter
Segment AssetBal Segment
FundsCenter AssetBal FundsCenter
BusinessArea AssetBal BusinessArea
MasterFixedAsset AssetBal MasterFixedAsset
FixedAsset AssetBal FixedAsset
GroupMasterFixedAsset
GroupFixedAsset
PersonnelNumber AssetBal PersonnelNumber
AssetPersonnelNumber AssetBal AssetPersonnelNumber
FinancialManagementArea AssetBal FinancialManagementArea
Fund AssetBal Fund
GrantID AssetBal GrantID
FunctionalArea AssetBal FunctionalArea
BudgetPeriod AssetBal BudgetPeriod
SubLedgerAcctLineItemType AssetBal SubLedgerAcctLineItemType
AssetTransactionType AssetBal AssetTransactionType
AssetAcctTransClassfctn AssetBal AssetAcctTransClassfctn
FinancialAccountType AssetBal FinancialAccountType
AccountingDocumentCreationDate AssetBal AccountingDocumentCreationDate
CreationTime AssetBal CreationTime
JointVentureCostRecoveryCode AssetBal JointVentureCostRecoveryCode
AccountingPrinciple AssetBal AccountingPrinciple
FiscalYearVariant AssetBal FiscalYearVariant
CountryChartOfAccounts AssetBal CountryChartOfAccounts
GLAccount AssetBal GLAccount
AlternativeGLAccount AssetBal AlternativeGLAccount
AssetBusinessArea AssetBal AssetBusinessArea
AssetCostCenter AssetBal AssetCostCenter
AssetProfitCenter AssetBal AssetProfitCenter
AssetSegment AssetBal AssetSegment
AssetBudgetPeriod AssetBal AssetBudgetPeriod
AssetGrant AssetBal AssetGrant
AssetFund AssetBal AssetFund
AssetLocation AssetBal AssetLocation
AssetFundsCenter AssetBal AssetFundsCenter
RealEstateObject AssetBal RealEstateObject
AssetCostCtrActivityType AssetBal AssetCostCtrActivityType
FirstAcquisitionFiscalYear AssetBal FirstAcquisitionFiscalYear
FirstAcquisitionFiscalPeriod AssetBal FirstAcquisitionFiscalPeriod
AssetCapitalizationDate AssetBal AssetCapitalizationDate
AssetDeactivationDate AssetBal AssetDeactivationDate
FixedAssetGroup AssetBal FixedAssetGroup
Supplier AssetBal Supplier
AssetSupplierName AssetBal AssetSupplierName
InvestmentOrder AssetBal InvestmentOrder
BaseUnit AssetBal BaseUnit
InventoryIsCounted AssetBal InventoryIsCounted
LastInventoryDate AssetBal LastInventoryDate
Inventory AssetBal Inventory
Group1AssetEvaluationKey AssetBal Group1AssetEvaluationKey
Group2AssetEvaluationKey AssetBal Group2AssetEvaluationKey
Group3AssetEvaluationKey AssetBal Group3AssetEvaluationKey
Group4AssetEvaluationKey AssetBal Group4AssetEvaluationKey
Group5AssetEvaluationKey AssetBal Group5AssetEvaluationKey
AssetSerialNumber AssetBal AssetSerialNumber
InvestmentSupportMeasure AssetBal InvestmentSupportMeasure
DepreciationStartDate AssetBal DepreciationStartDate
SpecialDeprStartDate AssetBal SpecialDeprStartDate
DepreciationKey AssetBal DepreciationKey
PlannedUsefulLifeInYears AssetBal PlannedUsefulLifeInYears
PlannedUsefulLifeInPeriods AssetBal PlannedUsefulLifeInPeriods
Country AssetBal Country
NationalClassification AssetBal NationalClassification
TaxDepreciationGroup AssetBal TaxDepreciationGroup
AccountingDocument AssetBal AccountingDocument
Room AssetBal Room
VehicleLicensePlateNumber AssetBal VehicleLicensePlateNumber
TaxJurisdiction AssetBal TaxJurisdiction
WBSElementExternalID AssetBal WBSElementExternalID 
@AbapCatalog.sqlViewName: 'CATSTRAUDASTTRAQ'
@VDM.viewType: #CONSUMPTION
@Analytics.query: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'Austrian Audit Asset Transaction Query'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true

define view C_AT_StRpAuditAssetTransacQ
  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.valueHelp: '_AssetKeyFigureSet'
    @Consumption.defaultValue: 'ABS_DEF'
    P_AssetAccountingKeyFigureSet : faa_key_figure_set,

    @AnalyticsDetails.query.variableSequence : 20
    @Consumption.valueHelp: '_CompanyCodeAssetVH'
    @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.derivation: { lookupEntity: 'I_UserSettingsForDeprArea',
          resultElement: 'AssetDepreciationArea', binding: [
          { targetElement : 'BusinessUser' , type : #PARAMETER, value : 'P_BusinessUser' } ]
         }
    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.valueHelp: '_FiscalYearVH'
    P_FiscalYear                  : fis_gjahr,

    @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.valueHelp: '_FiscalYearPeriodVH'
    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_CurrencyRole',
                   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
  association [0..1] to I_AssetKeyFigureSet         as _AssetKeyFigureSet  on  _AssetKeyFigureSet.AssetAccountingKeyFigureSet    = :P_AssetAccountingKeyFigureSet
                                                                           and _AssetKeyFigureSet.AssetAcctgKeyFigSetAnlytlCntxt = '02'
  association [0..1] to I_CompanyCodeAsset          as _CompanyCodeAssetVH on  _CompanyCodeAssetVH.CompanyCode = :P_CompanyCode
  association [0..1] to I_FiscalYearForCompanyCode  as _FiscalYearVH       on  _FiscalYearVH.FiscalYear  = :P_FiscalYear
                                                                           and _FiscalYearVH.CompanyCode = :P_CompanyCode
  association [0..1] to I_FiscalYearPeriodForLedger as _FiscalYearPeriodVH on  _FiscalYearPeriodVH.CompanyCode  = :P_CompanyCode
                                                                           and _FiscalYearPeriodVH.Ledger       = :P_Ledger
                                                                           and _FiscalYearPeriodVH.FiscalYear   = :P_FiscalYear
                                                                           and _FiscalYearPeriodVH.FiscalPeriod = :P_FiscalPeriod
{
  //Rows:

  //=====

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #ROWS
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.AssetAccountDetermination,

  @Consumption.filter: {selectionType: #SINGLE, 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,

  //Free characteristics:

  //=====================

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.AcqnProdnCostGLAccount,

  @Consumption.filter: {selectionType: #SINGLE, 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: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  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: #SINGLE, multipleSelections: false, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.FinancialStatementVariant,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.ControllingArea,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.AssetPlant,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.CostCenter,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.ProfitCenter,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.Segment,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.FundsCenter,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.BusinessArea,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.MasterFixedAsset,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.FixedAsset,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  cast(AssetBal.GroupMasterFixedAsset as fis_anlgr)               as GroupMasterFixedAsset,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  cast(AssetBal.GroupFixedAsset as fis_anlgr2)                    as GroupFixedAsset,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.PersonnelNumber,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.AssetPersonnelNumber,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.FinancialManagementArea,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.Fund,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.GrantID,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.FunctionalArea,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.BudgetPeriod,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.SubLedgerAcctLineItemType,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.AssetTransactionType,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.AssetAcctTransClassfctn,

  @Consumption.filter: {selectionType: #SINGLE, 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: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.JointVentureCostRecoveryCode,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.AccountingPrinciple,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.FiscalYearVariant,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.CountryChartOfAccounts,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.GLAccount,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.AlternativeGLAccount,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.AssetBusinessArea,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.AssetCostCenter,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.AssetProfitCenter,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.AssetSegment,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.AssetBudgetPeriod,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.AssetGrant,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.AssetFund,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.AssetLocation,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.AssetFundsCenter,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.RealEstateObject,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.AssetCostCtrActivityType,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.FirstAcquisitionFiscalYear,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.FirstAcquisitionFiscalPeriod,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.AssetCapitalizationDate,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.AssetDeactivationDate,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.FixedAssetGroup,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.Supplier,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.AssetSupplierName,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.InvestmentOrder,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.BaseUnit,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.InventoryIsCounted,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.LastInventoryDate,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.Inventory,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.Group1AssetEvaluationKey,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.Group2AssetEvaluationKey,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.Group3AssetEvaluationKey,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.Group4AssetEvaluationKey,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.Group5AssetEvaluationKey,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.AssetSerialNumber,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.InvestmentSupportMeasure,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.DepreciationStartDate,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.SpecialDeprStartDate,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.DepreciationKey,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.PlannedUsefulLifeInYears,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.PlannedUsefulLifeInPeriods,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.Country,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.NationalClassification,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  AssetBal.TaxDepreciationGroup,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.AccountingDocument,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.Room,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.VehicleLicensePlateNumber,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.TaxJurisdiction,

  @Consumption.filter: {selectionType: #SINGLE, multipleSelections: true, mandatory: false}
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  AssetBal.WBSElementExternalID
}
where
      CompanyCode            = :P_CompanyCode
  and Ledger                 = :P_Ledger
  and AssetDepreciationArea  = :P_AssetDepreciationArea
  and SelectedCurrencyBranch = :P_SelectedCurrencyBranch

Learn More