C_AssetValuationTP

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 C_AssetValuationTP.
-- 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: CASSETVALNTP

CREATE VIEW C_AssetValuationTP AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  AssetDepreciationArea,
  Ledger,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Ledger._Text[1:Language = $session.system_language].LedgerName AS LedgerName,
  _DepreciationArea._Text[1:Language=$session.system_language].AssetDepreciationAreaName AS AssetDepreciationAreaName,
  cast( '' as anlkl ) AS AssetClass,
  cast( '' as faa_assetcla ) AS AssetClassName,
  AssetLeadingDepreciationArea,
  ChartOfDepreciation,
  DepreciationKey,
  cast('' as fis_afatxt) AS DepreciationKeyName,
  PlannedUsefulLifeInYears,
  PlannedUsefulLifeInPeriods,
  ExpiredUsefulLifeInYrs,
  ExpiredUsefulLifeInPerds,
  SpclExpiredUsefulLifeInYrs,
  SpclExpiredUsefulLifeInPerds,
  NegativeAmountIsAllowed,
  DepreciationStartDate,
  SpecialDeprStartDate,
  InterestCalcStartDate,
  AssetOpgReadinessDate,
  ReplacementValueIndexSers,
  RplcmtValueAgingIndexSers,
  DeprKeyChangeoverYear,
  DeprKeyChangeoverPeriod,
  LowValueAssetAmountCheckType,
  LastRetirementValueDate,
  AssetCurrentFiscalYear,
  AssetNumberOfPeriods,
  DepreciationAreaType,
  cast( '0' as timestamp ) AS LastChangeDateTime,
  _CurrencyRoles.CompanyCodeCurrencyRole AS CompanyCodeCurrencyRole,
  _CurrencyRoles.GlobalCurrencyRole AS GlobalCurrencyRole,
  _CurrencyRoles.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
  _CurrencyRoles.FreeDefinedCurrency2Role AS FreeDefinedCurrency2Role,
  _CurrencyRoles.FreeDefinedCurrency3Role AS FreeDefinedCurrency3Role,
  _CurrencyRoles.FreeDefinedCurrency4Role AS FreeDefinedCurrency4Role,
  _CurrencyRoles.FreeDefinedCurrency5Role AS FreeDefinedCurrency5Role,
  _CurrencyRoles.FreeDefinedCurrency6Role AS FreeDefinedCurrency6Role,
  _CurrencyRoles.FreeDefinedCurrency7Role AS FreeDefinedCurrency7Role,
  _CurrencyRoles.FreeDefinedCurrency8Role AS FreeDefinedCurrency8Role,
  _CurrencyRoles.FunctionalCurrencyRole AS FunctionalCurrencyRole
FROM I_AssetValuationTP AS AssetValuationTP
LEFT OUTER JOIN C_AssetTP AS _AssetTP ON CompanyCode = _AssetTP.CompanyCode AND MasterFixedAsset = _AssetTP.MasterFixedAsset AND FixedAsset = _AssetTP.FixedAsset  -- association [1..1]
LEFT OUTER JOIN C_AssetTimeBasedValuationTP AS _AssetTimeBasedValuationTP ON CompanyCode = _AssetTimeBasedValuationTP.CompanyCode AND MasterFixedAsset = _AssetTimeBasedValuationTP.MasterFixedAsset AND FixedAsset = _AssetTimeBasedValuationTP.FixedAsset AND Ledger = _AssetTimeBasedValuationTP.Ledger AND AssetDepreciationArea = _AssetTimeBasedValuationTP.AssetDepreciationArea  -- association [1..*]
LEFT OUTER JOIN C_AssetYearOpeningValnAttribTP AS _AssetYearOpeningValnAttribTP ON CompanyCode = _AssetYearOpeningValnAttribTP.CompanyCode AND MasterFixedAsset = _AssetYearOpeningValnAttribTP.MasterFixedAsset AND FixedAsset = _AssetYearOpeningValnAttribTP.FixedAsset AND Ledger = _AssetYearOpeningValnAttribTP.Ledger AND AssetDepreciationArea = _AssetYearOpeningValnAttribTP.AssetDepreciationArea  -- association [1..*]
LEFT OUTER JOIN C_GlobAssetTimeBasedValnTP AS _GlobAssetTimeBasedValnTP ON CompanyCode = _GlobAssetTimeBasedValnTP.CompanyCode AND MasterFixedAsset = _GlobAssetTimeBasedValnTP.MasterFixedAsset AND FixedAsset = _GlobAssetTimeBasedValnTP.FixedAsset AND Ledger = _GlobAssetTimeBasedValnTP.Ledger AND AssetDepreciationArea = _GlobAssetTimeBasedValnTP.AssetDepreciationArea  -- association [0..*]
LEFT OUTER JOIN I_DepreciationKey AS _DepreciationKey ON DepreciationKey = _DepreciationKey.DepreciationKey AND ChartOfDepreciation = _DepreciationKey.ChartOfDepreciation  -- association [0..1]
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRoles AS _CurrencyRoles ON CompanyCode = _CurrencyRoles.CompanyCode AND Ledger = _CurrencyRoles.Ledger  -- association [0..1]
;