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  | T685B
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
Sales and Distribution :: Basic Functions :: Output Determination
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T685B381Condition Types: Additional Data for Sending OutputOutput Determination
SQL:  selectupdate insert create

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

SELECT MANDT, KAPPL, KSCHL, PARAB, PRKEY, MAXTDNAME, VSZTP, NACHA, TXTFL, TPROG, TROUT, PPROG, PROUT, PARVW, ERLV1, ERLV2, ERLV3, ERLV4, KNZUG, NBEAR, MEHRF, TDARMOD, ARCOBJART, APROG, AROUT, OBJNAM, OBJPRI, OBJCP, FNDTIMPRG, FNDTIMRTN, NOPROG, SORTPRG, SORTRTN, NOPROTOCOL, SORT1, SORT2, SORT3, STRATEGY FROM T685B
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2KAPPLApplicationnvarchar20CHAR(N' ')NoT681ZKAPPL Allow NULL? 
3KSCHLOutput Typenvarchar40CHAR(N' ')NoT685NA_KSCHL Allow NULL? 
4PARABOutput independent of partnerchar10CHAR(N' ')NoNA_PARAB Allow NULL? 
5PRKEYSelection criteria for maintaining print parameterschar10CHAR(N' ')NoTNADPNA_PRKEY Allow NULL? 
6MAXTDNAMENamenvarchar700CHAR(N' ')NoTDOBNAME Allow NULL? 
7VSZTPDispatch timechar10CHAR(N' ')NoNA_VSZTP Allow NULL? 
8NACHAMessage transmission mediumchar10CHAR(N' ')NoNA_NACHA Allow NULL? 
9TXTFLCheckboxchar10CHAR(N' ')NoXFELD Allow NULL? 
10TPROGProgram for creating or changing an output textnvarchar400CHAR(N' ')NoTRDIRNA_TPROG Allow NULL? 
11TROUTName of routine to be called up in the processing programnvarchar300CHAR(N' ')NoNA_RONAM Allow NULL? 
12PPROGProgram for deriving action parametersnvarchar400CHAR(N' ')NoTRDIRNA_PPROG Allow NULL? 
13PROUTName of routine to be called up in the processing programnvarchar300CHAR(N' ')NoNA_RONAM Allow NULL? 
14PARVWPartner Functionnvarchar20CHAR(N' ')NoTPARPARVW Allow NULL? 
15ERLV1Timing 1 (periodic job) not allowedchar10CHAR(N' ')NoNA_ERLV1 Allow NULL? 
16ERLV2Timing 2 (job and time entry) not allowedchar10CHAR(N' ')NoNA_ERLV2 Allow NULL? 
17ERLV3Timing 3 (application transaction) not allowedchar10CHAR(N' ')NoNA_ERLV3 Allow NULL? 
18ERLV4Timing 4 (immediate) not allowedchar10CHAR(N' ')NoNA_ERLV4 Allow NULL? 
19KNZUGAccess to output conditionschar10CHAR(N' ')NoNA_KNZUG Allow NULL? 
20NBEAROutput cannot be changed manuallychar10CHAR(N' ')NoNA_NBEAR Allow NULL? 
21MEHRFMultiple issuing of outputchar10CHAR(N' ')NoNA_MEHRF Allow NULL? 
22TDARMODPrint: Archiving modechar10CHAR(N' ')NoSYARMOD Allow NULL? 
23ARCOBJARTDocument typenvarchar100CHAR(N' ')NoTOADVSAEOBJART Allow NULL? 
24APROGProgram for setting changed output indicatornvarchar400CHAR(N' ')NoTRDIRNA_APROG Allow NULL? 
25AROUTName of routine to be called up in the processing programnvarchar300CHAR(N' ')NoNA_RONAM Allow NULL? 
26OBJNAMName of document, folder or distribution listnvarchar120CHAR(N' ')NoSO_OBJ_NAM Allow NULL? 
27OBJPRIDocument prioritychar10CHAR(N' ')NoSO_OBJ_PRI Allow NULL? 
28OBJCPDocument cannot be changedchar10CHAR(N' ')NoSO_OBJ_CP Allow NULL? 
29FNDTIMPRGProgram for determining output timingnvarchar400CHAR(N' ')NoTRDIRNA_TIMPRG Allow NULL? 
30FNDTIMRTNFORM routine for time determinatn (using VSDAT VSURA VSURB)nvarchar300CHAR(N' ')NoNA_TIMRTN Allow NULL? 
31NOPROGNo processing program necessarychar10CHAR(N' ')NoNA_NOPROG Allow NULL? 
32SORTPRGProgram for determining sort criteria in output control rec.nvarchar400CHAR(N' ')NoTRDIRNA_SORTPRG Allow NULL? 
33SORTRTNFORM routine for determining sort crit. in output cont. recnvarchar300CHAR(N' ')NoNA_SORTRTN Allow NULL? 
34NOPROTOCOLWFMC: Flag: do not write a processing logchar10CHAR(N' ')YesNA_NOPROT Allow NULL? 
35SORT1WFMC: Field name in structurenvarchar610CHAR(N' ')YesNA_SORTFLD Allow NULL? 
36SORT2WFMC: Field name in structurenvarchar610CHAR(N' ')YesNA_SORTFLD Allow NULL? 
37SORT3WFMC: Field name in structurenvarchar610CHAR(N' ')YesNA_SORTFLD Allow NULL? 
38STRATEGYCommunication strategynvarchar40CHAR(N' ')YesTCSTRCSTRATEGY Allow NULL? 
NamePrimaryUniqueTypeColumns
T685B~0YesYesCLUSTEREDKSCHL, KAPPL, MANDT

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