biuan SAP® BUSINESS ONE SDK
API TPW1
TPW1 - Selection Criteria Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEAbsolute Entry NoInt
11OTPW
Tax Payment Wizard
PRIMARYYes
FromPeriodFrom PeriodDate
8
ToPeriodTo PeriodDate
8
FromDateFrom DateDate
8
ToDateTo DateDate
8
TaxCategryTax CategoryInt
11ONFT
Nota Fiscal Tax Category (Brazil)
LocCodeLocation CodeInt
11OLCT
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates