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

52 columns | Print definition?ERP 6.0  | BONDT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRDCT_TPY_RGDIRDeclustering - Directory for Test Payroll Results19BONDTOff-cycle payroll payment datenvarchar80
2P2AA_OH_SAPayroll Result: OH Data for KSA20BONDTOff-cycle payroll payment datenvarchar80
3P2BG_BG_CUXDifference table of payroll results10BONDTOff-cycle payroll payment datenvarchar80
4P2BG_BG_DIFDifference table of payroll results10BONDTOff-cycle payroll payment datenvarchar80
5P2CO_COAVAPC2CO_AVA43BONDTOff-cycle payroll payment datenvarchar80
6P2CO_COSEVPC2CO_SEV16BONDTOff-cycle payroll payment datenvarchar80
7P2RO_RO_CUXDifference table of payroll results10BONDTOff-cycle payroll payment datenvarchar80
8P2RO_RO_DIFDifference table of payroll results10BONDTOff-cycle payroll payment datenvarchar80
9P2RU_BALPayroll Results: Tax Retro Differences -(USA)13BONDTOff-cycle payroll payment datenvarchar80
10P2RU_CLMOverpayments Processing structure9BONDTOff-cycle payroll payment datenvarchar80
11P2RU_CLM_PERSONOverpayments Processing structure11BONDTOff-cycle payroll payment datenvarchar80
12P2RU_DFRTPayroll Results: Retroaccounting Differences -DFRT- (USA)7BONDTOff-cycle payroll payment datenvarchar80
13P2RU_DNRCTPayroll Results: Retro Differences 1042S -DNRCT- (USA)9BONDTOff-cycle payroll payment datenvarchar80
14P2RU_UNBPayroll Results: Tax Retro Differences -(USA)13BONDTOff-cycle payroll payment datenvarchar80
15P2RU_XDFRTPayroll Results: Tax Retro Differences -(USA)13BONDTOff-cycle payroll payment datenvarchar80
16P2RX_VERSCPayroll Status Information16BONDTOff-cycle payroll payment datenvarchar80
17PA3273HR Master Record: Infotype 327353BONDTOff-cycle payroll payment datenvarchar80
18PA3307HR Master Record: Infotype 330734BONDTOff-cycle payroll payment datenvarchar80
19PA3312HR Master Record: Infotype 331291BONDTOff-cycle payroll payment datenvarchar80
20PB3307Applicant data infotype 3307 (model)34BONDTOff-cycle payroll payment datenvarchar80
21T5Q_SUPERSTREAMSuper Stream Master Table12BONDTOff-cycle payroll payment datenvarchar80
22T77PAYKZBTBank Transfer Table Image (BTKZ)14BONDTOff-cycle payroll payment datenvarchar80
TOPArgentina
23PA0551Termination of contract: General data94BONDTOff-cycle payroll payment datenvarchar80
24T7AR28Assignment of SIJP periods to settled payrolls3BONDTOff-cycle payroll payment datenvarchar80
25T7AR75Annual Extra Payment (SAC): Off-cycle payroll run data5BONDTOff-cycle payroll payment datenvarchar80
TOPAustralia
26PA0701HR Terminations Data Container : Infotype 070130BONDTOff-cycle payroll payment datenvarchar80
TOPDenmark
27T5M49Date Identifiers for Special Payroll9BONDTOff-cycle payroll payment datenvarchar80
28T5M5YAssignment of Year and PBS Track to an Original Payroll7BONDTOff-cycle payroll payment datenvarchar80
29T5M7DStatus Line for Payroll Run32BONDTOff-cycle payroll payment datenvarchar80
TOPJapan
30T5J69HR Attributes to SYOYO payroll run JP5BONDTOff-cycle payroll payment datenvarchar80
TOPNew Zealand
31PT2001HR Time Record: Infotype 2001 (Absences)74BONDTOff-cycle payroll payment datenvarchar80
TOPOff-Cycle
32T52OCGOff-Cycle: Indicators for Batch: Payroll, Subsequent Program9BONDTOff-cycle payroll payment datenvarchar80
33T52OCMPOff-Cycle Flag for Mass Processing4BONDTOff-cycle payroll payment datenvarchar80
TOPPayroll
34T5H84Payroll log8BONDTOff-cycle payroll payment datenvarchar80
35T5HNRHU_NREN payroll table data of the "current month"8BONDTOff-cycle payroll payment datenvarchar80
36T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000957BONDTDátum platby zúctovania off-cyclenvarchar80
TOPPayroll General Parts
37HRPY_RGDIRDirectory for Payroll Results17BONDTOff-cycle payroll payment datenvarchar80
38HRPY_RGDIR_TEMPInternal TEMPORARY Directory for Payroll Results17BONDTOff-cycle payroll payment datenvarchar80
39PA0815HR Master Record for Infotype 081544BONDTOff-cycle payroll payment datenvarchar80
40PYNOSCREENSelection Screen Fields (Only as Interface)9BONDTOff-cycle payroll payment datenvarchar80
41T51G1Off-Cycle Batch Table12BONDTOff-cycle payroll payment datenvarchar80
TOPPersonnel Administration
42PA0009HR Master Record: Infotype 0009 (Bank Details)54BONDTOff-cycle payroll payment datenvarchar80
43PA0829HR master record for infotypes 082933BONDTOff-cycle payroll payment datenvarchar80
44PA0831HR master record for infotypes 083194BONDTOff-cycle payroll payment datenvarchar80
45PA0834HR master record for infotypes 083432BONDTOff-cycle payroll payment datenvarchar80
46T7COT3Payroll external results transfer: COSEV16BONDTOff-cycle payroll payment datenvarchar80
47T7COT8Payroll external results transfer: COAVA43BONDTOff-cycle payroll payment datenvarchar80
TOPPersonnel Time Management
48PA2001HR Time Record: Infotype 2001 (Absences)74BONDTOff-cycle payroll payment datenvarchar80
TOPRecruitment
49PB0009HR Master Record: Infotype 0009 (Bank Details)54BONDTOff-cycle payroll payment datenvarchar80
TOPTax Reporter
50T51TXTransfer to be Evaluated10BONDTOff-cycle payroll payment datenvarchar80
TOPThird Party Remittance
51T51R1Remittance evaluation run data12BONDTOff-cycle payroll payment datenvarchar80
TOPUSA
52PA0909HR Master Record: Infotype 090930BONDTOff-cycle payroll payment datenvarchar80