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

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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Administration
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.3OUSR1134UsersAdministration
SQL:  selectupdate insert create

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

SELECT USERID, PASSWORD, PASSWORD1, PASSWORD2, INTERNAL_K, USER_CODE, U_NAME, GROUPS, PASSWORD4, ALLOWENCES, SUPERUSER, DISCOUNT, PASSWORD3, Info1File, Info1Field, Info2File, Info2Field, Info3File, Info3Field, Info4File, Info4Field, dType, E_Mail, PortNum, OutOfOffic, SendEMail, SendSMS, DfltsGroup, CashLimit, MaxCashSum, Fax, SendFax, Locked, Department, Branch, UserPrefs, Language, Charset, OpenCdt, CdtPrvDays, DsplyRates, AuImpRates, OpenDps, RcrFlag, CheckFiles, OpenCredit, CreditDay1, CreditDay2, WallPaper, WllPprDsp, AdvImagePr, ContactLog, LastWarned, AlertPolFr, ScreenLock, ShowNewMsg, Picture, Position, Address, Country, Tel1, Tel2, GENDER, Birthday, EnbMenuFlt, objType, logInstanc, userSign, createDate, userSign2, updateDate, OneLogPwd, lastLogin, LastPwds, LastPwds2, LastPwdSet, FailedLog, PwdNeverEx, SalesDisc, PurchDisc, LstLogoutD, LstLoginT, LstLogoutT, LstPwdChT, LstPwdChB, RclFlag, MobileUser, MobileIMEI, PrsWkCntEb, SnapShotId, STData, SupportUsr, NoSTPwdNum, DomainUser, CUSAgree, EmailSig, TPLId, DigCrtPath, ShowNewTsk, IntgrtEb, AllBrnchF, EvtNotify, IgnDtOwn, EnterAsTab, DotAsSep, MouseOnly, Color, SkinType, Font, FontSize, NaturalPer, DPPStatus, AutoAsnBPL FROM OUSR

