I_AssetClass

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_AssetClass.
-- 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 I_AssetClass AS
SELECT
  AssetClass,
  AssetAccountDetermination,
  BusinessArea,
  Plant,
  CostCenter,
  FixedAssetFinDataCmpltns,
  AssetCountryOfOrigin,
  Supplier,
  FixedAssetGroup,
  FixedAssetPropertyType,
  PropertyClass,
  InvestmentSupportMeasure,
  Group1AssetEvaluationKey,
  Group2AssetEvaluationKey,
  Group3AssetEvaluationKey,
  Group4AssetEvaluationKey,
  InvestmentReason,
  AssetAuthorizationContext
FROM P_AssetClass
LEFT OUTER JOIN I_AssetClassText AS _Text ON AssetClass = _Text.AssetClass  -- association [0..*]
LEFT OUTER JOIN I_AssetAcctDetermination AS _AssetAcctDetermination ON AssetAccountDetermination = _AssetAcctDetermination.AssetAccountDetermination  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON AssetCountryOfOrigin = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetFinDataCmpltns AS _FixedAssetFinDataCmpltns ON FixedAssetFinDataCmpltns = _FixedAssetFinDataCmpltns.FixedAssetFinDataCmpltns  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetPropertyType AS _FixedAssetPropertyType ON FixedAssetPropertyType = _FixedAssetPropertyType.FixedAssetPropertyType  -- association [0..1]
LEFT OUTER JOIN I_PropertyClass AS _PropertyClass ON PropertyClass = _PropertyClass.PropertyClass  -- association [0..1]
LEFT OUTER JOIN I_Group1AssetEvaluationKey AS _Group1AssetEvaluationKey ON Group1AssetEvaluationKey = _Group1AssetEvaluationKey.Group1AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group2AssetEvaluationKey AS _Group2AssetEvaluationKey ON Group2AssetEvaluationKey = _Group2AssetEvaluationKey.Group2AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group3AssetEvaluationKey AS _Group3AssetEvaluationKey ON Group3AssetEvaluationKey = _Group3AssetEvaluationKey.Group3AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group4AssetEvaluationKey AS _Group4AssetEvaluationKey ON Group4AssetEvaluationKey = _Group4AssetEvaluationKey.Group4AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_InvestmentReason AS _InvestmentReason ON InvestmentReason = _InvestmentReason.InvestmentReason  -- association [0..1]
;