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

161 columns | Print definition?ERP 6.0  | PERID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRP1789DB Table for Infotype 178919PERIDAcademic Sessionnvarchar30
2HRP1798DB Table for Infotype 179819PERIDAcademic Sessionnvarchar30
3P2RB_PERMPersonal Features11PERIDPersonnel ID Numbernvarchar200
4P2RB_SVSocial Insurance payroll Belgium16PERIDPersonnel ID Numbernvarchar200
5P2RD_PERMPayroll Results: Personal Features11PERIDPersonnel ID Numbernvarchar200
6P2RK_PERMPersonal Characteristics6PERIDPersonnel ID Numbernvarchar200
7P2RM_MTAXPayroll Result: Tax (DK)9PERIDPersonnel ID Numbernvarchar200
8P2RU_PERMPersonal Characteristics7PERIDPersonnel ID Numbernvarchar200
9PAPBSGB_SWF_STAFSWF: Staff Details14PERIDPersonnel ID Numbernvarchar200
10PIQDB_DE_STATHDRHeader Table for Statistical Reporting Germany9PERIDAcademic Sessionnvarchar30
11T7PIQ_DE_MTPERIDMapping table for Academic Periods2PERIDAcademic Sessionnvarchar30
12T868Elimination of IC profit and loss5PERIDPeriodnvarchar30
13TSTGCConsolidation test data6PERIDPeriodnvarchar30
14HRP1707Database Table for Infotype 170723PERIDNote Reference to an Academic Sessionnvarchar30
15HRP1739DB Table for Infotype 173919PERIDAcademic Sessionnvarchar30
16HRP1771DB Table for Infotype 177119PERIDAcademic Sessionnvarchar30
17HRP1772DB Table for Infotype 177254PERIDAcademic Sessionnvarchar30
18HRPAD503Additional Data for PAD5034PERIDAcademic Sessionnvarchar30
19HRPAD506Additional Data for PAD50617PERIDAcademic Sessionnvarchar30
20HRPAD512Additional Data for PAD5124PERIDAcademic Sessionnvarchar30
21HRPAD532Additional Data for PAD50813PERIDAcademic Sessionnvarchar30
22HRPAD547Additional Data PAD5476PERIDAcademic Sessionnvarchar30
23HRT1737Table Section for Infotype 173717PERIDAcademic Session for Progression Resultnvarchar30
24HRT1750Table Section for Infotype 17506PERIDAcademic Sessionnvarchar30
25HRT1764Table Section for Infotype 176411PERIDAcademic Sessionnvarchar30
26HRT1773Table Section for Infotype 177332PERIDAcademic Sessionnvarchar30
27PIQDBCMPRRECORDSAssessment Process9PERIDAssessment Sessionnvarchar30
28PIQDBEVOBOFFERScheduled Assessment6PERIDAcademic Sessionnvarchar30
29PIQDBEVOBOFFER2Scheduled Assessment: Functions6PERIDAcademic Sessionnvarchar30
30PIQDBEVOBOFFER3Scheduled Assessment: Location/Time6PERIDAcademic Sessionnvarchar30
31PIQDBLMSLPIDLearning Product UUID - LMS5PERIDAcademic Sessionnvarchar30
32PIQDBOFFERMP1Templates Copied for Academic Period4PERIDAcademic Sessionnvarchar30
33PIQDBOFFERMP2Business Events Copied for Academic Period5PERIDAcademic Sessionnvarchar30
34PIQPROC_ED_INT_WED Activity Document: Transferred Internal Academic Work19PERIDAssigned Academic Session of Internal Academic Work/Qualif.nvarchar30
35PIQPROC_PG_DTActivity Document: Progression Details18PERIDAcademic Session for Progression Resultnvarchar30
36PIQPROC_PG_MBActivity Document: Module Booking10PERIDAcademic Sessionnvarchar30
37T7PIQOFFERPATDEFSession Pattern Definition3PERIDAcademic Sessionnvarchar30
38T7PIQPERASSIGNAcademic Session/Group Assignments3PERIDAcademic Sessionnvarchar30
39T7PIQPERIODAcademic Sessions2PERIDAcademic Sessionnvarchar30
40T7PIQPERIODTAcademic Sessions (Text Table)3PERIDAcademic Sessionnvarchar30
41T7PIQSTDYEARPRDStandard Academic Year/Session Assignments3PERIDAcademic Sessionnvarchar30
42T7PIQYEARPRDAcademic Year/Session Assignments3PERIDAcademic Sessionnvarchar30
43T7PIQ_NL_ENRNMMapping Table for Year/ Session and Enrollment Moment Code3PERIDAcademic Sessionnvarchar30
44T7PIQ_US_PTINDXCustomizing to map Program Full time and Performance Index6PERIDAcademic Sessionnvarchar30
45TCMACGRHDGrants Document Header4PERIDAcademic Sessionnvarchar30
46TCMACGRITGrants Document Items5PERIDAcademic Sessionnvarchar30
47TCMACSUBTYPERIDCO-Integration: Map Acad. Session to Subtype of infty 17592PERIDAcademic Sessionnvarchar30
TOPBasic Data
48TN01ZIS-H: Table for Period Input Help3PERIDIS-H: Period for Time Interval Input Helpnvarchar80
TOPBasic Functions
49T850DAssignment of business segment4PERIDPeriodnvarchar30
50T850STax rates4PERIDPeriodnvarchar30
51T851Changes in Investments7PERIDPeriodnvarchar30
52T852PConsolidation Periods3PERID"To" period for the period intervalnvarchar30
53T852USubgroup companies6PERIDPeriodnvarchar30
54T853Company status6PERIDPeriodnvarchar30
55T853KSubgroup status6PERIDPeriodnvarchar30
56T864Reclassifications3PERIDPeriodnvarchar30
57T865Intercompany Elimination3PERIDPeriodnvarchar30
58T868BElimination of IC profit/loss: Inventory management co.s4PERIDPeriodnvarchar30
59T869Consolidation methods6PERIDGoodwill amortization: Duration in monthsnvarchar30
60T871Changes in investee equity6PERIDPeriodnvarchar30
61T872Equity Holdings Adjustments7PERIDPeriodnvarchar30
62T873Hidden reserves6PERIDPeriodnvarchar30
63T875Asset transfers within the group9PERIDPeriodnvarchar30
64T875CChanges in depreciation6PERIDPeriodnvarchar30
65T875DAsset transfers33PERIDPeriod of asset transfernvarchar30
66T875EChange in depreciation of asset transfers7PERIDPeriodnvarchar30
TOPBelgium
67PA0735HR Master Record: Infotype 0735 (Dimona B)47PERIDDimona Period ID (00913)nvarchar120
68T5BDI0HR-BE: Dimona Central Table4PERIDDimona Period ID (00913)nvarchar120
TOPBenefits
69T74ABCOBRA dependent of qualified beneficiary11PERIDPersonnel ID Numbernvarchar200
TOPCollectionsDisbursements
70TVS010HIS-IS Scheduling: Percentage Distribution in Paymt Plan3PERIDPeriod identificationnvarchar30
TOPConsolidation
71TF080List Directory of MCDX7PERIDPeriodnvarchar30
72TF154Dimensions year- and period-dependent4PERIDEffective from periodnvarchar30
73TF155Dimensions: Assign Task Groups5PERIDEffective from periodnvarchar30
74TF163Consolidation Units, Version/Period-Based Attributes6PERIDEffective from periodnvarchar30
75TF167Consolidation Units Version- and Period-Dependent6PERIDEffective from periodnvarchar30
76TF169Version/Period-Dependent Cons. Units: Tax Rates6PERIDEffective from periodnvarchar30
77TF183AConsolidation Groups - Restricted Task Groups5PERIDEffective from periodnvarchar30
78TF187Consolidation Group Set Assignments6PERIDPeriodnvarchar30
79TF188Consolidation Group Assignment of Task Group6PERIDEffective from periodnvarchar30
80TF189Assignment of CG/CU, Version- and Period-Dependent7PERIDEffective from periodnvarchar30
81TF192Hierarchies, Period-Dependent5PERIDEffective from periodnvarchar30
82TF242Consolidation Periods3PERIDTo periodnvarchar30
83TF250Periods, Opened/Closed6PERIDPeriodnvarchar30
84TF260Overall Status of CG/CU - Data Monitor6PERIDPeriodnvarchar30
85TF261CG/CU: Detail Status of Tasks - Data Monitor6PERIDPeriodnvarchar30
86TF262History of Data Entry Layouts5PERIDPeriodnvarchar30
87TF270CG/CU Overall Status of Consolidation Monitor6PERIDPeriodnvarchar30
88TF271CG/CU: Detail Status of Tasks - Consolidation Monitor6PERIDPeriodnvarchar30
89TF280User-Defined Tasks5PERIDEffective from periodnvarchar30
90TF362Download: Selection Parameters for Downloading Fin. Data9PERIDPeriodnvarchar30
91TF425Exchange Rate Indicators: ER Type Assignments5PERIDEffective from periodnvarchar30
92TF543Consolidation Tasks: Assignments of Methods and Doc.Types6PERIDEffective from periodnvarchar30
93TF544Tasks: Task Group Exceptions7PERIDEffective from periodnvarchar30
94TF545Consolidation Tasks: Exceptions for Cons Units7PERIDEffective from periodnvarchar30
95TF562Assignment of Method/Doc. Type to Task in Reclassification6PERIDEffective from periodnvarchar30
96TF570Tasks for Manual Posting - Document Type Assignments6PERIDEffective from periodnvarchar30
97TF575Tasks for CG Changes: Document Type Assignments6PERIDEffective from periodnvarchar30
98TF585Inventory Data6PERIDPeriodnvarchar30
99TF586Supplier Data5PERIDEffective from periodnvarchar30
100TF595Elimination of IU Profit/Loss in Inventory: Tasks6PERIDEffective from periodnvarchar30
101TF599Global Settings for Elim. of IU P/L in Inventory4PERIDEffective from periodnvarchar30
102TF615C/I Tasks: Assignment of Document Types6PERIDEffective from periodnvarchar30
103TF616C/I Activities/Acctg Techniques: Document Type Assignments7PERIDEffective from periodnvarchar30
104TF620Changes in Investments8PERIDPeriodnvarchar30
105TF625Group Shares9PERIDEffective from periodnvarchar30
106TF630Changes in Investee Equity8PERIDPeriodnvarchar30
107TF643Fair Value Adjustments: Version/Date-Sensitive8PERIDEffective from periodnvarchar30
108TF645Reporting Fair Value Adjustment Data8PERIDPeriodnvarchar30
109TF650C/I Activity Numbers8PERIDPeriodnvarchar30
110TF651Activity Numbers - Sequence8PERIDPeriodnvarchar30
111TF652Activity Numbers - Sequence - Sort Status7PERIDPeriodnvarchar30
112TF660Equity Holdings Adjustments8PERIDPeriodnvarchar30
113TF661Equity Holdings Adjustments by Upper Unit8PERIDPeriodnvarchar30
114TFMIG10Migration: Processing Options7PERIDPeriodnvarchar30
TOPFinland
115T7FILISTable for Low Income Support Statement6PERIDHR_FI: Finnish person IDnvarchar110
116T7FITELMETEL messages5PERIDSocial insurance numbernvarchar110
TOPGermany
117PA0521HR Master Record: Infotype 0521 (Semiretirement D)38PERIDPersonnel ID Numbernvarchar200
TOPItaly
118T5ITBSBonus Straordinario14PERIDRiferimento danvarchar60
TOPNorway
119PA0173Tax card information41PERIDeTaxCard - Personnel ID Numbernvarchar110
TOPPayroll
120T5TA1External transfers6PERIDPersonnel ID Numbernvarchar200
121T5TELDP2004TRANSRecords ELDP for transfer from external system to SAP24PERIDPersonnel ID Numbernvarchar200
122T5TREGTRANSHRCZ - table for transfer items of Insured Register to SAP18PERIDPersonnel ID Numbernvarchar200
123T7ROG2EE register - EE history15PERIDPersonnel ID Numbernvarchar200
124T7ROG6EE register - EE history17PERIDPersonnel ID Numbernvarchar200
125T7SIA3M4 - Temporary data5PERIDPersonnel ID Numbernvarchar200
126T7SKA1External transfers6PERIDPersonnel ID Numbernvarchar200
TOPPayroll General Parts
127T51G1Off-Cycle Batch Table13PERIDPayroll periodnvarchar60
TOPPersonnel Administration
128PA0002HR Master Record: Infotype 0002 (Personal Data)54PERIDPersonnel ID Numbernvarchar200
129PA0152Infotype 0152 - Tax data CZ44PERIDPersonal ID numbernvarchar200
130PA0153Infotype 0153 - SI CZ69PERIDPersonal ID numbernvarchar200
131T7PL91Seniority codes relevance to technical dates5PERIDPeriod identifiernvarchar10
132T7PL92Infotype record influence to seniority7PERIDPeriod identifiernvarchar10
TOPPortfolio Management
133RPM_FIDATAFinancial Information11PERIDPeriodnvarchar30
134RPM_PROJECT_COControlling Information about a project10PERIDPeriodnvarchar30
135RPM_SCENARIO_FINRPM : Scenario financial data8PERIDPeriodnvarchar30
TOPPublic sector Sweden
136T5SA0_CEAlecta8PERIDPersonnel ID Numbernvarchar200
137T5SK0_CEKPA events11PERIDPersonnel ID Numbernvarchar200
138T5SP0_CEPA91 periods4PERIDPersonnel ID Numbernvarchar200
139T5SP1_CEPA91 absence4PERIDPersonnel ID Numbernvarchar200
140T5SP2_CEPA91 income4PERIDPersonnel ID Numbernvarchar200
141T5SS0_CEPA03 periods5PERIDPersonnel ID Numbernvarchar200
142T5SS1_CEPA03 absences5PERIDPersonnel ID Numbernvarchar200
143T5SS2_CEPA03 income5PERIDPersonnel ID Numbernvarchar200
TOPRecruitment
144PB0002HR Master Record: Infotype 0002 (Personal Data)54PERIDPersonnel ID Numbernvarchar200
TOPRecycling Administration Core Functions
145J_7LV1KREA Document: Header Data51PERIDREA Declaration Periodicitynvarchar10
TOPSingapore
146PA0412HR Master Record: Infotype 0412 [View to I0021] (SG)42PERIDPersonnel ID Numbernvarchar200
TOPSouth Africa
147T5WITA88ITA88 Transaction Table12PERIDPersonnel ID Numbernvarchar200
TOPSpain
148T5EL1Protected data access log6PERIDPersonnel ID Numbernvarchar200
149T5EL5Protected data access log5PERIDPersonnel ID Numbernvarchar200
150T5EL7Log for accessing protected data for XML files3PERIDPersonnel ID Numbernvarchar200
TOPSweden
151T5S0SMessages for sickness administration (SE)9PERIDPersonnel ID Numbernvarchar200
152T5SPPHR-SE: Information needed to be reported to Alecta13PERIDPersonnel ID Numbernvarchar200
TOPTraining and Event Management
153HRT1060Table Division for Infotype 10604PERIDPeriod for Training and Event Planningnvarchar30
TOPUnited Kingdom
154PAGB_ASHEASHE Return Data11PERIDPersonnel ID Numbernvarchar200
TOPUSA
155PA0106HR Master Record: Infotype 0106 (Related Persons NA)25PERIDPersonnel ID Numbernvarchar200
156T51G2Off-Cycle Batch Table7PERIDPayroll periodnvarchar60
TOPWorkbench Utilities
157FLAPPInternal flight applications2PERIDPersonnel numbernvarchar100
158FLEMPEmployees1PERIDPersonnel numbernvarchar100
159FLPASPassenger list2PERIDPersonnel numbernvarchar100
TOPWorkforce Management Application
160WFAEM_START_DATEStart date of the employee6PERIDPersonnel ID Numbernvarchar200
TOPWorkforce Management Core
161WFMEM_START_DATEStart date of the employee6PERIDPersonnel ID Numbernvarchar200