|
|
SQL Finance / Asset Attributes
DTW Administration / Setup / Financials / Fixed Assets / Attribute Groups
API Attribute Groups Service / Attribute Group
OFAA - Asset Attributes Table
Attribute Group AttributeGroup Object· Table: OFAA
Parent: Attribute Groups Service AttributeGroupsService Service
OFAA SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name KEY UNIQUE | Name | nVarChar | 100 | Name | Yes | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N | |||
| SnapshotId | Snapshot ID | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
OFAA.Code AS 'Code',
OFAA.Name AS 'Name',
OFAA.DataSource AS 'Data Source',
OFAA.UserSign AS 'User Signature',
OFAA.LogInstanc AS 'Log Instance',
OFAA.CreateDate AS 'Creation Date',
OFAA.UserSign2 AS 'Updating User',
OFAA.UpdateDate AS 'Date of Update',
OFAA.Locked AS 'Locked',
OFAA.SnapshotId AS 'Snapshot ID'
FROM OFAA AS OFAA
Related information
Attribute Group AttributeGroup Object· Table: OFAA
Source table: OFAA.
Parent: Attribute Groups Service AttributeGroupsService ServiceOFAA SQL Table
Users OUSR SQL Table
AttributeGroupsService
Object
AttributeGroup
Collection
Method
Property
Code
DTW DB
Locked
DTW DB
Name
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
