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

SQL Business Partners / Target Group Details

DTW Administration / Setup / Business Partners / Target Group

API TGG1

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Primary_Key	Unique
TargetCode ^KEY ^UNIQUE	Target Group Code	nVarChar		20	OTGG Target Group	PRIMARY	Yes
CardCode	BP Code	nVarChar		15
CardName	BP Name	nVarChar		100
GroupCode	Group Code	nVarChar		20
Industry	Industry	Text		16
validFor	Active	VarChar	A) Active I) Inactive	1
CntctPrsn	Contact Person	nVarChar		50	OCPR Contact Persons
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	nVarChar		100
Block	Block	nVarChar		100
City	City	nVarChar		100
ZipCode	Zip Code	nVarChar		20
County	County	nVarChar		100
State	State	nVarChar		3	OCST States
Country	Country	nVarChar		3	OCRY Countries
Building	Building/Floor/Room	Text		16
LineNum	Line Number	Int		11
FirstName	First Name	nVarChar		50
MiddleName	Middle Name	nVarChar		50
LastName	Last Name	nVarChar		50
LicTradNum	Federal Tax ID	nVarChar		32
AddrType	Address Type	nVarChar		100
Address2	Address Name 2	nVarChar		50
Address3	Address Name 3	nVarChar		50
StreetNo	Street No.	nVarChar		100
AddressID	Address ID	nVarChar		50

Table relationship map

SELECT statement

SELECT
   TGG1.TargetCode AS 'Target Group Code', 
   TGG1.CardCode AS 'BP Code', 
   TGG1.CardName AS 'BP Name', 
   TGG1.GroupCode AS 'Group Code', 
   TGG1.Industry AS 'Industry', 
   TGG1.validFor AS 'Active', 
   TGG1.CntctPrsn AS 'Contact Person', 
   TGG1.Title AS 'Title', 
   TGG1.Position AS 'Position', 
   TGG1.E_Mail AS 'E-Mail', 
   TGG1.Telephone AS 'Telephone', 
   TGG1.Cellolar AS 'Mobile Phone', 
   TGG1.Fax AS 'Fax', 
   TGG1.Address AS 'Address', 
   TGG1.Street AS 'Street', 
   TGG1.Block AS 'Block', 
   TGG1.City AS 'City', 
   TGG1.ZipCode AS 'Zip Code', 
   TGG1.County AS 'County', 
   TGG1.State AS 'State', 
   TGG1.Country AS 'Country', 
   TGG1.Building AS 'Building/Floor/Room', 
   TGG1.LineNum AS 'Line Number', 
   TGG1.FirstName AS 'First Name', 
   TGG1.MiddleName AS 'Middle Name', 
   TGG1.LastName AS 'Last Name', 
   TGG1.LicTradNum AS 'Federal Tax ID', 
   TGG1.AddrType AS 'Address Type', 
   TGG1.Address2 AS 'Address Name 2', 
   TGG1.Address3 AS 'Address Name 3', 
   TGG1.StreetNo AS 'Street No.', 
   TGG1.AddressID AS 'Address ID'
FROM TGG1 AS TGG1

Related information

OCPR SQL Table

OCRY SQL Table

OCST SQL Table

OTGG SQL Table

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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates