|
|
API CPI20
CPI20 - Intrastat Expenses Table
A/P Correction Invoice OCPI SQL Table
Freight Setup OEXD SQL Table
Currency Codes OCRN 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 | OCPI A/P Correction Invoice | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ExpnsCode | Freight Code | Int | 11 | OEXD Freight Setup | ||||
| TotalLC | Total | Num | 20 | |||||
| TotalFC | Total (FC) | Num | 20 | |||||
| TotalSC | Total (SC) | Num | 20 | |||||
| DistribM | Distribution Method | VarChar | Q) Quantity V) Volume W) Weight E) Equally T) Row Total | 1 | T | |||
| DrawnLC | Drawn Total | Num | 20 | |||||
| DrawnFC | Drawn Total (FC) | Num | 20 | |||||
| DrawnSC | Drawn Total (SC) | Num | 20 | |||||
| LineNum | Line Number | Int | 11 | -1 | ||||
| BaseAbsEnt | Base Abs. Entry | Int | 11 | -1 | ||||
| BaseType | Base Document Type | Int | 23) Sales Quotation 17) Sales Order 15) Delivery Notes 16) Return 13) A/R Invoice 203) Down Payment Incoming 204) Down Payment Outgoing 22) Purchase Order 20) Goods Receipt PO 21) Goods Return 18) A/P Invoice 540000006) Purchase Quotation 0 -1) | 11 | -1 | |||
| BaseRef | Base Document Reference | Int | 11 | |||||
| BaseLnNum | Base Document Row No. | Int | 11 | -1 | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjectType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 163 | |||
| FixCurr | Fixation Currency | nVarChar | 3 | OCRN Currency Codes |
Table relationship map
SELECT statement
SELECT
CPI20.DocEntry AS 'Document Internal ID',
CPI20.ExpnsCode AS 'Freight Code',
CPI20.TotalLC AS 'Total',
CPI20.TotalFC AS 'Total (FC)',
CPI20.TotalSC AS 'Total (SC)',
CPI20.DistribM AS 'Distribution Method',
CPI20.DrawnLC AS 'Drawn Total',
CPI20.DrawnFC AS 'Drawn Total (FC)',
CPI20.DrawnSC AS 'Drawn Total (SC)',
CPI20.LineNum AS 'Line Number',
CPI20.BaseAbsEnt AS 'Base Abs. Entry',
CPI20.BaseType AS 'Base Document Type',
CPI20.BaseRef AS 'Base Document Reference',
CPI20.BaseLnNum AS 'Base Document Row No.',
CPI20.LogInstanc AS 'Log Instance',
CPI20.ObjectType AS 'Object Type',
CPI20.FixCurr AS 'Fixation Currency'
FROM CPI20 AS CPI20
Related information
A/P Correction Invoice OCPI SQL Table
Freight Setup OEXD SQL Table
Currency Codes OCRN 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
