biuan SAP® BUSINESS ONE SDK
API OOPR / Sales Opportunities
OOPR - Opportunity Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
OpprId KEY UNIQUESequence No.Int
11
PRIMARYYes
CardCodeBP CodenVarChar
15OCRD
Business Partner
SlpCodeMain Sales Emp.Int
11OSLP
Sales Employee
CprCodeContact PersonInt
11OCPR
Contact Persons
SourceSourceInt
11OOSR
Information Source
IntCat1Interest - Field 1Int
11OOIN
Interest
IntCat2Interest - Field 2Int
11OOIN
Interest
IntCat3Interest - Field 3Int
11OOIN
Interest
IntRateInterest LevelInt
11OOIR
Interest Level
OpenDateStart DateDate
8
DifTypeClosing TypeVarChar
M) Months
W) Weeks
D) Days
1
D
PredDatePredicted Closing DateDate
8
MaxSumLocLocal Potential AmountNum
20
MaxSumSysSystem Potential AmountNum
20
WtSumLocWeighted Amount (LC) - DocumentNum
20
WtSumSysWeighted Amount (SC)Num
20
PrcnProfGross Profit %Num
20
SumProfLGross Profit Total - LocalNum
20
SumProfSGross Profit Total - SystemNum
20
MemoRemarksText
16
StatusStatusVarChar
O) Open
L) Lost
W) Won
1
O
StatusRemStatus RemarksnVarChar
30
ReasonReason for ClosingInt
11OOFR
Defect Cause
RealSumLocTotal Amount - LocalNum
20
RealSumSysTotal Amount - SystemNum
20
RealProfLClosing Gross Profit - LocalNum
20
RealProfSClosing Gross Profit - SystemNum
20
CloPrcntClosing PercentageNum
20
StepLastCurrent Stage No.Int
6OOST
Opportunity Stage
UserSignUser SignatureInt
6OUSR
Users
TransferedTransferred to next yearVarChar
Y) Yes
N) No
1
N
InstanceInstanceInt
6
0
CardNameBP NamenVarChar
100
CloseDateClosing DateDate
8
LastSlpLast Sales Emp.Int
11OSLP
Sales Employee
NameOpportunity NamenVarChar
100
TerritoryTerritoryInt
11OTER
Territories
IndustryIndustryInt
11OOND
Industries
ChnCrdCodeBP Channel CodenVarChar
15OCRD
Business Partner
ChnCrdNameBP Channel NamenVarChar
100
PrjCodeProject CodenVarChar
20OPRJ
Project Codes
CardGroupBP GroupInt
6OCRD
Business Partner
ChnCrdConBP Channel ContactInt
11OCPR
Contact Persons
OwnerData Ownership fieldInt
11OHEM
Employees
attachmentAttachmentsText
16
DocTypeLinked Document TypenVarChar
-1)
23) 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
DocNumLinked Document NumberInt
11
DocEntryLinked Document EntryInt
11
DocChkboxDocument CheckboxVarChar
1
AtcEntryAttachment EntryInt
11
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8
OpprTypeOpportunity TypeVarChar
R) Sales
P) Purchasing
1
R

Table relationship map

SELECT statement

SELECT OOPR.OpprId AS 'Sequence No.', OOPR.CardCode AS 'BP Code', OOPR.SlpCode AS 'Main Sales Emp.', OOPR.CprCode AS 'Contact Person', OOPR.Source AS 'Source', OOPR.IntCat1 AS 'Interest - Field 1', OOPR.IntCat2 AS 'Interest - Field 2', OOPR.IntCat3 AS 'Interest - Field 3', OOPR.IntRate AS 'Interest Level', OOPR.OpenDate AS 'Start Date', OOPR.DifType AS 'Closing Type', OOPR.PredDate AS 'Predicted Closing Date', OOPR.MaxSumLoc AS 'Local Potential Amount', OOPR.MaxSumSys AS 'System Potential Amount', OOPR.WtSumLoc AS 'Weighted Amount (LC) - Document', OOPR.WtSumSys AS 'Weighted Amount (SC)', OOPR.PrcnProf AS 'Gross Profit %', OOPR.SumProfL AS 'Gross Profit Total - Local', OOPR.SumProfS AS 'Gross Profit Total - System', OOPR.Memo AS 'Remarks', OOPR.Status AS 'Status', OOPR.StatusRem AS 'Status Remarks', OOPR.Reason AS 'Reason for Closing', OOPR.RealSumLoc AS 'Total Amount - Local', OOPR.RealSumSys AS 'Total Amount - System', OOPR.RealProfL AS 'Closing Gross Profit - Local', OOPR.RealProfS AS 'Closing Gross Profit - System', OOPR.CloPrcnt AS 'Closing Percentage', OOPR.StepLast AS 'Current Stage No.', OOPR.UserSign AS 'User Signature', OOPR.Transfered AS 'Transferred to next year', OOPR.Instance AS 'Instance', OOPR.CardName AS 'BP Name', OOPR.CloseDate AS 'Closing Date', OOPR.LastSlp AS 'Last Sales Emp.', OOPR.Name AS 'Opportunity Name', OOPR.Territory AS 'Territory', OOPR.Industry AS 'Industry', OOPR.ChnCrdCode AS 'BP Channel Code', OOPR.ChnCrdName AS 'BP Channel Name', OOPR.PrjCode AS 'Project Code', OOPR.CardGroup AS 'BP Group', OOPR.ChnCrdCon AS 'BP Channel Contact', OOPR.Owner AS 'Data Ownership field', OOPR.attachment AS 'Attachments', OOPR.DocType AS 'Linked Document Type', OOPR.DocNum AS 'Linked Document Number', OOPR.DocEntry AS 'Linked Document Entry', OOPR.DocChkbox AS 'Document Checkbox', OOPR.AtcEntry AS 'Attachment Entry', OOPR.LogInstanc AS 'Log Instance', OOPR.UserSign2 AS 'Updating User', OOPR.UpdateDate AS 'Update Date', OOPR.OpprType AS 'Opportunity Type' FROM OOPR AS OOPR

Related information


Sales Opportunities SalesOpportunities Object· Table: OOPR
SalesOpportunities is a business object that represents the sales opportunities data in SAP Business One. Sales opportunities include potential sale volumes that may arise from business with customers and interested parties. This object enables...

OOPR SQL Table

Business Partner OCRD SQL Table

Contact Persons OCPR SQL Table

Industries OOND SQL Table

Interest OOIN SQL Table

Interest Level OOIR SQL Table

Sales Employee OSLP SQL Table

Employees OHEM SQL Table

Project Codes OPRJ SQL Table

Defect Cause OOFR SQL Table

Information Source OOSR SQL Table

Opportunity Stage OOST SQL Table

Territories OTER 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates