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

148 columns | Print definition?ERP 6.0  | ABKRS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000281000PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee19ABKRSnvarchar20
2/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee22ABKRSnvarchar20
3/GSINS/INH_CPHRRClaim Payee and HCM Person Relation7ABKRSPayroll Areanvarchar20
4/GSINS/INH_RIDHHCM-FSCD: List of HCM Posting runs to be processed6ABKRSPayroll Areanvarchar20
5CNVLTHCM_APLNOApplication Number Organisational data (Before Conversion)14ABKRSPayroll Areanvarchar20
6CNVLTHCM_PERNRPersonnel Number Organisational data (Before Conversion)14ABKRSPayroll Areanvarchar20
7HRBW_REC_DT_NEWPY-XX-RECON : Country specific reports detailed results32ABKRSPayroll Areanvarchar20
8HRDCT_TPY_RGDIRDeclustering - Directory for Test Payroll Results6ABKRSPayroll Areanvarchar20
9P01BN_STATStatus Table for Contribution Statements18ABKRSPayroll Areanvarchar20
10P01PF_REBUILDGarnishment Principle of Origin: Results of Rebuild17ABKRSPayroll Areanvarchar20
11P01PF_REB_HISTGarnishment Principle of Origin: Results of Rebuild History17ABKRSPayroll Areanvarchar20
12P08RTI_XMLDRTI4ABKRSPayroll Areanvarchar20
13P2CO_COAVAPC2CO_AVA5ABKRSPayroll Areanvarchar20
14P2RG_WEARNNI: payment history of affected wagetype7ABKRSPayroll Areanvarchar20
15P2RU_BALPayroll Results: Tax Retro Differences -(USA)15ABKRSPayroll Areanvarchar20
16P2RU_CLMOverpayments Processing structure13ABKRSPayroll Areanvarchar20
17P2RU_CLM_PERSONOverpayments Processing structure15ABKRSPayroll Areanvarchar20
18P2RU_DFRTPayroll Results: Retroaccounting Differences -DFRT- (USA)11ABKRSPayroll Areanvarchar20
19P2RU_UNBPayroll Results: Tax Retro Differences -(USA)15ABKRSPayroll Areanvarchar20
20P2RU_XDFRTPayroll Results: Tax Retro Differences -(USA)15ABKRSPayroll Areanvarchar20
21P2RX_EVAL_PERIODIndex for Payroll Results Periods10ABKRSPayroll Areanvarchar20
22P2RX_VERSCPayroll Status Information5ABKRSPayroll Areanvarchar20
23PA3340Infotype 334028ABKRSPayroll Areanvarchar20
24PA9220HR Master Record: Infotype 922026ABKRSPayroll Areanvarchar20
25PA9390Personal-Stammsatz Infotyp 939026ABKRSAbrechnungskreisnvarchar20
26PA9429Registro maestro de personal Infotipo 942926ABKRSÁrea de nóminanvarchar20
27PA9640Personal-Stammsatz Infotyp 964026ABKRSAbrechnungskreisnvarchar20
28PA9701Personal-Stammsatz Infotyp 970126ABKRSAbrechnungskreisnvarchar20
29PA9725HR Master Record: Infotype 972526ABKRSPayroll Areanvarchar20
30PA9741HR Master Record: Infotype 974126ABKRSPayroll Areanvarchar20
31PA9742HR Master Record: Infotype 974226ABKRSPayroll Areanvarchar20
32PA9825HR Master Record: Infotype 982526ABKRSPayroll Areanvarchar20
33PA9990HR Master Record: Infotype 999026ABKRSPayroll Areanvarchar20
34PA9991HR Master Record: Infotype 999126ABKRSPayroll Areanvarchar20
35PA9992HR Master Record: Infotype 999226ABKRSPayroll Areanvarchar20
36PA9993HR Master Record: Infotype 999326ABKRSPayroll Areanvarchar20
37PA9995HR Master Record: Infotype 999526ABKRSPayroll Areanvarchar20
38PA9996HR Master Record: Infotype 999626ABKRSPayroll Areanvarchar20
39PA9997HR Master Record: Infotype 999726ABKRSPayroll Areanvarchar20
40PA9998HR Master Record: Infotype 999826ABKRSPayroll Areanvarchar20
41PYC_D_EE_MDCKEmployee Master Data Change Key Information4ABKRSPayroll Areanvarchar20
42PYC_D_PY_MSGPYC: payroll message11ABKRSPayroll Areanvarchar20
43T350WMaintenance control parameters: Order type plant6ABKRSProcessing groupnvarchar20
44T5FPBST5Tranche de décompte / Code correspondant2ABKRSTranche de décomptenvarchar20
45T5G_RTIDCRTI Declaration Data4ABKRSPayroll Areanvarchar20
46T5REGEmployee Information Log for Destruction of Data16ABKRSPayroll Areanvarchar20
47T5RPDPersonnel Data Deletion Log26ABKRSPayroll Areanvarchar20
48T704OBatch Requests for Statements9ABKRSPayroll Areanvarchar20
49T77PAYKZBTBank Transfer Table Image (BTKZ)11ABKRSPayroll Areanvarchar20
50T7CNREW_APRPARSPayroll result master table8ABKRSPayroll Areanvarchar20
51T7CNREW_USRFPAUser favorate control record2ABKRSPayroll Areanvarchar20
52T7ROA8Contr. G - Deducted Amount3ABKRSPayroll Areanvarchar20
TOPArgentina
53T7AR20Date for final settlement of income for financial year2ABKRSPayroll Areanvarchar20
54T7AR28Assignment of SIJP periods to settled payrolls13ABKRSPayroll Areanvarchar20
TOPBelgium
55T5BVPDefinition of SI periods2ABKRSPayroll Areanvarchar20
TOPBenefit Integration
56PA0496Payroll Infotype: US Benefits Data - Per Pay Period26ABKRSPayroll Areanvarchar20
57PA0497Payroll Infotype: US Benefits Data - MTD26ABKRSPayroll Areanvarchar20
58PA0498Payroll Infotype: US Benefits Data - QTD26ABKRSPayroll Areanvarchar20
59PA0499Payroll Infotype: US Benefits Data - YTD26ABKRSPayroll Areanvarchar20
60PA0500Payroll Infotype: US Benefits Data in Arrears (ARRRS)26ABKRSPayroll Areanvarchar20
61PA0501Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK)26ABKRSPayroll Areanvarchar20
TOPChile
62T7CL16Period identifier2ABKRSPayroll Areanvarchar20
TOPChina
63HRPAYCN_GAWage Type Assignment (Golden Audit)2ABKRSPayroll Areanvarchar20
64T7CN3FReported Tax Data5ABKRSPayroll Areanvarchar20
TOPCross-Application Components
65AAUUFKOrder master data43ABKRSProcessing groupnvarchar20
TOPCross-Application Objects in HR
66HRP5581DB Table for Infotype 558131ABKRSPayroll Areanvarchar20
TOPDenmark
67T5M7DStatus Line for Payroll Run4ABKRSLower limit of payroll area intervalnvarchar20
68T5M7URetrieval of DA-DS Statistics2ABKRSLower limit of payroll area intervalnvarchar20
69T5M7WFile Entries Assignment from T5M7V4ABKRSPayroll Areanvarchar20
70T5M7XEntries for Form X1 - Special Payment Days2ABKRSLower limit of payroll area intervalnvarchar20
71T5M8SEmployer assignment in original period9ABKRSPayroll Areanvarchar20
72T5M8ZEmployer Assignment in Original Period12ABKRSPayroll Areanvarchar20
TOPFrance
73T5F67Interface: Link PAC Payroll Area1ABKRSPayroll Areanvarchar20
74T5F6FM-1 management of presence incidents (SAP/ADP interface)2ABKRSPayroll Areanvarchar20
75T5F6UInterface: Link PAC Processing Type1ABKRSPayroll Areanvarchar20
TOPGermany
76PD3DSAPHR-DDU: Administration Record for Notifications19ABKRSHR-DDU: Payroll Areanvarchar20
77T5D10Procedure for Expected Due Contributions2ABKRSPayroll Areanvarchar20
78T5D16Advanced Payment - Statement of Contributions Paid3ABKRSPayroll Areanvarchar20
TOPGreat Britain
79T5BUKTPersonnel numbers for AHP process model2ABKRSPayroll Areanvarchar20
80T5G51Payroll Area PAYE Reference2ABKRSPayroll Areanvarchar20
81T5G55HR-GB: Default Tax Code2ABKRSPayroll Areanvarchar20
82T5G56HR-GB: Offshore employer details2ABKRSPayroll Areanvarchar20
83T5GEF01HR-GB: filing - Store parsed recording coming in from GG15ABKRSPayroll Areanvarchar20
TOPItaly
84T5ITPOS_AHeader table for traceability7ABKRSPayroll Areanvarchar20
TOPJapan
85PA3239HR Master Record: Infotype 323926ABKRSPayroll Areanvarchar20
86T5J69HR Attributes to SYOYO payroll run JP2ABKRSPayroll Areanvarchar20
87T5JKGKijungai period setting per payroll area2ABKRSPayroll Areanvarchar20
TOPKorea
88T7KRTMTax calculation method2ABKRSPayroll Areanvarchar20
TOPMaintenance Processing
89/MRSS/C_PREMKDummy table for creating Org. Assgnmnt Search Help (No Data)6ABKRSPayroll Areanvarchar20
TOPOff-Cycle
90T52OCGOff-Cycle: Indicators for Batch: Payroll, Subsequent Program5ABKRSPayroll Areanvarchar20
91T52OCMPOff-Cycle Flag for Mass Processing7ABKRSPayroll Areanvarchar20
TOPOverhead Cost Orders
92AUFKOrder master data43ABKRSProcessing groupnvarchar20
93TKO08Processing groups for orders3ABKRSProcessing groupnvarchar20
94TKO09Allocation Group Descriptions4ABKRSProcessing groupnvarchar20
TOPPayroll
95T5H84Payroll log16ABKRSPayroll Areanvarchar20
96T5TA1External transfers9ABKRSPayroll Areanvarchar20
97T5TA2Medium for health insurance20ABKRSPayroll Areanvarchar20
98T7ROA6Contr. H - received/deducted amount from the authorities4ABKRSPayroll Areanvarchar20
99T7ROERHR Cluster 2 - ER Insurances7ABKRSPayroll Areanvarchar20
100T7SKA1External transfers9ABKRSPayroll Areanvarchar20
101T7TRP03Bordroda kullanilacak yabanci kurun gün belirleme tablosu2ABKRSBordro alt biriminvarchar20
TOPPayroll General Parts
102HRPY_RGDIRDirectory for Payroll Results4ABKRSPayroll Areanvarchar20
103HRPY_RGDIR_TEMPInternal TEMPORARY Directory for Payroll Results4ABKRSPayroll Areanvarchar20
104PYORGSCREENPNP900 Selection Screen: Fields for Organizational Selection7ABKRSPayroll Areanvarchar20
105T506SHR Loans: Value Date for Each Payroll Area2ABKRSPayroll Areanvarchar20
106T51G1Off-Cycle Batch Table3ABKRSPayroll Areanvarchar20
107T549AGAAssign Payroll Area Group to Payroll Areas3ABKRSPayroll Areanvarchar20
108T569ULogs for Control Records2ABKRSPayroll Areanvarchar20
109T569VControl Records2ABKRSPayroll Areanvarchar20
TOPPersonnel Administration
110PA0001HR Master Record: Infotype 0001 (Org. Assignment)32ABKRSPayroll Areanvarchar20
111PA0402HR Master Data Infotype 040226ABKRSPayroll Areanvarchar20
112PA0403HR Master Record for Infotype 040326ABKRSPayroll Areanvarchar20
113PA0832HR master record for infotypes 083224ABKRSPayroll area for authorized self-assessed valuesnvarchar20
114T549APayroll areas2ABKRSPayroll Areanvarchar20
115T549TPayroll areas3ABKRSPayroll Areanvarchar20
116T7COT8Payroll external results transfer: COAVA5ABKRSPayroll Areanvarchar20
TOPPersonnel Management
117T7HR1SR-Sm ID3ABKRSPayroll Areanvarchar20
TOPProcess Controls -Automated Controls
118GRPCRTA_HRDA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)15ABKRSPayroll Areanvarchar20
119GRPCRTA_HRDA0045PC HR control data for infotype 0045 - Loan15ABKRSPayroll Areanvarchar20
120GRPCRTA_HRDA0078PC HR control data for infotype 0078 - Loan Payments15ABKRSPayroll Areanvarchar20
121GRPCRTA_HRDA0267PC HR control data for infotype 026715ABKRSPayroll Areanvarchar20
122GRPCRTA_HRDAT1PC HR control data for infotype 0014 and 001515ABKRSPayroll Areanvarchar20
123GRPCRTA_HRDAT2PC HR control data for infotype 0014 and 001515ABKRSPayroll Areanvarchar20
TOPRecruitment
124PB0001HR Master Record: Infotype 0001 (Org. Assignment)32ABKRSPayroll Areanvarchar20
TOPReuse Services for Country Development
125PA0262HR Master Record: Infotype 026225ABKRSPayroll Areanvarchar20
TOPSimulation
126VSAUFK_CNVersion: Order master data44ABKRSProcessing groupnvarchar20
TOPTax Reporter
127T51T4Evaluated tax form reporting periods4ABKRSPayroll Areanvarchar20
128T51T6Evaluated payroll time units4ABKRSPayroll Areanvarchar20
129T51T9Tax pay dates4ABKRSPayroll Areanvarchar20
TOPTools
130HRPYO_D_CYCLCycles5ABKRSPayroll Areanvarchar20
131HRPYO_D_SCHDLSchedule6ABKRSPayroll Areanvarchar20
TOPUSA
132PA044626ABKRSnvarchar20
133PA0447US Federal Tax MTD26ABKRSPayroll Areanvarchar20
134PA0448US Federal Tax QTD26ABKRSPayroll Areanvarchar20
135PA0449HR Master Record: Infotype 044926ABKRSPayroll Areanvarchar20
136PA0450HR Master Record: Infotype 045026ABKRSPayroll Areanvarchar20
137PA0451HR Master Record: Infotype 045126ABKRSPayroll Areanvarchar20
138PA0452HR Master Record: Infotype 045226ABKRSPayroll Areanvarchar20
139PA0453HR Master Record: Infotype 045326ABKRSPayroll Areanvarchar20
140PA0454HR Master Record: Infotype 045426ABKRSPayroll Areanvarchar20
141PA0455HR Master Record: Infotype 045526ABKRSPayroll Areanvarchar20
142PA0456HR Master Record: Infotype 045626ABKRSPayroll Areanvarchar20
143PA0457HR Master Record: Infotype 045726ABKRSPayroll Areanvarchar20
144PA0458HR Master Record for Infotype 045826ABKRSPayroll Areanvarchar20
145PA0459HR Master Record for Infotype 045926ABKRSPayroll Areanvarchar20
146PA0460HR Master Record for Infotype 046026ABKRSPayroll Areanvarchar20
147T51G2Off-Cycle Batch Table3ABKRSPayroll Areanvarchar20
148T5UFFPersonnel area to ADP company code mapping (US ADP only)2ABKRSPayroll Areanvarchar20