|
|
SQL Banking / Selection Criteria
API TPW1
TPW1 - Selection Criteria Table
Tax Payment Wizard OTPW SQL Table
Location OLCT SQL Table
Nota Fiscal Tax Category (Brazil) ONFT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Absolute Entry No | Int | 11 | OTPW Tax Payment Wizard | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| FromPeriod | From Period | Date | 8 | |||||
| ToPeriod | To Period | Date | 8 | |||||
| FromDate | From Date | Date | 8 | |||||
| ToDate | To Date | Date | 8 | |||||
| TaxCategry | Tax Category | Int | 11 | ONFT Nota Fiscal Tax Category (Brazil) | ||||
| LocCode | Location Code | Int | 11 | OLCT Location |
Table relationship map
SELECT statement
SELECT
TPW1.AbsEntry AS 'Absolute Entry No',
TPW1.FromPeriod AS 'From Period',
TPW1.ToPeriod AS 'To Period',
TPW1.FromDate AS 'From Date',
TPW1.ToDate AS 'To Date',
TPW1.TaxCategry AS 'Tax Category',
TPW1.LocCode AS 'Location Code'
FROM TPW1 AS TPW1
Related information
Tax Payment Wizard OTPW SQL Table
Location OLCT SQL Table
Nota Fiscal Tax Category (Brazil) ONFT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
