|
|
API PMN5
PMN5 - Payment - VAT Adjustment Table
Object Settings - History ADP1 SQL Table
Tax Definition OVTG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocNum KEY UNIQUE | Document Number | Int | 11 | OPMN | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| InvEntry | Invoice No. | Int | 11 | |||||
| LineNum | Row Number | Int | 11 | |||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 24 | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| VatGroup | Tax Group | nVarChar | 8 | OVTG Tax Definition | ||||
| VatPrcnt | Tax % | Num | 20 | |||||
| VatSum | Tax Amount | Num | 20 | |||||
| BaseSum | Base Amount | Num | 20 | |||||
| NoDedSum | Nondeductible Amount | Num | 20 | |||||
| BaseSumFc | Base Amount (FC) | Num | 20 | |||||
| VatSumFc | Tax Amount (FC) | Num | 20 | |||||
| NoDedSumFc | Nondeductible Amount (FC) | Num | 20 | |||||
| BaseSumSc | Base Amount (SC) | Num | 20 | |||||
| NoDedSumSc | Nondeductible Amount (SC) | Num | 20 | |||||
| VatSumSc | VAT Amount (SC) | Num | 20 | |||||
| CashDiscAc | Cash Discount Account | nVarChar | 15 | |||||
| BaseObjArr | Base Object Array Number | Int | 6 | 1 | ||||
| BaseObj | Base Object | Int | 11 | 13 | ||||
| InstlmntId | Installment ID | Int | 6 | 0 | ||||
| GroupNum | Group Number | Int | 11 | 0 | ||||
| LineSeq | Row Sequence | Int | 11 | |||||
| EquVatPer | Equalization Tax % | Num | 20 | |||||
| EquVatSum | Total Equalization Tax | Num | 20 | |||||
| EquVatSumF | Total Equalization Tax (FC) | Num | 20 | |||||
| EquVatSumS | Total Equalization Tax (SC) | Num | 20 |
Table relationship map
SELECT statement
SELECT
PMN5.DocNum AS 'Document Number',
PMN5.InvEntry AS 'Invoice No.',
PMN5.LineNum AS 'Row Number',
PMN5.ObjType AS 'Object Type',
PMN5.LogInstanc AS 'Log Instance',
PMN5.VatGroup AS 'Tax Group',
PMN5.VatPrcnt AS 'Tax %',
PMN5.VatSum AS 'Tax Amount',
PMN5.BaseSum AS 'Base Amount',
PMN5.NoDedSum AS 'Nondeductible Amount',
PMN5.BaseSumFc AS 'Base Amount (FC)',
PMN5.VatSumFc AS 'Tax Amount (FC)',
PMN5.NoDedSumFc AS 'Nondeductible Amount (FC)',
PMN5.BaseSumSc AS 'Base Amount (SC)',
PMN5.NoDedSumSc AS 'Nondeductible Amount (SC)',
PMN5.VatSumSc AS 'VAT Amount (SC)',
PMN5.CashDiscAc AS 'Cash Discount Account',
PMN5.BaseObjArr AS 'Base Object Array Number',
PMN5.BaseObj AS 'Base Object',
PMN5.InstlmntId AS 'Installment ID',
PMN5.GroupNum AS 'Group Number',
PMN5.LineSeq AS 'Row Sequence',
PMN5.EquVatPer AS 'Equalization Tax %',
PMN5.EquVatSum AS 'Total Equalization Tax',
PMN5.EquVatSumF AS 'Total Equalization Tax (FC)',
PMN5.EquVatSumS AS 'Total Equalization Tax (SC)'
FROM PMN5 AS PMN5
Related information
Object Settings - History ADP1 SQL Table
Tax Definition OVTG SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
