I_GlobAssetTimeBasedValn

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_GlobAssetTimeBasedValn.
-- 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: IGASTTIMEBSDVALN

CREATE VIEW I_GlobAssetTimeBasedValn AS
SELECT
  comp_code AS CompanyCode,
  asset_no AS MasterFixedAsset,
  asset_subno AS FixedAsset,
  Ledger,
  depr_area AS AssetDepreciationArea,
  valid_to_date AS ValidityEndDate,
  valid_from_date AS ValidityStartDate,
  glo_jp_imp_posting_date AS JP_ImpairmentPostingDate,
  glo_jp_imp_apc_hsl AS JP_ImpAcqnProdCostAmtInCCCrcy,
  glo_jp_imp_apc_ksl AS JP_ImpAcqnProdCostAmtInGCrcy,
  glo_jp_imp_apc_osl AS JP_ImpAcqnProdCostAmtInFDCrcy1,
  glo_jp_imp_apc_vsl AS JP_ImpAcqnProdCostAmtInFDCrcy2,
  glo_jp_imp_apc_bsl AS JP_ImpAcqnProdCostAmtInFDCrcy3,
  glo_jp_imp_apc_csl AS JP_ImpAcqnProdCostAmtInFDCrcy4,
  glo_jp_imp_apc_dsl AS JP_ImpAcqnProdCostAmtInFDCrcy5,
  glo_jp_imp_apc_esl AS JP_ImpAcqnProdCostAmtInFDCrcy6,
  glo_jp_imp_apc_fsl AS JP_ImpAcqnProdCostAmtInFDCrcy7,
  glo_jp_imp_apc_gsl AS JP_ImpAcqnProdCostAmtInFDCrcy8,
  glo_jp_imp_bai_hsl AS JP_AftImprmtBookAmtInCCCrcy,
  glo_jp_imp_bai_ksl AS JP_AftImprmtBookAmtInGlobCrcy,
  glo_jp_imp_bai_osl AS JP_AftImprmtBookAmtInFDCrcy1,
  glo_jp_imp_bai_vsl AS JP_AftImprmtBookAmtInFDCrcy2,
  glo_jp_imp_bai_bsl AS JP_AftImprmtBookAmtInFDCrcy3,
  glo_jp_imp_bai_csl AS JP_AftImprmtBookAmtInFDCrcy4,
  glo_jp_imp_bai_dsl AS JP_AftImprmtBookAmtInFDCrcy5,
  glo_jp_imp_bai_esl AS JP_AftImprmtBookAmtInFDCrcy6,
  glo_jp_imp_bai_fsl AS JP_AftImprmtBookAmtInFDCrcy7,
  glo_jp_imp_bai_gsl AS JP_AftImprmtBookAmtInFDCrcy8,
  glo_sk_cptl_imprv_yr AS SK_CapitalImprovementYear
FROM glo_faat_md_vtdd AS GlobAssetTimeBasedValuation
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_AssetValuation AS _AssetValuation ON CompanyCode = _AssetValuation.CompanyCode AND MasterFixedAsset = _AssetValuation.MasterFixedAsset AND FixedAsset = _AssetValuation.FixedAsset AND Ledger = _AssetValuation.Ledger AND AssetDepreciationArea = _AssetValuation.AssetDepreciationArea  -- association [1..1]
;