I_MM_FixedAssetValueHelp

DDL: I_MM_FIXEDASSETVALUEHELP SQL: IMMFXDAST Type: view COMPOSITE Package: ODATA_MM_COMMONS_VH
9 Fields 1 Data Sources 4 OData Services

Purchasing Fixed Asset Value Help

I_MM_FixedAssetValueHelp is a Composite CDS View that provides data about "Purchasing Fixed Asset Value Help" in SAP S/4HANA. It reads from 1 data source (I_FixedAssetValueHelp) and exposes 9 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset. It is exposed through 4 OData services (ASQL_F1665, ASQL_F2420, ASQL_F2421, ...). Part of development package ODATA_MM_COMMONS_VH.

Data Sources (1)

SourceAliasJoin Type
I_FixedAssetValueHelp FixedAsset from

Annotations (16)

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

OData Services (4)

ServiceBindingVersionContractRelease
ASQL_F1665 ASQL_F1665 C2 NOT_RELEASED
ASQL_F2420 ASQL_F2420 C2 NOT_RELEASED
ASQL_F2421 ASQL_F2421 C2 NOT_RELEASED
ASQL_F2422 ASQL_F2422 C2 NOT_RELEASED

Fields (9)

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

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_MM_FixedAssetValueHelp.
-- 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: IMMFXDAST

CREATE VIEW I_MM_FixedAssetValueHelp AS
SELECT
  FixedAsset.CompanyCode AS CompanyCode,
  FixedAsset.MasterFixedAsset AS MasterFixedAsset,
  FixedAsset.FixedAsset AS FixedAsset,
  FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  FixedAsset.AssetClass AS AssetClass,
  FixedAsset.AssetAuthorizationContext AS AssetAuthorizationContext,
  FixedAsset.AssetCapitalizationDate AS AssetCapitalizationDate
FROM I_FixedAssetValueHelp AS FixedAsset
;

Learn More