R_REIntegObjectAddressTP

DDL: R_REINTEGOBJECTADDRESSTP SQL: RREINTEGOBJADRTP Type: view_entity TRANSACTIONAL

IntegrationObject Address TP

R_REIntegObjectAddressTP is a Transactional CDS View that provides data about "IntegrationObject Address TP" in SAP S/4HANA. It reads from 1 data source (I_REObjectAddress) and exposes 19 fields with key field InternalRealEstateNumber.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_REObjectAddress _REObjectAddress from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey InternalRealEstateNumber view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label IntegrationObject Address TP view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber
AddressID AddressID
REAddressObjType REAddressObjType
StreetName _Address StreetName
HouseNumber _Address HouseNumber
CityName _Address CityName
PostalCode _Address PostalCode
Country _Address Country
Region _Address Region
StreetPrefixName _Address StreetPrefixName1
AdditionalStreetPrefixName _Address StreetPrefixName2
StreetSuffixName _Address StreetSuffixName1
AdditionalStreetSuffixName _Address StreetSuffixName2
HouseNumberSupplementText _Address HouseNumberSupplementText
District
Building _Address Building
TaxJurisdiction _Address TaxJurisdiction
_Address _Address
_REIntegrationObjectTP _REIntegrationObjectTP 
//@AbapCatalog.sqlViewName: 'RREINTEGOBJADRTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]

@ObjectModel.representativeKey: 'InternalRealEstateNumber' 
@ObjectModel.semanticKey: ['InternalRealEstateNumber' ]
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

@EndUserText.label: 'IntegrationObject Address TP'
//@ClientHandling.algorithm: #SESSION_VARIABLE

define view entity R_REIntegObjectAddressTP
  as select from I_REObjectAddress as _REObjectAddress
  association to parent R_REIntegrationObjectTP as _REIntegrationObjectTP on $projection.InternalRealEstateNumber = _REIntegrationObjectTP.InternalRealEstateNumber

{
  key  InternalRealEstateNumber,
       AddressID,
       REAddressObjType,       
       _Address.StreetName, //street

       _Address.HouseNumber, //house_num1 

       _Address.CityName, //city1

       _Address.PostalCode, //post_code1

       _Address.Country, //country

       _Address.Region, //region

       //ADDRESS_TEXT

       _Address.StreetPrefixName1 as StreetPrefixName, //str_suppl1

       _Address.StreetPrefixName2 as AdditionalStreetPrefixName, //str_suppl2

       _Address.StreetSuffixName1 as StreetSuffixName, //str_suppl3

       _Address.StreetSuffixName2 as AdditionalStreetSuffixName, //location

       _Address.HouseNumberSupplementText, // house_num2 

       cast(_Address.DistrictName as ort02_gp) as District, //city2

       _Address.Building, //building

       _Address.TaxJurisdiction, //taxjurcode       

       
       _Address,
       _REIntegrationObjectTP

}
where //_REIntegrationObjectTP.RealEstateObjectType = 'J5'

  InternalRealEstateNumber like 'J5%'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS_2",
"I_REOBJECTADDRESS"
],
"ASSOCIATED":
[
"I_ADDRESS_2",
"R_REINTEGRATIONOBJECTTP"
],
"BASE":
[
"I_REOBJECTADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More