SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

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