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

82 columns | Print definition?ERP 6.0  | NODETYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IXOS/DCRMS_VAIDSelection screen of DocLink for Records Management7NODETYPENode typenvarchar200
2/OTEB/SWF_TACT1xIM activities remote parameters 16NODETYPENode typenvarchar200
3/OTEB/SWF_TACTSxIM activities DocuLink tree selections5NODETYPENode typenvarchar200
4/OTEB/SWF_TMPTA1Temporary storage of /OTEB/SWF_T_TACT1 data for web dynpro7NODETYPENode typenvarchar200
5/OTEB/SWF_WD_TMPTemporary storage of selected documents for Web UI workflows6NODETYPENode typenvarchar200
6/OTEI/SWF_TMPTA1Temporary storage of /OTEB/SWF_T_TACT1 data for web dynpro7NODETYPENode typenvarchar200
7/OTEI/SWF_WD_TMPTemporary storage of selected documents for Web UI workflows6NODETYPENode typenvarchar200
8/PLMI/PRT_TREEtemplate tasks relation tree node5NODETYPENode Type in Process Routenvarchar20
9CNVC_MENUMenu node data8NODETYPEMenu item typenvarchar10
TOPBusiness Consolidation
10UCFTL10Data Collection: Overview Screen7NODETYPENode Type for Data Entry Overview Screennvarchar20
11UCFTL12Data Collection: Hidden Lines in Web Dynpro10NODETYPENode Type for Data Entry Overview Screennvarchar20
TOPBW Service API
12ROHIEOBJDerivation of hierarchy class and node type -> InfoObject2NODETYPEType of a hierarchy nodenvarchar40
TOPClaims Management
13ICLX_CNODETYPEBusiness Object Node Categories of 'Claims Facade'2NODETYPEBusiness Object Node Typenvarchar110
14ICLX_CNODETYPETBO Node Categories of 'Claims Facade': Name3NODETYPEBusiness Object Node Typenvarchar110
15ICL_CPOLSNTYPNew Policy Snapshot: Node Categories for Overview Tree2NODETYPENode Category for Contract Overview in Policy Snapshotnvarchar30
16ICL_CPOLSNTYPTNew Policy Snapshot: Node Category for Overvw Tree TxtTable3NODETYPENode Category for Contract Overview in Policy Snapshotnvarchar30
17ICL_CPOLSTREE1Overview of Policy in Policy Snapshot: Node Information2NODETYPENode Category for Contract Overview in Policy Snapshotnvarchar30
18ICL_CPOLSTREE1TOverview of Policy in Policy Snapshot: Node Information3NODETYPENode Category for Contract Overview in Policy Snapshotnvarchar30
19ICL_CPOLSTREE2Overview of Policy in Policy Snapshot: Text2NODETYPENode Category for Contract Overview in Policy Snapshotnvarchar30
20ICL_CPOLSTREE2TOverview of Policy in Policy Snapshot: Text3NODETYPENode Category for Contract Overview in Policy Snapshotnvarchar30
TOPCross-Application Components
21/IXOS/DC46TAREPAGenerated reports for the selection screen > 4.6 systems5NODETYPENode typenvarchar200
22/IXOS/DC46_TBGOSDocuLink Customizing for GOS (Generic Object Services)6NODETYPENode typenvarchar200
23/IXOS/DCRSA_TRCETrace Table Rendering9NODETYPENode typenvarchar200
24/IXOS/DC_NTL_WDTable for node type related Web Dynpro settings5NODETYPENode typenvarchar200
25/IXOS/DC_TAHUHitlist User maintenance (hierachy/separat)6NODETYPENode typenvarchar200
26/IXOS/DC_TALNTUAUser settings for archiving at nodetypes5NODETYPENode typenvarchar200
27/IXOS/DC_TAREPHGenerated reports for hitlists5NODETYPENode typenvarchar200
28/IXOS/DC_TAREPRGenerated reports restrictions for links nt sf(customizing)5NODETYPENode typenvarchar200
29/IXOS/DC_TAREPSGenerated reports for the selection mask5NODETYPENode typenvarchar200
30/IXOS/DC_TASASelectionscreen Administrator maintenance6NODETYPENode typenvarchar200
31/IXOS/DC_TASUSelectionscreen user maintenance6NODETYPENode typenvarchar200
32/IXOS/DC_TAVARSAVariant INDX table for data cluster variants backup5NODETYPENode typenvarchar200
33/IXOS/DC_TAXFCSSScreens: Excluded function codes for selection screen5NODETYPENode typenvarchar200
34/IXOS/DC_TCHIERHierarchy of a view5NODETYPENode typenvarchar200
35/IXOS/DC_TCLNTFLink nodetype/function code5NODETYPENode typenvarchar200
36/IXOS/DC_TCLNTSFLink nodetype/selection field5NODETYPENode typenvarchar200
37/IXOS/DC_TCNTRECRecursion in a view5NODETYPENode typenvarchar200
38/IXOS/DC_TCNTSFOOutput masks for selection fields at node types6NODETYPENode typenvarchar200
39/IXOS/DC_TCNTSFRRestriction of selection fields at node types5NODETYPENode typenvarchar200
40/IXOS/DC_TCNTTNode type description6NODETYPENode typenvarchar200
41/IXOS/DC_TCNTTXTNode type texts6NODETYPENode typenvarchar200
42/IXOS/DC_TC_NTSFMemorized deleted Links: nodetype/selection field7NODETYPENode typenvarchar200
43/IXOS/DC_TC_NTSOOutput masks for selection fields at node types8NODETYPENode typenvarchar200
44/IXOS/DC_TC_NTSRMemorized deleted restrictions of sel. fields at node types7NODETYPENode typenvarchar200
45/IXOS/DC_TTCNS2Local table for suggestion of sel. fields to node type5NODETYPENode typenvarchar200
46/IXOS/DC_TTCNS2TLocal table for suggestion of sel. fields, descr6NODETYPENode typenvarchar200
47/IXOS/DC_TTCNTSFLocal table for suggestion of sel. fields for node type text5NODETYPENode typenvarchar200
48/IXOS/DC_TTCNTSTLocal table for suggestion of sel. fields, descr6NODETYPENode typenvarchar200
49/IXOS/DC_TTCRF4F4-help: reference node types for recursions with parent6NODETYPENode typenvarchar200
50/IXOS/DC_TUNTUpgrade table old/new nodetypes/nodes6NODETYPENode typenvarchar200
51/IXOS/DC_WD_NTLImage pro Node type5NODETYPENode typenvarchar200
52T001W_EXTPlants (Company's Own and External)9NODETYPENode type: supply chain networknvarchar30
TOPData Mining
53RSDMTD_TREESTRUCNode Structure5NODETYPENode Typenvarchar10
TOPData Staging
54RSBMNODETYPESHierarchical Log: Node Types1NODETYPEDTP Log: Node Typenvarchar60
TOPDatabase Monitors
55ALLAZYMTALERTS NEXT GEN: Whole Database Monitoring Tree Infrastr.3NODETYPEALERTS NEXT GEN: nodetype: C...CTXT, ...nvarchar10
56ALLAZYMT2ALERTS NEXT GEN: NEW (>=4.6A) Database Monitoring Tree7NODETYPEALERTS NEXT GEN: nodetype: C...CTXT, ...nvarchar10
TOPDistribution Requirements Planning
57MDRP_MENUMenu for DRP network2NODETYPENode type: supply chain networknvarchar30
58MDRP_MENUTMenu text for DRP network3NODETYPENode type: supply chain networknvarchar30
59MDRP_NODENodes for DRP Network4NODETYPENode type: supply chain networknvarchar30
60MDRP_NODTNode Type for DRP Network1NODETYPENode type: supply chain networknvarchar30
61MDRP_NODTTNode Type for DRP Network1NODETYPENode type: supply chain networknvarchar30
TOPIndustrial Hygiene and Safety
62CCIHC_RCNODECauses and Root Causes3NODETYPECause Typenvarchar30
63CCIHC_RCNTYPENode Categories for Causes and Root Causes2NODETYPECause Typenvarchar30
64CCIHC_RCNTYPETXTTexts for Node Categories2NODETYPECause Typenvarchar30
TOPIntegration Customer Relationship Management
65EPDESCIS-U MD template description: header entries4NODETYPECategory for MD Template Description Nodenvarchar20
TOPLogistics Basic Data
66DMF_D_T001WTransferred Sites49NODETYPENode type: supply chain networknvarchar30
TOPPeriodical Sales and Distribution
67TJYCIC_TEXTS_NIS-M: CIC, Texts, Nodes3NODETYPEIS-M: CIC, Texts, Node Typenvarchar20
68TJYCIC_TEXTS_PTIS-M: CIC, Texts, Possible Text Objects per Node1NODETYPEIS-M: CIC, Texts, Node Typenvarchar20
69TJYCIC_TEXTS_TPNIS-M: CIC, Texts, Texts per Node3NODETYPEIS-M: CIC, Texts, Node Typenvarchar20
TOPPlant Master
70T001WPlants/Branches49NODETYPENode type: supply chain networknvarchar30
TOPProfitability Analysis
71TKENODE01ACO-PA: Attributes for Node Table TKENODE015NODETYPECO-PA Hierarchy Repository: Node typenvarchar100
TOPRuntime
72SWFGPWULACDEFWhere-Used List of Activities in Workflow Definitions7NODETYPENode Typenvarchar10
TOPSAP Business Workflow
73SWDSMNODESWF Definition: Nodes5NODETYPENode typenvarchar40
74SWD_MNODESWorkflow Definition: Node Table (Definition)6NODETYPENode typenvarchar40
75SWD_NODESWF-Runtime: Nodes (Part 1)6NODETYPENode Typenvarchar10
76SWPNODELOGWorkflow: Instance Data of Nodes of a Workflow Execution10NODETYPENode Typenvarchar10
TOPTechnical Objects
77EAML_NODE_TYPEEAML: Node Type for Object Link From / To2NODETYPENode Type for Object Link From / Tonvarchar100
78EAML_NODE_TYPE_TEAML: Node Type for Object Link From / To2NODETYPENode Type for Object Link From / Tonvarchar100
TOPUser Interface Framework
79TPTUCLYTSUIA Layout Structure (Enhancement Layer)5NODETYPENode Typenvarchar10
80TPTUSLYTSUIA Layout Structure4NODETYPENode Typenvarchar10
TOPVirtual Machine Container
81SVMCRT_CONF_NODEVMC Runtime: Configuration Node8NODETYPEint100
TOPWithout Description
82RSNODETYPNode types1NODETYPEType of a hierarchy nodenvarchar40