P_FixedAssetValueForToFsclPerd

DDL: P_FIXEDASSETVALUEFORTOFSCLPERD Type: view COMPOSITE Package: FINS_FIS_AA_MD

P_FixedAssetValueForToFsclPerd

P_FixedAssetValueForToFsclPerd is a Composite CDS View that provides data about "P_FixedAssetValueForToFsclPerd" in SAP S/4HANA. It reads from 6 data sources and exposes 201 fields with key fields AssetDepreciationArea, CompanyCode, FiscalYear, MasterFixedAsset, FixedAsset. Part of development package FINS_FIS_AA_MD.

6 data source(s) 201 fields

Data Sources (6)

SourceAliasJoin Type
I_AssetKeyFigureSetSpec AssetKeyFigureSetSpec inner
I_AssetKeyFigureSetSpec AssetKeyFigureSetSpec inner
I_AssetKeyFigureSpecification AssetKeyFigureSpec inner
I_AssetKeyFigureSpecification AssetKeyFigureSpec inner
P_FixedAssetValueWthDetn P_FixedAssetValueWthDetn from
P_FixedAssetValueWthDetn P_FixedAssetValueWthDetn union_all

Parameters (3)

NameTypeDefault
P_AssetAccountingKeyFigureSet faa_key_figure_set
P_FiscalYear fis_gjahr
P_ToFiscalPeriod fis_period_to

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFASSETVALUEFP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view

Fields (201)

