|
|
SQL Business Partners / Campaign
API ACPN
ACPN - Campaign Table
Attachments OATC SQL Table
Employees OHEM SQL Table
Target Group OTGG SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CpnNo KEY UNIQUE | Campaign No. | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name | Campaign Name | nVarChar | 100 | |||||
| Type | Campaign Type | VarChar | E) E-Mail M) Mail F) Fax P) Phone Call T) Meeting S) SMS W) Web O) Other | 1 | E | |||
| TargetGrp | Target Group | nVarChar | 20 | OTGG Target Group | ||||
| Owner | Campaign Owner | Int | 11 | OHEM Employees | ||||
| Status | Campaign Status | VarChar | O) Open F) Finished C) Canceled | 1 | O | |||
| StartDate | Campaign Start Date | Date | 8 | |||||
| FinishDate | Campaign Finish Date | Date | 8 | |||||
| Remarks | Campaign Remarks | Text | 16 | |||||
| WizardGen | Generated by Wizard | VarChar | Y) Yes N) No | 1 | N | |||
| Template | Campaign Template | Text | 16 | |||||
| AtcEntry | Attachment Entry | Int | 11 | OATC Attachments | ||||
| Attachment | Attachments | Text | 16 | |||||
| LogIns | Log Instance - History | Int | 11 | |||||
| UserSign2 | Updating User - History | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update - History | Date | 8 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| CreateDate | Create Date | Date | 8 | |||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Upgrade M) Import O) DI API A) Auto Summary P) Partner Implementation T) Year of Transfer | 1 | N | |||
| Transfered | Year Transfer | VarChar | 1 | N | ||||
| Instance | Instance | Int | 6 | 0 | ||||
| Url | Web Link | Text | 16 | |||||
| TmplPath | Template Path | nVarChar | 127 |
Table relationship map
SELECT statement
SELECT
ACPN.CpnNo AS 'Campaign No.',
ACPN.Name AS 'Campaign Name',
ACPN.Type AS 'Campaign Type',
ACPN.TargetGrp AS 'Target Group',
ACPN.Owner AS 'Campaign Owner',
ACPN.Status AS 'Campaign Status',
ACPN.StartDate AS 'Campaign Start Date',
ACPN.FinishDate AS 'Campaign Finish Date',
ACPN.Remarks AS 'Campaign Remarks',
ACPN.WizardGen AS 'Generated by Wizard',
ACPN.Template AS 'Campaign Template',
ACPN.AtcEntry AS 'Attachment Entry',
ACPN.Attachment AS 'Attachments',
ACPN.LogIns AS 'Log Instance - History',
ACPN.UserSign2 AS 'Updating User - History',
ACPN.UpdateDate AS 'Date of Update - History',
ACPN.UserSign AS 'User Signature',
ACPN.CreateDate AS 'Create Date',
ACPN.DataSource AS 'Data Source',
ACPN.Transfered AS 'Year Transfer',
ACPN.Instance AS 'Instance',
ACPN.Url AS 'Web Link',
ACPN.TmplPath AS 'Template Path'
FROM ACPN AS ACPN
Related information
Attachments OATC SQL Table
Employees OHEM SQL Table
Target Group OTGG SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
