|
|
SQL Administration / Customer List
DTW Administration / System Initialization / Attachments2
API DGP1
DGP1 - Customer List Table
Document Generation Parameter Sets ODGP SQL Table
Business Partner OCRD SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | ODGP Document Generation Parameter Sets | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CardCode | Customer Code | nVarChar | 15 | OCRD Business Partner | ||||
| CardName | Customer Name | nVarChar | 100 | |||||
| Checked | Checked | VarChar | Y) Yes N) No | 1 | Y | |||
| CtrlAcct | Control Account | nVarChar | 15 |
Table relationship map
SELECT statement
SELECT
DGP1.AbsEntry AS 'Internal Number',
DGP1.CardCode AS 'Customer Code',
DGP1.CardName AS 'Customer Name',
DGP1.Checked AS 'Checked',
DGP1.CtrlAcct AS 'Control Account'
FROM DGP1 AS DGP1
Related information
Document Generation Parameter Sets ODGP SQL Table
Business Partner OCRD SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
