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

44 columns | Print definition?ERP 6.0  | USMD_OBS_TXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1MD/MD______01Q0F Texts BDCSET6USMD_OBS_TXTObsolete Data Recordnvarchar10
2/1MD/MD______01V0F Texts SUBMPACK6USMD_OBS_TXTObsolete Data Recordnvarchar10
3/1MD/MD______01Z0F Texts CCOA6USMD_OBS_TXTObsolete Data Recordnvarchar10
4/1MD/MD______0230F Texts COA6USMD_OBS_TXTObsolete Data Recordnvarchar10
5/1MD/MD______0260F Texts FCRS7USMD_OBS_TXTObsolete Data Recordnvarchar10
6/1MD/MD______02C0F Texts BDC7USMD_OBS_TXTObsolete Data Recordnvarchar10
7/1MD/MD______02D0F Texts FRS7USMD_OBS_TXTObsolete Data Recordnvarchar10
8/1MD/MD______02J0F Texts ACCOUNT7USMD_OBS_TXTObsolete Data Recordnvarchar10
9/1MD/MD______02K0F Texts FSI7USMD_OBS_TXTObsolete Data Recordnvarchar10
10/1MD/MD______02P0F Texts FRSI8USMD_OBS_TXTObsolete Data Recordnvarchar10
11/1MD/MD______02R0F Texts TEXTITEM8USMD_OBS_TXTObsolete Data Recordnvarchar10
12/1MD/MD______03T0G Texts ACCOUNT7USMD_OBS_TXTObsolete Data Recordnvarchar10
13/1MD/MD______03W0G Texts FRS7USMD_OBS_TXTObsolete Data Recordnvarchar10
14/1MD/MD______03Z0G Texts FSI7USMD_OBS_TXTObsolete Data Recordnvarchar10
15/1MD/MD______0450G Texts BDC7USMD_OBS_TXTObsolete Data Recordnvarchar10
16/1MD/MD______0480G Texts CELEMG7USMD_OBS_TXTObsolete Data Recordnvarchar10
17/1MD/MD______0490G Texts CELEMH7USMD_OBS_TXTObsolete Data Recordnvarchar10
18/1MD/MD______04F0G Texts CELEM7USMD_OBS_TXTObsolete Data Recordnvarchar10
19/1MD/MD______04G0G Texts BDCSET6USMD_OBS_TXTObsolete Data Recordnvarchar10
20/1MD/MD______04J0G Texts CCTRH7USMD_OBS_TXTObsolete Data Recordnvarchar10
21/1MD/MD______04P0G Texts CCTRG7USMD_OBS_TXTObsolete Data Recordnvarchar10
22/1MD/MD______04T0G Texts CCTR7USMD_OBS_TXTObsolete Data Recordnvarchar10
23/1MD/MD______04W0G Texts COMPANY5USMD_OBS_TXTObsolete Data Recordnvarchar10
24/1MD/MD______0570G Texts PCTRH7USMD_OBS_TXTObsolete Data Recordnvarchar10
25/1MD/MD______05F0G Texts CONSCHAR6USMD_OBS_TXTObsolete Data Recordnvarchar10
26/1MD/MD______05I0G Texts FSIH7USMD_OBS_TXTObsolete Data Recordnvarchar10
27/1MD/MD______05N0G Texts TRANSTYPE6USMD_OBS_TXTObsolete Data Recordnvarchar10
28/1MD/MD______05O0G Texts PCTR7USMD_OBS_TXTObsolete Data Recordnvarchar10
29/1MD/MD______05U0G Texts SUBMPACK6USMD_OBS_TXTObsolete Data Recordnvarchar10
30/1MD/MD______05W0G Texts PCTRG7USMD_OBS_TXTObsolete Data Recordnvarchar10
31/1MD/MD______0630G Texts FSIT8USMD_OBS_TXTObsolete Data Recordnvarchar10
32/1MD/MD______0640G Texts FRSI8USMD_OBS_TXTObsolete Data Recordnvarchar10
33/1MD/MD______0650G Texts CONSGRP7USMD_OBS_TXTObsolete Data Recordnvarchar10
34/1MD/MD______0690G Texts CONSGRPH7USMD_OBS_TXTObsolete Data Recordnvarchar10
35/1MD/MD______06C0G Texts CONSUNIT7USMD_OBS_TXTObsolete Data Recordnvarchar10
36/1MD/MD______06NMM Texts MATERIAL5USMD_OBS_TXTObsolete Data Recordnvarchar10
37/1MD/MD______06ZBP Texts BP_SUBHRY4USMD_OBS_TXTObsolete Data Recordnvarchar10
38/1MD/MD______076BP Texts BP_HRCHY4USMD_OBS_TXTObsolete Data Recordnvarchar10
39/1MD/MD______077BP Texts BP_HEADER4USMD_OBS_TXTObsolete Data Recordnvarchar10
40/1MD/MD______0ADZ5 Texts FAMNAME4USMD_OBS_TXTObsolete Data Recordnvarchar10
41/1MD/MD______0AKZ5 Texts ZRECORD5USMD_OBS_TXTObsolete Data Recordnvarchar10
42/1MD/MD______0AUZ6 Texts FAMNAME4USMD_OBS_TXTObsolete Data Recordnvarchar10
43/1MD/MD______0B1Z6 Texts ZRECORD5USMD_OBS_TXTObsolete Data Recordnvarchar10
44/SMD/MD_____0004SID-Tabelle fuer Obsolete3USMD_OBS_TXTObsolete Data Recordnvarchar10