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

178 columns | Print definition?ERP 6.0  | TREE_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T7PIQ_US_IPEDSDMAssign Reports to DMEE Trees4TREE_IDDMEE: unique description for a DMEE format treenvarchar300
TOPActivity-Based Costing
2ABC_FTREECO-OM-ABC: Function Tree2TREE_IDFunction Tree IDnvarchar160
3ABC_FTREETCO-ABC: Texts for Tree Structure3TREE_IDFunction Tree IDnvarchar160
4COHIERARCHCO-OM-ABC: Hiearchy Graphic for Functions4TREE_IDFunction Tree IDnvarchar160
TOPASAP AcceleratedSAP
5IATNODE01Node Table for Implementation Assistant1TREE_IDUnique ID - 32 charactersnvarchar320
6IATNODE01TNode Names for Implementation Assistant2TREE_IDUnique ID - 32 charactersnvarchar320
7TNODEREVStructure Item Table for Review Structures1TREE_IDUnique ID - 32 charactersnvarchar320
8TNODEREVTStructure Item Descriptions for Review Structures2TREE_IDUnique ID - 32 charactersnvarchar320
9TTREEBRAEXAttribute Repository for Structure Nodes: Invalid Industry1TREE_IDUnique ID - 32 charactersnvarchar320
10TTREEBRAINAttribute Repository for Sturcture Nodes: Valid Industry1TREE_IDUnique ID - 32 charactersnvarchar320
11TTREECOUEXAttribute Repository for Structure Nodes: Invalid Countries1TREE_IDUnique ID - 32 charactersnvarchar320
12TTREECOUINAttribute Repository for Structure Nodes: Valid Countries1TREE_IDUnique ID - 32 charactersnvarchar320
13TTREEFLAEXAttribute Repository for Hierarchy Nodes: Invalid Flavors1TREE_IDUnique ID - 32 charactersnvarchar320
14TTREEFLAINAttribute Repository for Hierarchy Nodes: Valid Flavors1TREE_IDUnique ID - 32 charactersnvarchar320
15TTREERELEXAttribute Repository for Hierarchy Nodes: Invalid Release1TREE_IDUnique ID - 32 charactersnvarchar320
16TTREERELINAttribute Repository for Hierarchy Nodes: Valid Release1TREE_IDUnique ID - 32 charactersnvarchar320
17TTREEROAEXAttribute Repository for Structure Nodes: Invalid Roadmap1TREE_IDUnique ID - 32 charactersnvarchar320
18TTREEROAINAttribute Repository for Structure Nodes: Valid Roadmap1TREE_IDUnique ID - 32 charactersnvarchar320
19TTREEROLEXAttribute Repository for Structure Nodes: Invalid Role1TREE_IDUnique ID - 32 charactersnvarchar320
20TTREEROLINAttribute Repository for Structure Nodes: Valid Role1TREE_IDUnique ID - 32 charactersnvarchar320
21TTREESUBEXAttribute Rep. for Structure Nodes: Invalid Subject Area1TREE_IDUnique ID - 32 charactersnvarchar320
22TTREESUBINAttribute Repository for Structure Nodes: Valid Subject Area1TREE_IDUnique ID - 32 charactersnvarchar320
TOPASAP Tools and Contents
23SMAPTNODESolution Map: Node table1TREE_IDUnique ID - 32 charactersnvarchar320
24SMAPTNODETSolution Map: Node texts2TREE_IDUnique ID - 32 charactersnvarchar320
TOPAuthoring Tools
25QMM_NODEQMM: Node Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
26QMM_NODETQMM: General Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
TOPBusiness Navigator
27BMTNODE01Structure repository for process model objects: Node table1TREE_IDUnique ID - 32 charactersnvarchar320
28BMTNODE01TStructure Repository for Process Model Objects: Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
29DFTNODE01Structure repository for process model objects: Node table1TREE_IDUnique ID - 32 charactersnvarchar320
30DFTNODE01TStructure Repository for Process Model Objects: Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
TOPCountry-Specific Objects
31DMEE_ABADMEE Format Tree: General Data2TREE_IDDMEE: ID for a DMEE format treenvarchar300
32DMEE_AGGR_ABADMEE: Aggregation of Nodes2TREE_IDDMEE: ID for a DMEE format treenvarchar300
33DMEE_CHECKS_ABADMEE: Checks2TREE_IDDMEE: ID for a DMEE format treenvarchar300
34DMEE_COND_ABADMEE: Format Tree Node Conditions2TREE_IDDMEE: ID for a DMEE format treenvarchar300
35DMEE_DEBUG_ABADMEE: Temporary Data for Debugging2TREE_IDDMEE: ID for a DMEE format treenvarchar300
36DMEE_HEAD_ABADMEE: Format Tree Header Data2TREE_IDDMEE: ID for a DMEE format treenvarchar300
37DMEE_LEVTAB_ABADMEE: Format Level2TREE_IDDMEE: ID for a DMEE format treenvarchar300
38DMEE_NODE_ABADMEE: Format Tree Nodes2TREE_IDDMEE: ID for a DMEE format treenvarchar300
39DMEE_NODE_T_ABADMEE: Text Table for Tree Node3TREE_IDDMEE: ID for a DMEE format treenvarchar300
40DMEE_NXTSG_ABADMEE: Supplementary Segments (Incoming DME Files)2TREE_IDDMEE: ID for a DMEE format treenvarchar300
41DMEE_RULES_ABADMEE: Assignment Rules (Incoming DME Files)2TREE_IDDMEE: ID for a DMEE format treenvarchar300
42DMEE_SHEET_ABADMEE: Key Fields for Subtotals on Accompanying Sheet2TREE_IDDMEE: ID for a DMEE format treenvarchar300
43DMEE_SORT_ABADMEE: Sort and Key Fields for Format2TREE_IDDMEE: ID for a DMEE format treenvarchar300
44DMEE_T_ABADMEE: Text Table for Tree Definition3TREE_IDDMEE: ID for a DMEE format treenvarchar300
TOPData Mining
45RSDMTD_NODE_DISTNode Class Distribution2TREE_IDID for Tree Related IDsnvarchar50
46RSDMTD_RULESRules Header2TREE_IDID for Tree Related IDsnvarchar50
47RSDMTD_RULESDTLRules Details2TREE_IDID for Tree Related IDsnvarchar50
48RSDMTD_TREEHDRTree Header2TREE_IDID for Tree Related IDsnvarchar50
49RSDMTD_TREESTRUCNode Structure2TREE_IDID for Tree Related IDsnvarchar50
50RSDMTD_TREE_MAPTree ID mapping to Mining Source Mapping3TREE_IDID for Tree Related IDsnvarchar50
TOPDocument Management Framework
51KDS_NODENode Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
52KDS_NODETGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
TOPDocument Management Services
53SDOKNODESDOK: Node table for general structure repository1TREE_IDUnique ID - 32 charactersnvarchar320
54SDOKNODETSDOK: Name of Nodes for General Structure Repository2TREE_IDUnique ID - 32 charactersnvarchar320
TOPeCATT Extended Computer Aided Test Tool
55ECBR_NODESHI3 ECBR/ECBO - Node Table for eCATT Browser Nodes1TREE_IDUnique ID - 32 charactersnvarchar320
56ECBR_NODETSHI3 ECBR/ECBO - Names of Nodes for eCATT Browser2TREE_IDUnique ID - 32 charactersnvarchar320
TOPHierarchical Derivation Service
57THDS_GENCATLCatalog for Generation3TREE_IDID/Name of Derivation Treenvarchar300
58THDS_GENCATLFCatalog for Generation3TREE_IDID/Name of Derivation Treenvarchar300
59THDS_GENCATLF_ACatalog for Generation3TREE_IDID/Name of Derivation Treenvarchar300
60THDS_GENCATLF_SCatalog for Generation2TREE_IDID/Name of Derivation Treenvarchar300
61THDS_GENCATL_ACatalog for Generation3TREE_IDID/Name of Derivation Treenvarchar300
62THDS_GENCATL_SCatalog for Generation2TREE_IDID/Name of Derivation Treenvarchar300
63THDS_NODENodes of a Derivation Tree3TREE_IDID/Name of Derivation Treenvarchar300
64THDS_NODETText Table for THDS_NODE4TREE_IDID/Name of Derivation Treenvarchar300
65THDS_NODET_AText Table for THDS_NODE_A4TREE_IDID/Name of Derivation Treenvarchar300
66THDS_NODET_SText Table for THDS_NODE_S3TREE_IDID/Name of Derivation Treenvarchar300
67THDS_NODE_ANodes of a Derivation Tree3TREE_IDID/Name of Derivation Treenvarchar300
68THDS_NODE_SNodes of a Derivation Tree2TREE_IDID/Name of Derivation Treenvarchar300
69THDS_TEST_QDEMOTable for Prototype1TREE_IDID/Name of Derivation Treenvarchar300
70THDS_TREEHeader of a Derivation Tree3TREE_IDID/Name of Derivation Treenvarchar300
71THDS_TREETText Table for THDS_TREE4TREE_IDID/Name of Derivation Treenvarchar300
72THDS_TREET_AText Table for THDS_TREE_A4TREE_IDID/Name of Derivation Treenvarchar300
73THDS_TREET_SText Table for THDS_TREE_S3TREE_IDID/Name of Derivation Treenvarchar300
74THDS_TREE_AHeader of a Derivation Tree3TREE_IDID/Name of Derivation Treenvarchar300
75THDS_TREE_ACTIVEComprises Active Versions of Trees3TREE_IDID/Name of Derivation Treenvarchar300
76THDS_TREE_ACT_AComprises Active Versions of Trees3TREE_IDID/Name of Derivation Treenvarchar300
77THDS_TREE_ACT_SComprises Active Versions of Trees2TREE_IDID/Name of Derivation Treenvarchar300
78THDS_TREE_HISTHistory Table - HDS Trees3TREE_IDID/Name of Derivation Treenvarchar300
79THDS_TREE_HIST_AHistory Table - HDS Trees3TREE_IDID/Name of Derivation Treenvarchar300
80THDS_TREE_HIST_SHistory Table - HDS Trees2TREE_IDID/Name of Derivation Treenvarchar300
81THDS_TREE_SHeader of a Derivation Tree2TREE_IDID/Name of Derivation Treenvarchar300
TOPHierarchy Storage
82TARCH01Node Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
83TARCH01TGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
84TNODE01Node Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
85TNODE01TGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
86TTREEDefinition table for structures6TREE_IDUnique ID - 32 charactersnvarchar320
87TTREELOADSGeneration data for structure buffering (nodes/links)1TREE_IDUnique ID - 32 charactersnvarchar320
88TTREELOADTGeneration data for structure buffering (texts)2TREE_IDUnique ID - 32 charactersnvarchar320
89TTREESRCHGeneration data for structure buffering (nodes/links)2TREE_IDUnique ID - 32 charactersnvarchar320
90TTREE_SFW_NODESAssignment of SFW Switches to Hierarchy Tool Nodes3TREE_IDGUID for Structurenvarchar320
91TTREVVersions: Header Data7TREE_IDUnique ID - 32 charactersnvarchar320
92TTREVBRAEXVersions: Copy of TTREEBRAEX2TREE_IDUnique ID - 32 charactersnvarchar320
93TTREVBRAINVersions: Copy of TTREEBRAIN2TREE_IDUnique ID - 32 charactersnvarchar320
94TTREVCOUEXVersions: Copy of TTREECOUEX2TREE_IDUnique ID - 32 charactersnvarchar320
95TTREVCOUINVersions: Copy of TTREECOUIN2TREE_IDUnique ID - 32 charactersnvarchar320
96TTREVROAEXVersions: Copy of TTREEROAEX2TREE_IDUnique ID - 32 charactersnvarchar320
97TTREVROAINVersions: Copy of TTREEROAIN2TREE_IDUnique ID - 32 charactersnvarchar320
98TTREVROLEXVersions: Copy of TTREEROLEX2TREE_IDUnique ID - 32 charactersnvarchar320
99TTREVROLINVersions: Copy of TTREEROLIN2TREE_IDUnique ID - 32 charactersnvarchar320
100TTREVSUBEXVersions: Copy of TTREESUBEX2TREE_IDUnique ID - 32 charactersnvarchar320
101TTREVSUBINVersions: Copy of TTREESUBIN2TREE_IDUnique ID - 32 charactersnvarchar320
102TTREV_NODEHierarchy Tool: Structure Versioning Node Table9TREE_IDUnique ID - 32 charactersnvarchar320
TOPImplementation Guide
103SCUS_HIERReplacements table for hierarchies4TREE_IDGUID for Structurenvarchar320
104SFRETREEStructure ID for complete release information list2TREE_IDUnique ID - 32 charactersnvarchar320
105TCUSGENINFGeneral information display: Assignment of structures2TREE_IDUnique ID - 32 charactersnvarchar320
106TCUSP40Customizing: Implementation project profile3TREE_IDUnique ID - 32 charactersnvarchar320
107TDOKUIMGNode Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
108TDOKUIMGTGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
109TNODEIMGNode table for the new IMG1TREE_IDUnique ID - 32 charactersnvarchar320
110TNODEIMGTGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
111TNODEPRNode Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
112TNODEPRTGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
113TNODERELNNode Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
114TNODERELNTGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
TOPIntegrated Product and Process Engineering
115CGIPROFILiPPE Workbench: Profile Definitions3TREE_IDIdentification of the ALV Tree on the iPPE User Interfacenvarchar20
116USRGISTACKiPPE Workbench: Stack2TREE_IDIdentification of the ALV Tree on the iPPE User Interfacenvarchar20
TOPKnowledge Warehouse
117CUSTNODENode Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
118CUSTNODETGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
119IWB0NODENode Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
120IWB0NODETGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
121IWB1NODENode Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
122IWB1NODETGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
123IWB2NODENode Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
124IWB2NODETGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
125IWB7NODENode Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
126IWB7NODETGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
127KWN_NODENode Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
128KWN_NODETGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
129TXML_NODEXML: table of nodes1TREE_IDUnique ID - 32 charactersnvarchar320
130TXML_NODETXML: General Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
TOPLocalization
131DMEE_TREEDMEE Format Tree: General Data2TREE_IDDMEE: unique description for a DMEE format treenvarchar300
132DMEE_TREE_AGGRDMEE: Aggregation of Nodes2TREE_IDDMEE: unique description for a DMEE format treenvarchar300
133DMEE_TREE_CHECKSDMEE: Checks2TREE_IDDMEE: unique description for a DMEE format treenvarchar300
134DMEE_TREE_CONDDMEE: Format Object - & Mapping Conditions2TREE_IDDMEE: unique description for a DMEE format treenvarchar300
135DMEE_TREE_DEBUGDMEE: Temporary Data for Debugging2TREE_IDDMEE: unique description for a DMEE format treenvarchar300
136DMEE_TREE_HEADDMEE: Format Tree Header Data2TREE_IDDMEE: unique description for a DMEE format treenvarchar300
137DMEE_TREE_LEVELDMEE: Format Level2TREE_IDDMEE: unique description for a DMEE format treenvarchar300
138DMEE_TREE_NODEDMEE: Format Tree Nodes2TREE_IDDMEE: unique description for a DMEE format treenvarchar300
139DMEE_TREE_NODE_TText Table DMEE: Format Tree Node3TREE_IDDMEE: unique description for a DMEE format treenvarchar300
140DMEE_TREE_NXTSGDMEE: Supplementary Segments (Incoming DME Files)2TREE_IDDMEE: unique description for a DMEE format treenvarchar300
141DMEE_TREE_RULESDMEE: Assignment Rules (Incoming DME Files)2TREE_IDDMEE: unique description for a DMEE format treenvarchar300
142DMEE_TREE_SHEETDMEE: Key Fields for Subtotals on Accompanying Sheet2TREE_IDDMEE: unique description for a DMEE format treenvarchar300
143DMEE_TREE_SORTDMEE: Sort and Key Fields for Format2TREE_IDDMEE: unique description for a DMEE format treenvarchar300
144DMEE_TREE_TDMEE: Text Table for Tree Definition3TREE_IDDMEE: unique description for a DMEE format treenvarchar300
TOPOverhead Cost Controlling
145PFALVPeriod-End Partner: Log (ALV Information)4TREE_IDReporting tree IDnvarchar160
TOPPerformance Assessment Workbench
146KWPWNODENode Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
147KWPWNODETGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
TOPProfitability Analysis
148TKENODE01CO-PA: Node Table for General Structure Repository1TREE_IDUnique ID - 32 charactersnvarchar320
149TKENODE01ACO-PA: Attributes for Node Table TKENODE011TREE_IDUnique ID - 32 charactersnvarchar320
150TKENODE01TGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
TOPQuestion Answer Database
151SCQADBQuestionnaire Header Entry3TREE_IDUnique ID - 32 charactersnvarchar320
152SCQADBHIERHierarchy for questionaire9TREE_IDUnique ID - 32 charactersnvarchar320
TOPReport Tree
153SERPATTRTree attributes2TREE_IDReporting tree IDnvarchar160
154SERPENTRReporting: Initial Position and Sub-trees (User-specific)3TREE_IDReporting tree IDnvarchar160
155SERPTReporting: Texts for Tree Structure2TREE_IDReporting tree IDnvarchar160
156SERPTREEReporting: Tree Structure2TREE_IDReporting tree IDnvarchar160
157SREPOCNTRReporting: Country-specific HR reports2TREE_IDReporting tree IDnvarchar160
158SREPOLISTReporting: Lists2TREE_IDReporting tree IDnvarchar160
159SREPORTEXTTexts in Report Tree3TREE_IDReporting tree IDnvarchar160
160SREPOUSERReporting: Visible Reports and Variants (User-specific)3TREE_IDReporting tree IDnvarchar160
161SREPOVARIReporting: Reports and Variants2TREE_IDReporting tree IDnvarchar160
TOPSAPscript
162TFORM01Node Table for SAPscript Form Tree1TREE_IDUnique ID - 32 charactersnvarchar320
163TFORM01TSAPscript Form Tree: Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
TOPService
164DVS1NODENode Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
165DVS1NODETGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
TOPSession Manager
166BMENTTREEDefinition Table for Structures6TREE_IDUnique ID - 32 charactersnvarchar320
167TMENU01Node Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
168TMENU01TGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
169TMENUBK01Node Table for General Structure Storage1TREE_IDUnique ID - 32 charactersnvarchar320
170TMENUBK01TGeneral Structure Storage Node Names2TREE_IDUnique ID - 32 charactersnvarchar320
TOPSpain
171T5EF5Definition of assignment trees2TREE_IDnvarchar40
TOPTest Organizer
172TNODE02Test Organizer, Node Table1TREE_IDUnique ID - 32 charactersnvarchar320
173TNODE02TTest Organizer, Texts2TREE_IDUnique ID - 32 charactersnvarchar320
TOPWarranty Claim Processing
174CGIPROFIL_WTYProfile Definitions Warranty Claim3TREE_IDIdentification of Navigation Tree on iPPE Interfacenvarchar20
TOPWebRFC, Web Reporting
175W3TREESInternet-enabled Reporting Trees (-> Transaction SERP)2TREE_IDReporting tree IDnvarchar160
TOPWorkbench Utilities
176RLB_DB_FVReuse Library: Table for Storing Favorites3TREE_IDReuse Library: Tree ID in Hierarchy Maintenance Toolnvarchar320
177RLB_DB_TRReuse Library: Structure Repository: Nodes1TREE_IDUnique ID - 32 charactersnvarchar320
178RLB_DB_TRTReuse Library: Structure Repository: Descriptions2TREE_IDUnique ID - 32 charactersnvarchar320