|
|
API ACP1
ACP1 - Campaign - BPs Table
Business Partner OCRD SQL Table
Countries OCRY SQL Table
Campaign OCPN SQL Table
Opportunity OOPR SQL Table
Response Type ORPT SQL Table
States OCST SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CpnNo KEY UNIQUE | Campaign No. | Int | 11 | OCPN Campaign | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CpnLineNum | Campaign Line Number | Int | 11 | |||||
| BpCode | BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| BpName | BP Name | nVarChar | 100 | |||||
| GroupName | BP Group Name | nVarChar | 20 | |||||
| Industry | BP Industry Name | nVarChar | 15 | |||||
| Status | BP Status | VarChar | A) Active I) Inactive | 1 | ||||
| CntCode | Contact Code | nVarChar | 50 | |||||
| CntTitle | Contact Title | nVarChar | 10 | |||||
| CntPstn | Contact Position | nVarChar | 90 | |||||
| CntEmail | Contact E-Mail | nVarChar | 100 | |||||
| CntTel | Contact Telephone | nVarChar | 20 | |||||
| CntMobile | Contact Mobile | nVarChar | 50 | |||||
| CntFax | Contact Fax | nVarChar | 20 | |||||
| CntAddr | Contact Address | nVarChar | 100 | |||||
| Response | Response from Company | VarChar | Y) Yes N) No | 1 | N | |||
| OpprId | Related Opportunity | Int | 11 | OOPR Opportunity | ||||
| LogIns | Log Instance - History | Int | 11 | |||||
| VisOrder | Visual Order | Int | 11 | |||||
| Street | Street | nVarChar | 100 | |||||
| Block | Block | nVarChar | 100 | |||||
| City | City | nVarChar | 100 | |||||
| ZipCode | Zip Code | nVarChar | 100 | |||||
| County | County | nVarChar | 100 | |||||
| State | State | nVarChar | 3 | OCST States | ||||
| Country | Country | nVarChar | 3 | OCRY Countries | ||||
| Building | Building/Floor/Room | Text | 16 | |||||
| CActivity | Create Activity [Y/N] | VarChar | 1 | Y | ||||
| DocType | Document Type | nVarChar | E) P) Opportunities Q) Sales Quotations O) Sales Orders D) Deliveries I) A/R Invoices | 20 | -1 | |||
| ShowBPDoc | Show BP Documents [Y/N] | VarChar | 1 | N | ||||
| DocNumber | Related Document | Int | 11 | |||||
| DocEntry | Document Entry | Int | 11 | |||||
| AssignTo | Assign to User or Employee | VarChar | U) User E) Employee | 1 | U | |||
| AssignName | User or Employee Name | Int | 11 | |||||
| FirstName | First Name | nVarChar | 50 | |||||
| MiddleName | Middle Name | nVarChar | 50 | |||||
| LastName | Last Name | nVarChar | 50 | |||||
| LicTradNum | Federal Tax ID | nVarChar | 32 | |||||
| AddrType | Address Type | nVarChar | 100 | |||||
| Address2 | Address Name 2 | nVarChar | 50 | |||||
| Address3 | Address Name 3 | nVarChar | 50 | |||||
| StreetNo | Street No. | nVarChar | 100 | |||||
| AddressID | Address ID | nVarChar | 50 | |||||
| RspType | Response Type | nVarChar | 20 | ORPT Response Type |
Table relationship map
SELECT statement
SELECT
ACP1.CpnNo AS 'Campaign No.',
ACP1.CpnLineNum AS 'Campaign Line Number',
ACP1.BpCode AS 'BP Code',
ACP1.BpName AS 'BP Name',
ACP1.GroupName AS 'BP Group Name',
ACP1.Industry AS 'BP Industry Name',
ACP1.Status AS 'BP Status',
ACP1.CntCode AS 'Contact Code',
ACP1.CntTitle AS 'Contact Title',
ACP1.CntPstn AS 'Contact Position',
ACP1.CntEmail AS 'Contact E-Mail',
ACP1.CntTel AS 'Contact Telephone',
ACP1.CntMobile AS 'Contact Mobile',
ACP1.CntFax AS 'Contact Fax',
ACP1.CntAddr AS 'Contact Address',
ACP1.Response AS 'Response from Company',
ACP1.OpprId AS 'Related Opportunity',
ACP1.LogIns AS 'Log Instance - History',
ACP1.VisOrder AS 'Visual Order',
ACP1.Street AS 'Street',
ACP1.Block AS 'Block',
ACP1.City AS 'City',
ACP1.ZipCode AS 'Zip Code',
ACP1.County AS 'County',
ACP1.State AS 'State',
ACP1.Country AS 'Country',
ACP1.Building AS 'Building/Floor/Room',
ACP1.CActivity AS 'Create Activity [Y/N]',
ACP1.DocType AS 'Document Type',
ACP1.ShowBPDoc AS 'Show BP Documents [Y/N]',
ACP1.DocNumber AS 'Related Document',
ACP1.DocEntry AS 'Document Entry',
ACP1.AssignTo AS 'Assign to User or Employee',
ACP1.AssignName AS 'User or Employee Name',
ACP1.FirstName AS 'First Name',
ACP1.MiddleName AS 'Middle Name',
ACP1.LastName AS 'Last Name',
ACP1.LicTradNum AS 'Federal Tax ID',
ACP1.AddrType AS 'Address Type',
ACP1.Address2 AS 'Address Name 2',
ACP1.Address3 AS 'Address Name 3',
ACP1.StreetNo AS 'Street No.',
ACP1.AddressID AS 'Address ID',
ACP1.RspType AS 'Response Type'
FROM ACP1 AS ACP1
Related information
Business Partner OCRD SQL Table
Countries OCRY SQL Table
Campaign OCPN SQL Table
Opportunity OOPR SQL Table
Response Type ORPT SQL Table
States OCST SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
