| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Business Partners / Campaign / Campaign API Campaigns Service / Campaign | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
OCPN - Campaign Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
OCPN.CpnNo AS 'Campaign No.',
OCPN.Name AS 'Campaign Name',
OCPN.Type AS 'Campaign Type',
OCPN.TargetGrp AS 'Target Group',
OCPN.Owner AS 'Campaign Owner',
OCPN.Status AS 'Campaign Status',
OCPN.StartDate AS 'Campaign Start Date',
OCPN.FinishDate AS 'Campaign Finish Date',
OCPN.Remarks AS 'Campaign Remarks',
OCPN.WizardGen AS 'Generated by Wizard',
OCPN.Template AS 'Campaign Template',
OCPN.AtcEntry AS 'Attachment Entry',
OCPN.Attachment AS 'Attachments',
OCPN.LogIns AS 'Log Instance - History',
OCPN.UserSign2 AS 'Updating User - History',
OCPN.UpdateDate AS 'Date of Update - History',
OCPN.UserSign AS 'User Signature',
OCPN.CreateDate AS 'Create Date',
OCPN.DataSource AS 'Data Source',
OCPN.Transfered AS 'Year Transfer',
OCPN.Instance AS 'Instance',
OCPN.Url AS 'Web Link',
OCPN.TmplPath AS 'Template Path'
FROM OCPN AS OCPN Related informationCampaign Campaign Object· Table: OCPN You can create, maintain, and analyze your marketing event information using the campaign management feature.
Source table: OCPN. Parent: Campaigns Service CampaignsService Service· Table: OCPN Campaigns Service CampaignsService Service· Table: OCPN The CampaignsService service enables you to add, look up, update, cancel, and remove campaigns.
Source table: OCPN. OCPN SQL Table Attachments OATC SQL Table Employees OHEM SQL Table Target Group OTGG SQL Table Users OUSR SQL Table |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |