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

59 columns | Print definition?ERP 6.0  | AS4VERS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000201DD02L6AS4VERSnvarchar40
2/1CADMC/00000202DD02T7AS4VERSnvarchar40
3/1CADMC/00000203DD08L7AS4VERSnvarchar40
4/1CADMC/00000204DD02L6AS4VERSnvarchar40
5/1CADMC/00000205DD02T7AS4VERSnvarchar40
6/1CADMC/00000206DD08L7AS4VERSnvarchar40
7/1CADMC/00000427DD04T7AS4VERSnvarchar40
8/1CADMC/00000430DD07T8AS4VERSnvarchar40
9/1CADMC/00001431DD02L6AS4VERSnvarchar40
10/1CADMC/00001432DD02T7AS4VERSnvarchar40
11/1CADMC/00001433DD08L7AS4VERSnvarchar40
12CNVCMIS_A_1_INDXIndx Table(CMIS)7AS4VERSVersion of the entry (not used)nvarchar40
13CNVCMIS_A_1_MCIDMCID type Repository Analysis7AS4VERSVersion of the entry (not used)nvarchar40
14CNVCMIS_A_1_MCIFMCIF type Repository Analysis8AS4VERSVersion of matchcode IDnvarchar40
15CNVCMIS_A_1_MCOBMCOB type Repository Analysis6AS4VERSVersion of the entry (not used)nvarchar40
16CNVCMIS_A_1_MCOFMCOF type Repository Analysis7AS4VERSVersion of viewnvarchar40
17CNVCMIS_A_1_VIEFVIEF type Repository Analysis7AS4VERSVersion of viewnvarchar40
18CNVCMIS_A_1_VIEWVIEW type Repository Analysis6AS4VERSVersion of the entry (not used)nvarchar40
19ESH_HDB_MAPMapping table for ESHAUTH <-> MANDT3AS4VERSVersion of the entry (not used)nvarchar40
20SCI_DD28SZeilen einer Selektionsbedingung3AS4VERSVersion einer Selektionsbedingungnvarchar40
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
21CD0TBSH001Veri-Struktur mit Suchhilfe-Anbindung3AS4VERSVersion des Eintrags (nicht benutzt)nvarchar40
22DD01LDomains3AS4VERSVersion of the entry (not used)nvarchar40
23DD01TR/3 DD: domain texts4AS4VERSVersion of the entry (not used)nvarchar40
24DD02LSAP Tables3AS4VERSVersion of the entry (not used)nvarchar40
25DD02TSAP DD: SAP Table Texts4AS4VERSVersion of the entry (not used)nvarchar40
26DD03LTable Fields4AS4VERSVersion of the entry (not used)nvarchar40
27DD04LData elements3AS4VERSVersion of the entry (not used)nvarchar40
28DD04TR/3 DD: Data element texts4AS4VERSVersion of the entry (not used)nvarchar40
29DD05SForeign key fields5AS4VERSVersion of the entry (not used)nvarchar40
30DD06LPool/cluster structures3AS4VERSVersion of the entry (not used)nvarchar40
31DD06TR/3 DD: texts on SQL tables4AS4VERSVersion of the entry (not used)nvarchar40
32DD07LR/3 DD: values for the domains4AS4VERSVersion of the entry (not used)nvarchar40
33DD07TDD: Texts for Domain Fixed Values (Language-Dependent)5AS4VERSVersion of the entry (not used)nvarchar40
34DD08LR/3 DD: relationship definitions4AS4VERSVersion of the entry (not used)nvarchar40
35DD08TTexts on the relationship definitions5AS4VERSVersion of the entry (not used)nvarchar40
36DD09LDD: Technical settings of tables3AS4VERSVersion of the entry (not used)nvarchar40
37DD12LR/3 S_SECINDEX: secondary indexes, header;4AS4VERSVersion of the entry (not used)nvarchar40
38DD12TText Table for DD12L (Short Descriptions of Sec. Indexes)5AS4VERSVersion of the entry (not used)nvarchar40
39DD14SR/3 DD: components of SAP objects4AS4VERSVersion of the entry (not used)nvarchar40
40DD15LR/3 DD: SAP objects3AS4VERSVersion of the entry (not used)nvarchar40
41DD15TR/3 DD: texts on SAP objects4AS4VERSVersion of the entry (not used)nvarchar40
42DD16SR/3 DD: SQL table fields4AS4VERSVersion of the entry (not used)nvarchar40
43DD17SR/3 S_SECINDEX: secondary indexes, fields5AS4VERSVersion of the entry (not used)nvarchar40
44DD20LMatchcode objects3AS4VERSVersion of the entry (not used)nvarchar40
45DD20TAS400-T_MCOBJECT: MC Object Texts4AS4VERSVersion of the entry (not used)nvarchar40
46DD21SS-MCIDTABLE: Tables for a MC ID4AS4VERSVersion of matchcode IDnvarchar40
47DD23LMatchcode ID4AS4VERSVersion of the entry (not used)nvarchar40
48DD23TAS400_L-MCID: Matchcode ID Texts5AS4VERSVersion of the entry (not used)nvarchar40
49DD24SFields of a matchcode ID5AS4VERSVersion of matchcode IDnvarchar40
50DD25LAggregate Header (Views, MC Objects, Lock Objects)3AS4VERSVersion of the entry (not used)nvarchar40
51DD25TShort Texts for Views and Lock Objects4AS4VERSVersion of the entry (not used)nvarchar40
52DD26SBase tables and foreign key relationships for a view4AS4VERSVersion of the entry (not used)nvarchar40
53DD27SFields in an Aggregate (View, MC Object, Lock Object)4AS4VERSVersion of viewnvarchar40
54DD28SLines of a selection condition3AS4VERSVersion of a selection conditionnvarchar40
55DD29LSelection Condition for Views and MC IDs3AS4VERSVersion of a selection conditionnvarchar40
56DD29TAS400_L-SELCOND: Selection Condition Texts4AS4VERSVersion of a selection conditionnvarchar40
TOPComputer Aided Process Planning
57TCAPTTables used in CAPP formulas and methods4AS4VERSVersion of the entry (not used)nvarchar40
TOPUpgrade Tools
58UPG_DD12LICNV: Secondary Indexes - Header4AS4VERSnvarchar40
59UPG_DD17SICNV: Secondary Indexes - Fields5AS4VERSnvarchar40