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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Reports
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.3AEC6151Electronic Protocol DI API PropertiesReports
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT Code, GenType, MapID, MapID_WS, TestMode, LogInstanc, ParamLogic, ParamStr, ParamLText, ActStatus, ParamUqc, ParamInt, ParamPAC, ParamTgl, ParamMon FROM AEC6

TOPB1 9.3  | AEC6 COLUMNS

ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1CodeCommunication Type or Protocolint110OECM0=Invalid, 1=GEN, 2=EET, 3=CFDI, 4=FPA, 5=MTD Allow NULL? 
2GenTypeGeneration Typechar10NG=Generate, L=Generate - Later, N=Not Relevant Allow NULL? 
3MapIDElectronic Document Format Mappingint110OLLF Allow NULL? 
4MapID_WSeDoc Web Service Format Mappingint110OLLF Allow NULL? 
5TestModeTesting Mode Flagchar10NN=No, Y=Yes Allow NULL? 
6LogInstancLog Instanceint60 Allow NULL? 
7ParamLogicLogic Value Parameterchar10NN=No, Y=Yes Allow NULL? 
8ParamStrString Value Parameternvarchar2540 Allow NULL? 
9ParamLTextLong Text Parametertext160
10ActStatusAction Statuschar10NA=Authorized, B=Aborted, C=Canceled, D=Denied, E=Error, G=Warning, I=In Process, J=Rejected, M=Imported, N=New, O=OK, P=Pending, Q=Queued, R=Document Error, S=Sent, W=Waiting Allow NULL? 
11ParamUqcUser Query Categoryint110OQCN Allow NULL? 
12ParamIntInteger Numberint110 Allow NULL? 
13ParamPACAuthority Codenvarchar160OPAC Allow NULL? 
14ParamTglToggle Value Parameterchar10 Allow NULL? 
15ParamMonMoney Value Parameternum196 Allow NULL? 

TOPB1 9.3  | AEC6 INDEXES

NamePrimaryUniqueTypeColumns
PRIMARYNoYesCode, LogInstanc