RELS_BU_MASTERDATA SAP () Structure details

Dictionary Type: Structure
Description:




ABAP Code to SELECT data from RELS_BU_MASTERDATA
Related tables to RELS_BU_MASTERDATA
Access table RELS_BU_MASTERDATA




Structure field list including key, data, relationships and ABAP select examples

RELS_BU_MASTERDATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_RELS_BU_MASTERDATA TYPE RELS_BU_MASTERDATA.

The RELS_BU_MASTERDATA table consists of various fields, each holding specific information or linking keys about data available in SAP. These include SWENR (Site Number), SGENR (Building Number), RGEBART (Type of building), JERBBAU (Heritable building right indicator).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP RELS_BU_MASTERDATA structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
SWENRSite Number SWENRCHAR8Assigned to domainSWENRSWENRWEHMCWE
SGENRBuilding Number SGENRCHAR8Assigned to domainSGENRSGENRGEBMCGE
RGEBARTType of building RGEBARTNUMC2Assigned to domainSOBJART
JERBBAUHeritable building right indicator JERBBAUCHAR1Assigned to domainSOBJERBBAU
RGEBZUSTGeneral condition of building RGEBZUSTNUMC2Assigned to domainVVRZUSTAND
YBAUJAHRConstYr VVYBAUJAHRDATS8DATUM
YMODERNYear of modernization VVYMODERNDATS8DATUM
YAUFBAUYear of reconstruction VVYAUFBAUDATS8DATUM
DBAUBEGIConstruction start date DBAUBEGIDATS8DDAT
BBAUW13Building value BBAUW13CURR11(2) WRBTR
BBAUWAKTCurrent building value BBAUWAKTCURR11(2) WRBTR
BDMCBMRAAmount per volume unit BDMCBMRACURR11(2) WRBTR
DBAUGENEBuilding permit DBAUGENEDATS8DDAT
XBAUGENENote on building permit XBAUGENECHAR30XMBEZ
DBEZUGSFReady for occupancy DBEZUGSFDATS8DDAT
DFERTIGCompletion DFERTIGDATS8DDAT
DSCHLUSSFinal Inspection DSCHLUSSDATS8DDAT
FDACHFLAttic space FDACHFLDEC8(2) DEC6_2
RDAZUSTCondition of roof RDAZUSTNUMC2Assigned to domainVVRZUSTAND
RFAZUSTCondition of facade RFAZUSTNUMC2Assigned to domainVVRZUSTAND
BUBRACubic Volume BUBRADEC11(3) DEC8_3
JDENKMALProtection of Historical Sites JDENKMALCHAR1JANE
AUGESCHNumber of basements AUGESCHDEC2DEC2
DBAUVORDate of planning inquiry DBAUVORDATS8DDAT
DVORBESDate of prior notice DVORBESDATS8DDAT
DANTBAUApplication for building permit DANTBAUDATS8DATUM
XGETXTBuilding text XGETXTCHAR60XLBEZ
BEINHEITWAssessed value of building BEINHEITWCURR11(2) WRBTR
NEINHEITWAssessed value base year NEINHEITWNUMC4GJAHRGJAHR
BVERSWRTInsurable value amount BVERSWRTCURR11(2) WRBTR
RVERSWRTType of insurance value RVERSWRTNUMC1RVERSWRT
SLAGKLocation class SLAGKNUMC2Assigned to domainSLAGK
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
DWIRTUBTransfer usage / charges VVDWIRTUBDATS8DATUM
DVERKAUFSale date VVDVERKAUFDATS8DATUM
SUNUTZAMain usage type VVSUNARTCHAR8Assigned to domainVVSUNART
DVRKPLANPlanned sale VVDVRKPLANDATS8DATUM
DNUTZENDEnd of usage VVDNUTZENDDATS8DATUM
DFRDVONPublic funding from VVDFRDVONDATS8DATUM
DFRDBISPublic funding to VVDFRDBISDATS8DATUM
BANZGENumber of floors VVBANZGEDEC4(1) DEC3_1
RPGENRBuilding no. of hierarchical superior building part VVRPGENRCHAR8Assigned to domainSGENRSGENR
JANLHIEIndicator: Asset allocation valid for subordin. building VVJANLHIECHAR1JANE
SSTCKBISUppermost Floor of a Building VVSTCKBISNUMC3Assigned to domainVVSSTOCKW
SLIFTBISElevator to Floor in Building VVLIFTBISNUMC3Assigned to domainVVSSTOCKW
INTRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
BERGRPAuthorization group VVBERGRPCHAR40VVBERGRP
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS

Key field Non-key field



How do I retrieve data from SAP structure RELS_BU_MASTERDATA using ABAP code?

As RELS_BU_MASTERDATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on RELS_BU_MASTERDATA as there is no data to select.

How to access SAP table RELS_BU_MASTERDATA

Within an ECC or HANA version of SAP you can also view further information about RELS_BU_MASTERDATA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!