|
|
API DPO9
DPO9 - Down Payment Outgoing - Drawn Dpm Table
A/P Down Payment ODPO SQL Table
Object Settings - History ADP1 SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Document Internal ID | Int | 11 | ODPO A/P Down Payment | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| BaseAbs | Base Document Internal ID | Int | 11 | |||||
| BaseLine | Base Document Row | Int | 11 | |||||
| TargetBase | Target or Base Document | VarChar | B) Base T) Target | 1 | B | |||
| ObjType | Base Object Type | nVarChar | 20 | |||||
| DrawnSum | Net LC | Num | 20 | |||||
| DrawnSumFc | Net FC | Num | 20 | |||||
| DrawnSumSc | Net SC | Num | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjCode | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 204 | |||
| ApplDrawn | Applied Net LC | Num | 20 | |||||
| ApplDrawnF | Applied Net FC | Num | 20 | |||||
| ApplDrawnS | Applied Net SC | Num | 20 | |||||
| BaseDocNum | Base Document Number | Int | 11 | |||||
| BsDocDate | Base Posting Date | Date | 8 | |||||
| BsDueDate | Base Due Date | Date | 8 | |||||
| BsCardName | Base BP Name | nVarChar | 100 | |||||
| BsComments | Base Remarks | nVarChar | 127 | |||||
| Posted | Base Document Posted | VarChar | Y) Yes N) No | 1 | Y | |||
| Vat | Tax LC | Num | 20 | |||||
| VatFc | Tax FC | Num | 20 | |||||
| VatSc | Tax SC | Num | 20 | |||||
| Gross | Gross LC | Num | 20 | |||||
| GrossFc | Gross FC | Num | 20 | |||||
| GrossSc | Gross SC | Num | 20 | |||||
| IsGross | Is Gross Line | VarChar | N) Net Line Y) Gross Line | 1 | N |
Table relationship map
SELECT statement
SELECT
DPO9.DocEntry AS 'Document Internal ID',
DPO9.LineNum AS 'Row Number',
DPO9.BaseAbs AS 'Base Document Internal ID',
DPO9.BaseLine AS 'Base Document Row',
DPO9.TargetBase AS 'Target or Base Document',
DPO9.ObjType AS 'Base Object Type',
DPO9.DrawnSum AS 'Net LC',
DPO9.DrawnSumFc AS 'Net FC',
DPO9.DrawnSumSc AS 'Net SC',
DPO9.LogInstanc AS 'Log Instance',
DPO9.ObjCode AS 'Object Type',
DPO9.ApplDrawn AS 'Applied Net LC',
DPO9.ApplDrawnF AS 'Applied Net FC',
DPO9.ApplDrawnS AS 'Applied Net SC',
DPO9.BaseDocNum AS 'Base Document Number',
DPO9.BsDocDate AS 'Base Posting Date',
DPO9.BsDueDate AS 'Base Due Date',
DPO9.BsCardName AS 'Base BP Name',
DPO9.BsComments AS 'Base Remarks',
DPO9.Posted AS 'Base Document Posted',
DPO9.Vat AS 'Tax LC',
DPO9.VatFc AS 'Tax FC',
DPO9.VatSc AS 'Tax SC',
DPO9.Gross AS 'Gross LC',
DPO9.GrossFc AS 'Gross FC',
DPO9.GrossSc AS 'Gross SC',
DPO9.IsGross AS 'Is Gross Line'
FROM DPO9 AS DPO9
Related information
A/P Down Payment ODPO SQL Table
Object Settings - History ADP1 SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
