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

101 columns | Print definition?ERP 6.0  | EMFSL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)44EMFSLPayee key for bank transfersnvarchar80
2P2FI_CSISocial ins & result structure for Finland11EMFSLPension insurance contract numbernvarchar110
3P2FI_SISocial ins & result structure for Finland11EMFSLPayee key for bank transfersnvarchar80
4P2RB_I0125Garnishment payroll Belgium22EMFSLPayee key for bank transfersnvarchar80
5P2RG_COURTTypes of Court Order (GB)22EMFSLPayee key for bank transfersnvarchar80
6P2RH_HU_MEMBP21MB7EMFSLPayee key for bank transfersnvarchar80
7P2RL_EPFPayroll result: EPF (Malaysia)22EMFSLPayee key for bank transfersnvarchar80
8P2RL_SOCSOPayroll result: SOCSO ( Malysian Social Insurance )10EMFSLPayee key for bank transfersnvarchar80
9P2RL_TAXPayroll result: Tax (Malaysia)19EMFSLPayee key for bank transfersnvarchar80
10P2RM_MGARGarnishments DK15EMFSLPayee key for bank transfersnvarchar80
11P2RP_MFHR-PT: Payroll Results: Membership fees9EMFSLPayee key for bank transfersnvarchar80
12P2RX_BTPayroll Results: Bank Transfers15EMFSLPayee key for bank transfersnvarchar80
13P2RX_BT_PERSONPayment-Related Information (Person)17EMFSLPayee key for bank transfersnvarchar80
14P2VE_SENHRMS-VE: Information on Length of Service11EMFSLPayee key for bank transfersnvarchar80
15T521CCheck Table for Payees5EMFSLPayee key for bank transfersnvarchar80
16T77PAYKZBTBank Transfer Table Image (BTKZ)32EMFSLPayee key for bank transfersnvarchar80
17T7RU_521BPayee Keys (Russia extension for T521B)2EMFSLPayee key for bank transfersnvarchar80
TOPAustria
18PA0136HR Master Record: Infotype 0136 (Garn. Transfer A)39EMFSLPayee key for bank transfersnvarchar80
19PA0751HR Master Record: Infotype 0751 (Company Pension Plan AT)28EMFSLPayee key for bank transfersnvarchar80
20T5A1UCompany Employee Pension Fund2EMFSLPayee key for bank transfersnvarchar80
21T5A9GCompany Number of Union3EMFSLPayee key for bank transfersnvarchar80
TOPBelgium
22PA0125HR Master Record: Infotype 0125 (Garnishment B)28EMFSLPayee key for bank transfersnvarchar80
TOPBrazil
23T7BR1BUnion2EMFSLPayee key for bank transfersnvarchar80
24T7BRB1Branch - general information10EMFSLPayee key for bank transfersnvarchar80
25T7BRTAUnion dues2EMFSLPayee key for bank transfersnvarchar80
TOPChile
26PA3235HR Master Record: Infotype 323527EMFSLPayee key for bank transfersnvarchar80
27T7CL28Company - Receptor6EMFSLPayee key for bank transfersnvarchar80
28T7CL29Code for each Institution3EMFSLPayee key for bank transfersnvarchar80
29T7CL36Pension plan beneficiary information2EMFSLPayee key for bank transfersnvarchar80
TOPCompany Pension Scheme Germany
30P01CBTTransfer Records for Reimbursement of Contributions CPS24EMFSLPayee key for bank transfersnvarchar80
TOPDenmark
31PA0200HR Master Record, Infotype 0200 (Garnishments DK)41EMFSLPayee key for bank transfersnvarchar80
32T5M7PGarnishment Types in Danish Payroll (IT 200)8EMFSLPayee key for bank transfersnvarchar80
TOPFinland
33T7FI02Pension insurance table (Finland)5EMFSLPayee key for bank transfersnvarchar80
34T7FI07Accident insurance table (Finland)5EMFSLPayee key for bank transfersnvarchar80
35T7FITELMETEL messages7EMFSLPayee key for bank transfersnvarchar80
36T7FITUPAssignment of Payee to Trade Union / Local Finland2EMFSLPayee key for bank transfersnvarchar80
TOPGermany
37P01Y15PAISY: Management Table Subrecord Type 1531EMFSLPayee key for bank transfersnvarchar80
38PA0010HR Master Record: Infotype 0010 (Capital Formation)34EMFSLPayee key for bank transfersnvarchar80
39PA0026HR Master Record: Infotype 0026 (Company Insurance)47EMFSLPayee key for bank transfersnvarchar80
40PA0116HR Master Record: Infotype 0116 (Garn. Transfer D)38EMFSLPayee key for bank transfersnvarchar80
41T5DRBAVmG: Investment Institute7EMFSLPayee key for bank transfersnvarchar80
TOPGreat Britain
42PA0070HR Master Record: Infotype 0070 (Court Orders - GB)37EMFSLPayee key for bank transfersnvarchar80
43T5G80HR-GB: Payee Keys2EMFSLPayee key for bank transfersnvarchar80
TOPIndia
44T7INT5Personnel subarea grouping for Tax6EMFSLPayee key for bank transfersnvarchar80
45T7INU3Slab codes for states12EMFSLPayee key for bank transfersnvarchar80
TOPMalaysia
46T5LEPEmployee Provident fund for Malaysia7EMFSLPayee key for bank transfersnvarchar80
47T5LSPEmployer reference for SOCSO (Malaysia)7EMFSLPayee key for bank transfersnvarchar80
48T5LTPEmployer reference for tax8EMFSLPayee key for bank transfersnvarchar80
TOPNorway
49T5V2BUnion table2EMFSLPayee key for bank transfersnvarchar80
50T5V4CAssignment of KID number to Payee Key3EMFSLPayee key for bank transfersnvarchar80
TOPPayroll
51T5H8MMNYP-kódok megfeleltetései2EMFSLÁtutalás fogadókulcsanvarchar80
52T5HVMMagánnyugdíjpénztár adónem kódok2EMFSLÁtutalás fogadókulcsanvarchar80
53T5TA1External transfers26EMFSLPayee key for bank transfersnvarchar80
54T5TPFConfiguration table for medium of pension funds2EMFSLPayee key for bank transfersnvarchar80
55T5TZPKonfiguracní tabulka pro médium zivotního pojistení3EMFSLKlíc príjemce pro financní prevodynvarchar80
56T7BG10Insurance Bank transfer6EMFSLPayee key for bank transfersnvarchar80
57T7BG20Tax Bank transfer8EMFSLPayee key for bank transfersnvarchar80
58T7BGA1Bank transfer - interface table22EMFSLPayee key for bank transfersnvarchar80
59T7BGE3Base for required amount3EMFSLPayee key for bank transfersnvarchar80
60T7RO10Insurance institutions7EMFSLPayee key for bank transfersnvarchar80
61T7RO20Tax institutions8EMFSLPayee key for bank transfersnvarchar80
62T7ROA1Bank transfer - interface table10EMFSLPayee key for bank transfersnvarchar80
63T7ROE3Base for required amount3EMFSLPayee key for bank transfersnvarchar80
64T7SIA6Bank transfer - interface table10EMFSLPayee key for bank transfersnvarchar80
65T7SIBUBank Units Slovenia14EMFSLKljuc prejemnika za nakazilanvarchar80
66T7SIV1Voluntary healt insurance contributions2EMFSLPayee key for bank transfersnvarchar80
67T7SIV2Voluntary healt insurance contributions2EMFSLPayee key for bank transfersnvarchar80
68T7SKA1External transfers26EMFSLPayee key for bank transfersnvarchar80
69T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000951EMFSLKlúc príjemcu pre financné prevodynvarchar80
70T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001138EMFSLKlúc príjemcu pre financné prevodynvarchar80
71T7UATARTax Administration Properties6EMFSLPayee key for bank transfersnvarchar80
72T7UA_521BPayee Keys (Ukranian extension for table T521B)2EMFSLPayee key for bank transfersnvarchar80
TOPPension fund Netherlands
73PA0665Personal-Stammsatz Infotyp 066528EMFSLOntvangercode voor overschrijvingennvarchar80
74T521B_PFOntvangercodes (extensie bij T521B voor PF)2EMFSLOntvangercode voor overschrijvingennvarchar80
TOPPension Fund Switzerland
75PA3230Personnel Master Record for Infotype 323035EMFSLPayee key for bank transfersnvarchar80
76T5CD3House Bank Pension Fund for Non-Recurring Payments6EMFSLPayee key for bank transfersnvarchar80
TOPPersonnel Administration
77PA0009HR Master Record: Infotype 0009 (Bank Details)48EMFSLPayee key for bank transfersnvarchar80
78PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)35EMFSLPayee key for bank transfersnvarchar80
79PA0057HR Master Record: Infotype 0057 (Membership Fees)24EMFSLPayee key for bank transfersnvarchar80
80PA0226Személyzeti törzsrekord 0164 infotípus tábla (TB - Magyaro.)36EMFSLEmpfängerschlüssel für Überweisungennvarchar80
81T521BPayee Keys2EMFSLPayee key for bank transfersnvarchar80
TOPPersonnel Management
82T7HR10Insurance institutions8EMFSLPayee key for bank transfersnvarchar80
83T7HR20Tax Institution7EMFSLPayee key for bank transfersnvarchar80
84T7HR21CCheck Table Company code x Payees4EMFSLPayee key for bank transfersnvarchar80
85T7HRA1Bank transfer - interface table10EMFSLPayee key for bank transfersnvarchar80
86T7HRBPXConversion IT 9 to T521B proposal8EMFSLPayee key for bank transfersnvarchar80
87T7HRDOStatutory deductions Croatia9EMFSLPayee key for bank transfersnvarchar80
88T7HRDSControl codes for stat. deductions and company codes Croatia6EMFSLPayee key for bank transfersnvarchar80
89T7HRKPControl codes for payees Croatia2EMFSLPayee key for bank transfersnvarchar80
90T7HRMUMunicipality codes (Croatia)7EMFSLPayee key for bank transfersnvarchar80
91T7HRMWControl numbers - municipalities and company codes (Croatia)5EMFSLPayee key for bank transfersnvarchar80
92T7HRPGControl codes for payees Croatia6EMFSLPayee key for bank transfersnvarchar80
TOPProcess Controls -Automated Controls
93GRPCRTA_HRDA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)28EMFSLPayee key for bank transfersnvarchar80
TOPRecruitment
94PB0009HR Master Record: Infotype 0009 (Bank Details)48EMFSLPayee key for bank transfersnvarchar80
TOPReuse Services for Country Development
95T799BPP05Connection Between Contribution and Receiver8EMFSLPayee key for bank transfersnvarchar80
TOPRussia
96T7RU1BPayee Keys of receiving orders (Russia standard)2EMFSLPayee key for bank transfersnvarchar80
TOPSouth Africa
97PA0151HR Master Record Infotype 0151 (Ext.Insurance South Africa)24EMFSLPayee key for bank transfersnvarchar80
TOPSpain
98PA0887HR master record, infotype 088735EMFSLPayee key for bank transfersnvarchar80
99T5E21Pension developer2EMFSLPayee key for bank transfersnvarchar80
TOPSwitzerland
100PA0980HR Master Record Infotype 098051EMFSLPayee key for bank transfersnvarchar80
TOPVenezuela
101PA0401HRMS-VE: Table for Benefits Infotype (IT401)27EMFSLPayee key for bank transfersnvarchar80