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

45 columns | Print definition?ERP 6.0  | PAY_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/TEMDTable for EMD Payment9PAY_DATEPayment Datenvarchar80
2PA9220HR Master Record: Infotype 922031PAY_DATEPay date for payroll resultnvarchar80
3PA9390Personal-Stammsatz Infotyp 939031PAY_DATEDatum der Auszahlung eines Abrechnungsergebnissesnvarchar80
4PA9429Registro maestro de personal Infotipo 942931PAY_DATEFecha de pago de un resultado de nóminanvarchar80
5PA9640Personal-Stammsatz Infotyp 964031PAY_DATEDatum der Auszahlung eines Abrechnungsergebnissesnvarchar80
6PA9701Personal-Stammsatz Infotyp 970131PAY_DATEDatum der Auszahlung eines Abrechnungsergebnissesnvarchar80
7PA9725HR Master Record: Infotype 972531PAY_DATEPay date for payroll resultnvarchar80
8PA9741HR Master Record: Infotype 974131PAY_DATEPay date for payroll resultnvarchar80
9PA9742HR Master Record: Infotype 974231PAY_DATEPay date for payroll resultnvarchar80
10PA9825HR Master Record: Infotype 982531PAY_DATEPay date for payroll resultnvarchar80
11PA9990HR Master Record: Infotype 999031PAY_DATEPay date for payroll resultnvarchar80
12PA9991HR Master Record: Infotype 999131PAY_DATEPay date for payroll resultnvarchar80
13PA9992HR Master Record: Infotype 999231PAY_DATEPay date for payroll resultnvarchar80
14PA9993HR Master Record: Infotype 999331PAY_DATEPay date for payroll resultnvarchar80
15PA9995HR Master Record: Infotype 999531PAY_DATEPay date for payroll resultnvarchar80
16PA9996HR Master Record: Infotype 999631PAY_DATEPay date for payroll resultnvarchar80
17PA9997HR Master Record: Infotype 999731PAY_DATEPay date for payroll resultnvarchar80
18PA9998HR Master Record: Infotype 999831PAY_DATEPay date for payroll resultnvarchar80
TOPBenefit Integration
19PA0496Payroll Infotype: US Benefits Data - Per Pay Period31PAY_DATEPay date for payroll resultnvarchar80
20PA0497Payroll Infotype: US Benefits Data - MTD31PAY_DATEPay date for payroll resultnvarchar80
21PA0498Payroll Infotype: US Benefits Data - QTD31PAY_DATEPay date for payroll resultnvarchar80
22PA0499Payroll Infotype: US Benefits Data - YTD31PAY_DATEPay date for payroll resultnvarchar80
23PA0500Payroll Infotype: US Benefits Data in Arrears (ARRRS)31PAY_DATEPay date for payroll resultnvarchar80
24PA0501Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK)31PAY_DATEPay date for payroll resultnvarchar80
TOPJapan
25PA3239HR Master Record: Infotype 323931PAY_DATEPay date for payroll resultnvarchar80
TOPPension fund Netherlands
26PA0646HR Master Record: Infotype 0022 (Education)43PAY_DATEnvarchar80
TOPPersonnel Administration
27PA0402HR Master Data Infotype 040231PAY_DATEPay date for payroll resultnvarchar80
28PA0403HR Master Record for Infotype 040331PAY_DATEPay date for payroll resultnvarchar80
TOPPosition Management
29BKKA1Position Manangement: General Data23PAY_DATECashing Date of Checknvarchar80
TOPStakeholder Relationship Management
30USS_SHARE_DIVIDDividends per Security3PAY_DATEDividend Payment Datenvarchar80
TOPUSA
31PA044631PAY_DATEnvarchar80
32PA0447US Federal Tax MTD31PAY_DATEPay date for payroll resultnvarchar80
33PA0448US Federal Tax QTD31PAY_DATEPay date for payroll resultnvarchar80
34PA0449HR Master Record: Infotype 044931PAY_DATEPay date for payroll resultnvarchar80
35PA0450HR Master Record: Infotype 045031PAY_DATEPay date for payroll resultnvarchar80
36PA0451HR Master Record: Infotype 045131PAY_DATEPay date for payroll resultnvarchar80
37PA0452HR Master Record: Infotype 045231PAY_DATEPay date for payroll resultnvarchar80
38PA0453HR Master Record: Infotype 045331PAY_DATEPay date for payroll resultnvarchar80
39PA0454HR Master Record: Infotype 045431PAY_DATEPay date for payroll resultnvarchar80
40PA0455HR Master Record: Infotype 045531PAY_DATEPay date for payroll resultnvarchar80
41PA0456HR Master Record: Infotype 045631PAY_DATEPay date for payroll resultnvarchar80
42PA0457HR Master Record: Infotype 045731PAY_DATEPay date for payroll resultnvarchar80
43PA0458HR Master Record for Infotype 045831PAY_DATEPay date for payroll resultnvarchar80
44PA0459HR Master Record for Infotype 045931PAY_DATEPay date for payroll resultnvarchar80
45PA0460HR Master Record for Infotype 046031PAY_DATEPay date for payroll resultnvarchar80