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

241 tablesERP 6.0 

Financial Accounting :: Special Purpose Ledger
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/CCIS/PBU18A585PBU18: Actual line item tableSpecial Purpose Ledger
2ERP EHP76.0/CCIS/PBU18C32PBU18: Object table 2Special Purpose Ledger
3ERP EHP76.0/CCIS/PBU18O182PBU18: Object tableSpecial Purpose Ledger
4ERP EHP76.0/CCIS/PBU18P1385PBU18: Plan line item tableSpecial Purpose Ledger
5ERP EHP76.0/CCIS/PBU18T1244PBU18: Summary table xSpecial Purpose Ledger
6ERP EHP76.0/CCIS/PROFTAX0081Object Table Number:00Special Purpose Ledger
7ERP EHP76.0/CCIS/PROFTAX0171Object Table Number:01Special Purpose Ledger
8ERP EHP76.0/CCIS/PROFTAX0251Object Table Number:02Special Purpose Ledger
9ERP EHP76.0/CCIS/PROFTAX03171Object Table Number:03Special Purpose Ledger
10ERP EHP76.0/CCIS/PROFTAX0431Object Table Number:04Special Purpose Ledger
11ERP EHP76.0/CCIS/PROFTAX0531Object Table Number:05Special Purpose Ledger
12ERP EHP76.0/CCIS/PROFTAX06131Object Table Number:06Special Purpose Ledger
13ERP EHP76.0/CCIS/PROFTAX0731Object Table Number:07Special Purpose Ledger
14ERP EHP76.0/CCIS/PROFTAX0831Object Table Number:08Special Purpose Ledger
15ERP EHP76.0/CCIS/PROFTAXA584Actual Line Items Table for General LedgerSpecial Purpose Ledger
16ERP EHP76.0/CCIS/PROFTAXP1344Plan Line Items Table for General LedgerSpecial Purpose Ledger
17ERP EHP76.0/CCIS/PROFTAXT1342Totals Table for General LedgerSpecial Purpose Ledger
Financial Accounting :: Special Purpose Ledger :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
18ERP EHP76.0ARC_IDX_AT131Index table for ACCTIT/ACCTHD/ACCTCR archivesBasic Functions
19ERP EHP76.0ARC_IDX_IT131Archive index table for FI-SL line itemsBasic Functions
20ERP EHP76.0FAGL_CUS_GENINFO51New General Ledger Accounting: Generation Status (Customer)Basic Functions
21ERP EHP76.0GGREFA475Example for Global FI-SL Line Items (Actual)Basic Functions
22ERP EHP76.0GGREFC32Example for Global FISL Objct Table 2 (Transactn Attributes)Basic Functions
23ERP EHP76.0GGREFO122Example for Global Object Table 1 (Object/Partner)Basic Functions
24ERP EHP76.0GGREFP1275Example for Global FI-SL Line Items (Plan)Basic Functions
25ERP EHP76.0GGREFT1134Example for Global FI-SL Summary TableBasic Functions
26ERP EHP76.0GLFUNCA454Actual Line Items Table for Cost of Sales AccountingBasic Functions
27ERP EHP76.0GLFUNCC62Object Table 2 for Cost of Sales AccountingBasic Functions
28ERP EHP76.0GLFUNCO102Object Table 1 for Cost of Sales AccountingBasic Functions
29ERP EHP76.0GLFUNCP1094Plan Line Items Table for Cost of Sales AccountingBasic Functions
30ERP EHP76.0GLFUNCT943Totals Table for Cost of Sales AccountingBasic Functions
31ERP EHP76.0GLFUNCU534Rollup line item tables with function area for IDESBasic Functions
32ERP EHP76.0GLFUNCV1174Rollup plan line items table with function area for IDESBasic Functions
33ERP EHP76.0GLIDXA151Index to Find FI-SL Documents Based on AWKEYBasic Functions
34ERP EHP76.0GLOO1151Object Table for FI-SL Table GLTO1Basic Functions
35ERP EHP76.0GLOO2191Object Table for GLT02: GlobalBasic Functions
36ERP EHP76.0GLOO3151Object Table for FI-SL Table GLTO3Basic Functions
37ERP EHP76.0GLP0811Local Logical General Ledger Plan Line ItemsBasic Functions
38ERP EHP76.0GLPO11334Plan Line Items for Object TableBasic Functions
39ERP EHP76.0GLPO21414Plan Line Items for Object Table GlobalBasic Functions
40ERP EHP76.0GLPO31334Plan Line Items for Object TableBasic Functions
41ERP EHP76.0GLREFA455Example for Local FI-SL Line Items (Actual)Basic Functions
42ERP EHP76.0GLREFC32Example for Loc. FISL Objct Table 2 (Transaction Attributes)Basic Functions
43ERP EHP76.0GLREFO112Example for Local Object Table 1 (Object/Partner)Basic Functions
44ERP EHP76.0GLREFP1255Example for Local FI-SL Line Items (Plan)Basic Functions
45ERP EHP76.0GLREFT1114Example for Local FI-SL Summary TableBasic Functions
46ERP EHP76.0GLREFU563Example for FI-SL Rollup Line Items (Actual)Basic Functions
47ERP EHP76.0GLREFV1363Example for Rollup FI-SL Line Items (Plan)Basic Functions
48ERP EHP76.0GLSO1544FI-SL Line Item Table with Objects for GLTO1Basic Functions
49ERP EHP76.0GLSO2624FI-SL Table with Objects, Structure corresponds to GLS2Basic Functions
50ERP EHP76.0GLSO3544FI-SL LI Table with Objects for GLTO3Basic Functions
51ERP EHP76.0GLT0633G/L account master record transaction figuresBasic Functions
52ERP EHP76.0GLTO11182FI-SL Table with Objects, Structure Corresponds to GLT1Basic Functions
53ERP EHP76.0GLTO21262FI-SL Table with Objects, Structure Corresponds to GLT2Basic Functions
54ERP EHP76.0GLTO31182FISL Table with Objects, Amounts and Quantities in Format P9Basic Functions
55ERP EHP76.0SMFISL161Spec. FI-SL Data in Monitor (See Schedman_specific_fisl)Basic Functions
56ERP EHP76.0T000G31Cross-Client FI-SL PostingsBasic Functions
57ERP EHP76.0T001C141Valid Posting Periods for Global CompaniesBasic Functions
58ERP EHP76.0T022201FI-SL Activity: Fixed DataBasic Functions
59ERP EHP76.0T022F51Format Table (Grouping of the Sender Tables)Basic Functions
60ERP EHP76.0T022FT31Texts for Formats used in FI-SLBasic Functions
61ERP EHP76.0T022T31FI-SL Activities: TextBasic Functions
62ERP EHP76.0T800A351FI-SL tablesBasic Functions
63ERP EHP76.0T800A_KEYFIG61FI-SL: Key Figures for Table GroupBasic Functions
64ERP EHP76.0T800B21Generated Archive and Database Reports for FI-SL TablesBasic Functions
65ERP EHP76.0T800D201Fields for Master Data CheckBasic Functions
66ERP EHP76.0T800DOM111Fixed exitsBasic Functions
67ERP EHP76.0T800G21Flexible general ledger installation checkBasic Functions
68ERP EHP76.0T800HISTH81Log Tables for Program Runs in FI-GL or FI-SL: HeaderBasic Functions
69ERP EHP76.0T800HISTP91Log Tables for Program Runs in FI-GL or FI-SL: ItemsBasic Functions
70ERP EHP76.0T800M71FI-SL: Fixed Field MovementsBasic Functions
71ERP EHP76.0T800O71Object management FI-GL/FI-SLBasic Functions
72ERP EHP76.0T807132Rollup SequenceBasic Functions
73ERP EHP76.0T807H251Rollup Header InformationBasic Functions
74ERP EHP76.0T807R141FI-SL Rollup: History of ExecutionsBasic Functions
75ERP EHP76.0T807T51FI-SL Rollup textsBasic Functions
76ERP EHP76.0T811U51Table Information Allocation Sender/Receiver RelationshipBasic Functions
77ERP EHP76.0T820552Planning ParametersBasic Functions
78ERP EHP76.0T820T41Planning Parameter DescriptionsBasic Functions
79ERP EHP76.0T82251Planning Parameter ClassesBasic Functions
80ERP EHP76.0T822T41Planning Parameter Class DescriptionsBasic Functions
81ERP EHP76.0T830A81FI-SL Master Record TableBasic Functions
82ERP EHP76.0T830B81FI-SL Master Record TableBasic Functions
83ERP EHP76.0T830D81FI-SL Master Record TableBasic Functions
84ERP EHP76.0T831A81FI-SL Master data textBasic Functions
85ERP EHP76.0T831B81FI-SL Master Record TableBasic Functions
86ERP EHP76.0T831D81FI-SL Master data textBasic Functions
87ERP EHP76.0T881431Ledger MasterBasic Functions
88ERP EHP76.0T881T41FI-SL Ledger textBasic Functions
89ERP EHP76.0T881W41Possible Combinations of Currency Keys in FI-SLBasic Functions
90ERP EHP76.0T881Z41Additional Ledger with Special Calculation TypeBasic Functions
91ERP EHP76.0T881_KEYFIG41FI-SL: Key Figures per LedgerBasic Functions
92ERP EHP76.0T882201Company Code/Ledger AssignmentBasic Functions
93ERP EHP76.0T882C231Global Company-Ledger Assignment in FI-SLBasic Functions
94ERP EHP76.0T88341User Table FieldsBasic Functions
95ERP EHP76.0T883S31FI-SL User TablesBasic Functions
96ERP EHP76.0T883T41Descriptions of FI-SL user tablesBasic Functions
97ERP EHP76.0T88691FI-SL ActivitiesBasic Functions
98ERP EHP76.0T886A81Activity/Ledger InformationBasic Functions
99ERP EHP76.0T886B91Activity/Ledger/CCode InformationBasic Functions
100ERP EHP76.0T886C91Activity/Ledger/Company InformationBasic Functions
101ERP EHP76.0T886TCODE31FI-SL: Monitor Procedure - TransactionBasic Functions
102ERP EHP76.0T888111Field Movement Header TableBasic Functions
103ERP EHP76.0T888M101FI-SL Field AssignmentsBasic Functions
104ERP EHP76.0T888T41FI-SL Field Assignment TextsBasic Functions
105ERP EHP76.0T88981FI-SL Document TypesBasic Functions
106ERP EHP76.0T889TE41Document Type TextsBasic Functions
107ERP EHP76.0T89031FI-SL: Boolean FormulasBasic Functions
108ERP EHP76.0T892U91Rollup SubstitutionBasic Functions
109ERP EHP76.0T89351Ledger Selection ConditionsBasic Functions
110ERP EHP76.0T89491FI-SL and FI-LC VersionsBasic Functions
111ERP EHP76.0T894T51FI-SL and FI-LC Version TextsBasic Functions
112ERP EHP76.0TGUMS61FI-SL: Convert TablesBasic Functions
113ERP EHP76.0TLDGRP21Ledger Group FI-SLBasic Functions
114ERP EHP76.0TLDGRPT41Ledger Group Texts (FI-SL)Basic Functions
115ERP EHP76.0TLDGRP_MAP31Assignment of Ledgers to Ledger GroupsBasic Functions
116ERP EHP76.0TRWLVH31List of variants for FI-SL line item reports (header)Basic Functions
117ERP EHP76.0TRWLVHT41List of variants for FI-SL line item reports (texts)Basic Functions
118ERP EHP76.0TRWLVL51List of variants for FI-SL line item reports (fields)Basic Functions
Financial Accounting :: Special Purpose Ledger :: Information System
ProductVersionTableColumnsIndexesDescriptionModule
119ERP EHP76.0GREP131Report Writer: File of Stored ReportsInformation System
120ERP EHP76.0GREP_VARCHAR91Report Writer: Varied extract characteristicsInformation System
121ERP EHP76.0GRIX164Report Writer: Directory of Stored DataInformation System
122ERP EHP76.0GRIX_AUT121Report Writer: Values of Adjustment-Related CharacteristicsInformation System
123ERP EHP76.0GRIX_SEL91Report Writer: Selection parameters for stored dataInformation System
124ERP EHP76.0GRIX_SRCH31Fields for finding Report Writer extractsInformation System
125ERP EHP76.0GRIX_TXT91Report Writer: Texts for stored dataInformation System
126ERP EHP76.0GRIX_VAR51Report Writer: Variable for a report group versionInformation System
127ERP EHP76.0GRIX_VARP161Variation parameters for extracts (Report Writer)Information System
128ERP EHP76.0GRRT81Report Writer: Runtime information for generated programsInformation System
129ERP EHP76.0GRW_DEL_OBJECTS61Report Writer Deleted ObjectsInformation System
130ERP EHP76.0GRW_HISTORY102Report Writer Changes historyInformation System
131ERP EHP76.0T8001221Report Writer: ReportsInformation System
132ERP EHP76.0T800AIS21Directory of InfoSource structures for FI-SL tablesInformation System
133ERP EHP76.0T800AIS_PI31Directory of BW Structures for FI-SL TablesInformation System
134ERP EHP76.0T800T51Report Writer: Texts for ReportsInformation System
135ERP EHP76.0T801B91Report Writer: Texts for Logical RowsInformation System
136ERP EHP76.0T801D241Report Writer: Row/Column CharacteristicsInformation System
137ERP EHP76.0T801E101Report Writer: Selection SetsInformation System
138ERP EHP76.0T801F61Report Writer: Rest Blocks (Rows, Columns)Information System
139ERP EHP76.0T801G491Report Writer: SectionsInformation System
140ERP EHP76.0T801H141Report Writer: Parallel ReportsInformation System
141ERP EHP76.0T801K191Report Writer: LibrariesInformation System
142ERP EHP76.0T801L71Report Writer: Library FieldsInformation System
143ERP EHP76.0T801M191Report Writer: Rows/ColumnsInformation System
144ERP EHP76.0T801Q41Report Writer: Key Figures for LibrariesInformation System
145ERP EHP76.0T801S131Report Writer: Cell AssignmentInformation System
146ERP EHP76.0T801T51Report Writer: Texts for Parallel ReportsInformation System
147ERP EHP76.0T801W61Report Writer: Standard Layout - Lang.-Dependent (new)Information System
148ERP EHP76.0T801X901Report Writer: Standard Layout - Lang. Independent (new)Information System
149ERP EHP76.0T802B41Report Writer: Receiver Report Control ( part 1 )Information System
150ERP EHP76.0T802C71Report Writer: Receiver Report Control (part 2)Information System
151ERP EHP76.0T802D31ABAP Receiver Programs for Report WriterInformation System
152ERP EHP76.0T803F71Report Writer: Key Figure Blocks (Formulas)Information System
153ERP EHP76.0T803G91Report Writer: Key Figure Blocks (Cells in Formulas)Information System
154ERP EHP76.0T803H141Report Writer: Row FormulasInformation System
155ERP EHP76.0T803J291Report Writer: Report GroupsInformation System
156ERP EHP76.0T803L52Report Writer: Entries in Report GroupsInformation System
157ERP EHP76.0T803T141Report Writer: Report Group TextsInformation System
158ERP EHP76.0T803V71Report Writer: Generated program versionsInformation System
159ERP EHP76.0T803VP52Report Writer: Generated program versionsInformation System
160ERP EHP76.0T803VP_TRANS42Report Writer: Generated Program Versions for TransportInformation System
161ERP EHP76.0T804A241Report Writer: File DescriptionInformation System
162ERP EHP76.0T804B541Report Writer: Key figuresInformation System
163ERP EHP76.0T804BT71Report Writer: Texts for basic key figuresInformation System
164ERP EHP76.0T804C211Report Writer: Special FieldsInformation System
165ERP EHP76.0T804E91Report Writer: Summary of TablesInformation System
166ERP EHP76.0T804F73Report Writer: Key FiguresInformation System
167ERP EHP76.0T804G61Report Writer: Texts for Key FiguresInformation System
168ERP EHP76.0T804H41Report Writer: Database Fields for ExitsInformation System
169ERP EHP76.0T804I11Report Writer: Supported LanguagesInformation System
170ERP EHP76.0T804J41Report Writer: Read module for table class SInformation System
171ERP EHP76.0T804T31Texts for reporting tableInformation System
172ERP EHP76.0T881IS41FI-SL LedgerInformation System
173ERP EHP76.0T881IS_PI71Assignment of TT/SI DataSource for FI-SL Ledger (Plug-In)Information System
Financial Accounting :: Special Purpose Ledger :: Validation, Substitution and Rules
ProductVersionTableColumnsIndexesDescriptionModule
174ERP EHP76.0GB0151Classes for Boolean FormulasValidation, Substitution and Rules
175ERP EHP76.0GB01151Rule Manager: 2D Structures in the Boolean ClassesValidation, Substitution and Rules
176ERP EHP76.0GB01C61Classes for Boolean Formulas for CustomersValidation, Substitution and Rules
177ERP EHP76.0GB0231Valid ClassesValidation, Substitution and Rules
178ERP EHP76.0GB02C21Customer Message IDs for ValidationsValidation, Substitution and Rules
179ERP EHP76.0GB02T31Boolean Logic: Text Table for Boolean ClassesValidation, Substitution and Rules
180ERP EHP76.0GB0391Validation/Substitution UserValidation, Substitution and Rules
181ERP EHP76.0GB03T31Validation/Substitution Application Area TextValidation, Substitution and Rules
182ERP EHP76.0GB3161Validation/Substitution Callup PointsValidation, Substitution and Rules
183ERP EHP76.0GB31C41Boolean Rules: Form Pool Naming RangeValidation, Substitution and Rules
184ERP EHP76.0GB31T41Validation/Substitution Callup Point TextValidation, Substitution and Rules
185ERP EHP76.0GB90131Boolean Formula Header for Rules and Boolean FunctionsValidation, Substitution and Rules
186ERP EHP76.0GB90141Boolean Formula DataValidation, Substitution and Rules
187ERP EHP76.0GB90342Mapping of shortname and SETID of sets used in boolean expr.Validation, Substitution and Rules
188ERP EHP76.0GB90541Usage of Boolean RulesValidation, Substitution and Rules
189ERP EHP76.0GB90641Rule: Usage of Rules in RulesValidation, Substitution and Rules
190ERP EHP76.0GB90741Rule: Usage of Rules in SubstitutionsValidation, Substitution and Rules
191ERP EHP76.0GB90841Rule: Usage of Rules in ValidationsValidation, Substitution and Rules
192ERP EHP76.0GB90T41Texts for Boolean FormulasValidation, Substitution and Rules
193ERP EHP76.0GB92141SubstitutionsValidation, Substitution and Rules
194ERP EHP76.0GB92141Substitution ConditionsValidation, Substitution and Rules
195ERP EHP76.0GB921T51Substitution: Text Table for Substitution StepsValidation, Substitution and Rules
196ERP EHP76.0GB922111Substitution ConstantsValidation, Substitution and Rules
197ERP EHP76.0GB92541Usage of SubstitutionsValidation, Substitution and Rules
198ERP EHP76.0GB92T41Texts for SubstitutionsValidation, Substitution and Rules
199ERP EHP76.0GB93131ValidationValidation, Substitution and Rules
200ERP EHP76.0GB931161Validation ActivitiesValidation, Substitution and Rules
201ERP EHP76.0GB93541Usage of ValidationsValidation, Substitution and Rules
202ERP EHP76.0GB93T41Texts for ValidationsValidation, Substitution and Rules
203ERP EHP76.0GBC131Configuration for the Boolean Rule ProcessorValidation, Substitution and Rules
Financial Accounting :: Special Purpose Ledger :: Basic Functions :: Master Data :: Sets
ProductVersionTableColumnsIndexesDescriptionModule
204ERP EHP76.0HDB_SETLEAF161Leaf view for SLT hierarchy replication (primary)Sets
205ERP EHP76.0HDB_SETLEAF261Leaf view for SLT hierarchy replication (secondary)Sets
206ERP EHP76.0HDB_SETNODE41Node view for SLT hierarchy replicationSets
207ERP EHP76.0RWSHEADER61Report Writer Data for Set HeaderSets
208ERP EHP76.0RWSLINE131Report Writer Data for the Set LineSets
209ERP EHP76.0SETCLS51Set ClassesSets
210ERP EHP76.0SETCLST51Set Class DescriptionsSets
211ERP EHP76.0SETCLS_CD31Change document indicator per set classSets
212ERP EHP76.0SETDATA61Sets - Contents (before Release 4.0)Sets
213ERP EHP76.0SETDTEL21Sets: Representative data elementsSets
214ERP EHP76.0SETEXITS11Exits for Formula VariablesSets
215ERP EHP76.0SETEXITST31Description of Exits for Formula VariablesSets
216ERP EHP76.0SETHANACLASSES31Hierarchy classes with HANA accelelerationSets
217ERP EHP76.0SETHANAHIER0101151Hierarchy table for Cost Center GroupsSets
218ERP EHP76.0SETHANAHIER0102141Hierarchy table for Cost Element GroupsSets
219ERP EHP76.0SETHANAHIER0103141Hierarchy table for Order GroupsSets
220ERP EHP76.0SETHANAHIER0106141Hierarchy table for Profit Center GroupsSets
221ERP EHP76.0SETHANAHIER0109141Hierarchy table for Account GroupsSets
222ERP EHP76.0SETHANA_HIER61Status of set hierarchies in HANASets
223ERP EHP76.0SETHANA_HVIEW__T31Generation template for HANA hierarchy viewsSets
224ERP EHP76.0SETHANA_STATUS243Status of set hierarchies in HANASets
225ERP EHP76.0SETHEADER233Set Header and DirectorySets
226ERP EHP76.0SETHEADERT61Short Description of SetsSets
227ERP EHP76.0SETHEADERTRANS71Changes Made to Sets by TransportsSets
228ERP EHP76.0SETLEAF101Values in SetsSets
229ERP EHP76.0SETLINET71Short Description of Set LineSets
230ERP EHP76.0SETNODE92Lower-level sets in setsSets
231ERP EHP76.0SETO2N41Tables and Set Names for Sets in New Storage FormSets
232ERP EHP76.0SETS131Sets - Contents (before Release 2.2)Sets
233ERP EHP76.0SETUSE_BER51Set Use in Authorizations (Area of Responsibility)Sets
234ERP EHP76.0SETUSE_REP62Set Use in Reports and LibrariesSets
235ERP EHP76.0T800S281FI-SL Set Table (before Release 4.0)Sets
236ERP EHP76.0T800Y51FI-SL Set Texts (before Release 4.0)Sets
237ERP EHP76.0T802G214Sets: VariablesSets
238ERP EHP76.0T802GU_SET42Use of Variables in SetsSets
239ERP EHP76.0T802GU_VAR32Use of Variables in Formula VariablesSets
240ERP EHP76.0T802T41Sets: Short Descriptions of VariablesSets
241ERP EHP76.0T804FU_SET52Use of Key Figures in Key Figure SetsSets