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

26 columns | Print definition?ERP 6.0  | ZFPER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_DUMMYDummy Table for External Deductions17ZFPERFirst payment periodnvarchar20
2/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)40ZFPERFirst payment periodnvarchar20
3P2RB_PENSPensioner's data (B)9ZFPERFirst payment periodnvarchar20
4P2RG_COURTTypes of Court Order (GB)32ZFPERFirst payment periodnvarchar20
5P2RH_HU_MEMBP21MB15ZFPERFirst payment periodnvarchar20
6P2RN_SRPayroll Results: Life-Course Savings Scheme38ZFPERFirst payment periodnvarchar20
7P2RR_RMPayroll Results: Table for Master data (SG)31ZFPERFirst payment periodnvarchar20
TOPBelgium
8PA0504Pensioner's Advantage B30ZFPERFirst payment periodnvarchar20
9PA0569HR Master Record: Infotype 056927ZFPERFirst payment periodnvarchar20
TOPCompany Pension Scheme Germany
10PA0202HR Master Record Infotype 0202 (Entitlements)82ZFPERFirst payment periodnvarchar20
11PA0263HR Master Record for Infotype 026326ZFPERFirst payment periodnvarchar20
12T5DVPDefinition of Identifiers for Default Values5ZFPERFirst payment periodnvarchar20
TOPGermany
13P01Y15PAISY: Management Table Subrecord Type 1517ZFPERFirst payment periodnvarchar20
14PA0010HR Master Record: Infotype 0010 (Capital Formation)30ZFPERFirst payment periodnvarchar20
15PA0026HR Master Record: Infotype 0026 (Company Insurance)27ZFPERFirst payment periodnvarchar20
16PA0699Personnel Master Record Infotype 069929ZFPERFirst payment periodnvarchar20
TOPGreat Britain
17PA0070HR Master Record: Infotype 0070 (Court Orders - GB)47ZFPERFirst payment periodnvarchar20
TOPNetherlands
18PA0854HR Master Record for Infotype 085454ZFPERFirst Savings Periodnvarchar20
TOPPayroll
19T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001134ZFPERPrvé výplatné obdobienvarchar20
TOPPayroll General Parts
20T506DConditions for Employee Loans8ZFPERFirst period in yearnvarchar20
TOPPersonnel Administration
21PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)31ZFPERFirst payment periodnvarchar20
22PA0014HR Master Record: Infotype 0014 (Recur. Payments/Deds.)32ZFPERFirst payment periodnvarchar20
23PA0057HR Master Record: Infotype 0057 (Membership Fees)32ZFPERFirst payment periodnvarchar20
TOPPublic Sector
24PA0756Public Sector Loan Infotype 0756 (Mexico)32ZFPERFirst payment periodnvarchar20
TOPRecruitment
25PB0014Applicant Master Record IT 0014 Recurring Pymnts/Deductions32ZFPERFirst payment periodnvarchar20
TOPSouth Africa
26PA0151HR Master Record Infotype 0151 (Ext.Insurance South Africa)32ZFPERFirst payment periodnvarchar20