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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

32 columns | Print definition?ERP 6.0  | HSNMR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OTEI/OCR_TSTGStaging table for HDCC download data18HSNMRHouse Numbernvarchar100
2P2AR_ARDIMPTax deduction results17HSNMRHouse Numbernvarchar60
3P2AR_AROIMPOther employers9HSNMRHouse Numbernvarchar60
4P2RB_ADRAddress payroll Belgium9HSNMRHouse Numbernvarchar100
5P2RB_I0125Garnishment payroll Belgium39HSNMRHouse Numbernvarchar60
6P2RF_SARPayroll Results: Garnishment21HSNMRHouse Numbernvarchar60
7P2RN_NADRAddress Data12HSNMRHouse Numbernvarchar100
8T7RU9AAddresses of organizations12HSNMRHouse Numbernvarchar100
9T7RUPA0006PA0006 copy39HSNMRHouse Numbernvarchar100
TOPArgentina
10PA0390Income Tax: Deductions35HSNMRHouse Numbernvarchar100
11PA0391Income Tax: Information on other employers28HSNMRHouse Numbernvarchar100
12PA0392Social Security: General data43HSNMRHouse Numbernvarchar100
TOPBelgium
13PA0125HR Master Record: Infotype 0125 (Garnishment B)46HSNMRHouse Numbernvarchar60
14T5B9AInstitutions (B)18HSNMRHouse Numbernvarchar60
15T5BS3Employee information except reductions ( level 3 )20HSNMRHouse Numbernvarchar100
TOPBrazil
16PA0736Alimony order for Brazil36HSNMRHouse Numbernvarchar100
TOPCompany Pension Scheme Germany
17PA0746HR Master Record for Infotype 074635HSNMRHouse Numbernvarchar90
TOPCross-Application Objects in HR
18HRP5583DB Table for Infotype 558330HSNMRHouse Numbernvarchar60
TOPFrance
19PA0272Infotype 0272 (Garnishment)40HSNMRHouse Numbernvarchar100
TOPMexico
20T7MX01Additional Company Informaton7HSNMRHouse Numbernvarchar60
21T7MX24IMSS Employer Regis. nos.6HSNMRHouse Numbernvarchar60
TOPNetherlands
22T5N1CHealth Insurance Companies (NL)10HSNMRHouse Numbernvarchar60
23T5N9AAuthority Addresses (NL)10HSNMRHouse Numbernvarchar60
TOPPayroll
24T5T1XLast foreign Health insurance - name9HSNMRHouse Numbernvarchar100
25T5TELDP2004TRANSRecords ELDP for transfer from external system to SAP28HSNMRHouse Numbernvarchar100
26T5TREGTRANSHRCZ - table for transfer items of Insured Register to SAP31HSNMRHouse Numbernvarchar100
TOPPersonnel Administration
27PA0006HR Master Record: Infotype 0006 (Addresses)39HSNMRHouse Numbernvarchar100
28PA0517HR Master Record: Infotype 051725HSNMRHouse Numbernvarchar100
29T7PL01Tax offices7HSNMRHouse Numbernvarchar60
TOPRecruitment
30PB0006HR Master Record: Infotype 0006 (Addresses)39HSNMRHouse Numbernvarchar100
TOPReporting
31P05TPRNL_EE_PDPension Return: Personal Data - Pers Level27HSNMRHouse Numbernvarchar100
TOPSpain
32T5EDHLocal tax offices/authorities8HSNMRHouse Numbernvarchar60