|
|
DTW Opportunity - Competitors
API Sales Opportunities / Sales Opportunities Competition
OPR3 - Opportunity - Competitors Table
Sales Opportunities Competition SalesOpportunitiesCompetition Object· Table: OPR3
Parent: Sales Opportunities SalesOpportunities Object· Table: OOPR
Competitors OCMT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | OpportId KEY UNIQUE | Sequence No. | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Line | Row No. | Int | 6 | |||||
| CompetId | Competitors | Int | 11 | OCMT Competitors | ||||
| Memo | Details | nVarChar | 50 | |||||
| Won | Won or Lost | VarChar | Y) Yes N) No | 1 | N | |||
| ThreatLevl | Threat Level | Int | 1) Low 2) Medium 3) High | 6 |
SELECT statement
SELECT
OPR3.OpportId AS 'Sequence No.',
OPR3.Line AS 'Row No.',
OPR3.CompetId AS 'Competitors',
OPR3.Memo AS 'Details',
OPR3.Won AS 'Won or Lost',
OPR3.ThreatLevl AS 'Threat Level'
FROM OPR3 AS OPR3
Related information
Sales Opportunities Competition SalesOpportunitiesCompetition Object· Table: OPR3
SalesOpportunityCompetition is a child object of the SalesOpportunities object that represents the competitors of the sales opportunity.
Source table: OPR3.
Parent: Sales Opportunities SalesOpportunities Object· Table: OOPR Competitors OCMT SQL Table
SalesOpportunities
Object
SalesOpportunitiesCompetition
Method
Property
Competition
DB
Details
DB
RowNo
DB
SequenceNo
DB
WonOrLost
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates