I_REObjectByIntFinNumber

DDL: I_REOBJECTBYINTFINNUMBER SQL: IREOBJBYFINUM Type: view BASIC
15 Fields 1 Data Sources 1 Associations

Real Estate Obj by Internal FIN Number

I_REObjectByIntFinNumber (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_REObjectByIntFinNumber is a Basic CDS View that provides data about "Real Estate Obj by Internal FIN Number" in SAP S/4HANA. It reads from 1 data source (I_REKeyAssgmt) and exposes 15 fields with key field REInternalFinNumber. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentRE-FX
CapabilitiesData Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_REKeyAssgmt _REKeyAssgmt from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_REObjectTypeText _REObjectTypeText _REObjectTypeText.RealEstateObjectType = $projection.RealEstateObjectType and _REObjectTypeText.Language = $session.system_language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IREOBJBYFINUM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Obj by Internal FIN Number view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey REInternalFinNumber view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY REInternalFinNumber REInternalFinNumber Internal Key of Real Estate Object (FI)
REStatusObject REStatusObject Val. Obj. No.
InternalRealEstateNumber InternalRealEstateNumber Internal Key of Real Estate Object
RealEstateObjectType RealEstateObjectType Object Type
REIdentificationKey REIdentificationKey ID Part Key, for example "1000/123"
CompanyCode CompanyCode Receiver Company Code
RealEstateContract RealEstateContract Real Estate Contract
REBusinessEntity REBusinessEntity RE Business Entity
RERentalObject RERentalObject RE Rental Object
RealEstateBuilding RealEstateBuilding Real Estate Building
RealEstateProperty RealEstateProperty Real Estate Property
REServiceChargeKey REServiceChargeKey RE Service Charge Key
RESettlementUnitID RESettlementUnitID RE Settlement Unit
_REObjectType _REObjectType
_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_REObjectByIntFinNumber.
-- 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: IREOBJBYFINUM

CREATE VIEW I_REObjectByIntFinNumber AS
SELECT
  REInternalFinNumber,
  REStatusObject,
  InternalRealEstateNumber,
  RealEstateObjectType,
  REIdentificationKey,
  CompanyCode,
  RealEstateContract,
  REBusinessEntity,
  RERentalObject,
  RealEstateBuilding,
  RealEstateProperty,
  REServiceChargeKey,
  RESettlementUnitID
FROM I_REKeyAssgmt AS _REKeyAssgmt
LEFT OUTER JOIN I_REObjectTypeText AS _REObjectTypeText ON _REObjectTypeText.RealEstateObjectType = RealEstateObjectType AND _REObjectTypeText.Language = $session.system_language  -- association [0..1]
;

Learn More