|
|
API ACPA1
ACPA1 - Periods Category - WIP Mapping - Log Table
Periods Category OACP SQL Table
G/L Accounts OACT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | OACP Periods Category | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Line Number | Int | 11 | |||||
| LogInstanc | Log Instance | Int | 11 | |||||
| AcctFrom | Consolidate from Account | nVarChar | 15 | OACT G/L Accounts | ||||
| AcctTo | Consolidate to Account | nVarChar | 15 | OACT G/L Accounts |
Table relationship map
SELECT statement
SELECT
ACPA1.AbsEntry AS 'Internal Number',
ACPA1.LineNum AS 'Line Number',
ACPA1.LogInstanc AS 'Log Instance',
ACPA1.AcctFrom AS 'Consolidate from Account',
ACPA1.AcctTo AS 'Consolidate to Account'
FROM ACPA1 AS ACPA1
Related information
Periods Category OACP SQL Table
G/L Accounts OACT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
