R_CollateralRealEstateTP

DDL: R_COLLATERALREALESTATETP Type: view_entity TRANSACTIONAL
52 Fields 1 Data Sources

Collateral Real Estate Object - TP

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

Data Sources (1)

SourceAliasJoin Type
I_CollateralRealEstate ColRE from

Annotations (9)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_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
EndUserText.label Collateral Real Estate Object - TP view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY CollateralRealEstateUUID I_CollateralRealEstate CollateralRealEstateUUID UUID
ColltrlRealEstateConvertedID I_CollateralRealEstate ColltrlRealEstateConvertedID
CollateralRealEstateIdentifier I_CollateralRealEstate CollateralRealEstateIdentifier Transaction ID
CollateralRealEstateType I_CollateralRealEstate CollateralRealEstateType Type
ColltrlRealEstateDescription I_CollateralRealEstate ColltrlRealEstateDescription Description
CollateralRealEstateParentUUID I_CollateralRealEstate CollateralRealEstateParentUUID Object GUID
ColltrlREExtReferenceNumber I_CollateralRealEstate ColltrlREExtReferenceNumber Ext. reference
ColltrlREFixtureFittingType I_CollateralRealEstate ColltrlREFixtureFittingType Fixture&Fitting
CollateralRealEstateAreaUnit I_CollateralRealEstate CollateralRealEstateAreaUnit Area UOM
CollateralRealEstateVolumeUnit I_CollateralRealEstate CollateralRealEstateVolumeUnit Volume UOM
ColltrlREObjectCurrency I_CollateralRealEstate ColltrlREObjectCurrency Object Curr
ColltrlRealEstateMacroLocation I_CollateralRealEstate ColltrlRealEstateMacroLocation Macro Location
ColltrlRealEstateMicroLocation I_CollateralRealEstate ColltrlRealEstateMicroLocation Micro Location
ColltrlRETransptConncn I_CollateralRealEstate ColltrlRETransptConncn Tranport Conn
ColltrlREEnvironmentalStatus I_CollateralRealEstate ColltrlREEnvironmentalStatus Environ. Status
ColltrlRealEstateIsFloodZone I_CollateralRealEstate ColltrlRealEstateIsFloodZone Flood Zone
ColltrlREIsEarthquakeZone I_CollateralRealEstate ColltrlREIsEarthquakeZone Earthquake Zone
ColltrlREIsArchlConsvnArea I_CollateralRealEstate ColltrlREIsArchlConsvnArea Arct. Conv Site
ColltrlREIsHistoricalSite I_CollateralRealEstate ColltrlREIsHistoricalSite Historical Site
ColltrlREHasFctrsImprngVal I_CollateralRealEstate ColltrlREHasFctrsImprngVal Imp Factors
ColltrlREFctrsImprngValDesc I_CollateralRealEstate ColltrlREFctrsImprngValDesc Des.Imp Factors
CollateralAdminOrgUnit I_CollateralRealEstate CollateralAdminOrgUnit AdminOrg
CollateralBankArea I_CollateralRealEstate CollateralBankArea Bankarea
CollateralRealEstateEnteredBy I_CollateralRealEstate CollateralRealEstateEnteredBy Version Created By
ColltrlRealEstateEnteredDate I_CollateralRealEstate ColltrlRealEstateEnteredDate Time Stamp
ColltrlRealEstateEnteredTime I_CollateralRealEstate ColltrlRealEstateEnteredTime Time Stamp
ColltrlRealEstateEnteredSource I_CollateralRealEstate ColltrlRealEstateEnteredSource Source Of Entry
ColltrlRealEstateLastChangedBy I_CollateralRealEstate ColltrlRealEstateLastChangedBy Last Changed by
ColltrlRELastChangedDate I_CollateralRealEstate ColltrlRELastChangedDate Last Changed on
ColltrlRELastChangedTime I_CollateralRealEstate ColltrlRELastChangedTime Last Changed at
clientNULLasColltrlRELastChangedDateTime
ColltrlRELastChangedSource I_CollateralRealEstate ColltrlRELastChangedSource Processing Src
CollateralBusinessProcessUUID I_CollateralRealEstate CollateralBusinessProcessUUID Bus. Process ID
ColltrlBusinessProcessTypeCode I_CollateralRealEstate ColltrlBusinessProcessTypeCode BusProcess Code
CollateralIsBlocked I_CollateralRealEstate CollateralIsBlocked BlockingInd.
CollateralRealEstateAddressID I_CollateralRealEstate CollateralRealEstateAddressID Address number
CityName Addr CityName Name
PostalCode Addr PostalCode Postal Code
StreetName Addr StreetName Text
HouseNumber Addr HouseNumber House Number
Building Addr Building Building code
Floor Addr Floor Floor
Country Addr Country Venue: Ctry/Reg
Region Addr Region Venue Region
AddressSearchTerm1 Addr AddressSearchTerm1 Search Term 1
AddressSearchTerm2 Addr AddressSearchTerm2 Search Term 2
_CollateralRealEstateType I_CollateralRealEstate _CollateralRealEstateType
_CollateralAdminOrgUnitAttrib I_CollateralRealEstate _CollateralAdminOrgUnitAttrib
_CollateralRealEstateAsset _CollateralRealEstateAsset
_CollateralRealEstatePart _CollateralRealEstatePart
_ColltrlRealEstateInsurance _ColltrlRealEstateInsurance
_ColltrlREEngyPerfCert _ColltrlREEngyPerfCert

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 R_CollateralRealEstateTP.
-- 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 R_CollateralRealEstateTP AS
SELECT
  ColRE.CollateralRealEstateUUID AS CollateralRealEstateUUID,
  ColRE.ColltrlRealEstateConvertedID AS ColltrlRealEstateConvertedID,
  ColRE.CollateralRealEstateIdentifier AS CollateralRealEstateIdentifier,
  ColRE.CollateralRealEstateType AS CollateralRealEstateType,
  ColRE.ColltrlRealEstateDescription AS ColltrlRealEstateDescription,
  ColRE.CollateralRealEstateParentUUID AS CollateralRealEstateParentUUID,
  ColRE.ColltrlREExtReferenceNumber AS ColltrlREExtReferenceNumber,
  ColRE.ColltrlREFixtureFittingType AS ColltrlREFixtureFittingType,
  ColRE.CollateralRealEstateAreaUnit AS CollateralRealEstateAreaUnit,
  ColRE.CollateralRealEstateVolumeUnit AS CollateralRealEstateVolumeUnit,
  ColRE.ColltrlREObjectCurrency AS ColltrlREObjectCurrency,
  ColRE.ColltrlRealEstateMacroLocation AS ColltrlRealEstateMacroLocation,
  ColRE.ColltrlRealEstateMicroLocation AS ColltrlRealEstateMicroLocation,
  ColRE.ColltrlRETransptConncn AS ColltrlRETransptConncn,
  ColRE.ColltrlREEnvironmentalStatus AS ColltrlREEnvironmentalStatus,
  ColRE.ColltrlRealEstateIsFloodZone AS ColltrlRealEstateIsFloodZone,
  ColRE.ColltrlREIsEarthquakeZone AS ColltrlREIsEarthquakeZone,
  ColRE.ColltrlREIsArchlConsvnArea AS ColltrlREIsArchlConsvnArea,
  ColRE.ColltrlREIsHistoricalSite AS ColltrlREIsHistoricalSite,
  ColRE.ColltrlREHasFctrsImprngVal AS ColltrlREHasFctrsImprngVal,
  ColRE.ColltrlREFctrsImprngValDesc AS ColltrlREFctrsImprngValDesc,
  ColRE.CollateralAdminOrgUnit AS CollateralAdminOrgUnit,
  ColRE.CollateralBankArea AS CollateralBankArea,
  ColRE.CollateralRealEstateEnteredBy AS CollateralRealEstateEnteredBy,
  ColRE.ColltrlRealEstateEnteredDate AS ColltrlRealEstateEnteredDate,
  ColRE.ColltrlRealEstateEnteredTime AS ColltrlRealEstateEnteredTime,
  ColRE.ColltrlRealEstateEnteredSource AS ColltrlRealEstateEnteredSource,
  ColRE.ColltrlRealEstateLastChangedBy AS ColltrlRealEstateLastChangedBy,
  ColRE.ColltrlRELastChangedDate AS ColltrlRELastChangedDate,
  ColRE.ColltrlRELastChangedTime AS ColltrlRELastChangedTime,
  dats_tims_to_tstmp( ColRE.ColltrlRELastChangedDate, ColRE.ColltrlRELastChangedTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as ColltrlRELastChangedDateTime AS clientNULLasColltrlRELastChangedDateTime,
  ColRE.ColltrlRELastChangedSource AS ColltrlRELastChangedSource,
  ColRE.CollateralBusinessProcessUUID AS CollateralBusinessProcessUUID,
  ColRE.ColltrlBusinessProcessTypeCode AS ColltrlBusinessProcessTypeCode,
  ColRE.CollateralIsBlocked AS CollateralIsBlocked,
  ColRE.CollateralRealEstateAddressID AS CollateralRealEstateAddressID,
  Addr.CityName AS CityName,
  Addr.PostalCode AS PostalCode,
  Addr.StreetName AS StreetName,
  Addr.HouseNumber AS HouseNumber,
  Addr.Building AS Building,
  Addr.Floor AS Floor,
  Addr.Country AS Country,
  Addr.Region AS Region,
  Addr.AddressSearchTerm1 AS AddressSearchTerm1,
  Addr.AddressSearchTerm2 AS AddressSearchTerm2,
  ColRE._CollateralRealEstateType AS _CollateralRealEstateType,
  ColRE._CollateralAdminOrgUnitAttrib AS _CollateralAdminOrgUnitAttrib
FROM I_CollateralRealEstate AS ColRE
;

Learn More