|
|
SQL Others / Legal Data - Rows
API LGL1
LGL1 - Legal Data - Rows Table
Legal Data OLGL SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal ID | Int | 11 | OLGL Legal Data | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineSeq | Line Sequence | Int | 11 | |||||
| LineType | Line Type | VarChar | T) Document Total R) Tax Per Line V) Total Tax | 1 | R | |||
| TaxCode | Tax Code | nVarChar | 8 | |||||
| TaxRate | Tax Rate | Num | 20 | |||||
| Amount | Amount | Num | 20 |
SELECT statement
SELECT
LGL1.AbsEntry AS 'Internal ID',
LGL1.LineSeq AS 'Line Sequence',
LGL1.LineType AS 'Line Type',
LGL1.TaxCode AS 'Tax Code',
LGL1.TaxRate AS 'Tax Rate',
LGL1.Amount AS 'Amount'
FROM LGL1 AS LGL1
Related information
Legal Data OLGL SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
