	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

138 columns | ERP 6.0 | RATE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000149000	PSA for 0DPR_TASK_ATTR T90CLNT090 Task Attributes	17	RATE		nvarchar	15	0
2	/CCEE/SIFI_CMWS	Slovenia Cash Sales report - assign tax code to tax rate	3	RATE	Slovenia Cash Sales Report Tax Rates	nvarchar	1	0
3	/IBS/TRB_ECF_PCF	RBD ECF - Provision Cash Flow	7	RATE	RBD: Amount of Cash Flow Position (Installment)	decimal	23	2
4	/IBS/TRB_ECF_PUT	RBD ECF - Provision Utilization	7	RATE	RBD: Expected Utilization (Installment)	decimal	23	2
5	/IBS/TRB_ECF_VCF	RBD ECF - Value Adjustment - Cash Flow	7	RATE	RBD: Amount of Contractual Cash Flow Item	decimal	23	2
6	/IBS/TRB_ECH_PCF	RBD ECF - Provision History - Cash Flow	8	RATE	RBD: Amount of Cash Flow Position (Installment)	decimal	23	2
7	/IBS/TRB_ECH_PUT	RBD ECF - Provision History - Utilization	8	RATE	RBD: Expected Utilization (Installment)	decimal	23	2
8	/IBS/TRB_ECH_VCF	RBD ECF - Value Adjustment History - Cash Flow	8	RATE	RBD: Amount of Contractual Cash Flow Item	decimal	23	2
9	/SLOAP/BILLINFO	SLOAS Service Billing Information	6	RATE		nvarchar	3	0
10	/SLOAP/PRICING_1	Conditions (1-Dimensional Quantity Scale)	5	RATE	Rate (condition amount or percentage) where no scale exists	int	10	0
11	FIKZD_PROPTAX	Property tax Kazakstan	51	RATE	Property Tax Rate	decimal	8	5
12	GRFNREAPLAN	Audit Risk Rating - Audit Plan	5	RATE	Score	decimal	13	5
13	J_2G_FPA_BOX	Assigment of VAT Rates to E-File Fields	2	RATE	Rate (condition amount or percentage)	decimal	11	2
14	J_3RVATD_RUN	Stored VAT-return Runs: Main Section	15	RATE	VAT Rate	decimal	11	2
15	J_3RVATD_RUN_TA	Stored VAT-return Runs: Tax Agent Section	15	RATE	VAT Rate	decimal	11	2
16	T7BREFD_PYWTAM	Wage types that form employee remuneration	8	RATE	Payroll: Amount per unit	decimal	15	2
17	TIVXCESPTSURCHRG	Municipal Property Tax - Surcharges	3	RATE	Surcharge Rate	decimal	5	2
18	TIVXCESPTTAXRATE	Municipal Property Tax Rate	5	RATE	Property Tax Rate	decimal	5	2
19	VIYCCOST2MTC	Major Tenant deduction for lease in CAM recovery	7	RATE	Rate	decimal	15	2
20	VIYCMAJTENANT	Major Tenant Parameters	7	RATE	Rate	decimal	15	2
21	ZPPMC_DPR_COSTPL	Bewegungsdaten für die Sachkostenplanung in cProjects	15	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	0
22	ZPPMC_DPR_COSTRA	Customizing Kostenraten für cProjects Kostenplanung	2	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	0
23	ZPPMC_DPR_PLANLV	Customizing Planungsebene für cProjects Kostenplanung	8	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	0
24	ZSERV_DET_CUST	Service details submitted by the customer	13	RATE	Character field 13 digits	nvarchar	13	0
TOPAsset Accounting
25	IDPT_A031	Manual Entries for Form 32.1	11	RATE	Depreciation Rate	decimal	13	10
TOPAssetLiability Management
26	JBAPLANPARLZB	ALM Assignment of Planning Parameters to Planning Variant	13	RATE	Repayment Installment	decimal	10	7
27	JBASIMLZBSAVE	ALM: Maturity-Band-Dependent Parameters	12	RATE	Repayment Installment	decimal	10	7
TOPBack Office
28	TRFT_BUSTRANS	Treasury: TRF Business Transaction	9	RATE	Price of Unit- or Percentage-Quoted Security	decimal	15	6
TOPBSI
29	BTXBRAK	BSI: Tax Formula Bracket Data	7	RATE	BSI: Tax class rate	decimal	9	8
30	BTXOVER	BSI: Higher Level Tax Formula	15	RATE	BSI: Override rate	nvarchar	24	0
31	BTXOVER_O	BSI: Higher Level Tax Formula	14	RATE	BSI: Override rate	nvarchar	24	0
TOPChargeback
32	WCOCOH	Condition Contract: Header	31	RATE	Exchange Rate	decimal	9	5
TOPCollectionsDisbursements
33	VVKKIHIST	Deposit Acct Interest Calc: History (Detail)	12	RATE	Interest rate for int.calc.	decimal	10	7
34	VVKKIHISTIOB	Sec. Acct Int. Calc. Acc. to Ins. Obj.: History (Detail)	20	RATE	Interest rate for int.calc.	decimal	10	7
TOPCondition
35	BKK96	Account Balancing Detail Data	21	RATE	Percentage rate for condition items	decimal	10	7
TOPControlling
36	DPR_RATES_CALC	Customizing: Mapping of Cost/Revenue Rates for Roles	2	RATE	Cost/Revenue Rate for Project Roles and Business Partner(s)	nvarchar	15	0
37	DPR_RATES_CO	Customizing: Cost/Revenue Rates for Project Roles	2	RATE	Cost/Revenue Rate for Project Roles and Business Partner(s)	nvarchar	15	0
38	DPR_RATES_T_CO	Customizing: Cost/Revenue Rates for Project Roles	2	RATE	Cost/Revenue Rate for Project Roles and Business Partner(s)	nvarchar	15	0
TOPcProjects Accounting Integration
39	DPR_RATES	Customizing: Cost/Revenue Rates for Project Roles	2	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	0
40	DPR_RATES_MAP	Customizing: Validity/Details of Cost/Revenue Rates	2	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	0
41	DPR_RATES_T	Customizing: Cost/Revenue Rates for Project Roles	2	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	0
TOPDistributor-Reseller-Management
42	/SAPHT/DRMWLPRIC	DRM-Agreement negotiation prices info table.	4	RATE	DRM worklist agreement rate	decimal	11	2
TOPGeneral Ledger Accounting
43	FMPEB_RATE_DEF	Assign Input Tax Deduction Rates	6	RATE	Input Tax Deduction Rate	decimal	6	3
TOPGeneric Contract Accounts Receivable and Payable
44	DFSCIHISTIOB	Balance Int. Calculation at Contract Account Level: History	19	RATE	Interest rate for int.calc.	decimal	10	7
TOPIndia
45	T7INJ7	Define slab rates for loans	5	RATE	Interest rate	decimal	5	2
TOPJapan
46	T5JLG	Premium amount for employment insurance	9	RATE	Flag for premium rate usage	nvarchar	1	0
47	T7JPBP_CLFCTBL	Calc. Factor Parameter Value Table	8	RATE	Percentage Rate	decimal	7	4
48	T7JPCP_CBFCTBL	Reassessment Rate Factor Parameter Value Table	9	RATE	Percentage Rate	decimal	7	4
49	T7JPCP_CLFCTBL	Calculation Factor Parameter Value Table	10	RATE	Percentage Rate	decimal	7	4
50	T7JPCP_PRFCTBL	Premium Amount/Rate Parameters Value Table	11	RATE	Percentage Rate	decimal	7	4
TOPJoint Venture und Production Sharing Accounting
51	T8J8C	Stepped Rate Thresholds	6	RATE	Step Rate for Stepped Rate Overhead (JVA)	decimal	5	2
52	T8J8F	Drilling Statistical Ratio Assignment	5	RATE	Drilling Rate - CFR Drilling	decimal	13	2
53	T8J8I	Assigned Producing Statistical Ratio Thresholds	7	RATE	Rate per Producing Well (JVA)	decimal	13	2
54	T8JOH_PERCENT_F	Table of Percentage Formulas in Overhead Organizer	6	RATE	Rate Applied to the amount range in Overhead Formula	decimal	8	2
55	T8JOH_STEPRATE_F	Table of Step Rate Formulas in Overhead Organizer	6	RATE	Rate Applied to the amount range in Overhead Formula	decimal	8	2
TOPLocal Currency Changeover
56	EWUTIMETAB	Rate of COUNT(*)/total runtime for estimation	3	RATE	Rate between count(*) and program real run	decimal	6	2
TOPLocalization
57	J_1ACI_MSG_RATES	Assignment of output messages to Installment rate	3	RATE	Sequential Number of Installment to be Paid	nvarchar	2	0
58	J_1BNFEPARKTAX	Nota fiscal electronica: Invoice create failed	20	RATE	Tax Rate	decimal	6	2
59	J_1BNFSTX	Nota Fiscal tax per item	6	RATE	Tax Rate	decimal	6	2
60	J_1BNFTXCOND	Tax Condition Interface for Notas Fiscais	6	RATE	Tax Rate Condition (Nota Fiscal)	nvarchar	4	0
61	J_1BRATEBANK	Vendor Operation - rates per bank	7	RATE	Interest Rate	decimal	10	7
62	J_1BTXCOF	Tax Calculation: COFINS	9	RATE	Tax Rate	decimal	6	2
63	J_1BTXDEF	Tax calc.: Default rates	4	RATE	Tax Rate	decimal	6	2
64	J_1BTXIC1	Tax calc.: ICMS general rules	6	RATE	Tax Rate	decimal	6	2
65	J_1BTXIC2	Tax calc.: ICMS rules	8	RATE	Tax Rate	decimal	6	2
66	J_1BTXIC3	Grouped ICMS	11	RATE	Tax Rate	decimal	6	2
67	J_1BTXIP1	Tax calc.: IPI rules	4	RATE	Tax Rate	decimal	6	2
68	J_1BTXIP2	Tax calc.: IPI rules (material dependent)	4	RATE	Tax Rate	decimal	6	2
69	J_1BTXIP3	Grouped IPI	7	RATE	Tax Rate	decimal	6	2
70	J_1BTXIS1	Tax calc.: ISS rules for sales	4	RATE	Tax Rate	decimal	6	2
71	J_1BTXIS3	Grouped ISS	10	RATE	Tax Rate	decimal	6	2
72	J_1BTXISS	Tax Calculation: ISS	10	RATE	Tax Rate	decimal	6	2
73	J_1BTXPIS	Tax Calculation: PIS	9	RATE	Tax Rate	decimal	6	2
74	J_1BTXST1	Tax calc.: Sub.Trib. rules	10	RATE	Sub.Trib. surcharge percentage rate	decimal	6	2
75	J_1BTXST2	Tax calc.: Sub.Trib. rules (general)	9	RATE	Sub.Trib. surcharge percentage rate	decimal	6	2
76	J_1BTXST3	Dynamic Calculation of Substituição Tributária	13	RATE	Sub.Trib. surcharge percentage rate	decimal	6	2
77	J_1IEXCTAX	Tax calc. - Excise tax rates	6	RATE	Rate of Excise Duty	decimal	7	4
78	J_3RFPROPTAXR	Property tax rates	8	RATE	Property Tax Rate	decimal	8	5
79	J_3RFTTAXR	Transport tax rates	8	RATE	Transport Tax Rate	decimal	8	5
80	TIVXCPTPTTAXRATE	Municipal Property Tax Rate	5	RATE	Municipal Property Tax Rate	decimal	5	2
81	TIVXCPTTAXRATE	Municipal Property Tax Rate for Portugal (obsolete)	5	RATE	Municipal Property Tax Rate	decimal	5	2
TOPMaster Data
82	TDCLI_INSURANCE	Table of Credit Life Insurance Rates	4	RATE	Key for Rate at Insurance Company	nvarchar	10	0
83	TDCLI_INS_1	Table of Credit Life Insurance Rates	3	RATE	Key for Rate at Insurance Company	nvarchar	10	0
TOPMulti Currency Accounting
84	GLE_MCA_RV_HSTRY	FX Revaluation History	17	RATE	Market Data Exchange Rate	decimal	28	14
TOPNon Profit Organizations
85	T7UNCMT_EXCH	CMT Interface: Exchange Rate	6	RATE		decimal	13	0
TOPPersonnel Cost Planning and Simulation
86	HRP5010	Database Table for Infotype 5010	25	RATE	Amount per Unit	decimal	15	2
87	PA0666	HR Master Record Infotype 0666	31	RATE	Amount per Unit	decimal	15	2
88	T77HCP_VALU	Valuation of Non-Valuated Cost Items	9	RATE	Amount per Unit	decimal	15	2
TOPPersonnel Management
89	T7HRDE	Dependent types (Croatia)	5	RATE	Dependent rate	decimal	4	2
TOPPortfolio Management
90	/RPM/FIN_LAB_MAP	Labor cost mapping Financial and Capacity entities to a rate	5	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	0
91	RPM_RESOURCE_RTE	Project Resource Standard Rate	5	RATE	Project Resource Standard Rate	decimal	16	2
92	RPM_ROLE_RTE	Project Resource Standard Rate	5	RATE	Role Demand - Standard Rate	decimal	16	2
TOPPortugal
93	T5P1P	HR-PT: Table of tax rates	8	RATE	Tax rate	decimal	4	2
94	T5P1R	HR-PT: Tax rates table	8	RATE	Tax rate	decimal	4	2
TOPPublic Sector Contract Accounts Receivable and Payable
95	TFMCA_BRF280	BRF: Charge Rate for Calculating Charges and Interest	9	RATE	Charge Rate (%)	decimal	5	2
TOPResources
96	DPR_PART	Project Participants	18	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	0
97	DPR_PART_ROLE	Customizing: Roles	5	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	0
TOPRisk Analysis
98	JBRACCOUNT	RM BP Update Administration for Account Balances	5	RATE	Percentage Rate of Condition Item	decimal	10	7
99	JBRAMOUNT	RM: Account Balance Summarization in Base Portfolio	8	RATE	Percentage Rate of Condition Item	decimal	10	7
TOPService Station Retailing
100	OIRCCOMPD	SSR Pricing - Competitor price differences	8	RATE	Rate (condition amount or percentage) where no scale exists	decimal	11	2
101	OIRCCOMPDM	SSR Pricing - Competitor price differences/Material	9	RATE	Rate (condition amount or percentage) where no scale exists	decimal	11	2
102	OIRCLPCD	SSR Pricing - Location price cluster differences	8	RATE	Rate (condition amount or percentage) where no scale exists	decimal	11	2
103	OIRCLPCDM	SSR Pricing - Location price cluster differences/Material	9	RATE	Rate (condition amount or percentage) where no scale exists	decimal	11	2
104	OIRCMDPGR	SSR Pricing - Material differences rates	8	RATE	Rate (condition amount or percentage) where no scale exists	decimal	11	2
105	OIRCSDPGR	SSR Pricing - Service type differences rates	8	RATE	Rate (condition amount or percentage) where no scale exists	decimal	11	2
106	OIRC_PRLOG_DIF	SSR Pricing - Price update differences	7	RATE	Rate (condition amount or percentage) where no scale exists	decimal	11	2
107	OIRC_PRLOG_PRL	SSR Pricing - Old and new prices	6	RATE	Rate (condition amount or percentage) where no scale exists	decimal	11	2
TOPStructure
108	DPR_TASK	Tasks	29	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	0
109	DPR_TSK_TYPE	Task Type	3	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	0
TOPTariffs, Duties and Permits
110	OIH_J_1BTXIC2	Tax calc.: ICMS rules (exceptions)	9	RATE	Tax Rate	decimal	6	2
111	OIH_J_1BTXIS1	Tax calc.: ISS rules for sales exeptions	9	RATE	Tax Rate	decimal	6	2
112	OIH_J_1BTXIX1	Tax calc.: ISS rules for sales and purchasing exeptions	15	RATE	Tax Rate	decimal	6	2
113	OIH_J_1BTXST1	Tax calc.: Sub.Trib. rules	12	RATE	Sub.Trib. surcharge percentage rate	decimal	6	2
TOPTax Reporting
114	OIUX6_WY_CTAX_RT	Tax 2.0 - Wyoming Conservation Tax Rates	3	RATE	Value tax rate	decimal	7	6
115	OIUX6_WY_CTXRATE	Tax 2.0 - Wyoming Conservation Tax Rate	2	RATE	Value tax rate	decimal	7	6
116	OIUX6_WY_RATE_CD	Tax 2.0 - Wyoming Rate Codes	6	RATE	Value tax rate	decimal	7	6
117	OIUX6_WY_STAX_RT	Tax 2.0 - Wyoming Severance Rate Codes	7	RATE	Value tax rate	decimal	7	6
TOPTraders and Schedulers Workbench
118	OIJ_EL_LAYT_EV	Laytime start and end events	17	RATE	Rate for influencing event	decimal	3	2
119	OIJ_EL_LAYT_INF	Laytime terms	9	RATE	Planned load/discharge rate	decimal	13	3
120	TOIJ_EL_LAYT_INF	Default laytime terms for documents	5	RATE	Rate for influencing event	decimal	3	2
TOPTransaction Management
121	FTR_AVG_SCHEDULE	Schedule with Rates	8	RATE	Exchange Rate	decimal	13	9
122	VTB_FX_WEB_QUOTE	FX Quotes for Transfer as Transaction	10	RATE	Rate of Forex Transaction	decimal	13	9
123	VTB_WEB_QUOTES	FX Quotes Received	13	RATE	Rate of Forex Transaction	decimal	13	9
TOPTransaction Manager
124	TCORT_CODMD	Deal: Main Data	63	RATE	Rate of Forex Transaction	decimal	13	9
125	THMEXT_EXPOS_FX	E-HA: Exposure Created by Transactions	8	RATE	FX Rate for Exposure	decimal	13	9
126	THMEXT_EXPOS_IR	E-HA: Exposure Created by Transactions	8	RATE	FX Rate for Exposure	decimal	13	9
127	THMEXT_TRANS_FX	E-HA: Transactions	9	RATE	FX Rate for Transaction (E-HA)	decimal	13	9
TOPTravel Planning
128	FTPT_HOTEL	Travel Request Item - Hotel Service	38	RATE	Rate/Price Per Night	decimal	10	2
TOPUse AP-MD-BP Components
129	BUT000	BP: General data I	24	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	0
130	BUT000_TD	BP: General Data I, Shadow Table Time Dependency	25	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	0
131	BUT000_TDS	BP: General Data I, Shadow Table Time Dependency	26	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	0
TOPValue Adjustment
132	/IBS/TRB_SHEET	RBD IAS - Value Adjustment Cash Flow Positions	7	RATE	RBD: Amount of Cash Flow Position (Installment)	decimal	23	2
133	/IBS/TRB_SHEET_I	RBD IAS - Provision Utilization	6	RATE	RBD: Expected Utilization (Installment)	decimal	23	2
134	/IBS/TRB_SHEET_R	RBD IAS - Provision Cash Flow Positions	6	RATE	RBD: Amount of Cash Flow Position (Installment)	decimal	23	2
135	/IBS/TRB_SHIST	RBD IAS - History Value Adjustment Cash Flow Positions	8	RATE	RBD: Amount of Cash Flow Position (Installment)	decimal	23	2
136	/IBS/TRB_SHIST_I	RBD IAS - History Provision Utilization	7	RATE	RBD: Expected Utilization (Installment)	decimal	23	2
137	/IBS/TRB_SHIST_R	RBD IAS - History Provision Cash Flow Positions	7	RATE	RBD: Amount of Cash Flow Position (Installment)	decimal	23	2
TOPVenezuela
138	T7VETX	Taxable income	5	RATE	Rate Applied to Taxable Earnings	decimal	9	4

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

138 columns | ERP 6.0 | RATE