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

43 columns | Print definition?ERP 6.0  | VALUETYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000171000PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances27VALUETYPEnvarchar30
2/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.29VALUETYPEnvarchar30
3/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs31VALUETYPEnvarchar30
4/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)31VALUETYPEnvarchar30
5CCGLT_PRTREQ_PAREHS: Print Request Parameters8VALUETYPEValue Type of a Parameter Valuenvarchar10
6CCGLT_PR_PAR_UTEHS: Print Request Parameters Test Data for Unit Tests11VALUETYPEValue Type of a Parameter Valuenvarchar10
7EHFNDD_AMNS_ROOTAmounts - Root18VALUETYPEValue Typenvarchar210
TOPActivity-Based Costing
8COTPLFPCO-OM-ABC: Formula Parameter Lists for Process Template14VALUETYPEString Typenvarchar10
9COTPLFVCO-OM-ABC: Formula Value Lists for Process Template11VALUETYPEString Typenvarchar10
TOPBudgeting and Availability Control
10GMBDGTLINEBudget Document Line20VALUETYPEGM Value Typenvarchar20
11GMHBDGTLINEBudget Line: Held Documents21VALUETYPEGM Value Typenvarchar20
TOPBW Service API
12RSMVTDETLValue table for detailling per value type1VALUETYPEValue type for Reportingnvarchar30
13RSMVTSTATValue table for statistics indicators per value type1VALUETYPEValue type for Reportingnvarchar30
14RSMVTYPEValue table for value types for reporting1VALUETYPEValue type for Reportingnvarchar30
15RSTVTDETLTexts for detailing per value type2VALUETYPEValue type for Reportingnvarchar30
16RSTVTSTATTexts for statistics indicator per value type2VALUETYPEValue type for Reportingnvarchar30
17RSTVTYPETexts for value types for reporting2VALUETYPEValue type for Reportingnvarchar30
TOPCompensation Management
18T71WL2Parameter for link structure7VALUETYPEType of Parameter for Web Linknvarchar10
TOPDepreciation Simulation
19IMCKFIM Summarization: Key figures8VALUETYPEValue Typenvarchar20
TOPGeneral Ledger Accounting
20FAGL_BW_LOG_ITEMFI-GL: Log for BW Extraction: Line Items55VALUETYPEValue type for Reportingnvarchar30
21FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records32VALUETYPEValue type for Reportingnvarchar30
22FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis31VALUETYPEValue type for Reportingnvarchar30
TOPIncentive and Commission Management ICM
23TCACS_TGSTarget Agreements: Elementary Target Types6VALUETYPETarget Agreements: Target Value Type (Amount or Quantity)nvarchar10
TOPInformation System
24BIWTBUF_CVBuffer Texts2VALUETYPEValue type for Reportingnvarchar30
25BIWTDAT_CVDate Texts2VALUETYPEValue type for Reportingnvarchar30
26BIWTDUR_CVDuration Texts2VALUETYPEValue type for Reportingnvarchar30
27BIW_BUF_CVConversion of Buffer into BW Format2VALUETYPEValue type for Reportingnvarchar30
28BIW_BUF_TBConversion of Buffer into BW Format2VALUETYPEValue type for Reportingnvarchar30
29BIW_DAT_CVConversion of Dates into BW Format2VALUETYPEValue type for Reportingnvarchar30
30BIW_DAT_TBConversion of Dates into BW Format2VALUETYPEValue type for Reportingnvarchar30
31BIW_DUR_CVConversion of Duration into BW Format2VALUETYPEValue type for Reportingnvarchar30
32BIW_DUR_TBConversion of Duration into BW Format2VALUETYPEValue type for Reportingnvarchar30
TOPProcess Controls
33GRPCRLCRSYSARule Criteria System Type Assignment5VALUETYPERule Criteria value Typenvarchar100
TOPProduct Configurator
34COMM_CFGCLNDOMDomains for Numeric Characteristics of Classes11VALUETYPEValue typenvarchar10
35COMM_CFGCLSDOMDomains for String Characteristics of Classes9VALUETYPEValue typenvarchar10
36COMM_CFGCLVALValues and Defaults for Characteristics of Classes10VALUETYPEValue typesmallint50
37COMM_CFGNUMDOMDomains for Numeric Characteristics9VALUETYPEValue typenvarchar10
38COMM_CFGSTRDOMDomains for String Characteristics7VALUETYPEValue typenvarchar10
TOPProduct Safety
39CVDDCSPEHS: Control Structure Parameters (Report Shipping)19VALUETYPEValue Type of a Parameter Valuenvarchar10
40CVDDPEHS: Parameter Values for Report Shipping19VALUETYPEValue Type of a Parameter Valuenvarchar10
41ESTAHEHS: Application-dependent data for report generation6VALUETYPEValue Type of a Parameter Valuenvarchar10
42ESTDCSPEHS: Parameter Control Structure19VALUETYPEValue Type of a Parameter Valuenvarchar10
TOPSales and Distribution
43SCECLVALValues Assigned to Characteristics of a Class6VALUETYPEType of value (default or value)nvarchar10