I_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 I_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: IASSETVALNTP

CREATE VIEW I_AssetValuationTP AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  Ledger,
  AssetDepreciationArea,
  cast ( cast ( '00' as abap.numc(2) ) as afaber ) AS AssetLeadingDepreciationArea,
  cast ( cast ( '' as abap.char(4) ) as afapl ) AS ChartOfDepreciation,
  AssetValuation.DepreciationKey AS DepreciationKey,
  AssetValuation.PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  AssetValuation.PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  NegativeAmountIsAllowed,
  DepreciationStartDate,
  SpecialDeprStartDate,
  InterestCalcStartDate,
  AssetOpgReadinessDate,
  ReplacementValueIndexSers,
  RplcmtValueAgingIndexSers,
  DeprKeyChangeoverYear,
  DeprKeyChangeoverPeriod,
  LowValueAssetAmountCheckType,
  LastRetirementValueDate,
  AssetCurrentFiscalYear,
  AssetNumberOfPeriods,
  DepreciationAreaType,
  ExpiredUsefulLifeInYrs,
  ExpiredUsefulLifeInPerds,
  SpclExpiredUsefulLifeInYrs,
  SpclExpiredUsefulLifeInPerds,
  CoCodeCurrencyErrorIsIgnored,
  GlobalCurrencyErrorIsIgnored,
  FreeDefinedCrcy1ErrorIsIgnored,
  FreeDefinedCrcy2ErrorIsIgnored,
  FreeDefinedCrcy3ErrorIsIgnored,
  FreeDefinedCrcy4ErrorIsIgnored,
  FreeDefinedCrcy5ErrorIsIgnored,
  FreeDefinedCrcy6ErrorIsIgnored,
  FreeDefinedCrcy7ErrorIsIgnored,
  FreeDefinedCrcy8ErrorIsIgnored
FROM I_AssetValuation AS AssetValuation
LEFT OUTER JOIN I_AssetTP AS _AssetTP ON CompanyCode = _AssetTP.CompanyCode AND MasterFixedAsset = _AssetTP.MasterFixedAsset AND FixedAsset = _AssetTP.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_AssetLedgerTP AS _AssetLedgerTP ON CompanyCode = _AssetLedgerTP.CompanyCode AND MasterFixedAsset = _AssetLedgerTP.MasterFixedAsset AND FixedAsset = _AssetLedgerTP.FixedAsset AND Ledger = _AssetLedgerTP.Ledger  -- association [1..1]
LEFT OUTER JOIN I_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 I_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 I_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..*]
;