I_REFixedAssetRelation

DDL: I_REFIXEDASSETRELATION SQL: IREFIXASTREL Type: view BASIC
5 Fields 1 Data Sources 2 Associations

Real Estate Relation to Fixed Asset

I_REFixedAssetRelation is a Basic CDS View that provides data about "Real Estate Relation to Fixed Asset" in SAP S/4HANA. It reads from 1 data source (I_FixedAsset) and exposes 5 fields with key field REStatusObjectAsset. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FixedAsset I_FixedAsset from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FixedAsset _FixedAsset $projection.CompanyCode = _FixedAsset.CompanyCode and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset and $projection.FixedAsset = _FixedAsset.FixedAsset
[0..1] I_REObjectTypeText _REObjectTypeText _REObjectTypeText.RealEstateObjectType = 'AN' and _REObjectTypeText.Language = $session.system_language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IREFIXASTREL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Real Estate Relation to Fixed Asset view
ObjectModel.representativeKey REStatusObjectAsset view
ObjectModel.semanticKey REStatusObjectAsset view
ObjectModel.compositionRoot true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY REStatusObjectAsset
CompanyCode CompanyCode Receiver Company Code
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
_FixedAsset _FixedAsset

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_REFixedAssetRelation.
-- 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: IREFIXASTREL

CREATE VIEW I_REFixedAssetRelation AS
SELECT
  cast( concat( 'AN' , concat( CompanyCode , concat( MasterFixedAsset , FixedAsset ) ) ) as receasobjnr ) AS REStatusObjectAsset,
  CompanyCode,
  MasterFixedAsset,
  FixedAsset
FROM I_FixedAsset
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_REObjectTypeText AS _REObjectTypeText ON _REObjectTypeText.RealEstateObjectType = 'AN' AND _REObjectTypeText.Language = $session.system_language  -- association [0..1]
;

Learn More