|
|
API CRD9
CRD9 - OCRD Extension Table
Business Partner OCRD SQL Table
Countries OCRY SQL Table
Intrastat Configuration ODCI SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CardCode KEY UNIQUE | BP Code | nVarChar | 25 | OCRD Business Partner | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ISTransMod | Intrastat Transport Mode | Int | 11 | ODCI Intrastat Configuration | ||||
| ISIncoterm | Intrastat Incoterms | Int | 11 | ODCI Intrastat Configuration | ||||
| ISState | Intrastat State | Int | 11 | ODCI Intrastat Configuration | ||||
| ISNatTrans | Intrastat Nature of Trans. | Int | 11 | ODCI Intrastat Configuration | ||||
| ISStatProc | Intrastat Statistical Proc. | Int | 11 | ODCI Intrastat Configuration | ||||
| ISCustProc | Intrastat Customs Proc. | Int | 11 | ODCI Intrastat Configuration | ||||
| ISCRYOrig | Intrastat Country Origin | nVarChar | 3 | OCRY Countries | ||||
| ISPort | Intrastat Port of Entry/Exit | Int | 11 | ODCI Intrastat Configuration | ||||
| ISDomFrgld | Intrastat Domestic/Foreign ID | VarChar | 1 | |||||
| ISRelevant | Intrastat Relevant | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
CRD9.CardCode AS 'BP Code',
CRD9.ISTransMod AS 'Intrastat Transport Mode',
CRD9.ISIncoterm AS 'Intrastat Incoterms',
CRD9.ISState AS 'Intrastat State',
CRD9.ISNatTrans AS 'Intrastat Nature of Trans.',
CRD9.ISStatProc AS 'Intrastat Statistical Proc.',
CRD9.ISCustProc AS 'Intrastat Customs Proc.',
CRD9.ISCRYOrig AS 'Intrastat Country Origin',
CRD9.ISPort AS 'Intrastat Port of Entry/Exit',
CRD9.ISDomFrgld AS 'Intrastat Domestic/Foreign ID',
CRD9.ISRelevant AS 'Intrastat Relevant'
FROM CRD9 AS CRD9
Related information
Business Partner OCRD SQL Table
Countries OCRY SQL Table
Intrastat Configuration ODCI SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
