|
|
DTW Administration / Setup / Purchasing / Landed Costs
API CIF1
CIF1 - Country Specific Information Table
Countries OCRY SQL Table
Configuration of Intrastat Fields OCIF SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | FldAbsEnt KEY UNIQUE | Field ID | Int | 11 | OCIF Configuration of Intrastat Fields | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Country | Country Code | nVarChar | 3 | OCRY Countries | ||||
| IsMandImp | Field is mandatory for import | VarChar | Y) Yes N) No | 1 | ||||
| IsMandExp | Field is mandatory for export | VarChar | Y) Yes N) No | 1 | ||||
| IsReqAllIm | Field is required for import | VarChar | Y) Yes N) No | 1 | N | |||
| IsReqAllEx | Field is required for export | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
CIF1.FldAbsEnt AS 'Field ID',
CIF1.Country AS 'Country Code',
CIF1.IsMandImp AS 'Field is mandatory for import',
CIF1.IsMandExp AS 'Field is mandatory for export',
CIF1.IsReqAllIm AS 'Field is required for import',
CIF1.IsReqAllEx AS 'Field is required for export'
FROM CIF1 AS CIF1
Related information
Countries OCRY SQL Table
Configuration of Intrastat Fields OCIF SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
