|
|
DTW Administration / Setup / Financials / Tax / Sales Tax Authorities / Valid Period
API Sales Tax Authorities / Tax Definitions
STA1 - Valid Period Table
Tax Definitions TaxDefinitions Object· Table: STA1
Parent: Sales Tax Authorities SalesTaxAuthorities Object· Table: OSTA
Sales Tax Authorities OSTA SQL Table
Sales Tax Authorities Type OSTT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | StaCode KEY UNIQUE | Tax Parameter Code | nVarChar | 8 | OSTA Sales Tax Authorities | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| SttType | Tax Type | Int | 11 | OSTT Sales Tax Authorities Type | ||||
| EfctDate | Effective From | Date | 8 | |||||
| Rate | Rate | Num | 20 |
Table relationship map
SELECT statement
SELECT
STA1.StaCode AS 'Tax Parameter Code',
STA1.SttType AS 'Tax Type',
STA1.EfctDate AS 'Effective From',
STA1.Rate AS 'Rate'
FROM STA1 AS STA1
Related information
Tax Definitions TaxDefinitions Object· Table: STA1
A set of tax rates for different time periods for a particular sales tax jurisdiction.
Source table: STA1
Parent: Sales Tax Authorities SalesTaxAuthorities Object· Table: OSTA Sales Tax Authorities OSTA SQL Table
Sales Tax Authorities Type OSTT SQL Table
SalesTaxAuthorities
Object
TaxDefinitions
Method
Property
Effectivefrom
DTW DB
Rate
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
