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

75 columns | Print definition?ERP 6.0  | RNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_20100_T801EOrg. derivation (LIB,RNAME) by T801E4RNAMEnvarchar80
2GRACBGRANGERange table values for Background Job variant4RNAMECharacter field, length 32nvarchar320
3P08P1CNTCLASS Interface Control Table (OBSOLETE from 46C)10RNAMECLASS CPX INTERFACE Control File Run User Namenvarchar120
4P08P_CLSCCLASS Interface Control Table (46C onwards)11RNAMECLASS CPX INTERFACE Control File Run User Namenvarchar120
5P08P_USSCUSS Interface Control Table (Contributions & Salary Changes)7RNAMEUSS Interface Control File Run User Namenvarchar120
6P08P_USSC_CAREUSS Interface Control Table (Contributions & Salary Changes)8RNAMEUSS Interface Control File Run User Namenvarchar120
7T180TReporting: Display Variants - Texts3RNAMEABAP Program Namenvarchar400
8T180UReporting: Display Variants - Headings3RNAMEABAP Program Namenvarchar400
9T180VReporting: Default Values2RNAMEABAP Program Namenvarchar400
10T512VRPDSYS00 - Cross References3RNAMEObject namenvarchar80
11T5GPBSH_CONTROLHESA NISR Control table6RNAMEName of Person Who Changed Objectnvarchar120
12T5GPBST_CONTROLTPS Control records7RNAMEName of Person Who Changed Objectnvarchar120
13T7CNRM_DREPORTTText Table of Report with Dynamic Rows or Columns4RNAMEReport Namenvarchar600
14T801AReport Writer: Exceptions in Row/Column Coordinates3RNAMEReportnvarchar80
15T801CReport Writer: Parallel Report Windows5RNAMEReportnvarchar80
16T803AReport Writer: Key Figure Blocks (Header)3RNAMEReportnvarchar80
17T803BReport Writer: Key Figure Blocks (Descriptions)4RNAMEReportnvarchar80
18T803CReport Writer: Key Figure Blocks (Rows)3RNAMEReportnvarchar80
19T803DReport Writer: Key Figure Blocks (Row/Column Texts)4RNAMEReportnvarchar80
20T803EReport Writer: Key Figure Blocks (Columns)3RNAMEReportnvarchar80
21T803IReport Writer: Row Formulas / Texts4RNAMEReportnvarchar80
22TCOLLConfiguration: Data collection for performance monitoring1RNAMEReport started by the collectornvarchar400
23TIVXCITICIFORMICI Form Settings20RNAMEFirst Namenvarchar400
TOPAccount Determination
24T180GReporting: Totals Variants for each Display Variant2RNAMEABAP Program Namenvarchar400
25T180PReporting: Display Variants: Selection Fields per Variant(s)2RNAMEABAP Program Namenvarchar400
26T180SReporting: Display Variants: Fields2RNAMEABAP Program Namenvarchar400
TOPBasic Functions
27T180MCustomizing List: Modification1RNAMEABAP Program Namenvarchar400
28T181DCustomizing List: Assign Work Structure1RNAMEABAP Program Namenvarchar400
29T181GGeneration Specifications1RNAMEABAP Program Namenvarchar400
30T181OCustomizing Lists: Assign Transaction and Report2RNAMEABAP Program Namenvarchar400
31T181VCustomizing List: Default Values1RNAMEABAP Program Namenvarchar400
32T181ZCustomizing Lists: Reasonable Accesses1RNAMEABAP Program Namenvarchar400
TOPClosing Operations
33FBRC0090CSets4RNAMEData Element (Semantic Domain)nvarchar300
TOPCustomer Bill of Services
34TADBOS01Valid Reports for BOS Reporting in SD4RNAMEABAP Program Namenvarchar400
TOPFinancial Accounting
35FBICRC01030Reconciliation Processes: Customer Defined Fields4RNAMEData Elementnvarchar300
36FBICRC01035Reconciliation Processes: Customer Defined Fields3RNAMEData Elementnvarchar300
TOPForms
37T59_PROTLRPDSYS-SE61 Conversion: Log Table Reference10RNAMEObject namenvarchar80
TOPGeneral Ledger Accounting
38FAGL_RMIGR_LOG2Report Migration: Log Header4RNAMEReportnvarchar80
39FAGL_RMIGR_LOG3Report Migration: Log Detail4RNAMEReportnvarchar80
40FAGL_RMIGR_LOG4Report Migration: Log Messages4RNAMEReportnvarchar80
TOPInformation System
41T800Report Writer: Reports3RNAMEReportnvarchar80
42T800TReport Writer: Texts for Reports4RNAMEReportnvarchar80
43T801BReport Writer: Texts for Logical Rows4RNAMEReportnvarchar80
44T801DReport Writer: Row/Column Characteristics3RNAMEReportnvarchar80
45T801EReport Writer: Selection Sets3RNAMEReportnvarchar80
46T801FReport Writer: Rest Blocks (Rows, Columns)3RNAMEReportnvarchar80
47T801GReport Writer: Sections3RNAMEReportnvarchar80
48T801MReport Writer: Rows/Columns3RNAMEReportnvarchar80
49T801SReport Writer: Cell Assignment3RNAMEReportnvarchar80
50T803FReport Writer: Key Figure Blocks (Formulas)3RNAMEReportnvarchar80
51T803GReport Writer: Key Figure Blocks (Cells in Formulas)3RNAMEReportnvarchar80
52T803HReport Writer: Row Formulas3RNAMEReportnvarchar80
53T803LReport Writer: Entries in Report Groups5RNAMEReportnvarchar80
TOPMaterial Maintenance
54T180ZReporting: Display Variants2RNAMEABAP Program Namenvarchar400
TOPMonitoring
55SWNC_TCOLL_LOGLog of the SWNC TCOLL Runner (CL_SWNC_TCOLL_RUNNER)9RNAMECalling Programnvarchar400
TOPOLAP Technology
56ARCH_IDX_PROTIndex Table for Log Archiving for BI Authorizations2RNAMEUser Name in User Master Recordnvarchar120
57RSECLOG_CLAnalysis Authorizations BI: Logging Active for User3RNAMEUser Name in User Master Recordnvarchar120
58RSECLOPDLOG_CLCopy of RSECLOG_CL3RNAMEUser Name in User Master Recordnvarchar120
59RSRDELREPORTSTable with deleted report programs1RNAMEABAP Program Namenvarchar400
60RSRREPDIRDirectory of all reports14RNAMEABAP Program Namenvarchar400
61RSRREPDIR_STATGeneration Status for Non Client-Specific Queries6RNAMEABAP Program Namenvarchar400
62RSRREPDIR_STATUSStatus of Query Generation5RNAMEABAP Program Namenvarchar400
63RSUDOLOGLogging for Execution As Other User4RNAMEUser Name in User Master Recordnvarchar120
TOPPayroll
64T5TPSTXT01Formuláre infotypu 0729 - doplnku opatrení13RNAMEPole délky 16nvarchar160
TOPPerformance Monitors TCC
65AMRHApplication Monitor: Hierarchy acc. to TCODE/REPORT1RNAMEABAP Program Namenvarchar400
66BUFCHECKException table of tables that cannot be buffered2RNAMEName of Pool/Cluster in the Databasenvarchar100
TOPPersonnel Administration
67T513VRPDSYS00 - Cross References4RNAMEObject namenvarchar80
TOPPersonnel Management
68T7HRA2IP Form - Master data6RNAMEName of Company Code or Companynvarchar250
69T7HRA2NIP Form - Master data - New (w. OIB)6RNAMEName of Company Code or Companynvarchar250
70T7HRA2OIP Form - Master data - with IDENT in key7RNAMEName of Company Code or Companynvarchar250
TOPPrint and Output Management
71TSPLOMSLogical Output Management Systems for Access Method 'E'2RNAMEReal output management systemnvarchar100
TOPProfitability Analysis
72TKEB1Report Management26RNAMEName of ABAP generatednvarchar400
TOPSets
73SETUSE_REPSet Use in Reports and Libraries3RNAMEReportnvarchar80
TOPTranslation Tools
74LXE_WRKLIDPersonal Worklists2RNAMEUser Namenvarchar120
TOPUnited Kingdom
75T5G_ASHE_CONTROLASHE Control Table5RNAMEName of Person Who Changed Objectnvarchar120