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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

161 columns | Print definition?ERP 6.0  | NODE_KEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BOBF/ACF_MAPBOPF Configuration: ACF mapping8NODE_KEYNodevarbinary160
2/BOBF/AUTH_OBJBOPF Configuration: ACF Definition7NODE_KEYNodevarbinary160
3/BOBF/OBM_AK_FLDBOPF Configuration: Fieldnames for Alternative Key8NODE_KEYNodevarbinary160
4CNVMBTITEMSCheck items1NODE_KEYTree Control: Node Keynvarchar120
5CNV_20317_TRTree Customizing for date dependent master data3NODE_KEYTree Control: Node Keynvarchar120
6CNV_20317_TRTTree Customizing for date dependent master data3NODE_KEYTree Control: Node Keynvarchar120
7EHFNDD_BO_INDEXIndex table for BO search7NODE_KEYBO Reference - Definition Key of the Subnodevarbinary160
8J_3RFREP_OBJECTSReporting Objects List5NODE_KEYInternal: Node IDnvarchar60
9J_3RF_TP_FL_ATTSAttachments links to nodes for folders hierarchy model3NODE_KEYNode key for folders hierarchy modelnvarchar120
10J_3RF_TP_FL_CUSTCustomizing table for folders hierarchy3NODE_KEYNode key for folders hierarchy modelnvarchar120
11J_3RF_TP_FL_FLDSFolders hierarchy for folders model3NODE_KEYNode key for folders hierarchy modelnvarchar120
12SEPM_OIA_CUCO_TOIA: Table for currency conversion tests2NODE_KEYint100
13SEPM_OIA_SMOKE_HEPM OIA: System Smoke Test Result Header2NODE_KEY16 Byte UUID in 16 Bytes (Raw Format)varbinary160
14SEPM_OIA_SMOKE_IEPM OIA: System Smoke Test Result Items3NODE_KEYNatural Numberint100
15SNWD_AD_EXTExtension table for geo coordinates2NODE_KEYEPM: Generic Node Keyvarbinary160
16SNWD_ATTACHMENTSEPM: Data Generator Untility Table for GOS Attachments2NODE_KEYEPM: Generic Node Keyvarbinary160
17SNWD_BP_EXT_PALEPM HANA: Business Partner extension table for PAL scenario2NODE_KEYEPM: Generic Node Keyvarbinary160
18SNWD_EXTENSIONSEPM: Extensions Table2NODE_KEYEPM: Generic Node Keyvarbinary160
19SNWD_LR_HEADEREPM: Leave Request header data2NODE_KEYEPM: Generic Node Keyvarbinary160
20SNWD_LR_ITEMEPM: Leave Request Item data2NODE_KEYEPM: Generic Node Keyvarbinary160
21SNWD_REV_HEADEPM: Review Header Table2NODE_KEYEPM: Generic Node Keyvarbinary160
22SNWD_REV_ITEMEPM: Review Item Table2NODE_KEYEPM: Generic Node Keyvarbinary160
23SNWD_REV_MARKEPM: Review Marker Table2NODE_KEYEPM: Generic Node Keyvarbinary160
24SNWD_REV_RATINGEPM: Review Rating Table2NODE_KEYEPM: Generic Node Keyvarbinary160
25SNWD_SO_EXT_PALEPM HANA: Sales Order Hdr extension table for PAL scenario2NODE_KEYEPM: Generic Node Keyvarbinary160
26T5UPBS01FAVORITENature of Actions Favorites Tree7NODE_KEYTree Control: Node Keynvarchar120
27T5UPBS01TREEPersonnel Actions Tree7NODE_KEYTree Control: Node Keynvarchar120
28TTS_SM_DATASafety Measure and Supplemental Safety Measure Data12NODE_KEYSafety Measure IDnvarchar40
29YIT_TREEida hiera1NODE_KEYTree Control: Schlüssel eines Knotensnvarchar120
30YIT_TREE_COMPida hiera components1NODE_KEYAnwendungskomponentenvarchar60
31YIT_TREE_COMPTida hiera components1NODE_KEYAnwendungskomponentenvarchar60
32YIT_TREE_EIDES Repository: Demo Hierarchy5NODE_KEYTree Control: Node Keynvarchar120
33YIT_TREE_PIDES Repository: IDES Process Hierarchy5NODE_KEYTree Control: Node Keynvarchar120
34YIT_TREE_TIDES Repository: Training Course Hierarchy5NODE_KEYTree Control: Node Keynvarchar120
35/BOBF/ACT_LISTBOPF Configuration: Action11NODE_KEYNodevarbinary160
36/BOBF/CONF_CLIMPInterface impl., instanciation etc. of configured classes1NODE_KEYNodevarbinary160
37/BOBF/CONF_DDICDDIC objects in BOPF configuration1NODE_KEYNodevarbinary160
38/BOBF/CONF_LIBCLibrary Category2NODE_KEYNodevarbinary160
39/BOBF/CONF_UI_ETree Elements4NODE_KEYNodevarbinary160
40/BOBF/DET_LISTBOPF Configuration: Determination7NODE_KEYNodevarbinary160
41/BOBF/OBM_ALTKEYBOPF Configuration: Alternative Keys6NODE_KEYNodevarbinary160
42/BOBF/OBM_GROUPBOPF Configuration: Group8NODE_KEYNodevarbinary160
43/BOBF/OBM_NCATBOPF Configuration: Node Category6NODE_KEYNodevarbinary160
44/BOBF/OBM_NODEBOPF Configuration: Node4NODE_KEYNodevarbinary160
45/BOBF/OBM_NODETBOPF Configuration: Text Table for /BOPF/OBM_NODE5NODE_KEYNodevarbinary160
46/BOBF/OBM_PROPTYBOPF Configuration: Static Properties6NODE_KEYNodevarbinary160
47/BOBF/OBM_QUERYBOPF Configuration: Query6NODE_KEYNodevarbinary160
48/BOBF/OBM_RTWBOPF Configuration: Dependencies between Logic and Nodes9NODE_KEYNodevarbinary160
49/BOBF/OBM_VSETBOPF Configuration: Value Set12NODE_KEYNodevarbinary160
50/BOBF/STA_DERIVBOPF Configuration: Status Derivator6NODE_KEYNodevarbinary160
51/BOBF/STA_SCHEMABOPF Configuration: Status Scheme6NODE_KEYNodevarbinary160
52/BOBF/STA_VARBOPF Configuration: Status Variable6NODE_KEYNodevarbinary160
53/BOBF/TOOL_ACCTRTracedata for Node Access Trace Tool5NODE_KEYNodevarbinary160
54/BOBF/VAL_LISTBOPF Configuration: List of all validations7NODE_KEYNodevarbinary160
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
55SATC_MD_MAPPINGTransaction data: Mapping2NODE_KEYGeneral keyint100
56SATC_MD_PHSTransaction data: Phase2NODE_KEYGeneral keyint100
57SATC_MD_PHS_EXTTransaction data: Phase extension2NODE_KEYGeneral keyint100
58SATC_MD_PHS_UNITTransaction data: Phase execution unit2NODE_KEYGeneral keyint100
59SATC_MD_SRLZDTransaction data: Serialized data, e.g. memento2NODE_KEYGeneral keyint100
60SATC_MD_STP_USETransaction data: Usage of step2NODE_KEYGeneral keyint100
TOPApplication-Specific Upgrade
61/ASU/SSMFOLDRASU SSM Tree: Folder Hierarchy Customizing2NODE_KEYASU Node Key (numeric; for sorting issues)nvarchar120
62/ASU/SSMFOLDRCNDASU SSM Tree Folder: assigned ASU step conditions2NODE_KEYASU Node Key (numeric; for sorting issues)nvarchar120
63/ASU/SSMFOLDR_TASU SSM Tree: Folder Hierarchy Customizing - Text Table2NODE_KEYASU Node Key (numeric; for sorting issues)nvarchar120
TOPBudgeting
64FMORGFAVBCS : Organizer Favorites6NODE_KEYnvarchar640
TOPBusiness Partner
65BPOBTABPartner-Object Relationship10NODE_KEYNodesnvarchar120
TOPFinancial Accounting
66/BGLOCS/FIVMENUBG VAT reporting Tree Menu2NODE_KEYNode namenvarchar300
TOPForce Element
67/ISDFPS/WFCUTREECustomizing Table for Workflow Customizing Tree1NODE_KEYTree Control: Node Keynvarchar120
TOPHierarchy Storage
68TTREV_NODEHierarchy Tool: Structure Versioning Node Table34NODE_KEYTree Control: Node Keynvarchar120
TOPIncentive and Commission Management ICM
69TCACS_NDPROCustomizing Table for Tree Profiles12NODE_KEYTree Control: Node Keynvarchar120
TOPLocalization
70J_3RFF4DATACash flow statement customizing5NODE_KEYInternal: Node IDnvarchar60
71J_3RFTAX_OBJECTSTax objects list4NODE_KEYInternal: Node IDnvarchar60
TOPMaxDB
72SDBTREEDEFSAP DB: CCMS Navigation Trees - Node Definition2NODE_KEYTree Control: Node Keynvarchar120
73SDBTREETXTSAP DB: CCMS Navigation Trees - Node Texts3NODE_KEYTree Control: Node Keynvarchar120
74SDBUSRSETUser Settings for Transactions LC10 and DB504NODE_KEYTree Control: Node Keynvarchar120
TOPMedia Product
75JPTBUPAASSIGNIS-M: Assignment of Business Partners to Material9NODE_KEYNodesnvarchar120
TOPMonitoring
76SAPBWPRFLSBW Workload: Relation of Workload Profile and Class Names2NODE_KEYTree Control: Node Keynvarchar120
77SAPWLDMTHDSAP Workload: Dynamically-Called Method for Events3NODE_KEYTree Control: Node Keynvarchar120
78SAPWLTREEGSAP Workload: Nodes for ST03G Tree Controls3NODE_KEYTree Control: Node Keynvarchar120
79SAPWLTREETSAP Workload: Text Field for ST03G Trees4NODE_KEYTree Control: Node Keynvarchar120
80SGLWLPRFLSSAP Workload: Profile Codes and Class Names2NODE_KEYTree Control: Node Keynvarchar120
TOPNetWeaver Demonstration
81SEPM_TEST_BO_DBEPM: THIS DB IS ONLY USED FOR EPM INTERNAL TEST PURPOSES !2NODE_KEYEPM: Generic Node Keyvarbinary160
82SEPM_TEST_ITEMEPM: THIS DB IS ONLY USED FOR EPM INTERNAL TEST PURPOSES !2NODE_KEYEPM: Generic Node Keyvarbinary160
83SEPM_TEST_LAZYEPM: THIS DB IS ONLY USED FOR EPM INTERNAL TEST PURPOSES !2NODE_KEYEPM: Generic Node Keyvarbinary160
84SEPM_TEST_SLEPM: THIS DB IS ONLY USED FOR EPM INTERNAL TEST PURPOSES !2NODE_KEYEPM: Generic Node Keyvarbinary160
85SNWD_ADEPM: Address Table2NODE_KEYEPM: Generic Node Keyvarbinary160
86SNWD_BPObsolete - Do Not Use2NODE_KEYEPM: Generic Node Keyvarbinary160
87SNWD_BPAEPM: Business Partners2NODE_KEYEPM: Generic Node Keyvarbinary160
88SNWD_BPA_CONTACTEPM: Business Partner Contacts2NODE_KEYEPM: Generic Node Keyvarbinary160
89SNWD_BP_EMObsolete - Do Not Use2NODE_KEYEPM: Generic Node Keyvarbinary160
90SNWD_BP_PHObsolete - Do Not Use2NODE_KEYEPM: Generic Node Keyvarbinary160
91SNWD_BP_RRObsolete - Do Not Use2NODE_KEYEPM: Generic Node Keyvarbinary160
92SNWD_BP_WAObsolete - Do Not Use2NODE_KEYEPM: Generic Node Keyvarbinary160
93SNWD_COMPANYEPM: Company Master2NODE_KEYEPM: Generic Node Keyvarbinary160
94SNWD_CONTACTObsolete - Do Not Use2NODE_KEYEPM: Generic Node Keyvarbinary160
95SNWD_ECMAEPM: Table for Enterprise Content Management attachments2NODE_KEYEPM: Generic Node Keyvarbinary160
96SNWD_EMPLOYEEObsolete - Do Not Use2NODE_KEYEPM: Generic Node Keyvarbinary160
97SNWD_EMPLOYEESEPM: Employee Data2NODE_KEYEPM: Generic Node Keyvarbinary160
98SNWD_GI_HEADEPM: Goods Issue Header Table2NODE_KEYEPM: Generic Node Keyvarbinary160
99SNWD_GI_IEPM: Goods Issue Item Table2NODE_KEYEPM: Generic Node Keyvarbinary160
100SNWD_GRObsolete - Do Not Use2NODE_KEYEPM: Generic Node Keyvarbinary160
101SNWD_GR_HEADEPM: Goods Received Header Table2NODE_KEYEPM: Generic Node Keyvarbinary160
102SNWD_GR_IEPM: Goods Received Item Table2NODE_KEYEPM: Generic Node Keyvarbinary160
103SNWD_ITELO_DEPTSEPM: Organizational Unit Table2NODE_KEYEPM: Generic Node Keyvarbinary160
104SNWD_ORG_UNITObsolete - Do Not Use2NODE_KEYEPM: Generic Node Keyvarbinary160
105SNWD_ORG_UNITSObsolete - Do Not Use2NODE_KEYEPM: Generic Node Keyvarbinary160
106SNWD_PAYROLLObsolete - Do Not Use2NODE_KEYEPM: Generic Node Keyvarbinary160
107SNWD_PDEPM: Product Data Table2NODE_KEYEPM: Generic Node Keyvarbinary160
108SNWD_PD_CFEPM: Product Conversion Factors2NODE_KEYEPM: Generic Node Keyvarbinary160
109SNWD_POEPM: Purchase Order Header Table2NODE_KEYEPM: Generic Node Keyvarbinary160
110SNWD_PO_IEPM: Purchase Order Item Table2NODE_KEYEPM: Generic Node Keyvarbinary160
111SNWD_PO_INV_HEADEPM: Purchase Order Invoice Header Table2NODE_KEYEPM: Generic Node Keyvarbinary160
112SNWD_PO_INV_ITEMEPM: Purchase Order Invoice Items Table2NODE_KEYEPM: Generic Node Keyvarbinary160
113SNWD_PO_SLEPM: Purchase Order Schedule Line Table2NODE_KEYEPM: Generic Node Keyvarbinary160
114SNWD_PR_I_TPLEPM: Purchase Requisition Item Database Table Template2NODE_KEYEPM: Generic Node Keyvarbinary160
115SNWD_PR_TPLEPM: Purchase Requistion Header Table Template2NODE_KEYEPM: Generic Node Keyvarbinary160
116SNWD_SOEPM: Sales Order Header Table2NODE_KEYEPM: Generic Node Keyvarbinary160
117SNWD_SO_IEPM: Sales Order Item Table2NODE_KEYEPM: Generic Node Keyvarbinary160
118SNWD_SO_INV_HEADEPM: Sales Order Invoice Header Table2NODE_KEYEPM: Generic Node Keyvarbinary160
119SNWD_SO_INV_ITEMEPM: Sales Order Invoice Items Table2NODE_KEYEPM: Generic Node Keyvarbinary160
120SNWD_SO_SLEPM: Sales Order Schedule Line Table2NODE_KEYEPM: Generic Node Keyvarbinary160
121SNWD_STAFFINGEPM: Staff assignments to org units2NODE_KEYEPM: Generic Node Keyvarbinary160
122SNWD_STOCKEPM: Stock Table2NODE_KEYEPM: Generic Node Keyvarbinary160
123SNWD_TEXTObsolete - Do Not Use2NODE_KEYEPM: Generic Node Keyvarbinary160
124SNWD_TEXTSEPM: Text Reference Table2NODE_KEYEPM: Generic Node Keyvarbinary160
125SNWD_TEXT_KEYEPM: Text keys and original language2NODE_KEYEPM: Generic Node Keyvarbinary160
TOPOracle Database Monitors
126DB02N_ANADetailed analyses in ST04N1NODE_KEYTree Model: Node Keynvarchar400
127DB02N_ANATDetailed analyses in ST04N (Node names)1NODE_KEYTree Model: Node Keynvarchar400
TOPPackage Tools
128PBELEMTYPSPackage Builder: Element Typs for Visible Elements4NODE_KEYTree Control: Node Keynvarchar120
TOPPayroll General Parts
129HRPY_CYCLE_INDEXIndex Table for Table HRPY_CYCLE_DOC3NODE_KEYCharacter Length 11nvarchar110
TOPPerformance Monitors TCC
130ST04N_ANADetailed analyses in ST04N1NODE_KEYTree Model: Node Keynvarchar400
131ST04N_ANATDetailed analyses in ST04N (Node names)1NODE_KEYTree Model: Node Keynvarchar400
TOPPost Processing Framework Adapter
132/BOFU/C_PPF_CONFBO Node Specific settings for PPF usage16NODE_KEYNodevarbinary160
133/BOFU/C_PPF_DOADirect Outputs: w/o PPF, w/o History; Immediate Outputs13NODE_KEYNodevarbinary160
134/BOFU/C_PPF_PROFAssign PPF Profiles for Business Object Nodes12NODE_KEYNodevarbinary160
135/BOFU/DPPFCNTRPPF Container: Persistant connection to PPF from BOPF3NODE_KEYNodevarbinary160
136/BOFU/DPPFEXT_COutput Management: Ext Comm - PDF Content Repository7NODE_KEYNodevarbinary160
TOPProduct Cost Planning
137CKECPWORKSPACEHierarchical Worklists and Assignments in ECP10NODE_KEYBusiness Key of the Nodenvarchar2550
TOPProfitability Analysis
138TKETE01Operating Concern Templates: Sub-Tree Structure2NODE_KEYTree Control: Node Keynvarchar120
139TKETE01_TText Table for Operating Concern Templates:Subtree Structure1NODE_KEYTree Control: Node Keynvarchar120
TOPProject System
140PSHLPDB_HIER_TMPTable to store temporary hierarchy data34NODE_KEYALV Tree Control: Node Keynvarchar120
TOPReal Estate Management
141BPOBIMMOBusiness Partner - Object Relationship: Real Estate10NODE_KEYNodesnvarchar120
TOPRemaining Beverage - Obsolete Objects
142/BEV3/CHAGTREEContract Tree3NODE_KEYNode Identifiernvarchar60
143/BEV3/CHAGTREETContract Tree - Free Text3NODE_KEYNode Identifiernvarchar60
TOPReusable Components of Business Suite Foundation
144/BOBF/C_ATT_BOAttachment Types for Business Object Nodes7NODE_KEYNodeIDvarbinary160
145/BOFU/C_TXC_DSText Schema: Assignment to BO/Node7NODE_KEYNodeIDvarbinary160
146/BOFU/S_TXC_DSText Schema: Default assignment to BO/Node4NODE_KEYNodeIDvarbinary160
TOPSAP Business Partner
147BUT030GBP Where-Used List: Generic Nodes5NODE_KEYCurrent nodenvarchar100
148TB018VBDT Object Usage: Variant Table4NODE_KEYCurrent nodenvarchar100
149TBZ5BDT: Where-Used List - Structure Table3NODE_KEYCurrent nodenvarchar100
150TBZ5FBDT Object Usage: Variant Table4NODE_KEYCurrent nodenvarchar100
151TBZ5SBDT: Where-Used List - Transport Shadow Table3NODE_KEYCurrent nodenvarchar100
TOPSAP Records Management
152SRMORGFAVBC-RM: Organizer Favorites5NODE_KEYnvarchar640
153SRMORGRL2BC-RM : Roles (new)6NODE_KEYnvarchar640
TOPSpain
154T5EF5Definition of assignment trees3NODE_KEYTree Control: Node Keynvarchar120
TOPSyntax, Compiler, Runtime
155ABAPDOCU_TREETree Structure of ABAP Keyword Documentation3NODE_KEYTree Model: Node Keyntext10737418230
TOPTax Reporting
156OIUX3_PORT_TREETax Reporting - Generic Portal Tree Control Table2NODE_KEYTree Control: Node Keynvarchar120
TOPTransaction Management
157VTBPAFin. Transaction: Assignment of Further Business Partners10NODE_KEYNodesnvarchar120
TOPUpstream Graphics
158OIUGT_NODE_XREFUpstream Graphics Node Type Cross Reference4NODE_KEYGraphical Tool Node Keynvarchar1000
159OIUGT_NODE_XREFTUpstream Graphics Node Type Cross Reference5NODE_KEYGraphical Tool Node Keynvarchar1000
TOPUse Subcomponents
160SIN_T_LINKNavigation Area of SAPBPT Workplace3NODE_KEYTree Control: Node Keynvarchar120
161SOSUBUTWorkplace: Private Sort of Folders Subscribed to5NODE_KEYTree Control: Node Keynvarchar120