|
|
API RPC14
RPC14 - A/P Credit Memo - Assembly - Rows Table
A/P Credit Memo ORPC SQL Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Warehouses OWHS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Document Internal ID | Int | 11 | ORPC A/P Credit Memo | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | -1 | ||||
| ChildNum | Child Number | Int | 11 | -1 | ||||
| ItemCode | Item no. | nVarChar | 20 | OITM Items | ||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| Quantity | Quantity | Num | 20 | |||||
| TotalQty | Total Quantity | Num | 20 | |||||
| OpenQty | Remaining Open Quantity | Num | 20 | |||||
| ObjectType | object type | nVarChar | 20 | ADP1 Object Settings - History | 19 | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| BaseChildN | Base Child Number | Int | 11 | -1 |
Table relationship map
SELECT statement
SELECT
RPC14.DocEntry AS 'Document Internal ID',
RPC14.LineNum AS 'Row Number',
RPC14.ChildNum AS 'Child Number',
RPC14.ItemCode AS 'Item no.',
RPC14.WhsCode AS 'Warehouse Code',
RPC14.Quantity AS 'Quantity',
RPC14.TotalQty AS 'Total Quantity',
RPC14.OpenQty AS 'Remaining Open Quantity',
RPC14.ObjectType AS 'object type',
RPC14.LogInstanc AS 'Log Instance',
RPC14.BaseChildN AS 'Base Child Number'
FROM RPC14 AS RPC14
Related information
A/P Credit Memo ORPC SQL Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Warehouses OWHS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
