P_RS_TaxDeprFxdAstFieldsExtd

DDL: P_RS_TAXDEPRFXDASTFIELDSEXTD SQL: PRSTDEPRFAFLDEX Type: view COMPOSITE

P_RS_TaxDeprFxdAstFieldsExtd is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_RS_TaxDeprFixedAssetFields) and exposes 11 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset.

Data Sources (1)

SourceAliasJoin Type
P_RS_TaxDeprFixedAssetFields P_RS_TaxDeprFixedAssetFields from

Parameters (5)

NameTypeDefault
P_TaxDepreciationSourceField fiaars_tax_depr_srce_field
P_TaxGroupDepreciationEndDate fiaars_grp_depr_end_date
P_TaxGroupIntngblDeprEndDate fiaars_grp_depr_end_date_intng
P_ReportingEndDate srf_rpg_period_end_date
P_TaxDepreciationAreaLedger fiaars_tax_area_ledger

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PRSTDEPRFAFLDEX 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 (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
FixedAssetDescription FixedAssetDescription Description
AssetClass AssetClass Asset Class
AssetCapitalizationDate AssetCapitalizationDate Asset Capitalization
AssetDeactivationDate AssetDeactivationDate
RS_AssetLastInvoiceDate RS_AssetLastInvoiceDate
FirstAcquisitionFiscalYear FirstAcquisitionFiscalYear Acquisition Yr
RS_GroupDeprExclusionYear RS_GroupDeprExclusionYear
OriginalTaxDepreciationGroup OriginalTaxDepreciationGroup

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_TaxDeprFxdAstFieldsExtd.
-- 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: PRSTDEPRFAFLDEX
-- Parameters: P_TaxDepreciationSourceField : fiaars_tax_depr_srce_field, P_TaxGroupDepreciationEndDate : fiaars_grp_depr_end_date, P_TaxGroupIntngblDeprEndDate : fiaars_grp_depr_end_date_intng, P_ReportingEndDate : srf_rpg_period_end_date, P_TaxDepreciationAreaLedger : fiaars_tax_area_ledger

CREATE VIEW P_RS_TaxDeprFxdAstFieldsExtd AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  FixedAssetDescription,
  AssetClass,
  AssetCapitalizationDate,
  AssetDeactivationDate,
  RS_AssetLastInvoiceDate,
  FirstAcquisitionFiscalYear,
  RS_GroupDeprExclusionYear,
  OriginalTaxDepreciationGroup
FROM P_RS_TaxDeprFixedAssetFields
;