E_FixedAsset

DDL: E_FIXEDASSET SQL: EFIXASSET Type: view EXTENSION
3 Fields 1 Data Sources

Extension View for Fixed Asset Master Data

E_FixedAsset is a Extension CDS View that provides data about "Extension View for Fixed Asset Master Data" in SAP S/4HANA. It reads from 1 data source (anlu) and exposes 3 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset.

Data Sources (1)

SourceAliasJoin Type
anlu Persistence from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName EFIXASSET view
EndUserText.label Extension View for Fixed Asset Master Data view
VDM.viewType #EXTENSION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode anlu bukrs Value
KEY MasterFixedAsset anlu anln1 Asset
KEY FixedAsset anlu anln2 Sub-number

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 E_FixedAsset.
-- 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: EFIXASSET

CREATE VIEW E_FixedAsset AS
SELECT
  Persistence.bukrs AS CompanyCode,
  Persistence.anln1 AS MasterFixedAsset,
  Persistence.anln2 AS FixedAsset
FROM anlu AS Persistence
;

Learn More