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

58 columns | Print definition?ERP 6.0  | SGENR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item25SGENRBuilding Numbernvarchar80
2/OPT/VIM_TITEMDocument Item25SGENRBuilding Numbernvarchar80
3REMOB_T_CONDAssign Condition Type & Measurement Type4SGENRNumber of Buildingnvarchar80
4REMOB_T_LOGVisit History5SGENRNumber of Buildingnvarchar80
5VIXCITCADROTemporary rental object data27SGENRNumber of Buildingnvarchar80
6VIYCPGParticipation Group for CAM4SGENRNumber of Buildingnvarchar80
7YVIM_1ITEMDocument Item25SGENRBuilding Numbernvarchar80
TOPBasic Data
8VIBDBUBuilding5SGENRNumber of Buildingnvarchar80
9VIBDPLANPSPlan Pooled Spaces5SGENRNumber of Buildingnvarchar80
10VIBDRORental Object26SGENRNumber of Buildingnvarchar80
TOPFinancial Accounting
11/OPT/VIM_1ITEMDocument Item25SGENRBuilding Numbernvarchar80
12KMZEIFI: Account Assignment Model Item Information81SGENRBuilding Numbernvarchar80
13KOMUAccount Assignment Templates for G/L Account Items81SGENRBuilding Numbernvarchar80
TOPFlexible Real Estate Management
14VICAINTRENOAssignment of INTRENO / OBJNR / IMKEY11SGENRNumber of Buildingnvarchar80
TOPLogistics - General
15HBSAFFAffected building in Home Building Solution4SGENRBuilding Numbernvarchar80
16HBSFLSFit-List4SGENRBuilding Numbernvarchar80
17HBSFSPHelp dummy table4SGENRBuilding Numbernvarchar80
TOPMigration
18VIGWARARFLSchlüssel archivierter arch. Flächen4SGENRRakennuksen numeronvarchar80
19VIGWARARRASchlüssel archivierter arch. Räume4SGENRRakennuksen numeronvarchar80
20VIGWARFLImmobilien gew.: Architektonische Fläche (statischer Teil)18SGENRRakennuksen numeronvarchar80
21VIGWARRAImmobilien gew.: Architektonischer Raum (statischer Teil)16SGENRRakennuksen numeronvarchar80
22VIGWFLGGZUImmobilien gew.: Fl.-Zuordnung zu Gebäude oder Grundstück9SGENRRakennuksen numeronvarchar80
23VIGWRAGEZUImmobilien gew.: Ra-Zuordnung zu Gebäude oder Gebäudeteil8SGENRRakennuksen numeronvarchar80
24VIGWVMFLZImmobilien gew.:Stammdaten Vermietfldche (zeitabh.Teil)17SGENRRakennuksen numeronvarchar80
25VIGWVOBWImmobilien gew.: Vorbelegung d.Konditionen f. BuKr/WE/GE/G4SGENRRakennuksen numeronvarchar80
26VIGWVOBW_UPDImmobilien gew.: Änderungsprotokoll der Konditionsvorbeleg.4SGENRRakennuksen numeronvarchar80
27VIGW_VOBWCRE Ph.2.1 neu: Vorbelegung d.Konditionen f. BuKr/WE/GE/GR4SGENRRakennuksen numeronvarchar80
28VIGW_VOBW_UPDImmobilien gew.: Änderungsprotokoll der Konditionsvorbeleg.4SGENRRakennuksen numeronvarchar80
TOPProfit Center Accounting
29KE1_WU_IM_ITEMPCA Where-Used List: Itemization for Real Estate15SGENRBuilding Numbernvarchar80
TOPReal Estate Management
30S401RE standard analysis partner16SGENRBuilding Numbernvarchar80
31S405Building15SGENRBuilding Numbernvarchar80
32S406Rental units18SGENRBuilding: numbernvarchar80
33S407Rental agreements78SGENRBuilding Numbernvarchar80
34VIAKBSEGDocument Line Item from SCS for Interface99SGENRBuilding Numbernvarchar80
35VIARMVKey for archived lease-outs7SGENRBuilding Numbernvarchar80
36VIAROBJArchived real estate objects12SGENRBuilding Numbernvarchar80
37VIBEPPFlow data - Planned items for real estate management75SGENRBuilding Numbernvarchar80
38VIMI01Rental unit - Master data6SGENRBuilding Numbernvarchar80
39VIOB03Real estate building master4SGENRBuilding Numbernvarchar80
40VIOB04Buildings: Fixtures and fittings characteristics4SGENRBuilding Numbernvarchar80
41VIOB05Building option rate4SGENRBuilding Numbernvarchar80
42VIOB08Room4SGENRBuilding Numbernvarchar80
43VIOB14Areas for Building (Obsolete)4SGENRBuilding Numbernvarchar80
44VIOB20Fixtures and fittings objects for building4SGENRBuilding Numbernvarchar80
45VIOB22Rooms7SGENRBuilding Numbernvarchar80
46VIOB24Rental units per usage type (plan)5SGENRBuilding Numbernvarchar80
47VIOB27Relationship between properties and buildings5SGENRBuilding Numbernvarchar80
48VIOB28OLD, replaced by VIOB39 for 3.08SGENRBuilding Numbernvarchar80
49VIOB29OLD, replaced by VIOB39 for 3.08SGENRBuilding Numbernvarchar80
50VIOB38Relationship between Real Estate objects and SAP-PS8SGENRBuilding Numbernvarchar80
51VIOB39Relationship between Real Estate objects and SAP-PM8SGENRBuilding Numbernvarchar80
52VIRPS405Building15SGENRBuilding Numbernvarchar80
53VIRPS406Rental units18SGENRBuilding: numbernvarchar80
54VIRPS407Rental agreements78SGENRBuilding Numbernvarchar80
55VIVW05Management contract: Managed objects11SGENRBuilding Numbernvarchar80
56VIVW08Events for management contracts12SGENRBuilding Numbernvarchar80
57VIWEGBRelation table between buildings and assets4SGENRBuilding Numbernvarchar80
58VIZNRNAssignment: Real Estate numbers <-> IMKEY <-> INTRENO7SGENRBuilding Numbernvarchar80