TOPB1 9.3  | OUSR COLUMNS

ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1USERIDUser Signatureint60 Allow NULL? 
2PASSWORDUser Passwordnvarchar25400 Allow NULL? 
3PASSWORD1User Passwordnvarchar80 Allow NULL? 
4PASSWORD2User Passwordnvarchar80 Allow NULL? 
5INTERNAL_KInternal Numberint60 Allow NULL? 
6USER_CODEUser Codenvarchar250 Allow NULL? 
7U_NAMEUser Namenvarchar1550 Allow NULL? 
8GROUPSUser Groupint6000=Regular, 99=Deleted Allow NULL? 
9PASSWORD4Passwordnvarchar2540 Allow NULL? 
10ALLOWENCESUser Confirmationtext160
11SUPERUSERSuperuserchar10NN=No, Y=Yes Allow NULL? 
12DISCOUNTMax. Discountnum196 Allow NULL? 
13PASSWORD3User Passwordnvarchar80 Allow NULL? 
14Info1FileInfo1Filenvarchar40 Allow NULL? 
15Info1FieldInfo1Fieldint60 Allow NULL? 
16Info2FileInfo2Filenvarchar40 Allow NULL? 
17Info2FieldInfo2Fieldint60 Allow NULL? 
18Info3FileInfo3Filenvarchar40 Allow NULL? 
19Info3FieldInfo3Fieldint60 Allow NULL? 
20Info4FileInfo4Filenvarchar40 Allow NULL? 
21Info4FieldInfo4Fieldint60 Allow NULL? 
22dTypedTypechar10SH=SHA1, N=No, S=SHA256, X, Y=Yes Allow NULL? 
23E_MailE-Mailnvarchar1000 Allow NULL? 
24PortNumMobile Phone Numbernvarchar500 Allow NULL? 
25OutOfOfficOut of Officechar10NN=No, Y=Yes Allow NULL? 
26SendEMailSend E-Mailchar10NN=No, Y=Yes Allow NULL? 
27SendSMSSend SMSchar10NN=No, Y=Yes Allow NULL? 
28DfltsGroupDefaultsnvarchar80OUDG Allow NULL? 
29CashLimitCash Amount Limitchar10NN=No, Y=Yes Allow NULL? 
30MaxCashSumMax. Cash Totalnum196 Allow NULL? 
31FaxFax Numbernvarchar200 Allow NULL? 
32SendFaxSend Faxchar10NN=No, Y=Yes Allow NULL? 
33LockedUser Lockedchar10NN=No, Y=Yes Allow NULL? 
34DepartmentDepartmentint60OUDP-2 Allow NULL? 
35BranchBranchint60OUBR-2 Allow NULL? 
36UserPrefsUser Preferencestext160
37LanguageLanguageint110 Allow NULL? 
38CharsetFont Languageint60 Allow NULL? 
39OpenCdtOpen Window for Credit Referencechar10NN=No, Y=Yes Allow NULL? 
40CdtPrvDaysVouchers from Last Daysint1101 Allow NULL? 
41DsplyRatesDisplay Rate Table on start upchar10NN=No, Y=Yes Allow NULL? 
42AuImpRatesImport Currency Rates Automaticallychar10NN=No, Y=Yes Allow NULL? 
43OpenDpsOpen Postdated Checks Windowchar10NN=No, Y=Yes Allow NULL? 
44RcrFlagDisplay Transactions Scheduled for Todaychar10NN=No, Y=Yes Allow NULL? 
45CheckFilesFile Checkchar10NN=No, Y=Yes Allow NULL? 
46OpenCreditOpen Postdated Credit Vouchers Windowchar10D=By Date, N=No, Y=Always Allow NULL? 
47CreditDay1Credit Handling Day 1int601 Allow NULL? 
48CreditDay2Credit Handling Day 2int6015 Allow NULL? 
49WallPaperWallpapertext160
50WllPprDspWallpaper Displayint601=Centralized, 2=Full Screen, 3=Tile Allow NULL? 
51AdvImagePrExtended Image Processingchar10N=Partial, O=Without, Y=Full Allow NULL? 
52ContactLogToday's Activity Alertchar10NN=No, Y=Yes Allow NULL? 
53LastWarnedLast Warned Datedate80
54AlertPolFrMessage Check Frequencyint605 Allow NULL? 
55ScreenLockScreen Lock Delayint6030 Allow NULL? 
56ShowNewMsgOpen Message on Arrivalchar10YN=No, Y=Yes Allow NULL? 
57PicturePicturenvarchar2000 Allow NULL? 
58PositionPositionnvarchar900 Allow NULL? 
59AddressAddressnvarchar1000 Allow NULL? 
60CountryCountrynvarchar30OCRY Allow NULL? 
61Tel1Telephone 1nvarchar200 Allow NULL? 
62Tel2Telephone 2nvarchar200 Allow NULL? 
63GENDERGenderchar10FF=Female, M=Male Allow NULL? 
64BirthdayBirthdaydate80
65EnbMenuFltEnable Forbidden Menu Itemschar10NN=No, Y=Yes Allow NULL? 
66objTypeObject Type - Historynvarchar20012 Allow NULL? 
67logInstancLog Instance - Historyint110 Allow NULL? 
68userSignCreating User - Historyint60OUSR Allow NULL? 
69createDateCreation Date - Historydate80
70userSign2Updating User - Historyint60OUSR Allow NULL? 
71updateDateDate of Update - Historydate80
72OneLogPwdAt first logon change passwordchar10YN=Password should not be changed at first login, Y=Password should be changed at first login Allow NULL? 
73lastLoginLast Logon Datedate80
74LastPwdsLast Passwords 1text160
75LastPwds2Last Passwords 2nvarchar25400 Allow NULL? 
76LastPwdSetLast Password Changedate80
77FailedLogFailed Login Countint1100 Allow NULL? 
78PwdNeverExPassword Never Expireschar10NN=No, Y=Yes Allow NULL? 
79SalesDiscMax. Sales Discountnum196 Allow NULL? 
80PurchDiscMax. Purchase Discountnum196 Allow NULL? 
81LstLogoutDLast Logoff Datedate80
82LstLoginTLast Logon Timeint110 Allow NULL? 
83LstLogoutTLast Logoff Timeint110 Allow NULL? 
84LstPwdChTLast Password Change Timeint110 Allow NULL? 
85LstPwdChBLast Password Changed Bynvarchar80 Allow NULL? 
86RclFlagDisplay Recurring Transactionschar10NN=No, Y=Yes Allow NULL? 
87MobileUserMobile Userchar10NN=No, Y=Yes Allow NULL? 
88MobileIMEIMobile IMEInvarchar640 Allow NULL? 
89PrsWkCntEbPersonal Work Center Enablechar10NN=No, Y=Yes Allow NULL? 
90SnapShotIdSnapshot IDint1100 Allow NULL? 
91STDataUser Password Saltnvarchar400 Allow NULL? 
92SupportUsrSupport Userchar10NN=No, Y=Yes Allow NULL? 
93NoSTPwdNumPassword encrypted w/o Salt (cryptography)int600 Allow NULL? 
94DomainUserDomain user name bound in SLDnvarchar500 Allow NULL? 
95CUSAgreeCUS Agreementchar10N=No, Y=Yes Allow NULL? 
96EmailSigE-Mail Signaturetext160
97TPLIdTemplate IDint60UICU Allow NULL? 
98DigCrtPathDigital Certificate Pathtext160
99ShowNewTskOpen Worklist on Task Arrivalchar10YN=No, Y=Yes Allow NULL? 
100IntgrtEbEnable Setting Integrationchar10NN=No, Y=Yes Allow NULL? 
101AllBrnchFAllow Viewing of All (Including Unassigned To) Branches in Financial Reportschar10YN=No, Y=Yes Allow NULL? 
102EvtNotifyAllow Event Notificationchar10Y Allow NULL? 
103IgnDtOwnIgnore Data Ownership for this userchar10NN=No, Y=Yes Allow NULL? 
104EnterAsTabUse Numeric Keypad Enter Key as Tab Keychar10NN=No, Y=Yes Allow NULL? 
105DotAsSepUse Del Key As Separatorchar10NN=No, Y=Yes Allow NULL? 
106MouseOnlyDocument Operation by Mouse Onlychar10NN=No, Y=Yes Allow NULL? 
107ColorCompany Colorint600=Combined, 1=Classic, 2=Gray, 3=Violet, 4=Blue, 5=Green, 6=Yellow, 7=Orange, 8=Red, 9=Brown Allow NULL? 
108SkinTypeSkin Typenvarchar2540 Allow NULL? 
109FontFontnvarchar500 Allow NULL? 
110FontSizeFont Sizeint110 Allow NULL? 
111NaturalPerNatural Personchar10NN=No, Y=Yes Allow NULL? 
112DPPStatusData Protection Statuschar10NB=Blocked, D=Erased, N=None, U=Unblocked Allow NULL? 
113AutoAsnBPLAuto. Assign Brancheschar10NN=No, Y=Yes Allow NULL? 

TOPB1 9.3  | OUSR INDEXES

NamePrimaryUniqueTypeColumns
PRIMARYNoYesUSERID
PASSWORDNoNoPASSWORD
USER_CODENoYesUSER_CODE
INTERNALNoYesINTERNAL_K