|
|
API ACR3
ACR3 - Business Partner Control Accounts - History Table
G/L Accounts OACT SQL Table
Business Partner OCRD SQL Table
Object Settings - History ADP1 SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CardCode KEY UNIQUE | BP Code | nVarChar | 15 | OCRD Business Partner | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| AcctType | Account Type | VarChar | M) Domestic F) Foreign D) Down Payment A) Assets Account R) Bill of Exchange Accounts Receivable P) Bill of Exchange Accounts Payable C) Bill of Exchange on Collection S) Bill of Exchange Presentation Y) Assets Bill of Exchange Acct Payable I) Bill of Exchange Discounted U) Unpaid Bill of Exchange O) Open Debts | 1 | M | |||
| AcctCode | Account Code | nVarChar | 15 | OACT G/L Accounts | ||||
| LogInstane | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | Int | 6 | ADP1 Object Settings - History | 2 |
Table relationship map
SELECT statement
SELECT
ACR3.CardCode AS 'BP Code',
ACR3.AcctType AS 'Account Type',
ACR3.AcctCode AS 'Account Code',
ACR3.LogInstane AS 'Log Instance',
ACR3.ObjType AS 'Object Type'
FROM ACR3 AS ACR3
Related information
G/L Accounts OACT SQL Table
Business Partner OCRD SQL Table
Object Settings - History ADP1 SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates