P_FIXEDASSETVALUEFORTOFSCLPERD
P_FixedAssetValueForToFsclPerd
P_FIXEDASSETVALUEFORTOFSCLPERD is a CDS View in S/4HANA. P_FixedAssetValueForToFsclPerd. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_FixedAssetValueForToFsclPerd | view | from | COMPOSITE | Fixed Asset Values |
@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
)