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

B1 9.2: Top 10 requests

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

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

47 columns | Print definition?B1 9.2  | DESCR

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