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

222 tablesERP 6.0 

Public Sector Management :: Funds Management :: Budget Control System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0BUBAS_CLUSTER81Cluster to store application logBudget Control System
2ERP EHP76.0BUBAS_MSG_AREA21Message AreaBudget Control System
3ERP EHP76.0FMBASIDX82Index table for budget structure and AVCBudget Control System
4ERP EHP76.0FMBASOBJNR132Object numbers for FM addressesBudget Control System
Public Sector Management :: Funds Management :: Budget Control System :: Availability Control
ProductVersionTableColumnsIndexesDescriptionModule
5ERP EHP76.0BUAVCACTGRP31Activity groups for availability controlAvailability Control
6ERP EHP76.0BUAVCACTGRPT51Activity Group Texts for Availability ControlAvailability Control
7ERP EHP76.0BUAVCEVENT71Event of availability controlAvailability Control
8ERP EHP76.0BUAVCEVENTT51Texts for Availability Control EventsAvailability Control
9ERP EHP76.0BUAVCKEDRENVT71Texts for Strategy (Derivation Tool Environment)Availability Control
10ERP EHP76.0BUAVCLDGR81Availability Control LedgerAvailability Control
11ERP EHP76.0BUAVCSRC51Data sources for availability ledgerAvailability Control
12ERP EHP76.0BUAVCSRCT41Data Source Texts for Availability Control LedgerAvailability Control
13ERP EHP76.0BUAVCTOLASS121Assignment of tolerance limits for availability controlAvailability Control
14ERP EHP76.0BUAVCTPRO51Tolerance profiles for availability controlAvailability Control
15ERP EHP76.0BUAVCTPROT51Tolerance Profile Texts for Availability ControlAvailability Control
16ERP EHP76.0FMAVCA444Actual line item tableAvailability Control
17ERP EHP76.0FMAVCACTCD41Activation of Change Documents for FMAVCT RecordsAvailability Control
18ERP EHP76.0FMAVCBUDFILTB71AVC filter settings for FM budget values: valid budget typesAvailability Control
19ERP EHP76.0FMAVCBUDFILTH91AVC filter settings for FM budget values: header entriesAvailability Control
20ERP EHP76.0FMAVCC72Object table 2Availability Control
21ERP EHP76.0FMAVCLDGRACT61Activation of availability ledger for Funds ManagementAvailability Control
22ERP EHP76.0FMAVCLDGRATT101Attributes of Availability Control Ledger (Funds Management)Availability Control
23ERP EHP76.0FMAVCLDGRGAT41Year-Independent Attributes of Control Ledger (FM)Availability Control
24ERP EHP76.0FMAVCNODUMP0111Calling Programs with do not cause AVC dump (note 1532323)Availability Control
25ERP EHP76.0FMAVCO152Object table 1Availability Control
26ERP EHP76.0FMAVCP994Plan line items tableAvailability Control
27ERP EHP76.0FMAVCT773AVC Summary Table (BCS)Availability Control
28ERP EHP76.0FMAVCUPDFILTH41AVC Filter Settings for FM Posting Data: Header EntriesAvailability Control
29ERP EHP76.0FMAVCUPDFILTV51AVC Filter Settings for Posting Data: Excluded Value TypesAvailability Control
30ERP EHP76.0FMAVC_RBE_FDE31AVC Filter Definition for RBEAvailability Control
31ERP EHP76.0FMAVC_RBE_FDET41Text Table for AVC Filter Definition for RBEAvailability Control
32ERP EHP76.0FMAVC_RBE_FSE31AVC Filter Settings for RBEAvailability Control
33ERP EHP76.0FMAVC_RBE_SET71AVC Ledger Settings for RBEAvailability Control
34ERP EHP76.0K9RKI4805000281Derivation rule:Derive act. group from value type onlyAvailability Control
35ERP EHP76.0K9RKI48050003101Derivation rule:Derivation using original CO transaction andAvailability Control
Public Sector Management :: Funds Management :: Budget Control System :: Budgeting
ProductVersionTableColumnsIndexesDescriptionModule
36ERP EHP76.0BTXCHKF0151Budge_text: File Name of Last Check OutBudgeting
37ERP EHP76.0BTXCHKO01101Budge_text: Check-Out Data for a Physical Information Obj.Budgeting
38ERP EHP76.0BTXCONT0171Budge_text: Table for Document Contents (Import/Export)Budgeting
39ERP EHP76.0BTXDOCL01181Budge_text: Instances of Logical Information ObjectsBudgeting
40ERP EHP76.0BTXDOCP01252Budge_text: Instances of Physical Information ObjectsBudgeting
41ERP EHP76.0BTXIDXST01122Budge_text: Status Table for Indexing DocumentsBudgeting
42ERP EHP76.0BTXLOIOT0151Budge_text: Descriptions of Logical Information ObjectsBudgeting
43ERP EHP76.0BTXLOPR0172Budge_text: Attribute Values of Logical Information ObjectsBudgeting
44ERP EHP76.0BTXLORE01113Budge_text: Outgoing Relations of Logical Information ObjectBudgeting
45ERP EHP76.0BTXLORI01113Budge_text: Incoming Relations of Logical Info ObjectsBudgeting
46ERP EHP76.0BTXPHF01101Budge_text: Files of Physical Information ObjectsBudgeting
47ERP EHP76.0BTXPHHR01123Budge_text: Outgoing Hyperlinks From Physical ObjectsBudgeting
48ERP EHP76.0BTXPHNM01123Budge_text: Use of Target Anchors in Physical ObjectsBudgeting
49ERP EHP76.0BTXPHPR0172Budge_text: Attributes of Physical Information ObjectsBudgeting
50ERP EHP76.0BTXPHRE01113Budge_text: Outgoing Relations of Physical Info ObjectsBudgeting
51ERP EHP76.0BTXPHRI01113Budge_text: Incoming Relations of Physical Info ObjectsBudgeting
52ERP EHP76.0BUBAS_MSG_AREA_T31Message Area TextsBudgeting
53ERP EHP76.0BUBUDCAT81List of budget category instancesBudgeting
54ERP EHP76.0BUBUDCATT31Texts for Budget CategoriesBudgeting
55ERP EHP76.0BUCC_LIB111Consistency Checks - LibraryBudgeting
56ERP EHP76.0BUCC_LIB_T61Library Texts for Consistency ChecksBudgeting
57ERP EHP76.0BUCC_RULE251Consistency Checks - RulesBudgeting
58ERP EHP76.0BUCC_RULE_MSG121Consistency Checks - Message of the ruleBudgeting
59ERP EHP76.0BUCC_RULE_OPD121Consistency Checks - OperandsBudgeting
60ERP EHP76.0BUCC_RULE_T71Rule Texts for Consistency ChecksBudgeting
61ERP EHP76.0BUFIELDS101Control allowed Field Names - Field Status ManagementBudgeting
62ERP EHP76.0BUKF_CAT31Key Figures - CategoryBudgeting
63ERP EHP76.0BUKF_CATDSRC41Key Figures - Category/Data source relationBudgeting
64ERP EHP76.0BUKF_CAT_T41Key Figures - Category TextsBudgeting
65ERP EHP76.0BUKF_DSRC61Key Figures - Data sourceBudgeting
66ERP EHP76.0BUKF_DSRC_FIELD71Key Figures - Data source fieldBudgeting
67ERP EHP76.0BUKF_DSRC_T41Key Figures - Texts for Data SourcesBudgeting
68ERP EHP76.0BUKF_FG31Key Figures - Field groupBudgeting
69ERP EHP76.0BUKF_FG_FIELD61Key Figures - Fields of field groupBudgeting
70ERP EHP76.0BUKF_FG_T51Key Figures - Texts for Field GroupsBudgeting
71ERP EHP76.0BUKF_FIELD_VALUE101Key Figures - Data source fields checks per categoryBudgeting
72ERP EHP76.0BUKF_KF101Key Figures - Key FigureBudgeting
73ERP EHP76.0BUKF_KFCAT41Key Figures - Key Figure/Category relationBudgeting
74ERP EHP76.0BUKF_KFDSRC51Key Figures - Key Figure Datasources relationBudgeting
75ERP EHP76.0BUKF_KF_T101Key Figures - Texts for Key FiguresBudgeting
76ERP EHP76.0BUKUTEXTCAT31Budget Text CategoriesBudgeting
77ERP EHP76.0BUKUTEXTCATT41Texts for Budget Text CategoriesBudgeting
78ERP EHP76.0BUKUTEXTTEMPL61Templates for Budget TextsBudgeting
79ERP EHP76.0BUKUTEXTTEMPLT61Texts for Budget Text TemplatesBudgeting
80ERP EHP76.0BUKUTXTTEMPLVAR81Variables for Budget Text TemplatesBudgeting
81ERP EHP76.0BUKUTXTTEMPLVART51Texts for Variables in Budget Text TemplatesBudgeting
82ERP EHP76.0BUPOSTFIELDS31Fields Which Can be Changed in Posted DocumentsBudgeting
83ERP EHP76.0BUPPSTFIELDS31Fields Which Can be Changed in Preposted DocumentsBudgeting
84ERP EHP76.0BUPROCESS31Internal budgeting processBudgeting
85ERP EHP76.0BUPROCESST31Texts of Internal Budgeting ProcessesBudgeting
86ERP EHP76.0BUPROCESS_UI21User Interface ProcessBudgeting
87ERP EHP76.0BUPROCESS_UIT31Texts for Budgeting Processes (User Interface - UI)Budgeting
88ERP EHP76.0BUPROCESS_UI_RD31Reduce Process UIBudgeting
89ERP EHP76.0BURBBLEDGERS41Ledgers for Revenue Increasing the BudgetBudgeting
90ERP EHP76.0BURBBLEDGERST31Ledger Text for Revenues Increasing the BudgetBudgeting
91ERP EHP76.0BURBCALCRULES121Calculation Formulas for Revenues Increasing the BudgetBudgeting
92ERP EHP76.0BURBCALCRULEST51Texts on Calculation Rules for Revenues Increasing the Bud.Budgeting
93ERP EHP76.0BUTECHORG61Table of original Transactions (Technical)Budgeting
94ERP EHP76.0BUTECHORGT41Texts for Original Applications (Budgeting)Budgeting
95ERP EHP76.0BUVALTPRO31Valid Combinations Between Process and Value TypeBudgeting
96ERP EHP76.0BUVALTYPE11List of budgeting value type instancesBudgeting
97ERP EHP76.0BUVALTYPET31Texts for Budgeting Value Type InstancesBudgeting
98ERP EHP76.0BUVORGA41Mapping rules for migration from FBS to BCS - Field VORGABudgeting
99ERP EHP76.0BUWRTTP51Mapping rules for migration from FBS to BCS - Field WRTTPBudgeting
100ERP EHP76.0FMACTIVPER41Activate Period Control BudgetingBudgeting
101ERP EHP76.0FMBCSA41Budget Control System activation settingsBudgeting
102ERP EHP76.0FMBCSA_USER61User specific Budget Control System activation settingsBudgeting
103ERP EHP76.0FMBDA474Actual line item tableBudgeting
104ERP EHP76.0FMBDC92Object table 2Budgeting
105ERP EHP76.0FMBDO142Object table 1 - Budget addressBudgeting
106ERP EHP76.0FMBDP955FM Budget change line items tableBudgeting
107ERP EHP76.0FMBDT793FM budget totals tableBudgeting
108ERP EHP76.0FMBH412Funds management budget header (entry documents)Budgeting
109ERP EHP76.0FMBL571Funds management budget document lines (entry documents)Budgeting
110ERP EHP76.0FMBSCDACT41Activation of Change Documents for Budget StructureBudgeting
111ERP EHP76.0FMBS_BO61Budget AddressesBudgeting
112ERP EHP76.0FMBS_BS101Budget structuresBudgeting
113ERP EHP76.0FMBS_BS_T51Texts for Budget StructuresBudgeting
114ERP EHP76.0FMBS_CONTROL61Budget structure settings on FM area and fiscal year levelBudgeting
115ERP EHP76.0FMBS_CONTROL_LDR61BS settings FM area, fisc. year and posting ledgerBudgeting
116ERP EHP76.0FMBS_HIE_ACT41Activation of Hierarchical Budget StructureBudgeting
117ERP EHP76.0FMBS_VERS_ASS61Budget Addresses settings on the version levelBudgeting
118ERP EHP76.0FMBTGDEF51Budget Group content definitionBudgeting
119ERP EHP76.0FMBTGROUP41Budget Type Group definitionBudgeting
120ERP EHP76.0FMBTGROUPT61Text for Budget Type GroupBudgeting
121ERP EHP76.0FMBUDCAT51Budget category activationBudgeting
122ERP EHP76.0FMBUDTXT191Budget texts registerBudgeting
123ERP EHP76.0FMBUDTXT_KEY201Budget Text Key CustomizingBudgeting
124ERP EHP76.0FMBUDTYPE51Budget type definitionBudgeting
125ERP EHP76.0FMBUDTYPET81Texts for Budget TypesBudgeting
126ERP EHP76.0FMBULEDGERS21Relation between posting and budgeting ledgersBudgeting
127ERP EHP76.0FMBUMANAGER71Management of budgeting enironment in FMBudgeting
128ERP EHP76.0FMBUSTATUS61Status and budget addresses settings on the version levelBudgeting
129ERP EHP76.0FMBWUD101User DocumentsBudgeting
130ERP EHP76.0FMBWUS351Budgeting Workbench User settingsBudgeting
131ERP EHP76.0FMCCFBDGT_CNTRL61Customizing settings: creation of budget during ccfBudgeting
132ERP EHP76.0FMCCFBDGT_CUST151Customizing settings: creation of budget during ccfBudgeting
133ERP EHP76.0FMCC_CUST_LIB71FM - Consistency checks - Assignment of librariesBudgeting
134ERP EHP76.0FMCEACT61Activation of Cover ElibilityBudgeting
135ERP EHP76.0FMCECDACT31Activation of Change Documents for Cover ElibilityBudgeting
136ERP EHP76.0FMCECGADDRS72Cover Groups: Assigned Budget AddressesBudgeting
137ERP EHP76.0FMCECVGRP191Cover GroupsBudgeting
138ERP EHP76.0FMCECVGRPT71Texts for Cover GroupsBudgeting
139ERP EHP76.0FMCONSUM_FTYPE61Consumable budget type for Fund TypeBudgeting
140ERP EHP76.0FMCONSUM_FUND61Consumable budget type for FundBudgeting
141ERP EHP76.0FMCUPRP21Field Profile for Preposted or Posted Budget DocumentsBudgeting
142ERP EHP76.0FMCUPRPCDACT31Activation of Change History for Preposted DocumentsBudgeting
143ERP EHP76.0FMCUPRPCOM41Assignment of Field Profiles for Preposted Budget DocumentsBudgeting
144ERP EHP76.0FMCUPRPT41Texts for Field Profiles for Provisionally Posted Bdgt DocsBudgeting
145ERP EHP76.0FMCYDOC111Links source and targets during the copy of documentsBudgeting
146ERP EHP76.0FMCY_COPI481For CO plan data transferBudgeting
147ERP EHP76.0FMDIMSTATE101Definition of state for account assignment elementBudgeting
148ERP EHP76.0FMDISTA61Distribution ActivationBudgeting
149ERP EHP76.0FMDISTC61Distribution ChecksBudgeting
150ERP EHP76.0FMDISTCK41Distribution ChecksBudgeting
151ERP EHP76.0FMEDDOCFORMS41Assignment of Forms for Entry documentBudgeting
152ERP EHP76.0FMEDDOCTYPEA41Assign process to document typeBudgeting
153ERP EHP76.0FMEDFORMS_WD61Assignment of Forms for Entry documentBudgeting
154ERP EHP76.0FMFSG21Field Status Group definitionBudgeting
155ERP EHP76.0FMFSGA41Assignment of Field Status GroupBudgeting
156ERP EHP76.0FMFSGT41Text for Field Status GroupBudgeting
157ERP EHP76.0FMFSS21Field Status String definitionBudgeting
158ERP EHP76.0FMFSSA41Assign Field Status StringBudgeting
159ERP EHP76.0FMFSSDEF71Edit Field Status StringBudgeting
160ERP EHP76.0FMFSST41Text for Field Status definitionBudgeting
161ERP EHP76.0FMFSV21Field Status Variant definitionBudgeting
162ERP EHP76.0FMFSVA31Assignment of Field Status VariantBudgeting
163ERP EHP76.0FMFSVT41Text for Field Status Variant definitionBudgeting
164ERP EHP76.0FMHBH281Funds management budget header (held documents)Budgeting
165ERP EHP76.0FMHBL571Funds management budget document lines (held documents)Budgeting
166ERP EHP76.0FMHIEHEADERS72Hierarchy Nodes: Constant Parts ("Headers")Budgeting
167ERP EHP76.0FMHIEIDS91Hierarchy IDsBudgeting
168ERP EHP76.0FMHIEIDST81Texts for Hierarchy IDsBudgeting
169ERP EHP76.0FMHIENODES123Hierarchy Nodes (Without Constant Part)Budgeting
170ERP EHP76.0FMHIESETTINGS251Settings for Budget HierarchiesBudgeting
171ERP EHP76.0FMHIE_CHGCHK_FLG121Activate Checks for Hierarchy ChangeBudgeting
172ERP EHP76.0FMKF_DSRC_EVAL31Key Figures - Evaluation class of data sourceBudgeting
173ERP EHP76.0FMKF_TERM171Key Figures - FM TermsBudgeting
174ERP EHP76.0FMKF_TERM_AVC141Key Figures - FM AVC TermBudgeting
175ERP EHP76.0FMKF_TERM_RB161Key Figures - FM TermsBudgeting
176ERP EHP76.0FMLA371Layout VariantBudgeting
177ERP EHP76.0FMLAT41Texts for Layout VariantsBudgeting
178ERP EHP76.0FMMAACT51Activation of Multi-annual BudgetingBudgeting
179ERP EHP76.0FMMACGPERC261Percentage per cover group (Multi-annual budgeting)Budgeting
180ERP EHP76.0FMMAPERC261Standard percentage set for multi-annual budgetingBudgeting
181ERP EHP76.0FMMIGDOC102Migrated DocumentsBudgeting
182ERP EHP76.0FMMIGOV71Overview of Migration StatusBudgeting
183ERP EHP76.0FMMIGPAR81Partially Migrated DocumentsBudgeting
184ERP EHP76.0FMOPENPER71Control Budgeting PeriodsBudgeting
185ERP EHP76.0FMOPENPER_FUND81Control Budgeting Periods per FundBudgeting
186ERP EHP76.0FMORGFAV121BCS : Organizer FavoritesBudgeting
187ERP EHP76.0FMPEPLAY91FMPEP - Layout Customizing Settings - Basic DataBudgeting
188ERP EHP76.0FMPEPLAY_COL161FMPEP: layout customizing settings for columnsBudgeting
189ERP EHP76.0FMPEPLAY_COL_T111FMPEP - Layout Customizing Settings - Columns (Text)Budgeting
190ERP EHP76.0FMPEPLAY_H91FMPEP - Layout Customizing Settings - HeaderBudgeting
191ERP EHP76.0FMPEPLAY_T41FMPEP - Layout Customizing Settings - Basic Data (Text)Budgeting
192ERP EHP76.0FMPEPLAY_TAB51FMPEP - Layout Customizing Settings - TabstripsBudgeting
193ERP EHP76.0FMPEPLAY_TAB_T51FMPEP - Layout Customizing Settings - Tabstrips (Text)Budgeting
194ERP EHP76.0FMPEP_FIELD_ATTR31FMPEP: system table for field attributes handlingBudgeting
195ERP EHP76.0FMPEP_VARIANTH321Session variants (header part) for transaction FMPEPBudgeting
196ERP EHP76.0FMPEP_VARIANTL701Session variants (line part) for transaction FMPEPBudgeting
197ERP EHP76.0FMPROFILE51Profile for BCS budgetingBudgeting
198ERP EHP76.0FMPRPDEF41Edit Field Profile for Preposted DocumentsBudgeting
199ERP EHP76.0FMPSTDEF41Edit Field Profile for Posted DocumentsBudgeting
200ERP EHP76.0FMPTCOMB61Allowed combinations (process / budget type)Budgeting
201ERP EHP76.0FMPTCOMBA81Allowed combinations (process / budget type) for statusBudgeting
202ERP EHP76.0FMPTCOMBAG81Allowed combinations process / budget type group for statusBudgeting
203ERP EHP76.0FMPTCOMBG51Allowed Combinations Process/Budget Type Using BT GroupsBudgeting
204ERP EHP76.0FMRBA434Actual line item tableBudgeting
205ERP EHP76.0FMRBACT41RIB Customizing SettingsBudgeting
206ERP EHP76.0FMRBACTCD31Activation of Change Documents for FMRBT RecordsBudgeting
207ERP EHP76.0FMRBBOBJECTS212Master Data For Revenue Increasing the Budget: RIB ObjectsBudgeting
208ERP EHP76.0FMRBBRECS111Master Data For RIB: Budget Receivers per RIB ObjectBudgeting
209ERP EHP76.0FMRBC62Object table 2Budgeting
210ERP EHP76.0FMRBCDACT31Activation of Change Documents for Cover ElibilityBudgeting
211ERP EHP76.0FMRBO152Object table 1Budgeting
212ERP EHP76.0FMRBP914Plan line items tableBudgeting
213ERP EHP76.0FMRBT763Summary tableBudgeting
214ERP EHP76.0FMRELSTATE51Definition of release scenarioBudgeting
215ERP EHP76.0FMREL_FTYPE51Consumable budget type for Fund TypeBudgeting
216ERP EHP76.0FMREL_FUND51Release settings for FundBudgeting
217ERP EHP76.0FMREV_STGRD_ACT41Activation of the Reversal Reason for Budget DocumentsBudgeting
218ERP EHP76.0FMREV_STGRD_DEF41Allowed Reversal Reasons for Budget DocumentsBudgeting
219ERP EHP76.0FMROLLUP_FTYPE121Preclosing Rollup: Transfer Rules for Fund TypeBudgeting
220ERP EHP76.0FMROLLUP_FUND121Preclosing Rollup: Transfer Rules for FundBudgeting
221ERP EHP76.0FMSTATDEF31Budgeting status definitionBudgeting
222ERP EHP76.0FMSTATDEFT61Texts for Budgeting StatusBudgeting