I_FixedAssetFromLegacySystemVH

DDL: I_FIXEDASSETFROMLEGACYSYSTEMVH SQL: IFILGFXDAST_VH Type: view COMPOSITE

Legacy Asset Value Help

I_FixedAssetFromLegacySystemVH is a Composite CDS View that provides data about "Legacy Asset Value Help" in SAP S/4HANA. It reads from 1 data source (I_FixedAsset) and exposes 9 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset.

Data Sources (1)

SourceAliasJoin Type
I_FixedAsset I_FixedAsset from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IFILGFXDAST_VH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey FixedAsset view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Legacy Asset Value Help view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
FixedAssetDescription FixedAssetDescription Description
IsMainAsset IsMainAsset Leading Asset
AssetClass AssetClass Asset Class
AssetAuthorizationContext AssetAuthorizationContext
_CompanyCode _CompanyCode
_MasterFixedAsset _MasterFixedAsset

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_FixedAssetFromLegacySystemVH.
-- 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: IFILGFXDAST_VH

CREATE VIEW I_FixedAssetFromLegacySystemVH AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  FixedAssetDescription,
  IsMainAsset,
  AssetClass,
  AssetAuthorizationContext
FROM I_FixedAsset
;