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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

53 columns | Print definition?ERP 6.0  | SGRNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item47SGRNRProperty Number for BEnvarchar80
2/OPT/VIM_TITEMDocument Item47SGRNRProperty Number for BEnvarchar80
3REMOB_T_CONDAssign Condition Type & Measurement Type5SGRNRNumber of Landnvarchar80
4REMOB_T_LOGVisit History6SGRNRNumber of Landnvarchar80
5VIXCITCADROTemporary rental object data26SGRNRNumber of Landnvarchar80
6VIYCPGParticipation Group for CAM5SGRNRNumber of Landnvarchar80
7YVIM_1ITEMDocument Item47SGRNRProperty Number for BEnvarchar80
TOPBasic Data
8VIBDPLANPSPlan Pooled Spaces6SGRNRNumber of Landnvarchar80
9VIBDPRLand5SGRNRNumber of Landnvarchar80
10VIBDRORental Object25SGRNRNumber of Landnvarchar80
TOPFinancial Accounting
11/OPT/VIM_1ITEMDocument Item47SGRNRProperty Number for BEnvarchar80
12KMZEIFI: Account Assignment Model Item Information82SGRNRProperty Number for BEnvarchar80
13KOMUAccount Assignment Templates for G/L Account Items82SGRNRProperty Number for BEnvarchar80
TOPFlexible Real Estate Management
14VICAINTRENOAssignment of INTRENO / OBJNR / IMKEY10SGRNRNumber of Landnvarchar80
TOPMigration
15VIGWARARFLSchlüssel archivierter arch. Flächen5SGRNRTontin numero - talousyksikkönvarchar80
16VIGWARFLImmobilien gew.: Architektonische Fläche (statischer Teil)17SGRNRTontin numero - talousyksikkönvarchar80
17VIGWFLGGZUImmobilien gew.: Fl.-Zuordnung zu Gebäude oder Grundstück8SGRNRTontin numero - talousyksikkönvarchar80
18VIGWVMFLZImmobilien gew.:Stammdaten Vermietfldche (zeitabh.Teil)18SGRNRTontin numero - talousyksikkönvarchar80
19VIGWVOBWImmobilien gew.: Vorbelegung d.Konditionen f. BuKr/WE/GE/G5SGRNRTontin numero - talousyksikkönvarchar80
20VIGWVOBW_UPDImmobilien gew.: Änderungsprotokoll der Konditionsvorbeleg.5SGRNRTontin numero - talousyksikkönvarchar80
21VIGW_VOBWCRE Ph.2.1 neu: Vorbelegung d.Konditionen f. BuKr/WE/GE/GR5SGRNRTontin numero - talousyksikkönvarchar80
22VIGW_VOBW_UPDImmobilien gew.: Änderungsprotokoll der Konditionsvorbeleg.5SGRNRTontin numero - talousyksikkönvarchar80
TOPProfit Center Accounting
23KE1_WU_IM_ITEMPCA Where-Used List: Itemization for Real Estate14SGRNRProperty Number for BEnvarchar80
TOPReal Estate Management
24S401RE standard analysis partner15SGRNRProperty Number for BEnvarchar80
25S404Properties52SGRNRProperty Number for BEnvarchar80
26S406Rental units17SGRNRProperty Number for BEnvarchar80
27S407Rental agreements88SGRNRProperty Number for BEnvarchar80
28S408Land registers89SGRNRProperty Number for BEnvarchar80
29VIAKBSEGDocument Line Item from SCS for Interface100SGRNRProperty Number for BEnvarchar80
30VIARMVKey for archived lease-outs6SGRNRProperty Number for BEnvarchar80
31VIAROBJArchived real estate objects11SGRNRProperty Number for BEnvarchar80
32VIBEPPFlow data - Planned items for real estate management74SGRNRProperty Number for BEnvarchar80
33VIGBSTDReal estate register of land register18SGRNRProperty Number for BEnvarchar80
34VILICICI Historical Data8SGRNRProperty Number for BEnvarchar80
35VILIDICI Historical Data of D-Building7SGRNRProperty Number for BEnvarchar80
36VIMI01Rental unit - Master data5SGRNRProperty Number for BEnvarchar80
37VIOB02Property master data4SGRNRProperty Number for BEnvarchar80
38VIOB06Property option rate4SGRNRProperty Number for BEnvarchar80
39VIOB15Areas for properties4SGRNRProperty Number for BEnvarchar80
40VIOB24Rental units per usage type (plan)4SGRNRProperty Number for BEnvarchar80
41VIOB27Relationship between properties and buildings4SGRNRProperty Number for BEnvarchar80
42VIOB28OLD, replaced by VIOB39 for 3.07SGRNRProperty Number for BEnvarchar80
43VIOB29OLD, replaced by VIOB39 for 3.07SGRNRProperty Number for BEnvarchar80
44VIOB35Productive Holdings7SGRNRProperty Number for BEnvarchar80
45VIOB38Relationship between Real Estate objects and SAP-PS7SGRNRProperty Number for BEnvarchar80
46VIOB39Relationship between Real Estate objects and SAP-PM7SGRNRProperty Number for BEnvarchar80
47VIRPS406Rental units17SGRNRProperty Number for BEnvarchar80
48VIRPS407Rental agreements88SGRNRProperty Number for BEnvarchar80
49VIVW05Management contract: Managed objects10SGRNRProperty Number for BEnvarchar80
50VIVW08Events for management contracts11SGRNRProperty Number for BEnvarchar80
51VIWEGRRelation table between property and assets4SGRNRProperty Number for BEnvarchar80
52VIZNRNAssignment: Real Estate numbers <-> IMKEY <-> INTRENO6SGRNRProperty Number for BEnvarchar80
TOPReal Estate Slovakia
53VIXCSKSDANPProperty Tax - Master data6SGRNRNumber of Landnvarchar80