biuan SAP® BUSINESS ONE SDK
DTW Opportunity - Reasons
API Sales Opportunities / Sales Opportunities Reasons
OPR5 - Opportunity - Reasons Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
OpportId KEY UNIQUESequence No.Int
11
PRIMARYYes
LineRow No.Int
6
ReasondIdReasonInt
11OOFR
Defect Cause

SELECT statement

SELECT OPR5.OpportId AS 'Sequence No.', OPR5.Line AS 'Row No.', OPR5.ReasondId AS 'Reason' FROM OPR5 AS OPR5

Related information


Sales Opportunities Reasons SalesOpportunitiesReasons Object· Table: OPR5
SalesOpportunitiesReasons is a child object of the SalesOpportunities object and represents the reasons for failures of sales opportunity. Source table: OPR5.
   Parent: Sales Opportunities SalesOpportunities Object· Table: OOPR
Defect Cause OOFR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates