I_FxdAstDeprAreaByFsclPerdEnd

DDL: I_FXDASTDEPRAREABYFSCLPERDEND Type: view COMPOSITE Package: FINS_FIS_AA_MD
29 Fields 2 Data Sources 4 Associations

Depreciation Area valid at fiscal period end date

I_FxdAstDeprAreaByFsclPerdEnd is a Composite CDS View that provides data about "Depreciation Area valid at fiscal period end date" in SAP S/4HANA. It reads from 2 data sources (I_AssetValuationForLedger, I_FiscalYearPeriodForLedger) and exposes 29 fields with key fields CompanyCode, Ledger, AssetDepreciationArea, MasterFixedAsset, FixedAsset. It has 4 associations to related views. Part of development package FINS_FIS_AA_MD.

Data Sources (2)

SourceAliasJoin Type
I_AssetValuationForLedger AssetValuation from
I_FiscalYearPeriodForLedger I_FiscalYearPeriodForLedger inner

Parameters (2)

NameTypeDefault
P_FiscalYear fis_gjahr
P_FiscalPeriod fis_period_to

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_MasterFixedAsset _MasterFixedAsset $projection.CompanyCode = _MasterFixedAsset.CompanyCode and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
[1..1] I_FixedAsset _FixedAsset $projection.CompanyCode = _FixedAsset.CompanyCode and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset and $projection.FixedAsset = _FixedAsset.FixedAsset
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_Ledger _Ledger $projection.Ledger = _Ledger.Ledger

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFASSETDPRAREAFP view
AbapCatalog.preserveKey true view
EndUserText.label Depreciation Area valid at fiscal period end date view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_AssetValuationForLedger CompanyCode Receiver Company Code
KEY Ledger I_AssetValuationForLedger Ledger Ledger
KEY AssetDepreciationArea I_AssetValuationForLedger AssetRealDepreciationArea
KEY MasterFixedAsset I_AssetValuationForLedger MasterFixedAsset Fixed Asset
KEY FixedAsset I_AssetValuationForLedger FixedAsset Sub-number
FiscalYear I_FiscalYearPeriodForLedger FiscalYear G/L Fiscal Year
FiscalPeriod I_FiscalYearPeriodForLedger FiscalPeriod Tax period
ValidityEndDate I_AssetValuationForLedger ValidityEndDate ValidTo
ValidityStartDate I_AssetValuationForLedger ValidityStartDate Validity Start Date
FiscalPeriodEndDate I_FiscalYearPeriodForLedger FiscalPeriodEndDate
DepreciationStartDate DepreciationStartDate
SpecialDeprStartDate SpecialDeprStartDate
ReplacementValueIndexSers ReplacementValueIndexSers
RplcmtValueAgingIndexSers RplcmtValueAgingIndexSers
OriglAstUsefulLifeInYears OriglAstUsefulLifeInYears
InvestmentSupportMeasure InvestmentSupportMeasure
DeprKeyChangeoverYear DeprKeyChangeoverYear
DeprKeyChangeoverPeriod DeprKeyChangeoverPeriod
VintageMonth VintageMonth
VintageYear VintageYear Vintage Year
OriglAstUsefulLifeInPerds OriglAstUsefulLifeInPerds
DepreciationKey DepreciationKey
PlannedUsefulLifeInYears PlannedUsefulLifeInYears Planned Use Life Yr.
PlannedUsefulLifeInPeriods PlannedUsefulLifeInPeriods
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_CompanyCode _CompanyCode
_Ledger _Ledger
_ReplacementValueIndexSers _ReplacementValueIndexSers

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 I_FxdAstDeprAreaByFsclPerdEnd.
-- 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.
-- Parameters: P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_period_to

CREATE VIEW I_FxdAstDeprAreaByFsclPerdEnd AS
SELECT
  AssetValuation.CompanyCode AS CompanyCode,
  AssetValuation.Ledger AS Ledger,
  AssetValuation.AssetRealDepreciationArea AS AssetDepreciationArea,
  AssetValuation.MasterFixedAsset AS MasterFixedAsset,
  AssetValuation.FixedAsset AS FixedAsset,
  I_FiscalYearPeriodForLedger.FiscalYear AS FiscalYear,
  I_FiscalYearPeriodForLedger.FiscalPeriod AS FiscalPeriod,
  AssetValuation.ValidityEndDate AS ValidityEndDate,
  AssetValuation.ValidityStartDate AS ValidityStartDate,
  I_FiscalYearPeriodForLedger.FiscalPeriodEndDate AS FiscalPeriodEndDate,
  DepreciationStartDate,
  SpecialDeprStartDate,
  ReplacementValueIndexSers,
  RplcmtValueAgingIndexSers,
  OriglAstUsefulLifeInYears,
  InvestmentSupportMeasure,
  DeprKeyChangeoverYear,
  DeprKeyChangeoverPeriod,
  VintageMonth,
  VintageYear,
  OriglAstUsefulLifeInPerds,
  DepreciationKey,
  PlannedUsefulLifeInYears,
  PlannedUsefulLifeInPeriods
FROM I_AssetValuationForLedger AS AssetValuation
INNER JOIN I_FiscalYearPeriodForLedger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
;

Learn More