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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

22 columns | Print definition?ERP 6.0  | VAL_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/O_BAT_HDRBatch master - Header table18VAL_TYPEValuation Typenvarchar100
2/GBT/O_MDOC_ITMMaterial Document Item for Tracking15VAL_TYPEValuation Typenvarchar100
3/GBT/O_PURO_ITMPurchasing Document Item for Tracking12VAL_TYPEValuation Typenvarchar100
4J_3RFREP_ADP_MAPXML Data Provider Parameters Definition5VAL_TYPEData Provider Export Typenvarchar500
5J_3RFREP_PRESETSPredefined Attributes for the Reporting Hierarchy Elements4VAL_TYPEValue Type of Reporting Hierarchy Object Attributenvarchar20
6J_3RFREP_VALFMTPredefined Attributes for the Reporting Hierarchy Elements5VAL_TYPEValue Type of Reporting Hierarchy Object Attributenvarchar20
7REQLINEMATemporary Line Data: Requirement Coverage Request(MRO Lines)40VAL_TYPEValuation Typenvarchar100
TOPCross-Application Component CA Enhancements
8/SAPMP/MIG_T001Migration CS -> DIMP: Object Status Material Master8VAL_TYPEValuation Typenvarchar100
TOPeCATT Extended Computer Aided Test Tool
9ECSCR_DATAValues for eCATT Script Parameters7VAL_TYPEType of Parameter Valuenvarchar10
10ECSP_PAR_DATAValues for eCATT Test Run Data Parameters7VAL_TYPEType of Parameter Valuenvarchar10
11ECTC_DATAAssignment of TD Parameters to eCATT Interface7VAL_TYPEType of Parameter Valuenvarchar10
12ECTD_DATAValues for Test Data Container Parameters7VAL_TYPEType of Parameter Valuenvarchar10
TOPFunds Management
13PSBM_EVENTPS Budget Monitoring Events6VAL_TYPEValue Typenvarchar20
TOPGlobal Performance Analysis Transaction ST3
14AMTINFOGlobal Performance Analysis: Performance Tests Info Table3VAL_TYPEValidation Type (Global Performance Analysis)nvarchar40
TOPGlobal Trade Services
15/SAPSLL/TCOVALGTS: Valuation Type2VAL_TYPEValuation Typenvarchar100
16/SAPSLL/TCOVALTGTS: Valuation Type: Description3VAL_TYPEValuation Typenvarchar100
17/SAPSLL/TCOVGSAssgmt of Valuation Type from FS to Valuation at FS Grp Lvl4VAL_TYPEValuation Typenvarchar100
18/SAPSLL/TCOVVSAssignment of Val. Type from FS to Val. Type at FS Level4VAL_TYPEValuation Typenvarchar100
TOPMaster Data
19CMS_OMS_VAL_LNKValue Link4VAL_TYPEValue Typenvarchar60
TOPPlanning
20RSPLF_SRV_PParameter Value (Elementary Type)6VAL_TYPEType of Parameter Valuenvarchar10
TOPReal Estate
21CMS_RE_PRT_VALReal Estate Part value details5VAL_TYPEValue Calculation Methodnvarchar100
TOPTrading Contract
22WBGTGlobal Trade: Generic Document Information45VAL_TYPEValuation Category in BWnvarchar20