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

72 tablesERP 6.0 

Financial Services :: Loans Management :: Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TDDUNNLVL141Dunning Levels by Number of Overdue InstallmentsAccounting
2ERP EHP76.0TDDUNN_CORRESP51Fields for Correspondence, e.g. Action if UndeliverableAccounting
3ERP EHP76.0TDIOA_BAL_COND51Assignment Condition Type to Flow Type Grouping - IOA Calc.Accounting
4ERP EHP76.0TDIOA_BO41Interest on Arrears Active in BO Interest on Arrears Calc.Accounting
5ERP EHP76.0TDIOA_FT_BALANCE61Assignment of Flows to Flow Type Grouping - IOA CalculationAccounting
6ERP EHP76.0TDIOA_GSTEER71General Control Data for Interest on Arrears CalculationAccounting
7ERP EHP76.0TDIOA_NOPOSTCALC31Flow Types Without RecalculationAccounting
8ERP EHP76.0TDIOA_SCHEMET41Text Table for Profile Definition IOA CalculationAccounting
9ERP EHP76.0TDIOA_SCHEME_BAL61Assignment of Product Type to Profile and Flow Type GroupingAccounting
10ERP EHP76.0TDIOA_SCHEME_DEF81Profile Definition for Interest on Arrears CalculationAccounting
11ERP EHP76.0TDIOA_TEMPL181Template for Interest On Arrears CalculationAccounting
12ERP EHP76.0TDIOA_TEMPLTXT71Template Texts for Interest on Arrears CalculationAccounting
13ERP EHP76.0TDIOA_TRIV_AMT61Trivial Amount per Currency and Profile IOA CalculationAccounting
14ERP EHP76.0VDDUNN_DISP91Dunning run data per loan and dunning runAccounting
15ERP EHP76.0VDIOA_CALC_CF102Original Documents Without Model Account Int. on ArrearsAccounting
16ERP EHP76.0VDIOA_CALC_DET642Progress (Interest) of Model Account IOA CalculationAccounting
17ERP EHP76.0VDIOA_CALC_HEAD321Calculation Details for Interest on Arrears CalculationAccounting
Financial Services :: Loans Management :: Accounting :: ReceivablesPayment Management
ProductVersionTableColumnsIndexesDescriptionModule
18ERP EHP76.0TDHIERKRITPRIO61Incoming Payment: Order of Evaluation CriteriaReceivablesPayment Management
19ERP EHP76.0TDHIERKRITSORT71Incoming Payment: Assignment TableReceivablesPayment Management
20ERP EHP76.0TDHIERKRITT81Incoming Payments: Assignment Criteria TextsReceivablesPayment Management
21ERP EHP76.0TDHIERPLAN71Hierarchy PlanReceivablesPayment Management
22ERP EHP76.0TDHIERSET71Hierarchy SettingsReceivablesPayment Management
23ERP EHP76.0TDIMPLEMENTRULES71Processing Rules for Contracts with Stop CodesReceivablesPayment Management
24ERP EHP76.0TDIPDPLAN91Payment Plan HierarchyReceivablesPayment Management
25ERP EHP76.0TDIPDPLANT61Texts for Payment Plan HierarchyReceivablesPayment Management
26ERP EHP76.0TDIPDRULES21Customizing Table, Definition of Processing RulesReceivablesPayment Management
27ERP EHP76.0TDIPDRULEST41Text Table for Rule KeyReceivablesPayment Management
28ERP EHP76.0TDMAZNB81Customizing: Automatic Incoming Payment PostprocessingReceivablesPayment Management
29ERP EHP76.0TDNONDUEITEMS61"Billed but Not Due" ChargesReceivablesPayment Management
30ERP EHP76.0TDPAYMS61Assignment Dunning Level Payment Status Stop CodesReceivablesPayment Management
31ERP EHP76.0TDPLANNRSUSP51U.S. Incoming Payment: Reasons for Qualified OverpaymentsReceivablesPayment Management
32ERP EHP76.0TDPMTTYPE21Payment Cat.ReceivablesPayment Management
33ERP EHP76.0TDPMTTYPET41Payment Cat.DescriptionReceivablesPayment Management
34ERP EHP76.0TDPREPKRIT51Prepayment CriteriaReceivablesPayment Management
35ERP EHP76.0TDPREPKRITFT61Flow Type for Prepayment CriteriaReceivablesPayment Management
36ERP EHP76.0TDPREPKRITPRIO141Priority of Prepayment CriteriaReceivablesPayment Management
37ERP EHP76.0TDPREPKRITT71Texts for Prepayment CriteriaReceivablesPayment Management
38ERP EHP76.0TDPRODPLAN41Assignment of Product Type to IP Distribution PlanReceivablesPayment Management
39ERP EHP76.0TDPRODTYPHIERARC31Assignment of Product Category to Payment HierarchyReceivablesPayment Management
40ERP EHP76.0TDSPECPAYMENT71Assignment and Prioritizing of Flow Types to Payment Cat.ReceivablesPayment Management
41ERP EHP76.0TDSUSPREASON11System Table - Reasons for SuspenseReceivablesPayment Management
42ERP EHP76.0TDSUSPREASONT31Text Table for TDSUSPREASONReceivablesPayment Management
43ERP EHP76.0TZB2121Processing groupReceivablesPayment Management
44ERP EHP76.0TZB21T51Name of Clerk (Processing Group)ReceivablesPayment Management
45ERP EHP76.0TZB2221Processing TypeReceivablesPayment Management
46ERP EHP76.0TZB22T41Name of Processing TypeReceivablesPayment Management
47ERP EHP76.0TZB2362Assign clerkReceivablesPayment Management
48ERP EHP76.0TZB2421Flow Type GroupReceivablesPayment Management
49ERP EHP76.0TZB24T41Name of Flow Type GroupReceivablesPayment Management
50ERP EHP76.0TZB2531Assign Flow Type to Flow Type GroupReceivablesPayment Management
51ERP EHP76.0TZB2621Account groupReceivablesPayment Management
52ERP EHP76.0TZB26T41Name of Account GroupReceivablesPayment Management
53ERP EHP76.0TZB2741Assignment of G/L account to account groupReceivablesPayment Management
54ERP EHP76.0TZB2841Selection KeyReceivablesPayment Management
55ERP EHP76.0TZB28T41Name of Selection KeyReceivablesPayment Management
56ERP EHP76.0TZB2921Processing categoryReceivablesPayment Management
57ERP EHP76.0TZB29T31Name of Processing CategoryReceivablesPayment Management
58ERP EHP76.0TZB3021Processing KeyReceivablesPayment Management
59ERP EHP76.0TZB30T41Name of processing keyReceivablesPayment Management
60ERP EHP76.0TZB3141Assignment of Processing Categories to Processing KeyReceivablesPayment Management
61ERP EHP76.0TZB3261Name of User Function KeysReceivablesPayment Management
62ERP EHP76.0TZB3331Pmnt PP: Default Susp. Acct Cust. for Refund by Bank Transf.ReceivablesPayment Management
63ERP EHP76.0TZB3441Payment PP: Default Payment Meth. for Refund by Bank Transf.ReceivablesPayment Management
64ERP EHP76.0TZB4031Account Clearing: Excluded Flow TypesReceivablesPayment Management
65ERP EHP76.0TZB4171Account Clearing: Amount LimitsReceivablesPayment Management
66ERP EHP76.0TZB4271Account Clearing: Checks at Contract LevelReceivablesPayment Management
67ERP EHP76.0TZB4341Account Clearing: Checks at Customer Account LevelReceivablesPayment Management
68ERP EHP76.0TZB5031Internal Bank Numbers for Returned Direct Debit ChargesReceivablesPayment Management
69ERP EHP76.0VDAD_CONTROL121Table with Dates for Auto Debit RunReceivablesPayment Management
70ERP EHP76.0VDAD_HIST111Auto Debits, Historical DataReceivablesPayment Management
71ERP EHP76.0VDAD_RESULT221Result Table for Auto Debit CollectionReceivablesPayment Management
72ERP EHP76.0VDARL_RLS141Direct Debits Per ContractReceivablesPayment Management