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

30 columns | Print definition?ERP 6.0  | PRZNT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RQ_SUPCOMSuperable salary components26PRZNTPercentage of increase for wage typedecimal72
2P2UN_SUPCOMSuperable salary components For NPO26PRZNTPercentage of increase for wage typedecimal72
3T5C1QHR-CH: Company department short-time work6PRZNTPercentagedecimal52
4T5DA7Dynamic Modification of Value Credit6PRZNTPercentagedecimal85
5T7QAPBS12Periodic Increment Evaluation by Appraisal Result8PRZNTPercentage for Periodic Pay Increasedecimal72
TOPCompany Pension Scheme Germany
6T5DC1Constants for Company Pension Scheme10PRZNTPercentage Rate for Constantsdecimal52
7T5DWDDeductions/Payments for Reimbursements7PRZNTFixed Percentage Ratedecimal52
TOPCompensation Management
8T510DDynamic Standard Pay Increase12PRZNTPercentage increase for wage typedecimal72
TOPConstruction Industry
9T5DBPData for Year-End Bonus (Construction Industry)12PRZNTPercentage Share for Year-End Bonusdecimal52
TOPCross-Application Components
10PLLPOTask list - operation/activity122PRZNTWork percentagetinyint30
TOPMaster Data Distribution
11/ISDFPS/TL1Task List - Operation/Activity122PRZNTWork percentagetinyint30
TOPNetwork and Activity
12AFABNetwork - Relationships16PRZNT% used to calc. time interval between predecessor/successornvarchar30
13PLABRelationships22PRZNT% used to calc. time interval between predecessor/successornvarchar30
TOPPayroll
14PA0776Personel ana verileri: Bilgi tipi 077626PRZNTYüzde.decimal52
15T7TRG02Nema Orani5PRZNTNema Oranidecimal74
16T7TRK03Wage and pay increase for higher duty7PRZNTPercentdecimal63
17T7TRS12SGK Uygulamalarý Ýstihtam Tesvik Oranlarý8PRZNTPercentdecimal52
18T7TRT01Vergi Dilimleri9PRZNTYüzde.decimal52
19T7TRT06Private Insurance Procents5PRZNTPercentdecimal52
20T7TRT08ÖGI (KDV Iadesi) Miktar ve Yüzdeleri8PRZNTYüzde.decimal52
TOPPension Administration
21T7PBS00TRF_DATPayscale Group-Dependent Data10PRZNTPercentage or Factordecimal74
22T7PBS00TRF_DATESPayscale Group-Dependent Data10PRZNTPercentage or Factordecimal74
TOPProduction Orders
23AFVCOperation within an order68PRZNTWork percentagetinyint30
TOPPublic Sector
24T5QPBS1ENational Wage Case (NWC) increase for Superannuation11PRZNTPercentage of increase for wage typedecimal72
TOPRemaining Beverage - Obsolete Objects
25/BEV3/CHRGPRZNTPercent Rule11PRZNTPercentagedecimal73
TOPRouting
26PLPOTask list - operation/activity122PRZNTWork percentagetinyint30
TOPSimulation
27VSAFAB_CNVersion: Network relationships17PRZNT% used to calc. time interval between predecessor/successornvarchar30
28VSAFVC_CNVersion: Operation in order69PRZNTWork percentagetinyint30
TOPSpain
29T5EFISeverance payment calculation7PRZNTPercentagedecimal74
TOPTime Tickets
30T703QIncentive Wages: Premium Formulas11PRZNTPremium formula result in percentnvarchar10