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  | NODE_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/I_SBD_NSB: DM node types2NODE_TYPEService Builder: Node Typenvarchar40
2/IWBEP/I_SBD_NCSB: DM node child types2NODE_TYPEService Builder: Node Typenvarchar40
3/IWBEP/I_SBD_NRSB: DM node relations2NODE_TYPEService Builder: Node Typenvarchar40
4/IWBEP/I_SBD_NTSB: DM node type descriptions2NODE_TYPEService Builder: Node Typenvarchar40
5/IXOS/DC_NT_OBJDefinition of objects for nodetypes1NODE_TYPEType of selection (document, static, dynamic, valuetab, ...)nvarchar10
6/MRSS/C_SGX_WCOLCollision Types: Graphical Element Allocation7NODE_TYPEName of Bar Typenvarchar200
7/MRSS/D_PN_HIERPlanning Node - Hierarchical Relationships4NODE_TYPENode Typenvarchar20
8/OEE/C_HTNTHierarchy Template Nodes3NODE_TYPEHierarchy Node Type on Templatenvarchar200
9/OEE/C_HTNTTHierarchy Template Node Texts4NODE_TYPEHierarchy Node Type on Templatenvarchar200
10/OEE/MPH_NODEPlant Hierarchy Nodes4NODE_TYPEHierarchy Node Type on Templatenvarchar200
11/OTEB/T_N_FCODFunction Codes at nodetypes5NODE_TYPENode typenvarchar200
12/OTEB/T_N_FCOD_TFunction Codes at nodetypes text table5NODE_TYPENode typenvarchar200
13/XFT/SOP_C006Maintain SOP types - SOP node type3NODE_TYPESOP Node Typenvarchar30
14/XFT/SRM_REC05Record Node: Header5NODE_TYPENode Typenvarchar10
15/XFT/SRM_RECT05Template Node: Header5NODE_TYPENode Typenvarchar10
16BBP_CT_LOADSTRUCStructure of Product Catalogs or Classification Schemas10NODE_TYPENode Typenvarchar20
17CMCBD_ORG_RSOrganizational Hierarchy Relationship7NODE_TYPEOrganizational Unit Typenvarchar10
18VEOBJECTTable containing business objects and its relations5NODE_TYPENode Type for Visual Objectsnvarchar200
19VFPRCC_TREE_NCGPricing View - Tree Node Configuration4NODE_TYPENode Type for "Pricing Elements: Tree" Viewnvarchar40
20VFPRCC_TREE_NCGCPricing View - Tree Node Configuration5NODE_TYPENode Type for "Pricing Elements: Tree" Viewnvarchar40
21VFPRCC_TREE_TXTPricing View - Tree Node Text4NODE_TYPENode Type for "Pricing Elements: Tree" Viewnvarchar40
22VFPRCC_TREE_TXTCPricing View - Tree Node Text5NODE_TYPENode Type for "Pricing Elements: Tree" Viewnvarchar40
23/BOBF/CONF_LIBCLBOPF Library classes10NODE_TYPENode Typenvarchar10
24/BOBF/OBM_NODEBOPF Configuration: Node20NODE_TYPENode Typenvarchar10
TOPAnalysis Process Designer
25RSANT_FCT_CIDNFactory - Class IDs - Node Attribute2NODE_TYPEType of Node in the Analysis Processnvarchar30
TOPASAP AcceleratedSAP
26IATNODE01Node Table for Implementation Assistant9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
27TNODEREVStructure Item Table for Review Structures9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPASAP Tools and Contents
28SMAPTNODESolution Map: Node table9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPAudit Management
29PLMM_QUEST_IQuestion List Item5NODE_TYPENode Typenvarchar10
30PLMM_QUEST_RESAudit Question/Reply List/Item11NODE_TYPENode Typenvarchar10
TOPAuthoring Tools
31QMM_NODEQMM: Node Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPBalanced Scorecard
32UMB_SC116Scorecard and BPS Web Interface9NODE_TYPENode typenvarchar100
33UMB_SC167Scorecard: Measures: BPS Link11NODE_TYPENode typenvarchar100
34UMB_SC191Scorecard: Initiatives: BPS Links11NODE_TYPENode typenvarchar100
TOPBRFplus - ABAP-Based Business Rules
35FDT_CTLG_0000FDT: Catalog Structure7NODE_TYPEFDT: Catalog Node Typenvarchar20
36FDT_CTLG_0000AFDT: Catalog Structure7NODE_TYPEFDT: Catalog Node Typenvarchar20
37FDT_CTLG_0000SFDT: Catalog Structure6NODE_TYPEFDT: Catalog Node Typenvarchar20
38FDT_CTLG_0000TFDT: Catalog Structure6NODE_TYPEFDT: Catalog Node Typenvarchar20
39FDT_CTLG_0400FDT: Catalog Attributes4NODE_TYPEFDT: Catalog Node Typenvarchar20
40FDT_CTLG_0400AFDT: Catalog Attributes4NODE_TYPEFDT: Catalog Node Typenvarchar20
41FDT_CTLG_0400SFDT: Catalog Attributes3NODE_TYPEFDT: Catalog Node Typenvarchar20
42FDT_CTLG_0400TFDT: Catalog Attributes3NODE_TYPEFDT: Catalog Node Typenvarchar20
43FDT_CTLG_E0000FDT: Enhancement - Catalog Structure7NODE_TYPEFDT: Catalog Node Typenvarchar20
44FDT_CTLG_E0000SFDT: Enhancement - Catalog Structure6NODE_TYPEFDT: Catalog Node Typenvarchar20
45FDT_CTLG_E0000TFDT: Enhancement - Catalog Structure6NODE_TYPEFDT: Catalog Node Typenvarchar20
46FDT_EXPR_2601FDT: Flow Nodes5NODE_TYPEFDT: Node Typenvarchar10
47FDT_EXPR_2601AFDT: Flow Nodes5NODE_TYPEFDT: Node Typenvarchar10
48FDT_EXPR_2601SFDT: Flow Nodes4NODE_TYPEFDT: Node Typenvarchar10
49FDT_EXPR_2601TFDT: Flow Nodes4NODE_TYPEFDT: Node Typenvarchar10
TOPBusiness Navigator
50BMTNODE01Structure repository for process model objects: Node table9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
51DFTNODE01Structure repository for process model objects: Node table9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPBusiness Planning and Simulation
52UPC_DISPATCHERDispatcher in SEM-BPS1NODE_TYPENode typenvarchar100
TOPCapacity Leveling
53TCY44Graphical object type: Fields2NODE_TYPEGraphic object type in the planning tablenvarchar60
54TCY45Graphical element category2NODE_TYPEGraphic object type in the planning tablenvarchar60
55TCY45KObject representation - header2NODE_TYPEGraphic object type in the planning tablenvarchar60
56TCY45TObject representation - text3NODE_TYPEGraphic object type in the planning tablenvarchar60
57TCY46Graphical object type selection: Decision steps12NODE_TYPEGraphic object type in the planning tablenvarchar60
58TCY47Object display selection2NODE_TYPEGraphic object type in the planning tablenvarchar60
59TCY47KSelection of object representation: Header2NODE_TYPEGraphic object type in the planning tablenvarchar60
60TCY47TSelection of object representation: Texts2NODE_TYPEGraphic object type in the planning tablenvarchar60
61TCY55Graphic object type: Header2NODE_TYPEGraphic object type in the planning tablenvarchar60
62TCY55TGraphic object type: Texts3NODE_TYPEGraphic object type in the planning tablenvarchar60
63TCY62Representation profile for selection of graphic object type4NODE_TYPEGraphic object type in the planning tablenvarchar60
TOPCommunication Services Mail, Fax, SMS, Telephony
64SXNODESSAPconnect: Communication nodes19NODE_TYPESAPconnect: Node Type (RFC,SMTP)nvarchar10
TOPCountry-Specific Objects
65DMEE_NODE_ABADMEE: Format Tree Nodes10NODE_TYPEDMEE: node typenvarchar40
TOPCustom Development Management Cockpit
66CNVCDMC_BPCACDMC Table for BPCA interface with mapping and TBOM info9NODE_TYPECDMC: Node Type ( For Project and Solution)nvarchar200
TOPData Warehousing Workbench
67RSIWADFLOWNODESNodes in Data Flow3NODE_TYPEData Target Typenvarchar60
TOPDocument Management Framework
68KDS_NODENode Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPDocument Management Services
69SDOKNODESDOK: Node table for general structure repository9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPeCATT Extended Computer Aided Test Tool
70ECBR_NODESHI3 ECBR/ECBO - Node Table for eCATT Browser Nodes9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPEngineering Change Management
71CCSEQ_NODESHistorical Statuses of Objects (Change Sequence Graph)7NODE_TYPEUsage Location Typenvarchar40
TOPFSCM In-House Cash
72IHC_DB_RT_NODEIHC: Routing Node8NODE_TYPEIHC: Node Typenvarchar40
73IHC_TAB_SELECTIHC: Selections in Selection Variants10NODE_TYPEIHC: Node Typenvarchar40
TOPHierarchy Storage
74TARCH01Node Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
75TNODE01Node Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
76TNODEEDefinition of attributes of a node type1NODE_TYPEValid Node Types in Structure Repositorynvarchar40
77TNODEHList of valid node types1NODE_TYPEValid Node Types in Structure Repositorynvarchar40
78TNODERTYPENode type: Assignable link types1NODE_TYPEValid Node Types in Structure Repositorynvarchar40
79TNODESNode type: Valid sub-node types1NODE_TYPEValid Node Types in Structure Repositorynvarchar40
80TNODETName of valid node types2NODE_TYPEValid Node Types in Structure Repositorynvarchar40
81TTREENList of node types to be displayed for a structure2NODE_TYPEValid Node Types in Structure Repositorynvarchar40
82TTREETYPENList of valid node types per structure type2NODE_TYPEValid Node Types in Structure Repositorynvarchar40
83TTREVNVersions: Copy of TTREEN2NODE_TYPEValid Node Types in Structure Repositorynvarchar40
84TTREV_NODEHierarchy Tool: Structure Versioning Node Table4NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPHR Administrative Services
85T5ASRDTOBJHIERObject Hierarchy2NODE_TYPENode Typenvarchar320
TOPImplementation Guide
86TDOKUIMGNode Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
87TNODEIMGNode table for the new IMG9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
88TNODEPRNode Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
89TNODERELNNode Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
90TNONOCLProject class node type note type assignment2NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPInventory Accounting
91UAIQS_BALANCEQuantity Structure: Beginning/Ending Inventories and Values6NODE_TYPEQuantity Structure: Node Typenvarchar100
TOPKnowledge Warehouse
92CUSTNODENode Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
93IWB0NODENode Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
94IWB1NODENode Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
95IWB2NODENode Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
96IWB7NODENode Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
97IWNODEICONIWB: Structure display icon management5NODE_TYPENode type IDnvarchar20
98KWN_NODENode Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
99TXML_NODEXML: table of nodes9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPLocalization
100DMEE_TREE_NODEDMEE: Format Tree Nodes10NODE_TYPEDMEE: node typenvarchar40
TOPLogbook
101DIOHFW_NTYPE_TXTText table for node types2NODE_TYPENode typenvarchar30
102DIOHFW_NTYPE_VALValue table for node types2NODE_TYPENode typenvarchar30
TOPMaintenance Orders
103/MRSS/D_PN_HDPlanning Node - Header Data3NODE_TYPENode Typenvarchar20
TOPNetWeaver Enterprise Search
104ESH_OM_AOTYPNObject Types: Nodes6NODE_TYPENode Typenvarchar10
105ESH_OM_COTYPNObject Types: Nodes6NODE_TYPENode Typenvarchar10
106ESH_OM_IOTYPNObject Types: Nodes6NODE_TYPENode Typenvarchar10
107ESH_OM_SOTYPNObject Types: Nodes6NODE_TYPENode Typenvarchar10
TOPNetwork Operations
108GHO_PP_PTABLE_ITItem Table for Results of GHO Planning Table15NODE_TYPENetwork Object Typenvarchar100
TOPPerformance Assessment Workbench
109KWPWNODENode Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPPersonnel Time Management
110TPT_UIA_CLNT_LYSUIA Layout Structure: Client-Dependent Customizing4NODE_TYPENode Typenvarchar10
111TPT_UIA_LAYOUTTMW: Database Table for UIA Layout3NODE_TYPENode Typenvarchar10
TOPProduct and Process Modeling
112RLMFWOLCMPRelease Order - Items - Component Variants18NODE_TYPEiPPE Node Typenvarchar80
TOPProduct Cost Planning
113CKECPWORKSPACEHierarchical Worklists and Assignments in ECP9NODE_TYPENode Type in Easy Cost Planning GUInvarchar40
TOPProduct Structure and Assembly Management
114/PLMI/PPE_C_ODNPLM WebUI Customizing Object Description: Nodes2NODE_TYPEiPPE Node Type, Alternative Type, or Variant Typenvarchar80
115/PLMI/PPE_C_ODNTPLM WebUI Customizing Object Description: Nodes Texts2NODE_TYPEiPPE Node Type, Alternative Type, or Variant Typenvarchar80
TOPProduction and Revenue Accounting
116OIUT2_LOG_VIEWERObsolete: Error Viewer Application Tree Configuration4NODE_TYPENode Typenvarchar10
117OIUT2_LOG_VIEWEXObsolete: Error Viewer Application Tree Configuration5NODE_TYPENode Typenvarchar10
TOPProfitability Analysis
118TKENODE01CO-PA: Node Table for General Structure Repository9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
119TKEPPLCSMFCHCO-PA: Function Codes for Context-Sensitive Menu - Header5NODE_TYPENode typenvarchar30
TOPQuestion Answer Database
120SCQADBHIERHierarchy for questionaire6NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPRepository Browser
121TMEMOUser-specific memory8NODE_TYPENode typenvarchar40
TOPSAP Multiresource Scheduling
122/MRSS/C_NODE_COLMaintain Color codes for nodes in Gantt2NODE_TYPENode Typenvarchar10
TOPSAP Records Management
123SRM_ECM_CSOClient Supplied Owners of Document Locks8NODE_TYPENode type for SRM ECM integrationnvarchar30
124SRM_ECM_NNTLookup table for RM node names in ECM integration6NODE_TYPENode type for SRM ECM integrationnvarchar30
TOPSAPscript
125TFORM01Node Table for SAPscript Form Tree9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPService
126DVS1NODENode Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPSession Manager
127TMENU01Node Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
128TMENUBK01Node Table for General Structure Storage9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPSyntax, Compiler, Runtime
129ABAPDOCU_TREETree Structure of ABAP Keyword Documentation5NODE_TYPEABAP Keyword Documentation Node Typenvarchar30
TOPTest Organizer
130TNODE02Test Organizer, Node Table9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
131TWBMAN_COMPTWBM: Application Components2NODE_TYPEValid Node Types in Structure Repositorynvarchar40
132TWBMAN_RECO_FAVTWBM: Favorites5NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPUpstream Graphics
133OIUGT_PR_TCODESTransactions used by Upstream Graphics1NODE_TYPENode Type - Graphicsnvarchar20
TOPWeb Screen Tools - ABAP
134WDY_CTX_NODEWeb Dynpro: Context Nodes of Controllers5NODE_TYPEWeb Dynpro: Class Name of Web Dynpro Metadata Objectnvarchar300
TOPWorkbench Utilities
135RLB_DB_TRReuse Library: Structure Repository: Nodes9NODE_TYPEValid Node Types in Structure Repositorynvarchar40
TOPWorkplace Server
136W3DEVFAVMWP: Favorites for Mobile Terminals5NODE_TYPEType of node ( U = URL, F = folder, T = transaction)nvarchar10