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

26 columns | Print definition?ERP 6.0  | FAX

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_STG_LIFTable: Staging data - Vendor master for ICC18FAXFax Numbernvarchar310
2/OTTM/OCR_T_OCICInput Channels for OCR6FAXInput Channel Type: Faxnvarchar10
3/XLSO/PREF_COMMTable to maintain preferred communication for user4FAXBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
4BBP_SUS_STG_FAXStaging address table7FAXFax number: dialling code+numbernvarchar300
5HRP1933DB Table for Infotype 193323FAXUCAS: Referee's Fax Numbernvarchar350
6J_1UF_TP_MAINMain Information of Notification13FAXFAX numbernvarchar300
7T5FADRAddresses for legal reporting8FAXFax addressnvarchar200
8T7BREFD_ERCNTCContact of person responsible for information9FAXFax numbernvarchar120
9T7BRERCONTACTCompany contact table9FAXSIP: faxnvarchar120
10T7PIQ_GB_SCHOOLUCAS: Schools39FAXFax Numbernvarchar250
11T7PIQ_NL_INSTITInstitutes and Education Details25FAXFax number: dialling code+numbernvarchar300
TOPAlert Framework
12SALRTDLVRYAlert Assignment (Personalization)20FAXSingle-Character Indicatornvarchar10
TOPDownloadUpload
13/DSD/HH_RACADDSD Route Settlement: Customer Address Data (One-Time Only)12FAXFax Numbernvarchar310
TOPEmployee Interaction Center
14THREIC_CONTACTEIC Contact11FAXFirst fax no.: dialling code+numbernvarchar300
TOPFunctions for U.S. Federal Government
15FMCCRTVENDORPOCCCR Vendor Points of Contact17FAXnvarchar300
TOPGermany
16T5D4X_ZERTRCertificate Request - Admin. Contrib. Statmt Certificates19FAXText field length 14nvarchar140
TOPLocations Location Structure
17EHFNDD_LOC_REVLocation - Revisions32FAXFax Numbernvarchar300
TOPMonitoring
18ALXMBEMAILCCMS: Registration of E-Mail Recipients for Alerts7FAXCCMS: Message Type Activation Faxnvarchar10
TOPPayroll
19T7ROG1EE register - ER history21FAXChar 20nvarchar200
20T7ROG5EE register - ER history25FAXnvarchar200
TOPPerformance Assessment Workbench
21SLS_CONTACPAW - Contact Data of Location10FAXFax number (PAW)nvarchar400
TOPPersonnel Administration
22T7GR4CMPCompany Elements12FAXTelefaxnvarchar300
TOPSpain
23T5E12Assignment of Social Insurance center15FAXRED system: Fax numbernvarchar120
TOPTravel Planning
24FTPT_HOTEL_DATAHotel Data17FAXFax Numbernvarchar400
25TA21PHCustomer-Specific Hotel Catalog15FAXHotel: Fax Numbernvarchar140
26TA23HOTELSHotel Data17FAXFax Numbernvarchar400