biuan SAP® BUSINESS ONE SDK
DTW Business Partners / Campaign
API Campaign Business Partners / Campaign Business Partner
CPN1 - Campaign - BPs Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CpnNo KEY UNIQUECampaign No.Int
11OCPN
Campaign
PRIMARYYes
CpnLineNumCampaign Line NumberInt
11
BpCodeBP CodenVarChar
15OCRD
Business Partner
BpNameBP NamenVarChar
100
GroupNameBP Group NamenVarChar
20
IndustryBP Industry NamenVarChar
15
StatusBP StatusVarChar
A) Active
I) Inactive
1
CntCodeContact CodenVarChar
50
CntTitleContact TitlenVarChar
10
CntPstnContact PositionnVarChar
90
CntEmailContact E-MailnVarChar
100
CntTelContact TelephonenVarChar
20
CntMobileContact MobilenVarChar
50
CntFaxContact FaxnVarChar
20
CntAddrContact AddressnVarChar
100
ResponseResponse from CompanyVarChar
Y) Yes
N) No
1
N
OpprIdRelated OpportunityInt
11OOPR
Opportunity
LogInsLog Instance - HistoryInt
11
VisOrderVisual OrderInt
11
StreetStreetnVarChar
100
BlockBlocknVarChar
100
CityCitynVarChar
100
ZipCodeZip CodenVarChar
100
CountyCountynVarChar
100
StateStatenVarChar
3OCST
States
CountryCountrynVarChar
3OCRY
Countries
BuildingBuilding/Floor/RoomText
16
CActivityCreate Activity [Y/N]VarChar
1
Y
DocTypeDocument TypenVarChar
-1)
97) Opportunities
23) Sales Quotations
17) Sales Orders
15) Deliveries
13) A/R Invoices
20
-1
ShowBPDocShow BP Documents [Y/N]VarChar
1
N
DocNumberRelated DocumentInt
11
DocEntryDocument EntryInt
11
AssignToAssign to User or EmployeeVarChar
U) User
E) Employee
1
U
AssignNameUser or Employee NameInt
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
RspTypeResponse TypenVarChar
20ORPT
Response Type

Table relationship map

SELECT statement

SELECT CPN1.CpnNo AS 'Campaign No.', CPN1.CpnLineNum AS 'Campaign Line Number', CPN1.BpCode AS 'BP Code', CPN1.BpName AS 'BP Name', CPN1.GroupName AS 'BP Group Name', CPN1.Industry AS 'BP Industry Name', CPN1.Status AS 'BP Status', CPN1.CntCode AS 'Contact Code', CPN1.CntTitle AS 'Contact Title', CPN1.CntPstn AS 'Contact Position', CPN1.CntEmail AS 'Contact E-Mail', CPN1.CntTel AS 'Contact Telephone', CPN1.CntMobile AS 'Contact Mobile', CPN1.CntFax AS 'Contact Fax', CPN1.CntAddr AS 'Contact Address', CPN1.Response AS 'Response from Company', CPN1.OpprId AS 'Related Opportunity', CPN1.LogIns AS 'Log Instance - History', CPN1.VisOrder AS 'Visual Order', CPN1.Street AS 'Street', CPN1.Block AS 'Block', CPN1.City AS 'City', CPN1.ZipCode AS 'Zip Code', CPN1.County AS 'County', CPN1.State AS 'State', CPN1.Country AS 'Country', CPN1.Building AS 'Building/Floor/Room', CPN1.CActivity AS 'Create Activity [Y/N]', CPN1.DocType AS 'Document Type', CPN1.ShowBPDoc AS 'Show BP Documents [Y/N]', CPN1.DocNumber AS 'Related Document', CPN1.DocEntry AS 'Document Entry', CPN1.AssignTo AS 'Assign to User or Employee', CPN1.AssignName AS 'User or Employee Name', CPN1.FirstName AS 'First Name', CPN1.MiddleName AS 'Middle Name', CPN1.LastName AS 'Last Name', CPN1.LicTradNum AS 'Federal Tax ID', CPN1.AddrType AS 'Address Type', CPN1.Address2 AS 'Address Name 2', CPN1.Address3 AS 'Address Name 3', CPN1.StreetNo AS 'Street No.', CPN1.AddressID AS 'Address ID', CPN1.RspType AS 'Response Type' FROM CPN1 AS CPN1

Related information


Campaign Business Partner CampaignBusinessPartner Object· Table: CPN1
The relevant business partners for the campaign. Source table: CPN1.
   Parent: Campaign Business Partners CampaignBusinessPartners Collection
Business Partner OCRD SQL Table

Countries OCRY SQL Table

Campaign OCPN SQL Table

Opportunity OOPR SQL Table

Response Type ORPT SQL Table

States OCST 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