SAP Basic Data Tables
Are you looking for the right table related to SAP Basic Data Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Basic Data (RE-FX-BD) module.
Top 10 tables in Basic Data
| Table | Description |
|---|---|
| TIVBDRI | Hereditary Land Lease Right |
| VIBDBE | Business Entity |
| TIVBDPMNT | PM Integration: Notification Transaction per Object Type |
| TIVBDLOCSYS | Hierarchical Location Structure |
| TIVBDAROBJTYPE | Architectural Object Type |
| TIVBDARFUNC | Function per Arch. Object Type |
| TIVBDCHARACTT | Fixtures and Fittings Characteristic (Text) |
| TIVBDCNSUBTYPET | Object Type (Text) |
| TIVBDMEASAO | Measurement Type: Settings per Arch. Object Type |
| TIVBDOBJASSUSES | Possible Object Type per Object Assignment Type |
List of tables in Basic Data
| Table | Description |
|---|---|
| TIVBDRI | Hereditary Land Lease Right |
| VIBDBE | Business Entity |
| TIVBDPMNT | PM Integration: Notification Transaction per Object Type |
| TIVBDLOCSYS | Hierarchical Location Structure |
| TIVBDAROBJTYPE | Architectural Object Type |
| TIVBDARFUNC | Function per Arch. Object Type |
| TIVBDCHARACTT | Fixtures and Fittings Characteristic (Text) |
| TIVBDCNSUBTYPET | Object Type (Text) |
| TIVBDMEASAO | Measurement Type: Settings per Arch. Object Type |
| TIVBDOBJASSUSES | Possible Object Type per Object Assignment Type |
| TIVBDMEAS | Measurement Type |
| TIVBDUSGFUNCT | Name of Function of Objects of Usage View |
| VIBDSUBOBJNUM | Current Number Level of Subobject |
| VIBDINFRA | Infrastructure |
| TIVBDRLOC | Regional location |
| TIVBDCHARACT | Fixtures and Fittings Characteristic |
| TIVBDARFSTATUS | Field Status per Architectural Object Type |
| TIVBDAROBJTYPET | Object Type of Architecture (Text) |
| TIVBDVACEVENTRS | Default Vacancy Reason per Vacancy Event |
| VIBDPLANOBJ | Plan Pooled Space |
| TIVBDUSGFUNC | Functions of Objects of Usage View |
| TIVBDDLOC | District Location |
| TIVBDOBJTYPEASS | Possible Object Assignment Type per Object Type |
| TIVBDIC | Infrastructure Characteristics (Surroundings) |
| TIVBDOBJASSTYPET | Type of Object Assignment (Text) |
| TIVBDVACREAST | Vacancy Reason (Text) |
| TIVBDLOCITEM | Hierarchical Locations in Location Structure |
| TIVBDPM | PM Integration: Settings per Object Type |
| TIVBDCTOBJ | Allowed Fixtures/Fittings Characteristics per Object Type |
| TIVBDBUT | Building Type |
| TIVBDMEASTRNS | Measurement Type: Transformation of Architecture to Usage |
| TIVBDVACEVENT | Event Influencing Vacancy/Occupancy |
| TIVBDTCON | Transport Connection |
| TIVBDLOCOBJ | Allowed Hier. Location Structures per Object Type |
| VIBDPLANOCC | Planned Occupancy of Usage Objects |
| VIBDCNSUBJECT | Contract Object |
| TIVBDMUNI | Municipality Key |
| TIVBDLOC | Location |
| TIVBDARNODE | Allowed Superordinate Architectural Object Type |
| TIVBDMEASSTRCT | Measurement Structure - Texts |
| TIVBDMEASSUM | Measurement Types - Totalling Within Architecture or Usage |
| TIVBDMEASROTYPE | Measurement Type: Settings per Rental Object Type |
| TIVBDUSGROTYPE | Allowed Usage Type per Rental Object Type |
| VIBDPLANPS | Plan Pooled Spaces |
| VIBDRO | Rental Object |
| VIBDBU | Building |
| TIVBDARFUNCT | Function per Architectural Object (Text) |
| TIVBDUSGPSRS | Allowed Usage Type for Rental Spaces in Pooled Spaces |
| TIVUSGTYPE | External Usage Types |
| TIVBDVACREAS | Vacancy Reason |
| TIVBDUSGRPT | Texts for Usage Group |
| TIVBDMEASSTRC | Measurement Structure |
| TIVBDMEASAOFU | Measurement Types: Settings per Arch. Object Type and Funct. |
| VIBDOBJASS | Object Assignment |
| TIVDBSYNCHRULE | Synchronization of Objects |
| VIBDPR | Land |
| TIVBDMEAST | Measurement Type - Texts |
| VIBDOBJASSIFRS | Valuation Data for Contract Objects |
| TIVBDLOCHIER | Assignment of Hierarchical Locations to Location Structure |
| VIBDAO | Architectural Object |
| TIVBDPMAO | PM Integration: Settings for Each Architect. Object Type |
| VIBDLOCHIER | Hierarchical Object Location |
| TIVBDUSGRP | Usage Group |
| TIVBDCNSUBTYPE | Object Type |
| VIEXSET | SETs |
| TIVBDMEASMETER | Characteristic per Measurement Type |
| TIVBDUTM | Main Usage Type |
| TIVBDBUC | Condition of Building |
| TIVBDOBJASSTYPE | Object Assignment Type |
| TIVBDLOCSYST | Hierarchical Location Structure - Texts |
| TIVBDMEASRO | Measurement Type: Settings per Usage Type |
| TIVBDMAREA | Maintenance District |
| VIBDARNUMRANGE | Number Range |
| VIBDAOFUNCTION | Architectural Object: Function |
| TIVBDGIS | External Graphics System |
| VIBDNODE | Higher-Level Architectural Object |
| TIVBDMEASCALC | Derivable Measurement Type |
| VIBDEXTREL | Assignment of RE Object to Ext. Graphical System (Not Used) |
| TIVBDAOIDPART | Generation Rule for AOID |
| TIVBDUSTYREL | Allowed Usage Types per Usage Group |
| VIBDOBJRELPART | Object Relationship A/U Object <-> A/U Object: Percent |
| TIVBDICT | Infrastructure Characteristics (Surroundings) - Texts |
| TIVBDVACEVENTT | Event That Influences Vacancy/Occupancy (Text) |
| TIVBDOBJASS | Allowed Object Assignment Type per Object Type |
| VIBDMEAS | Measurement |
| TIVBDROFSTATUS | Field Status of Rental Object per Usage Type |
| VIBDCHARACT | Fixtures/Fittings |
| TIVBDFLOOR | Floor |
| TIVBDICTB | Infrastructure Characteristics: Time Basis |
| VIBDOBJREL | Object Relationship A/U Object <-> A/U Object |
| TIVBDICTBT | Infrastructure Characteristics: Time Basis - Texts |
| TIVBDMEASRELSTRC | Measurement Structure for Measurement Type |
| TIVBDGIST | External Graphics System (Text) |
| VIBDOBJGRP | Object Group |
| VIBDROOCC | Occupancy History |
| TIVBDNEIGHBORH | Neighborhood |