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

37 columns | Print definition?ERP 6.0  | USMD_ACREATED_BY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1MD/MD______01I0F Attributes ACCCCDET8USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
2/1MD/MD______01U0F Attributes SUBMPACK6USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
3/1MD/MD______01W0F Attributes BDCSET6USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
4/1MD/MD______0200F Attributes CCOA6USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
5/1MD/MD______0240F Attributes COA6USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
6/1MD/MD______0280F Attributes FCRS7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
7/1MD/MD______02B0F Attributes BDC7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
8/1MD/MD______02F0F Attributes FRS7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
9/1MD/MD______02H0F Attributes ACCOUNT7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
10/1MD/MD______02L0F Attributes FSI7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
11/1MD/MD______02Q0F Attributes FRSI8USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
12/1MD/MD______02V0G Attributes ACCCCDET8USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
13/1MD/MD______03U0G Attributes FSI7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
14/1MD/MD______03V0G Attributes ACCOUNT7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
15/1MD/MD______03Y0G Attributes FRS7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
16/1MD/MD______0440G Attributes BDC7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
17/1MD/MD______0460G Attributes CELEMG7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
18/1MD/MD______04B0G Attributes CELEMH7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
19/1MD/MD______04C0G Attributes CELEM7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
20/1MD/MD______04I0G Attributes CCTRH7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
21/1MD/MD______04M0G Attributes BDCSET6USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
22/1MD/MD______04N0G Attributes CCTRG7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
23/1MD/MD______04S0G Attributes CCTR7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
24/1MD/MD______0540G Attributes PCTRH7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
25/1MD/MD______0550G Attributes COMPANY6USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
26/1MD/MD______0580G Attributes CONSCHAR6USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
27/1MD/MD______05E0G Attributes PCTRG7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
28/1MD/MD______05K0G Attributes FSIH7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
29/1MD/MD______05L0G Attributes TRANSTYPE6USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
30/1MD/MD______05Q0G Attributes PCTR7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
31/1MD/MD______05S0G Attributes SUBMPACK6USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
32/1MD/MD______0610G Attributes FRSI8USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
33/1MD/MD______0660G Attributes CONSGRP7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
34/1MD/MD______06A0G Attributes CONSGRPH7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
35/1MD/MD______06D0G Attributes CONSUNIT7USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
36/1MD/MD______07PMM Attributes MATERIAL5USMD_ACREATED_BYUser Name in User Master Recordnvarchar120
TOPApplication Framework
37USMD1211Change Request: Attachments4USMD_ACREATED_BYUser Name in User Master Recordnvarchar120