biuan SAP® BUSINESS ONE SDK
DTW Opportunity - Partners
API Sales Opportunities / Sales Opportunities Partners
OPR2 - Opportunity - Partners Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
OpportId KEY UNIQUESequence No.Int
11
PRIMARYYes
LineRow No.Int
6
ParterIdPartnersInt
11OPRT
Partners
MemoDetailsnVarChar
50
OrlCodeRelationship CodeInt
11OORL
Relationships
RelatCardRelated BPnVarChar
15OCRD
Business Partner

Table relationship map

SELECT statement

SELECT OPR2.OpportId AS 'Sequence No.', OPR2.Line AS 'Row No.', OPR2.ParterId AS 'Partners', OPR2.Memo AS 'Details', OPR2.OrlCode AS 'Relationship Code', OPR2.RelatCard AS 'Related BP' FROM OPR2 AS OPR2

Related information


Sales Opportunities Partners SalesOpportunitiesPartners Object· Table: OPR2
SalesOpportunityPartner is a child object of the SalesOpportunities object that represents the partners of the sales opportunity. Source table: OPR2.
   Parent: Sales Opportunities SalesOpportunities Object· Table: OOPR
Relationships OORL SQL Table

Partners OPRT SQL Table

Business Partner OCRD 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