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

154 columns | Print definition?ERP 6.0  | PAYTY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_CD2_CCD Posting: GL item settings3PAYTYType of Posting for Collections/Disbursements Documentnvarchar10
2/GSINS/INH_CD3_CCD Posting: BP item settings3PAYTYType of Posting for Collections/Disbursements Documentnvarchar10
3/GSINS/INH_CD4_CCD Posting: Variant-Type of Posting3PAYTYType of Posting for Collections/Disbursements Documentnvarchar10
4/GSINS/INH_RIDIHCM-FSCD: List of HCM Pernr Items to be posted9PAYTYType of Posting for Collections/Disbursements Documentnvarchar10
5HRDCT_TPY_RGDIRDeclustering - Directory for Test Payroll Results16PAYTYPayroll typenvarchar10
6P2BG_BG_CUXDifference table of payroll results8PAYTYPayroll typenvarchar10
7P2BG_BG_DIFDifference table of payroll results8PAYTYPayroll typenvarchar10
8P2CO_COAVAPC2CO_AVA41PAYTYPayroll typenvarchar10
9P2CO_COSEVPC2CO_SEV14PAYTYPayroll typenvarchar10
10P2HK_RETIPayroll structure for retroactive accounting8PAYTYPayroll typenvarchar10
11P2HK_RETOPayroll structure for retroactive accounting8PAYTYPayroll typenvarchar10
12P2IS_RETIPayroll structure for retroactive accounting8PAYTYPayroll typenvarchar10
13P2IS_RETOPayroll structure for retroactive accounting8PAYTYPayroll typenvarchar10
14P2KR_KRSP2Payroll Results Korea: Separation payroll II6PAYTYPayment typenvarchar20
15P2MX_GRORDMaintenance payment order10PAYTYPayroll typenvarchar10
16P2NZ_NZHPIPayroll Result: Holiday Payment Information NZHPI - NZ7PAYTYPayroll typenvarchar10
17P2RH_HU_NRENP21PA23PAYTYPayroll typenvarchar10
18P2RK_GRORDPayroll results Canada: Garnishment order11PAYTYPayroll typenvarchar10
19P2RM_MVACPayroll Structure MVAC: Leave Handling (DK)121PAYTYPayroll typenvarchar10
20P2RO_RO_CUXDifference table of payroll results8PAYTYPayroll typenvarchar10
21P2RO_RO_DIFDifference table of payroll results8PAYTYPayroll typenvarchar10
22P2RR_RMPayroll Results: Table for Master data (SG)49PAYTYPayroll typenvarchar10
23P2RU_BALPayroll Results: Tax Retro Differences -(USA)16PAYTYPayroll typenvarchar10
24P2RU_CLMOverpayments Processing structure14PAYTYPayroll typenvarchar10
25P2RU_CLM_PERSONOverpayments Processing structure16PAYTYPayroll typenvarchar10
26P2RU_DFRTPayroll Results: Retroaccounting Differences -DFRT- (USA)12PAYTYPayroll typenvarchar10
27P2RU_GRDOCPayroll Results: Garnishment for US Document21PAYTYPayroll typenvarchar10
28P2RU_UNBPayroll Results: Tax Retro Differences -(USA)16PAYTYPayroll typenvarchar10
29P2RU_XDFRTPayroll Results: Tax Retro Differences -(USA)16PAYTYPayroll typenvarchar10
30P2RX_EVAL_PERIODIndex for Payroll Results Periods13PAYTYPayroll typenvarchar10
31P2RX_VERSCPayroll Status Information17PAYTYPayroll typenvarchar10
32P2UA_UATIStructure for Ukrainian social insurance(PF) calculation7PAYTYPayroll typenvarchar10
33P2UA_UATRStructure for Ukrainian social insurance(PF) calculation7PAYTYPayroll typenvarchar10
34P2UA_UATSStructure for Ukrainian social insurance(PF) calculation7PAYTYPayroll typenvarchar10
35PA0556HR Master Record: Infotype 055631PAYTYPayment typenvarchar40
36PA3273HR Master Record: Infotype 327351PAYTYPayroll typenvarchar10
37PA9220HR Master Record: Infotype 922029PAYTYPayroll typenvarchar10
38PA9390Personal-Stammsatz Infotyp 939029PAYTYAbrechnungstypnvarchar10
39PA9429Registro maestro de personal Infotipo 942929PAYTYTipo de nóminanvarchar10
40PA9640Personal-Stammsatz Infotyp 964029PAYTYAbrechnungstypnvarchar10
41PA9701Personal-Stammsatz Infotyp 970129PAYTYAbrechnungstypnvarchar10
42PA9725HR Master Record: Infotype 972529PAYTYPayroll typenvarchar10
43PA9741HR Master Record: Infotype 974129PAYTYPayroll typenvarchar10
44PA9742HR Master Record: Infotype 974229PAYTYPayroll typenvarchar10
45PA9825HR Master Record: Infotype 982529PAYTYPayroll typenvarchar10
46PA9990HR Master Record: Infotype 999029PAYTYPayroll typenvarchar10
47PA9991HR Master Record: Infotype 999129PAYTYPayroll typenvarchar10
48PA9992HR Master Record: Infotype 999229PAYTYPayroll typenvarchar10
49PA9993HR Master Record: Infotype 999329PAYTYPayroll typenvarchar10
50PA9995HR Master Record: Infotype 999529PAYTYPayroll typenvarchar10
51PA9996HR Master Record: Infotype 999629PAYTYPayroll typenvarchar10
52PA9997HR Master Record: Infotype 999729PAYTYPayroll typenvarchar10
53PA9998HR Master Record: Infotype 999829PAYTYPayroll typenvarchar10
54PYC_D_PY_MSGPYC: payroll message15PAYTYPayroll typenvarchar10
55T5FDSNPAYMTemp table for PAYFR_RESULT-PAYM15PAYTYPaie : Code type groupe rubriquesnvarchar50
56T5Q_SUPERSTREAMSuper Stream Master Table10PAYTYPayroll typenvarchar10
57T5UTLAVKAdditional Attributes of Tax Company on Tax Authority Level4PAYTYPayroll typenvarchar10
58T77PAYKZBTBank Transfer Table Image (BTKZ)12PAYTYPayroll typenvarchar10
59TFKKBRINRETCODBrazil: Receivables Return Codes Conversion2PAYTYReceivables: Payment Typenvarchar120
TOPArgentina
60PA0551Termination of contract: General data92PAYTYPayroll typenvarchar10
61T7AR28Assignment of SIJP periods to settled payrolls11PAYTYPayroll typenvarchar10
62T7AR75Annual Extra Payment (SAC): Off-cycle payroll run data3PAYTYPayroll typenvarchar10
TOPBenefit Integration
63PA0496Payroll Infotype: US Benefits Data - Per Pay Period29PAYTYPayroll typenvarchar10
64PA0497Payroll Infotype: US Benefits Data - MTD29PAYTYPayroll typenvarchar10
65PA0498Payroll Infotype: US Benefits Data - QTD29PAYTYPayroll typenvarchar10
66PA0499Payroll Infotype: US Benefits Data - YTD29PAYTYPayroll typenvarchar10
67PA0500Payroll Infotype: US Benefits Data in Arrears (ARRRS)29PAYTYPayroll typenvarchar10
68PA0501Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK)29PAYTYPayroll typenvarchar10
TOPBrazil
69PA0738Alimony adjustment for Brazil33PAYTYPayroll typenvarchar10
70T7BRG1Alimony: calculation models5PAYTYPayroll typenvarchar10
TOPCanada
71PA0221HR Master Record: Infotype 0221 (Manual Checks)145PAYTYPayroll typenvarchar10
TOPDenmark
72PA0074HR Master Record: Infotype 0074 (Leave Processing - DK)146PAYTYPayroll typenvarchar10
73PA0578HR Master Record: Infotype 057827PAYTYPayroll typenvarchar10
74T5M49Date Identifiers for Special Payroll7PAYTYPayroll typenvarchar10
75T5M58SAP-PBS Interface: Transfer Payroll Account (DK)4PAYTYPayroll typenvarchar10
76T5M5YAssignment of Year and PBS Track to an Original Payroll5PAYTYPayroll typenvarchar10
77T5M6PDefault Values for Leave Accumulation127PAYTYPayroll typenvarchar10
78T5M7DStatus Line for Payroll Run33PAYTYPayroll typenvarchar10
79T5M7WFile Entries Assignment from T5M7V8PAYTYPayroll typenvarchar10
80T5M8GMatchcode W Specifically for Payroll Step (DK)5PAYTYPayroll typenvarchar10
81T5M8HPBS error table for importing error file5PAYTYPayroll typenvarchar10
82T5M8JFile entries for PBS file5PAYTYPayroll typenvarchar10
83T5M8ZEmployer Assignment in Original Period4PAYTYPayroll typenvarchar10
84T5M9HSplit Indicators for Wage Types Sent to PBS4PAYTYPayroll typenvarchar10
85T5MFDRetrieval of Official Statistics for DA/DS and FA8PAYTYPayroll typenvarchar10
86T5MFHSpecial Transfer Days for Wage Types8PAYTYPayroll typenvarchar10
87T5MFJCorrect FA Absence Statistics8PAYTYPayroll typenvarchar10
88T5MP1General Messages for the PBS Remuneration Statement6PAYTYPayroll typenvarchar10
TOPHong Kong
89T7HK04Control table for EOY Payment6PAYTYPayroll typenvarchar10
90T7HK4AEvents & reasons for LSP/Severance payments4PAYTYPayment type for long services and severancenvarchar10
91T7HK4BFactor & constants for LSP/severance payments3PAYTYPayment type for long services and severancenvarchar10
TOPIndia
92T7INTEForm 24Q - TAN number lock4PAYTYPayroll typenvarchar10
TOPInterface to External Payroll Systems
93T5UOTTax Services: Terminations and Inactives4PAYTYPayroll typenvarchar10
TOPJapan
94PA3239HR Master Record: Infotype 323929PAYTYPayroll typenvarchar10
95T5J69HR Attributes to SYOYO payroll run JP3PAYTYPayroll typenvarchar10
TOPKorea
96T7KRS2Separation payment average calculation period2PAYTYPayment typenvarchar20
97T7KRS6Cumulation method2PAYTYPayment typenvarchar20
TOPNew Zealand
98PT2001HR Time Record: Infotype 2001 (Absences)72PAYTYPayroll typenvarchar10
99T7NZLPLeave Payment Rule Table - NZ7PAYTYLeave Pay Type.nvarchar10
TOPOff-Cycle
100T52OCCCategories for Off-Cycle Reasons3PAYTYPayroll typenvarchar10
101T52OCGOff-Cycle: Indicators for Batch: Payroll, Subsequent Program7PAYTYPayroll typenvarchar10
TOPPayroll
102PA3234HR master record, infotype 323438PAYTYPayroll typenvarchar10
103T5H84Payroll log5PAYTYPayroll typenvarchar10
104T5HNRHU_NREN payroll table data of the "current month"5PAYTYPayroll typenvarchar10
105T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000954PAYTYTyp zúctovanianvarchar10
TOPPayroll General Parts
106HRPY_RGDIRDirectory for Payroll Results14PAYTYPayroll typenvarchar10
107HRPY_RGDIR_TEMPInternal TEMPORARY Directory for Payroll Results14PAYTYPayroll typenvarchar10
108PA0128HR Master Record: Infotype 0128 (Notifications)28PAYTYPayroll typenvarchar10
109PA0267HR Master Record: Infotype 0267 (One time Payment off-cycle)36PAYTYPayroll typenvarchar10
110PA0815HR Master Record for Infotype 081542PAYTYPayroll typenvarchar10
111PYNOSCREENSelection Screen Fields (Only as Interface)1PAYTYPayroll typenvarchar10
112PYTIMESCREENPNP900: Fields For Time Selection1PAYTYPayroll typenvarchar10
113T51G1Off-Cycle Batch Table14PAYTYPayroll typenvarchar10
114T52BXValid Special Payroll Runs for Countries2PAYTYPayroll typenvarchar10
115T52RICRetroactive Changes to Off-Cycle Infotypes4PAYTYPayroll typenvarchar10
116T558BPayroll Account Transfer: Payroll Periods4PAYTYPayroll typenvarchar10
TOPPersonnel Administration
117PA0009HR Master Record: Infotype 0009 (Bank Details)51PAYTYPayroll typenvarchar10
118PA0402HR Master Data Infotype 040229PAYTYPayroll typenvarchar10
119PA0403HR Master Record for Infotype 040329PAYTYPayroll typenvarchar10
120PA0657HR Master Record: Infotype 065742PAYTYPayroll typenvarchar10
121PA0829HR master record for infotypes 082930PAYTYPayroll typenvarchar10
122PA0831HR master record for infotypes 083192PAYTYPayroll typenvarchar10
123PA0834HR master record for infotypes 083430PAYTYPayroll typenvarchar10
124T7COT3Payroll external results transfer: COSEV14PAYTYPayroll typenvarchar10
125T7COT8Payroll external results transfer: COAVA41PAYTYPayroll typenvarchar10
TOPPersonnel Management
126T7HR1RR-Sm ID4PAYTYPayroll typenvarchar10
127T7HR1SR-Sm ID5PAYTYPayroll typenvarchar10
128T7HRA0Datum uplate - Napomene - GOD obrazac4PAYTYTip obracuna placanvarchar10
129T7HRA3IP Form - Earnings8PAYTYPayroll typenvarchar10
130T7HRA3NIP Form - Earnings - New (w. OIB)8PAYTYPayroll typenvarchar10
131T7HRA3OIP Form - Earnings - with IDENT in key9PAYTYPayroll typenvarchar10
TOPPersonnel Time Management
132PA2001HR Time Record: Infotype 2001 (Absences)72PAYTYPayroll typenvarchar10
TOPPublic Sector
133T5QPBS4APayment Type for terminations & redundancies2PAYTYPayment Type for Terminations & Redundanciesnvarchar40
134T5QPBS4ATText for Payment Type for terminations & redundancies3PAYTYPayment Type for Terminations & Redundanciesnvarchar40
135T5QPBS4BTermination Payment Type3PAYTYPayment Type for Terminations & Redundanciesnvarchar40
TOPRecruitment
136PB0009HR Master Record: Infotype 0009 (Bank Details)51PAYTYPayroll typenvarchar10
TOPReuse Services for Country Development
137PA0262HR Master Record: Infotype 026229PAYTYPayroll typenvarchar10
TOPUnited Kingdom
138T5G_DTONINational Insurance Data Take-on6PAYTYPayroll typenvarchar10
TOPUSA
139PA044629PAYTYnvarchar10
140PA0447US Federal Tax MTD29PAYTYPayroll typenvarchar10
141PA0448US Federal Tax QTD29PAYTYPayroll typenvarchar10
142PA0449HR Master Record: Infotype 044929PAYTYPayroll typenvarchar10
143PA0450HR Master Record: Infotype 045029PAYTYPayroll typenvarchar10
144PA0451HR Master Record: Infotype 045129PAYTYPayroll typenvarchar10
145PA0452HR Master Record: Infotype 045229PAYTYPayroll typenvarchar10
146PA0453HR Master Record: Infotype 045329PAYTYPayroll typenvarchar10
147PA0454HR Master Record: Infotype 045429PAYTYPayroll typenvarchar10
148PA0455HR Master Record: Infotype 045529PAYTYPayroll typenvarchar10
149PA0456HR Master Record: Infotype 045629PAYTYPayroll typenvarchar10
150PA0457HR Master Record: Infotype 045729PAYTYPayroll typenvarchar10
151PA0458HR Master Record for Infotype 045829PAYTYPayroll typenvarchar10
152PA0459HR Master Record for Infotype 045929PAYTYPayroll typenvarchar10
153PA0460HR Master Record for Infotype 046029PAYTYPayroll typenvarchar10
154PA0909HR Master Record: Infotype 090931PAYTYPayroll typenvarchar10