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

32 columns | Print definition?ERP 6.0  | STAT2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000281000PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee30STAT2nvarchar10
2/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee13STAT2nvarchar10
3P2B2_PTHCM Declustering B2 - Time Event Pairs17STAT2Status from time evaluationnvarchar10
4P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay13STAT2Employment Statusnvarchar10
5P2IE_CPRSIHR IE: Irish Payroll PRSI Cumulation Table8STAT2Employment Statusnvarchar10
6P2IN_TANCompany code cluster line item12STAT2Employment Statusnvarchar10
7P2RD_VERSORGUNGPayroll Result: Pension Payment (PS)37STAT2Statistics Indicator for Pensionsnvarchar20
8P2RK_TAX1Payroll results - master data from infotypes 0461-04638STAT2Employment Statusnvarchar10
9P2RK_TAXOPayroll results - master data from infotypes 0461-04638STAT2Employment Statusnvarchar10
10P2RW_CSTPayroll Result: Cumulated Tax Data for South Africa.8STAT2Employment Statusnvarchar10
11P2RW_STPayroll Result: Tax Data for South Africa.8STAT2Employment Statusnvarchar10
12P2RX_WPBPPayroll Results: Work Center/Basic Pay11STAT2Employment Statusnvarchar10
13T5REGEmployee Information Log for Destruction of Data6STAT2Employment Statusnvarchar10
14T5RPDPersonnel Data Deletion Log16STAT2Employment Statusnvarchar10
15T7HRJOPPDJOPPD Form data - Intermediate table44STAT2Statusnvarchar10
TOPAssortment Maintenance
16WSOFModule Assignment (SAP Retail) to Plants10STAT2Status of assortment owner assignmentnvarchar10
17WSOHAssortment Modules SAP Retail11STAT2Status assignment promotionnvarchar10
TOPCompany Pension Scheme Germany
18P01CVHActuarial CPS Header Records19STAT2Employment Statusnvarchar10
TOPCost Object
19TKKAS_LControl Table for Results Analysis7STAT2Status for Cancellation of Inventory and Reservesnvarchar50
TOPCross-Application Components
20J_2GLPLEGSIGLegal printed docs: Sign data13STAT2Legal document sign statusnvarchar10
TOPCross-Application Objects in HR
21HRP5580DB Table for Infotype 558018STAT2Employment Statusnvarchar10
TOPPayroll
22T7ROG3EE register - EE history26STAT2Employment Statusnvarchar10
23T7ROG7EE register - Contract History29STAT2Employment Statusnvarchar10
TOPPayroll General Parts
24HRPY_WPBPHR-PAY: Transparent Table WPBP9STAT2Employment Statusnvarchar10
TOPPersonnel Administration
25PA0000HR Master Record: Infotype 0000 (Actions)27STAT2Employment Statusnvarchar10
26T529APersonnel Action Types10STAT2Employment Statusnvarchar10
TOPPublic Sector
27PA0322HR Master Record: Infotype 0322 (Pensions and Rel. Ben.)51STAT2Statistics Indicator for Pensionsnvarchar20
28T7PBSWB5BProcess status flow rule definition9STAT2Secondary sub process scenario statusnvarchar40
TOPReal Estate Management
29VIWB01Teile der Hauptwirtschaftlichkeitsberechnung8STAT2Status Teilwirtschaftlichkeitsberechnungnvarchar10
TOPResults Recording
30TQ78Status-dependent processing table for insp. characteristics7STAT2Characteristic Is Being Processednvarchar10
TOPTaiwan
31T7TW2IReported data of Tax withdrawal report33STAT2Employment Statusnvarchar10
TOPTransaction Manager
32VTB_FRGSTControl parameter for Release - Status management6STAT2Individual status of an object (short form)nvarchar40