|
|
API SAL1
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Document Entry | Int | 11 | OINV A/R Invoice | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| BaseEntry | Base Document Internal ID | Int | 11 | |||||
| PackQty | Packing Quantity | Num | 20 | |||||
| PurPackMsr | Packaging UoM Name | nVarChar | 8 | Pack | ||||
| ArsnalName | Storage Group Name | nVarChar | 20 | |||||
| ArsnalCode | Storage Group Code | nVarChar | 20 | |||||
| UnitMsr | Ref. UoM (Type) | nVarChar | 5 | Unit | ||||
| Quantity | Quantity | Num | 20 | |||||
| Fraction | Remainder | Num | 20 | |||||
| Weight1 | Weight | Num | 20 | |||||
| LineTotal | Row Total | Num | 20 | |||||
| ItemCode | Item No. | nVarChar | 20 | OITM Items |
Table relationship map
SELECT statement
SELECT
SAL1.DocEntry AS 'Document Entry',
SAL1.LineNum AS 'Row Number',
SAL1.BaseEntry AS 'Base Document Internal ID',
SAL1.PackQty AS 'Packing Quantity',
SAL1.PurPackMsr AS 'Packaging UoM Name',
SAL1.ArsnalName AS 'Storage Group Name',
SAL1.ArsnalCode AS 'Storage Group Code',
SAL1.UnitMsr AS 'Ref. UoM (Type)',
SAL1.Quantity AS 'Quantity',
SAL1.Fraction AS 'Remainder',
SAL1.Weight1 AS 'Weight',
SAL1.LineTotal AS 'Row Total',
SAL1.ItemCode AS 'Item No.'
FROM SAL1 AS SAL1
Related information
A/R Invoice OINV SQL Table
Items OITM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates