|
|
DTW Administration / Setup / General / Sales Employees
API Series Lines / Series Line
CSN1 - Certificate Series - Series Table
Series Line SeriesLine Object· Table: CSN1
Parent: Series Lines SeriesLines Collection
Certificate Series OCSN SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsId KEY UNIQUE | Internal Number | Int | 11 | OCSN Certificate Series | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Series | Series | Int | 6 | |||||
| BeginStr | Prefix | nVarChar | 20 | |||||
| InitialNum | First No. | Int | 11 | 1 | ||||
| NextNum | Next No. | Int | 11 | 1 | ||||
| LastNum | Last No. | Int | 11 |
SELECT statement
SELECT
CSN1.AbsId AS 'Internal Number',
CSN1.Series AS 'Series',
CSN1.BeginStr AS 'Prefix',
CSN1.InitialNum AS 'First No.',
CSN1.NextNum AS 'Next No.',
CSN1.LastNum AS 'Last No.'
FROM CSN1 AS CSN1
Related information
Series Line SeriesLine Object· Table: CSN1
Contains the details of a certificate series.
Source table: CSN1
Parent: Series Lines SeriesLines CollectionCertificate Series OCSN SQL Table
SeriesLines
Object
SeriesLine
Method
Property
FirstNum
DB
LastNum
DB
NextNum
DB
Prefix
DB
Collection
Enumeration
Method
Object
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
