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)
8BSEG345Accounting Document Segment
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
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Financial Accounting :: Localization
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DMEE_TREE_NODE481DMEE: Format Tree NodesLocalization
SQL:  selectupdate insert create

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

SELECT TREE_TYPE, TREE_ID, VERSION, NODE_ID, TECH_NAME, REF_NAME, PARENT_ID, BROTHER_ID, FIRSTCHILD_ID, NODE_TYPE, LENGTH, DATA_TYPE, EX_STATUS, LEV, X_COMPLTAB, TAB_KEYFLD, ATOM_HANDL, MP_OFFSET, MP_SC_TAB, MP_SC_FLD, MP_SC_OFFSET, MP_IF_TP, MP_SC_NODE, MP_SC_NODE_ATTR, MP_SC_REF_NAME, MP_CONST, CV_RULE, MP_EXIT_FUNC, MP_SELECTION, MP_CUKY_TAB, MP_CUKY_FLD, INT_DATA_TYPE, TDFORM_NAME, SHIFTED_OUTPUT, SEGM_END, SEGM_CR, SEGM_LF, CRLF_ONLY, CK_EXIT_FUNC, REACT_LEV_SCREEN, REACT_LEV_EXIT, MSG_CLASS_SCREEN, MSG_NUM_SCREEN, MSG_CLASS_EXIT, MSG_NUM_EXIT, TRAILER, CV_SOURCE_FORMAT, LENGTH_IN_BYTES FROM DMEE_TREE_NODE
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1TREE_TYPEDMEE: tree typenvarchar40 Allow NULL? 
2TREE_IDDMEE: unique description for a DMEE format treenvarchar300 Allow NULL? 
3VERSIONDMEE: version of format treenvarchar30 Allow NULL? 
4NODE_IDDMEE: node IDnvarchar120 Allow NULL? 
5TECH_NAMEDMEE: node name for format tree nodenvarchar500 Allow NULL? 
6REF_NAMEDMEE: unique node identification for referencing purposesnvarchar120 Allow NULL? 
7PARENT_IDDMEE: node IDnvarchar120 Allow NULL? 
8BROTHER_IDDMEE: node IDnvarchar120 Allow NULL? 
9FIRSTCHILD_IDDMEE: node IDnvarchar120 Allow NULL? 
10NODE_TYPEDMEE: node typenvarchar40 Allow NULL? 
11LENGTHDMEE: length of DMEE nodenvarchar40 Allow NULL? 
12DATA_TYPEDMEE: data type of DMEE nodechar10 Allow NULL? 
13EX_STATUSDMEE: existence status of a format tree nodechar10 Allow NULL? 
14LEVDMEE: level of a format objectnvarchar30 Allow NULL? 
15X_COMPLTABDMEE: loop starts with the first line of internal tablechar10 Allow NULL? 
16TAB_KEYFLDDMEE: key field of internal tablenvarchar60 Allow NULL? 
17ATOM_HANDLDMEE: Handling of Different Atoms for an Elementnvarchar20 Allow NULL? 
18MP_OFFSETDMEE: offset of a format object in target fieldnvarchar30 Allow NULL? 
19MP_SC_TABDMEE: name of DDIC structure for source fieldnvarchar300 Allow NULL? 
20MP_SC_FLDDMEE: name of a source fieldnvarchar300 Allow NULL? 
21MP_SC_OFFSETDMEE: mapping offset in source fieldnvarchar30 Allow NULL? 
22MP_IF_TPDMEE: type of interface that source struct. originates fromchar10 Allow NULL? 
23MP_SC_NODEDMEE: node IDnvarchar120 Allow NULL? 
24MP_SC_NODE_ATTRDMEE: node attribute that serves as source valuenvarchar20 Allow NULL? 
25MP_SC_REF_NAMEDMEE: reference ID of the referenced nodenvarchar120 Allow NULL? 
26MP_CONSTDMEE: constant as a source valuenvarchar1320 Allow NULL? 
27CV_RULEDMEE: internal conversion functionnvarchar100 Allow NULL? 
28MP_EXIT_FUNCDMEE: name of mapping exit function modulenvarchar300 Allow NULL? 
29MP_SELECTIONDMEE: selected mapping procedurechar10 Allow NULL? 
30MP_CUKY_TABTable for reference fieldnvarchar300 Allow NULL? 
31MP_CUKY_FLDReference field for currency and qty fieldsnvarchar300 Allow NULL? 
32INT_DATA_TYPEDMEE: internal type (A: currency amount; SPACE: other)char10 Allow NULL? 
33TDFORM_NAMEDMEE: name of node in SAPscript formnvarchar200 Allow NULL? 
34SHIFTED_OUTPUTDMEE: Delayed Segment Outputchar10 Allow NULL? 
35SEGM_ENDDMEE: Rule for Closing a Segmentchar10 Allow NULL? 
36SEGM_CRSegments are separated by carriage returnchar10 Allow NULL? 
37SEGM_LFSegments are separated by line feedchar10 Allow NULL? 
38CRLF_ONLYDMEE: Empty Segment for Generating CR/LF Onlychar10 Allow NULL? 
39CK_EXIT_FUNCDMEE: Name of CHECK Exit Function Modulenvarchar300 Allow NULL? 
40REACT_LEV_SCREENDMEE: System Response for Configurable Checkchar10 Allow NULL? 
41REACT_LEV_EXITDMEE: System Response for Exit-Module Checkchar10 Allow NULL? 
42MSG_CLASS_SCREENDMEE: Message Class for Response (Configurable Check)nvarchar200 Allow NULL? 
43MSG_NUM_SCREENDMEE: Message Number for Response (Configurable Check)nvarchar30 Allow NULL? 
44MSG_CLASS_EXITDMEE: Message Class for Response (Exit)nvarchar200 Allow NULL? 
45MSG_NUM_EXITDMEE: Message Number for Response (Exit)nvarchar30 Allow NULL? 
46TRAILERDMEE: Trailer Segment for Closing Data Recordchar10 Allow NULL? 
47CV_SOURCE_FORMATDMEE: Source Format at Conversion (Incoming Files)nvarchar100 Allow NULL? 
48LENGTH_IN_BYTESLength in Byteschar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
DMEE_TREE_NODE~0YesYesCLUSTEREDNODE_ID, VERSION, TREE_ID, TREE_TYPE