P_DeprTraceCalculationOrder

DDL: P_DEPRTRACECALCULATIONORDER SQL: PDTCALCORD Type: view CONSUMPTION Package: FINS_FAA_MD_VALUES
13 Fields 1 Data Sources

Depreciation Trace: Calculation Order

P_DeprTraceCalculationOrder is a Consumption CDS View that provides data about "Depreciation Trace: Calculation Order" in SAP S/4HANA. It reads from 1 data source (faat_dctr_calord) and exposes 13 fields with key fields comp_code, asset_no, asset_subno, depr_area, virt_area. Part of development package FINS_FAA_MD_VALUES.

Data Sources (1)

SourceAliasJoin Type
faat_dctr_calord faat_dctr_calord from

Annotations (11)

NameValueLevelField
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PDTCALCORD view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY comp_code comp_code Procuring Comp. Cde
KEY asset_no asset_no Asset
KEY asset_subno asset_subno Sub-number
KEY depr_area depr_area Deprec. Area
KEY virt_area virt_area Deprec. Area
KEY fisc_year fisc_year Year
KEY period_to period_to To Period
KEY amount_type amount_type Value Type
period_from period_from Period Start
base_area base_area Deprec. Area
sort_ind sort_ind Sorting
sequence_no sequence_no Sqnc No. in Ext File
is_dependant is_dependant Dependent Area

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_DeprTraceCalculationOrder.
-- 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: PDTCALCORD

CREATE VIEW P_DeprTraceCalculationOrder AS
SELECT
  comp_code,
  asset_no,
  asset_subno,
  depr_area,
  virt_area,
  fisc_year,
  period_to,
  amount_type,
  period_from,
  base_area,
  sort_ind,
  sequence_no,
  is_dependant
FROM faat_dctr_calord
;

Learn More