|
|
DTW Banking / Incoming Payments / Incoming Payments
API ODGP
ODGP - Document Generation Parameter Sets Table
ODGP SQL Table
Business Place OBPL SQL Table
Electronic Series NNM4 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 |
|---|---|---|---|---|---|---|---|---|
| SetName KEY UNIQUE | Set Name | nVarChar | 20 | SET_NAME | Yes | |||
| SetDesc | Set Description | nVarChar | 100 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| ModifyDate | Last Modified | Date | 8 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Target | Target Document Type | nVarChar | -1) 17) Sales Order 15) Delivery 16) Returns 13) A/R Invoice | 20 | -1 | |||
| PostDate | Posting Date | Date | 8 | |||||
| TaxDate | Document Date | Date | 8 | |||||
| Series | Series | Int | 6 | |||||
| Items | Items Documents Summary | VarChar | Y) Yes N) No | 1 | Y | |||
| ItemSmmry | Items Summary Method | VarChar | N) No Summary I) Summary by Items D) Summary by Documents | 1 | N | |||
| Service | Service Documents Summary | VarChar | Y) Yes N) No | 1 | N | |||
| ServSmmry | Service Summary Method | VarChar | N) No Summary D) Summary by Documents | 1 | N | |||
| ExchgRate | Exchange Rate | VarChar | D) Use Base Doc. and Row Rate B) Use Base Row Rate C) Use Current Rate | 1 | C | |||
| CreatDraft | Create Drafts | VarChar | Y) Yes N) No | 1 | N | |||
| BaseQUT | Sales Quotation Summary | VarChar | Y) Yes N) No | 1 | N | |||
| BaseRDR | Order Summary | VarChar | Y) Yes N) No | 1 | N | |||
| BaseDLN | Delivery Summary | VarChar | Y) Yes N) No | 1 | N | |||
| BaseRDN | Returns Summary | VarChar | Y) Yes N) No | 1 | N | |||
| BaseResINV | A/R Reserve Invoice Summary | VarChar | Y) Yes N) No | 1 | N | |||
| ExpndSel | Expanded Selection Criteria | VarChar | Y) Yes N) No | 1 | N | |||
| SortField | Sort Field | nVarChar | DocNum) Document Number DocDate) Posting Date DocDueDate) Due Date NumAtCard) BP Reference No. DocTotal) Document Amount SlpCode) Sales Employee | 100 | DocNum | |||
| Consolidat | Consolidate | VarChar | Y) Yes N) No | 1 | Y | |||
| ExpandCons | Expanded Consolidation Options | VarChar | Y) Yes N) No | 1 | N | |||
| RCNSummary | Reference Document | VarChar | Y) Yes N) No | 1 | N | |||
| ChainCode | Retail Chain | Int | 11 | |||||
| OredrNum1 | Order No. From | Int | 11 | |||||
| OredrNum2 | To | Int | 11 | |||||
| Direct | Direct | VarChar | Y) Yes N) No | 1 | N | |||
| Indirect | Indirect | VarChar | Y) Yes N) No | 1 | N | |||
| DoReport | Overview of Invoice Deliveries | VarChar | Y) Yes N) No | 1 | N | |||
| FileExport | File Export | VarChar | Y) Yes N) No | 1 | N | |||
| SavePath | File Path | Text | 16 | |||||
| DealNum | Closing No. | nVarChar | 12 | |||||
| UseDirect | Direct/Indirect | VarChar | Y) Yes N) No | 1 | N | |||
| NoItmCode | Drop Item No. Where Cat. No. E | VarChar | Y) Yes N) No | 1 | N | |||
| OnData | Missing Data | VarChar | N) Skip to Next Document B) Skip to Next Customer W) Ask for User Confirmation | 1 | N | |||
| OnLedger | Bookkeeping Alert | VarChar | N) Skip to Next Document B) Skip to Next Customer W) Ask for User Confirmation | 1 | N | |||
| OnInvnt | Warehouse Alert | VarChar | N) Skip to Next Document B) Skip to Next Customer W) Ask for User Confirmation | 1 | N | |||
| Summary | Summary | nVarChar | 127 | |||||
| AltItmDocs | Process docsc with alt. items | VarChar | Y) Yes N) No | 1 | Y | |||
| PartDelivr | Partial Delivery | VarChar | Y) Yes N) No | 1 | N | |||
| ConsiderBP | Consider BP | VarChar | Y) Yes N) No | 1 | Y | |||
| ConsiderTy | Consider Type | VarChar | Y) Yes N) No | 1 | Y | |||
| EDocGenTyp | Electr. Doc. Generation Type | VarChar | G) Generate L) Generate - Later S) Send R) Send - Later N) Not Relevant | 1 | N | |||
| ESeries | Electronic Series | Int | 6 | NNM4 Electronic Series | ||||
| EDocNum | Electronic Document Number | nVarChar | 20 | |||||
| ReopOriRdr | Reopen Origin. Order by Return | VarChar | Y) Yes N) No | 1 | N | |||
| ReopManCls | Reop. Man. Closed/Canc. Orders | VarChar | Y) Yes N) No | 1 | N | |||
| SeqCode | Target Doc. NF Sequence Code | Int | 6 | |||||
| UseBaseSeq | Use Base Document NF Sequence | VarChar | Y) Yes N) No | 1 | N | |||
| OnSeqCode | Missing NF Sequence | VarChar | N) Skip to Next Document T) Use NF Sequence from Step 2 | 1 | N | |||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| BlckFrOnly | Block Docs. with Zero Items | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
ODGP.AbsEntry AS 'Internal Number',
ODGP.SetName AS 'Set Name',
ODGP.SetDesc AS 'Set Description',
ODGP.CreateDate AS 'Creation Date',
ODGP.ModifyDate AS 'Last Modified',
ODGP.UserSign AS 'User Signature',
ODGP.Target AS 'Target Document Type',
ODGP.PostDate AS 'Posting Date',
ODGP.TaxDate AS 'Document Date',
ODGP.Series AS 'Series',
ODGP.Items AS 'Items Documents Summary',
ODGP.ItemSmmry AS 'Items Summary Method',
ODGP.Service AS 'Service Documents Summary',
ODGP.ServSmmry AS 'Service Summary Method',
ODGP.ExchgRate AS 'Exchange Rate',
ODGP.CreatDraft AS 'Create Drafts',
ODGP.BaseQUT AS 'Sales Quotation Summary',
ODGP.BaseRDR AS 'Order Summary',
ODGP.BaseDLN AS 'Delivery Summary',
ODGP.BaseRDN AS 'Returns Summary',
ODGP.BaseResINV AS 'A/R Reserve Invoice Summary',
ODGP.ExpndSel AS 'Expanded Selection Criteria',
ODGP.SortField AS 'Sort Field',
ODGP.Consolidat AS 'Consolidate',
ODGP.ExpandCons AS 'Expanded Consolidation Options',
ODGP.RCNSummary AS 'Reference Document',
ODGP.ChainCode AS 'Retail Chain',
ODGP.OredrNum1 AS 'Order No. From',
ODGP.OredrNum2 AS 'To',
ODGP.Direct AS 'Direct',
ODGP.Indirect AS 'Indirect',
ODGP.DoReport AS 'Overview of Invoice Deliveries',
ODGP.FileExport AS 'File Export',
ODGP.SavePath AS 'File Path',
ODGP.DealNum AS 'Closing No.',
ODGP.UseDirect AS 'Direct/Indirect',
ODGP.NoItmCode AS 'Drop Item No. Where Cat. No. E',
ODGP.OnData AS 'Missing Data',
ODGP.OnLedger AS 'Bookkeeping Alert',
ODGP.OnInvnt AS 'Warehouse Alert',
ODGP.Summary AS 'Summary',
ODGP.AltItmDocs AS 'Process docsc with alt. items',
ODGP.PartDelivr AS 'Partial Delivery',
ODGP.ConsiderBP AS 'Consider BP',
ODGP.ConsiderTy AS 'Consider Type',
ODGP.EDocGenTyp AS 'Electr. Doc. Generation Type',
ODGP.ESeries AS 'Electronic Series',
ODGP.EDocNum AS 'Electronic Document Number',
ODGP.ReopOriRdr AS 'Reopen Origin. Order by Return',
ODGP.ReopManCls AS 'Reop. Man. Closed/Canc. Orders',
ODGP.SeqCode AS 'Target Doc. NF Sequence Code',
ODGP.UseBaseSeq AS 'Use Base Document NF Sequence',
ODGP.OnSeqCode AS 'Missing NF Sequence',
ODGP.BPLId AS 'Branch',
ODGP.BlckFrOnly AS 'Block Docs. with Zero Items'
FROM ODGP AS ODGP
Related information
ODGP SQL Table
Business Place OBPL SQL Table
Electronic Series NNM4 SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
