|
|
DTW Administration / System Initialization / Opening Balances / Business Partners Opening Balance
API DADB
DADB - Data Archive DSA Balance Table
Items OITM SQL Table
Location OLCT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Document Internal ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ItemCode | Item Number | nVarChar | 20 | OITM Items | ||||
| LocCode | Location Code | Int | 11 | OLCT Location | ||||
| OpenBal | Opening Balance | Num | 20 |
Table relationship map
SELECT statement
SELECT
DADB.AbsEntry AS 'Document Internal ID',
DADB.ItemCode AS 'Item Number',
DADB.LocCode AS 'Location Code',
DADB.OpenBal AS 'Opening Balance'
FROM DADB AS DADB
Related information
Items OITM SQL Table
Location OLCT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
