biuan SAP® BUSINESS ONE SDK
DTW Competitors
API Sales Opportunity Competitors Setup Service / Sales Opportunity Competitor Setup
OCMT - Competitors Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CompetId KEY UNIQUESequence No.Int
11
PRIMARYYes
NameNamenVarChar
15
ThreatLevlThreat LevelInt
1) Low
2) Medium
3) High
6
1
MemoDetailsnVarChar
50
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OCMT.CompetId AS 'Sequence No.', OCMT.Name AS 'Name', OCMT.ThreatLevl AS 'Threat Level', OCMT.Memo AS 'Details', OCMT.DataSource AS 'Data Source', OCMT.UserSign AS 'User Signature' FROM OCMT AS OCMT

Related information


Sales Opportunity Competitor Setup SalesOpportunityCompetitorSetup Object· Table: OCMT
Represents a competitor. Source table: OCMT Mandatory properties: Name
   Parent: Sales Opportunity Competitors Setup Service SalesOpportunityCompetitorsSetupService Service· Table: OCMT

Sales Opportunity Competitors Setup Service SalesOpportunityCompetitorsSetupService Service· Table: OCMT
The SalesOpportunityCompetitorsSetupService service enables you to add, look up and remove competitors in the competitors master data table. Competitors can be assigned to sales opportunities. To see the list of competitors, select Sales...

OCMT 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