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

194 tablesERP 6.0 

Industry Specific :: Bank Components :: Bank Customer Accounts :: Master Data
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0BCA_US_HLD2REL312Hold Records which have not been released - Dual ControlMaster Data
2ERP EHP76.0BCA_US_HOLD302Hold Amounts Which Affect Available BalanceMaster Data
3ERP EHP76.0BKK40333Current Account Master Data: GeneralMaster Data
4ERP EHP76.0BKK40_ENQ_HY31Dummy Block Table for Accounts for Hierarchy CreationMaster Data
5ERP EHP76.0BKK42465Current Account Master Data: Operative DataMaster Data
6ERP EHP76.0BKK42ENQ31Current Account: Block FieldsMaster Data
7ERP EHP76.0BKK42_CC182BCA Account Master Data: Currency ChangeoverMaster Data
8ERP EHP76.0BKK43343BCA: Reference AccountsMaster Data
9ERP EHP76.0BKK4441Current Account Master Data: BlocksMaster Data
10ERP EHP76.0BKK4592Relationship: Current Account - Business PartnerMaster Data
11ERP EHP76.0BKK45_HISTORY61History Table for Table BKK45Master Data
12ERP EHP76.0BKK4631Current Account Master Data: Customer AppendsMaster Data
13ERP EHP76.0BKK4781BCA: Direct Debit OrdersMaster Data
14ERP EHP76.0BKK4871Control Indicator for Account BalancingMaster Data
15ERP EHP76.0BKK5051Account balanceMaster Data
16ERP EHP76.0BKK5151Subj.Fin.Pay. BalanceMaster Data
17ERP EHP76.0BKK5471Account Balance of HierarchiesMaster Data
18ERP EHP76.0BKK5571Subject to Final Payment Balance of HierarchiesMaster Data
19ERP EHP76.0BKK5651Account ResubmissionMaster Data
20ERP EHP76.0BKK60072Account Hierarchy: Account RelationshipsMaster Data
21ERP EHP76.0BKK610243Account Hierarchy: Assignment of Root Account to Tree NumberMaster Data
22ERP EHP76.0BKK61581Data for External Root Accounts Cash ConcentrationMaster Data
23ERP EHP76.0BKK620111Account Hierarchy: Amount Definitions for Cash ConcentrationMaster Data
24ERP EHP76.0BKK621101Cash Concentration: Different Amount DefintionsMaster Data
25ERP EHP76.0BKK62271Cash Concentration: Balancing Date of Last ExecutionMaster Data
26ERP EHP76.0BKK62351Enhancement Fields for Cash Concentration / HierarchiesMaster Data
27ERP EHP76.0BKK62551Assign. of Int. No. to Ext. Root Acct. for Change DocumentMaster Data
28ERP EHP76.0BKK62_CC91Value Date Transaction Figures for Cash ConcentrationMaster Data
29ERP EHP76.0BKK63341Enhancement Fields for Cash Pooling / HierarchiesMaster Data
30ERP EHP76.0BKK64041Extension Fields for Comb. Flexible Balances/HierarchiesMaster Data
31ERP EHP76.0BKK9B_CC241Value Date Transaction Figures for Cash ConcentrationMaster Data
32ERP EHP76.0BKKE1132Current Account: LimitsMaster Data
33ERP EHP76.0BKKOVR_ACCNT172Item Table: Accounts with Tolerated OverdraftMaster Data
34ERP EHP76.0BKKOVR_HD61Header Table Administration Accts with Tolerated OverdraftMaster Data
35ERP EHP76.0BKK_4EYES_CLOS41Account Closure Principle of Dual ControlMaster Data
36ERP EHP76.0BKK_ACCL_DC_REAS21Account Closure: Rejection Reasons for ReleaseMaster Data
37ERP EHP76.0BKK_ACCL_DC_REAT41Account Closure: Texts on Rejection ReasonsMaster Data
38ERP EHP76.0BKK_MIN_DEP61Minimum Deposit for Each ProductMaster Data
39ERP EHP76.0TBCA_US_H_TYPE31Hold Types TableMaster Data
40ERP EHP76.0TBKK4311Reference Account CategoryMaster Data
41ERP EHP76.0TBKK43T31Texts for Reference Account CategoryMaster Data
42ERP EHP76.0TBKK4731Account Status EnhancementMaster Data
43ERP EHP76.0TBKK47T41Texts for Account Status EnhancementsMaster Data
44ERP EHP76.0TBKK5121Reasons for Account ResubmissionMaster Data
45ERP EHP76.0TBKK51T41Texts on Account Resubmission ReasonsMaster Data
46ERP EHP76.0TBKK6091Account Hierarchy: Hierarchy TypesMaster Data
47ERP EHP76.0TBKK60T51Account Hierarchy: Hierarchy Type TextsMaster Data
48ERP EHP76.0TBKK61161Business Transaction Events for Hierarchy MaintenanceMaster Data
49ERP EHP76.0TBKK6581Settings for Cash ConcentrationMaster Data
50ERP EHP76.0TBKKE111Limit CategoriesMaster Data
51ERP EHP76.0TBKKE1T31Texts for Limit CategoriesMaster Data
52ERP EHP76.0TBKKE271Reference LimitsMaster Data
53ERP EHP76.0TBKKE2T71Texts for Reference LimitsMaster Data
54ERP EHP76.0TBKKE_FOUR_EYES31Limits: Validity of Principle of Dual ControlMaster Data
55ERP EHP76.0TBKKHLDAUTH61Amount Authorization/Permanent HoldsMaster Data
56ERP EHP76.0TBKKHYCD11Possible View Types Change Documents Account HierarchiesMaster Data
57ERP EHP76.0TBKKHYCDA31Table with Clear Texts on Change ActionsMaster Data
58ERP EHP76.0TBKKHYCDT31Text Table for TBKKHYCD - No. of Change Docs HierarchiesMaster Data
59ERP EHP76.0TBKK_AKT21BDT Field Modification According to Account StatusMaster Data
60ERP EHP76.0TBKK_AKT191BDT Field Modification According to Accouunt Status Part 1Master Data
61ERP EHP76.0TBKK_AKT291BDT Field Modification According to Account Status Part 2Master Data
Industry Specific :: Bank Components :: Bank Customer Accounts :: Master Data :: Condition
ProductVersionTableColumnsIndexesDescriptionModule
62ERP EHP76.0BKK81401Bank ConditionCondition
63ERP EHP76.0BKK81T51Texts for Bank ConditonCondition
64ERP EHP76.0BKK82391Bank Condition ItemCondition
65ERP EHP76.0BKK83181Bank Condition DeterminationCondition
66ERP EHP76.0BKK84421Bank Account - Individual ConditionCondition
67ERP EHP76.0BKK84T61Texts for Bank Account Individual ConditionCondition
68ERP EHP76.0BKK85421Bank Account - Individual Condition PositionCondition
69ERP EHP76.0BKK8RK111Standard Conditions: Retroactive Condition ChangesCondition
70ERP EHP76.0BKK91701Value Date Transaction FiguresCondition
71ERP EHP76.0BKK92463Account Balancing (Interest and Charges)Condition
72ERP EHP76.0BKK9371Oldest Period for Return PostingCondition
73ERP EHP76.0BKK9481Number of ItemsCondition
74ERP EHP76.0BKK9591Account Specific Amount Limits for Graduated ConditionsCondition
75ERP EHP76.0BKK96301Account Balancing Detail DataCondition
76ERP EHP76.0BKK97251Acct Balancing: Posting Data (Temporary Data)(for Deletion)Condition
77ERP EHP76.0BKK9881Dispatch Expenses Number of ItemsCondition
78ERP EHP76.0BKK9961Date of Early Balancing and End Date of PeriodCondition
79ERP EHP76.0BKK9A91Posting and Value Date Balances Carried ForwardCondition
80ERP EHP76.0BKK9ACC62Interest Accrual/Deferral (Accounts With No Result)Condition
81ERP EHP76.0BKK9AI72Carryforward of Interest PenaltyCondition
82ERP EHP76.0BKK9B241Value Date Transaction FiguresCondition
83ERP EHP76.0BKK9C91Acct Balancing (Interest and Charges) Enhancement to BKK92Condition
84ERP EHP76.0BKK9IW41Variant Condition FixingsCondition
85ERP EHP76.0BKK9RK91Oldest Period for Retroactive Condition ChangesCondition
86ERP EHP76.0TBKK8021Condition AreaCondition
87ERP EHP76.0TBKK80A31Bank Area - Condition Area (old)Condition
88ERP EHP76.0TBKK80B31Account Type - Condition Area (old)Condition
89ERP EHP76.0TBKK80BAS91Basic Settings ConditionsCondition
90ERP EHP76.0TBKK80C21Basic Settings Condition Area (old)Condition
91ERP EHP76.0TBKK80T41Texts for Condition AreasCondition
92ERP EHP76.0TBKK8131Bank Condition CategoryCondition
93ERP EHP76.0TBKK81T31Texts for Bank Condition CategoryCondition
94ERP EHP76.0TBKK8241Bank Condition Type DifferentiationCondition
95ERP EHP76.0TBKK82T41Texts for Bank Condition Type DifferentiationCondition
96ERP EHP76.0TBKK8551Bank Condition GroupCondition
97ERP EHP76.0TBKK85T61Texts for Bank Condition GroupCondition
98ERP EHP76.0TBKK8611Bank Condition Group CategoryCondition
99ERP EHP76.0TBKK86T31Texts for Bank Condition Group CategoryCondition
100ERP EHP76.0TBKK8711Bank Condition ClassCondition
101ERP EHP76.0TBKK87T31Texts for Bank Condition ClassCondition
102ERP EHP76.0TBKK88101Field Control - ConditionsCondition
103ERP EHP76.0TBKK8971Internal Default for Field Control ConditionsCondition
104ERP EHP76.0TBKK8A41Bank Condition Category - Differentiation Type AssignmentCondition
105ERP EHP76.0TBKK8AI31Assignment of Transaction Type - Interest Penalty TA TypeCondition
106ERP EHP76.0TBKK8B41Categorization Transaction Types (Item Counter)Condition
107ERP EHP76.0TBKK8BO21BonusCondition
108ERP EHP76.0TBKK8BOT41Text Table BonusCondition
109ERP EHP76.0TBKK8C41Categorization Medium (Item Counter)Condition
110ERP EHP76.0TBKK8D31Item CounterCondition
111ERP EHP76.0TBKK8DS21Dynamic BalancesCondition
112ERP EHP76.0TBKK8DST41Text Tables Dynamic BalancesCondition
113ERP EHP76.0TBKK8DT51Text Table Item CounterCondition
114ERP EHP76.0TBKK8DURA51TermsCondition
115ERP EHP76.0TBKK8DURAT51Text Table for TermsCondition
116ERP EHP76.0TBKK8E51Item Counter DeterminationCondition
117ERP EHP76.0TBKK8F31Category Transaction Types (Item Counter)Condition
118ERP EHP76.0TBKK8FT51Texts for Category Transaction Types (Item Counter)Condition
119ERP EHP76.0TBKK8G31Category Medium (Item Counter)Condition
120ERP EHP76.0TBKK8GT51Texts for Category Medium (Item Counter)Condition
121ERP EHP76.0TBKK8H31Assignment Trans. Activity Type - Charge Transaction TypeCondition
122ERP EHP76.0TBKK8I31Assignment Trans. Activiy Type - Interest Transacation TypeCondition
123ERP EHP76.0TBKK8IW51Periods for Interest Guarantee for OffersCondition
124ERP EHP76.0TBKK8J31Dispatch Expense CounterCondition
125ERP EHP76.0TBKK8JT51Text Table for Dispatch Expense CounterCondition
126ERP EHP76.0TBKK8K31Transaction Type Category (Differentiation Type)Condition
127ERP EHP76.0TBKK8K231Transaction Type Category 2 (Diff. Type)Condition
128ERP EHP76.0TBKK8K2T51Texts for Transaction Type Category (Diff.Type)Condition
129ERP EHP76.0TBKK8KT51Texts for Transaction Type Category (Diff.Type)Condition
130ERP EHP76.0TBKK8L41Assignment Transaction Type Category (Diff.Type)Condition
131ERP EHP76.0TBKK8L241Assignment Transaction Type Category 2 (Diff. Type)Condition
132ERP EHP76.0TBKK8M51Trivial AmountsCondition
133ERP EHP76.0TBKK8N31Feature - Charge Transaction Type AssignmentCondition
134ERP EHP76.0TBKK92121Interest Compensation MethodCondition
135ERP EHP76.0TBKK92T51Pooling Method TextCondition
136ERP EHP76.0TBKK9321Object Category for Balancing (Balancing or Interest Comp.)Condition
137ERP EHP76.0TBKK93T41Texts for Object Category for BalancingCondition
Industry Specific :: Bank Components :: Bank Customer Accounts :: Master Data :: Product definition
ProductVersionTableColumnsIndexesDescriptionModule
138ERP EHP76.0FIPR_PARTPROD51Assignment Version Partial ProductProduct definition
139ERP EHP76.0FIPR_PRODUCT141Product, Master DataProduct definition
140ERP EHP76.0FIPR_PRODUCTT41Product DescriptionProduct definition
141ERP EHP76.0FIPR_PRODV171Version of a Prodcut, Master DataProduct definition
142ERP EHP76.0FIPR_VA61Version AttributeProduct definition
143ERP EHP76.0FIPR_VA_FLD81Version Attribute Category FieldProduct definition
144ERP EHP76.0FIPR_VA_FLDM71Version Attribute Category Field: Multiple Value FieldsProduct definition
145ERP EHP76.0FIPR_VA_FLDVAL81Version Attribute Category Field: Value RestrictionProduct definition
146ERP EHP76.0FIPR_VA_VALUE71Version Attribute Category ListProduct definition
147ERP EHP76.0FIPR_VA_VALUE281Version Attribute Category MatrixProduct definition
148ERP EHP76.0TBKK4831Old: Permitted Products per Bank AreaProduct definition
149ERP EHP76.0TBKKG161MediaProduct definition
150ERP EHP76.0TBKKG1T51Text Table for MediaProduct definition
151ERP EHP76.0TBKKG1_TCODE41Assignment Transaction to MediumProduct definition
152ERP EHP76.0TBKKG1_TCODEPM41Assignment Transaction to Payment MethodProduct definition
153ERP EHP76.0TBKKG221FeaturesProduct definition
154ERP EHP76.0TBKKG2T31Text Table for FeaturesProduct definition
155ERP EHP76.0TBKKG2_DATE41Settings for Date Calculation for Periodic FeatureProduct definition
156ERP EHP76.0TBKKG3341Transaction typesProduct definition
157ERP EHP76.0TBKKG31201Return Reason, Assigned Transaction TypesProduct definition
158ERP EHP76.0TBKKG31T51Return ReasonProduct definition
159ERP EHP76.0TBKKG3241Transaction Type Offsetting Posting Inter. Initiated PTProduct definition
160ERP EHP76.0TBKKG3381Transaction Types: Notification of ReturnsProduct definition
161ERP EHP76.0TBKKG3481Transaction Types: Payment Notes for ReturnsProduct definition
162ERP EHP76.0TBKKG34K61Transaction Types: Payment Notes for Returns W/o Sequ.No.Product definition
163ERP EHP76.0TBKKG34P61Payment Notes for Returns, Text Symbols for SAPscriptProduct definition
164ERP EHP76.0TBKKG34W31Display of Currency for ReturnsProduct definition
165ERP EHP76.0TBKKG3T51Text Table for Transaction TypesProduct definition
166ERP EHP76.0TBKKG3_TCODE41Assignment Activity to Transaction TypeProduct definition
167ERP EHP76.0TBKKG421Functionality GroupProduct definition
168ERP EHP76.0TBKKG4T41Texts for Functions GroupsProduct definition
169ERP EHP76.0TBKKG541Assignment Functions Group - Medium, Transaction TypeProduct definition
170ERP EHP76.0TBKKG5231Assignment Functions Group -> FunctionsProduct definition
171ERP EHP76.0TBKKG621Locking ReasonsProduct definition
172ERP EHP76.0TBKKG6T41Texts for Blocking ReasonsProduct definition
173ERP EHP76.0TBKKG741Assignment Blocking Reason - Medium, Transaction TypeProduct definition
174ERP EHP76.0TBKKG7231Assignment Blocking Reason -> FunctionsProduct definition
175ERP EHP76.0TBKKG831Old: Assignment Product -> Functionality GroupsProduct definition
176ERP EHP76.0TBKKG941Formats for Application of FundsProduct definition
177ERP EHP76.0TBKKG9T41Text Table Formats Payment NotesProduct definition
178ERP EHP76.0TBKKH131Permitted Products per Bank AreaProduct definition
179ERP EHP76.0TBKK_PAYNT_TYP31Table for Payment Notes CategoriesProduct definition
180ERP EHP76.0TBKK_PAYNT_TYP_T41Text Table for Payment Notes CategoriesProduct definition
181ERP EHP76.0TFIPR_ATTRFIELD81Attribute: FieldProduct definition
182ERP EHP76.0TFIPR_ATTRFUNCT41Attribute: FeatureProduct definition
183ERP EHP76.0TFIPR_ATTRIBUTE52AttributeProduct definition
184ERP EHP76.0TFIPR_ATTRIBUTET31Description AttributeProduct definition
185ERP EHP76.0TFIPR_ATTRTREE61Attribute HierarchyProduct definition
186ERP EHP76.0TFIPR_ATTRTYPE21Attribute CategoryProduct definition
187ERP EHP76.0TFIPR_ATTRTYPET31Description Attribute CategoryProduct definition
188ERP EHP76.0TFIPR_ATTRVALUE41Attribute: ListProduct definition
189ERP EHP76.0TFIPR_ATTRVALUE271Attribute: MatrixProduct definition
190ERP EHP76.0TFIPR_KEYPREFIX21Prefix for Attributes and ProductsProduct definition
191ERP EHP76.0TFIPR_PRODAREA31Product RangeProduct definition
192ERP EHP76.0TFIPR_PRODAREAT41Description Product RangeProduct definition
193ERP EHP76.0TFIPR_PRODTYPE11Product CategoryProduct definition
194ERP EHP76.0TFIPR_PRODTYPET31Description Product CategoryProduct definition