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  | SOUD
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 :: Basis Services Communication Interfaces :: Use Subcomponents
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0SOUD1066SAPoffice: user definitionUse Subcomponents
SQL:  selectupdate insert create

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

SELECT MANDT, USRTP, USRYR, USRNO, CROTP, CROYR, CRONO, CRONAM, CRDAT, CRTIM, CHOTP, CHOYR, CHONO, CHONAM, CHDAT, CHTIM, SAPNAM, USRNAM, LOADAT, EXMAX, RCMAX, INMAX, USRAU, CRGDL, CRFCL, CRFCC, CRFPL, CRFDP, CRFAD, CRFGR, HOMAX, HOCNT, GLMAX, GFMAX, GFCNT, AUTEXT, NOTTP, CALEN, OUTFL, SQWIN, SYUSR, SYUSRINB, SYUSROUT, ADREXT, PRWYR, PRWNO, PUWYR, PUWNO, INBYR, INBNO, OUTYR, OUTNO, WSTYR, WSTNO, PFRYR, PFRNO, PDLYR, PDLNO, VORYR, VORNO, NOTYR, NOTNO, DELETED, RSWORKDAY, RSFACID, USRADR, LFDNR, SNDART, FLAG1, FLAG2, FLAG3, NATIO, LADAT, VLADAT, LASDAT, EXTTELE, EXTSMTP, EXTX400, EXTSAP, AREPYR, AREPNO, AREPABDAT, AREPAEDAT, FAXFORM, SCRFORM, CHATSEND, NOARSDEX, PRPARCHG, PRPARNDH, PRPARRCL, PRPARNOP, DELFORIB, GHRAWDOC, FOLDSORT, DELTRASH, RSDOCFOR, FOLASDYR, FOLASDNO, FOLLINYR, FOLLINNO, FOLCRDYR, FOLCRDNO, LINKDOYR, LINKDONO, NORTFEDIT, PCOLE FROM SOUD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2USRTPUser type from IDnvarchar30CHAR(N' ')NoTSOTDSO_USR_TP Allow NULL? 
3USRYRUser year from the IDnvarchar20CHAR(N' ')NoSO_USR_YR Allow NULL? 
4USRNOUser number from the IDnvarchar120CHAR(N' ')NoSO_USR_NO Allow NULL? 
5CROTPUser who created object: Object type from IDnvarchar30CHAR(N' ')YesTSOTDSO_CRO_TP Allow NULL? 
6CROYRUser that created object: year from the IDnvarchar20CHAR(N' ')YesSO_CRO_YR Allow NULL? 
7CRONOUser that created object: number from the IDnvarchar120CHAR(N' ')Yes*SO_CRO_NO Allow NULL? 
8CRONAMCreator Namenvarchar120CHAR(N' ')YesSO_CRO_NAM Allow NULL? 
9CRDATDate creatednvarchar80DATS(N'00000000')YesSO_DAT_CR Allow NULL? 
10CRTIMTime creatednvarchar60TIMS(N'000000')YesSO_TIM_CR Allow NULL? 
11CHOTPUser that changed the object: Object type from IDnvarchar30CHAR(N' ')YesTSOTDSO_CHO_TP Allow NULL? 
12CHOYRUser that changed the object: year from the IDnvarchar20CHAR(N' ')YesSO_CHO_YR Allow NULL? 
13CHONOUser that changed the object: number from the IDnvarchar120CHAR(N' ')Yes*SO_CHO_NO Allow NULL? 
14CHONAMChanged bynvarchar120CHAR(N' ')YesSO_CHO_NAM Allow NULL? 
15CHDATDate of Last Changenvarchar80DATS(N'00000000')YesSO_DAT_CH Allow NULL? 
16CHTIMTime of Last Changenvarchar60TIMS(N'000000')YesSO_TIM_CH Allow NULL? 
17SAPNAMSAP name of a SAPoffice usernvarchar120CHAR(N' ')YesSO_SAP_NAM Allow NULL? 
18USRNAMSAPoffice user namenvarchar120CHAR(N' ')YesSO_USR_NAM Allow NULL? 
19LOADATLast access to SAPoffice by usernvarchar80DATS(N'00000000')YesSO_DAT_LOA Allow NULL? 
20EXMAXMaximum number of express messages allowed per sendvarbinary20RAWYesSO_EXMAX
21RCMAXMaximum number of recipients allowed per sendvarbinary20RAWYesSO_RCMAX
22INMAXMaximum number of documents allowed in the inboxvarbinary20RAWYesSO_INMAX
23USRAUMaintain user: only the administrator is authorizedchar10CHAR(N' ')YesSO_USRAU Allow NULL? 
24CRGDLAuthorization to create shared distribution listschar10CHAR(N' ')YesSO_CRGDL Allow NULL? 
25CRFCLAuthorization to create client folderschar10CHAR(N' ')YesSO_CRFCL Allow NULL? 
26CRFCCAuthorization to create company-code-wide folderschar10CHAR(N' ')YesSO_CRFCC Allow NULL? 
27CRFPLAuthorization to create plant-wide folderschar10CHAR(N' ')YesSO_CRFPL Allow NULL? 
28CRFDPAuthorization to create department-wide folderschar10CHAR(N' ')YesSO_CRFDP Allow NULL? 
29CRFADAuthorization to create cost-center-wide folderschar10CHAR(N' ')YesSO_CRFAD Allow NULL? 
30CRFGRAuthorization to create group folderschar10CHAR(N' ')YesSO_CRFGR Allow NULL? 
31HOMAXMax. no. of documents a user can protect from archivingvarbinary10RAWYesSO_HOMAX
32HOCNTNumber of documents which should not be archivedvarbinary10RAWYesSO_HOCNT
33GLMAXMaximum size of the access lists of a uservarbinary10RAWYesSO_GLMAX
34GFMAXMax. number of group folders which a user can createvarbinary10RAWYesSO_GFMAX
35GFCNTNumber of group folders created by a uservarbinary10RAWYesSO_GFCNT
36AUTEXTAuthorization to send externallychar10CHAR(N' ')YesSO_AUT_EXT Allow NULL? 
37NOTTPDefault setting of document classnvarchar30CHAR(N' ')YesTSOTDSO_NOT_TP Allow NULL? 
38CALENDay on which the week beginschar10CHAR(N' ')YesSO_CALEN Allow NULL? 
39OUTFLDocuments are copied to the outbox when sentchar10CHAR(N' ')YesSO_OUTFL Allow NULL? 
40SQWINSwitch confirmation prompt on or off when deletingchar10CHAR(N' ')YesSO_SQWIN Allow NULL? 
41SYUSRYour user view is set when you start SAPofficechar10CHAR(N' ')YesSO_SYUSR Allow NULL? 
42SYUSRINBInbox filter (unviewed documents only)char10CHAR(N' ')YesSO_SYUSRIN Allow NULL? 
43SYUSROUTUser view of outboxchar10CHAR(N' ')YesSO_SYUSROU Allow NULL? 
44ADREXTThe user has an active external address.char10CHAR(N' ')YesSO_ADR_EXT Allow NULL? 
45PRWYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
46PRWNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
47PUWYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
48PUWNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
49INBYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
50INBNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
51OUTYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
52OUTNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
53WSTYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
54WSTNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
55PFRYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
56PFRNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
57PDLYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
58PDLNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
59VORYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
60VORNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
61NOTYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
62NOTNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
63DELETEDSAPoffice: Office user was deletedchar10CHAR(N' ')YesSO_USR_DEL Allow NULL? 
64RSWORKDAYResubmission on workdays onlychar10CHAR(N' ')YesSO_RSWD Allow NULL? 
65RSFACIDFactory calendar identification code for the resubmissionnvarchar20CHAR(N' ')YesTFACDSO_RSFACID Allow NULL? 
66USRADRSAP-Office keynvarchar100CHAR(N' ')YesAD_SO_KEY Allow NULL? 
67LFDNRAddresses: Sequence numbernvarchar30CHAR(N' ')YesSO_LFDNR Allow NULL? 
68SNDARTText field length 3: for use as requirednvarchar30CHAR(N' ')YesSO_TEXT003 Allow NULL? 
69FLAG1Text field length 1char10CHAR(N' ')YesSO_TEXT001 Allow NULL? 
70FLAG2Retain default document for entire sessionchar10CHAR(N' ')YesSO_STORE_I Allow NULL? 
71FLAG3Text field length 1char10CHAR(N' ')YesSO_TEXT001 Allow NULL? 
72NATIOSAPoffice: international code for character setchar10CHAR(N' ')Yes*SO_NATIO Allow NULL? 
73LADATDefault for last access date (last changed)nvarchar30NUMC(N'000')YesSO_DEF_LAD Allow NULL? 
74VLADATSecond last access of user to SAPofficenvarchar80DATS(N'00000000')YesSO_DAT_VLA Allow NULL? 
75LASDATLast access to SAPoffice by substitutenvarchar80DATS(N'00000000')YesSO_DAT_LAS Allow NULL? 
76EXTTELEAuthorization to send via telematic serviceschar10CHAR(N' ')YesSO_EXTTELE Allow NULL? 
77EXTSMTPAuthorization to send via the Internetchar10CHAR(N' ')YesSO_EXTSMTP Allow NULL? 
78EXTX400Authorization to send via X.400char10CHAR(N' ')YesSO_EXTX400 Allow NULL? 
79EXTSAPAuthorization to send within SAP system groupchar10CHAR(N' ')YesSO_EXTSAP Allow NULL? 
80AREPYRAutomatic reply: year from the IDnvarchar20CHAR(N' ')YesSO_AAN_YR Allow NULL? 
81AREPNOAutomatic reply: number from the IDnvarchar120CHAR(N' ')Yes*SO_AAN_NO Allow NULL? 
82AREPABDATDate from when the automatic reply is activenvarchar80DATS(N'00000000')YesSO_DAT_AB Allow NULL? 
83AREPAEDATDate up to which automatic reply is activenvarchar80DATS(N'00000000')YesSO_DAT_AE Allow NULL? 
84FAXFORMSAPoffice: User layout set name for faxingnvarchar160CHAR(N' ')YesSO_FAXFORM Allow NULL? 
85SCRFORMSAPoffice: User-defined standard SAPscript layout setnvarchar160CHAR(N' ')YesSO_SCRFORM Allow NULL? 
86CHATSENDChange options for document after sendingchar10CHAR(N' ')YesSO_CHATSEN Allow NULL? 
87NOARSDEXSend automatic reply externallychar10CHAR(N' ')YesSO_NOARSDE Allow NULL? 
88PRPARCHGDefault settings for calling print parameterschar10CHAR(N' ')YesSO_PRPARCH Allow NULL? 
89PRPARNDHDefault settings for printing of document headerchar10CHAR(N' ')YesSO_PRPANDH Allow NULL? 
90PRPARRCLDefault settings for printing of recipient listchar10CHAR(N' ')YesSO_PRPARRL Allow NULL? 
91PRPARNOPDefault settings for printing of noteschar10CHAR(N' ')YesSO_PRPARNP Allow NULL? 
92DELFORIBDelete document from inbox after forwardingchar10CHAR(N' ')YesSO_DELFOIB Allow NULL? 
93GHRAWDOCDisplay of document header in continuos-text editorchar10CHAR(N' ')YesSO_GHRAWDO Allow NULL? 
94FOLDSORTSetting for sorting folders subscribed tochar10CHAR(N' ')YesSO_FOLSORT Allow NULL? 
95DELTRASHNo. of calendar days after which doc. is deleted from trashnvarchar30CHAR(N' ')YesSO_DELTRSH Allow NULL? 
96RSDOCFORResubmission date of forwarded documentnvarchar80DATS(N'00000000')YesSO_DAT_RDF Allow NULL? 
97FOLASDYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
98FOLASDNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
99FOLLINYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
100FOLLINNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
101FOLCRDYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
102FOLCRDNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
103LINKDOYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
104LINKDONOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
105NORTFEDITContinuos-text editor for SAP editor documentschar10CHAR(N' ')YesSO_NRTFEDT Allow NULL? 
106PCOLEStart PC application in SAP windowchar10CHAR(N' ')YesSO_PCOLE Allow NULL? 
NamePrimaryUniqueTypeColumns
SOUD~0YesYesCLUSTEREDUSRNO, USRYR, USRTP, MANDT
SOUD~ANoNoNONCLUSTEREDUSRADR
SOUD~BNoNoNONCLUSTEREDUSRNAM
SOUD~CNoNoNONCLUSTEREDSAPNAM
SOUD~DNoYesNONCLUSTEREDSAPNAM, USRNAM, DELETED, USRNO, USRYR, USRTP, MANDT
SOUD~ENoNoNONCLUSTEREDUSRTP, USRNO

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