What is A_CollateralRealEstate in SAP S/4HANA?

A_CollateralRealEstate is a consumption CDS view in SAP S/4HANA. Collateral Real Estate Object It contains 48 fields.

Which tables does A_CollateralRealEstate read from?

A_CollateralRealEstate reads data from: R_CollateralRealEstateTP.

What VDM layer is A_CollateralRealEstate?

A_CollateralRealEstate is classified as a Consumption view optimized for specific business scenarios and reporting.

A_CollateralRealEstate

DDL: A_COLLATERALREALESTATE Type: view_entity CONSUMPTION

48 Fields 1 Data Sources

Collateral Real Estate Object

A_CollateralRealEstate is a Consumption CDS View that provides data about "Collateral Real Estate Object" in SAP S/4HANA. It reads from 1 data source (R_CollateralRealEstateTP) and exposes 48 fields with key field CollateralRealEstateUUID.

Data Sources (1)

Source	Alias	Join Type
R_CollateralRealEstateTP	R_CollateralRealEstateTP	projection

Annotations (10)

Name	Value	Level
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
ObjectModel.sapObjectNodeType.name	CollateralRealEstate	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
AccessControl.authorizationCheck	#MANDATORY	view
Metadata.ignorePropagatedAnnotations	true	view
OData.entityType.name	CollateralRealEstate_Type	view
EndUserText.label	Collateral Real Estate Object	view

Fields (48)

Key	Field	Source Field	Description
KEY	CollateralRealEstateUUID	CollateralRealEstateUUID
	ColltrlRealEstateConvertedID	ColltrlRealEstateConvertedID
	CollateralRealEstateIdentifier	CollateralRealEstateIdentifier
	CollateralRealEstateType	CollateralRealEstateType
	ColltrlRealEstateDescription	ColltrlRealEstateDescription
	CollateralRealEstateParentUUID	CollateralRealEstateParentUUID
	ColltrlREExtReferenceNumber	ColltrlREExtReferenceNumber
	ColltrlREFixtureFittingType	ColltrlREFixtureFittingType
	CollateralRealEstateAreaUnit	CollateralRealEstateAreaUnit
	CollateralRealEstateVolumeUnit	CollateralRealEstateVolumeUnit
	ColltrlREObjectCurrency	ColltrlREObjectCurrency
	ColltrlRealEstateMacroLocation	ColltrlRealEstateMacroLocation
	ColltrlRealEstateMicroLocation	ColltrlRealEstateMicroLocation
	ColltrlRETransptConncn	ColltrlRETransptConncn
	ColltrlREEnvironmentalStatus	ColltrlREEnvironmentalStatus
	ColltrlRealEstateIsFloodZone	ColltrlRealEstateIsFloodZone
	ColltrlREIsEarthquakeZone	ColltrlREIsEarthquakeZone
	ColltrlREIsArchlConsvnArea	ColltrlREIsArchlConsvnArea
	ColltrlREIsHistoricalSite	ColltrlREIsHistoricalSite
	ColltrlREHasFctrsImprngVal	ColltrlREHasFctrsImprngVal
	ColltrlREFctrsImprngValDesc	ColltrlREFctrsImprngValDesc
	CollateralAdminOrgUnit	CollateralAdminOrgUnit
	CollateralBankArea	CollateralBankArea
	CollateralRealEstateEnteredBy	CollateralRealEstateEnteredBy
	ColltrlRealEstateEnteredDate	ColltrlRealEstateEnteredDate
	ColltrlRealEstateEnteredTime	ColltrlRealEstateEnteredTime
	ColltrlRealEstateEnteredSource	ColltrlRealEstateEnteredSource
	ColltrlRealEstateLastChangedBy	ColltrlRealEstateLastChangedBy
	ColltrlRELastChangedDate	ColltrlRELastChangedDate
	ColltrlRELastChangedTime	ColltrlRELastChangedTime
	ColltrlRELastChangedDateTime	ColltrlRELastChangedDateTime
	ColltrlRELastChangedSource	ColltrlRELastChangedSource
	CollateralBusinessProcessUUID	CollateralBusinessProcessUUID
	ColltrlBusinessProcessTypeCode	ColltrlBusinessProcessTypeCode
	CollateralIsBlocked	CollateralIsBlocked
	CollateralRealEstateAddressID	CollateralRealEstateAddressID
	CityName	CityName	Name
	PostalCode	PostalCode	Postal Code
	StreetName	StreetName	Text
	HouseNumber	HouseNumber	House Number
	Building	Building	Building code
	Floor	Floor	Floor
	Country	Country	Venue: Ctry/Reg
	Region	Region	Venue Region
	AddressSearchTerm1	AddressSearchTerm1	Search Term 1
	AddressSearchTerm2	AddressSearchTerm2	Search Term 2
	_CollateralRealEstateType	_CollateralRealEstateType
	_CollateralAdminOrgUnitAttrib	_CollateralAdminOrgUnitAttrib

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 A_CollateralRealEstate.
-- 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 A_CollateralRealEstate AS
SELECT
  CollateralRealEstateUUID,
  ColltrlRealEstateConvertedID,
  CollateralRealEstateIdentifier,
  CollateralRealEstateType,
  ColltrlRealEstateDescription,
  CollateralRealEstateParentUUID,
  ColltrlREExtReferenceNumber,
  ColltrlREFixtureFittingType,
  CollateralRealEstateAreaUnit,
  CollateralRealEstateVolumeUnit,
  ColltrlREObjectCurrency,
  ColltrlRealEstateMacroLocation,
  ColltrlRealEstateMicroLocation,
  ColltrlRETransptConncn,
  ColltrlREEnvironmentalStatus,
  ColltrlRealEstateIsFloodZone,
  ColltrlREIsEarthquakeZone,
  ColltrlREIsArchlConsvnArea,
  ColltrlREIsHistoricalSite,
  ColltrlREHasFctrsImprngVal,
  ColltrlREFctrsImprngValDesc,
  CollateralAdminOrgUnit,
  CollateralBankArea,
  CollateralRealEstateEnteredBy,
  ColltrlRealEstateEnteredDate,
  ColltrlRealEstateEnteredTime,
  ColltrlRealEstateEnteredSource,
  ColltrlRealEstateLastChangedBy,
  ColltrlRELastChangedDate,
  ColltrlRELastChangedTime,
  ColltrlRELastChangedDateTime,
  ColltrlRELastChangedSource,
  CollateralBusinessProcessUUID,
  ColltrlBusinessProcessTypeCode,
  CollateralIsBlocked,
  CollateralRealEstateAddressID,
  CityName,
  PostalCode,
  StreetName,
  HouseNumber,
  Building,
  Floor,
  Country,
  Region,
  AddressSearchTerm1,
  AddressSearchTerm2
FROM R_CollateralRealEstateTP
;

Depth:

A_CollateralRealEstate view_entity

R_CollateralRealEstateTP view_entity