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

42 columns | Print definition?ERP 6.0  | PY_SEQNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRBW_REC_DT_NEWPY-XX-RECON : Country specific reports detailed results11PY_SEQNRSequence Numbernvarchar50
2PA9220HR Master Record: Infotype 922024PY_SEQNRSequence Numbernvarchar50
3PA9390Personal-Stammsatz Infotyp 939024PY_SEQNRSequenznummernvarchar50
4PA9429Registro maestro de personal Infotipo 942924PY_SEQNRNº de secuencianvarchar50
5PA9640Personal-Stammsatz Infotyp 964024PY_SEQNRSequenznummernvarchar50
6PA9701Personal-Stammsatz Infotyp 970124PY_SEQNRSequenznummernvarchar50
7PA9725HR Master Record: Infotype 972524PY_SEQNRSequence Numbernvarchar50
8PA9741HR Master Record: Infotype 974124PY_SEQNRSequence Numbernvarchar50
9PA9742HR Master Record: Infotype 974224PY_SEQNRSequence Numbernvarchar50
10PA9825HR Master Record: Infotype 982524PY_SEQNRSequence Numbernvarchar50
11PA9990HR Master Record: Infotype 999024PY_SEQNRSequence Numbernvarchar50
12PA9991HR Master Record: Infotype 999124PY_SEQNRSequence Numbernvarchar50
13PA9992HR Master Record: Infotype 999224PY_SEQNRSequence Numbernvarchar50
14PA9993HR Master Record: Infotype 999324PY_SEQNRSequence Numbernvarchar50
15PA9995HR Master Record: Infotype 999524PY_SEQNRSequence Numbernvarchar50
16PA9996HR Master Record: Infotype 999624PY_SEQNRSequence Numbernvarchar50
17PA9997HR Master Record: Infotype 999724PY_SEQNRSequence Numbernvarchar50
18PA9998HR Master Record: Infotype 999824PY_SEQNRSequence Numbernvarchar50
TOPBenefit Integration
19PA0496Payroll Infotype: US Benefits Data - Per Pay Period24PY_SEQNRSequence Numbernvarchar50
20PA0497Payroll Infotype: US Benefits Data - MTD24PY_SEQNRSequence Numbernvarchar50
21PA0498Payroll Infotype: US Benefits Data - QTD24PY_SEQNRSequence Numbernvarchar50
22PA0499Payroll Infotype: US Benefits Data - YTD24PY_SEQNRSequence Numbernvarchar50
23PA0500Payroll Infotype: US Benefits Data in Arrears (ARRRS)24PY_SEQNRSequence Numbernvarchar50
24PA0501Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK)24PY_SEQNRSequence Numbernvarchar50
TOPJapan
25PA3239HR Master Record: Infotype 323924PY_SEQNRSequence Numbernvarchar50
TOPPersonnel Administration
26PA0402HR Master Data Infotype 040224PY_SEQNRSequence Numbernvarchar50
27PA0403HR Master Record for Infotype 040324PY_SEQNRSequence Numbernvarchar50
TOPUSA
28PA044624PY_SEQNRnvarchar50
29PA0447US Federal Tax MTD24PY_SEQNRSequence Numbernvarchar50
30PA0448US Federal Tax QTD24PY_SEQNRSequence Numbernvarchar50
31PA0449HR Master Record: Infotype 044924PY_SEQNRSequence Numbernvarchar50
32PA0450HR Master Record: Infotype 045024PY_SEQNRSequence Numbernvarchar50
33PA0451HR Master Record: Infotype 045124PY_SEQNRSequence Numbernvarchar50
34PA0452HR Master Record: Infotype 045224PY_SEQNRSequence Numbernvarchar50
35PA0453HR Master Record: Infotype 045324PY_SEQNRSequence Numbernvarchar50
36PA0454HR Master Record: Infotype 045424PY_SEQNRSequence Numbernvarchar50
37PA0455HR Master Record: Infotype 045524PY_SEQNRSequence Numbernvarchar50
38PA0456HR Master Record: Infotype 045624PY_SEQNRSequence Numbernvarchar50
39PA0457HR Master Record: Infotype 045724PY_SEQNRSequence Numbernvarchar50
40PA0458HR Master Record for Infotype 045824PY_SEQNRSequence Numbernvarchar50
41PA0459HR Master Record for Infotype 045924PY_SEQNRSequence Numbernvarchar50
42PA0460HR Master Record for Infotype 046024PY_SEQNRSequence Numbernvarchar50