|
|
API ISW2
ISW2 - Intrastat Reported Items Table
Items OITM SQL Table
Intrastat Wizard OISW SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | WizAbsEnt KEY UNIQUE | Wizard Run Key | Int | 11 | OISW Intrastat Wizard | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| CommCode | Commodity Code | nVarChar | 12 | |||||
| SerCode | Service Code | nVarChar | 12 | |||||
| AddMUnit | Additional Measure Unit | nVarChar | 50 | |||||
| FactorAM | Factor Additional Measure | Num | 20 | |||||
| OriRegSta | Region of Origin (for Export) | nVarChar | 12 | |||||
| DstRegSta | Destination Region (Import) | nVarChar | 12 | |||||
| CtryOrig | Country of Origin | nVarChar | 3 | |||||
| SerSupplM | Service Supply Method | nVarChar | I) Immediate R) To More Resumptions | 12 | I | |||
| SerPymMeth | Service Payment Method | nVarChar | A) Accredited to Bank Account B) Bank Transfer X) Other | 12 | X | |||
| ItemType | Item Type | VarChar | I) Item S) Service N) Item not relevant to Intrastat | 1 | I | |||
| ItemName | Item Name | nVarChar | 100 | |||||
| DestRegCry | Destination Country - Region | nVarChar | 3 | |||||
| OrigRegCry | Origin Region Country | nVarChar | 3 | |||||
| UseWeight | Use Wt in Add. Measure Calc. | VarChar | Y) Yes N) No | 1 | Y | |||
| StatCode | Statistical Code | nVarChar | 2 | |||||
| NatOfTrans | Nature of Transaction | nVarChar | 50 | |||||
| StatProc | Statistical Procedure | nVarChar | 50 |
Table relationship map
SELECT statement
SELECT
ISW2.WizAbsEnt AS 'Wizard Run Key',
ISW2.ItemCode AS 'Item Code',
ISW2.CommCode AS 'Commodity Code',
ISW2.SerCode AS 'Service Code',
ISW2.AddMUnit AS 'Additional Measure Unit',
ISW2.FactorAM AS 'Factor Additional Measure',
ISW2.OriRegSta AS 'Region of Origin (for Export)',
ISW2.DstRegSta AS 'Destination Region (Import)',
ISW2.CtryOrig AS 'Country of Origin',
ISW2.SerSupplM AS 'Service Supply Method',
ISW2.SerPymMeth AS 'Service Payment Method',
ISW2.ItemType AS 'Item Type',
ISW2.ItemName AS 'Item Name',
ISW2.DestRegCry AS 'Destination Country - Region',
ISW2.OrigRegCry AS 'Origin Region Country',
ISW2.UseWeight AS 'Use Wt in Add. Measure Calc.',
ISW2.StatCode AS 'Statistical Code',
ISW2.NatOfTrans AS 'Nature of Transaction',
ISW2.StatProc AS 'Statistical Procedure'
FROM ISW2 AS ISW2
Related information
Items OITM SQL Table
Intrastat Wizard OISW SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
