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

35 columns | Print definition?ERP 6.0  | BKPLZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)46BKPLZPostal Codenvarchar100
2P2RB_I0125Garnishment payroll Belgium24BKPLZPostal Codenvarchar100
3P2RX_BTPayroll Results: Bank Transfers10BKPLZPostal Codenvarchar100
4P2RX_BT_PERSONPayment-Related Information (Person)12BKPLZPostal Codenvarchar100
5P2VE_SENHRMS-VE: Information on Length of Service13BKPLZPostal Codenvarchar100
6T77PAYKZBTBank Transfer Table Image (BTKZ)27BKPLZPostal Codenvarchar100
TOPAustria
7PA0136HR Master Record: Infotype 0136 (Garn. Transfer A)42BKPLZPostal codenvarchar100
TOPBelgium
8PA0125HR Master Record: Infotype 0125 (Garnishment B)30BKPLZPostal Codenvarchar100
TOPChile
9PA3235HR Master Record: Infotype 323531BKPLZPostal Codenvarchar100
TOPCompany Pension Scheme Germany
10P01CBTTransfer Records for Reimbursement of Contributions CPS18BKPLZPostal Codenvarchar100
TOPDenmark
11PA0073HR Master Record: Infotype 0073 (Private Pensions - DK)67BKPLZPostal code (layout: PLSTLZ/ORT)nvarchar100
12PA0200HR Master Record, Infotype 0200 (Garnishments DK)46BKPLZPostal code (layout: PLSTLZ/ORT)nvarchar100
TOPGermany
13PA0010HR Master Record: Infotype 0010 (Capital Formation)36BKPLZPostal Codenvarchar100
14PA0026HR Master Record: Infotype 0026 (Company Insurance)49BKPLZPostal Codenvarchar100
15PA0116HR Master Record: Infotype 0116 (Garn. Transfer D)41BKPLZPostal codenvarchar100
16PA0699Personnel Master Record Infotype 069936BKPLZPostal Codenvarchar100
TOPPayroll
17T5TA1External transfers33BKPLZPostal Codenvarchar100
18T7ROA1Bank transfer - interface table27BKPLZPostal Codenvarchar100
19T7SIA6Bank transfer - interface table30BKPLZPostal Codenvarchar100
20T7SIBTVirman configuration (WT->Accounts)24BKPLZPostal Codenvarchar100
21T7SKA1External transfers33BKPLZPostal Codenvarchar100
22T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000935BKPLZPoštové smerovacie císlonvarchar100
23T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001140BKPLZPSCnvarchar100
TOPPersonnel Administration
24PA0009HR Master Record: Infotype 0009 (Bank Details)32BKPLZPostal Codenvarchar100
25PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)37BKPLZPostal Codenvarchar100
26PA0226Személyzeti törzsrekord 0164 infotípus tábla (TB - Magyaro.)38BKPLZPostleitzahlnvarchar100
TOPPersonnel Management
27T7HRA1Bank transfer - interface table23BKPLZPostal Codenvarchar100
28T7HRDOStatutory deductions Croatia11BKPLZPostal Codenvarchar100
29T7HRDSControl codes for stat. deductions and company codes Croatia8BKPLZPostal Codenvarchar100
30T7HRMUMunicipality codes (Croatia)9BKPLZPostal Codenvarchar100
31T7HRMWControl numbers - municipalities and company codes (Croatia)7BKPLZPostal Codenvarchar100
32T7HRPGControl codes for payees Croatia8BKPLZPostal Codenvarchar100
TOPRecruitment
33PB0009HR Master Record: Infotype 0009 (Bank Details)32BKPLZPostal Codenvarchar100
TOPSpain
34PA0887HR master record, infotype 088739BKPLZPostal Codenvarchar100
TOPVenezuela
35PA0401HRMS-VE: Table for Benefits Infotype (IT401)29BKPLZPostal Codenvarchar100