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

SQL Business Partners / Campaign - Items

API ACP2

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
   ACP2.CpnNo AS 'Campaign No.', 
   ACP2.CpnLineNum AS 'Campaign Line Number', 
   ACP2.ItemCode AS 'Item No.', 
   ACP2.ItemName AS 'Item Description', 
   ACP2.ItemType AS 'Item Type', 
   ACP2.ItemGrp AS 'Item Group', 
   ACP2.LogIns AS 'Log Instance - History', 
   ACP2.VisOrder AS 'Visual Order'
FROM ACP2 AS ACP2

Related information

OCPN SQL Table

OITM 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