KeyFieldSource TableSource FieldDescription
KEY AssetDepreciationArea values AssetDepreciationArea
KEY CompanyCode values CompanyCode
KEY FiscalYear values FiscalYear
KEY MasterFixedAsset values MasterFixedAsset
KEY FixedAsset values FixedAsset
KEY AccountingDocument values AccountingDocument
KEY TransactionSubitem values TransactionSubitem
KEY Ledger values Ledger
KEY FiscalPeriod values FiscalPeriod
KEY SubLedgerAcctLineItemType values SubLedgerAcctLineItemType
KEY AssetAcctTransClassfctn values AssetAcctTransClassfctn
KEY DebitCreditCode values DebitCreditCode
LedgerFiscalYear LedgerFiscalYear
FiscalYearVariant FiscalYearVariant
FiscalYearPeriod FiscalYearPeriod
DepreciationFiscalPeriod DepreciationFiscalPeriod
AssetReportingFiscalPeriod DepreciationFiscalPeriod
IsPlanningDocument IsPlanningDocument
AssetAccountingSortedKeyFigure I_AssetKeyFigureSetSpec AssetAccountingSortedKeyFigure
AssetAcctAnlytlTransClassfctn values AssetAcctAnlytlTransClassfctn
LedgerGroup values LedgerGroup
ChartOfAccounts values ChartOfAccounts
CountryChartOfAccounts values CountryChartOfAccounts
GLAccount values GLAccount
AlternativeGLAccount values AlternativeGLAccount
GroupMasterFixedAsset values GroupMasterFixedAsset
GroupFixedAsset values GroupFixedAsset
FinancialAccountType values FinancialAccountType
ChartOfDepreciation values ChartOfDepreciation
AccountingDocumentCreationDate values AccountingDocumentCreationDate
CreationTime values CreationTime
AccountingDocCreatedByUser values AccountingDocCreatedByUser
JointVentureCostRecoveryCode values JointVentureCostRecoveryCode
CostCenter values CostCenter
Plant values Plant
BusinessArea values BusinessArea
PersonnelNumber values PersonnelNumber
FinancialManagementArea values FinancialManagementArea
Fund values Fund
GrantID values GrantID
FunctionalArea values FunctionalArea
BudgetPeriod values BudgetPeriod
ProfitCenter values ProfitCenter
Segment values Segment
FundsCenter values FundsCenter
AssetTransactionType values AssetTransactionType
AssetDeactivationDate values AssetDeactivationDate
AssetAccountingKeyFigure I_AssetKeyFigureSpecification AssetAccountingKeyFigure
PlannedValueIsInclusive I_AssetKeyFigureSpecification PlannedValueIsInclusive
ReferenceDocumentItem values ReferenceDocumentItem
ReferenceDocumentType values ReferenceDocumentType
LogicalSystem values LogicalSystem
ReferenceDocument values ReferenceDocument
ReferenceDocumentContext values ReferenceDocumentContext
ReversalReferenceDocument values ReversalReferenceDocument
ReversalReferenceDocumentCntxt values ReversalReferenceDocumentCntxt
ReversalTransactionSubitem values ReversalTransactionSubitem
IsReversal values IsReversal
IsReversed values IsReversed
DocumentDate values DocumentDate
PostingDate values PostingDate
AssetValueDate values AssetValueDate
AccountingDocumentType values AccountingDocumentType
AssignmentReference values AssignmentReference
DocumentItemText values DocumentItemText
IsStatisticalDocument values IsStatisticalDocument
GLBusinessTransactionType values GLBusinessTransactionType
PartnerMasterFixedAsset values PartnerMasterFixedAsset
PartnerFixedAsset values PartnerFixedAsset
CompanyCodeCurrency values CompanyCodeCurrency
GlobalCurrency values GlobalCurrency
FreeDefinedCurrency1 values FreeDefinedCurrency1
FreeDefinedCurrency2 values FreeDefinedCurrency2
FreeDefinedCurrency3 values FreeDefinedCurrency3
FreeDefinedCurrency4 values FreeDefinedCurrency4
FreeDefinedCurrency5 values FreeDefinedCurrency5
FreeDefinedCurrency6 values FreeDefinedCurrency6
FreeDefinedCurrency7 values FreeDefinedCurrency7
FreeDefinedCurrency8 values FreeDefinedCurrency8
ActualAmountInCompanyCodeCrcy values ActualAmountInCompanyCodeCrcy
ActualAmountInGlobalCurrency values ActualAmountInGlobalCurrency
ActualAmountInFreeDfndCrcy1 values ActualAmountInFreeDfndCrcy1
ActualAmountInFreeDfndCrcy2 values ActualAmountInFreeDfndCrcy2
ActualAmountInFreeDfndCrcy3 values ActualAmountInFreeDfndCrcy3
ActualAmountInFreeDfndCrcy4 values ActualAmountInFreeDfndCrcy4
ActualAmountInFreeDfndCrcy5 values ActualAmountInFreeDfndCrcy5
ActualAmountInFreeDfndCrcy6 values ActualAmountInFreeDfndCrcy6
ActualAmountInFreeDfndCrcy7 values ActualAmountInFreeDfndCrcy7
ActualAmountInFreeDfndCrcy8 values ActualAmountInFreeDfndCrcy8
PlanAmountInCompanyCodeCrcy values PlanAmountInCompanyCodeCrcy
PlanAmountInGlobalCurrency values PlanAmountInGlobalCurrency
PlanAmountInFreeDefinedCrcy1 values PlanAmountInFreeDefinedCrcy1
PlanAmountInFreeDefinedCrcy2 values PlanAmountInFreeDefinedCrcy2
PlanAmountInFreeDefinedCrcy3 values PlanAmountInFreeDefinedCrcy3
PlanAmountInFreeDefinedCrcy4 values PlanAmountInFreeDefinedCrcy4
PlanAmountInFreeDefinedCrcy5 values PlanAmountInFreeDefinedCrcy5
PlanAmountInFreeDefinedCrcy6 values PlanAmountInFreeDefinedCrcy6
PlanAmountInFreeDefinedCrcy7 values PlanAmountInFreeDefinedCrcy7
PlanAmountInFreeDefinedCrcy8 values PlanAmountInFreeDefinedCrcy8
BaseUnit BaseUnit
AssetDepreciationArea
KEY CompanyCode values CompanyCode
KEY FiscalYear values FiscalYear
KEY MasterFixedAsset values MasterFixedAsset
KEY FixedAsset values FixedAsset
KEY AccountingDocument values AccountingDocument
KEY TransactionSubitem values TransactionSubitem
KEY Ledger values Ledger
KEY FiscalPeriod values FiscalPeriod
KEY SubLedgerAcctLineItemType values SubLedgerAcctLineItemType
KEY AssetAcctTransClassfctn values AssetAcctTransClassfctn
KEY DebitCreditCode values DebitCreditCode
LedgerFiscalYear LedgerFiscalYear
FiscalYearVariant FiscalYearVariant
FiscalYearPeriod FiscalYearPeriod
DepreciationFiscalPeriod DepreciationFiscalPeriod
AssetReportingFiscalPeriod FiscalPeriod
IsPlanningDocument IsPlanningDocument
AssetAccountingSortedKeyFigure I_AssetKeyFigureSetSpec AssetAccountingSortedKeyFigure
AssetAcctAnlytlTransClassfctn values AssetAcctAnlytlTransClassfctn
LedgerGroup values LedgerGroup
ChartOfAccounts values ChartOfAccounts
CountryChartOfAccounts values CountryChartOfAccounts
GLAccount values GLAccount
AlternativeGLAccount values AlternativeGLAccount
GroupMasterFixedAsset values GroupMasterFixedAsset
GroupFixedAsset values GroupFixedAsset
FinancialAccountType values FinancialAccountType
ChartOfDepreciation values ChartOfDepreciation
AccountingDocumentCreationDate values AccountingDocumentCreationDate
CreationTime values CreationTime
AccountingDocCreatedByUser values AccountingDocCreatedByUser
JointVentureCostRecoveryCode values JointVentureCostRecoveryCode
CostCenter values CostCenter
Plant values Plant
BusinessArea values BusinessArea
PersonnelNumber values PersonnelNumber
FinancialManagementArea values FinancialManagementArea
Fund values Fund
GrantID values GrantID
FunctionalArea values FunctionalArea
BudgetPeriod values BudgetPeriod
ProfitCenter values ProfitCenter
Segment values Segment
FundsCenter values FundsCenter
AssetTransactionType values AssetTransactionType
AssetDeactivationDate values AssetDeactivationDate
AssetAccountingKeyFigure I_AssetKeyFigureSpecification AssetAccountingKeyFigure
PlannedValueIsInclusive I_AssetKeyFigureSpecification PlannedValueIsInclusive
ReferenceDocumentItem values ReferenceDocumentItem
ReferenceDocumentType values ReferenceDocumentType
LogicalSystem values LogicalSystem
ReferenceDocument values ReferenceDocument
ReferenceDocumentContext values ReferenceDocumentContext
ReversalReferenceDocument values ReversalReferenceDocument
ReversalReferenceDocumentCntxt values ReversalReferenceDocumentCntxt
ReversalTransactionSubitem values ReversalTransactionSubitem
IsReversal values IsReversal
IsReversed values IsReversed
DocumentDate values DocumentDate
PostingDate values PostingDate
AssetValueDate values AssetValueDate
AccountingDocumentType values AccountingDocumentType
AssignmentReference values AssignmentReference
DocumentItemText values DocumentItemText
IsStatisticalDocument values IsStatisticalDocument
GLBusinessTransactionType values GLBusinessTransactionType
PartnerMasterFixedAsset values PartnerMasterFixedAsset
PartnerFixedAsset values PartnerFixedAsset
CompanyCodeCurrency values CompanyCodeCurrency
GlobalCurrency values GlobalCurrency
FreeDefinedCurrency1 values FreeDefinedCurrency1
FreeDefinedCurrency2 values FreeDefinedCurrency2
FreeDefinedCurrency3 values FreeDefinedCurrency3
FreeDefinedCurrency4 values FreeDefinedCurrency4
FreeDefinedCurrency5 values FreeDefinedCurrency5
FreeDefinedCurrency6 values FreeDefinedCurrency6
FreeDefinedCurrency7 values FreeDefinedCurrency7
FreeDefinedCurrency8 values FreeDefinedCurrency8
ActualAmountInCompanyCodeCrcy values ActualAmountInCompanyCodeCrcy
ActualAmountInGlobalCurrency values ActualAmountInGlobalCurrency
ActualAmountInFreeDfndCrcy1 values ActualAmountInFreeDfndCrcy1
ActualAmountInFreeDfndCrcy2 values ActualAmountInFreeDfndCrcy2
ActualAmountInFreeDfndCrcy3 values ActualAmountInFreeDfndCrcy3
ActualAmountInFreeDfndCrcy4 values ActualAmountInFreeDfndCrcy4
ActualAmountInFreeDfndCrcy5 values ActualAmountInFreeDfndCrcy5
ActualAmountInFreeDfndCrcy6 values ActualAmountInFreeDfndCrcy6
ActualAmountInFreeDfndCrcy7 values ActualAmountInFreeDfndCrcy7
ActualAmountInFreeDfndCrcy8 values ActualAmountInFreeDfndCrcy8
PlanAmountInCompanyCodeCrcy values PlanAmountInCompanyCodeCrcy
PlanAmountInGlobalCurrency values PlanAmountInGlobalCurrency
PlanAmountInFreeDefinedCrcy1 values PlanAmountInFreeDefinedCrcy1
PlanAmountInFreeDefinedCrcy2 values PlanAmountInFreeDefinedCrcy2
PlanAmountInFreeDefinedCrcy3 values PlanAmountInFreeDefinedCrcy3
PlanAmountInFreeDefinedCrcy4 values PlanAmountInFreeDefinedCrcy4
PlanAmountInFreeDefinedCrcy5 values PlanAmountInFreeDefinedCrcy5
PlanAmountInFreeDefinedCrcy6 values PlanAmountInFreeDefinedCrcy6
PlanAmountInFreeDefinedCrcy7 values PlanAmountInFreeDefinedCrcy7
PlanAmountInFreeDefinedCrcy8 values PlanAmountInFreeDefinedCrcy8
BaseUnit BaseUnit
Quantity Quantity 
@AbapCatalog: {sqlViewName: 'PFASSETVALUEFP', preserveKey: true, compiler.compareFilter: true}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true

