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

SQL Business Partners / Campaign - Items

DTW Business Partners / Campaign

API Campaign Items / Campaign Item

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Primary_Key	Unique
CpnNo ^KEY ^UNIQUE	Campaign No.	Int		11	OCPN Campaign	PRIMARY	Yes
CpnLineNum	Campaign Line Number	Int		11
ItemCode	Item No.	nVarChar		20	OITM Items
ItemName	Item Description	nVarChar		100
ItemType	Item Type	VarChar	I) Items L) Labor T) Travel	1
ItemGrp	Item Group	nVarChar		20
LogIns	Log Instance - History	Int		11
VisOrder	Visual Order	Int		11

Table relationship map

SELECT statement

SELECT
   CPN2.CpnNo AS 'Campaign No.', 
   CPN2.CpnLineNum AS 'Campaign Line Number', 
   CPN2.ItemCode AS 'Item No.', 
   CPN2.ItemName AS 'Item Description', 
   CPN2.ItemType AS 'Item Type', 
   CPN2.ItemGrp AS 'Item Group', 
   CPN2.LogIns AS 'Log Instance - History', 
   CPN2.VisOrder AS 'Visual Order'
FROM CPN2 AS CPN2

Related information

CampaignItem Object· Table: CPN2

The relevant items for the campaign. Source table: CPN2.

Parent: Campaign Items CampaignItems Collection
OCPN SQL Table

OITM SQL Table

biuan SAP® BUSINESS ONE

Collection
CampaignItems

Object
CampaignItem

Enumeration

CampaignItemTypeEnum

Method

FromXMLFile

FromXMLString

GetXMLSchema

ToXMLFile

ToXMLString

Property

UserFields

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