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

Home | ERP 6.0  | FAVSELS
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
Basis Components :: Use Subcomponents :: Background Processing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FAVSELS472User-Specific Favorite Selection CriteriaBackground Processing
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT FAVNAME, CREATOR, CREADATE, CREATIME, JOBNAME, USERNAME, SELFAV, FROM_DATE, FROM_TIME, TO_DATE, TO_TIME, EVENTID, JOBID, OPMODEID, F_DATE_E, F_TIME_E, T_DATE_E, T_TIME_E, ST_ACTIVE, EN_ACTIVE, BE_ACTIVE, F_DATE_L, F_TIME_L, T_DATE_L, T_TIME_L, F_DATE_B, F_TIME_B, T_DATE_B, T_TIME_B, PRELIM, SCHEDUL, READY, RUNNING, FINISHED, ABORTED, DONTCARE, PERIOD, NON_PERD, NRMONTHS, NRWEEKS, NRDAYS, NRHOURS, NRMINUTES, ABAPNAME, EXTPROG, EXTCMD, AUTHCKNAM FROM FAVSELS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1FAVNAMEBackground job personalized selectionnvarchar320CHAR(N' ')NoBTCSELFAV Allow NULL? 
2CREATORUser Namenvarchar120CHAR(N' ')NoSYUNAME Allow NULL? 
3CREADATESystem Datenvarchar80DATS(N'00000000')YesSYDATUM Allow NULL? 
4CREATIMESystem Timenvarchar60TIMS(N'000000')YesSYUZEIT Allow NULL? 
5JOBNAMEBackground job namenvarchar320CHAR(N' ')YesBTCJOB Allow NULL? 
6USERNAMEInitiator of job/step schedulingnvarchar120CHAR(N' ')YesBTCSDLNM Allow NULL? 
7SELFAVBackground job personalized selectionnvarchar320CHAR(N' ')YesBTCSELFAV Allow NULL? 
8FROM_DATEPlanned Start Date for Background Jobnvarchar80DATS(N'00000000')YesBTCSDATE Allow NULL? 
9FROM_TIMEPlanned start time for background Jobnvarchar60TIMS(N'000000')YesBTCSTIME Allow NULL? 
10TO_DATEPlanned Start Date for Background Jobnvarchar80DATS(N'00000000')YesBTCSDATE Allow NULL? 
11TO_TIMEPlanned start time for background Jobnvarchar60TIMS(N'000000')YesBTCSTIME Allow NULL? 
12EVENTIDBackground Processing Eventnvarchar320CHAR(N' ')YesBTCEVENTID Allow NULL? 
13JOBIDBackground job namenvarchar320CHAR(N' ')YesBTCJOB Allow NULL? 
14OPMODEIDName of Operation Modenvarchar200CHAR(N' ')YesPFEBANAME Allow NULL? 
15F_DATE_EJob start datenvarchar80DATS(N'00000000')YesBTCXDATE Allow NULL? 
16F_TIME_EBatch job start timenvarchar60TIMS(N'000000')YesBTCXTIME Allow NULL? 
17T_DATE_EJob start datenvarchar80DATS(N'00000000')YesBTCXDATE Allow NULL? 
18T_TIME_EBatch job start timenvarchar60TIMS(N'000000')YesBTCXTIME Allow NULL? 
19ST_ACTIVEActive tab signalchar10CHAR(N' ')YesBTCACTIVE Allow NULL? 
20EN_ACTIVEActive tab signalchar10CHAR(N' ')YesBTCACTIVE Allow NULL? 
21BE_ACTIVEActive tab signalchar10CHAR(N' ')YesBTCACTIVE Allow NULL? 
22F_DATE_LJob start datenvarchar80DATS(N'00000000')YesBTCXDATE Allow NULL? 
23F_TIME_LBatch job start timenvarchar60TIMS(N'000000')YesBTCXTIME Allow NULL? 
24T_DATE_LJob start datenvarchar80DATS(N'00000000')YesBTCXDATE Allow NULL? 
25T_TIME_LBatch job start timenvarchar60TIMS(N'000000')YesBTCXTIME Allow NULL? 
26F_DATE_BJob start datenvarchar80DATS(N'00000000')YesBTCXDATE Allow NULL? 
27F_TIME_BBatch job start timenvarchar60TIMS(N'000000')YesBTCXTIME Allow NULL? 
28T_DATE_BJob start datenvarchar80DATS(N'00000000')YesBTCXDATE Allow NULL? 
29T_TIME_BBatch job start timenvarchar60TIMS(N'000000')YesBTCXTIME Allow NULL? 
30PRELIMState of Background Jobchar10CHAR(N' ')YesBTCSTATUS Allow NULL? 
31SCHEDULState of Background Jobchar10CHAR(N' ')YesBTCSTATUS Allow NULL? 
32READYState of Background Jobchar10CHAR(N' ')YesBTCSTATUS Allow NULL? 
33RUNNINGState of Background Jobchar10CHAR(N' ')YesBTCSTATUS Allow NULL? 
34FINISHEDState of Background Jobchar10CHAR(N' ')YesBTCSTATUS Allow NULL? 
35ABORTEDState of Background Jobchar10CHAR(N' ')YesBTCSTATUS Allow NULL? 
36DONTCAREselection flag for selection of periodical jobschar10CHAR(N' ')YesBTCPERIOD Allow NULL? 
37PERIODselection flag for selection of periodical jobschar10CHAR(N' ')YesBTCPERIOD Allow NULL? 
38NON_PERDselection flag for selection of periodical jobschar10CHAR(N' ')YesBTCPERIOD Allow NULL? 
39NRMONTHSDuration period (in months) for a batch jobnvarchar20NUMC(N'00')YesBTCPMNTH Allow NULL? 
40NRWEEKSDuration period (in weeks) for a batch jobnvarchar20NUMC(N'00')YesBTCPWEEK Allow NULL? 
41NRDAYSDuration (in days) of DBA actionnvarchar30NUMC(N'000')YesBTCPDAY Allow NULL? 
42NRHOURSDuration period (in hours) for a batch jobnvarchar20NUMC(N'00')YesBTCPHOUR Allow NULL? 
43NRMINUTESDuration period (in minutes) for a batch jobnvarchar20NUMC(N'00')YesBTCPMIN Allow NULL? 
44ABAPNAMEABAP Program Namenvarchar400CHAR(N' ')YesPROGNAME Allow NULL? 
45EXTPROGName of external program (possibly with access path)nvarchar1280CHAR(N' ')YesBTCXPGPGM Allow NULL? 
46EXTCMDName of Logical Commandnvarchar180CHAR(N' ')YesSXPGLOGCMD Allow NULL? 
47AUTHCKNAMBackground User Name for Authorization Checknvarchar120CHAR(N' ')YesBTCAUTHNAM Allow NULL? 
NamePrimaryUniqueTypeColumns
FAVSELS~0YesYesCLUSTEREDCREATOR, FAVNAME
FAVSELS~1NoNoNONCLUSTEREDCREATOR

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy