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

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_A_1_TYPEType Pool Information Table(CMIS)31IDATESelection screen generation: Datenvarchar80
2P2RP_DAHR-PT: Payroll Results: Disability12IDATEDate when disability document was issuednvarchar80
3T7OM13Visa Information12IDATEDate of issue for personal IDnvarchar80
4T7QA63Visa Information12IDATEDate of issue for personal IDnvarchar80
5T7SA47Visa Information12IDATEDate of issue for personal IDnvarchar80
TOPBelgium
6T5BDRDeductions codes for DMFA7IDATEBegin date of deduction entitlement needed in DMFAnvarchar10
TOPBusiness Partner
7FSBP_BP3000_10_SStatus Tab. for Conversion Report FSBP_FTBU_BP3000_TO_BP30104IDATEDate data element for SYSTnvarchar80
TOPCATT Computer Aided Test Tool
8CAT_DP_FLDExport fields for DataProvider7IDATECharacter field of length 40nvarchar400
TOPClientServer Technology
9REPOSRCReport Source Code29IDATESelection screen generation: Datenvarchar80
TOPeCATT Extended Computer Aided Test Tool
10ECSCR_TFLDeCATT - TCD Data Provider Data DP_FLD Export Data9IDATECharacter field of length 40nvarchar400
TOPF4 Help
11DDF4GPManagement data, generated programs for F4 help2IDATEnvarchar80
TOPFrance
12PA0424Industrial accident / maternity / sickness statement (FR)25IDATEDate of accidentnvarchar80
TOPGreat Britain
13PA0070HR Master Record: Infotype 0070 (Court Orders - GB)35IDATECourt Order/Student Loan Issued or Received onnvarchar80
TOPKorea
14PA0557HR Master Record: Infotype 055730IDATEIssuing date of IDnvarchar80
TOPMeasurement System
15GHO_IMRG_EXTExtension Table for IMRG (Measurement Document)7IDATEDate of the Measurementnvarchar80
TOPMeasuring Points and Counters
16IMRGMeasurement Document4IDATEDate of the Measurementnvarchar80
17IMTRTermination of MeasRead. Data Transfer to Measuring Points2IDATEDate of the Measurementnvarchar80
TOPMobile Maintenance
18/ISDFPS/PMMEPOMobile Measurement Recording: Download Start for Meas.Docs3IDATEDate of the Measurementnvarchar80
TOPOnline Text Repository
19OTR_COMMOTR: Comment for Concept5IDATEDatenvarchar80
TOPPersonnel Administration
20PA0255HR master record Infotype 0082 (Additional absence data)28IDATEDate of illnessnvarchar80
TOPPersonnel Time Management
21PA0082HR Master Record: Infotype 0082 (Additional Absence Data)28IDATEDate of illnessnvarchar80
TOPPortugal
22PA0333HR Master Record: Infotype 0333 (Challenge - P)28IDATEDate when disability document was issuednvarchar80
TOPTakeoverHandover of Technical Objects
23PHINTPhase In Table7IDATEInstallation Date (UTC Timestamp)decimal150
TOPTour Status
24/DSD/ST_STATUSCurrent tour status18IDATEDate on Which Record Was Creatednvarchar80
25/DSD/ST_STATUS_HTour status history - Recording tour status5IDATEDate on Which Record Was Creatednvarchar80
TOPTraders and Schedulers Workbench
26OIJNOMCOIL-TSW: Nomination copy table7IDATEScheduled datenvarchar80
27OIJNOMINomination Item7IDATEScheduled datenvarchar80
28OIJNOMIVERSNomination Item Version Table9IDATEScheduled datenvarchar80
29OIJ_EL_DOC_I_REFDocument item reference to nomination16IDATEScheduled datenvarchar80
30OIJ_SCHEDPlanned Schedule Lines58IDATEScheduled datenvarchar80
TOPTranslation Tools
31APP_FCTRApplication ID Node Number5IDATEDatenvarchar80
32DEVC_APPDevelopment Class Within the Application Hierarchy6IDATEDatenvarchar80
33DEVC_APXChanges Within the Translation Hierarchy (DEVC_APP)2IDATEDatenvarchar80
34TRMCOMRemark Table for the Proposal Pool13IDATEDatenvarchar80
35TRMINTLink Table of Proposal Pool19IDATEDatenvarchar80
36TRMTRALink Table of Proposal Pool19IDATEDatenvarchar80
37TRMWRKAdministration of Worklists for the Proposal Pool11IDATEDatenvarchar80
TOPWork Clearance Management
38WCAAPWCM: Application69IDATEIssuednvarchar80