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

159 columns | Print definition?ERP 6.0  | NODEID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/B364/HFPIDHierarchy: InfoObject Structure Element3NODEIDInternal ID number of a hierarchy nodenvarchar80
2/B364/HMPITEMSHierarchy: InfoObject Structure Element3NODEIDInternal ID number of a hierarchy nodenvarchar80
3/B631/HACTTYPEHierarchy: InfoObject Activity Type3NODEIDInternal ID number of a hierarchy nodenvarchar80
4/B631/HCOORDERHierarchy: InfoObject Order3NODEIDInternal ID number of a hierarchy nodenvarchar80
5/B631/HCOSTCNTRHierarchy: InfoObject Cost Center3NODEIDInternal ID number of a hierarchy nodenvarchar80
6/B631/HCOSTELMTHierarchy: InfoObject Cost Element3NODEIDInternal ID number of a hierarchy nodenvarchar80
7/B631/HPLANTHierarchy: InfoObject Plant3NODEIDInternal ID number of a hierarchy nodenvarchar80
8/B631/HPROFTCTRHierarchy: InfoObject Profit Center3NODEIDInternal ID number of a hierarchy nodenvarchar80
9/B631/HWBSELMTHierarchy: InfoObject WBS Element3NODEIDInternal ID number of a hierarchy nodenvarchar80
10/B631/JACTTYPEHierarchy Interval: InfoObject Activity Type3NODEIDInternal ID number of a hierarchy nodenvarchar80
11/B631/JCOORDERHierarchy Interval: InfoObject Order3NODEIDInternal ID number of a hierarchy nodenvarchar80
12/B631/JCOSTCNTRHierarchy Interval: InfoObject Cost Center3NODEIDInternal ID number of a hierarchy nodenvarchar80
13/B631/JCOSTELMTHierarchy Interval: InfoObject Cost Element3NODEIDInternal ID number of a hierarchy nodenvarchar80
14/B631/JPROFTCTRHierarchy Interval: InfoObject Profit Center3NODEIDInternal ID number of a hierarchy nodenvarchar80
15/BI0/HBUCKETHierarchy: InfoObject Directory of Precalc3NODEIDInternal ID number of a hierarchy nodenvarchar80
16/BI0/HCALMONTHHierarchy: InfoObject Calendar Year/Month3NODEIDInternal ID number of a hierarchy nodenvarchar80
17/BI0/HCALMONTH2Hierarchy: InfoObject Calendar month3NODEIDInternal ID number of a hierarchy nodenvarchar80
18/BI0/HDATEHierarchy: InfoObject Date3NODEIDInternal ID number of a hierarchy nodenvarchar80
19/BI0/HFISCPERHierarchy: InfoObject Fiscal year/period3NODEIDInternal ID number of a hierarchy nodenvarchar80
20/BI0/HHALFYEAR1Hierarchy: InfoObject Halfyear3NODEIDInternal ID number of a hierarchy nodenvarchar80
21/BI0/HINFOPROVHierarchy: InfoObject InfoProvider3NODEIDInternal ID number of a hierarchy nodenvarchar80
22/BI0/HIOBJNMHierarchy: InfoObject InfoObject3NODEIDInternal ID number of a hierarchy nodenvarchar80
23/BI0/HRSPL_ORGHierarchy: InfoObject Area of Responsibil.3NODEIDInternal ID number of a hierarchy nodenvarchar80
24/BI0/HRSTT_EIDHierarchy: InfoObject Error ID3NODEIDInternal ID number of a hierarchy nodenvarchar80
25/BI0/HRSTT_FTPCHierarchy: InfoObject Function Subject3NODEIDInternal ID number of a hierarchy nodenvarchar80
26/BI0/HRSTT_FUNCHierarchy: InfoObject Functions3NODEIDInternal ID number of a hierarchy nodenvarchar80
27/BI0/HRSTT_IONMHierarchy: InfoObject InfoObject3NODEIDInternal ID number of a hierarchy nodenvarchar80
28/BI0/HRSTT_IPBZMHierarchy: InfoObject RTM for Non-Cum.3NODEIDInternal ID number of a hierarchy nodenvarchar80
29/BI0/HRSTT_IPNMHierarchy: InfoObject InfoProvider Name3NODEIDInternal ID number of a hierarchy nodenvarchar80
30/BI0/HRSTT_JIDHierarchy: InfoObject Job ID3NODEIDInternal ID number of a hierarchy nodenvarchar80
31/BI0/HRSTT_OBJNMHierarchy: InfoObject Object Name3NODEIDInternal ID number of a hierarchy nodenvarchar80
32/BI0/HRSTT_PIDHierarchy: InfoObject Trace Package ID3NODEIDInternal ID number of a hierarchy nodenvarchar80
33/BI0/HRSTT_PVARHierarchy: InfoObject Play Variant3NODEIDInternal ID number of a hierarchy nodenvarchar80
34/BI0/HRSTT_QYNMHierarchy: InfoObject Query Name3NODEIDInternal ID number of a hierarchy nodenvarchar80
35/BI0/HRSTT_RQIDHierarchy: InfoObject Test Request3NODEIDInternal ID number of a hierarchy nodenvarchar80
36/BI0/HRSTT_RVARHierarchy: InfoObject Ref. Data Variant3NODEIDInternal ID number of a hierarchy nodenvarchar80
37/BI0/HRSTT_SAPCPHierarchy: InfoObject SAP Component3NODEIDInternal ID number of a hierarchy nodenvarchar80
38/BI0/HRSTT_SVARIHierarchy: InfoObject Selection Variant3NODEIDInternal ID number of a hierarchy nodenvarchar80
39/BI0/HRSTT_TIDHierarchy: InfoObject Trace ID3NODEIDInternal ID number of a hierarchy nodenvarchar80
40/BI0/HRSTT_TLAYHierarchy: InfoObject Trace Layer3NODEIDInternal ID number of a hierarchy nodenvarchar80
41/BI0/HRSTT_TOTYPHierarchy: InfoObject Object Type (Transp)3NODEIDInternal ID number of a hierarchy nodenvarchar80
42/BI0/HRSTT_TRANRHierarchy: InfoObject Transport Request3NODEIDInternal ID number of a hierarchy nodenvarchar80
43/BI0/HRSTT_TRTGTHierarchy: InfoObject Transport Target3NODEIDInternal ID number of a hierarchy nodenvarchar80
44/BI0/HRSTT_USERHierarchy: InfoObject Trace User3NODEIDInternal ID number of a hierarchy nodenvarchar80
45/BI0/HTCAIFAREAHierarchy: InfoObject InfoArea Analys. Aut3NODEIDInternal ID number of a hierarchy nodenvarchar80
46/BI0/HTCTAPPLHierarchy: InfoObject Appl. Component3NODEIDInternal ID number of a hierarchy nodenvarchar80
47/BI0/HTCTBWOBJCTHierarchy: InfoObject BI Object3NODEIDInternal ID number of a hierarchy nodenvarchar80
48/BI0/HTCTIFAREAHierarchy: InfoObject InfoArea3NODEIDInternal ID number of a hierarchy nodenvarchar80
49/BI0/HTCTMDXFCHierarchy: InfoObject MDX Functions3NODEIDInternal ID number of a hierarchy nodenvarchar80
50/BI0/HTCTPRCSCHNHierarchy: InfoObject Process Chain ID3NODEIDInternal ID number of a hierarchy nodenvarchar80
51/BI0/HTCTQUERIDHierarchy: InfoObject Query (UID)3NODEIDInternal ID number of a hierarchy nodenvarchar80
52/BI0/HTCTSOURSYSHierarchy: InfoObject Source System3NODEIDInternal ID number of a hierarchy nodenvarchar80
53/BI0/HTCTSTATEVTHierarchy: InfoObject Statistics Event3NODEIDInternal ID number of a hierarchy nodenvarchar80
54/BI0/HTCTSYSIDHierarchy: InfoObject BW System3NODEIDInternal ID number of a hierarchy nodenvarchar80
55/BI0/HTCTUSERNMHierarchy: InfoObject User3NODEIDInternal ID number of a hierarchy nodenvarchar80
56/BI0/HTCTUSRNMHierarchy: InfoObject User ID3NODEIDInternal ID number of a hierarchy nodenvarchar80
57/BI0/JDATEHierarchy Interval: InfoObject Date3NODEIDInternal ID number of a hierarchy nodenvarchar80
58/BI0/SNODEIDMaster Data IDs: InfoObject Node ID1NODEIDTechnical Node ID of Node in Hierarchynvarchar80
59CMCBD_LQH_HIERLiquidity Item Hierarchy Relationship(Runtime)4NODEIDHierarchy Node IDnvarchar80
60CMCBD_NODEATTRAttributes of a Node in Process Flow4NODEIDInternal ID number of a hierarchy nodenvarchar80
61CMCBD_PS_NODESNodes in the Data Models4NODEIDInternal ID number of a hierarchy nodenvarchar80
62CMCBD_PS_NODES_TTexts for the Data Models5NODEIDInternal ID number of a hierarchy nodenvarchar80
63CMCB_LQH_HIERLiquidity Item Hierarchy Relationship(Runtime)3NODEIDHierarchy Node IDnvarchar80
64CNVC_MENUMenu node data3NODEIDMenu item IDnvarchar100
65CNVC_MENU_TXTMenu texts3NODEIDMenu namenvarchar100
66CNV_ADT_MENUTransformation Summary: Menu tree3NODEIDNode ID for menu treenvarchar120
67CNV_ADT_MENU_DPTransformation Summary: Data providers for menu nodes3NODEIDNode ID for menu treenvarchar120
68CNV_ADT_MENU_TXTTransformation Summary: Menu tree texts3NODEIDNode ID for menu treenvarchar120
69FCLM_LQH_HIERLiquidity Item Hierarchy Relationship3NODEIDHierarchy Node IDnvarchar80
70RSDMHIETAB740Model Table: Hierarchies of a Characteristic (from 3.0B)3NODEIDInternal ID number of a hierarchy nodenvarchar80
71RSDMHINTAB740Model table: Hierarchy intervals of a characteristic3NODEIDInternal ID number of a hierarchy nodenvarchar80
72SWDDUSRATTWorkflow Definition: User Attributes2NODEIDNode Numbernvarchar100
73SWDDUSRATTTXTWorkflow Definition: User Attribute Text Table2NODEIDNode Numbernvarchar100
74SWD_USRATTWorkflow Definition: User Attributes3NODEIDNode Numbernvarchar100
75SWD_USRATTTXTWorkflow Definition: User Attribute Texts3NODEIDNode Numbernvarchar100
TOPBackground Processing
76BTC_CRITERIASelection Criteria: Criteria3NODEIDSelection Criteria: IDint100
TOPBW Service API
77ROVERFIELHHierarchy using Test Fields in Verification Scenario3NODEIDInternal ID number of a hierarchy nodenvarchar80
TOPData Basis
78RSDIPROHNODEInfoProvider: Hierarchy Nodes5NODEIDInternal ID number of a hierarchy nodenvarchar80
79RSMAXHIETABHierarchy Node Table with Maximum Possible Structure3NODEIDInternal ID number of a hierarchy nodenvarchar80
TOPData Modeler
80TDMV1EDM varchart positions2NODEIDEDM varchart-node IDnvarchar100
TOPData Staging
81RSHIEINTVLTMPHelp Table for Packaged Loading of Hierarchies2NODEIDInternal ID number of a hierarchy nodenvarchar80
82RSHIENODETMPHelp Table for Packaged Loading of Hierarchies2NODEIDInternal ID number of a hierarchy nodenvarchar80
TOPData Warehousing Workbench
83RSAWBNUTESTMTREEUnit Tests for Model Trees of the Data Warehousing Workbench4NODEIDTechnical Node ID of Node in Hierarchynvarchar80
84RSDFNODEATTRAttributes of a Node in Data Flow3NODEIDID of Node in Data Flowint100
85RSDFNODEATTRLONGAttributes of a Node in Data Flow3NODEIDID of Node in Data Flowint100
86RSDFNODEDOCUDescription (string) of data flow node4NODEIDID of Node in Data Flowint100
87RSDFNODESNodes in the Data Models3NODEIDID of Node in Data Flowint100
88RSDFNODESTTexts for the Data Models4NODEIDID of Node in Data Flowint100
TOPDistribution Requirements Planning
89MDRP_NODENodes for DRP Network2NODEIDIdentification nodes for DRP networknvarchar180
90MDRP_NODEPPositions of the nodes in a DRP network3NODEIDIdentification nodes for DRP networknvarchar180
91MDRP_NSEQSequence of Node Processing4NODEIDIdentification nodes for DRP networknvarchar180
TOPECM ABAP Stack
92NWECMD_CONTENTnwecm: persistent table of (file) content2NODEIDGlobally Unique Identifiervarbinary160
93NWECMD_NODEtable for persistent node objects2NODEIDGlobally Unique Identifiervarbinary160
94NWECMD_PROPERTYStable for persistent properties objects4NODEIDnwecm: UU Identifiervarbinary160
TOPEnd User Technology
95RSRFAVREPTText table for executable nodes in the favorites4NODEIDInternal ID number of a hierarchy nodenvarchar80
TOPEnvironment, Health and Safety
96/TDAG/CPC_REP011CP: Define hierarchy for report format3NODEIDNode IDnvarchar60
TOPIndustrial Hygiene and Safety
97CCIHC_RCNODECauses and Root Causes2NODEIDHierarchy Nodenvarchar120
98CCIHC_RCNODETXTTexts for Causes and Root Causes2NODEIDHierarchy Nodenvarchar120
99CCIHC_RCTREECause Hierarchy Tree3NODEIDHierarchy Nodenvarchar120
100CCIHT_RCEHS: Accident Causes (Root Causes)17NODEIDHierarchy Nodenvarchar120
TOPInformation System
101TIVISREPTREEInfo System Report Tree1NODEIDNodesnvarchar200
102TIVISREPTREETInfo System Report Tree (Texts)2NODEIDNodesnvarchar200
TOPLogbook
103DIOHFW_NODESNodes2NODEIDNode IDnvarchar320
TOPMetadata Repository
104RSDMHIETABObsolete from APOLLO -> RSDMHIERTABNEW3NODEIDInternal ID number of a hierarchy nodenvarchar80
105RSDMHIETABNEWModel Table: Hierarchies of a Characteristic (from 3.0B)3NODEIDInternal ID number of a hierarchy nodenvarchar80
106RSDMHINTABObsolete from APOLLO -> RSDMHINTABNEW3NODEIDInternal ID number of a hierarchy nodenvarchar80
107RSDMHINTABNEWModel table: Hierarchy intervals of a characteristic3NODEIDInternal ID number of a hierarchy nodenvarchar80
TOPPortfolio Analyzer
108BMA_BMLAYERDETOLD CFM Benchmarking: Benchmark Layer5NODEIDInternal ID for Portfolio Hierarchy Nodenvarchar60
TOPProcess Monitoring Infrastructure
109SSPICSPRSTSPI: Steps of Assembled Process Instances27NODEIDSPI: Node IDint100
110SSPICSTRHEADSPI: Central Store Tracking Records Header23NODEIDSPI: Node IDint100
TOPProfitability Analysis
111TKEPPLPROTOTREEStorage of Tree Structure for Logs5NODEIDALV Tree Control: Node Keynvarchar120
112TKEPPLPROTOTREETText Table for TKEPPLPROTOTREE5NODEIDALV Tree Control: Node Keynvarchar120
TOPRuntime
113SWFDEBUGWorkflow Debugger: Breakpoints5NODEIDNode Numbernvarchar100
114SWFGPWULACDEFWhere-Used List of Activities in Workflow Definitions6NODEIDNode Numbernvarchar100
TOPSAP Business Workflow
115SWDSBINDEFWF Definition: Bindings4NODEIDNode Numbernvarchar100
116SWDSCONDEFWF Definition: Conditions4NODEIDNode Numbernvarchar100
117SWDSCONTWF Definition: Container (from 610)4NODEIDNode Numbernvarchar100
118SWDSDSTEPSWF Definition: Definition-Relevant Steps Only4NODEIDNode Numbernvarchar100
119SWDSEVNTSWF Definition: Events4NODEIDNode Numbernvarchar100
120SWDSEXPRWF Definition: Expressions4NODEIDNode Numbernvarchar100
121SWDSFUNCSWF Definition: Functions4NODEIDNode Numbernvarchar100
122SWDSLEVNTSWF Definition: Local Events4NODEIDNode Numbernvarchar100
123SWDSMETHODWF Definition: Methods4NODEIDNode Numbernvarchar100
124SWDSMNODESWF Definition: Nodes4NODEIDNode Numbernvarchar100
125SWDSPROPTSWF Definition: Properties4NODEIDNode Numbernvarchar100
126SWDSSTEPSWF Definition: Steps4NODEIDNode Numbernvarchar100
127SWDSTASKSWF Definition: Tasks4NODEIDNode Numbernvarchar100
128SWDSTEXTWF definition: Language-dependent texts5NODEIDNode Numbernvarchar100
129SWDSWFCTXTWF Definition: Container Text (All Releases)4NODEIDNode Numbernvarchar100
130SWD_BINDEFWF Definition/Runtime: Bindings5NODEIDNode Numbernvarchar100
131SWD_CONDEFWF Definition/Runtime: Conditions5NODEIDNode Numbernvarchar100
132SWD_CONTWF Definition: Container (from 610)5NODEIDNode Numbernvarchar100
133SWD_EVNTSWF Definition/Runtime: Events5NODEIDNode Numbernvarchar100
134SWD_EXPRWF Definition: Expressions5NODEIDNode Numbernvarchar100
135SWD_FUNCSWF Definition/Runtime: Functions5NODEIDNode Numbernvarchar100
136SWD_LEVNTSWF Definition: Local Events5NODEIDNode Numbernvarchar100
137SWD_METHODWF-Definition/Runtime: Methods5NODEIDNode Numbernvarchar100
138SWD_MNODESWorkflow Definition: Node Table (Definition)5NODEIDNode Numbernvarchar100
139SWD_NODESWF-Runtime: Nodes (Part 1)5NODEIDNode Numbernvarchar100
140SWD_NODES2WF-Runtime: Nodes (part 2)5NODEIDNode Numbernvarchar100
141SWD_PROPTSWF Definition/Runtime: Functions5NODEIDNode Numbernvarchar100
142SWD_STEPSWF-Definition/Runtime: Steps5NODEIDNode Numbernvarchar100
143SWD_TEXTWF definition: Language-dependent texts6NODEIDNode Numbernvarchar100
144SWD_WFCTXTWorkflow definition: Container texts5NODEIDNode Numbernvarchar100
145SWF_TRC_WF_DATWorkflow-Trace: Data Entries19NODEIDNode Numbernvarchar100
146SWPNODEWFM: Node Properties and Node Hierarchy at Runtime4NODEIDNode Numbernvarchar100
147SWPNODELOGWorkflow: Instance Data of Nodes of a Workflow Execution3NODEIDNode Numbernvarchar100
148SWP_JOINWorkflow instances: Join node of a workflow execution3NODEIDNode Numbernvarchar100
149SWP_NODEWIWF: Work items for nodes in a workflow definition4NODEIDNode Numbernvarchar100
TOPSchedule Manager
150SCMA_CONTSchedule Manager: TVARV Variable in Workflow Container3NODEIDNode Numbernvarchar100
151SMANWFVARVALSchedule Manager: Values for Schedule Manager Variable2NODEIDNode number of definitionnvarchar100
TOPTransaction Tax Engine
152TTED_TAXELES_COMInput document tax elements information6NODEIDNode IDnvarchar120
153TTED_TAXLOC_COMTaxlocation6NODEIDNode IDnvarchar120
TOPUser Interface Framework
154TPTGCLYTSGUI Layout Structure (Enhancement Layer)4NODEIDNode IDnvarchar300
155TPTGSLYTSGUI Layout Structure3NODEIDNode IDnvarchar300
156TPTUCLYTSUIA Layout Structure (Enhancement Layer)4NODEIDNode IDnvarchar300
157TPTUSLYTSUIA Layout Structure3NODEIDNode IDnvarchar300
TOPWithout Description
158RSHIENODESHierarchy Node(s)3NODEIDInternal ID number of a hierarchy nodenvarchar80
159RSRVTESTHIERHierarchical Storage for Tests of RSRV1NODEIDTree Control: Node Keynvarchar120