|
|
SQL Administration / User Defaults
DTW Administration / Setup / General / User Default Groups
API OUDG / User Default Groups
OUDG - User Defaults Table
User Default Groups UserDefaultGroups Object· Table: OUDG
OUDG SQL Table
Business Place OBPL SQL Table
Countries OCRY SQL Table
Credit Cards OCRC SQL Table
Point of Issue OPTI SQL Table
Sales Tax Codes OSTC SQL Table
Business Partner OCRD SQL Table
Sales Employee OSLP SQL Table
Warehouses OWHS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | nVarChar | 8 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name | Name | nVarChar | 20 | |||||
| Warehouse | Warehouse | nVarChar | 8 | OWHS Warehouses | ||||
| SalePerson | Sales Employee | Int | 11 | OSLP Sales Employee | -1 | |||
| ICTCard | BP for Invoice + Payment | nVarChar | 15 | OCRD Business Partner | ||||
| CashAcct | Cash Account | nVarChar | 15 | |||||
| CheckAcct | Current Account | nVarChar | 15 | |||||
| CreditCard | Credit Card | Int | 6 | OCRC Credit Cards | ||||
| PrintRcpt | Print Receipt | VarChar | N) No A) Only When Adding Y) Always | 1 | N | |||
| ShortRcpt | Print Payment & Invoice in Succession | VarChar | Y) Yes N) No | 1 | N | |||
| Color | Windows Color | Int | 0 1) Classic 2) Gray 3) Violet 4) Blue 5) Green 6) Yellow 7) Orange 8) Red 9) Brown | 6 | 1 | |||
| Address | Address | nVarChar | 127 | |||||
| Country | Country | nVarChar | 3 | OCRY Countries | ||||
| PrintHeadr | Printing Header | nVarChar | 100 | |||||
| Phone1 | Telephone Number 1 | nVarChar | 20 | |||||
| Phone2 | Telephone Number 2 | nVarChar | 20 | |||||
| Fax | Fax Number | nVarChar | 20 | |||||
| E_Mail | nVarChar | 100 | ||||||
| FrgnAddr | Address in Foreign Language | nVarChar | 127 | |||||
| FrnPrntHdr | Printing Header in Foreign Lan | nVarChar | 100 | |||||
| FrgnPhone1 | Telephone Number 1 (Foreign Lang.) | nVarChar | 20 | |||||
| FrgnPhone2 | Telephone Number 2 (Foreign Lang.) | nVarChar | 20 | |||||
| FrgnFax | Fax Number (Foreign Lang.) | nVarChar | 20 | |||||
| DflTaxCode | Default Tax Code | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| FreeZoneNo | Additional ID Number | nVarChar | 32 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| free1 | Free1 | VarChar | 1 | |||||
| UseTax | Use Tax | VarChar | Y) Yes N) No | 1 | ||||
| AdrsFromWh | Use Warehouse Address in A/P Documents | VarChar | Y) Yes N) No | 1 | N | |||
| Language | Language | Int | 11 | |||||
| Font | Font | nVarChar | 50 | |||||
| FontSize | Font Size | Int | 11 | |||||
| BPLId | Default Branch | Int | 11 | OBPL Business Place | ||||
| AssetInDoc | Allow Creation of Asset in Doc. | VarChar | Y) Yes N) No | 1 | N | |||
| AttachPath | Attachments Path | Text | 16 | |||||
| DflPTICode | Default POI Code | nVarChar | 5 | OPTI Point of Issue |
Table relationship map
SELECT statement
SELECT
OUDG.Code AS 'Code',
OUDG.Name AS 'Name',
OUDG.Warehouse AS 'Warehouse',
OUDG.SalePerson AS 'Sales Employee',
OUDG.ICTCard AS 'BP for Invoice + Payment',
OUDG.CashAcct AS 'Cash Account',
OUDG.CheckAcct AS 'Current Account',
OUDG.CreditCard AS 'Credit Card',
OUDG.PrintRcpt AS 'Print Receipt',
OUDG.ShortRcpt AS 'Print Payment & Invoice in Succession',
OUDG.Color AS 'Windows Color',
OUDG.Address AS 'Address',
OUDG.Country AS 'Country',
OUDG.PrintHeadr AS 'Printing Header',
OUDG.Phone1 AS 'Telephone Number 1',
OUDG.Phone2 AS 'Telephone Number 2',
OUDG.Fax AS 'Fax Number',
OUDG.E_Mail AS 'E-Mail',
OUDG.FrgnAddr AS 'Address in Foreign Language',
OUDG.FrnPrntHdr AS 'Printing Header in Foreign Lan',
OUDG.FrgnPhone1 AS 'Telephone Number 1 (Foreign Lang.)',
OUDG.FrgnPhone2 AS 'Telephone Number 2 (Foreign Lang.)',
OUDG.FrgnFax AS 'Fax Number (Foreign Lang.)',
OUDG.DflTaxCode AS 'Default Tax Code',
OUDG.FreeZoneNo AS 'Additional ID Number',
OUDG.UserSign AS 'User Signature',
OUDG.free1 AS 'Free1',
OUDG.UseTax AS 'Use Tax',
OUDG.AdrsFromWh AS 'Use Warehouse Address in A/P Documents',
OUDG.Language AS 'Language',
OUDG.Font AS 'Font',
OUDG.FontSize AS 'Font Size',
OUDG.BPLId AS 'Default Branch',
OUDG.AssetInDoc AS 'Allow Creation of Asset in Doc.',
OUDG.AttachPath AS 'Attachments Path',
OUDG.DflPTICode AS 'Default POI Code'
FROM OUDG AS OUDG
Related information
User Default Groups UserDefaultGroups Object· Table: OUDG
The UserDefaultGroups object enables to define default values (such as, default documents, default address in printed documents, windows color, and so on). These default values can be applied to specific user or group of users by setting the...
OUDG SQL Table
Business Place OBPL SQL Table
Countries OCRY SQL Table
Credit Cards OCRC SQL Table
Point of Issue OPTI SQL Table
Sales Tax Codes OSTC SQL Table
Business Partner OCRD SQL Table
Sales Employee OSLP SQL Table
Warehouses OWHS SQL Table
UserDefaultGroups
Enumeration
Method
Object
DefaultCreditCards UDG2
DefaultDocuments UDG1
Property
AdditionalIdNumber
DTW DB
Address
DTW DB
AddressinForeignLanguage
DTW DB
BPforInvoicePayment
DTW DB
CashAccount
DTW DB
CheckingAcct
DTW DB
Code
DTW DB
Country
DTW DB
DefaultTaxCode
DTW DB
eMail
DTW DB
FaxNumber
DTW DB
FaxNumberForeignLang
DTW DB
Name
DTW DB
PhoneNumber1
DTW DB
PhoneNumber1ForeignLang
DTW DB
PhoneNumber2
DTW DB
PhoneNumber2ForeignLang
DTW DB
PrintingHeader
DTW DB
PrintingHeaderInForeignLangu
DTW DB
PrintInvoiceandPaymentinS
DTW DB
PrintReceipt
DTW DB
SalesEmployee
DTW DB
UseTax
DTW DB
UseWarehouseAddressinAPD
DTW DB
Warehouse
DTW DB
WindowsColor
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates