| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Opportunity - Rows API Sales Opportunities / Sales Opportunities Lines | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
OPR1 - Opportunity - Rows Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
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 informationSales 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 |