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

56 columns | Print definition?ERP 6.0  | PAYDT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRDCT_TPY_RGDIRDeclustering - Directory for Test Payroll Results26PAYDTPay date for payroll resultnvarchar80
2P2BR_BRTAXWithholding Income Tax6PAYDTPay date for payroll resultnvarchar80
3P2CN_CNSPPayroll result: Special Payment (CN)26PAYDTPay date for payroll resultnvarchar80
4P2CN_TAXPayroll result: Income Tax (CN)35PAYDTPay date for payroll resultnvarchar80
5P2NZ_KIWCOKiwi Saver and Complying Fund Details7PAYDTPay date for payroll resultnvarchar80
6P2NZ_NZHPIPayroll Result: Holiday Payment Information NZHPI - NZ9PAYDTPay date for payroll resultnvarchar80
7P2RG_WEARNNI: payment history of affected wagetype10PAYDTPay date for payroll resultnvarchar80
8P2RJ_MSTPayroll result: Monthly socail insurance table10PAYDTPay date for payroll resultnvarchar80
9P2RJ_RETTAXPayroll Results: Detailed Retirement Tax Infomation6PAYDTPay Datenvarchar80
10P2RX_VERSCPayroll Status Information23PAYDTPay date for payroll resultnvarchar80
11P2TN_NHIPayroll Structure NHI Taiwan29PAYDTPay date for payroll resultnvarchar80
12PA3312HR Master Record: Infotype 331290PAYDTPay Datenvarchar80
13PA3364HR Master Record: Infotype 336431PAYDTPay Datenvarchar80
14T5Q_SUPERSTREAMSuper Stream Master Table13PAYDTPay date for payroll resultnvarchar80
15T77PAYKZBTBank Transfer Table Image (BTKZ)20PAYDTPay date for awardsnvarchar80
16T77WWW_CLTRANSDCluster table for storing transaction data.15PAYDTPayment Datenvarchar80
17T77WWW_CLTRAN_BUBackup Table for Storing Transaction Data15PAYDTPayment Datenvarchar80
18T7CNREW_APRPARSPayroll result master table5PAYDTPay date for payroll resultnvarchar80
19T7HRJOPPDJOPPD Form data - Intermediate table17PAYDTPay date for awardsnvarchar80
20T7TW7ASNHI report history data record4PAYDTPay date for payroll resultnvarchar80
TOPBenefits
21PA0270HR Master Data Record: Infotype 0270 (COBRA Payments)24PAYDTCOBRA payment datenvarchar80
TOPCanada
22T5KYAYear end reporting history table4PAYDTPay date for payroll resultnvarchar80
TOPContract Accounts Receivable and Payable
23DFKKCOLLPAYMLINKAssignment of Collection Payments to Collection Units11PAYDTPayment Datenvarchar80
TOPDenmark
24T5M58SAP-PBS Interface: Transfer Payroll Account (DK)3PAYDTPay date for awardsnvarchar80
25T5M7WFile Entries Assignment from T5M7V7PAYDTPay date for awardsnvarchar80
26T5M8GMatchcode W Specifically for Payroll Step (DK)4PAYDTPay date for awardsnvarchar80
27T5M8HPBS error table for importing error file4PAYDTPay date for awardsnvarchar80
28T5M8JFile entries for PBS file4PAYDTPay date for awardsnvarchar80
29T5M8ZEmployer Assignment in Original Period3PAYDTPay date for awardsnvarchar80
30T5M9HSplit Indicators for Wage Types Sent to PBS3PAYDTPay date for awardsnvarchar80
31T5MFDRetrieval of Official Statistics for DA/DS and FA6PAYDTPay date for awardsnvarchar80
32T5MFHSpecial Transfer Days for Wage Types6PAYDTPay date for awardsnvarchar80
33T5MFJCorrect FA Absence Statistics6PAYDTPay date for awardsnvarchar80
34T5MP1General Messages for the PBS Remuneration Statement8PAYDTPay date for awardsnvarchar80
TOPExpenditure Certification
35FMEUFEXPCertified Expenditure Documents22PAYDTPayment Datenvarchar80
TOPHong Kong
36T7HK04Control table for EOY Payment5PAYDTPay date for EOY paymentnvarchar80
TOPInterface to External Payroll Systems
37T5UOTTax Services: Terminations and Inactives6PAYDTPay date for payroll resultnvarchar80
TOPJapan
38PA3204HR Master Record: Infotype 320424PAYDTPay Datenvarchar80
TOPMalaysia
39T5LESESS Malaysia: TP1 TP215PAYDTPayment Datenvarchar80
TOPPayroll
40T7BGA2Changes of external transfers (IT11)4PAYDTPay date for payroll resultnvarchar80
41T7ROA5Changes of external transfers (IT11)4PAYDTPay date for payroll resultnvarchar80
42T7SIA0Annual tax - Paydays x Days of payments3PAYDTPay date for awardsnvarchar80
43T7SIA5History of repayments5PAYDTnvarchar80
44T7SIREK11AState for REK field 011a4PAYDTDatum izplacila za rezultat obracuna placnvarchar80
TOPPayroll General Parts
45HRPY_RGDIRDirectory for Payroll Results24PAYDTPay date for payroll resultnvarchar80
46HRPY_RGDIR_TEMPInternal TEMPORARY Directory for Payroll Results24PAYDTPay date for payroll resultnvarchar80
47PYNOSCREENSelection Screen Fields (Only as Interface)7PAYDTPay date for payroll resultnvarchar80
48T558BPayroll Account Transfer: Payroll Periods6PAYDTPay date for payroll resultnvarchar80
TOPPersonnel Management
49T7HR1RR-Sm ID3PAYDTPay date for payroll resultnvarchar80
50T7HR1SR-Sm ID4PAYDTPay date for payroll resultnvarchar80
51T7HRA0Datum uplate - Napomene - GOD obrazac3PAYDTnvarchar80
TOPSingapore
52PA0183HR Master Record: Infotype 0183 [Awards] (SG)28PAYDTPay date for awardsnvarchar80
TOPTax Reporter
53T51T9Tax pay dates3PAYDTTax pay datenvarchar60
54T5UT1Tax Interface Table: Payroll results7PAYDTTax pay datenvarchar60
55T5UT2Deposited taxes, that have to be reported in tax forms6PAYDTTax pay datenvarchar60
TOPUnited Kingdom
56T5G_DTONINational Insurance Data Take-on8PAYDTPay date for payroll resultnvarchar80