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

98 columns | Print definition?ERP 6.0  | MESTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_FINFInterface definition59MESTYPMessage Typenvarchar300
2/SDF/IVISALEPNDGALE messages stuck in tRFC7MESTYPMessage Typenvarchar300
3EDP21OPTIONSPartner Profile: Options5MESTYPMessage Typenvarchar300
4IDXLOGDC40IDoc Adapter RFC Logging EDI_DC4014MESTYPMessage typenvarchar300
5IDXLOG_ADMConfiguration: IDoc Adapter RFC Logging3MESTYPMessage typenvarchar300
6TBDDAAGMESSAGEResidence Times for Message Types or Partners2MESTYPMessage Typenvarchar300
7TKEBBManagement for Operating Concerns (Cross-Client)8MESTYPMessage Typenvarchar300
8WLF_C_IDOC2STRUCMapping From IDOC Segment To Maintenance Structure2MESTYPMessage Typenvarchar300
9WLF_C_IDOC2STRUTDescription texts for IDOC editor3MESTYPMessage Typenvarchar300
10WLF_C_IDOCFIELDSChangeable IDOC Fields2MESTYPMessage Typenvarchar300
TOPAgency Business Global Trade
11TWLFEDIMAPEDI: Assignment Table Between IDoc and Application Fields1MESTYPMessage Typenvarchar300
TOPALE Integration Technology
12EDBDMSKYEDI/ALE: Map CCMS Key to IDoc Attributes2MESTYPMessage Typenvarchar300
13EDCRYPTDISPLAYAssignment: Encrypted Segment Field Display1MESTYPMessage Typenvarchar300
14EDIDCControl record (IDoc)40MESTYPMessage Typenvarchar300
15EDIDOCINDXControl record (IDoc)40MESTYPMessage Typenvarchar300
16EDIFCTIDoc: Assignment of FM to log. message and IDoc type5MESTYPMessage Typenvarchar300
17EDIMAPEDI: Assignment Table Between IDoc and Application Fields4MESTYPMessage Typenvarchar300
18EDIMSGOutput Types and Assignment to IDoc Types1MESTYPMessage Typenvarchar300
19EDIMSGTShort description of SAP message types2MESTYPMessage Typenvarchar300
20EDIPHONETelephony Data for Partner Profiles6MESTYPMessage Typenvarchar300
21EDIQIIDoc Inbound Queue Table7MESTYPMessage Typenvarchar300
22EDIQOIDoc: Outbound Queue for qRFC7MESTYPMessage Typenvarchar300
23EDI_MSG_MDMPMessage Types with MDMP Segments1MESTYPMessage Typenvarchar300
24EDP12Partner Profile: Outbound with Message Control9MESTYPMessage Typenvarchar300
25EDP13Partner Profile: Outbound (technical parameters)5MESTYPMessage Typenvarchar300
26EDP21Partner Profile: Inbound5MESTYPMessage Typenvarchar300
27EDPPVProposal Values for Partner Fast Entry4MESTYPMessage Typenvarchar300
28IDOCSTYLETable of Style IDs with the Objects to Be Loaded2MESTYPMessage Typenvarchar300
29TBD03Communication relation between systems5MESTYPMessage Typenvarchar300
30TBD05Distribution model for message types4MESTYPMessage Typenvarchar300
31TBD10ALE: IDoc fields in ALE object1MESTYPMessage Typenvarchar300
32TBD12Mapping message type -> serialization and link type1MESTYPMessage Typenvarchar300
33TBD13Organizational units to be converted in IDoc fields1MESTYPMessage Typenvarchar300
34TBD14Message type -> object type1MESTYPMessage Typenvarchar300
35TBD17Dependencies between message types1MESTYPMessage Typenvarchar300
36TBD20ALE: data for IDoc projection filter8MESTYPMessage Typenvarchar300
37TBD21ALE: IDoc reduction1MESTYPMessage Typenvarchar300
38TBD22ALE: mapping IDoc fields to change document fields1MESTYPMessage Typenvarchar300
39TBD23ALE: definition of mandatory segments/fields1MESTYPMessage Typenvarchar300
40TBD24ALE: IDOC reduction flagged with positive logic1MESTYPMessage Typenvarchar300
41TBD30ALE: Conversion rules for IDoc segments8MESTYPMessage Typenvarchar300
42TBD40Assign Message Types to Serialization Group3MESTYPMessage Typenvarchar300
43TBD41Inbound processing of serialization group3MESTYPMessage Typenvarchar300
44TBD53ALE: Object Channel Serialization: Message Type of Bus. Obj.2MESTYPMessage Typenvarchar300
45TBD62Assignment of change document field to message type3MESTYPMessage Typenvarchar300
46TBDA2ALE message active2MESTYPMessage Typenvarchar300
47TBDLTLists for a logical system for ALE distribution3MESTYPMessage Typenvarchar300
48TBDMEALE supplement data for EDI message type1MESTYPMessage Typenvarchar300
49TBDMSAssignment of message type to IDoc type1MESTYPMessage Typenvarchar300
50TBDTPMALE Template: Message Type Interfaces4MESTYPMessage Typenvarchar300
51TCEDP21EDI Partner Profile: Help Structure Table Control edp215MESTYPMessage Typenvarchar300
52TEDE1EDI process types (outbound)5MESTYPMessage Typenvarchar300
53TEDNOLINKSIDoc: Negative List for IDoc/Application Object Link4MESTYPMessage Typenvarchar300
54TEDNOLINKSHISTIDoc: History of Changes in TEDNOLINKS5MESTYPMessage Typenvarchar300
55TMSG1Logical Messages and Process Codes in Outb. Procg2MESTYPMessage Typenvarchar300
56TMSG2Logical Messages and Process Codes in Inb. Procg2MESTYPMessage Typenvarchar300
TOPClinical System
57N1MERGSTIS-H*MED: Medication Event - Status4MESTYPStatus Typenvarchar20
TOPContract Accounts Receivable and Payable
58FKK_EBS_TOI_SYSTDocument Transfer from External System : Agreements3MESTYPMessage Typenvarchar300
TOPDistributed System Landscape
59/ISDFPS/ALE_OBJALE Objects - Priority Category Assignments for tRFC-ALE2MESTYPMessage Typenvarchar300
60/ISDFPS/XI_IFALE Objects - Priority Category Assignments3MESTYPMessage Typenvarchar300
TOPDistribution Unit Distribution Packet
61DELIVERYReplication Table3MESTYPMessage Typenvarchar300
62DSPITMALE Distribution Packet : Objects3MESTYPMessage Typenvarchar300
63TDSP01ALE Distribution Packet : Message Types to be Controlled1MESTYPMessage Typenvarchar300
64TUPS01ALEALE Distribution Unit: Object Types (Distributable) - Serv.2MESTYPMessage Typenvarchar300
65TUPS01DObsolete (Old Data)2MESTYPMessage Typenvarchar300
TOPDSD Connector
66/DSD/ME_MSGT2OBJDSD CN: Assignment Message Types to MDE Object3MESTYPMessage Typenvarchar300
67/DSD/ME_MSG_CUSTDSD Connector: Definitions of Driver Messages2MESTYPMessage Typenvarchar300
TOPFinancial Accounting
68FEDICUSFI EDI Control for Calling Customer Functions per Segment1MESTYPMessage Typenvarchar300
TOPIndustry Solution - Telecommunications
69IST_EBS_TOI_SYSTDocument Transfer from External System : Agreements3MESTYPMessage Typenvarchar300
TOPIntegration Server
70IDXMDMPRCVMDMP Support Receiver2MESTYPMessage typenvarchar300
71IDXNOALEDo not request IDoc Adapter exception list acknowledgement3MESTYPMessage typenvarchar300
72IDXQUEUEIDoc Adapter Queue3MESTYPMessage typenvarchar300
TOPLocalization
73J_1BPOSCOUPONSPOS-Database Coupons (Brazilian)22MESTYPMessage Typenvarchar300
74J_1BPOSREDUCTIONPOS-Database Reduction (Brazilian)25MESTYPMessage Typenvarchar300
TOPMarketing Retail Network
75OIFORCAMConversion of article master to material master data (ALE)10MESTYPMessage Typenvarchar300
TOPMaterial Master
76EANC_IOPROCESSTable in Which the Processes to be Mapped are Defined1MESTYPMessage Typenvarchar300
TOPMaterials Management
77/ISDFPS/CS_SW_IDSystem Switch: Force Element and IDocs6MESTYPMessage Typenvarchar300
TOPOrganizational Management
78HRPADXNAdditional Data PADXN3MESTYPMessage Typenvarchar300
TOPPayment Transactions
79FEDIWF1FI EDI: Person with signing authority3MESTYPFI EDI Ccontrol: Logical Message Typenvarchar60
TOPPOS Interface - Outbound
80TWPCOPYReference Ship-to Party for IDoc Copy Management4MESTYPMessage Typenvarchar300
81WDLCOPYLog Table for IDoc Copy Management4MESTYPMessage Typenvarchar300
82WDLCOPYLOGError Log Table for IDoc Copy Management5MESTYPMessage Typenvarchar300
TOPRemaining Beverage - Obsolete Objects
83/DSD/ME_MESS2OBJDSD Connector: Assignment Message Types to MDE Object3MESTYPMessage Typenvarchar300
TOPRisk Analysis
84JBRRMBBFAnalysis Structure8MESTYPMessage Typenvarchar300
TOPSelf-Billing Proced.
85T665CSD Self-Billing Procedure: EDI Partner Inbound Parameters5MESTYPMessage Typenvarchar300
86TRNSMData Transfer11MESTYPMessage Typenvarchar300
TOPSpecification 2
87CSPCS1SRFQ/Quotation Type for Part Availability Information2MESTYPMessage Typenvarchar300
88SPCFILESPEC 2000 messages & fields3MESTYPMessage Typenvarchar300
89SPCINMAPRules for linking src field and trg field3MESTYPMessage Typenvarchar300
90SPCMCOMPSPEC 2000 AEC Data sets2MESTYPMessage Typenvarchar300
91SPCMFILESPEC 2000 AEC messages & fields2MESTYPMessage Typenvarchar300
92SPCMINMAPRules for linking src field and trg field (AECMA)3MESTYPMessage Typenvarchar300
93SPCMPORTFUNSPEC 2000 message with FMs for further processing2MESTYPMessage Typenvarchar300
94SPCM_DISP_MENUAction table for A&D Displaytool (menu)2MESTYPMessage Typenvarchar300
95SPCPORTFUNSPEC 2000 message with FMs for further processing2MESTYPMessage Typenvarchar300
96SPCPORTFUNIIRules table linking src field and trg fields2MESTYPMessage Typenvarchar300
TOPSupplier Workplace
97ISI_SWPBCPartner agreement for document exchange via SWP + SAP BC3MESTYPMessage Typenvarchar300
TOPTreasury
98TTMRBAdministration of Risk Management areas (indep. of client)7MESTYPMessage Typenvarchar300