|
|
API CPA1
CPA1 - Periods Category - WIP Mapping 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
CPA1.AbsEntry AS 'Internal Number',
CPA1.LineNum AS 'Line Number',
CPA1.LogInstanc AS 'Log Instance',
CPA1.AcctFrom AS 'Consolidate from Account',
CPA1.AcctTo AS 'Consolidate to Account'
FROM CPA1 AS CPA1
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
