|
|
DTW Administration / Setup / General / User Default Groups / User Defaults - Credit Cards
API User Default Groups / Default Credit Cards
UDG2 - User Defaults - Credit Cards Table
Default Credit Cards DefaultCreditCards Object· Table: UDG2
Parent: User Default Groups UserDefaultGroups Object· Table: OUDG
G/L Accounts OACT SQL Table
Credit Cards OCRC 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 |
|---|---|---|---|---|---|---|---|---|
| CreditCard | Credit Card Code | Int | 6 | OCRC Credit Cards | ||||
| AcctCode | Credit Amount Code | nVarChar | 15 | OACT G/L Accounts |
Table relationship map
SELECT statement
SELECT
UDG2.Code AS 'Code',
UDG2.CreditCard AS 'Credit Card Code',
UDG2.AcctCode AS 'Credit Amount Code'
FROM UDG2 AS UDG2
Related information
Default Credit Cards DefaultCreditCards Object· Table: UDG2
The DefaultCreditCards is a child object of the UserDefaultGroups object. It enables to link G/L accounts to credit card codes.
Source table: UDG2.
Parent: User Default Groups UserDefaultGroups Object· Table: OUDG G/L Accounts OACT SQL Table
Credit Cards OCRC SQL Table
UserDefaultGroups
Object
DefaultCreditCards
Method
Property
Code
DB
CreditAccountCode
DTW DB
CreditCardCode
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
