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

31 columns | Print definition?ERP 6.0  | GEGRU

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBasic Functions
1ECCNLegal Control: Foreign Percentages4GEGRULegal regulation for legal controlnvarchar20
2EMBKLegal Control: License Master - Header Data4GEGRULegal regulation for legal controlnvarchar20
3FSLSIForeign Trade: Legal Control - Sanct. Party List - Indices9GEGRULegal regulation for legal controlnvarchar20
4T606Legal Control: License Types2GEGRULegal regulation for legal controlnvarchar20
5T606ALegal Control: Departure Country / Legal Regulations3GEGRULegal regulation for legal controlnvarchar20
6T606ASLegal Control: Export Control Class - Commodity Code2GEGRULegal regulation for legal controlnvarchar20
7T606BLegal Control: Grouping Materials2GEGRULegal regulation for legal controlnvarchar20
8T606CLegal Control: Import code numbers for license2GEGRULegal regulation for legal controlnvarchar20
9T606DLegal Control: Special Characteristic Code for Goods2GEGRULegal regulation for legal controlnvarchar20
10T606DTLegal Control: Special Char. Code for Goods - Description3GEGRULegal regulation for legal controlnvarchar20
11T606ELegal Control: Grouping Destination Countries2GEGRULegal regulation for legal controlnvarchar20
12T606GLegal Control: Legal Regulations2GEGRULegal regulation for legal controlnvarchar20
13T606HLegal Control: Export Control Classes2GEGRULegal regulation for legal controlnvarchar20
14T606ILegal Control: Export Control Class / Grouping2GEGRULegal regulation for legal controlnvarchar20
15T606LLegal Control: Country Classification by Destination Ctry3GEGRULegal regulation for legal controlnvarchar20
16T606MLegal Control: Product Classification by Destinat. Ctry3GEGRULegal regulation for legal controlnvarchar20
17T606NLegal Control: Product Classification by Country Grouping2GEGRULegal regulation for legal controlnvarchar20
18T606RLegal Control: Legal Regulation Descriptions3GEGRULegal regulation for legal controlnvarchar20
19T606SLegal Control: Grouping of Dest. Countries - Descriptions3GEGRULegal regulation for legal controlnvarchar20
20T606TLegal Control: License Type Descriptions3GEGRULegal regulation for legal controlnvarchar20
21T606ULegal Control: Grouping Descriptions3GEGRULegal regulation for legal controlnvarchar20
22T606VLegal Control: Export Control Class Descriptions3GEGRULegal regulation for legal controlnvarchar20
23T606WLegal Control: Materials for license2GEGRULegal regulation for legal controlnvarchar20
24T606XLegal Control: Destination Countries for License2GEGRULegal regulation for legal controlnvarchar20
25T606YLegal Control: Export Control Classes for License2GEGRULegal regulation for legal controlnvarchar20
26T606ZLegal Control: Partners - Customers for License2GEGRULegal regulation for legal controlnvarchar20
27T606ZKLegal Control: Partners - Vendors License2GEGRULegal regulation for legal controlnvarchar20
28T608LLegal Control: Sanctioned Party Lists - List Type3GEGRULegal regulation for legal controlnvarchar20
29T609PForeign Trade: Communication: Control Printing of FT Docs23GEGRULegal regulation for legal controlnvarchar20
30VBEXSD Document: Export Control: Data at Item Level4GEGRULegal regulation for legal controlnvarchar20
TOPMaterial Master
31MAEXMaterial Master: Legal Control4GEGRULegal regulation for legal controlnvarchar20