|
|
SQL 
Finance / 
Account Segmentation
DTW Administration / Setup / Financials / Account Segmentation
API OASG / / Account Segmentations
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsId KEY UNIQUE | Numerator | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name | Name | nVarChar | 100 | |||||
| Size | Size | Int | 6 | |||||
| Type | Type | VarChar | A) Alphanumeric N) Numeric | 1 | A | |||
| UserSign | User Signature | Int | 6 | OUSR Users |
Table relationship map
SELECT statement
SELECT
OASG.AbsId AS 'Numerator',
OASG.Name AS 'Name',
OASG.Size AS 'Size',
OASG.Type AS 'Type',
OASG.UserSign AS 'User Signature'
FROM OASG AS OASG
Related information
Account Segmentations AccountSegmentations Object· Table: OASG
The AccountSegmentations object represents the account segments in the Financials module. The default segments are: Division, Region, and Department.
When creating a new company, before defining any accounts, this object enables you to:
Add up...
OASG SQL Table
Users OUSR SQL Table
AccountSegmentations
Enumeration
Method
Object
Property
Name
DTW DB
Numerator
DTW DB
Size
DTW DB
Type
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates