P_RS_TaxIndivDeprKeyFigure

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_TaxIndivDeprKeyFigure.
-- 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: PRSTDINDKF
-- Parameters: P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_TaxDepreciationSourceField : fiaars_tax_depr_srce_field, P_TaxDepreciationAreaLedger : fiaars_tax_area_ledger, P_BookDepreciationAreaLedger : fiaars_book_area_ledger, P_TaxGroupDepreciationEndDate : fiaars_grp_depr_end_date, P_TaxGroupIntngblDeprEndDate : fiaars_grp_depr_end_date_intng, P_ReportingStartDate : srf_rpg_period_start_date, P_ReportingEndDate : srf_rpg_period_end_date, P_ReportingYear : srf_reporting_year, P_ToFiscalPeriod : fis_period_to

CREATE VIEW P_RS_TaxIndivDeprKeyFigure AS
SELECT
  DeprCompleteFields.CompanyCode AS CompanyCode,
  DeprCompleteFields.MasterFixedAsset AS MasterFixedAsset,
  DeprCompleteFields.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,
  DeprCompleteFields.FixedAssetDescription AS FixedAssetDescription,
  DeprCompleteFields.AssetCapitalizationDate AS AssetCapitalizationDate,
  DeprCompleteFields.RS_AssetLastInvoiceDate AS RS_AssetLastInvoiceDate,
  DeprCompleteFields.AssetDeactivationDate AS AssetDeactivationDate,
  DeprCompleteFields.DepreciationTypeReferenceDate AS DepreciationTypeReferenceDate,
  DeprCompleteFields.RS_GroupDeprExclusionYear AS RS_GroupDeprExclusionYear,
  DeprCompleteFields.OriginalTaxDepreciationGroup AS OriginalTaxDepreciationGroup,
  DeprCompleteFields.AdjustedTaxDepreciationGroup AS AdjustedTaxDepreciationGroup,
  DeprCompleteFields.RS_TaxDepreciationRlvnceCode AS RS_TaxDepreciationRlvnceCode,
  DeprCompleteFields.AssetClass AS AssetClass,
  DeprCompleteFields.BookDepreciationStartDate AS BookDepreciationStartDate,
  DeprCompleteFields.BookDepreciationRate AS BookDepreciationRate,
  DeprCompleteFields.TaxDepreciationKey AS TaxDepreciationKey,
  TaxDeprTransType.RS_TaxDeprTransTypeClassfctn AS RS_TaxDeprTransTypeClassfctn,
  FxdAstBal.AssetAccountDetermination AS AssetAccountDetermination,
  FxdAstBal.DisplayCurrency AS DisplayCurrency
FROM P_RS_TaxIndivDeprFxdAstEval
INNER JOIN I_AssetBalanceCube ON /* join condition not captured in parsed metadata */
;