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  | TBTCP
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.0TBTCP713Background Job Step OverviewBackground Processing
SQL:  selectupdate insert create

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

SELECT JOBNAME, JOBCOUNT, STEPCOUNT, PROGNAME, PROGFROMLN, PROGTOLN, SDLDATE, SDLTIME, SDLUNAME, VARIANT, AUTHCKNAM, LISTIDENT, XPGPID, XPGTGTSYS, XPGRFCDEST, XPGPROG, XPGPARAMS, XPGFLAG, CONNCNTL, STDINCNTL, STDOUTCNTL, STDERRCNTL, TRACECNTL, TERMCNTL, STATUS, EXITCODE, LANGUAGE, EXTCMD, OPSYSTEM, PDEST, PRCOP, PLIST, PRTXT, PRIMM, PRREL, PRNEW, PEXPI, LINCT, LINSZ, PAART, PRBIG, PRSAP, PRREC, PRABT, PRBER, PRDSN, PTYPE, ARMOD, FOOTL, PRCHK, SAP_OBJECT, AR_OBJECT, ARCHIV_ID, DOC_TYPE, RPC_HOST, RPC_SERVIC, INTERFACE, MANDANT, REPORT, INFO, ARCTEXT, DATUM, ARCUSER, PRINTER, FORMULAR, ARCHIVPATH, PROTOKOLL, VERSION, ACHECK, PRIPARKEY, CONVID FROM TBTCP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1JOBNAMEBackground job namenvarchar320CHAR(N' ')NoBTCJOB Allow NULL? 
2JOBCOUNTJob IDnvarchar80CHAR(N' ')NoBTCJOBCNT Allow NULL? 
3STEPCOUNTJob step ID number.int100INT4((0))NoBTCSTEPCNT Allow NULL? 
4PROGNAMEProgram name within a step (e.g. report)nvarchar400CHAR(N' ')YesBTCPROG Allow NULL? 
5PROGFROMLNLine number in an internal report.int100INT4((0))YesBTCSRCLINE Allow NULL? 
6PROGTOLNLine number in an internal report.int100INT4((0))YesBTCSRCLINE Allow NULL? 
7SDLDATEDate of job/step schedulingnvarchar80DATS(N'00000000')YesBTCSDLDATE Allow NULL? 
8SDLTIMETime of a scheduled job/stepnvarchar60TIMS(N'000000')YesBTCSDLTIME Allow NULL? 
9SDLUNAMEInitiator of job/step schedulingnvarchar120CHAR(N' ')YesBTCSDLNM Allow NULL? 
10VARIANTName of variant within a stepnvarchar140CHAR(N' ')YesBTCVARIANT Allow NULL? 
11AUTHCKNAMBackground User Name for Authorization Checknvarchar120CHAR(N' ')YesBTCAUTHNAM Allow NULL? 
12LISTIDENTID of batch job output list in the spoolnvarchar100NUMC(N'0000000000')YesBTCLISTID Allow NULL? 
13XPGPIDID of external programnvarchar100CHAR(N' ')YesBTCXPGPID Allow NULL? 
14XPGTGTSYSTarget System to Run Background Jobnvarchar320CHAR(N' ')YesBTCTGTSYS Allow NULL? 
15XPGRFCDESTLogical Destination (Specified in Function Call)nvarchar320CHAR(N' ')Yes*RFCDEST Allow NULL? 
16XPGPROGName of external program (possibly with access path)nvarchar1280CHAR(N' ')YesBTCXPGPGM Allow NULL? 
17XPGPARAMSParameters of external program (string)nvarchar2550CHAR(N' ')YesBTCXPGPAR Allow NULL? 
18XPGFLAGIdentification of step as ABAP, ext. command or programchar10CHAR(N' ')YesBTCSTEPTYP Allow NULL? 
19CONNCNTLControl flag for external program (e.g. trace level)char10CHAR(N' ')YesBTCXPGCNTL Allow NULL? 
20STDINCNTLControl flag for external program (e.g. trace level)char10CHAR(N' ')YesBTCXPGCNTL Allow NULL? 
21STDOUTCNTLControl flag for external program (e.g. trace level)char10CHAR(N' ')YesBTCXPGCNTL Allow NULL? 
22STDERRCNTLControl flag for external program (e.g. trace level)char10CHAR(N' ')YesBTCXPGCNTL Allow NULL? 
23TRACECNTLControl flag for external program (e.g. trace level)char10CHAR(N' ')YesBTCXPGCNTL Allow NULL? 
24TERMCNTLControl flag for external program (e.g. trace level)char10CHAR(N' ')YesBTCXPGCNTL Allow NULL? 
25STATUSStatus of step in background processingchar10CHAR(N' ')YesBTCPSTATUS Allow NULL? 
26EXITCODEExit code of an external programint100INT4((0))YesBTCXPGEXIT Allow NULL? 
27LANGUAGELanguage Keychar10LANG(N' ')Yes*SPRAS Allow NULL? 
28EXTCMDName of Logical Commandnvarchar180CHAR(N' ')YesSXPGLOGCMD Allow NULL? 
29OPSYSTEMOperating System of Application Servernvarchar100CHAR(N' ')YesSYOPSYS Allow NULL? 
30PDESTSpool Output Devicenvarchar40CHAR(N' ')Yes*SYPDEST Allow NULL? 
31PRCOPNumber of Spool Copiesnvarchar30NUMC(N'000')YesSYPRCOP Allow NULL? 
32PLISTSpool Requestnvarchar120CHAR(N' ')YesSYPLIST Allow NULL? 
33PRTXTSpool Descriptionnvarchar680CHAR(N' ')YesSYPRTXT Allow NULL? 
34PRIMMImmediate Spool Printchar10CHAR(N' ')YesSYPRIMM Allow NULL? 
35PRRELImmediate Spool Deletionchar10CHAR(N' ')YesSYPRREL Allow NULL? 
36PRNEWNew Spool Requestchar10CHAR(N' ')YesSYPRNEW Allow NULL? 
37PEXPISpool Retention Periodchar10NUMC(N'0')YesSYPEXPI Allow NULL? 
38LINCTPage Length of Listint100INT4((0))YesSYLINCT Allow NULL? 
39LINSZLine width of listint100INT4((0))YesSYLINSZ Allow NULL? 
40PAARTSpool Formatnvarchar160CHAR(N' ')Yes*SYPAART Allow NULL? 
41PRBIGSpool Cover Sheetchar10CHAR(N' ')YesSYPRBIG Allow NULL? 
42PRSAPPrint: SAP cover pagechar10CHAR(N' ')YesSYPRSAP Allow NULL? 
43PRRECSpool Recipient Namenvarchar120CHAR(N' ')YesSYPRREC Allow NULL? 
44PRABTSpool Department Namenvarchar120CHAR(N' ')YesSYPRABT Allow NULL? 
45PRBERPrint: Authorizationnvarchar120CHAR(N' ')YesSYPRBER Allow NULL? 
46PRDSNSpool Filenvarchar60CHAR(N' ')YesSYPRDSN Allow NULL? 
47PTYPEPrint: Type of spool requestnvarchar120CHAR(N' ')YesSYPTYPE Allow NULL? 
48ARMODPrint: Archiving modechar10CHAR(N' ')YesSYARMOD Allow NULL? 
49FOOTLPrint: Output footerchar10CHAR(N' ')YesSYFOOTL Allow NULL? 
50PRCHKPrint: Check sum for print and archiving parametersint100INT4((0))YesSYCHECK Allow NULL? 
51SAP_OBJECTArchiving Parameter: Object Type of SAP Objectnvarchar100CHAR(N' ')Yes*SYARC_SAP_OBJECT Allow NULL? 
52AR_OBJECTArchiving Parameter: Document Typenvarchar100CHAR(N' ')Yes*SYARC_AR_OBJECT Allow NULL? 
53ARCHIV_IDArchiving Parameter: Target Storage Systemnvarchar20CHAR(N' ')YesSYARC_ARCHIV_ID Allow NULL? 
54DOC_TYPEArchiving Parameter: Document Typenvarchar200CHAR(N' ')Yes*SYARC_DOC_TYPE Allow NULL? 
55RPC_HOSTArchiving Parameter: RPC Hostnvarchar320CHAR(N' ')YesSYARC_RPC_HOST Allow NULL? 
56RPC_SERVICArchiving Parameter: RPC Service/RFC Destinationnvarchar320CHAR(N' ')YesSYARC_RPC_SERVIC Allow NULL? 
57INTERFACEArchiving Parameter: Communication Connection Componentnvarchar140CHAR(N' ')YesSYARC_INTERFACE Allow NULL? 
58MANDANTArchiving Parameter: Clientnvarchar30CLNT(N'000')Yes*SYARC_MANDANT Allow NULL? 
59REPORTArchiving Parameter: Program Namenvarchar400CHAR(N' ')Yes*SYARC_REPORT Allow NULL? 
60INFOArchiving Parameter: Info Fieldnvarchar30CHAR(N' ')YesSYARC_INFO Allow NULL? 
61ARCTEXTArchiving Parameter: Text Information Fieldnvarchar400CHAR(N' ')YesSYARC_ARCTEXT Allow NULL? 
62DATUMArchiving Parameter: Archiving Datenvarchar80CHAR(N' ')YesSYARC_DATUM Allow NULL? 
63ARCUSERArchiving Parameter: Usernvarchar120CHAR(N' ')YesSYARC_ARCUSER Allow NULL? 
64PRINTERArchiving Parameter: Target Output Devicenvarchar40CHAR(N' ')Yes*SYARC_PRINTER Allow NULL? 
65FORMULARArchiving Parameter: Output Formatnvarchar160CHAR(N' ')YesSYARC_FORMULAR Allow NULL? 
66ARCHIVPATHArchiving Parameter: Standard Pathnvarchar700CHAR(N' ')YesSYARC_ARCHIVPATH Allow NULL? 
67PROTOKOLLArchiving Parameter: Lognvarchar80CHAR(N' ')YesSYARC_PROTOKOLL Allow NULL? 
68VERSIONArchiving Parameter: Version Numbernvarchar40CHAR(N' ')YesSYARC_VERSION Allow NULL? 
69ACHECKArchiving Parameter: Check Totalint100INT4((0))YesSYARC_CHECK Allow NULL? 
70PRIPARKEYKey for print parametersnvarchar160CHAR(N' ')YesSYPRKEY Allow NULL? 
71CONVIDConversation IDnvarchar80CHAR(N' ')YesGWY_CONVID Allow NULL? 
NamePrimaryUniqueTypeColumns
TBTCP~0YesYesCLUSTEREDSTEPCOUNT, JOBCOUNT, JOBNAME
TBTCP~1NoNoNONCLUSTEREDVARIANT, PROGNAME
TBTCP~2NoNoNONCLUSTEREDXPGPROG

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