biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Business Partners / Target Group
API TGG1
TGG1 - Target Group Details Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TargetCode KEY UNIQUETarget Group CodenVarChar
20OTGG
Target Group
PRIMARYYes
CardCodeBP CodenVarChar
15
CardNameBP NamenVarChar
100
GroupCodeGroup CodenVarChar
20
IndustryIndustryText
16
validForActiveVarChar
A) Active
I) Inactive
1
CntctPrsnContact PersonnVarChar
50OCPR
Contact Persons
TitleTitlenVarChar
10
PositionPositionnVarChar
90
E_MailE-MailnVarChar
100
TelephoneTelephonenVarChar
20
CellolarMobile PhonenVarChar
50
FaxFaxnVarChar
20
AddressAddressnVarChar
100
StreetStreetnVarChar
100
BlockBlocknVarChar
100
CityCitynVarChar
100
ZipCodeZip CodenVarChar
20
CountyCountynVarChar
100
StateStatenVarChar
3OCST
States
CountryCountrynVarChar
3OCRY
Countries
BuildingBuilding/Floor/RoomText
16
LineNumLine NumberInt
11
FirstNameFirst NamenVarChar
50
MiddleNameMiddle NamenVarChar
50
LastNameLast NamenVarChar
50
LicTradNumFederal Tax IDnVarChar
32
AddrTypeAddress TypenVarChar
100
Address2Address Name 2nVarChar
50
Address3Address Name 3nVarChar
50
StreetNoStreet No.nVarChar
100
AddressIDAddress IDnVarChar
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


Contact Persons OCPR SQL Table

Countries OCRY SQL Table

States OCST SQL Table

Target Group OTGG 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