biuan SAP® BUSINESS ONE SDK
DTW Business Partners / Campaign
API Campaign Items / Campaign Item
CPN2 - Campaign - Items Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CpnNo KEY UNIQUECampaign No.Int
11OCPN
Campaign
PRIMARYYes
CpnLineNumCampaign Line NumberInt
11
ItemCodeItem No.nVarChar
20OITM
Items
ItemNameItem DescriptionnVarChar
100
ItemTypeItem TypeVarChar
I) Items
L) Labor
T) Travel
1
ItemGrpItem GroupnVarChar
20
LogInsLog Instance - HistoryInt
11
VisOrderVisual OrderInt
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


Campaign Item CampaignItem Object· Table: CPN2
The relevant items for the campaign. Source table: CPN2.
   Parent: Campaign Items CampaignItems Collection
Campaign OCPN SQL Table

Items OITM 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