biuan SAP® BUSINESS ONE SDK
API OTBP
OTBP - Target Group Business Partner Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CardCode KEY UNIQUEBP CodenVarChar
15
PRIMARYYes
CardNameBP NamenVarChar
100
CntctPrsnContact PersonnVarChar
90
TitleTitlenVarChar
10
PositionPositionnVarChar
90
E_MailE-MailnVarChar
100
TelephoneTelephonenVarChar
20
CellolarMobile PhonenVarChar
50
FaxFaxnVarChar
20
AddressAddressnVarChar
100
StreetStreet/PO BoxnVarChar
100
BlockBlocknVarChar
100
CityCitynVarChar
100
ZipCodeZip CodenVarChar
20
CountyCountynVarChar
100
BuildingBuilding/Floor/RoomnVarChar
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




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