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

152 columns | Print definition?ERP 6.0  | PAYID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKKEXC_BAppendix to External Payment Information4PAYIDID of External Paymentnvarchar350
2HRDCT_TPY_RGDIRDeclustering - Directory for Test Payroll Results17PAYIDPayroll Identifiernvarchar10
3P2BG_BG_CUXDifference table of payroll results9PAYIDPayroll Identifiernvarchar10
4P2BG_BG_DIFDifference table of payroll results9PAYIDPayroll Identifiernvarchar10
5P2CO_COAVAPC2CO_AVA42PAYIDPayroll Identifiernvarchar10
6P2CO_COSEVPC2CO_SEV15PAYIDPayroll Identifiernvarchar10
7P2FI_STTax result structure for Finland23PAYIDPayer identification for bank transfer filenvarchar90
8P2HK_RETIPayroll structure for retroactive accounting9PAYIDPayroll Identifiernvarchar10
9P2HK_RETOPayroll structure for retroactive accounting9PAYIDPayroll Identifiernvarchar10
10P2IS_RETIPayroll structure for retroactive accounting9PAYIDPayroll Identifiernvarchar10
11P2IS_RETOPayroll structure for retroactive accounting9PAYIDPayroll Identifiernvarchar10
12P2NZ_EMSPayroll Result: Employer Monthly Schedule - NZ10PAYIDPayroll Identifiernvarchar10
13P2NZ_LVACCPayroll Result: Leave Accruals LVACC - NZ25PAYIDParental Lve Flag - NZnvarchar10
14P2NZ_NZHPIPayroll Result: Holiday Payment Information NZHPI - NZ8PAYIDPayroll Identifiernvarchar10
15P2RH_HU_NRENP21PA24PAYIDPayroll Identifiernvarchar10
16P2RM_MVACPayroll Structure MVAC: Leave Handling (DK)122PAYIDPayroll Identifiernvarchar10
17P2RO_RO_CUXDifference table of payroll results9PAYIDPayroll Identifiernvarchar10
18P2RO_RO_DIFDifference table of payroll results9PAYIDPayroll Identifiernvarchar10
19P2RR_RMPayroll Results: Table for Master data (SG)50PAYIDPayroll Identifiernvarchar10
20P2RU_BALPayroll Results: Tax Retro Differences -(USA)17PAYIDPayroll Identifiernvarchar10
21P2RU_CLMOverpayments Processing structure15PAYIDPayroll Identifiernvarchar10
22P2RU_CLM_PERSONOverpayments Processing structure17PAYIDPayroll Identifiernvarchar10
23P2RU_DFRTPayroll Results: Retroaccounting Differences -DFRT- (USA)13PAYIDPayroll Identifiernvarchar10
24P2RU_UNBPayroll Results: Tax Retro Differences -(USA)17PAYIDPayroll Identifiernvarchar10
25P2RU_XDFRTPayroll Results: Tax Retro Differences -(USA)17PAYIDPayroll Identifiernvarchar10
26P2RX_EVAL_PERIODIndex for Payroll Results Periods14PAYIDPayroll Identifiernvarchar10
27P2RX_VERSCPayroll Status Information18PAYIDPayroll Identifiernvarchar10
28P2UA_UATIStructure for Ukrainian social insurance(PF) calculation8PAYIDPayroll Identifiernvarchar10
29P2UA_UATRStructure for Ukrainian social insurance(PF) calculation8PAYIDPayroll Identifiernvarchar10
30P2UA_UATSStructure for Ukrainian social insurance(PF) calculation8PAYIDPayroll Identifiernvarchar10
31PA3273HR Master Record: Infotype 327352PAYIDPayroll Identifiernvarchar10
32PA9220HR Master Record: Infotype 922030PAYIDPayroll Identifiernvarchar10
33PA9390Personal-Stammsatz Infotyp 939030PAYIDAbrechnungsidentifikatornvarchar10
34PA9429Registro maestro de personal Infotipo 942930PAYIDIdentificador de nóminanvarchar10
35PA9640Personal-Stammsatz Infotyp 964030PAYIDAbrechnungsidentifikatornvarchar10
36PA9701Personal-Stammsatz Infotyp 970130PAYIDAbrechnungsidentifikatornvarchar10
37PA9725HR Master Record: Infotype 972530PAYIDPayroll Identifiernvarchar10
38PA9741HR Master Record: Infotype 974130PAYIDPayroll Identifiernvarchar10
39PA9742HR Master Record: Infotype 974230PAYIDPayroll Identifiernvarchar10
40PA9825HR Master Record: Infotype 982530PAYIDPayroll Identifiernvarchar10
41PA9990HR Master Record: Infotype 999030PAYIDPayroll Identifiernvarchar10
42PA9991HR Master Record: Infotype 999130PAYIDPayroll Identifiernvarchar10
43PA9992HR Master Record: Infotype 999230PAYIDPayroll Identifiernvarchar10
44PA9993HR Master Record: Infotype 999330PAYIDPayroll Identifiernvarchar10
45PA9995HR Master Record: Infotype 999530PAYIDPayroll Identifiernvarchar10
46PA9996HR Master Record: Infotype 999630PAYIDPayroll Identifiernvarchar10
47PA9997HR Master Record: Infotype 999730PAYIDPayroll Identifiernvarchar10
48PA9998HR Master Record: Infotype 999830PAYIDPayroll Identifiernvarchar10
49PYC_D_PY_MSGPYC: payroll message16PAYIDPayroll Identifiernvarchar10
50T5Q_SUPERSTREAMSuper Stream Master Table11PAYIDPayroll Identifiernvarchar10
51T77PAYKZBTBank Transfer Table Image (BTKZ)13PAYIDPayroll Identifiernvarchar10
52T7CNREW_APRPARSPayroll result master table10PAYIDPayroll Identifiernvarchar10
TOPArgentina
53PA0551Termination of contract: General data93PAYIDPayroll Identifiernvarchar10
54T7AR28Assignment of SIJP periods to settled payrolls4PAYIDPayroll Identifiernvarchar10
55T7AR75Annual Extra Payment (SAC): Off-cycle payroll run data4PAYIDPayroll Identifiernvarchar10
TOPAustralia
56PA0701HR Terminations Data Container : Infotype 070132PAYIDPayroll Identifiernvarchar10
TOPBenefit Integration
57PA0496Payroll Infotype: US Benefits Data - Per Pay Period30PAYIDPayroll Identifiernvarchar10
58PA0497Payroll Infotype: US Benefits Data - MTD30PAYIDPayroll Identifiernvarchar10
59PA0498Payroll Infotype: US Benefits Data - QTD30PAYIDPayroll Identifiernvarchar10
60PA0499Payroll Infotype: US Benefits Data - YTD30PAYIDPayroll Identifiernvarchar10
61PA0500Payroll Infotype: US Benefits Data in Arrears (ARRRS)30PAYIDPayroll Identifiernvarchar10
62PA0501Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK)30PAYIDPayroll Identifiernvarchar10
TOPBrazil
63PA0738Alimony adjustment for Brazil34PAYIDPayroll Identifiernvarchar10
TOPCanada
64PA0221HR Master Record: Infotype 0221 (Manual Checks)146PAYIDPayroll Identifiernvarchar10
TOPChina
65T7CN29Social insurance7PAYIDPayment id for social insurancenvarchar10
TOPCollectionsDisbursements
66ITAGCYDEPDIFFAdditional Information About Deposits and Differences2PAYIDPayment IDvarbinary160
67ITAGCYPAYPayment Information2PAYIDPayment IDvarbinary160
68ITAGCYPM_ADDAgency Collections: Payt Method Info. Addtl Payt Methods2PAYIDPayment IDvarbinary160
69ITAGCYPM_BANKPayment Methods: Bank2PAYIDPayment IDvarbinary160
70ITAGCYPM_CCPayment Methods: Credit Card2PAYIDPayment IDvarbinary160
71ITAGCYPM_CHECKPayment Methods: Check2PAYIDPayment IDvarbinary160
72ITAGCYWDTable for Withdrawal Information2PAYIDPayment IDvarbinary160
TOPContract Accounts Receivable and Payable
73DFKKEXCExternal Payment Information4PAYIDID of External Paymentnvarchar350
74DFKKEXC_CLExternal Payment Information - Clearing Proposals4PAYIDID of External Paymentnvarchar350
75DFKKEXC_PAYINFOInformation for Payment Medium4PAYIDID of External Paymentnvarchar350
TOPDenmark
76PA0074HR Master Record: Infotype 0074 (Leave Processing - DK)147PAYIDPayroll Identifiernvarchar10
77PA0578HR Master Record: Infotype 057828PAYIDPayroll Identifiernvarchar10
78T5M49Date Identifiers for Special Payroll8PAYIDPayroll Identifiernvarchar10
79T5M58SAP-PBS Interface: Transfer Payroll Account (DK)5PAYIDPayroll Identifiernvarchar10
80T5M5YAssignment of Year and PBS Track to an Original Payroll6PAYIDPayroll Identifiernvarchar10
81T5M6PDefault Values for Leave Accumulation128PAYIDPayroll Identifiernvarchar10
82T5M7DStatus Line for Payroll Run34PAYIDPayroll Identifiernvarchar10
83T5M7WFile Entries Assignment from T5M7V9PAYIDPayroll Identifiernvarchar10
84T5M8GMatchcode W Specifically for Payroll Step (DK)6PAYIDPayroll Identifiernvarchar10
85T5M8HPBS error table for importing error file6PAYIDPayroll Identifiernvarchar10
86T5M8JFile entries for PBS file6PAYIDPayroll Identifiernvarchar10
87T5M8ZEmployer Assignment in Original Period5PAYIDPayroll Identifiernvarchar10
88T5M9HSplit Indicators for Wage Types Sent to PBS5PAYIDPayroll Identifiernvarchar10
89T5MFDRetrieval of Official Statistics for DA/DS and FA7PAYIDPayroll Identifiernvarchar10
90T5MFHSpecial Transfer Days for Wage Types7PAYIDPayroll Identifiernvarchar10
91T5MFJCorrect FA Absence Statistics7PAYIDPayroll Identifiernvarchar10
92T5MP1General Messages for the PBS Remuneration Statement7PAYIDPayroll Identifiernvarchar10
TOPFinland
93T7FI1PTime-dependent information for personnel area/subarea10PAYIDPayer identification for bank transfer filenvarchar90
TOPIndia
94T7INTEForm 24Q - TAN number lock5PAYIDPayroll Identifiernvarchar10
TOPInterface to External Payroll Systems
95T5UOTTax Services: Terminations and Inactives5PAYIDPayroll Identifiernvarchar10
TOPJapan
96PA3239HR Master Record: Infotype 323930PAYIDPayroll Identifiernvarchar10
97T5J69HR Attributes to SYOYO payroll run JP4PAYIDPayroll Identifiernvarchar10
TOPLong-Term Incentives
98PA0762HR Master Record: Infotype 0762 (LTI Exercising)35PAYIDPayroll Identifiernvarchar10
TOPNew Zealand
99PA0312Leave History Adjustments NZ35PAYIDParental Lve Flag - NZnvarchar10
100PT2001HR Time Record: Infotype 2001 (Absences)73PAYIDPayroll Identifiernvarchar10
TOPOff-Cycle
101T52OCGOff-Cycle: Indicators for Batch: Payroll, Subsequent Program8PAYIDPayroll Identifiernvarchar10
102T52OCMPOff-Cycle Flag for Mass Processing6PAYIDPayroll Identifiernvarchar10
TOPPayroll
103PA3234HR master record, infotype 323439PAYIDPayroll Identifiernvarchar10
104T5H84Payroll log6PAYIDPayroll Identifiernvarchar10
105T5HNRHU_NREN payroll table data of the "current month"6PAYIDPayroll Identifiernvarchar10
106T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000955PAYIDIdentifikátor zúctovanianvarchar10
TOPPayroll General Parts
107HRPY_RGDIRDirectory for Payroll Results15PAYIDPayroll Identifiernvarchar10
108HRPY_RGDIR_TEMPInternal TEMPORARY Directory for Payroll Results15PAYIDPayroll Identifiernvarchar10
109PA0128HR Master Record: Infotype 0128 (Notifications)31PAYIDPayroll Identifiernvarchar10
110PA0267HR Master Record: Infotype 0267 (One time Payment off-cycle)37PAYIDPayroll Identifiernvarchar10
111PA0815HR Master Record for Infotype 081543PAYIDPayroll Identifiernvarchar10
112PYNOSCREENSelection Screen Fields (Only as Interface)6PAYIDPayroll Identifiernvarchar10
113PYTIMESCREENPNP900: Fields For Time Selection2PAYIDPayroll Identifiernvarchar10
114T51G1Off-Cycle Batch Table15PAYIDPayroll Identifiernvarchar10
115T52RICRetroactive Changes to Off-Cycle Infotypes5PAYIDPayroll Identifiernvarchar10
116T558BPayroll Account Transfer: Payroll Periods5PAYIDPayroll Identifiernvarchar10
TOPPersonnel Administration
117PA0009HR Master Record: Infotype 0009 (Bank Details)52PAYIDPayroll Identifiernvarchar10
118PA0402HR Master Data Infotype 040230PAYIDPayroll Identifiernvarchar10
119PA0403HR Master Record for Infotype 040330PAYIDPayroll Identifiernvarchar10
120PA0657HR Master Record: Infotype 065743PAYIDPayroll Identifiernvarchar10
121PA0829HR master record for infotypes 082931PAYIDPayroll Identifiernvarchar10
122PA0831HR master record for infotypes 083193PAYIDPayroll Identifiernvarchar10
123PA0834HR master record for infotypes 083431PAYIDPayroll Identifiernvarchar10
124T7COT3Payroll external results transfer: COSEV15PAYIDPayroll Identifiernvarchar10
125T7COT8Payroll external results transfer: COAVA42PAYIDPayroll Identifiernvarchar10
TOPPersonnel Management
126T7HR1RR-Sm ID5PAYIDPayroll Identifiernvarchar10
127T7HR1SR-Sm ID6PAYIDPayroll Identifiernvarchar10
128T7HRA0Datum uplate - Napomene - GOD obrazac5PAYIDIdentifikator obracuna placanvarchar10
129T7HRA3IP Form - Earnings9PAYIDPayroll Identifiernvarchar10
130T7HRA3NIP Form - Earnings - New (w. OIB)9PAYIDPayroll Identifiernvarchar10
131T7HRA3OIP Form - Earnings - with IDENT in key10PAYIDPayroll Identifiernvarchar10
TOPPersonnel Time Management
132PA2001HR Time Record: Infotype 2001 (Absences)73PAYIDPayroll Identifiernvarchar10
TOPRecruitment
133PB0009HR Master Record: Infotype 0009 (Bank Details)52PAYIDPayroll Identifiernvarchar10
TOPReuse Services for Country Development
134PA0262HR Master Record: Infotype 026230PAYIDPayroll Identifiernvarchar10
135T5JOCCPayroll Category for Payroll Reason2PAYIDPayroll Identifiernvarchar10
TOPUnited Kingdom
136T5G_DTONINational Insurance Data Take-on7PAYIDPayroll Identifiernvarchar10
TOPUSA
137PA044630PAYIDnvarchar10
138PA0447US Federal Tax MTD30PAYIDPayroll Identifiernvarchar10
139PA0448US Federal Tax QTD30PAYIDPayroll Identifiernvarchar10
140PA0449HR Master Record: Infotype 044930PAYIDPayroll Identifiernvarchar10
141PA0450HR Master Record: Infotype 045030PAYIDPayroll Identifiernvarchar10
142PA0451HR Master Record: Infotype 045130PAYIDPayroll Identifiernvarchar10
143PA0452HR Master Record: Infotype 045230PAYIDPayroll Identifiernvarchar10
144PA0453HR Master Record: Infotype 045330PAYIDPayroll Identifiernvarchar10
145PA0454HR Master Record: Infotype 045430PAYIDPayroll Identifiernvarchar10
146PA0455HR Master Record: Infotype 045530PAYIDPayroll Identifiernvarchar10
147PA0456HR Master Record: Infotype 045630PAYIDPayroll Identifiernvarchar10
148PA0457HR Master Record: Infotype 045730PAYIDPayroll Identifiernvarchar10
149PA0458HR Master Record for Infotype 045830PAYIDPayroll Identifiernvarchar10
150PA0459HR Master Record for Infotype 045930PAYIDPayroll Identifiernvarchar10
151PA0460HR Master Record for Infotype 046030PAYIDPayroll Identifiernvarchar10
152PA0909HR Master Record: Infotype 090932PAYIDPayroll Identifiernvarchar10