OTBP - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Business Partners /

Target Group Business Partner

API OTBP

OTBP - Target Group Business Partner Table

SBO SQL database table details

Field	Description	Type	Size	Primary_Key	Unique
CardCode ^KEY ^UNIQUE	BP Code	nVarChar	15	PRIMARY	Yes
CardName	BP Name	nVarChar	100
CntctPrsn	Contact Person	nVarChar	90
Title	Title	nVarChar	10
Position	Position	nVarChar	90
E_Mail	E-Mail	nVarChar	100
Telephone	Telephone	nVarChar	20
Cellolar	Mobile Phone	nVarChar	50
Fax	Fax	nVarChar	20
Address	Address	nVarChar	100
Street	Street/PO Box	nVarChar	100
Block	Block	nVarChar	100
City	City	nVarChar	100
ZipCode	Zip Code	nVarChar	20
County	County	nVarChar	100
Building	Building/Floor/Room	nVarChar	100

SELECT statement

SELECT
   OTBP.CardCode AS 'BP Code', 
   OTBP.CardName AS 'BP Name', 
   OTBP.CntctPrsn AS 'Contact Person', 
   OTBP.Title AS 'Title', 
   OTBP.Position AS 'Position', 
   OTBP.E_Mail AS 'E-Mail', 
   OTBP.Telephone AS 'Telephone', 
   OTBP.Cellolar AS 'Mobile Phone', 
   OTBP.Fax AS 'Fax', 
   OTBP.Address AS 'Address', 
   OTBP.Street AS 'Street/PO Box', 
   OTBP.Block AS 'Block', 
   OTBP.City AS 'City', 
   OTBP.ZipCode AS 'Zip Code', 
   OTBP.County AS 'County', 
   OTBP.Building AS 'Building/Floor/Room'
FROM OTBP AS OTBP

Related information

biuan SAP® BUSINESS ONE

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