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

38 columns | Print definition?ERP 6.0  | EILAN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBasic Functions
1CONUForeign Trade: Duty Rate Numbers and Commodity Codes2EILANImporting country for import processing in foreign tradenvarchar30
2T610AImport Processing: Anti-dumping Code2EILANImporting country for import processing in foreign tradenvarchar30
3T610ATImport Processing: Anti-dumping Code Descriptions3EILANImporting country for import processing in foreign tradenvarchar30
4T610DImport Processing: Pharmaceutical Products Code2EILANImporting country for import processing in foreign tradenvarchar30
5T610DTImport Processing: Pharmaceutical Products Code Descriptions3EILANImporting country for import processing in foreign tradenvarchar30
6T610FAImport Processing: Anti-dumping Code Determination2EILANImporting country for import processing in foreign tradenvarchar30
7T610FDImport Processing: Pharmaceut. Products Code Determination2EILANImporting country for import processing in foreign tradenvarchar30
8T610FEImport Processing: Import Verification Doc. Determination2EILANImporting country for import processing in foreign tradenvarchar30
9T610FKImport Processing: Customs Quota Code Determination2EILANImporting country for import processing in foreign tradenvarchar30
10T610FLImport Processing: Third-country Duty Rate Determination2EILANImporting country for import processing in foreign tradenvarchar30
11T610FPImport Processing: Preferential Duty Rate Determination2EILANImporting country for import processing in foreign tradenvarchar30
12T610FSImport Processing: Customs Exemption Determination2EILANImporting country for import processing in foreign tradenvarchar30
13T610KImport Processing: Customs Quota Codes2EILANImporting country for import processing in foreign tradenvarchar30
14T610KPForeign Trade: Import Processing: Quota or Ceiling Number2EILANImporting country for import processing in foreign tradenvarchar30
15T610KPTForeign Trade: Import Processing: Quota or Ceiling Number3EILANImporting country for import processing in foreign tradenvarchar30
16T610KTImport Processing: Customs Quota Code Descriptions3EILANImporting country for import processing in foreign tradenvarchar30
17T610LGForeign Trade: Country Groups for Import Processing2EILANImporting country for import processing in foreign tradenvarchar30
18T610LGTForeign Trade: Country Groups for Import Processing - Descr.3EILANImporting country for import processing in foreign tradenvarchar30
19T610LGZForeign Trade: Assignment of Countries to Country Groups2EILANImporting country for import processing in foreign tradenvarchar30
20T610PAForeign Trade: Preference Type2EILANImporting country for import processing in foreign tradenvarchar30
21T610PATForeign Trade: Preference Type - Description3EILANImporting country for import processing in foreign tradenvarchar30
22T610RImport Processing: Reference Countries2EILANImporting country for import processing in foreign tradenvarchar30
23T610UForeign Trade: Upload: Duty Rate Types, Legal Regulations2EILANImporting country for import processing in foreign tradenvarchar30
24T612AForeign Trade/Customs: Electronic Procedure: Duty Types2EILANImporting country for import processing in foreign tradenvarchar30
25T612ATFT/Customs: Elect. Procedure: Duty Type - Means of Transport3EILANImporting country for import processing in foreign tradenvarchar30
26T612BFT/Customs: Electr. Procedure: Type of means of transport2EILANImporting country for import processing in foreign tradenvarchar30
27T612BTFT/Customs: Elect. Procedure: Type of Means of Transport - D3EILANImporting country for import processing in foreign tradenvarchar30
28T612GForeign Trade/Customs: Electr. procedures: Duty type group.2EILANImporting country for import processing in foreign tradenvarchar30
29T612GTForeign Trade/Customs: Electr. procedures: Duty type group.3EILANImporting country for import processing in foreign tradenvarchar30
30T612KFT/Customs: Electr. Procedure: Duty Type - Condition type2EILANImporting country for import processing in foreign tradenvarchar30
31T612NFT/Customs: Electr. procedures: Type of identity of goods2EILANImporting country for import processing in foreign tradenvarchar30
32T612NTFT/Customs: Electr. Proced.: Type of ident. of goods - descr3EILANImporting country for import processing in foreign tradenvarchar30
33T612PFT/Customs: Electr. Procedure: Type of Shipping Unit2EILANImporting country for import processing in foreign tradenvarchar30
34T612PTFT/Customs: Electr. procedure: Shp. unit type - Description3EILANImporting country for import processing in foreign tradenvarchar30
35T612SForeign Trade/Customs: Electr. Procedure: Status2EILANImporting country for import processing in foreign tradenvarchar30
36T612STFT/Customs: Electr. procedure: Status - Description3EILANImporting country for import processing in foreign tradenvarchar30
37T612VForeign Trade/Customs: Electr. Procedure2EILANImporting country for import processing in foreign tradenvarchar30
38T612VTFT/Customs: Electr. procedure - Description3EILANImporting country for import processing in foreign tradenvarchar30