|
|
API ISW1
ISW1 - Reported Business Partners Table
Business Partner OCRD 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 |
|---|---|---|---|---|---|---|---|---|
| CardCode | Business Partner Code | nVarChar | 15 | OCRD Business Partner | ||||
| CardName | Business Partner Name | nVarChar | 100 | |||||
| CardType | Business Partner Type | VarChar | 1 | |||||
| NatOfTrans | Nature of Transaction | nVarChar | 50 | |||||
| StatProc | Statistical Procedure | nVarChar | 50 | |||||
| CustProc | Customs Procedure | nVarChar | 50 | |||||
| TransMode | Transport Mode | nVarChar | 12 | |||||
| Incoterms | Incoterms | nVarChar | 12 | |||||
| PortEnEx | Port of Entry or Exit | nVarChar | 50 | |||||
| BPVATRegNo | Business Partner VAT Reg. No. | nVarChar | 32 | |||||
| DomFrgID | Domestic/Foreign Identifier | VarChar | 1 | |||||
| CtryOrig | Country of Origin | nVarChar | 3 |
Table relationship map
SELECT statement
SELECT
ISW1.WizAbsEnt AS 'Wizard Run Key',
ISW1.CardCode AS 'Business Partner Code',
ISW1.CardName AS 'Business Partner Name',
ISW1.CardType AS 'Business Partner Type',
ISW1.NatOfTrans AS 'Nature of Transaction',
ISW1.StatProc AS 'Statistical Procedure',
ISW1.CustProc AS 'Customs Procedure',
ISW1.TransMode AS 'Transport Mode',
ISW1.Incoterms AS 'Incoterms',
ISW1.PortEnEx AS 'Port of Entry or Exit',
ISW1.BPVATRegNo AS 'Business Partner VAT Reg. No.',
ISW1.DomFrgID AS 'Domestic/Foreign Identifier',
ISW1.CtryOrig AS 'Country of Origin'
FROM ISW1 AS ISW1
Related information
Business Partner OCRD 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
