biuan SAP® BUSINESS ONE SDK
API ISW1
ISW1 - Reported Business Partners Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WizAbsEnt KEY UNIQUEWizard Run KeyInt
11OISW
Intrastat Wizard
PRIMARYYes
CardCodeBusiness Partner CodenVarChar
15OCRD
Business Partner
CardNameBusiness Partner NamenVarChar
100
CardTypeBusiness Partner TypeVarChar
1
NatOfTransNature of TransactionnVarChar
50
StatProcStatistical ProcedurenVarChar
50
CustProcCustoms ProcedurenVarChar
50
TransModeTransport ModenVarChar
12
IncotermsIncotermsnVarChar
12
PortEnExPort of Entry or ExitnVarChar
50
BPVATRegNoBusiness Partner VAT Reg. No.nVarChar
32
DomFrgIDDomestic/Foreign IdentifierVarChar
1
CtryOrigCountry of OriginnVarChar
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates