|
|
DTW Administration / Setup / Sales Opportunities / Sales Stages
API OOST / / Sales Stages
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Num KEY UNIQUE | Sequence No. | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Descript | Name | nVarChar | 30 | |||||
| StepId KEY UNIQUE | Stage No. | Int | 6 | STEP | Yes | |||
| CloPrcnt | Closing Percentage | Num | 20 | |||||
| Canceled | Canceled | VarChar | Y) Yes N) No | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| SalesStage | Sales | VarChar | Y) Yes N) No | 1 | Y | |||
| PurStage | Purchasing | VarChar | Y) Yes N) No | 1 | Y |
Table relationship map
SELECT statement
SELECT
OOST.Num AS 'Sequence No.',
OOST.Descript AS 'Name',
OOST.StepId AS 'Stage No.',
OOST.CloPrcnt AS 'Closing Percentage',
OOST.Canceled AS 'Canceled',
OOST.UserSign AS 'User Signature',
OOST.SalesStage AS 'Sales',
OOST.PurStage AS 'Purchasing'
FROM OOST AS OOST
Related information
Sales Stages SalesStages Object· Table: OOST
The SalesStages object enables defining sales stages and their probability percentage. For example: Lead, Meeting, Quotation, Negotiation, and Order. These definitions are used as default values for the SalesOpportunities object.
Source table:...
OOST SQL Table
Users OUSR SQL Table
SalesStages
Method
Property
Cancelled
DTW DB
ClosingPercentage
DTW DB
Name
DTW DB
SequenceNo
DTW DB
Stageno
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates