|
|
DTW Administration / Setup / Financials / Account Segmentation Categories
API OASC / Account Segmentation Categories
OASC - Account Segmentation Categories Table
Account Segmentation Categories AccountSegmentationCategories Object· Table: OASC
Acct Segmnt Categories AcctSegmnt_Categories Object· Table: OASC
Parent: Account Segmentations AccountSegmentations Object· Table: OASG
Account Segmentation OASG SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | SegmentId KEY UNIQUE | Segment ID | Int | 6 | OASG Account Segmentation | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Code | Code | nVarChar | 20 | |||||
| Name | Name | nVarChar | 100 | |||||
| ShortName | Short Name | nVarChar | 10 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users |
Table relationship map
SELECT statement
SELECT
OASC.SegmentId AS 'Segment ID',
OASC.Code AS 'Code',
OASC.Name AS 'Name',
OASC.ShortName AS 'Short Name',
OASC.UserSign AS 'User Signature'
FROM OASC AS OASC
Related information
Account Segmentation Categories AccountSegmentationCategories Object· Table: OASC
The AccountSegmentationCategories object represents the categories for each of the account segments in the Financials module.
This object enables you to:
Add an account category to a segment.
Retrieve an account segment category by its key....
Acct Segmnt Categories AcctSegmnt_Categories Object· Table: OASC
The category of the account segmentation.
Source table: OASC.
Parent: Account Segmentations AccountSegmentations Object· Table: OASG Account Segmentation OASG SQL Table
Users OUSR SQL Table
AccountSegmentationCategories
Method
Property
Code
DTW DB
Name
DTW DB
SegmentID
DTW DB
ShortName
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
