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

136 columns | Print definition?ERP 6.0  | EXT_KEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/N_DT_EVNT_IDetected events, which potentially need to be reloaded10EXT_KEYExternal Object Keynvarchar500
2/IWBEP/I_SBD_XTSB: DM extensions3EXT_KEYService Builder: Extension Keynvarchar400
3/IWBEP/I_SBD_XTTSB: DM extension descriptions3EXT_KEYService Builder: Extension Keynvarchar400
4/IWBEP/I_SBU_XTSB: UI extensions3EXT_KEYService Builder: Extension Keynvarchar400
5/IWBEP/I_SBU_XTTSB: UI extension descriptions3EXT_KEYService Builder: Extension Keynvarchar400
6/OPT/CT_IDH_DATAInbound Document Handler: Table for storing key/value pairs3EXT_KEYField Name from External Systemnvarchar500
7/OPT/VIM_IDH_EXTInbound Document Handler: Table for storing original values3EXT_KEYField Name from External Systemnvarchar500
TOPASAP AcceleratedSAP
8IATNODE01Node Table for Implementation Assistant4EXT_KEYExternal keynvarchar120
9IATNODE01RGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
10IATNODE01TNode Names for Implementation Assistant6EXT_KEYExternal keynvarchar120
11TNODEREVStructure Item Table for Review Structures4EXT_KEYExternal keynvarchar120
12TNODEREVRReferences for Review Structures2EXT_KEYExternal keynvarchar120
13TNODEREVTStructure Item Descriptions for Review Structures6EXT_KEYExternal keynvarchar120
14TTREEBRAEXAttribute Repository for Structure Nodes: Invalid Industry4EXT_KEYExternal keynvarchar120
15TTREEBRAINAttribute Repository for Sturcture Nodes: Valid Industry4EXT_KEYExternal keynvarchar120
16TTREECOUEXAttribute Repository for Structure Nodes: Invalid Countries4EXT_KEYExternal keynvarchar120
17TTREECOUINAttribute Repository for Structure Nodes: Valid Countries4EXT_KEYExternal keynvarchar120
18TTREEFLAEXAttribute Repository for Hierarchy Nodes: Invalid Flavors4EXT_KEYExternal keynvarchar120
19TTREEFLAINAttribute Repository for Hierarchy Nodes: Valid Flavors4EXT_KEYExternal keynvarchar120
20TTREERELEXAttribute Repository for Hierarchy Nodes: Invalid Release4EXT_KEYExternal keynvarchar120
21TTREERELINAttribute Repository for Hierarchy Nodes: Valid Release4EXT_KEYExternal keynvarchar120
22TTREEROAEXAttribute Repository for Structure Nodes: Invalid Roadmap4EXT_KEYExternal keynvarchar120
23TTREEROAINAttribute Repository for Structure Nodes: Valid Roadmap4EXT_KEYExternal keynvarchar120
24TTREEROLEXAttribute Repository for Structure Nodes: Invalid Role4EXT_KEYExternal keynvarchar120
25TTREEROLINAttribute Repository for Structure Nodes: Valid Role4EXT_KEYExternal keynvarchar120
26TTREESUBEXAttribute Rep. for Structure Nodes: Invalid Subject Area4EXT_KEYExternal keynvarchar120
27TTREESUBINAttribute Repository for Structure Nodes: Valid Subject Area4EXT_KEYExternal keynvarchar120
TOPASAP Tools and Contents
28SMAPTNODESolution Map: Node table4EXT_KEYExternal keynvarchar120
29SMAPTNODERSolution Map: Node references2EXT_KEYExternal keynvarchar120
30SMAPTNODETSolution Map: Node texts6EXT_KEYExternal keynvarchar120
TOPAuthoring Tools
31QMM_NODEQMM: Node Table for General Structure Storage4EXT_KEYExternal keynvarchar120
32QMM_NODERQMM: General Structure Storage References2EXT_KEYExternal keynvarchar120
33QMM_NODETQMM: General Structure Storage Node Names6EXT_KEYExternal keynvarchar120
TOPBusiness Navigator
34BMTNODE01Structure repository for process model objects: Node table4EXT_KEYExternal keynvarchar120
35BMTNODE01RStructure repository for process model objects: References2EXT_KEYExternal keynvarchar120
36BMTNODE01TStructure Repository for Process Model Objects: Node Names6EXT_KEYExternal keynvarchar120
37DFTNODE01Structure repository for process model objects: Node table4EXT_KEYExternal keynvarchar120
38DFTNODE01RStructure repository for process model objects: References2EXT_KEYExternal keynvarchar120
39DFTNODE01TStructure Repository for Process Model Objects: Node Names6EXT_KEYExternal keynvarchar120
TOPCase Management
40SCMG_T_CASE_ATTRCase Attributes4EXT_KEYCase IDnvarchar120
TOPClinical System
41N2COMM_LOGDocuments Received in Temporary Storage11EXT_KEYExternal Key of a Transferred Objectnvarchar1200
42N2COMM_LOGSTATLast Known Status for Transmitted Object10EXT_KEYExternal Key of a Transferred Objectnvarchar1200
TOPContract Accounts Receivable and Payable
43DFKKCASEITEMSHItem List in Cases, Header Data11EXT_KEYCase IDnvarchar120
44DFKKWLI_ADDAdditional Collection Case Attributes3EXT_KEYCustomer-Specific Collection Case IDnvarchar300
45TFK052ICustomizing for Additional Collection Case Attributes3EXT_KEYCustomer-Specific Collection Case ID (Customizing)nvarchar10
TOPControlling
46FCOMT_CR_OBJECTChange Request: Objects5EXT_KEYExternal Keynvarchar300
TOPDocument Management Framework
47KDS_NODENode Table for General Structure Storage4EXT_KEYExternal keynvarchar120
48KDS_NODERGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
49KDS_NODETGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
TOPDocument Management Services
50SDOKNODESDOK: Node table for general structure repository4EXT_KEYExternal keynvarchar120
51SDOKNODERGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
52SDOKNODETSDOK: Name of Nodes for General Structure Repository6EXT_KEYExternal keynvarchar120
TOPeCATT Extended Computer Aided Test Tool
53ECBR_NODESHI3 ECBR/ECBO - Node Table for eCATT Browser Nodes4EXT_KEYExternal keynvarchar120
54ECBR_NODERSHI3 ECBR/ECBO - Node References2EXT_KEYExternal keynvarchar120
55ECBR_NODETSHI3 ECBR/ECBO - Names of Nodes for eCATT Browser6EXT_KEYExternal keynvarchar120
TOPEmployee Interaction Center
56THREIC_PER_ALRTSEIC: Personal Alerts5EXT_KEYCase IDnvarchar120
TOPHierarchy Storage
57TARCH01Node Table for General Structure Storage4EXT_KEYExternal keynvarchar120
58TARCH01RGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
59TARCH01TGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
60TNODE01Node Table for General Structure Storage4EXT_KEYExternal keynvarchar120
61TNODE01RGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
62TNODE01TGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
63TTREEDefinition table for structures3EXT_KEYExternal keynvarchar120
64TTREVVersions: Header Data4EXT_KEYExternal keynvarchar120
65TTREVBRAEXVersions: Copy of TTREEBRAEX5EXT_KEYExternal keynvarchar120
66TTREVBRAINVersions: Copy of TTREEBRAIN5EXT_KEYExternal keynvarchar120
67TTREVCOUEXVersions: Copy of TTREECOUEX5EXT_KEYExternal keynvarchar120
68TTREVCOUINVersions: Copy of TTREECOUIN5EXT_KEYExternal keynvarchar120
69TTREVROAEXVersions: Copy of TTREEROAEX5EXT_KEYExternal keynvarchar120
70TTREVROAINVersions: Copy of TTREEROAIN5EXT_KEYExternal keynvarchar120
71TTREVROLEXVersions: Copy of TTREEROLEX5EXT_KEYExternal keynvarchar120
72TTREVROLINVersions: Copy of TTREEROLIN5EXT_KEYExternal keynvarchar120
73TTREVSUBEXVersions: Copy of TTREESUBEX5EXT_KEYExternal keynvarchar120
74TTREVSUBINVersions: Copy of TTREESUBIN5EXT_KEYExternal keynvarchar120
TOPImplementation Guide
75TDOKUIMGNode Table for General Structure Storage4EXT_KEYExternal keynvarchar120
76TDOKUIMGRGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
77TDOKUIMGTGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
78TNODEIMGNode table for the new IMG4EXT_KEYExternal keynvarchar120
79TNODEIMGRReferences for the new IMG2EXT_KEYExternal keynvarchar120
80TNODEIMGTGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
81TNODEPRNode Table for General Structure Storage4EXT_KEYExternal keynvarchar120
82TNODEPRRGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
83TNODEPRTGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
84TNODERELNNode Table for General Structure Storage4EXT_KEYExternal keynvarchar120
85TNODERELNRGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
86TNODERELNTGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
TOPInterface to External Project Software
87PSGUIDGUIDs for Project Definition5EXT_KEYExternal Key for PS Objectnvarchar400
TOPKnowledge Warehouse
88CUSTNODENode Table for General Structure Storage4EXT_KEYExternal keynvarchar120
89CUSTNODERGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
90CUSTNODETGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
91IWB0NODENode Table for General Structure Storage4EXT_KEYExternal keynvarchar120
92IWB0NODERGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
93IWB0NODETGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
94IWB1NODENode Table for General Structure Storage4EXT_KEYExternal keynvarchar120
95IWB1NODERGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
96IWB1NODETGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
97IWB2NODENode Table for General Structure Storage4EXT_KEYExternal keynvarchar120
98IWB2NODERGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
99IWB2NODETGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
100IWB7NODENode Table for General Structure Storage4EXT_KEYExternal keynvarchar120
101IWB7NODERGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
102IWB7NODETGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
103KWN_NODENode Table for General Structure Storage4EXT_KEYExternal keynvarchar120
104KWN_NODERGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
105KWN_NODETGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
106TXML_NODEXML: table of nodes4EXT_KEYExternal keynvarchar120
107TXML_NODERXML: General Structure Storage References2EXT_KEYExternal keynvarchar120
108TXML_NODETXML: General Structure Storage Node Names6EXT_KEYExternal keynvarchar120
TOPPerformance Assessment Workbench
109KWPWNODENode Table for General Structure Storage4EXT_KEYExternal keynvarchar120
110KWPWNODERGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
111KWPWNODETGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
TOPPortfolio
112VDARL_PAYM_PLANReferences from Premium Plans to Relevant Objects5EXT_KEYExternal Key for Objects for a Premium Plannvarchar320
TOPProfitability Analysis
113TKENODE01CO-PA: Node Table for General Structure Repository4EXT_KEYExternal keynvarchar120
114TKENODE01ACO-PA: Attributes for Node Table TKENODE014EXT_KEYExternal keynvarchar120
115TKENODE01RGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
116TKENODE01TGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
TOPSAPscript
117TFORM01Node Table for SAPscript Form Tree4EXT_KEYExternal keynvarchar120
118TFORM01RSAPscript Form Tree: References2EXT_KEYExternal keynvarchar120
119TFORM01TSAPscript Form Tree: Node Names6EXT_KEYExternal keynvarchar120
TOPService
120DVS1NODENode Table for General Structure Storage4EXT_KEYExternal keynvarchar120
121DVS1NODERGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
122DVS1NODETGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
TOPSession Manager
123BMENTTREEDefinition Table for Structures3EXT_KEYExternal keynvarchar120
124TMENU01Node Table for General Structure Storage4EXT_KEYExternal keynvarchar120
125TMENU01RGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
126TMENU01TGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
127TMENUBK01Node Table for General Structure Storage4EXT_KEYExternal keynvarchar120
128TMENUBK01RGeneral Structure Storage References2EXT_KEYExternal keynvarchar120
129TMENUBK01TGeneral Structure Storage Node Names6EXT_KEYExternal keynvarchar120
TOPTest Organizer
130TNODE02Test Organizer, Node Table4EXT_KEYExternal keynvarchar120
131TNODE02ATest Organizer, Test Catalog, Plan, Package Attributes3EXT_KEYExternal keynvarchar120
132TNODE02RTest Organizer, References2EXT_KEYExternal keynvarchar120
133TNODE02TTest Organizer, Texts6EXT_KEYExternal keynvarchar120
TOPWorkbench Utilities
134RLB_DB_TRReuse Library: Structure Repository: Nodes4EXT_KEYExternal keynvarchar120
135RLB_DB_TRRReuse Library: Structure Repository: References2EXT_KEYExternal keynvarchar120
136RLB_DB_TRTReuse Library: Structure Repository: Descriptions6EXT_KEYExternal keynvarchar120