|
|
API OAMD
OAMD - Amount Differences Report Table
Business Partner OCRD SQL Table
Currency Codes OCRN SQL Table
G/L Accounts OACT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | LineNum KEY UNIQUE | Internal ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DateFrom | Date From | Date | 8 | |||||
| DateTo | Date To | Date | 8 | |||||
| CardCode | BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| Approved | Confirmed | VarChar | Y) Yes N) No | 1 | N | |||
| AmountDiff | Amount Difference (LC) | Num | 20 | |||||
| TaxAmtDiff | Tax Difference (LC) | Num | 20 | |||||
| RpCurrency | Currency Chosen for the Report | nVarChar | 3 | OCRN Currency Codes | ||||
| VendOffAct | Vendor Offset Account | nVarChar | 15 | OACT G/L Accounts |
Table relationship map
SELECT statement
SELECT
OAMD.LineNum AS 'Internal ID',
OAMD.DateFrom AS 'Date From',
OAMD.DateTo AS 'Date To',
OAMD.CardCode AS 'BP Code',
OAMD.Approved AS 'Confirmed',
OAMD.AmountDiff AS 'Amount Difference (LC)',
OAMD.TaxAmtDiff AS 'Tax Difference (LC)',
OAMD.RpCurrency AS 'Currency Chosen for the Report',
OAMD.VendOffAct AS 'Vendor Offset Account'
FROM OAMD AS OAMD
Related information
Business Partner OCRD SQL Table
Currency Codes OCRN 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
