P_RS_TaxIndivDeprFxdAstEval

DDL: P_RS_TAXINDIVDEPRFXDASTEVAL SQL: PRSTDINDFAEVAL Type: view COMPOSITE Package: GLO_FIN_IS_AA_RS
20 Fields 3 Data Sources

TS Tax indiv. depr. - FA evaluation

P_RS_TaxIndivDeprFxdAstEval is a Composite CDS View that provides data about "TS Tax indiv. depr. - FA evaluation" in SAP S/4HANA. It reads from 3 data sources (P_RS_TaxDeprBookAreaFields, P_RS_TaxDeprFxdAstEvaluation, P_RS_TaxDeprTaxAreaFields) and exposes 20 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset. Part of development package GLO_FIN_IS_AA_RS.

Data Sources (3)

SourceAliasJoin Type
P_RS_TaxDeprBookAreaFields P_RS_TaxDeprBookAreaFields inner
P_RS_TaxDeprFxdAstEvaluation P_RS_TaxDeprFxdAstEvaluation from
P_RS_TaxDeprTaxAreaFields P_RS_TaxDeprTaxAreaFields inner

Parameters (8)

NameTypeDefault
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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PRSTDINDFAEVAL 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 MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode TaxDeprFxdAstEval CompanyCode Receiver Company Code
KEY MasterFixedAsset TaxDeprFxdAstEval MasterFixedAsset Fixed Asset
KEY FixedAsset TaxDeprFxdAstEval FixedAsset Sub-number
FixedAssetDescription TaxDeprFxdAstEval FixedAssetDescription Description
AssetClass TaxDeprFxdAstEval AssetClass Asset Class
AssetCapitalizationDate TaxDeprFxdAstEval AssetCapitalizationDate Asset Capitalization
AssetDeactivationDate TaxDeprFxdAstEval AssetDeactivationDate
RS_AssetLastInvoiceDate TaxDeprFxdAstEval RS_AssetLastInvoiceDate
FirstAcquisitionFiscalYear TaxDeprFxdAstEval FirstAcquisitionFiscalYear Acquisition Yr
RS_GroupDeprExclusionYear TaxDeprFxdAstEval RS_GroupDeprExclusionYear
OriginalTaxDepreciationGroup TaxDeprFxdAstEval OriginalTaxDepreciationGroup
AdjustedTaxDepreciationGroup TaxDeprFxdAstEval AdjustedTaxDepreciationGroup
DepreciationTypeReferenceDate TaxDeprFxdAstEval DepreciationTypeReferenceDate
RS_AssetIsExcludedInRptgYear TaxDeprFxdAstEval RS_AssetIsExcludedInRptgYear
RS_TaxDepreciationRlvnceCode TaxDeprFxdAstEval RS_TaxDepreciationRlvnceCode
TaxDepreciationKey TaxAssetField TaxDepreciationKey
BookDepreciationStartDate BookAssetField BookDepreciationStartDate
BookPlannedUsefulLifeInPeriods BookAssetField BookPlannedUsefulLifeInPeriods
BookPlannedUsefulLifeInYears BookAssetField BookPlannedUsefulLifeInYears Planned Use Life Yr.
BookDepreciationRate BookAssetField BookDepreciationRate

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_TaxIndivDeprFxdAstEval.
-- 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: PRSTDINDFAEVAL
-- Parameters: 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

CREATE VIEW P_RS_TaxIndivDeprFxdAstEval AS
SELECT
  TaxDeprFxdAstEval.CompanyCode AS CompanyCode,
  TaxDeprFxdAstEval.MasterFixedAsset AS MasterFixedAsset,
  TaxDeprFxdAstEval.FixedAsset AS FixedAsset,
  TaxDeprFxdAstEval.FixedAssetDescription AS FixedAssetDescription,
  TaxDeprFxdAstEval.AssetClass AS AssetClass,
  TaxDeprFxdAstEval.AssetCapitalizationDate AS AssetCapitalizationDate,
  TaxDeprFxdAstEval.AssetDeactivationDate AS AssetDeactivationDate,
  TaxDeprFxdAstEval.RS_AssetLastInvoiceDate AS RS_AssetLastInvoiceDate,
  TaxDeprFxdAstEval.FirstAcquisitionFiscalYear AS FirstAcquisitionFiscalYear,
  TaxDeprFxdAstEval.RS_GroupDeprExclusionYear AS RS_GroupDeprExclusionYear,
  TaxDeprFxdAstEval.OriginalTaxDepreciationGroup AS OriginalTaxDepreciationGroup,
  TaxDeprFxdAstEval.AdjustedTaxDepreciationGroup AS AdjustedTaxDepreciationGroup,
  TaxDeprFxdAstEval.DepreciationTypeReferenceDate AS DepreciationTypeReferenceDate,
  TaxDeprFxdAstEval.RS_AssetIsExcludedInRptgYear AS RS_AssetIsExcludedInRptgYear,
  TaxDeprFxdAstEval.RS_TaxDepreciationRlvnceCode AS RS_TaxDepreciationRlvnceCode,
  TaxAssetField.TaxDepreciationKey AS TaxDepreciationKey,
  BookAssetField.BookDepreciationStartDate AS BookDepreciationStartDate,
  BookAssetField.BookPlannedUsefulLifeInPeriods AS BookPlannedUsefulLifeInPeriods,
  BookAssetField.BookPlannedUsefulLifeInYears AS BookPlannedUsefulLifeInYears,
  BookAssetField.BookDepreciationRate AS BookDepreciationRate
FROM P_RS_TaxDeprFxdAstEvaluation
INNER JOIN P_RS_TaxDeprBookAreaFields ON /* join condition not captured in parsed metadata */
INNER JOIN P_RS_TaxDeprTaxAreaFields ON /* join condition not captured in parsed metadata */
;

Learn More