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

38 columns | Print definition?ERP 6.0  | MESCOD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_FINFInterface definition62MESCODLogical Message Variantnvarchar30
2EDP21OPTIONSPartner Profile: Options6MESCODMessage codenvarchar30
3IDXLOGDC40IDoc Adapter RFC Logging EDI_DC4015MESCODMessage codenvarchar30
TOPALE Integration Technology
4EDIDCControl record (IDoc)20MESCODLogical Message Variantnvarchar30
5EDIDOCINDXControl record (IDoc)20MESCODLogical Message Variantnvarchar30
6EDIFCTIDoc: Assignment of FM to log. message and IDoc type6MESCODLogical Message Variantnvarchar30
7EDIPHONETelephony Data for Partner Profiles7MESCODLogical Message Variantnvarchar30
8EDP12Partner Profile: Outbound with Message Control10MESCODMessage codenvarchar30
9EDP13Partner Profile: Outbound (technical parameters)6MESCODMessage codenvarchar30
10EDP21Partner Profile: Inbound6MESCODMessage codenvarchar30
11EDPI1EDI: Partner profiles (inbound)8MESCODMessage codenvarchar30
12EDPPVProposal Values for Partner Fast Entry5MESCODMessage codenvarchar30
13TCEDP21EDI Partner Profile: Help Structure Table Control edp216MESCODMessage codenvarchar30
14TMSG1Logical Messages and Process Codes in Outb. Procg3MESCODLogical Message Variantnvarchar30
15TMSG2Logical Messages and Process Codes in Inb. Procg3MESCODLogical Message Variantnvarchar30
TOPContract Accounts Receivable and Payable
16FKK_EBS_TOI_SYSTDocument Transfer from External System : Agreements4MESCODLogical Message Variantnvarchar30
TOPDistribution Unit Distribution Packet
17UPSITMALE Distribution Unit: Objects7MESCODActivity of Object Statusnvarchar30
18UPSITXALE Distribution Unit: Objects of Processed Units7MESCODActivity of Object Statusnvarchar30
TOPFSCM In-House Cash
19IHC_DB_CL_IDOCIHC: Communication Data for Clearing Unit7MESCODLogical Message Variantnvarchar30
TOPGlobal Trade Services
20/SAPSLL/TLEACMMessages for Activity14MESCODMessage codenvarchar30
TOPIndustry Solution - Telecommunications
21IST_EBS_TOI_SYSTDocument Transfer from External System : Agreements4MESCODLogical Message Variantnvarchar30
TOPProduct Data Replication
22CRWB_BADI_BL2UPSUPS Entries for Baseline (Workflow Dependent)8MESCODActivity of Object Statusnvarchar30
TOPSelf-Billing Proced.
23T665CSD Self-Billing Procedure: EDI Partner Inbound Parameters6MESCODMessage codenvarchar30
24TRNSMData Transfer12MESCODLogical Message Variantnvarchar30
TOPSpecification 2
25CSPCS1SRFQ/Quotation Type for Part Availability Information3MESCODMessage codenvarchar30
26SPCFILESPEC 2000 messages & fields5MESCODLogical Message Variantnvarchar30
27SPCINMAPRules for linking src field and trg field4MESCODLogical Message Variantnvarchar30
28SPCMCOMPSPEC 2000 AEC Data sets4MESCODLogical Message Variantnvarchar30
29SPCMDTELSPEC 2000M Data Elements1MESCODLogical Message Variantnvarchar30
30SPCMFILESPEC 2000 AEC messages & fields4MESCODLogical Message Variantnvarchar30
31SPCMGLOSACStatus/Advice Codes SPEC2000M4MESCODLogical Message Variantnvarchar30
32SPCMINMAPRules for linking src field and trg field (AECMA)4MESCODLogical Message Variantnvarchar30
33SPCMPORTFUNSPEC 2000 message with FMs for further processing3MESCODLogical Message Variantnvarchar30
34SPCMVERSIONVersions for SPEC messages1MESCODLogical Message Variantnvarchar30
35SPCM_DISP_MENUAction table for A&D Displaytool (menu)4MESCODLogical Message Variantnvarchar30
36SPCPORTFUNSPEC 2000 message with FMs for further processing3MESCODLogical Message Variantnvarchar30
37SPCPORTFUNIIRules table linking src field and trg fields3MESCODLogical Message Variantnvarchar30
TOPSupplier Workplace
38ISIPCPossible operations in the Supplier Workplace functions7MESCODMessage codenvarchar30