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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

30 columns | Print definition?ERP 6.0  | CHANGE_TIMESTAMP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OTTM/BL_T_ERAE-Receipt assignments12CHANGE_TIMESTAMPTimestamp of last changenvarchar140
2NHCF_QUEUE_MAPIS-H: Map SOA Event Sequence ID to IS-H Business Object4CHANGE_TIMESTAMPTime Stamp for Change (UTC)decimal150
3SRT_UDS_CONFIGUser defined search: config with only one table layout10CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPAccounting Interface
4ACI_TECS_IF_GENAdministration Information for Generation6CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPCommunication
5NHCF_EVENTIS-H: HCF: Triggered Unprocessed Events20CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPHR Administrative Services
6T5ASRSTEPDETAILSStep Details of Process7CHANGE_TIMESTAMPUTC Change Time Stamp of Process Stepdecimal150
TOPInformation Retention Manager
7SILM_VIEWView Definition: Header8CHANGE_TIMESTAMPTime Stamp - Last Changed on/atdecimal150
TOPOwnership
8GHO_OWN_DOI_HDRDOI Header Details14CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPPersonnel Time Management
9PA0439HR Master Record for Infotype 0439 (Data Transfer)33CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPRecords and Case Management
10RMPSDOD_RBASEHISTNA: Historical Data Disposal Schedules3CHANGE_TIMESTAMPLast Changed Ondecimal150
11RMPSPRO_RBASEHISHistorical Data Disposal Schedules3CHANGE_TIMESTAMPLast Changed Ondecimal150
12RMPSPRO_RBASMHISHistorical Data: Multistage Disposal Rules4CHANGE_TIMESTAMPLast Changed Ondecimal150
13RMPSTNA_RBASEHISTNA: Historical Data Disposal Schedules3CHANGE_TIMESTAMPLast Changed Ondecimal150
TOPRoyalty Reporting
14OIUREPP_LEASEMMS-2014 - Lease PPA19CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
15OIUREPP_OWNERMMS-2014 - Owner PPA13CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
16OIUREPP_PRPAYXRFMMS-2014 - Property / Payor XRef PPA14CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
17OIUREPP_SALETYPEMMS-2014 - Sales Type PPA20CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
18OIUREPP_WCPAYXRFMMS-2014 - Well Completion / Payor XRef PPA13CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
19OIUREP_LEASEMMS-2014 - Lease19CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
20OIUREP_MMS_REJSMMS-2014 - Extraction Rejects93CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
21OIUREP_MRT_CREDMMS-2014: Credits Against Monthly Report10CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
22OIUREP_OWNERMMS-2014 - Owner13CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
23OIUREP_PRPAYXREFMMS-2014 - Property / Payor XRef14CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
24OIUREP_RECOUPMMS-2014 - Recoupable Balance10CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
25OIUREP_RTPENDMMS-2014 - Royalty Transaction Pending92CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
26OIUREP_RT_HISTMMS-2014 - Royalty Transaction (Pending) History92CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
27OIUREP_SALESTYPEMMS-2014 - Sales Type20CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
28OIUREP_WCPAYXREFMMS-2014 - Well Completion / Payor XRef13CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPWeb Dynpro ALV for ABAP
29SALV_CSQ_PARAMSParameters for ALV runtime8CHANGE_TIMESTAMPUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
30SALV_CSQ_TR_HEADTrace heads19CHANGE_TIMESTAMPUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217