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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

150 columns | Print definition?ERP 6.0  | ZEINH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)38ZEINHTime/Measurement Unitnvarchar30
2P2B2_ABWKONTIHCM Declustering B2 - Absence Quotas (Table ABWKONTI)18ZEINHTime/Measurement Unitnvarchar30
3P2B2_ALPHCM Declustering B2 - Alternative Payment Table ALP13ZEINHTime/Measurement Unitnvarchar30
4P2B2_ANWKONTIHCM Declustering B2 - Attendance Quotas (Table ANWKONTI)17ZEINHTime/Measurement Unitnvarchar30
5P2CN_CNREIPayroll result: structure for retro difference details20ZEINHTime/Measurement Unitnvarchar30
6P2CN_CNREOPayroll result: structure for retro difference details20ZEINHTime/Measurement Unitnvarchar30
7P2CO_COAVAPC2CO_AVA34ZEINHTime/Measurement Unitnvarchar30
8P2HK_RETIPayroll structure for retroactive accounting22ZEINHTime/Measurement Unitnvarchar30
9P2HK_RETOPayroll structure for retroactive accounting22ZEINHTime/Measurement Unitnvarchar30
10P2HR_CUFStructure of difference table Croatia7ZEINHTime/Measurement Unitnvarchar30
11P2HR_CUPStructure of difference table Croatia7ZEINHTime/Measurement Unitnvarchar30
12P2HR_DTFStructure of difference table Croatia7ZEINHTime/Measurement Unitnvarchar30
13P2HR_DTPStructure of difference table Croatia7ZEINHTime/Measurement Unitnvarchar30
14P2IS_RETIPayroll structure for retroactive accounting22ZEINHTime/Measurement Unitnvarchar30
15P2IS_RETOPayroll structure for retroactive accounting22ZEINHTime/Measurement Unitnvarchar30
16P2MX_GRORDMaintenance payment order16ZEINHPayroll Time Unitsnvarchar20
17P2NZ_SALSACSalary Sacrifice Details19ZEINHTime/Measurement Unitnvarchar30
18P2RA_DFRTPayroll Result for Other Payroll Periods20ZEINHTime/Measurement Unitnvarchar30
19P2RB_I0125Garnishment payroll Belgium21ZEINHTime/Measurement Unitnvarchar30
20P2RD_XITPayroll Results: Extended IT15ZEINHTime/Measurement Unitnvarchar30
21P2RD_ZTBAUPayroll Result: Construction Pay Daily Statement10ZEINHTime/Measurement Unitnvarchar30
22P2RG_COURTTypes of Court Order (GB)36ZEINHTime/Measurement Unitnvarchar30
23P2RH_HU_HKIFP21PB17ZEINHTime/Measurement Unitnvarchar30
24P2RH_HU_MEMBP21MB14ZEINHTime/Measurement Unitnvarchar30
25P2RH_HU_NRENP21PA14ZEINHTime/Measurement Unitnvarchar30
26P2RI_IPCUMRI cluster structure for cumulations (IPCUM)17ZEINHTime/Measurement Unitnvarchar30
27P2RI_ITIOTRI cluster structure for retroactive accounting19ZEINHTime/Measurement Unitnvarchar30
28P2RK_GRORDPayroll results Canada: Garnishment order17ZEINHPayroll time unitsnvarchar20
29P2RN_NSR0Payroll Results: Special Provisions (NL)11ZEINHTime/Measurement Unitnvarchar30
30P2RP_SCRTHR-PT: Cumulated result table (Legal entity dependent)11ZEINHTime/Measurement Unitnvarchar30
31P2RQ_HTPayroll Results: Results Table17ZEINHTime/Measurement Unitnvarchar30
32P2RQ_NTPayroll Results: Results Table17ZEINHTime/Measurement Unitnvarchar30
33P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)17ZEINHTime/Measurement Unitnvarchar30
34P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)17ZEINHTime/Measurement Unitnvarchar30
35P2RR_RMPayroll Results: Table for Master data (SG)23ZEINHTime/Measurement Unitnvarchar30
36P2RR_SRTPayroll Results: Results Table17ZEINHTime/Measurement Unitnvarchar30
37P2RU_GRDOCPayroll Results: Garnishment for US Document23ZEINHPayroll time unitsnvarchar20
38P2RX_ALPAlternative Payment Table ALP11ZEINHTime/Measurement Unitnvarchar30
39P2RX_DFTPayroll Results: Differences for Gross/Net Payroll8ZEINHTime/Measurement Unitnvarchar30
40P2RX_GRTPayroll Results: Results Table17ZEINHTime/Measurement Unitnvarchar30
41P2RX_RTPayroll Results: Results Table17ZEINHTime/Measurement Unitnvarchar30
42P2RX_RT_PERSONResults Table (Person)21ZEINHTime/Measurement Unitnvarchar30
43P2SI_CUFDifference table of payroll results7ZEINHTime/Measurement Unitnvarchar30
44P2SI_CUPDifference table of payroll results7ZEINHTime/Measurement Unitnvarchar30
45P2SI_DTFDifference table of payroll results7ZEINHTime/Measurement Unitnvarchar30
46P2SI_DTPDifference table of payroll results7ZEINHTime/Measurement Unitnvarchar30
47P2TN_TWOTPayroll Results: Results Table17ZEINHTime/Measurement Unitnvarchar30
48P2UA_UARFStructure for Ukrainian social insurance(PF) calculation20ZEINHTime/Measurement Unitnvarchar30
49P2UA_UARTPayroll Results: Results Table17ZEINHTime/Measurement Unitnvarchar30
50P2UA_UATIStructure for Ukrainian social insurance(PF) calculation21ZEINHTime/Measurement Unitnvarchar30
51P2UA_UATRStructure for Ukrainian social insurance(PF) calculation21ZEINHTime/Measurement Unitnvarchar30
52P2UA_UATSStructure for Ukrainian social insurance(PF) calculation21ZEINHTime/Measurement Unitnvarchar30
53P2UN_HTPayroll Results: Results Table17ZEINHTime/Measurement Unitnvarchar30
54P2UN_NTPayroll Results: Results Table17ZEINHTime/Measurement Unitnvarchar30
55P2UR_RURTPayroll Results: Results Table17ZEINHTime/Measurement Unitnvarchar30
56PA0297HR Master Record: Infotype 0297 Work conditions32ZEINHTime/Measurement Unitnvarchar30
57PA3364HR Master Record: Infotype 336429ZEINHTime/Measurement Unitnvarchar30
58T538BUnits of Time/Measurement4ZEINHTime/Measurement Unitnvarchar30
59T538CPermissibility of Time/Measurement Units for Infotypes3ZEINHTime/Measurement Unitnvarchar30
60T538ZPermissibility of Time/Measurement Units for Infotypes3ZEINHTime/Measurement Unitnvarchar30
61T5D1TSI Assessment Threshold9ZEINHTime/Measurement Unitnvarchar30
62T5M3UBank Transfer Types (Denmark)2ZEINHPayroll time unitsnvarchar20
63T5UPBSPOOLSick Leave Pool4ZEINHTime/Measurement Unitnvarchar30
64T5UPBSPOOLASick Leave Pool Attributes11ZEINHTime/Measurement Unitnvarchar30
65T7RU53PStatus for time accounting for PSG5ZEINHTime/Measurement Unitnvarchar30
TOPAustralia
66PA0701HR Terminations Data Container : Infotype 070170ZEINHTime/Measurement Unitnvarchar30
67T5QRSTerminations Redundancy Payments Australia12ZEINHTime/Measurement Unitnvarchar30
TOPAustria
68HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results18ZEINHTime/Measurement Unitnvarchar30
TOPBelgium
69PA0125HR Master Record: Infotype 0125 (Garnishment B)27ZEINHTime/Measurement Unitnvarchar30
TOPBrazil
70T7BRQTAbsence quota type9ZEINHUnit of measure/timenvarchar30
TOPCanada
71PA0067HR master data infotype 0067 - Canadian garnishment: debt44ZEINHPayroll time unitsnvarchar20
TOPChile
72T7CL17Tax Brackets2ZEINHPayroll time unitsnvarchar20
TOPCompany Pension Scheme Germany
73P01CSOSpecial Information10ZEINHTime/measurement unitnvarchar30
74P01CVDActuarial CPS Data37ZEINHTime unit for determining next paymentnvarchar30
75PA0202HR Master Record Infotype 0202 (Entitlements)34ZEINHTime/measurement unitnvarchar30
76T5DCAEntitlements / Benefit Types31ZEINHTime/measurement unitnvarchar30
TOPCompensation Management
77T50X1Type of Expatriate7ZEINHTime/Measurement Unitnvarchar30
TOPConfirmations
78AFRVConfirmation pool57ZEINH3-Byte fieldnvarchar30
79AFRV_DELBackup Copy for Confirmation Pool57ZEINH3-Byte fieldnvarchar30
TOPConstruction Industry
80PA0215Construction Pay Transaction Data32ZEINHTime/Measurement Unitnvarchar30
TOPGermany
81P01Y15PAISY: Management Table Subrecord Type 1520ZEINHTime/Measurement Unitnvarchar30
TOPGreat Britain
82PA0070HR Master Record: Infotype 0070 (Court Orders - GB)51ZEINHTime/Measurement Unitnvarchar30
TOPIndia
83T77WWW_INFAPAdditional Payments Configuration9ZEINHTime/Measurement Unitnvarchar30
TOPIndonesia
84T7ID2LTax Constant Amounts (Indonesia)4ZEINHPayroll time unitsnvarchar20
TOPIreland
85PA0386HR Master Record: Infotype 0386 (VHI Scheme)27ZEINHTime/Measurement Unitnvarchar30
TOPMaster Data
86RSDBIndex of the RESB for the Direct Procurement Element14ZEINHUnit for the time interval between relationshipsnvarchar30
TOPNetherlands
87PA0317HR Master Record: Infotype 0317 (Special Provisions)28ZEINHTime/Measurement Unitnvarchar30
TOPNetwork and Activity
88AFABNetwork - Relationships9ZEINHUnit for the time interval between relationshipsnvarchar30
89PLABRelationships15ZEINHUnit for the time interval between relationshipsnvarchar30
TOPOff-Cycle
90T52OCAPPayroll in Advance - Default Values for Number of Periods3ZEINHPayroll time unitsnvarchar20
TOPPayroll
91PA3234HR master record, infotype 323429ZEINHTime/Measurement Unitnvarchar30
92PA3261Commission contracts H34ZEINHTime/Measurement Unitnvarchar30
93T5HPBS_T538C_DAYComm. - number of days for IT3261 time units2ZEINHTime/Measurement Unitnvarchar30
94T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000931ZEINHCasová/merná jednotkanvarchar30
95T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001132ZEINHCasová/merná jednotkanvarchar30
TOPPayroll General Parts
96PA0267HR Master Record: Infotype 0267 (One time Payment off-cycle)29ZEINHTime/Measurement Unitnvarchar30
97PA0477Personnel Master Record Infotype 0477: Debt (Garnishments)50ZEINHPayroll Time Unitnvarchar20
98T510HPayroll Parameters for Time Unit4ZEINHPayroll time unitsnvarchar20
99T512KText for Payroll Constants Regarding Time Units5ZEINHPayroll time unitsnvarchar20
100T549PValid Time Units for Payroll2ZEINHPayroll time unitsnvarchar20
101T54C2Calendar Type3ZEINHPayroll time unitsnvarchar20
102T54C4Valid Calendar Types3ZEINHPayroll time unitsnvarchar20
103T558DTransfer Wage Types with Split Indicator16ZEINHTime/Measurement Unitnvarchar30
104T56C1Parameter for Cumulation Types3ZEINHPayroll time unitsnvarchar20
TOPPersonnel Administration
105PA0009HR Master Record: Infotype 0009 (Bank Details)28ZEINHTime/Measurement Unitnvarchar30
106PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)29ZEINHTime/Measurement Unitnvarchar30
107PA0014HR Master Record: Infotype 0014 (Recur. Payments/Deds.)29ZEINHTime/Measurement Unitnvarchar30
108PA0015HR Master Record: Infotype 0015 (Additional Payments)29ZEINHTime/Measurement Unitnvarchar30
109PA0040HR Master Record: Infotype 0040 (Objects on Loan)26ZEINHTime/Measurement Unitnvarchar30
110PA0057HR Master Record: Infotype 0057 (Membership Fees)31ZEINHTime/Measurement Unitnvarchar30
111PA0441Corrections for reports (Hungary)27ZEINHTime/Measurement Unitnvarchar30
112PA0657HR Master Record: Infotype 065739ZEINHTime/Measurement Unitnvarchar30
113T510FAssign Pay Scale --> Currency8ZEINHNot usednvarchar20
114T511Wage Types9ZEINHTime/Measurement Unitnvarchar30
115T531Deadline Types4ZEINHTime/Measurement Unitnvarchar30
116T538AHR Time/Measurement Units2ZEINHTime/Measurement Unitnvarchar30
117T538DUnits of Time/Measurement4ZEINHTime/Measurement Unitnvarchar30
118T538TUnits of Time/Measurement Texts3ZEINHTime/Measurement Unitnvarchar30
119T549RPeriod Parameters3ZEINHPayroll time unitsnvarchar20
120T7COT8Payroll external results transfer: COAVA34ZEINHTime/Measurement Unitnvarchar30
TOPPersonnel Management
121/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs21ZEINHTime/Measurement Unitnvarchar30
TOPPersonnel Time Management
122PA2010HR Time Record: Infotype 2010 (Employee Remuneration Info.)30ZEINHTime/Measurement Unitnvarchar30
123PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)31ZEINHTime/Measurement Unitnvarchar30
124T554WPeriods of Military Service8ZEINHTime/Measurement Unitnvarchar30
125T555W[OBSOLETE; NOW USE T705K] Ext. Wages Types from Subsystem10ZEINHTime/Measurement Unitnvarchar30
126T556AAbsence Quota Types7ZEINHTime/Measurement Unitnvarchar30
127T556PAttendance Quotas7ZEINHTime/Measurement Unitnvarchar30
128T556RRules for Deduction Sequence for Absence Quotas8ZEINHTime/Measurement Unitnvarchar30
129T557MTime Types Relationships Table (from Period Totals Table)6ZEINHTime/Measurement Unitnvarchar30
130T705KExternal Wage Types for Subsystem10ZEINHTime/Measurement Unitnvarchar30
131TEVENTime Events12ZEINHTime/Measurement Unitnvarchar30
132TEXLGAEmployee Expenditures11ZEINHTime/Measurement Unitnvarchar30
TOPPhilippines
133T7PHTATax installment amounts per salary bracket3ZEINHPayroll time unitsnvarchar20
134T7PHTWPeriod Tax Withheld2ZEINHPayroll time unitsnvarchar20
TOPPlant Data Collection
135RUECKTemp. storage for subsystem confirmations52ZEINHTime/Measurement Unitnvarchar30
TOPProcess Controls -Automated Controls
136GRPCRTA_HRDA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)27ZEINHTime/Measurement Unitnvarchar30
137GRPCRTA_HRDA0267PC HR control data for infotype 026727ZEINHTime/Measurement Unitnvarchar30
138GRPCRTA_HRDAT1PC HR control data for infotype 0014 and 001527ZEINHTime/Measurement Unitnvarchar30
TOPRecruitment
139PB0009HR Master Record: Infotype 0009 (Bank Details)28ZEINHTime/Measurement Unitnvarchar30
140PB0014Applicant Master Record IT 0014 Recurring Pymnts/Deductions29ZEINHTime/Measurement Unitnvarchar30
141PB0015Applicant Master Record Infotype 0015 (Additional Payments)29ZEINHTime/Measurement Unitnvarchar30
TOPRouting
142PLMZAllocation of bill of material items to operations40ZEINHUnit for the time interval between relationshipsnvarchar30
TOPSimulation
143VSAFAB_CNVersion: Network relationships10ZEINHUnit for the time interval between relationshipsnvarchar30
144VSRSDB_CNVersion: Index of RESB for direct procurement elements15ZEINHUnit for the time interval between relationshipsnvarchar30
TOPSouth Africa
145PA0151HR Master Record Infotype 0151 (Ext.Insurance South Africa)31ZEINHTime/Measurement Unitnvarchar30
146T5W1NSocial insurance schemes15ZEINHPayroll frequency. Used for medical aid tablesnvarchar20
TOPSwitzerland
147PA0120HR Master Record: Infotype 0120 (Pension Fund Trans. CH)29ZEINHTime/Measurement Unitnvarchar30
TOPTools
148PA0579HR Master Record Infotype 0579 (Ext. Wage Components)33ZEINHTime/Measurement Unitnvarchar30
149T532BHR: Connection to Third-Party Payroll: Choice of Wage Types18ZEINHComponent 709: Entry field for field selection in PC207nvarchar10
TOPWarehouse Management
150T328Warehouse Activity Monitor: Defin. of Critical Parameters8ZEINHWarehouse activity monitor: Time unit for critical durationnvarchar30