OPR3 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Sales Opportunities /

Opportunity / Opportunity - Competitors

DTW Opportunity - Competitors

API Sales Opportunities / Sales Opportunities Competition

OPR3 - Opportunity - Competitors 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

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
OCMT SQL Table

biuan SAP® BUSINESS ONE

Object
SalesOpportunities

Object
SalesOpportunitiesCompetition

Method

Add

SetCurrentLine

Property

Competition

Count

Details

RowNo

SequenceNo

UserFields

WonOrLost

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