biuan SAP® BUSINESS ONE SDK
DTW Cockpit Main Table
API Cockpits Service / Cockpit
OCPT - Cockpit Main Table Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
Code KEY UNIQUECockpit CodeInt
6
CODEYes
NameNamenVarChar
20
DescrDescriptionnVarChar
100
IsDefaultIs DefaultVarChar
Y)
N)
1
N
UserSignUser IDInt
6OUSR
Users
IsPublicPublicVarChar
Y)
N)
1
N
StrategyLayout StrategynVarChar
20
_TopClient TopInt
11
_LeftClient LeftInt
11
_WidthClient WidthInt
11
_HeightClient HeightInt
11
DatePublication DateDate
8
TimePublication TimeInt
6
MnfacturerProvidernVarChar
50
PubbyPublished BynVarChar
30
DisabledDisabledVarChar
Y)
N)
1
N
TypeTypeVarChar
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



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