P_AssetValuationScrapAmount

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 P_AssetValuationScrapAmount.
-- 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.

CREATE VIEW P_AssetValuationScrapAmount AS
SELECT
  I_AssetTimeBasedValuation.CompanyCode AS CompanyCode,
  I_AssetTimeBasedValuation.MasterFixedAsset AS MasterFixedAsset,
  I_AssetTimeBasedValuation.FixedAsset AS FixedAsset,
  I_AssetTimeBasedValuation.Ledger AS Ledger,
  cast(I_AssetTimeBasedValuation.AssetDepreciationArea as afabe_d) AS AssetRealDepreciationArea,
  I_AssetTimeBasedValuation.ValidityEndDate AS ValidityEndDate,
  I_AssetTimeBasedValuation.ValidityStartDate AS ValidityStartDate,
  I_AssetTimeBasedValuation.AcqnProdnCostScrapPercent AS AcqnProdnCostScrapPercent,
  I_AssetTimeBasedValuation.ScrapAmountInCoCodeCrcy AS ScrapAmountInCoCodeCrcy,
  I_LedgerCompanyCodeCrcyRoles.CompanyCodeCurrencyRole AS CompanyCodeCurrencyRole,
  cast( _CompanyCodeCurrency.Currency as fis_hwaer preserving type ) AS CompanyCodeCurrency,
  I_AssetTimeBasedValuation.ScrapAmountInGlobCrcy AS ScrapAmountInGlobCrcy,
  I_LedgerCompanyCodeCrcyRoles.GlobalCurrencyRole AS GlobalCurrencyRole,
  cast (_GlobalCurrency.Currency as fins_currk preserving type) AS GlobalCurrency,
  I_AssetTimeBasedValuation.ScrapAmountInFreeDefinedCrcy1 AS ScrapAmountInFreeDefinedCrcy1,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
  cast ( _FreeDefinedCurrency1.Currency as fins_curr1 preserving type) AS FreeDefinedCurrency1,
  I_AssetTimeBasedValuation.ScrapAmountInFreeDefinedCrcy2 AS ScrapAmountInFreeDefinedCrcy2,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency2Role AS FreeDefinedCurrency2Role,
  cast ( _FreeDefinedCurrency2.Currency as fins_curr2 preserving type) AS FreeDefinedCurrency2,
  I_AssetTimeBasedValuation.ScrapAmountInFreeDefinedCrcy3 AS ScrapAmountInFreeDefinedCrcy3,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency3Role AS FreeDefinedCurrency3Role,
  cast ( _FreeDefinedCurrency3.Currency as fins_curr3 preserving type) AS FreeDefinedCurrency3,
  I_AssetTimeBasedValuation.ScrapAmountInFreeDefinedCrcy4 AS ScrapAmountInFreeDefinedCrcy4,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency4Role AS FreeDefinedCurrency4Role,
  cast ( _FreeDefinedCurrency4.Currency as fins_curr4 preserving type) AS FreeDefinedCurrency4,
  I_AssetTimeBasedValuation.ScrapAmountInFreeDefinedCrcy5 AS ScrapAmountInFreeDefinedCrcy5,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency5Role AS FreeDefinedCurrency5Role,
  cast ( _FreeDefinedCurrency5.Currency as fins_curr5 preserving type) AS FreeDefinedCurrency5,
  I_AssetTimeBasedValuation.ScrapAmountInFreeDefinedCrcy6 AS ScrapAmountInFreeDefinedCrcy6,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency6Role AS FreeDefinedCurrency6Role,
  cast ( _FreeDefinedCurrency6.Currency as fins_curr6 preserving type) AS FreeDefinedCurrency6,
  I_AssetTimeBasedValuation.ScrapAmountInFreeDefinedCrcy7 AS ScrapAmountInFreeDefinedCrcy7,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency7Role AS FreeDefinedCurrency7Role,
  cast ( _FreeDefinedCurrency7.Currency as fins_curr7 preserving type) AS FreeDefinedCurrency7,
  I_AssetTimeBasedValuation.ScrapAmountInFreeDefinedCrcy8 AS ScrapAmountInFreeDefinedCrcy8,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency8Role AS FreeDefinedCurrency8Role,
  cast ( _FreeDefinedCurrency8.Currency as fins_curr8 preserving type) AS FreeDefinedCurrency8
FROM I_AssetTimeBasedValuation
LEFT OUTER JOIN I_Companycodecurrencyrole AS _CompanyCodeCurrency ON CompanyCode = _CompanyCodeCurrency.CompanyCode AND I_LedgerCompanyCodeCrcyRoles.CompanyCodeCurrencyRole = _CompanyCodeCurrency.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_Companycodecurrencyrole AS _GlobalCurrency ON CompanyCode = _GlobalCurrency.CompanyCode AND I_LedgerCompanyCodeCrcyRoles.GlobalCurrencyRole = _GlobalCurrency.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_Companycodecurrencyrole AS _FreeDefinedCurrency1 ON CompanyCode = _FreeDefinedCurrency1.CompanyCode AND I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency1Role = _FreeDefinedCurrency1.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_Companycodecurrencyrole AS _FreeDefinedCurrency2 ON CompanyCode = _FreeDefinedCurrency2.CompanyCode AND I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency2Role = _FreeDefinedCurrency2.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_Companycodecurrencyrole AS _FreeDefinedCurrency3 ON CompanyCode = _FreeDefinedCurrency3.CompanyCode AND I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency2Role = _FreeDefinedCurrency3.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_Companycodecurrencyrole AS _FreeDefinedCurrency4 ON CompanyCode = _FreeDefinedCurrency4.CompanyCode AND I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency3Role = _FreeDefinedCurrency4.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_Companycodecurrencyrole AS _FreeDefinedCurrency5 ON CompanyCode = _FreeDefinedCurrency5.CompanyCode AND I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency5Role = _FreeDefinedCurrency5.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_Companycodecurrencyrole AS _FreeDefinedCurrency6 ON CompanyCode = _FreeDefinedCurrency6.CompanyCode AND I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency6Role = _FreeDefinedCurrency6.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_Companycodecurrencyrole AS _FreeDefinedCurrency7 ON CompanyCode = _FreeDefinedCurrency7.CompanyCode AND I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency7Role = _FreeDefinedCurrency7.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_Companycodecurrencyrole AS _FreeDefinedCurrency8 ON CompanyCode = _FreeDefinedCurrency8.CompanyCode AND I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency8Role = _FreeDefinedCurrency8.CurrencyRole  -- association [0..1]
;