|
|
API ITM10
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItemCode KEY UNIQUE | Item No. | nVarChar | 20 | OITM Items | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ISCommCode | Commodity Code | Int | 11 | ODCI Intrastat Configuration | ||||
| ISSubMasUn | Intrastat Additional Measure | Int | 11 | ODCI Intrastat Configuration | ||||
| ISFactor | IS Factor Additional Measure | Num | 20 | |||||
| ISOrCSTImp | IS Destination State for Impor. | Int | 11 | ODCI Intrastat Configuration | ||||
| ISOrCSTExp | IS State of Origin for Export | Int | 11 | ODCI Intrastat Configuration | ||||
| ISNaTraImp | IS Nature of Trans. Import | Int | 11 | ODCI Intrastat Configuration | ||||
| ISNaTraExp | IS Nature of Trans. Export | Int | 11 | ODCI Intrastat Configuration | ||||
| ISStProImp | IS Statistical Procedure Imp. | Int | 11 | ODCI Intrastat Configuration | ||||
| ISStProExp | IS Statistical Procedure Exp. | Int | 11 | ODCI Intrastat Configuration | ||||
| ISOriCntry | Intrastat Country of Origin | nVarChar | 3 | OCRY Countries | ||||
| ISSerCode | Intrastat Service Code | Int | 11 | ODCI Intrastat Configuration | ||||
| ISItemType | Intrastat Item Type | VarChar | I) Item S) Service | 1 | I | |||
| ISSerSupMt | IS Service Supply Method | nVarChar | I) Immediate R) To More Resumptions | 12 | I | |||
| ISSerPayMt | IS Service Payment Method | nVarChar | A) Accredited to Bank Account B) Bank Transfer X) Other | 12 | X | |||
| ISOrCRYImp | IS Destination Country for Imp. | nVarChar | 3 | OCRY Countries | ||||
| ISOrCRYExp | IS Origin Country for Export | nVarChar | 3 | OCRY Countries | ||||
| ISUseWeigh | Use Wt in Add. Measure Calc. | VarChar | Y) Yes N) No | 1 | Y | |||
| ISRelevant | Intrastat Relevant | VarChar | Y) Yes N) No | 1 | N | |||
| ISStatCode | Statistical Code | nVarChar | 2 |
Table relationship map
SELECT statement
SELECT
ITM10.ItemCode AS 'Item No.',
ITM10.ISCommCode AS 'Commodity Code',
ITM10.ISSubMasUn AS 'Intrastat Additional Measure',
ITM10.ISFactor AS 'IS Factor Additional Measure',
ITM10.ISOrCSTImp AS 'IS Destination State for Impor.',
ITM10.ISOrCSTExp AS 'IS State of Origin for Export',
ITM10.ISNaTraImp AS 'IS Nature of Trans. Import',
ITM10.ISNaTraExp AS 'IS Nature of Trans. Export',
ITM10.ISStProImp AS 'IS Statistical Procedure Imp.',
ITM10.ISStProExp AS 'IS Statistical Procedure Exp.',
ITM10.ISOriCntry AS 'Intrastat Country of Origin',
ITM10.ISSerCode AS 'Intrastat Service Code',
ITM10.ISItemType AS 'Intrastat Item Type',
ITM10.ISSerSupMt AS 'IS Service Supply Method',
ITM10.ISSerPayMt AS 'IS Service Payment Method',
ITM10.ISOrCRYImp AS 'IS Destination Country for Imp.',
ITM10.ISOrCRYExp AS 'IS Origin Country for Export',
ITM10.ISUseWeigh AS 'Use Wt in Add. Measure Calc.',
ITM10.ISRelevant AS 'Intrastat Relevant',
ITM10.ISStatCode AS 'Statistical Code'
FROM ITM10 AS ITM10
Related information
Intrastat Configuration ODCI SQL Table
Countries OCRY SQL Table
Items OITM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates