biuan SAP® BUSINESS ONE SDK
DTW Opportunity - Competitors
API Sales Opportunities / Sales Opportunities Competition
OPR3 - Opportunity - Competitors Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
OpportId KEY UNIQUESequence No.Int
11
PRIMARYYes
LineRow No.Int
6
CompetIdCompetitorsInt
11OCMT
Competitors
MemoDetailsnVarChar
50
WonWon or LostVarChar
Y) Yes
N) No
1
N
ThreatLevlThreat LevelInt
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



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