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

18 columns | Print definition?ERP 6.0  | TEXTFIELD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRHAPCN_FPROPSField Properties9TEXTFIELDField Namenvarchar300
2T77UICONVTXTContent of a text fields3TEXTFIELDField Namenvarchar300
3T77UICONVTXTCContent of text fields, Customer Table3TEXTFIELDField Namenvarchar300
TOPAddress ManagementBusiness Address
4ADRSTRCONVConversion of Street Sections4TEXTFIELDText Field (Converted to Uppercase Letters)nvarchar400
TOPCross-Application Components
5/IXOS/DC_TADAAdministrator maintenance for Details18TEXTFIELDInfotext: Description fieldnvarchar300
6/IXOS/DC_TAIAAdministrator maintenance for Creating22TEXTFIELDInfotext: Description fieldnvarchar300
TOPMerchandise and Assortment Planning
7TWISPC_MTEXTRetail Planning: Customer-spec. Text Tables for Character.4TEXTFIELDText Field in Customer-Specific Text Tablenvarchar300
TOPPersonnel Administration
8T588AUTO_TEXTAssignment of Text Fields for Generic Text Reader2TEXTFIELDField Namenvarchar300
9T588AUTO_TEXTCAssignment of Text Fields for Generic Text Reader (Customer)2TEXTFIELDText Field in Screen Structurenvarchar300
10T588FIX_TEXTAssignment of Data Elements to Determine Fixed Texts2TEXTFIELDField Namenvarchar300
TOPProcess Controls
11GRPCRLCRARule Criteria Assignment13TEXTFIELDText Field - obsoletenvarchar300
TOPSAP Query
12TEXC_DEText ID: Exception Definiton using Data Element3TEXTFIELDField Namenvarchar300
13TEXC_DE_CText ID: Exception Definiton using Data Element3TEXTFIELDField Namenvarchar300
14TEXC_DOMText ID: Exception Definition using Domains3TEXTFIELDField Namenvarchar300
15TEXC_DOM_CText ID: Exception Definition using Domains3TEXTFIELDField Namenvarchar300
16TEXC_FLDText ID: Exception Definition using Table/Field4TEXTFIELDField Namenvarchar300
17TEXC_FLD_CText ID: Exception Definition using Table/Field4TEXTFIELDField Namenvarchar300
TOPSyntax, Compiler, Runtime
18ICONIcons table8TEXTFIELDIcon suitable key wordnvarchar10