SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

78 tablesERP 6.0 

Real Estate Management :: Flexible Real Estate Management :: Basic Data
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TIVBDAOIDPART71Generation Rule for AOIDBasic Data
2ERP EHP76.0TIVBDARFSTATUS71Field Status per Architectural Object TypeBasic Data
3ERP EHP76.0TIVBDARFUNC31Function per Arch. Object TypeBasic Data
4ERP EHP76.0TIVBDARFUNCT61Function per Architectural Object (Text)Basic Data
5ERP EHP76.0TIVBDARNODE31Allowed Superordinate Architectural Object TypeBasic Data
6ERP EHP76.0TIVBDAROBJTYPE91Architectural Object TypeBasic Data
7ERP EHP76.0TIVBDAROBJTYPET41Object Type of Architecture (Text)Basic Data
8ERP EHP76.0TIVBDCHARACT91Fixtures and Fittings CharacteristicBasic Data
9ERP EHP76.0TIVBDCHARACTT41Fixtures and Fittings Characteristic (Text)Basic Data
10ERP EHP76.0TIVBDCTOBJ41Allowed Fixtures/Fittings Characteristics per Object TypeBasic Data
11ERP EHP76.0TIVBDGIS31External Graphics SystemBasic Data
12ERP EHP76.0TIVBDGIST51External Graphics System (Text)Basic Data
13ERP EHP76.0TIVBDIC51Infrastructure Characteristics (Surroundings)Basic Data
14ERP EHP76.0TIVBDICT41Infrastructure Characteristics (Surroundings) - TextsBasic Data
15ERP EHP76.0TIVBDICTB21Infrastructure Characteristics: Time BasisBasic Data
16ERP EHP76.0TIVBDICTBT41Infrastructure Characteristics: Time Basis - TextsBasic Data
17ERP EHP76.0TIVBDLOCHIER141Assignment of Hierarchical Locations to Location StructureBasic Data
18ERP EHP76.0TIVBDLOCITEM61Hierarchical Locations in Location StructureBasic Data
19ERP EHP76.0TIVBDLOCOBJ51Allowed Hier. Location Structures per Object TypeBasic Data
20ERP EHP76.0TIVBDLOCSYS31Hierarchical Location StructureBasic Data
21ERP EHP76.0TIVBDLOCSYST131Hierarchical Location Structure - TextsBasic Data
22ERP EHP76.0TIVBDMEAS271Measurement TypeBasic Data
23ERP EHP76.0TIVBDMEASAO51Measurement Type: Settings per Arch. Object TypeBasic Data
24ERP EHP76.0TIVBDMEASAOFU51Measurement Types: Settings per Arch. Object Type and Funct.Basic Data
25ERP EHP76.0TIVBDMEASCALC121Derivable Measurement TypeBasic Data
26ERP EHP76.0TIVBDMEASMETER51Characteristic per Measurement TypeBasic Data
27ERP EHP76.0TIVBDMEASRELSTRC31Measurement Structure for Measurement TypeBasic Data
28ERP EHP76.0TIVBDMEASRO51Measurement Type: Settings per Usage TypeBasic Data
29ERP EHP76.0TIVBDMEASROTYPE41Measurement Type: Settings per Rental Object TypeBasic Data
30ERP EHP76.0TIVBDMEASSTRC21Measurement StructureBasic Data
31ERP EHP76.0TIVBDMEASSTRCT51Measurement Structure - TextsBasic Data
32ERP EHP76.0TIVBDMEASSUM51Measurement Types - Totalling Within Architecture or UsageBasic Data
33ERP EHP76.0TIVBDMEAST51Measurement Type - TextsBasic Data
34ERP EHP76.0TIVBDMEASTRNS51Measurement Type: Transformation of Architecture to UsageBasic Data
35ERP EHP76.0TIVBDNEIGHBORH21NeighborhoodBasic Data
36ERP EHP76.0TIVBDOBJASS101Allowed Object Assignment Type per Object TypeBasic Data
37ERP EHP76.0TIVBDOBJASSTYPE61Object Assignment TypeBasic Data
38ERP EHP76.0TIVBDOBJASSTYPET31Type of Object Assignment (Text)Basic Data
39ERP EHP76.0TIVBDOBJASSUSES21Possible Object Type per Object Assignment TypeBasic Data
40ERP EHP76.0TIVBDOBJTYPEASS21Possible Object Assignment Type per Object TypeBasic Data
41ERP EHP76.0TIVBDPM71PM Integration: Settings per Object TypeBasic Data
42ERP EHP76.0TIVBDPMAO61PM Integration: Settings for Each Architect. Object TypeBasic Data
43ERP EHP76.0TIVBDPMNT51PM Integration: Notification Transaction per Object TypeBasic Data
44ERP EHP76.0TIVBDROFSTATUS71Field Status of Rental Object per Usage TypeBasic Data
45ERP EHP76.0TIVBDUSGFUNC31Functions of Objects of Usage ViewBasic Data
46ERP EHP76.0TIVBDUSGFUNCT51Name of Function of Objects of Usage ViewBasic Data
47ERP EHP76.0TIVBDUSGPSRS31Allowed Usage Type for Rental Spaces in Pooled SpacesBasic Data
48ERP EHP76.0TIVBDUSGROTYPE41Allowed Usage Type per Rental Object TypeBasic Data
49ERP EHP76.0TIVBDUSGRP21Usage GroupBasic Data
50ERP EHP76.0TIVBDUSGRPT41Texts for Usage GroupBasic Data
51ERP EHP76.0TIVBDUSTYREL41Allowed Usage Types per Usage GroupBasic Data
52ERP EHP76.0TIVBDVACEVENT31Event Influencing Vacancy/OccupancyBasic Data
53ERP EHP76.0TIVBDVACEVENTRS51Default Vacancy Reason per Vacancy EventBasic Data
54ERP EHP76.0TIVBDVACEVENTT31Event That Influences Vacancy/Occupancy (Text)Basic Data
55ERP EHP76.0TIVBDVACREAS91Vacancy ReasonBasic Data
56ERP EHP76.0TIVBDVACREAST51Vacancy Reason (Text)Basic Data
57ERP EHP76.0VIBDAO796Architectural ObjectBasic Data
58ERP EHP76.0VIBDARNUMRANGE91Number RangeBasic Data
59ERP EHP76.0VIBDBE445Business EntityBasic Data
60ERP EHP76.0VIBDBU974BuildingBasic Data
61ERP EHP76.0VIBDCHARACT171Fixtures/FittingsBasic Data
62ERP EHP76.0VIBDEXTREL81Assignment of RE Object to Ext. Graphical System (Not Used)Basic Data
63ERP EHP76.0VIBDINFRA81InfrastructureBasic Data
64ERP EHP76.0VIBDLOCHIER41Hierarchical Object LocationBasic Data
65ERP EHP76.0VIBDMEAS101MeasurementBasic Data
66ERP EHP76.0VIBDNODE82Higher-Level Architectural ObjectBasic Data
67ERP EHP76.0VIBDOBJASS192Object AssignmentBasic Data
68ERP EHP76.0VIBDOBJGRP62Object GroupBasic Data
69ERP EHP76.0VIBDOBJREL82Object Relationship A/U Object <-> A/U ObjectBasic Data
70ERP EHP76.0VIBDOBJRELPART112Object Relationship A/U Object <-> A/U Object: PercentBasic Data
71ERP EHP76.0VIBDPLANOBJ111Plan Pooled SpaceBasic Data
72ERP EHP76.0VIBDPLANOCC155Planned Occupancy of Usage ObjectsBasic Data
73ERP EHP76.0VIBDPLANPS91Plan Pooled SpacesBasic Data
74ERP EHP76.0VIBDPR654LandBasic Data
75ERP EHP76.0VIBDRO774Rental ObjectBasic Data
76ERP EHP76.0VIBDROOCC253Occupancy HistoryBasic Data
77ERP EHP76.0VIBDSUBOBJNUM51Current Number Level of SubobjectBasic Data
78ERP EHP76.0VIEXSET41SETsBasic Data