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

139 tablesERP 6.0 

Financial Accounting :: Special Purpose Ledger :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ARC_IDX_AT131Index table for ACCTIT/ACCTHD/ACCTCR archivesBasic Functions
2ERP EHP76.0ARC_IDX_IT131Archive index table for FI-SL line itemsBasic Functions
3ERP EHP76.0FAGL_CUS_GENINFO51New General Ledger Accounting: Generation Status (Customer)Basic Functions
4ERP EHP76.0GGREFA475Example for Global FI-SL Line Items (Actual)Basic Functions
5ERP EHP76.0GGREFC32Example for Global FISL Objct Table 2 (Transactn Attributes)Basic Functions
6ERP EHP76.0GGREFO122Example for Global Object Table 1 (Object/Partner)Basic Functions
7ERP EHP76.0GGREFP1275Example for Global FI-SL Line Items (Plan)Basic Functions
8ERP EHP76.0GGREFT1134Example for Global FI-SL Summary TableBasic Functions
9ERP EHP76.0GLFUNCA454Actual Line Items Table for Cost of Sales AccountingBasic Functions
10ERP EHP76.0GLFUNCC62Object Table 2 for Cost of Sales AccountingBasic Functions
11ERP EHP76.0GLFUNCO102Object Table 1 for Cost of Sales AccountingBasic Functions
12ERP EHP76.0GLFUNCP1094Plan Line Items Table for Cost of Sales AccountingBasic Functions
13ERP EHP76.0GLFUNCT943Totals Table for Cost of Sales AccountingBasic Functions
14ERP EHP76.0GLFUNCU534Rollup line item tables with function area for IDESBasic Functions
15ERP EHP76.0GLFUNCV1174Rollup plan line items table with function area for IDESBasic Functions
16ERP EHP76.0GLIDXA151Index to Find FI-SL Documents Based on AWKEYBasic Functions
17ERP EHP76.0GLOO1151Object Table for FI-SL Table GLTO1Basic Functions
18ERP EHP76.0GLOO2191Object Table for GLT02: GlobalBasic Functions
19ERP EHP76.0GLOO3151Object Table for FI-SL Table GLTO3Basic Functions
20ERP EHP76.0GLP0811Local Logical General Ledger Plan Line ItemsBasic Functions
21ERP EHP76.0GLPO11334Plan Line Items for Object TableBasic Functions
22ERP EHP76.0GLPO21414Plan Line Items for Object Table GlobalBasic Functions
23ERP EHP76.0GLPO31334Plan Line Items for Object TableBasic Functions
24ERP EHP76.0GLREFA455Example for Local FI-SL Line Items (Actual)Basic Functions
25ERP EHP76.0GLREFC32Example for Loc. FISL Objct Table 2 (Transaction Attributes)Basic Functions
26ERP EHP76.0GLREFO112Example for Local Object Table 1 (Object/Partner)Basic Functions
27ERP EHP76.0GLREFP1255Example for Local FI-SL Line Items (Plan)Basic Functions
28ERP EHP76.0GLREFT1114Example for Local FI-SL Summary TableBasic Functions
29ERP EHP76.0GLREFU563Example for FI-SL Rollup Line Items (Actual)Basic Functions
30ERP EHP76.0GLREFV1363Example for Rollup FI-SL Line Items (Plan)Basic Functions
31ERP EHP76.0GLSO1544FI-SL Line Item Table with Objects for GLTO1Basic Functions
32ERP EHP76.0GLSO2624FI-SL Table with Objects, Structure corresponds to GLS2Basic Functions
33ERP EHP76.0GLSO3544FI-SL LI Table with Objects for GLTO3Basic Functions
34ERP EHP76.0GLT0633G/L account master record transaction figuresBasic Functions
35ERP EHP76.0GLTO11182FI-SL Table with Objects, Structure Corresponds to GLT1Basic Functions
36ERP EHP76.0GLTO21262FI-SL Table with Objects, Structure Corresponds to GLT2Basic Functions
37ERP EHP76.0GLTO31182FISL Table with Objects, Amounts and Quantities in Format P9Basic Functions
38ERP EHP76.0SMFISL161Spec. FI-SL Data in Monitor (See Schedman_specific_fisl)Basic Functions
39ERP EHP76.0T000G31Cross-Client FI-SL PostingsBasic Functions
40ERP EHP76.0T001C141Valid Posting Periods for Global CompaniesBasic Functions
41ERP EHP76.0T022201FI-SL Activity: Fixed DataBasic Functions
42ERP EHP76.0T022F51Format Table (Grouping of the Sender Tables)Basic Functions
43ERP EHP76.0T022FT31Texts for Formats used in FI-SLBasic Functions
44ERP EHP76.0T022T31FI-SL Activities: TextBasic Functions
45ERP EHP76.0T800A351FI-SL tablesBasic Functions
46ERP EHP76.0T800A_KEYFIG61FI-SL: Key Figures for Table GroupBasic Functions
47ERP EHP76.0T800B21Generated Archive and Database Reports for FI-SL TablesBasic Functions
48ERP EHP76.0T800D201Fields for Master Data CheckBasic Functions
49ERP EHP76.0T800DOM111Fixed exitsBasic Functions
50ERP EHP76.0T800G21Flexible general ledger installation checkBasic Functions
51ERP EHP76.0T800HISTH81Log Tables for Program Runs in FI-GL or FI-SL: HeaderBasic Functions
52ERP EHP76.0T800HISTP91Log Tables for Program Runs in FI-GL or FI-SL: ItemsBasic Functions
53ERP EHP76.0T800M71FI-SL: Fixed Field MovementsBasic Functions
54ERP EHP76.0T800O71Object management FI-GL/FI-SLBasic Functions
55ERP EHP76.0T807132Rollup SequenceBasic Functions
56ERP EHP76.0T807H251Rollup Header InformationBasic Functions
57ERP EHP76.0T807R141FI-SL Rollup: History of ExecutionsBasic Functions
58ERP EHP76.0T807T51FI-SL Rollup textsBasic Functions
59ERP EHP76.0T811U51Table Information Allocation Sender/Receiver RelationshipBasic Functions
60ERP EHP76.0T820552Planning ParametersBasic Functions
61ERP EHP76.0T820T41Planning Parameter DescriptionsBasic Functions
62ERP EHP76.0T82251Planning Parameter ClassesBasic Functions
63ERP EHP76.0T822T41Planning Parameter Class DescriptionsBasic Functions
64ERP EHP76.0T830A81FI-SL Master Record TableBasic Functions
65ERP EHP76.0T830B81FI-SL Master Record TableBasic Functions
66ERP EHP76.0T830D81FI-SL Master Record TableBasic Functions
67ERP EHP76.0T831A81FI-SL Master data textBasic Functions
68ERP EHP76.0T831B81FI-SL Master Record TableBasic Functions
69ERP EHP76.0T831D81FI-SL Master data textBasic Functions
70ERP EHP76.0T881431Ledger MasterBasic Functions
71ERP EHP76.0T881T41FI-SL Ledger textBasic Functions
72ERP EHP76.0T881W41Possible Combinations of Currency Keys in FI-SLBasic Functions
73ERP EHP76.0T881Z41Additional Ledger with Special Calculation TypeBasic Functions
74ERP EHP76.0T881_KEYFIG41FI-SL: Key Figures per LedgerBasic Functions
75ERP EHP76.0T882201Company Code/Ledger AssignmentBasic Functions
76ERP EHP76.0T882C231Global Company-Ledger Assignment in FI-SLBasic Functions
77ERP EHP76.0T88341User Table FieldsBasic Functions
78ERP EHP76.0T883S31FI-SL User TablesBasic Functions
79ERP EHP76.0T883T41Descriptions of FI-SL user tablesBasic Functions
80ERP EHP76.0T88691FI-SL ActivitiesBasic Functions
81ERP EHP76.0T886A81Activity/Ledger InformationBasic Functions
82ERP EHP76.0T886B91Activity/Ledger/CCode InformationBasic Functions
83ERP EHP76.0T886C91Activity/Ledger/Company InformationBasic Functions
84ERP EHP76.0T886TCODE31FI-SL: Monitor Procedure - TransactionBasic Functions
85ERP EHP76.0T888111Field Movement Header TableBasic Functions
86ERP EHP76.0T888M101FI-SL Field AssignmentsBasic Functions
87ERP EHP76.0T888T41FI-SL Field Assignment TextsBasic Functions
88ERP EHP76.0T88981FI-SL Document TypesBasic Functions
89ERP EHP76.0T889TE41Document Type TextsBasic Functions
90ERP EHP76.0T89031FI-SL: Boolean FormulasBasic Functions
91ERP EHP76.0T892U91Rollup SubstitutionBasic Functions
92ERP EHP76.0T89351Ledger Selection ConditionsBasic Functions
93ERP EHP76.0T89491FI-SL and FI-LC VersionsBasic Functions
94ERP EHP76.0T894T51FI-SL and FI-LC Version TextsBasic Functions
95ERP EHP76.0TGUMS61FI-SL: Convert TablesBasic Functions
96ERP EHP76.0TLDGRP21Ledger Group FI-SLBasic Functions
97ERP EHP76.0TLDGRPT41Ledger Group Texts (FI-SL)Basic Functions
98ERP EHP76.0TLDGRP_MAP31Assignment of Ledgers to Ledger GroupsBasic Functions
99ERP EHP76.0TRWLVH31List of variants for FI-SL line item reports (header)Basic Functions
100ERP EHP76.0TRWLVHT41List of variants for FI-SL line item reports (texts)Basic Functions
101ERP EHP76.0TRWLVL51List of variants for FI-SL line item reports (fields)Basic Functions
Financial Accounting :: Special Purpose Ledger :: Basic Functions :: Master Data :: Sets
ProductVersionTableColumnsIndexesDescriptionModule
102ERP EHP76.0HDB_SETLEAF161Leaf view for SLT hierarchy replication (primary)Sets
103ERP EHP76.0HDB_SETLEAF261Leaf view for SLT hierarchy replication (secondary)Sets
104ERP EHP76.0HDB_SETNODE41Node view for SLT hierarchy replicationSets
105ERP EHP76.0RWSHEADER61Report Writer Data for Set HeaderSets
106ERP EHP76.0RWSLINE131Report Writer Data for the Set LineSets
107ERP EHP76.0SETCLS51Set ClassesSets
108ERP EHP76.0SETCLST51Set Class DescriptionsSets
109ERP EHP76.0SETCLS_CD31Change document indicator per set classSets
110ERP EHP76.0SETDATA61Sets - Contents (before Release 4.0)Sets
111ERP EHP76.0SETDTEL21Sets: Representative data elementsSets
112ERP EHP76.0SETEXITS11Exits for Formula VariablesSets
113ERP EHP76.0SETEXITST31Description of Exits for Formula VariablesSets
114ERP EHP76.0SETHANACLASSES31Hierarchy classes with HANA accelelerationSets
115ERP EHP76.0SETHANAHIER0101151Hierarchy table for Cost Center GroupsSets
116ERP EHP76.0SETHANAHIER0102141Hierarchy table for Cost Element GroupsSets
117ERP EHP76.0SETHANAHIER0103141Hierarchy table for Order GroupsSets
118ERP EHP76.0SETHANAHIER0106141Hierarchy table for Profit Center GroupsSets
119ERP EHP76.0SETHANAHIER0109141Hierarchy table for Account GroupsSets
120ERP EHP76.0SETHANA_HIER61Status of set hierarchies in HANASets
121ERP EHP76.0SETHANA_HVIEW__T31Generation template for HANA hierarchy viewsSets
122ERP EHP76.0SETHANA_STATUS243Status of set hierarchies in HANASets
123ERP EHP76.0SETHEADER233Set Header and DirectorySets
124ERP EHP76.0SETHEADERT61Short Description of SetsSets
125ERP EHP76.0SETHEADERTRANS71Changes Made to Sets by TransportsSets
126ERP EHP76.0SETLEAF101Values in SetsSets
127ERP EHP76.0SETLINET71Short Description of Set LineSets
128ERP EHP76.0SETNODE92Lower-level sets in setsSets
129ERP EHP76.0SETO2N41Tables and Set Names for Sets in New Storage FormSets
130ERP EHP76.0SETS131Sets - Contents (before Release 2.2)Sets
131ERP EHP76.0SETUSE_BER51Set Use in Authorizations (Area of Responsibility)Sets
132ERP EHP76.0SETUSE_REP62Set Use in Reports and LibrariesSets
133ERP EHP76.0T800S281FI-SL Set Table (before Release 4.0)Sets
134ERP EHP76.0T800Y51FI-SL Set Texts (before Release 4.0)Sets
135ERP EHP76.0T802G214Sets: VariablesSets
136ERP EHP76.0T802GU_SET42Use of Variables in SetsSets
137ERP EHP76.0T802GU_VAR32Use of Variables in Formula VariablesSets
138ERP EHP76.0T802T41Sets: Short Descriptions of VariablesSets
139ERP EHP76.0T804FU_SET52Use of Key Figures in Key Figure SetsSets