/* The UNION ALL has the purpose to support the selection with proper performance                                          */
/* Key figures for planned planned values have to take the depreciation period rather than the posting period into account */
define view P_FixedAssetValueForToFsclPerd
  with parameters
    P_AssetAccountingKeyFigureSet : faa_key_figure_set,
    P_FiscalYear                  : fis_gjahr,
    P_ToFiscalPeriod              : fis_period_to

  as select from P_FixedAssetValueWthDetn(P_AssetAccountingKeyFigureSet: :P_AssetAccountingKeyFigureSet) as values
    inner join   I_AssetKeyFigureSetSpec                                                                 as AssetKeyFigureSetSpec on AssetKeyFigureSetSpec.AssetAccountingKeyFigureSet = :P_AssetAccountingKeyFigureSet
    inner join   I_AssetKeyFigureSpecification                                                           as AssetKeyFigureSpec    on  AssetKeyFigureSpec.AssetAccountingKeyFigure      = AssetKeyFigureSetSpec.AssetAccountingKeyFigure
                                                                                                                                  and AssetKeyFigureSpec.AssetAcctAnlytlTransClassfctn = values.AssetAcctAnlytlTransClassfctn
                                                                                                                                  and AssetKeyFigureSpec.SubLedgerAcctLineItemType     = values.SubLedgerAcctLineItemType
{
  key values.AssetDepreciationArea,
  key values.CompanyCode,
  key values.FiscalYear,
  key values.MasterFixedAsset,
  key values.FixedAsset,
  key values.AccountingDocument,
  key values.TransactionSubitem,
  key values.Ledger,
  key values.FiscalPeriod,
  key values.SubLedgerAcctLineItemType,
  key values.AssetAcctTransClassfctn,
  key values.DebitCreditCode,

      LedgerFiscalYear,
      FiscalYearVariant,
      FiscalYearPeriod,
      DepreciationFiscalPeriod,
      DepreciationFiscalPeriod                                                                                                                                                                                                                       as                                                                                                                                                                                                                 AssetReportingFiscalPeriod,
      IsPlanningDocument,

      AssetKeyFigureSetSpec.AssetAccountingSortedKeyFigure,
      values.AssetAcctAnlytlTransClassfctn,
      values.LedgerGroup,
      values.ChartOfAccounts,
      values.CountryChartOfAccounts,
      values.GLAccount,
      values.AlternativeGLAccount,
      values.GroupMasterFixedAsset,
      values.GroupFixedAsset,
      values.FinancialAccountType,
      values.ChartOfDepreciation,

      values.AccountingDocumentCreationDate,
      values.CreationTime,
      values.AccountingDocCreatedByUser,
      values.JointVentureCostRecoveryCode,
      values.CostCenter,
      values.Plant,
      values.BusinessArea,
      values.PersonnelNumber,
      values.FinancialManagementArea,
      values.Fund,
      values.GrantID,
      values.FunctionalArea,
      values.BudgetPeriod,
      values.ProfitCenter,
      values.Segment,
      values.FundsCenter,
      values.AssetTransactionType,
      values.AssetDeactivationDate,
      AssetKeyFigureSpec.AssetAccountingKeyFigure,
      AssetKeyFigureSpec.PlannedValueIsInclusive,

      values.ReferenceDocumentItem,
      values.ReferenceDocumentType,
      values.LogicalSystem,
      values.ReferenceDocument,
      values.ReferenceDocumentContext,
      values.ReversalReferenceDocument,
      values.ReversalReferenceDocumentCntxt,
      values.ReversalTransactionSubitem,
      values.IsReversal,
      values.IsReversed,
      values.DocumentDate,
      values.PostingDate,
      values.AssetValueDate,
      values.AccountingDocumentType,
      values.AssignmentReference,
      values.DocumentItemText,
      values.IsStatisticalDocument,
      values.GLBusinessTransactionType,
      values.PartnerMasterFixedAsset,
      values.PartnerFixedAsset,

      @Semantics.currencyCode:true
      values.CompanyCodeCurrency,
      @Semantics.currencyCode:true
      values.GlobalCurrency,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency1,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency2,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency3,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency4,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency5,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency6,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency7,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency8,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      values.ActualAmountInCompanyCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      values.ActualAmountInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      values.ActualAmountInFreeDfndCrcy1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      values.ActualAmountInFreeDfndCrcy2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      values.ActualAmountInFreeDfndCrcy3,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      values.ActualAmountInFreeDfndCrcy4,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      values.ActualAmountInFreeDfndCrcy5,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      values.ActualAmountInFreeDfndCrcy6,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      values.ActualAmountInFreeDfndCrcy7,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      values.ActualAmountInFreeDfndCrcy8,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      values.PlanAmountInCompanyCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      values.PlanAmountInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      values.PlanAmountInFreeDefinedCrcy1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      values.PlanAmountInFreeDefinedCrcy2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      values.PlanAmountInFreeDefinedCrcy3,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      values.PlanAmountInFreeDefinedCrcy4,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      values.PlanAmountInFreeDefinedCrcy5,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      values.PlanAmountInFreeDefinedCrcy6,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      values.PlanAmountInFreeDefinedCrcy7,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      values.PlanAmountInFreeDefinedCrcy8,

      @Semantics.unitOfMeasure:true
      BaseUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      Quantity
}
where
      IsPlanningDocument       =  ''
  and PlannedValueIsInclusive  <> '0'
  and FiscalYear               =  :P_FiscalYear
  and DepreciationFiscalPeriod <= :P_ToFiscalPeriod


