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

53 columns | Print definition?ERP 6.0  | OPTIO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_20551_DERIV3Object types for Find_Objects - evaluation rule6OPTIOOptionnvarchar40
2P2KR_KRTAXPayroll Result Korea : Tax31OPTIOTax calculation method for foreignernvarchar10
3P2RK_TAX1Payroll results - master data from infotypes 0461-046315OPTIOOption for tax calculationnvarchar10
4P2RK_TAXOPayroll results - master data from infotypes 0461-046315OPTIOOption for tax calculationnvarchar10
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
5COAT_LTDCOAT: Layouts of Initial Screen; Data6OPTIOCOAT: Table Display - OPTION for Selectionnvarchar20
TOPBusiness Consolidation
6UCL2031Change Log: Selections6OPTIOType of OPTION component in row type of a Ranges typenvarchar20
7UCT101CSet: Rows5OPTIOType of OPTION component in row type of a Ranges typenvarchar20
8UCT2010Single Field Selection: Range for Selection Characteristic5OPTIOType of OPTION component in row type of a Ranges typenvarchar20
9UCT2016Single Field Selection: Cross Characteristic4OPTIOType of OPTION component in row type of a Ranges typenvarchar20
TOPBusiness Planning and Simulation
10UPC_OPTIOSPlanning: Conditions for Fields8OPTIOSelection Condition: EQ, BT,...nvarchar20
TOPCanada
11PA0224Tax information - infotype 0224 - Canada29OPTIOOption for tax calculationnvarchar10
12PA0463HR Master Record: Infotype 046333OPTIOOption for tax calculationnvarchar10
13T5KTCWage Type Tax Classifications (Canada)3OPTIOOption for tax calculationnvarchar10
TOPCCMS Database Monitors for Oracle
14DBSTATCConfiguration of Statistics Creation11OPTIOSample Size for Collection of Statisticsnvarchar50
15DBSTATSControl for Application Monitor and CBO: Setup11OPTIOSample Size for Collection of Statisticsnvarchar50
16DBTMPORADB Optimizer Control (Statistics Creation)11OPTIOSample Size for Collection of Statisticsnvarchar50
TOPControlling
17SE16N_LTDSE16N: Initial Screen for Layouts, Data6OPTIOTable display: OPTION for selectionnvarchar20
TOPCost Center Accounting
18TKA53CO planner profile: entry screen for pre-parameterization9OPTIOVersion Number Componentnvarchar20
TOPData Collection
19KCSLOSAP-EIS: Selection requirements for data slices6OPTIOSelection conditionsnvarchar20
20T242DData transfer control9OPTIOSelection conditionnvarchar20
TOPData Transfer
21KCDRSData Transfer Rules: Selection Criteria of Sender Fields10OPTIOSelection conditionsnvarchar20
TOPDB2 for OS39
22DBSTATHDB2DB2/390 Statistics for Tables (History)5OPTIOSample Size for Collection of Statisticsnvarchar50
23DBSTATTDB2DB2/390 Statistics for Tables5OPTIOSample Size for Collection of Statisticsnvarchar50
TOPDB2 Universal Database for UNIX NT
24DBSTATHDB6DB6: Statistical History of Application Monitor6OPTIOSample Size for Collection of Statisticsnvarchar50
25DBSTATTDB6DB6: Table Statistics for Application Monitor6OPTIOSample Size for Collection of Statisticsnvarchar50
TOPFrance
26PA0098Infotype 0098 (Profit Sharing - France)29OPTIOProfit sharing tax optionnvarchar20
27T5F5FSettings for 'Bilan Social' selection criteria9OPTIOOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
TOPKorea
28PA0541HR Master Record: Infotype 054134OPTIOTax calculation method for foreignernvarchar10
TOPOverhead Cost Controlling
29PFPARPeriod-End Partner: Processing Parameters8OPTIOOPTION of the Parameter/Select-Option Tablenvarchar20
30PFSELPeriod-End Partner: Selection Criteria8OPTIOOPTION of the Parameter/Select-Option Tablenvarchar20
TOPPayroll General Parts
31DSYS_TRANS_DEVCLHRDSYS: Object Not to be Translated (Except DE, EN)4OPTIOABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPPension fund General Parts
32T72TBHR-PF: TS Parameter Values8OPTIOTS Parameter Optionnvarchar10
TOPPerformance Monitors TCC
33AMDSEffective size of tables and indexes in the database5OPTIOSample Size for Collection of Statisticsnvarchar50
34AMDTControl Table for Application Monitor / DB Storage7OPTIOSample Size for Collection of Statisticsnvarchar50
35DBSTATHORAActual size of tables on the database (history)5OPTIOSample Size for Collection of Statisticsnvarchar50
36DBSTATTORAActual size of tables on the database5OPTIOSample Size for Collection of Statisticsnvarchar50
TOPPersonnel Administration
37T599TField Control for Report Categories8OPTIOCHAR04 data element for SYSTnvarchar40
TOPProfitability Analysis
38TKEHDB_RANGESCOPA HANA: Use of Read Access7OPTIOOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
TOPPromotion
39WARNGSaving of RANGES6OPTIORelational operator (EQ, NE, GT, LT, GE, LE)nvarchar20
TOPReuse Services for Country Development
40T5F99K0Possible configuration options3OPTIOPossible Confituration Optionsnvarchar50
41T5F99K0TPossible configuration options descriptions4OPTIOPossible Confituration Optionsnvarchar50
42T5F99K1Configuration values for configuration options3OPTIOPossible Confituration Optionsnvarchar50
43T5F99K1TDescription of configuration option values4OPTIOPossible Confituration Optionsnvarchar50
44T5F99K2Customer values for configuration options3OPTIOPossible Confituration Optionsnvarchar50
45T5F99KMModificators for configuration options3OPTIOPossible Confituration Optionsnvarchar50
46T5F99KMTDescription of configuration option modificators4OPTIOPossible Confituration Optionsnvarchar50
TOPSchedule Manager
47SMPARAMSchedule Manager Monitor: Processing Parameters9OPTIOOPTION of the Parameter/Select-Option Tablenvarchar20
48SMSELKRITSchedule Manager Monitor: Selection Criteria9OPTIOOPTION of the Parameter/Select-Option Tablenvarchar20
TOPServices
49UASE16N_LTDSE16N: Initial Screen for Layouts, Data6OPTIOTable Display: OPTION for Selectionnvarchar20
TOPUSA
50T5UPBSPA23Selection Rule Definition7OPTIOSelection operator OPTION for range tablesnvarchar20
TOPXBRL Reporting
51UGX0040Value Selection - Characteristic Values7OPTIOType of OPTION component in row type of a Ranges typenvarchar20
52UGX0050Dimension Mapping: Value Mapping8OPTIOType of OPTION component in row type of a Ranges typenvarchar20
53UGXV100Variant: BW Variables of Type Characteristic Value7OPTIOType of OPTION component in row type of a Ranges typenvarchar20