| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Banking / Outgoing Payments / Checks for Payment / Documents Numbering - Series API Series Service / Document Series Params | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
NNM1 - Documents Numbering - Series Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
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 informationDocument 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 ![]() 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). ![]() Series Collection SeriesCollection Collection· Table: NNM1 SeriesCollection is a data collection of Series data structures.
Source table: NNM1 (Documents Numbering - Series). ![]() 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 |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates |