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  | IWEXDONE
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
Knowledge Management :: Knowledge Warehouse
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0IWEXDONE441KEn: Html Export HistoryKnowledge Warehouse
SQL:  selectupdate insert create

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

SELECT EXP_ID, F_CLASS, F_OBJID, F_NAME, F_TITLE, S_CLASS, S_OBJID, S_NAME, S_TITLE, RELEASE, LANGU, IND_ID, IND_REL, ORG_LANGU, RESP, AREA, COMPONENT, DELIVERY, EXP_TYPE, PRIO, OPT_ID, DEST_ID, PROC_ID, STATUS, I_DATE, I_TIME, A_DATE, A_TIME, W_DATE, W_TIME, X_DATE, X_TIME, C_DATE, C_TIME, Y_DATE, Y_TIME, F_DATE, F_TIME, A_ERRORS, A_WARNINGS, ERRORS, WARNINGS, JOBCOUNT, RFCCALLS FROM IWEXDONE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1EXP_IDHTML Export IDnvarchar100NUMC(N'0000000000')NoIWEXEXPID Allow NULL? 
2F_CLASSClass of logical documentnvarchar100CHAR(N' ')Yes*SDOK_LOCL Allow NULL? 
3F_OBJIDLogical documentnvarchar320CHAR(N' ')YesSDOK_LOID Allow NULL? 
4F_NAMETechnical name of an information objectnvarchar400CHAR(N' ')YesIW_TECNAME Allow NULL? 
5F_TITLETitlenvarchar640CHAR(N' ')YesIWTITLE Allow NULL? 
6S_CLASSClass of logical documentnvarchar100CHAR(N' ')Yes*SDOK_LOCL Allow NULL? 
7S_OBJIDLogical documentnvarchar320CHAR(N' ')YesSDOK_LOID Allow NULL? 
8S_NAMETechnical name of an information objectnvarchar400CHAR(N' ')YesIW_TECNAME Allow NULL? 
9S_TITLETitlenvarchar640CHAR(N' ')YesIWTITLE Allow NULL? 
10RELEASERelease of SAP Systemnvarchar120CHAR(N' ')Yes*IW_RELEASE Allow NULL? 
11LANGUTranslation Source Languagechar10LANG(N' ')Yes*IWSRCLAN Allow NULL? 
12IND_IDEnhancementnvarchar100CHAR(N' ')Yes*IWEXTID Allow NULL? 
13IND_RELEnhancement Releasenvarchar120CHAR(N' ')Yes*IWEXTREL Allow NULL? 
14ORG_LANGUOriginal languagechar10LANG(N' ')Yes*IW_OR_LANG Allow NULL? 
15RESPPerson Responsiblenvarchar300CHAR(N' ')YesIWRESPOND Allow NULL? 
16AREAArea (Technical Name)nvarchar100CHAR(N' ')Yes*IW_AREA Allow NULL? 
17COMPONENTApplication component IDnvarchar240CHAR(N' ')YesUFPS_POSID Allow NULL? 
18DELIVERYProductive folderchar10CHAR(N' ')YesIWDELIVER Allow NULL? 
19EXP_TYPEHTML export typechar10CHAR(N' ')YesIWEXEXTYP Allow NULL? 
20PRIOPrioritychar10CHAR(N' ')YesIW_PRIO Allow NULL? 
21OPT_IDHTML export option IDnvarchar30NUMC(N'000')YesIWEXOID Allow NULL? 
22DEST_IDHTML export destination IDnvarchar30NUMC(N'000')YesIWEXDID Allow NULL? 
23PROC_IDHTML export server process IDnvarchar100NUMC(N'0000000000')YesIWEXPID Allow NULL? 
24STATUSHTML export statuschar10CHAR(N' ')YesIWEXSTAT Allow NULL? 
25I_DATEDate of initializationnvarchar80DATS(N'00000000')YesIWEXIDATE Allow NULL? 
26I_TIMETime of initializationnvarchar60TIMS(N'000000')YesIWEXITIME Allow NULL? 
27A_DATEDate analysisnvarchar80DATS(N'00000000')YesIWEXADATE Allow NULL? 
28A_TIMETime analysisnvarchar60TIMS(N'000000')YesIWEXATIME Allow NULL? 
29W_DATEDate of waitnvarchar80DATS(N'00000000')YesIWEXWDATE Allow NULL? 
30W_TIMETime of waitnvarchar60TIMS(N'000000')YesIWEXWTIME Allow NULL? 
31X_DATEDate of exportnvarchar80DATS(N'00000000')YesIWEXXDATE Allow NULL? 
32X_TIMEExport timenvarchar60TIMS(N'000000')YesIWEXXTIME Allow NULL? 
33C_DATEDate of compilationnvarchar80DATS(N'00000000')YesIWEXCDATE Allow NULL? 
34C_TIMETime of compilationnvarchar60TIMS(N'000000')YesIWEXCTIME Allow NULL? 
35Y_DATEDate of copynvarchar80DATS(N'00000000')YesIWEXYDATE Allow NULL? 
36Y_TIMETime of copynvarchar60TIMS(N'000000')YesIWEXYTIME Allow NULL? 
37F_DATEDate finishednvarchar80DATS(N'00000000')YesIWEXFDATE Allow NULL? 
38F_TIMETime finishednvarchar60TIMS(N'000000')YesIWEXFTIME Allow NULL? 
39A_ERRORSNumber of errorsnvarchar100NUMC(N'0000000000')YesIW_NOERRS Allow NULL? 
40A_WARNINGSNumber of warning messagesnvarchar100NUMC(N'0000000000')YesIW_NOWRNGS Allow NULL? 
41ERRORSNumber of errorsnvarchar100NUMC(N'0000000000')YesIW_NOERRS Allow NULL? 
42WARNINGSNumber of warning messagesnvarchar100NUMC(N'0000000000')YesIW_NOWRNGS Allow NULL? 
43JOBCOUNTJob IDnvarchar80CHAR(N' ')YesBTCJOBCNT Allow NULL? 
44RFCCALLSCounter for RFC Callsnvarchar30NUMC(N'000')YesIW_RFCCALLS Allow NULL? 
NamePrimaryUniqueTypeColumns
IWEXDONE~0YesYesCLUSTEREDEXP_ID

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