biuan SAP® BUSINESS ONE SDK
API ACP3
ACP3 - Campaign - Partners Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CpnNo KEY UNIQUECampaign No.Int
11OCPN
Campaign
PRIMARYYes
CpnLineNumCampaign Line NumberInt
11
ParterIdPartnersInt
11OPRT
Partners
OrlCodeRelationship CodeInt
11OORL
Relationships
RelatCardRelated BPnVarChar
15OCRD
Business Partner
MemoDetailsnVarChar
50
LogInsLog Instance - HistoryInt
11
VisOrderVisual OrderInt
11

Table relationship map

SELECT statement

SELECT ACP3.CpnNo AS 'Campaign No.', ACP3.CpnLineNum AS 'Campaign Line Number', ACP3.ParterId AS 'Partners', ACP3.OrlCode AS 'Relationship Code', ACP3.RelatCard AS 'Related BP', ACP3.Memo AS 'Details', ACP3.LogIns AS 'Log Instance - History', ACP3.VisOrder AS 'Visual Order' FROM ACP3 AS ACP3

Related information


Campaign OCPN SQL Table

Relationships OORL SQL Table

Partners OPRT SQL Table

Business Partner OCRD 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