|
|
DTW Cockpit Main Table
API Cockpits Service / Cockpit
OCPT - Cockpit Main Table Table
Cockpit Cockpit Object· Table: OCPT
Parent: Cockpits Service CockpitsService Service· Table: OCPT
Cockpits Service CockpitsService Service· Table: OCPT
OCPT SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Code KEY UNIQUE | Cockpit Code | Int | 6 | CODE | Yes | |||
| Name | Name | nVarChar | 20 | |||||
| Descr | Description | nVarChar | 100 | |||||
| IsDefault | Is Default | VarChar | Y) N) | 1 | N | |||
| UserSign | User ID | Int | 6 | OUSR Users | ||||
| IsPublic | Public | VarChar | Y) N) | 1 | N | |||
| Strategy | Layout Strategy | nVarChar | 20 | |||||
| _Top | Client Top | Int | 11 | |||||
| _Left | Client Left | Int | 11 | |||||
| _Width | Client Width | Int | 11 | |||||
| _Height | Client Height | Int | 11 | |||||
| Date | Publication Date | Date | 8 | |||||
| Time | Publication Time | Int | 6 | |||||
| Mnfacturer | Provider | nVarChar | 50 | |||||
| Pubby | Published By | nVarChar | 30 | |||||
| Disabled | Disabled | VarChar | Y) N) | 1 | N | |||
| Type | Type | VarChar | U) User T) Template | 1 | U |
Table relationship map
SELECT statement
SELECT
OCPT.AbsEntry AS 'Internal Number',
OCPT.Code AS 'Cockpit Code',
OCPT.Name AS 'Name',
OCPT.Descr AS 'Description',
OCPT.IsDefault AS 'Is Default',
OCPT.UserSign AS 'User ID',
OCPT.IsPublic AS 'Public',
OCPT.Strategy AS 'Layout Strategy',
OCPT._Top AS 'Client Top',
OCPT._Left AS 'Client Left',
OCPT._Width AS 'Client Width',
OCPT._Height AS 'Client Height',
OCPT.Date AS 'Publication Date',
OCPT.Time AS 'Publication Time',
OCPT.Mnfacturer AS 'Provider',
OCPT.Pubby AS 'Published By',
OCPT.Disabled AS 'Disabled',
OCPT.Type AS 'Type'
FROM OCPT AS OCPT
Related information
Cockpit Cockpit Object· Table: OCPT
Represents a cockpit, which is a personalized work center where you can view, search, organize, and perform your regular work and related activities.
Source table: OCPT.
Parent: Cockpits Service CockpitsService Service· Table: OCPT Cockpits Service CockpitsService Service· Table: OCPT
The CockpitsService service enables you to add, look up, update, and remove cockpits.
Source table: OCPT.
OCPT SQL Table
Users OUSR SQL Table
CockpitsService
Object
Cockpit
Method
Property
AbsEntry
DB
Code
DB
Date
DB
Description
DB
Manufacturer
DB
Name
DB
Publisher
DB
Time
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
