I_FixedAssetDeprAreaTP

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_FixedAssetDeprAreaTP.
-- 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: IFASSETDEPRTP

CREATE VIEW I_FixedAssetDeprAreaTP AS
SELECT
  I_FixedAssetDeprArea.CompanyCode AS CompanyCode,
  I_FixedAssetDeprArea.MasterFixedAsset AS MasterFixedAsset,
  I_FixedAssetDeprArea.FixedAsset AS FixedAsset,
  I_FixedAssetDeprArea.AssetRealDepreciationArea AS AssetDepreciationArea,
  I_FixedAssetDeprArea.ValidityEndDate AS ValidityEndDate,
  I_DeprAreaByCoCodeWithCrcyRole.Ledger AS Ledger,
  _DepreciationArea._Text[1: Language = $session.system_language ].AssetDepreciationAreaName AS AssetDepreciationAreaName,
  I_FixedAssetDeprArea.ValidityStartDate AS ValidityStartDate,
  I_FixedAssetDeprArea.PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  I_FixedAssetDeprArea.PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  I_FixedAssetDeprArea.DepreciationStartDate AS DepreciationStartDate,
  I_FixedAssetDeprArea.SpecialDeprStartDate AS SpecialDeprStartDate,
  I_FixedAssetDeprArea.InterestCalcStartDate AS InterestCalcStartDate,
  I_FixedAssetDeprArea.ReplacementValueIndexSers AS ReplacementValueIndexSers,
  I_FixedAssetDeprArea.RplcmtValueAgingIndexSers AS RplcmtValueAgingIndexSers,
  I_FixedAssetDeprArea.VariableDeprPercent AS VariableDeprPercent,
  I_FixedAssetDeprArea.DepreciationAreaCurrency AS DepreciationAreaCurrency,
  I_FixedAssetDeprArea.ScrapAmountInCoCodeCrcy AS ScrapAmountInCoCodeCrcy,
  I_FixedAssetDeprArea.OriglAstUsefulLifeInYears AS OriglAstUsefulLifeInYears,
  I_FixedAssetDeprArea.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  I_FixedAssetDeprArea.AssetOpgReadinessDate AS AssetOpgReadinessDate,
  I_FixedAssetDeprArea.NegativeAmountIsAllowed AS NegativeAmountIsAllowed,
  I_FixedAssetDeprArea.DepreciationAreaIsDactvtd AS DepreciationAreaIsDactvtd,
  I_FixedAssetDeprArea.AcqnProdnCostScrapPercent AS AcqnProdnCostScrapPercent,
  I_FixedAssetDeprArea.AssetRevaluation AS AssetRevaluation,
  I_FixedAssetDeprArea.InvestmentSupportMeasure AS InvestmentSupportMeasure,
  I_FixedAssetDeprArea.DeprKeyChangeoverYear AS DeprKeyChangeoverYear,
  I_FixedAssetDeprArea.DeprKeyChangeoverPeriod AS DeprKeyChangeoverPeriod,
  I_FixedAssetDeprArea.VintageMonth AS VintageMonth,
  I_FixedAssetDeprArea.VintageYear AS VintageYear,
  I_FixedAssetDeprArea.OriglAstUsefulLifeInPerds AS OriglAstUsefulLifeInPerds,
  I_FixedAssetDeprArea.GroupFixedAsset AS GroupFixedAsset,
  I_DeprAreaByCoCodeWithCrcyRole.ChartOfDepreciation AS ChartOfDepreciation,
  I_DeprAreaByCoCodeWithCrcyRole.DepreciationAreaCurrencyRole AS DepreciationAreaCurrencyRole,
  I_DeprAreaByCoCodeWithCrcyRole.AccountingPrinciple AS AccountingPrinciple,
  I_DeprAreaByCoCodeWithCrcyRole.ValueReferenceDepreciationArea AS ValueReferenceDepreciationArea,
  I_DeprAreaByCoCodeWithCrcyRole.IsValueReferenceDeprArea AS IsValueReferenceDeprArea,
  I_DeprAreaByCoCodeWithCrcyRole.IsRealDepreciationArea AS IsRealDepreciationArea,
  I_DeprAreaByCoCodeWithCrcyRole.AssetAcctgLastClosedFiscalYear AS AssetAcctgLastClosedFiscalYear,
  I_FixedAssetDeprArea.DepreciationKey AS DepreciationKey
FROM I_FixedAssetDeprArea
INNER JOIN I_DeprAreaByCoCodeWithCrcyRole ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FixedAssetTP AS _FixedAsset ON MasterFixedAsset = _FixedAsset.MasterFixedAsset AND CompanyCode = _FixedAsset.CompanyCode AND FixedAsset = _FixedAsset.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_AssetDepreciationArea AS _DepreciationArea ON ChartOfDepreciation = _DepreciationArea.ChartOfDepreciation AND AssetDepreciationArea = _DepreciationArea.AssetDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DepreciationAreaCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ChartOfDepreciation AS _ChartOfDepreciation ON ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation  -- association [0..1]
LEFT OUTER JOIN I_ReplacementValueIndexSers AS _ReplacementValueIndexSers ON ReplacementValueIndexSers = _ReplacementValueIndexSers.ReplacementValueIndexSers  -- association [0..1]
LEFT OUTER JOIN I_ReplacementValueIndexSers AS _RplcmtValueAgingIndexSers ON RplcmtValueAgingIndexSers = _RplcmtValueAgingIndexSers.ReplacementValueIndexSers  -- association [0..1]
LEFT OUTER JOIN I_InvestmentSupportMeasure AS _InvestmentSupportMeasure ON ChartOfDepreciation = _InvestmentSupportMeasure.ChartOfDepreciation AND InvestmentSupportMeasure = _InvestmentSupportMeasure.InvestmentSupportMeasure  -- association [0..1]
LEFT OUTER JOIN I_DepreciationKey AS _DepreciationKey ON ChartOfDepreciation = _DepreciationKey.ChartOfDepreciation AND DepreciationKey = _DepreciationKey.DepreciationKey  -- association [0..1]
LEFT OUTER JOIN I_AssetDepreciationArea AS _ValueReferenceDeprArea ON ValueReferenceDepreciationArea = _ValueReferenceDeprArea.AssetDepreciationArea AND ChartOfDepreciation = _ValueReferenceDeprArea.ChartOfDepreciation  -- association [0..1]
-- UNION ALL with additional select branch(es): I_FixedAssetTP
;