|
|
API AOPR
AOPR - Opportunity 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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | OpprId KEY UNIQUE | Sequence No. | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CardCode | BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| SlpCode | Main Sales Emp. | Int | 11 | OSLP Sales Employee | ||||
| CprCode | Contact Person | Int | 11 | OCPR Contact Persons | ||||
| Source | Source | Int | 11 | OOSR Information Source | ||||
| IntCat1 | Interest - Field 1 | Int | 11 | OOIN Interest | ||||
| IntCat2 | Interest - Field 2 | Int | 11 | OOIN Interest | ||||
| IntCat3 | Interest - Field 3 | Int | 11 | OOIN Interest | ||||
| IntRate | Interest Level | Int | 11 | OOIR Interest Level | ||||
| OpenDate | Start Date | Date | 8 | |||||
| DifType | Closing Type | VarChar | M) Months W) Weeks D) Days | 1 | D | |||
| PredDate | Predicted Closing Date | Date | 8 | |||||
| MaxSumLoc | Local Potential Amount | Num | 20 | |||||
| MaxSumSys | System Potential Amount | Num | 20 | |||||
| WtSumLoc | Weighted Amount (LC) - Document | Num | 20 | |||||
| WtSumSys | Weighted Amount (SC) | Num | 20 | |||||
| PrcnProf | Gross Profit % | Num | 20 | |||||
| SumProfL | Gross Profit Total - Local | Num | 20 | |||||
| SumProfS | Gross Profit Total - System | Num | 20 | |||||
| Memo | Remarks | Text | 16 | |||||
| Status | Status | VarChar | O) Open L) Lost W) Won | 1 | O | |||
| StatusRem | Status Remarks | nVarChar | 30 | |||||
| Reason | Reason for Closing | Int | 11 | OOFR Defect Cause | ||||
| RealSumLoc | Total Amount - Local | Num | 20 | |||||
| RealSumSys | Total Amount - System | Num | 20 | |||||
| RealProfL | Closing Gross Profit - Local | Num | 20 | |||||
| RealProfS | Closing Gross Profit - System | Num | 20 | |||||
| CloPrcnt | Closing Percentage | Num | 20 | |||||
| StepLast | Current Stage No. | Int | 6 | OOST Opportunity Stage | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Transfered | Transferred to Next Year | VarChar | Y) Yes N) No | 1 | N | |||
| Instance | Instance | Int | 6 | 0 | ||||
| CardName | BP Name | nVarChar | 100 | |||||
| CloseDate | Closing Date | Date | 8 | |||||
| LastSlp | Last Sales Emp. | Int | 11 | OSLP Sales Employee | ||||
| Name | Opportunity Name | nVarChar | 100 | |||||
| Territory | Territory | Int | 11 | OTER Territories | ||||
| Industry | Industry | Int | 11 | OOND Industries | ||||
| ChnCrdCode | BP Channel Code | nVarChar | 15 | OCRD Business Partner | ||||
| ChnCrdName | BP Channel Name | nVarChar | 100 | |||||
| PrjCode | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| CardGroup | BP Group | Int | 6 | OCRD Business Partner | ||||
| ChnCrdCon | BP Channel Contact | Int | 11 | OCPR Contact Persons | ||||
| Owner | Data Ownership field | Int | 11 | OHEM Employees | ||||
| attachment | Attachments | Text | 16 | |||||
| DocType | Linked Document Type | nVarChar | -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 | |||
| DocNum | Linked Document Number | Int | 11 | |||||
| DocEntry | Linked Document Entry | Int | 11 | |||||
| DocChkbox | Document Checkbox | VarChar | 1 | |||||
| AtcEntry | Attachment Entry | Int | 11 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 | |||||
| OpprType | Opportunity Type | VarChar | R) Sales P) Purchasing | 1 | R |
Table relationship map
SELECT statement
SELECT
AOPR.OpprId AS 'Sequence No.',
AOPR.CardCode AS 'BP Code',
AOPR.SlpCode AS 'Main Sales Emp.',
AOPR.CprCode AS 'Contact Person',
AOPR.Source AS 'Source',
AOPR.IntCat1 AS 'Interest - Field 1',
AOPR.IntCat2 AS 'Interest - Field 2',
AOPR.IntCat3 AS 'Interest - Field 3',
AOPR.IntRate AS 'Interest Level',
AOPR.OpenDate AS 'Start Date',
AOPR.DifType AS 'Closing Type',
AOPR.PredDate AS 'Predicted Closing Date',
AOPR.MaxSumLoc AS 'Local Potential Amount',
AOPR.MaxSumSys AS 'System Potential Amount',
AOPR.WtSumLoc AS 'Weighted Amount (LC) - Document',
AOPR.WtSumSys AS 'Weighted Amount (SC)',
AOPR.PrcnProf AS 'Gross Profit %',
AOPR.SumProfL AS 'Gross Profit Total - Local',
AOPR.SumProfS AS 'Gross Profit Total - System',
AOPR.Memo AS 'Remarks',
AOPR.Status AS 'Status',
AOPR.StatusRem AS 'Status Remarks',
AOPR.Reason AS 'Reason for Closing',
AOPR.RealSumLoc AS 'Total Amount - Local',
AOPR.RealSumSys AS 'Total Amount - System',
AOPR.RealProfL AS 'Closing Gross Profit - Local',
AOPR.RealProfS AS 'Closing Gross Profit - System',
AOPR.CloPrcnt AS 'Closing Percentage',
AOPR.StepLast AS 'Current Stage No.',
AOPR.UserSign AS 'User Signature',
AOPR.Transfered AS 'Transferred to Next Year',
AOPR.Instance AS 'Instance',
AOPR.CardName AS 'BP Name',
AOPR.CloseDate AS 'Closing Date',
AOPR.LastSlp AS 'Last Sales Emp.',
AOPR.Name AS 'Opportunity Name',
AOPR.Territory AS 'Territory',
AOPR.Industry AS 'Industry',
AOPR.ChnCrdCode AS 'BP Channel Code',
AOPR.ChnCrdName AS 'BP Channel Name',
AOPR.PrjCode AS 'Project Code',
AOPR.CardGroup AS 'BP Group',
AOPR.ChnCrdCon AS 'BP Channel Contact',
AOPR.Owner AS 'Data Ownership field',
AOPR.attachment AS 'Attachments',
AOPR.DocType AS 'Linked Document Type',
AOPR.DocNum AS 'Linked Document Number',
AOPR.DocEntry AS 'Linked Document Entry',
AOPR.DocChkbox AS 'Document Checkbox',
AOPR.AtcEntry AS 'Attachment Entry',
AOPR.LogInstanc AS 'Log Instance',
AOPR.UserSign2 AS 'Updating User',
AOPR.UpdateDate AS 'Update Date',
AOPR.OpprType AS 'Opportunity Type'
FROM AOPR AS AOPR
Related information
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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates