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  | PLATFORM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BLEND1checked combinations opsys and blended codepage1PLATFORMSYSTEM: operating system + releasenvarchar160
2CLB2C_APPL_DATACollaboration: Application Settings for a Target Server4PLATFORMCollaboration Platform ID (Server)nvarchar300
3CLB2C_APPL_PLATFCollaboration Platform: Application-specific Settings4PLATFORMCollaboration Platform ID (Server)nvarchar300
4CLB2C_PLATFCollaboration: Server Communication Settings3PLATFORMCollaboration Platform ID (Server)nvarchar300
5CLB2C_PLATF_AUTHCollaboration: Authentication Method for a Context3PLATFORMCollaboration Platform ID (Server)nvarchar300
6CLB2C_PLATF_DEFCollaboration: Target Platform / Server2PLATFORMCollaboration Platform ID (Server)nvarchar300
7CLB2C_PLATF_DEFTCollaboration: Target Platform / Server (Description)3PLATFORMCollaboration Platform ID (Server)nvarchar300
8CLB2C_PLATF_METHCollaboration: Valid Method Versions of a Server2PLATFORMCollaboration Platform ID (Server)nvarchar300
9CLB2D_SESSIONPlatform Session Mapping5PLATFORMCollaboration Platform ID (Server)nvarchar300
10CLB2D_TOKENOAuth Access Data for User5PLATFORMCollaboration Platform ID (Server)nvarchar300
11ESH_OM_ALCONFLayout Configurations5PLATFORMPlatformnvarchar100
12ESH_OM_CLCONFLayout Configurations5PLATFORMPlatformnvarchar100
13ESH_OM_ILCONFLayout Configurations5PLATFORMPlatformnvarchar100
14LOCINFOOS dependent locale information.1PLATFORMSYSTEM: operating system + releasenvarchar160
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
15CRMCHKCSNShort Desc.: Related Ticket21PLATFORMPlatform-Dependency Templatenvarchar20
TOPATC extensions for Technical Check
16SATC_AC_RESULTVCResults of comparision with RefDB16PLATFORMnvarchar20
17SATC_AC_RESULTVRMovement data: 'Display Load' module verdicts40PLATFORMnvarchar20
TOPBusiness Consolidation
18UCM001CData Basis of Consolidation4PLATFORMPlatform of Consolidationnvarchar10
19UCM002CData Stream of Consolidation3PLATFORMPlatform of Consolidationnvarchar10
TOPClientServer Technology
20PATCHHISTHistory of Kernel Patch4PLATFORMOS type without release no. (or '*'): HP-UX, Windows NT, ...nvarchar100
TOPeCATT Extended Computer Aided Test Tool
21TZRR_RPATestZone Result Rep.: SUT Registered Problem Attributes10PLATFORMnvarchar10
TOPEnd User Technology
22RSPOR_T_PORTALConnected Portals16PLATFORMRuntime Platformnvarchar40
TOPF1 Help
23SHLPADM1Administration: Display of the SAP Library2PLATFORMPlatformnvarchar100
24SHLPADM2TText Table for Administration Online Help2PLATFORMPlatformnvarchar100
25SHLPUSRVALUser Settings for SAP Library (Display)2PLATFORMPlatformnvarchar100
26SLIBUVALUser Settings for SAP Library (Display)2PLATFORMPlatformnvarchar100
TOPGraphical User Interface
27CNTLSTRASCAdministration of components, A-LOBS (Ascii Large OBjectS)2PLATFORMCharacter field, 8 characters longnvarchar80
28CNTLSTREAMAdministration of components, BLOBS (Binary Large OBjectS)2PLATFORMCharacter field, 8 characters longnvarchar80
29CNTLSTRINFAttributes of a stream2PLATFORMCharacter field, 8 characters longnvarchar80
30CNTLSTRLISControl stream list2PLATFORMCharacter field, 8 characters longnvarchar80
TOPInternationalization I18N
31TCP0CLocale names for setting up C-libraries1PLATFORMSYSTEM: operating system + releasenvarchar160
TOPStreamWork ABAP Library
32CLBC_APPLI_DATACollaboration: Application Settings for a Target Server4PLATFORMCollaboration Platform ID (Server)nvarchar300
33CLBC_APPLI_PLATFCollaboration Platform: Application-specific Settings4PLATFORMCollaboration Platform ID (Server)nvarchar300
34CLBC_PLATFCollaboration: Server Communication Settings3PLATFORMCollaboration Platform ID (Server)nvarchar300
35CLBC_PLATF_AUTHCollaboration: Authentication Method for a Context3PLATFORMCollaboration Platform ID (Server)nvarchar300
36CLBC_PLATF_DEFCollaboration: Target Platform / Server2PLATFORMCollaboration Platform ID (Server)nvarchar300
37CLBC_PLATF_DEF_TCollaboration: Target Platform / Server (Description)3PLATFORMCollaboration Platform ID (Server)nvarchar300
38CLBC_PLATF_METHCollaboration Platform: Valid Method Versions2PLATFORMCollaboration Platform ID (Server)nvarchar300