C_AssetTimeBasedValuationTP

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_AssetTimeBasedValuationTP.
-- 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: CASTTMBSDVALNTP

CREATE VIEW C_AssetTimeBasedValuationTP AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  ValidityEndDate,
  Ledger,
  AssetDepreciationArea,
  ValidityEndDateForEdit,
  ChartOfDepreciation,
  ValidityStartDate,
  DepreciationKey,
  cast('' as fis_afatxt) AS DepreciationKeyName,
  PlannedUsefulLifeInYears,
  PlannedUsefulLifeInPeriods,
  VariableDeprPercent,
  AcqnProdnCostScrapPercent,
  DeprCalcBaseValuePercent,
  ShiftOperationFactor,
  IsShutDown,
  FixedAssetUsageObject,
  _FixedAssetUsageObject.FixedAssetUsageObjectDesc AS FixedAssetUsageObjectDesc,
  AssetRevaluationIndex,
  _FixedAssetRevaluationIndex.AssetRevaluationIndexName AS AssetRevaluationIndexName,
  ScrapAmountInCoCodeCrcy,
  ScrapAmountInGlobCrcy,
  ScrapAmountInFreeDefinedCrcy1,
  ScrapAmountInFreeDefinedCrcy2,
  ScrapAmountInFreeDefinedCrcy3,
  ScrapAmountInFreeDefinedCrcy4,
  ScrapAmountInFreeDefinedCrcy5,
  ScrapAmountInFreeDefinedCrcy6,
  ScrapAmountInFreeDefinedCrcy7,
  ScrapAmountInFreeDefinedCrcy8,
  cast( '' as waers ) AS CompanyCodeCurrency,
  cast( '' as fac_crcyrole_txt ) AS CompanyCodeCurrencyRoleName,
  cast( '' as waers ) AS GlobalCurrency,
  cast( '' as fac_crcyrole_txt ) AS GlobalCurrencyRoleName,
  cast( '' as waers ) AS FreeDefinedCurrency1,
  cast( '' as fac_crcyrole_txt ) AS FreeDefinedCurrency1RoleName,
  cast( '' as waers ) AS FreeDefinedCurrency2,
  cast( '' as fac_crcyrole_txt ) AS FreeDefinedCurrency2RoleName,
  cast( '' as waers ) AS FreeDefinedCurrency3,
  cast( '' as fac_crcyrole_txt ) AS FreeDefinedCurrency3RoleName,
  cast( '' as waers ) AS FreeDefinedCurrency4,
  cast( '' as fac_crcyrole_txt ) AS FreeDefinedCurrency4RoleName,
  cast( '' as waers ) AS FreeDefinedCurrency5,
  cast( '' as fac_crcyrole_txt ) AS FreeDefinedCurrency5RoleName,
  cast( '' as waers ) AS FreeDefinedCurrency6,
  cast( '' as fac_crcyrole_txt ) AS FreeDefinedCurrency6RoleName,
  cast( '' as waers ) AS FreeDefinedCurrency7,
  cast( '' as fac_crcyrole_txt ) AS FreeDefinedCurrency7RoleName,
  cast( '' as waers ) AS FreeDefinedCurrency8,
  cast( '' as fac_crcyrole_txt ) AS FreeDefinedCurrency8RoleName,
  cast( '' as waers ) AS FunctionalCurrency,
  cast( '' as fac_crcyrole_txt ) AS FunctionalCurrencyRoleName,
  DepreciationAreaType,
  cast( '0' as timestamp ) AS LastChangeDateTime
FROM I_AssetTimeBasedValuationTP AS _AssetTimeBasedValuationTP
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_AssetValuationTP AS _AssetValuationTP ON CompanyCode = _AssetValuationTP.CompanyCode AND MasterFixedAsset = _AssetValuationTP.MasterFixedAsset AND FixedAsset = _AssetValuationTP.FixedAsset AND Ledger = _AssetValuationTP.Ledger AND AssetDepreciationArea = _AssetValuationTP.AssetDepreciationArea  -- association [1..1]
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRoles AS _CurrencyRoles ON CompanyCode = _CurrencyRoles.CompanyCode AND Ledger = _CurrencyRoles.Ledger  -- association [0..1]
;