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

40 columns | Print definition?ERP 6.0  | SEGTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/TIDOC_STRAIF IDoc structure mapping table3SEGTYPSegment typenvarchar270
2T7PIQINFTYCATGPObsolete:Assign infotypes to change pointer category4SEGTYPSegment typenvarchar270
TOPALE Integration Technology
3CIMSYNSyntax Description for Extensions2SEGTYPSegment typenvarchar270
4EDCRYPTDISPLAYAssignment: Encrypted Segment Field Display2SEGTYPSegment typenvarchar270
5EDIMAPEDI: Assignment Table Between IDoc and Application Fields1SEGTYPSegment typenvarchar100
6EDISDEFIDoc Development : IDoc Segment Definitions1SEGTYPSegment typenvarchar270
7EDISEGEDI: IDoc Segments with Assignment to Segment Type4SEGTYPSegment typenvarchar100
8EDISEGMENTIDoc Development : IDoc Segment1SEGTYPSegment typenvarchar270
9EDISEGTEDI: Short Description of IDoc Segments1SEGTYPSegment typenvarchar270
10EDISYNSyntax Description for Extended Basic Types4SEGTYPSegment typenvarchar270
11EDI_MSG_MDMPMessage Types with MDMP Segments3SEGTYPSegment typenvarchar270
12EDI_SPRAS_MDMPLang. Fields for Each Segm. Type1SEGTYPSegment typenvarchar270
13EDSAPPLEDI: IDoc Segment Application Structure1SEGTYPSegment typenvarchar270
14EDSEAEDI: Table of all segments of current release1SEGTYPSegment typenvarchar100
15EDSVRSEDI: Table of all segments of current release1SEGTYPSegment typenvarchar100
16IDOCSYNSyntax Description for Basic Types3SEGTYPSegment typenvarchar270
17IDXEDISDEFIDoc Adapter Segment Versions for each Port3SEGTYPSegment typenvarchar270
18IDXEDSAPPLIDoc Adapter Fields in the Segments for each Port2SEGTYPSegment typenvarchar270
19IDXIDOCSYNIDoc Adapter IDoc Syntax Description for each Port5SEGTYPSegment typenvarchar270
20TBD10ALE: IDoc fields in ALE object2SEGTYPSegment typenvarchar270
21TBD13Organizational units to be converted in IDoc fields2SEGTYPSegment typenvarchar270
22TBD20ALE: data for IDoc projection filter9SEGTYPSegment typenvarchar270
23TBD21ALE: IDoc reduction2SEGTYPSegment typenvarchar270
24TBD22ALE: mapping IDoc fields to change document fields2SEGTYPSegment typenvarchar270
25TBD23ALE: definition of mandatory segments/fields2SEGTYPSegment typenvarchar270
26TBD24ALE: IDOC reduction flagged with positive logic2SEGTYPRelease-independent name of segment in EDI IDoc typenvarchar270
27TBD30ALE: Conversion rules for IDoc segments9SEGTYPSegment typenvarchar270
28TBDSSMapping of Segments to DDIC Structures1SEGTYPSegment typenvarchar270
29VIEWSYNSyntax description for views3SEGTYPSegment typenvarchar270
TOPData Collection
30MCSLISEFLIS Inbound Interface: Control Information (Fields)2SEGTYPLIS-E: name of segment type in EDI-IDoc objectnvarchar270
31MCSLISEHLIS Inbound Interface: Control Information (Headers)2SEGTYPLIS-E: name of segment type in EDI-IDoc objectnvarchar270
32MCSLISEHTLIS Inbound Interface: Control Information (H): Texts2SEGTYPLIS-E: name of segment type in EDI-IDoc objectnvarchar270
TOPIncentive and Commission Management ICM
33CACS_SEGAGRAgreement for The Assignment of Segments5SEGTYPSegment Typenvarchar40
34CACS_SEGMNTSegment3SEGTYPSegment Typenvarchar40
35CACS_SEGMNTTSegment: Text4SEGTYPSegment Typenvarchar40
36TCACS_ASGRLAssignment Role for Segment Assignment6SEGTYPSegment Typenvarchar40
37TCACS_SEGTYPIFBA: Segment Type3SEGTYPSegment Typenvarchar40
38TCACS_SEGTYPTIFBA: Segment Type Texts4SEGTYPSegment Typenvarchar40
TOPIntegration Server
39IDXLNKOBJIDoc Adapter Link Segment Fields for Port4SEGTYPSegment typenvarchar270
40IDXMDMPLANGUMDMP: IDoc type with language field2SEGTYPSegment typenvarchar270