|
|
DTW Opportunity - Partners
API Sales Opportunities / Sales Opportunities Partners
OPR2 - Opportunity - Partners Table
Sales Opportunities Partners SalesOpportunitiesPartners Object· Table: OPR2
Parent: Sales Opportunities SalesOpportunities Object· Table: OOPR
Relationships OORL SQL Table
Partners OPRT SQL Table
Business Partner OCRD 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 | |||||
| ParterId | Partners | Int | 11 | OPRT Partners | ||||
| Memo | Details | nVarChar | 50 | |||||
| OrlCode | Relationship Code | Int | 11 | OORL Relationships | ||||
| RelatCard | Related BP | nVarChar | 15 | OCRD 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
SalesOpportunities
Object
SalesOpportunitiesPartners
Method
Property
Details
DB
Partners
DB
RowNo
DB
SequenceNo
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
