|
|
DTW Banking / Outgoing Payments / Checks for Payment / Documents Numbering - Series
API Series Service / Document Series Params
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ObjectCode KEY UNIQUE | Document | nVarChar | 20 | ONNM Document Numbering | SER_NAME | Yes |
|---|---|---|---|---|---|---|---|---|
| Series KEY UNIQUE | Series | Int | 6 | 0 | PRIMARY | Yes | ||
| SeriesName | Series Name | nVarChar | 8 | |||||
| InitialNum | Initial Number | Int | 11 | 0 | ||||
| NextNumber | Next Number for Use | Int | 11 | 0 | ||||
| LastNum | Last Number Allowed | Int | 11 | |||||
| BeginStr | Prefix String | nVarChar | 20 | |||||
| EndStr | Suffix String | nVarChar | 20 | |||||
| Remark | Remarks | nVarChar | 50 | |||||
| GroupCode | Group | Int | 1) Series Group 1 2) Series Group 2 3) Series Group 3 4) Series Group 4 5) Series Group 5 6) Series Group 6 7) Series Group 7 8) Series Group 8 9) Series Group 9 10) Series Group 10 | 6 | 1 | |||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N | |||
| YearTransf | Year-End Closing | VarChar | Y) Yes N) No | 1 | N | |||
| Indicator | Period Indicator | nVarChar | 10 | OPID Period Indicator | ' ' | |||
| Template | Template | nVarChar | 20 | |||||
| NumSize | Numeric Size | Int | 11 | |||||
| FolioPref | Folio Prefix String | nVarChar | 4 | |||||
| NextFolio | Next Folio Number | Int | 11 | |||||
| DocSubType | Document Sub-Type | nVarChar | 2 | -- | ||||
| DefESeries | Default Electronic Series | Int | 6 | 0 | ||||
| IsDigSerie | Is Digital Series | VarChar | Y) Yes N) No | 1 | N | |||
| SeriesType | Series Type | VarChar | D) Document B) Business Partner I) Item R) Resource | 1 | D | |||
| IsManual | Is Manual Series | VarChar | Y) Yes N) No | 1 | N | |||
| BPLId | Assigned Branch | Int | 11 | OBPL Business Place | ||||
| IsForCncl | Is Series for Cancelation | VarChar | Y) Yes N) No | 1 | N | |||
| AtDocType | AT Document Type | nVarChar | GT) GT GA) GA GD) GD GR) GR GC) GC FT) FT FS) FS NC) NC ND) ND FR) FR | 2 | ||||
| IsElAuth | Elec. Authorization Code | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
NNM1.ObjectCode AS 'Document',
NNM1.Series AS 'Series',
NNM1.SeriesName AS 'Series Name',
NNM1.InitialNum AS 'Initial Number',
NNM1.NextNumber AS 'Next Number for Use',
NNM1.LastNum AS 'Last Number Allowed',
NNM1.BeginStr AS 'Prefix String',
NNM1.EndStr AS 'Suffix String',
NNM1.Remark AS 'Remarks',
NNM1.GroupCode AS 'Group',
NNM1.Locked AS 'Locked',
NNM1.YearTransf AS 'Year-End Closing',
NNM1.Indicator AS 'Period Indicator',
NNM1.Template AS 'Template',
NNM1.NumSize AS 'Numeric Size',
NNM1.FolioPref AS 'Folio Prefix String',
NNM1.NextFolio AS 'Next Folio Number',
NNM1.DocSubType AS 'Document Sub-Type',
NNM1.DefESeries AS 'Default Electronic Series',
NNM1.IsDigSerie AS 'Is Digital Series',
NNM1.SeriesType AS 'Series Type',
NNM1.IsManual AS 'Is Manual Series',
NNM1.BPLId AS 'Assigned Branch',
NNM1.IsForCncl AS 'Is Series for Cancelation',
NNM1.AtDocType AS 'AT Document Type',
NNM1.IsElAuth AS 'Elec. Authorization Code'
FROM NNM1 AS NNM1
Related information
Document Series Params DocumentSeriesParams Object· Table: NNM1
The DocumentSeriesParams specifies the identification key combination (Document and Series) for which the Documents is related.
Source table: NNM1. DocumentSeries
Parent: Series Service SeriesService Service· Table: NNM1 Series Series Object· Table: NNM1
Series is a data structure related to the SeriesService.
It represents the series object, a part of a document name.
Source table: NNM1 (Documents Numbering - Series).
Parent: Series Collection SeriesCollection Collection· Table: NNM1 Series Collection SeriesCollection Collection· Table: NNM1
SeriesCollection is a data collection of Series data structures.
Source table: NNM1 (Documents Numbering - Series).
Parent: Series Service SeriesService Service· Table: NNM1 Series Service SeriesService Service· Table: NNM1
SeriesService manages the Series object, a component of the document numbering system.
Source table: NNM1 (Documents Numbering - Series).
NNM1 SQL Table
Business Place OBPL SQL Table
Period Indicator OPID SQL Table
Document Numbering ONNM SQL Table
SeriesService
Object
DocumentSeriesParams
Method
Property
Document
DB
Series
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates