E_FixedAssetWorklist

DDL: E_FIXEDASSETWORKLIST Type: view EXTENSION
3 Fields 1 Data Sources

Extension View for Fixed Asset Worklist

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

Data Sources (1)

SourceAliasJoin Type
anla Persistence from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName EFASSETLIST view
AbapCatalog.preserveKey true view
EndUserText.label Extension View for Fixed Asset Worklist view
VDM.viewType #EXTENSION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode anla bukrs Value
KEY MasterFixedAsset anla anln1 Asset
KEY FixedAsset anla 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_FixedAssetWorklist.
-- 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 E_FixedAssetWorklist AS
SELECT
  Persistence.bukrs AS CompanyCode,
  Persistence.anln1 AS MasterFixedAsset,
  Persistence.anln2 AS FixedAsset
FROM anla AS Persistence
;

Learn More