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

49 columns | Print definition?ERP 6.0  | IDTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GEOE/CONFIG_20Result set context menus7IDTYPEID Typenvarchar10
2EHPRCC_IMMAPMapping table7IDTYPEIdentification Categorynvarchar100
TOPAccounting - General
3SMCOPCSpecific CO-OM Data in Monitor (See Schedman_specific_coom)4IDTYPEObject Category of the IDnvarchar10
TOPActual CostingMaterial Ledger
4CKML_SM_ACActual Costing Data for Schedule Manager4IDTYPEObject Category of the IDnvarchar10
TOPAutomatic Payments
5SMFIBLSpec. FI-BL Data in Monitor4IDTYPEObject Category of the IDnvarchar10
TOPBasic Functions
6SMFIAASpec. FI-AA Data in Monitor (see Schedman_specific_fiaa)4IDTYPEObject Category of the IDnvarchar10
7SMFIARSpec. FI-SL Data in Monitor (See Schedman_specific_fisl)4IDTYPEObject Category of the IDnvarchar10
8SMFISLSpec. FI-SL Data in Monitor (See Schedman_specific_fisl)4IDTYPEObject Category of the IDnvarchar10
TOPBusiness Partner
9BPID001Additional Partner Numbers3IDTYPEID Number Category for Business Partnernvarchar60
10BPID002_TDescription of Identification Number Category3IDTYPEID Number Category for Business Partnernvarchar60
11BPID003_EID Number Category2IDTYPEID Number Category for Business Partnernvarchar60
12BPIDCONVAssignment of ID Categories/Types and ID Number Categories2IDTYPEID Number Category for Business Partnernvarchar60
13TBPIDID Number Category2IDTYPEID Number Category for Business Partnernvarchar60
14TP42Assignment of Logical System / ID Number Category4IDTYPEIdentification Typenvarchar60
TOPContract Accounts Receivable and Payable
15BPPAN_IDTYP_INMaintain Taxtype/ID type for PAN number4IDTYPEIdentification Typenvarchar60
TOPCosts
16SMPSSpecific PS Data in Monitor4IDTYPEObject Category of the IDnvarchar10
TOPEnvironment, Health and Safety
17/TDAG/CPC_EXMAPCP: Export Mapping6IDTYPEIdentification Categorynvarchar100
18/TDAG/CPC_IMMAPMapping table7IDTYPEIdentification Categorynvarchar100
19/TDAG/CPC_REP005CP: Define attributes for element8IDTYPEIdentification Typenvarchar100
TOPJoint Venture und Production Sharing Accounting
20SMJVSpecific CO-OM Data in Monitor (See Schedman_specific_coom)4IDTYPEObject Category of the IDnvarchar10
TOPMigration
21TEMIDID assignment for IS-U Migration Workbench1IDTYPEApplication for IDnvarchar10
TOPOverhead Cost Controlling
22SMCOOMSpecific CO-OM Data in Monitor (See Schedman_specific_coom)4IDTYPEObject Category of the IDnvarchar10
TOPPayment Transactions
23SMFIAPSpec. FI-SL Data in Monitor (See Schedman_specific_fisl)4IDTYPEObject Category of the IDnvarchar10
TOPProduct Cost Planning
24SMCOPCPCPCO-PC-PCP Data in Monitor (see Schedman_specific_copc_pcp)4IDTYPEObject Category of the IDnvarchar10
TOPProduct Safety
25ESTOCCEHS: OCC: Table for Saving Import Information7IDTYPEIdentification Categorynvarchar100
26ESTRIEHS: Identifier (Numbers, Names, Chemical Formulas)16IDTYPEIdentification Categorynvarchar100
27TCG21EHS: Identification Category1IDTYPEIdentification Categorynvarchar100
28TCG22EHS: Language-Dependent Desc. for Identification Category2IDTYPEIdentification Categorynvarchar100
29TCG23EHS: Identification Type2IDTYPEIdentification Categorynvarchar100
30TCG23OBJEHS: Identification Type - Specification Categ. Assignment2IDTYPEIdentification Categorynvarchar100
31TCG24EHS: Language-Dependent Desc. for Identification Type3IDTYPEIdentification Categorynvarchar100
32TCG28EHS: Definition of identification listings6IDTYPEIdentification Categorynvarchar100
33TCGHITPOSEHS: Set of hit items10IDTYPEIdentification Categorynvarchar100
34TCGRULPOSIDCHGEHS: Easy Expert Set of Rules, Ident. Changes5IDTYPEIdentification Categorynvarchar100
35TCGTPLIEHS: Inheritance Templates - Identifiers17IDTYPEIdentification Categorynvarchar100
TOPProfitability Analysis
36SMCOPASpecial CO-PA Data in Monitor4IDTYPEObject Category of the IDnvarchar10
TOPSchedule Manager
37SMBATCHBatch Information for an Entry in the Monitor4IDTYPEObject Category of the IDnvarchar10
38SMCUSTOMERSpecific User-Defined Data in the Monitor4IDTYPEObject Category of the IDnvarchar10
39SMEXTInformation on Results Lists That Have Been Saved4IDTYPEObject Category of the IDnvarchar10
40SMMAINMain Information for an Entry in the Monitor4IDTYPEObject Category of the IDnvarchar10
41SMMESSAGEMessages Saved for Monitor4IDTYPEObject Category of the IDnvarchar10
42SMPARAMSchedule Manager Monitor: Processing Parameters7IDTYPEObject Category of the IDnvarchar10
43SMRLInformation on Saved Basic Lists4IDTYPEObject Category of the IDnvarchar10
44SMSELKRITSchedule Manager Monitor: Selection Criteria7IDTYPEObject Category of the IDnvarchar10
45SMSPOOLBatch Information for an Entry in the Monitor5IDTYPEObject Category of the IDnvarchar10
46SMSTATUSStatus Information of an Entry in the Monitor4IDTYPEObject Category of the IDnvarchar10
47SMSTATUS_HISTStatus Information of an Entry in the Monitor5IDTYPEObject Category of the IDnvarchar10
48SMWFInformation on Workflow Worklists4IDTYPEObject Category of the IDnvarchar10
TOPWeb Service and SOAP - ABAP
49SRT_UTIL_CONFIGSRT Utilities: Trace Configuration2IDTYPEnvarchar10