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

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Cross-Application Components :: CAD Integration
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TCIS421Control Parameters for the CAD Dialog InterfaceCAD Integration
SQL:  selectupdate insert create

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

SELECT MANDT, CISKY, CPICD, CPICP, DELIM, DELHX, MCMAX, OUTLN, TXTLN, SORTK, STRLN, MEXTV, MINTV, DEXTV, DINTV, MRESV, MCART, MKLAT, DKLAT, MM01M, MM02M, CS01M, CS02M, CV01M, CV02M, CV04M, IE01M, IE02M, IL01M, IL02M, IW21M, IW22M, CC01M, CC02M, AEXTV, AINTV, EEXTV, EINTV, TEXTV, TINTV, PEXTV, PINTV FROM TCIS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2CISKYKey for table TCISnvarchar30CHAR(N' ')NoCISKY Allow NULL? 
3CPICDDelete log table TCPIC when program is startedchar10CHAR(N' ')NoCPICD Allow NULL? 
4CPICPCAD communication log in table TCPICchar10CHAR(N' ')NoCPICP Allow NULL? 
5DELIMSeparator in Data Stringschar10CHAR(N' ')NoDELIM Allow NULL? 
6DELHXSeparator character in data strings (hex code)nvarchar20CHAR(N' ')NoDELHX Allow NULL? 
7MCMAXMaximum number of matchcode recordsnvarchar50NUMC(N'00000')NoMCMAX Allow NULL? 
8OUTLNLine length of CAD output table for screen displaynvarchar30NUMC(N'000')NoOUTLN Allow NULL? 
9TXTLNLine length of standard textnvarchar30NUMC(N'000')NoTXTLN Allow NULL? 
10SORTKSort criterion for items without an item numberchar10CHAR(N' ')NoSORTC Allow NULL? 
11STRLNMaximum length of CAD send stringnvarchar50NUMC(N'00000')NoSTRLN Allow NULL? 
12MEXTVIndicator for external material number assignment from CADchar10CHAR(N' ')NoMEXTV Allow NULL? 
13MINTVIndicator for internal material number assignment from CADchar10CHAR(N' ')NoMINTV Allow NULL? 
14DEXTVIndicator for internal document number assignment from CADchar10CHAR(N' ')NoDEXTV Allow NULL? 
15DINTVIndicator for internal document number assignment from CADchar10CHAR(N' ')NoDINTV Allow NULL? 
16MRESVIndicator for material number reservation from CADchar10CHAR(N' ')NoMRESV Allow NULL? 
17MCARTMaterial typenvarchar40CHAR(N' ')NoT134MCART Allow NULL? 
18MKLATDefault class type for displaying material classif. datanvarchar30CHAR(N' ')NoTCLAMKLAT Allow NULL? 
19DKLATDefault class type for displaying document classif. datanvarchar30CHAR(N' ')NoTCLADKLAT Allow NULL? 
20MM01MProcess mode for transaction MM01char10CHAR(N' ')NoMM01M Allow NULL? 
21MM02MProcess mode for transaction MM02char10CHAR(N' ')NoMM02M Allow NULL? 
22CS01MProcess mode for transaction CS01char10CHAR(N' ')NoCS01M Allow NULL? 
23CS02MProcess mode for transaction CS02char10CHAR(N' ')NoCS02M Allow NULL? 
24CV01MProcess mode for transaction CV01char10CHAR(N' ')NoCV01M Allow NULL? 
25CV02MProcess mode for transaction CV02char10CHAR(N' ')NoCV02M Allow NULL? 
26CV04MProcessing mode for transaction CV04char10CHAR(N' ')NoCV04M Allow NULL? 
27IE01MProcessing mode for transaction IE01char10CHAR(N' ')NoIE01M Allow NULL? 
28IE02MProcessing mode for transaction IE02char10CHAR(N' ')NoIE02M Allow NULL? 
29IL01MProcessing mode for transaction IL01char10CHAR(N' ')NoIL01M Allow NULL? 
30IL02MProcessing mode for transaction IL02char10CHAR(N' ')NoIL02M Allow NULL? 
31IW21MProcessing mode for transaction IW21char10CHAR(N' ')NoIW21M Allow NULL? 
32IW22MProcessing mode for transaction IW22char10CHAR(N' ')NoIW22M Allow NULL? 
33CC01MProcessing mode for transaction CC01char10CHAR(N' ')NoCC01M Allow NULL? 
34CC02MProcessing mode for transaction CC02char10CHAR(N' ')NoCC02M Allow NULL? 
35AEXTVIndicator: external change number assignment from CADchar10CHAR(N' ')NoAEXTV Allow NULL? 
36AINTVIndicator: internal change number assignment from CADchar10CHAR(N' ')NoAINTV Allow NULL? 
37EEXTVIndicator: external equipment number assignment from CADchar10CHAR(N' ')NoEEXTV Allow NULL? 
38EINTVIndicator: internal equipment number assignment from CADchar10CHAR(N' ')NoCA_EINTV Allow NULL? 
39TEXTVIndicator: external funct. loc. number assignment from CADchar10CHAR(N' ')NoCA_TEXTV Allow NULL? 
40TINTVIndicator: internal location number assignment from CADchar10CHAR(N' ')NoTINTV Allow NULL? 
41PEXTVIndicator: external notification number assignment from CADchar10CHAR(N' ')NoPEXTV Allow NULL? 
42PINTVIndicator: internal notification number assignment from CADchar10CHAR(N' ')NoPINTV_D Allow NULL? 
NamePrimaryUniqueTypeColumns
TCIS~0YesYesCLUSTEREDCISKY, MANDT