biuan SAP® BUSINESS ONE SDK
DTW Opportunity - Rows
API Sales Opportunities / Sales Opportunities Lines
OPR1 - Opportunity - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
OpprId KEY UNIQUESequence No.Int
11OOPR
Opportunity
PRIMARYYes
LineRow No.Int
6
SlpCodeSales EmployeeInt
11OSLP
Sales Employee
CntctCodeContact PersonInt
11OCPR
Contact Persons
OpenDateStart DateDate
8
CloseDateClosing DateDate
8
Step_IdStage KeyInt
11OOST
Opportunity Stage
ClosePrcntPercentage RateNum
20
MaxSumLocMax. Local TotalNum
20
MaxSumSysMax. System TotalNum
20
MemoRemarksText
16
DocIdObject CodeInt
11
ObjTypeObject TypenVarChar
-1)
0
23) Sales Quotations
17) Sales Orders
15) Delivery Notes
13) Sales Invoices
540000006) Purchase Quotations
22) Purchase Orders
20) Goods Receipt POs
18) Purchase Invoices
9
-1
StatusStatusVarChar
O) Open
C) Closed
1
O
LinkedActivityVarChar
Y) Yes
N) No
1
N
WtSumLocWeighted Amount (LC) - RowsNum
20
WtSumSysWeighted Amount (SC)Num
20
UserSignUser SignatureInt
6OUSR
Users
ChnCrdCodeBP Channel CodenVarChar
15OCRD
Business Partner
ChnCrdNameBP Channel NamenVarChar
100
ChnCrdConBP Channel ContactInt
11OCPR
Contact Persons
DocChkboxDocument CheckboxVarChar
Y) Yes
N) No
1
OwnerData Ownership FieldInt
11OHEM
Employees
DocNumberDocument NumberInt
11

Table relationship map

SELECT statement

SELECT OPR1.OpprId AS 'Sequence No.', OPR1.Line AS 'Row No.', OPR1.SlpCode AS 'Sales Employee', OPR1.CntctCode AS 'Contact Person', OPR1.OpenDate AS 'Start Date', OPR1.CloseDate AS 'Closing Date', OPR1.Step_Id AS 'Stage Key', OPR1.ClosePrcnt AS 'Percentage Rate', OPR1.MaxSumLoc AS 'Max. Local Total', OPR1.MaxSumSys AS 'Max. System Total', OPR1.Memo AS 'Remarks', OPR1.DocId AS 'Object Code', OPR1.ObjType AS 'Object Type', OPR1.Status AS 'Status', OPR1.Linked AS 'Activity', OPR1.WtSumLoc AS 'Weighted Amount (LC) - Rows', OPR1.WtSumSys AS 'Weighted Amount (SC)', OPR1.UserSign AS 'User Signature', OPR1.ChnCrdCode AS 'BP Channel Code', OPR1.ChnCrdName AS 'BP Channel Name', OPR1.ChnCrdCon AS 'BP Channel Contact', OPR1.DocChkbox AS 'Document Checkbox', OPR1.Owner AS 'Data Ownership Field', OPR1.DocNumber AS 'Document Number' FROM OPR1 AS OPR1

Related information


Sales Opportunities Lines SalesOpportunitiesLines Object· Table: OPR1
SalesOpportunityLines is a child object of the SalesOpportunities object and represents the stages of the sales opportunity. Source table: OPR1.
   Parent: Sales Opportunities SalesOpportunities Object· Table: OOPR
Business Partner OCRD SQL Table

Contact Persons OCPR SQL Table

Opportunity OOPR SQL Table

Employees OHEM SQL Table

Sales Employee OSLP SQL Table

Opportunity Stage OOST SQL Table

Users OUSR 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