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

52 columns | Print definition?B1 9.3  | DESCR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AFMLTax Formula Master Table3DescrDescriptionnVarChar1000
2APFSPersonal Fields Setup - History15DescrDescriptionnVarChar2540
3CUFDUser Fields - Description4DescrDescriptionnVarChar800
4OBMIBrazilian Multi-Indexer4DescrDescriptionnVarChar2540
5OBSIBrazil String Indexer3DescrBeverage TableText160
6ODCIIntrastat Configuration4DescrDescriptionnVarChar2540
7OFMLTax Formula Master Table3DescrDescriptionnVarChar1000
8OGPCGovernment Payment Code3DescrDescriptionnVarChar1000
9OLLFLegal List Format3DescrElectronic File DescriptionnVarChar2500
10ONOANature of Assessee3DescrDescriptionnVarChar1000
11OPFSPersonal Fields Setup15DescrDescriptionnVarChar2540
12OSECSections3DescrDescriptionnVarChar300
13OTCXTax Code Determination30DescrDescriptionnVarChar2500
14OTFCTax Type Combination3DescrDescriptionnVarChar1000
15OTPATax Parameter Attributes3DescrDescriptionnVarChar300
16OTPRTax Return Values3DescrDescriptionnVarChar300
17OTPSTax Parameter3DescrDescriptionnVarChar1000
18OUSGUsage of Nota Fiscal14DescrUsage DescriptionnVarChar1000
19OUTBUser Tables2DescrDescriptionnVarChar300
20TCD1Key Fields for Determination7DescrDescriptionnVarChar1000
21UFD1User Fields - Values Definitions5DescrDescriptionnVarChar2540
TOPFinance
22AADTFixed Assets Account Determination - History2DescrDescriptionnVarChar1000
23ADPAFixed Asset Depreciation Areas - History2DescrDescriptionnVarChar1000
24ADTPFixed Assets Depreciation Types - History2DescrDescriptionnVarChar1000
25BOX3Box Definition - Choice4DescrDescriptionnVarChar2500
26OADGDepreciation Groups2DescrDescriptionnVarChar1000
27OADTFixed Assets Account Determination2DescrDescriptionnVarChar1000
28OAGSAsset Groups2DescrDescriptionnVarChar1000
29ODPAFixed Asset Depreciation Areas2DescrDescriptionnVarChar1000
30ODPPDepreciation Type Pools2DescrDescriptionnVarChar1000
31ODTPFixed Assets Depreciation Types2DescrDescriptionnVarChar1000
32OFYMFinancial Year Master3DescrDescriptionnVarChar300
33OTTRRemark Text Templates2DescrTemplate DescriptionnVarChar2540
TOPGeneral
34MFLDMetaData Tables Fields5DescrDescriptionnVarChar2500
35MTBLMetaData Tables4DescrDescriptionnVarChar2540
36MVALMetaData Tables Fields Vals5DescrDescriptionnVarChar2540
37OBFIBrazil Fuel Indexer3DescrDescriptionnVarChar2540
38OBNIBrazil Numeric Indexer3DescrBeverage BrandnVarChar2540
39OCPTCockpit Main Table4DescrDescriptionnVarChar1000
40OLNKHelp Links3DescrDescriptionnVarChar1000
41ONCPNew Cockpit Table11DescrDescriptionnVarChar1000
42OSESOSES2DescrSEFAZ Country DescriptionnVarChar1000
TOPInventory and Production
43ABINBin Location - History34DescrDescriptionnVarChar500
44ABSLWarehouse Sublevel - History4DescrDescriptionnVarChar500
45OBINBin Location34DescrDescriptionnVarChar500
46OBSLWarehouse Sublevel4DescrDescriptionnVarChar500
47OIPFLanded Costs11DescrRemarksnVarChar2500
TOPMRP
48OMSNMRP Scenarios3DescrDescriptionnVarChar1000
TOPReports
49AECMElectronic Communication Types or Protocols2DescrDescriptionnVarChar2000
50GDP1General Data Protection Wizard - Personal Fields Setup9DescrDescriptionnVarChar2540
51OECMElectronic Communication Types or Protocols2DescrDescriptionnVarChar2000
52OTRXTransformation Documents3DescrDescriptionnVarChar2500