P_RS_TaxGroupDepreciation

DDL: P_RS_TAXGROUPDEPRECIATION SQL: PRSTDEPGRP Type: view COMPOSITE Package: GLO_FIN_IS_AA_RS
27 Fields 2 Data Sources

RS Tax Group Depreciation

P_RS_TaxGroupDepreciation is a Composite CDS View that provides data about "RS Tax Group Depreciation" in SAP S/4HANA. It reads from 2 data sources (I_AssetBalanceCube, P_RS_TaxDeprFxdAstEvaluation) and exposes 27 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, AssetDepreciationArea, FiscalYear. Part of development package GLO_FIN_IS_AA_RS.

Data Sources (2)

SourceAliasJoin Type
I_AssetBalanceCube I_AssetBalanceCube inner
P_RS_TaxDeprFxdAstEvaluation P_RS_TaxDeprFxdAstEvaluation from

Parameters (10)

NameTypeDefault
P_AssetAccountingKeyFigureSet faa_key_figure_set
P_TaxDepreciationSourceField fiaars_tax_depr_srce_field
P_AssetTaxDepreciationArea fis_afabe_d
P_TaxDepreciationAreaLedger fiaars_tax_area_ledger
P_TaxGroupDepreciationEndDate fiaars_grp_depr_end_date
P_TaxGroupIntngblDeprEndDate fiaars_grp_depr_end_date_intng
P_ReportingStartDate date
P_ReportingEndDate date
P_ReportingYear gjahr
P_ToFiscalPeriod fis_period_to

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PRSTDEPGRP view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.dataClass TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode TaxDeprFxdAstEval CompanyCode Receiver Company Code
KEY MasterFixedAsset TaxDeprFxdAstEval MasterFixedAsset Fixed Asset
KEY FixedAsset TaxDeprFxdAstEval FixedAsset Sub-number
KEY AssetDepreciationArea FxdAstBal AssetDepreciationArea Deprec. Area
KEY FiscalYear FxdAstBal FiscalYear G/L Fiscal Year
KEY FiscalPeriod FxdAstBal FiscalPeriod Tax period
KEY SubLedgerAcctLineItemType FxdAstBal SubLedgerAcctLineItemType SLALineItemType
KEY AssetAcctTransClassfctn FxdAstBal AssetAcctTransClassfctn Trans.Type Cat.
KEY AssetAccountingKeyFigure FxdAstBal AssetAccountingKeyFigure
KEY AccountingDocument FxdAstBal AccountingDocument Journal Entry
KEY LedgerGLLineItem FxdAstBal LedgerGLLineItem Journal Entry Item
KEY TransactionSubitem FxdAstBal TransactionSubitem Sub Transaction
FixedAssetDescription TaxDeprFxdAstEval FixedAssetDescription Description
AssetClass TaxDeprFxdAstEval AssetClass Asset Class
AssetCapitalizationDate TaxDeprFxdAstEval AssetCapitalizationDate Asset Capitalization
RS_AssetLastInvoiceDate TaxDeprFxdAstEval RS_AssetLastInvoiceDate
AssetDeactivationDate TaxDeprFxdAstEval AssetDeactivationDate
DepreciationTypeReferenceDate TaxDeprFxdAstEval DepreciationTypeReferenceDate
RS_GroupDeprExclusionYear TaxDeprFxdAstEval RS_GroupDeprExclusionYear
OriginalTaxDepreciationGroup TaxDeprFxdAstEval OriginalTaxDepreciationGroup
RS_TaxDepreciationRlvnceCode TaxDeprFxdAstEval RS_TaxDepreciationRlvnceCode
RS_AssetIsExcludedInRptgYear TaxDeprFxdAstEval RS_AssetIsExcludedInRptgYear
AmountInDisplayCurrency FxdAstBal AmountInDisplayCurrency
DisplayCurrency FxdAstBal DisplayCurrency Display Currency
AssetTransactionType FxdAstBal AssetTransactionType Trans.Type
AssetValueDate FxdAstBal AssetValueDate Reference date
RS_TaxDeprTransTypeClassfctn TaxDeprTransType RS_TaxDeprTransTypeClassfctn

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_RS_TaxGroupDepreciation.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PRSTDEPGRP
-- Parameters: P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_TaxDepreciationSourceField : fiaars_tax_depr_srce_field, P_AssetTaxDepreciationArea : fis_afabe_d, P_TaxDepreciationAreaLedger : fiaars_tax_area_ledger, P_TaxGroupDepreciationEndDate : fiaars_grp_depr_end_date, P_TaxGroupIntngblDeprEndDate : fiaars_grp_depr_end_date_intng, P_ReportingStartDate : date, P_ReportingEndDate : date, P_ReportingYear : gjahr, P_ToFiscalPeriod : fis_period_to

CREATE VIEW P_RS_TaxGroupDepreciation AS
SELECT
  TaxDeprFxdAstEval.CompanyCode AS CompanyCode,
  TaxDeprFxdAstEval.MasterFixedAsset AS MasterFixedAsset,
  TaxDeprFxdAstEval.FixedAsset AS FixedAsset,
  FxdAstBal.AssetDepreciationArea AS AssetDepreciationArea,
  FxdAstBal.FiscalYear AS FiscalYear,
  FxdAstBal.FiscalPeriod AS FiscalPeriod,
  FxdAstBal.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  FxdAstBal.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  FxdAstBal.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  FxdAstBal.AccountingDocument AS AccountingDocument,
  FxdAstBal.LedgerGLLineItem AS LedgerGLLineItem,
  FxdAstBal.TransactionSubitem AS TransactionSubitem,
  TaxDeprFxdAstEval.FixedAssetDescription AS FixedAssetDescription,
  TaxDeprFxdAstEval.AssetClass AS AssetClass,
  TaxDeprFxdAstEval.AssetCapitalizationDate AS AssetCapitalizationDate,
  TaxDeprFxdAstEval.RS_AssetLastInvoiceDate AS RS_AssetLastInvoiceDate,
  TaxDeprFxdAstEval.AssetDeactivationDate AS AssetDeactivationDate,
  TaxDeprFxdAstEval.DepreciationTypeReferenceDate AS DepreciationTypeReferenceDate,
  TaxDeprFxdAstEval.RS_GroupDeprExclusionYear AS RS_GroupDeprExclusionYear,
  TaxDeprFxdAstEval.OriginalTaxDepreciationGroup AS OriginalTaxDepreciationGroup,
  TaxDeprFxdAstEval.RS_TaxDepreciationRlvnceCode AS RS_TaxDepreciationRlvnceCode,
  TaxDeprFxdAstEval.RS_AssetIsExcludedInRptgYear AS RS_AssetIsExcludedInRptgYear,
  FxdAstBal.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  FxdAstBal.DisplayCurrency AS DisplayCurrency,
  FxdAstBal.AssetTransactionType AS AssetTransactionType,
  FxdAstBal.AssetValueDate AS AssetValueDate,
  TaxDeprTransType.RS_TaxDeprTransTypeClassfctn AS RS_TaxDeprTransTypeClassfctn
FROM P_RS_TaxDeprFxdAstEvaluation
INNER JOIN I_AssetBalanceCube ON /* join condition not captured in parsed metadata */
;

Learn More