union all select from P_FixedAssetValueWthDetn(P_AssetAccountingKeyFigureSet: :P_AssetAccountingKeyFigureSet) as values
  inner join          I_AssetKeyFigureSetSpec                                                                 as AssetKeyFigureSetSpec on AssetKeyFigureSetSpec.AssetAccountingKeyFigureSet = :P_AssetAccountingKeyFigureSet
  inner join          I_AssetKeyFigureSpecification                                                           as AssetKeyFigureSpec    on  AssetKeyFigureSpec.AssetAccountingKeyFigure      = AssetKeyFigureSetSpec.AssetAccountingKeyFigure
                                                                                                                                       and AssetKeyFigureSpec.AssetAcctAnlytlTransClassfctn = values.AssetAcctAnlytlTransClassfctn
                                                                                                                                       and AssetKeyFigureSpec.SubLedgerAcctLineItemType     = values.SubLedgerAcctLineItemType
{
  key values.AssetDepreciationArea,
  key values.CompanyCode,
  key values.FiscalYear,
  key values.MasterFixedAsset,
  key values.FixedAsset,
  key values.AccountingDocument,
  key values.TransactionSubitem,
  key values.Ledger,
  key values.FiscalPeriod,
  key values.SubLedgerAcctLineItemType,
  key values.AssetAcctTransClassfctn,
  key values.DebitCreditCode,

      LedgerFiscalYear,
      FiscalYearVariant,
      FiscalYearPeriod,
      DepreciationFiscalPeriod,
      FiscalPeriod                                                                                                                                                                                                                        as                                                                                                                                                                                                                 AssetReportingFiscalPeriod,
      IsPlanningDocument,

      AssetKeyFigureSetSpec.AssetAccountingSortedKeyFigure,
      values.AssetAcctAnlytlTransClassfctn,
      values.LedgerGroup,
      values.ChartOfAccounts,
      values.CountryChartOfAccounts,
      values.GLAccount,
      values.AlternativeGLAccount,
      values.GroupMasterFixedAsset,
      values.GroupFixedAsset,
      values.FinancialAccountType,
      values.ChartOfDepreciation,

      values.AccountingDocumentCreationDate,
      values.CreationTime,
      values.AccountingDocCreatedByUser,
      values.JointVentureCostRecoveryCode,
      values.CostCenter,
      values.Plant,
      values.BusinessArea,
      values.PersonnelNumber,
      values.FinancialManagementArea,
      values.Fund,
      values.GrantID,
      values.FunctionalArea,
      values.BudgetPeriod,
      values.ProfitCenter,
      values.Segment,
      values.FundsCenter,
      values.AssetTransactionType,
      values.AssetDeactivationDate,
      AssetKeyFigureSpec.AssetAccountingKeyFigure,
      AssetKeyFigureSpec.PlannedValueIsInclusive,

      values.ReferenceDocumentItem,
      values.ReferenceDocumentType,
      values.LogicalSystem,
      values.ReferenceDocument,
      values.ReferenceDocumentContext,
      values.ReversalReferenceDocument,
      values.ReversalReferenceDocumentCntxt,
      values.ReversalTransactionSubitem,
      values.IsReversal,
      values.IsReversed,
      values.DocumentDate,
      values.PostingDate,
      values.AssetValueDate,
      values.AccountingDocumentType,
      values.AssignmentReference,
      values.DocumentItemText,
      values.IsStatisticalDocument,
      values.GLBusinessTransactionType,
      values.PartnerMasterFixedAsset,
      values.PartnerFixedAsset,

      @Semantics.currencyCode:true
      values.CompanyCodeCurrency,
      @Semantics.currencyCode:true
      values.GlobalCurrency,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency1,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency2,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency3,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency4,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency5,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency6,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency7,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency8,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      values.ActualAmountInCompanyCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      values.ActualAmountInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      values.ActualAmountInFreeDfndCrcy1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      values.ActualAmountInFreeDfndCrcy2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      values.ActualAmountInFreeDfndCrcy3,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      values.ActualAmountInFreeDfndCrcy4,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      values.ActualAmountInFreeDfndCrcy5,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      values.ActualAmountInFreeDfndCrcy6,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      values.ActualAmountInFreeDfndCrcy7,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      values.ActualAmountInFreeDfndCrcy8,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      values.PlanAmountInCompanyCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      values.PlanAmountInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      values.PlanAmountInFreeDefinedCrcy1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      values.PlanAmountInFreeDefinedCrcy2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      values.PlanAmountInFreeDefinedCrcy3,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      values.PlanAmountInFreeDefinedCrcy4,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      values.PlanAmountInFreeDefinedCrcy5,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      values.PlanAmountInFreeDefinedCrcy6,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      values.PlanAmountInFreeDefinedCrcy7,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      values.PlanAmountInFreeDefinedCrcy8,

      @Semantics.unitOfMeasure:true
      BaseUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      Quantity
}
where
  (
        IsPlanningDocument                         =  ''
    and PlannedValueIsInclusive                    =  '0'
    and FiscalYear                                 =  :P_FiscalYear
    and FiscalPeriod                               <= :P_ToFiscalPeriod
  )
  or(
        IsPlanningDocument                         =  'X'
    and AssetKeyFigureSpec.PlannedValueIsInclusive <> '0'
    and FiscalYear                                 =  :P_FiscalYear
    and FiscalPeriod                               <= :P_ToFiscalPeriod
  )

Learn More