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  | N2FDBS
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
Industry Specific :: Clinical System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0N2FDBS381IS-H*MED: Catalog of external data modulesClinical System
SQL:  selectupdate insert create

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

SELECT MANDT, FDBSID, KURZTEXT, SCHLWORTE, FTOTEXT, FTOTAB, FTOEXP, FQUERY, FSAVREF, FGETREF, FFROMTEXT, FFROMTAB, FGETERR, FHELP_F4, FHELP_F1, FCHKVAL, F_XCODE, F_EODOK, FIXDENT, STRUCT, MULTIP, REFERENZ, VORBELEG, NOREFRET, AENDERN, HELPF4, LONGTRET, FUNCGR, DDSTRUK, REFTAB, PARSTR, PARAMSTR, FQPARAM, FFLUSH, QPEXTRA1, QPEXTRA2, INTERFVERS, FDELETE FROM N2FDBS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2FDBSIDPMD: Name of External Data Module (ID)nvarchar100CHAR(N' ')NoN2_FDBSID Allow NULL? 
3KURZTEXTShort Text for System Definition Objectsnvarchar500CHAR(N' ')YesN2_KURZTXT Allow NULL? 
4SCHLWORTEKeywords for Sysdef Objectsnvarchar800CHAR(N' ')YesN2_SCHLWRT Allow NULL? 
5FTOTEXTConvertToText Function Modulenvarchar300CHAR(N' ')YesN2_FTOTEXT Allow NULL? 
6FTOTABConvertToTab Function Modulenvarchar300CHAR(N' ')YesN2_FTOTAB Allow NULL? 
7FTOEXPConvertToExport Function Modulenvarchar300CHAR(N' ')YesN2_FTOEXP Allow NULL? 
8FQUERYQuery Function Modulenvarchar300CHAR(N' ')YesN2_FQUERY Allow NULL? 
9FSAVREFSave Function Modulenvarchar300CHAR(N' ')YesN2_FSAVREF Allow NULL? 
10FGETREFGET Function Modulenvarchar300CHAR(N' ')YesN2_FGETREF Allow NULL? 
11FFROMTEXTConvertFromText Function Modulenvarchar300CHAR(N' ')YesN2_FFROMTX Allow NULL? 
12FFROMTABConvertFromTab Function Modulenvarchar300CHAR(N' ')YesN2_FFROMTB Allow NULL? 
13FGETERRGetError Function Modulenvarchar300CHAR(N' ')YesN2_FGETERR Allow NULL? 
14FHELP_F4Help F4 Function Modulenvarchar300CHAR(N' ')YesN2_FHELPF4 Allow NULL? 
15FHELP_F1Help F1 Function Modulenvarchar300CHAR(N' ')YesN2_FHELPF1 Allow NULL? 
16FCHKVALCheckValue Function Modulenvarchar300CHAR(N' ')YesN2_FCHKVAL Allow NULL? 
17F_XCODEXCode Function Modulenvarchar300CHAR(N' ')YesN2_F_XCODE Allow NULL? 
18F_EODOKEnd-of-Document Function Modulenvarchar300CHAR(N' ')YesN2_F_EODOK Allow NULL? 
19FIXDENTExternal Data from "Fixed" Entitychar10CHAR(N' ')YesN2_FIXDENT Allow NULL? 
20STRUCTExternal Data Supply of a Structurechar10CHAR(N' ')YesN2_STRUCT Allow NULL? 
21MULTIPExternal Data Supply of a Multiple Structurechar10CHAR(N' ')YesN2_MULTIP Allow NULL? 
22REFERENZReference Modulechar10CHAR(N' ')YesN2_REFEREN Allow NULL? 
23VORBELEGDefault Modulechar10CHAR(N' ')YesN2_VORBELE Allow NULL? 
24NOREFRETNo Reference Key Returnedchar10CHAR(N' ')YesN2_NOREFRE Allow NULL? 
25AENDERNChange-Modulechar10CHAR(N' ')YesN2_AENDERN Allow NULL? 
26HELPF4F4 Help Modulechar10CHAR(N' ')YesN2_HELP_F4 Allow NULL? 
27LONGTRETLong Text Backchar10CHAR(N' ')YesN2_LTRET Allow NULL? 
28FUNCGRName of External Data Module's Function Groupnvarchar260CHAR(N' ')Yes*N2_FUNCGR Allow NULL? 
29DDSTRUKName of DD Structure for Multiple Ext. Datanvarchar300CHAR(N' ')Yes*N2_DDSTRUK Allow NULL? 
30REFTABReference Table for External Datanvarchar300CHAR(N' ')Yes*N2_REFTAB Allow NULL? 
31PARSTRParameter Structure for External Data Modulenvarchar300CHAR(N' ')Yes*N2_PARSTR Allow NULL? 
32PARAMSTRPMD: Fixed Parameters for Query Routinenvarchar650CHAR(N' ')YesN2_PARAMST Allow NULL? 
33FQPARAMParamString Function Modulenvarchar300CHAR(N' ')YesN2_FQPARAM Allow NULL? 
34FFLUSHFlush-Buffer Function Modulenvarchar300CHAR(N' ')YesN2_FFLUSH Allow NULL? 
35QPEXTRA1Further Query Parameters for External Data Modulenvarchar800CHAR(N' ')YesN2_QPEXTRA Allow NULL? 
36QPEXTRA2Further Query Parameters for External Data Modulenvarchar800CHAR(N' ')YesN2_QPEXTRA Allow NULL? 
37INTERFVERSExternal Data Module Interface Versionchar10CHAR(N' ')YesN2_FDBSINF Allow NULL? 
38FDELETEName of the deletion modulenvarchar300CHAR(N' ')Yes*N2_FDELETE Allow NULL? 
NamePrimaryUniqueTypeColumns
N2FDBS~0YesYesCLUSTEREDFDBSID, 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