|
|
DTW A/P Correction Invoice - Freight
API Documents Additional Expenses / Base Doc Entry
CPI3 - A/P Correction Invoice - Freight Table
v9.0 Base Doc Entry BaseDocEntry Property· Table: CPI3
Parent: Documents Additional Expenses DocumentsAdditionalExpenses Object· Table: DRF3 RPC3 PCH3 CPI3 CPV3 PDN3 RPD3 POR3 PQT3 RIN3 INV3 CSI3 CSV3 DLN3 RDN3 RDR3 QUT3
A/P Correction Invoice OCPI SQL Table
Freight Setup OEXD SQL Table
Currency Codes OCRN SQL Table
Object Settings - History ADP1 SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Sales Tax Codes OSTC SQL Table
Tax Definition OVTG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY | Document Internal ID | Int | 11 | OCPI A/P Correction Invoice | DOCUMENT | No |
|---|---|---|---|---|---|---|---|---|
| ExpnsCode | Expense Code | Int | 11 | OEXD Freight Setup | ||||
| LineTotal | Total | Num | 20 | |||||
| TotalFrgn | Total (FC) | Num | 20 | |||||
| TotalSumSy | Total (SC) | Num | 20 | |||||
| PaidToDate | Paid to Date | Num | 20 | |||||
| PaidFC | Paid in FC | Num | 20 | |||||
| PaidSys | Paid in SC | Num | 20 | |||||
| Comments | Remarks | nVarChar | 100 | |||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 163 | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| DistrbMthd | Distribution Method | VarChar | N) None Q) Quantity V) Volume W) Weight E) Equally T) Row Total | 1 | ||||
| TaxStatus | Tax Liable | VarChar | Y) Yes N) No | 1 | Y | |||
| VatGroup | Tax Group | nVarChar | 8 | OVTG Tax Definition | ||||
| VatPrcnt | Row Tax % | Num | 20 | |||||
| VatSum | Tax Amount | Num | 20 | |||||
| VatSumFrgn | Tax Amount (FC) | Num | 20 | |||||
| VatSumSy | Tax Amount (SC) | Num | 20 | |||||
| DedVatSum | Deductible Tax Amount | Num | 20 | |||||
| DedVatSumF | Deductible Tax Amount (FC) | Num | 20 | |||||
| DedVatSumS | Deductible Tax Amount (SC) | Num | 20 | |||||
| IsAcquistn | Aquisition Tax | VarChar | Y) Yes N) No | 1 | N | |||
| TaxCode | Tax Code | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| TaxType | Tax Type | VarChar | Y) Regular Tax N) No Tax U) Use Tax | 1 | Y | |||
| WTLiable | WT Liable | VarChar | Y) Yes N) No | 1 | ||||
| VatApplied | Vat Applied | Num | 20 | |||||
| VatAppldFC | Applied Tax (FC) | Num | 20 | |||||
| VatAppldSC | Applied Tax (SC) | Num | 20 | |||||
| EquVatPer | Equalization Tax % | Num | 20 | |||||
| EquVatSum | Total Equalization Tax | Num | 20 | |||||
| EquVatSumF | Total Equalization Tax (FC) | Num | 20 | |||||
| EquVatSumS | Total Equalization Tax (SC) | Num | 20 | |||||
| LineVat | Net Tax Amount | Num | 20 | |||||
| LineVatF | Net Tax Amount (FC) | Num | 20 | |||||
| LineVatS | Net Tax Amount (SC) | Num | 20 | |||||
| BaseMethod | Base Method | VarChar | N) None Q) Quantity V) Volume W) Weight T) Total A) All | 1 | ||||
| Stock | Stock | VarChar | Y) Yes N) No | 1 | ||||
| LstPchPrce | Last Purchase Price | VarChar | Y) Yes N) No | 1 | ||||
| AnalysRpt | Analysis Report | VarChar | Y) Yes N) No | 1 | N | |||
| BaseAbsEnt | Base Abs Entry | Int | 11 | -1 | ||||
| BaseType | Base Document Type | Int | -1) 0 18) A/P Invoice 163) A/P Correction Invoice | 11 | ||||
| BaseRef | Base Document Reference | Int | 11 | |||||
| BaseLnNum | Base Document Line No. | Int | 11 | |||||
| LineNum | line num | Int | 11 | -1 | ||||
| Status | Status | VarChar | O) Open C) Closed | 1 | O | |||
| TrgType | Target Type | Int | 11 | |||||
| TrgAbsEnt | Target Abs. Entry | Int | 11 | -1 | ||||
| StDstr | Stock Distributed Sum | Num | 20 | |||||
| StDstrSC | Stock Distributed Sum (SC) | Num | 20 | |||||
| StDstrFC | Stock Distributed Sum (FC) | Num | 20 | |||||
| FixCurr | Fixation Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| VatDscntPr | Tax Discount % | Num | 20 | |||||
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| TaxDistMtd | Tax Distribution Method | VarChar | N) None Q) Quantity V) Volume W) Weight E) Equally T) Row Total | 1 | ||||
| OcrCode2 | Distribution Rule2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Distribution Rule3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Distribution Rule4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Distribution Rule5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| VatGrpSrc | VAT Group Source | VarChar | N) Not Defined M) Manually Entered D) Determined | 1 | N | |||
| DrawnTotal | Drawn Total | Num | 20 | |||||
| DrawnFC | Drawn Total (FC) | Num | 20 | |||||
| DrawnSC | Drawn Total (SC) | Num | 20 |
Table relationship map
SELECT statement
SELECT
CPI3.DocEntry AS 'Document Internal ID',
CPI3.ExpnsCode AS 'Expense Code',
CPI3.LineTotal AS 'Total',
CPI3.TotalFrgn AS 'Total (FC)',
CPI3.TotalSumSy AS 'Total (SC)',
CPI3.PaidToDate AS 'Paid to Date',
CPI3.PaidFC AS 'Paid in FC',
CPI3.PaidSys AS 'Paid in SC',
CPI3.Comments AS 'Remarks',
CPI3.ObjType AS 'Object Type',
CPI3.LogInstanc AS 'Log Instance',
CPI3.DistrbMthd AS 'Distribution Method',
CPI3.TaxStatus AS 'Tax Liable',
CPI3.VatGroup AS 'Tax Group',
CPI3.VatPrcnt AS 'Row Tax %',
CPI3.VatSum AS 'Tax Amount',
CPI3.VatSumFrgn AS 'Tax Amount (FC)',
CPI3.VatSumSy AS 'Tax Amount (SC)',
CPI3.DedVatSum AS 'Deductible Tax Amount',
CPI3.DedVatSumF AS 'Deductible Tax Amount (FC)',
CPI3.DedVatSumS AS 'Deductible Tax Amount (SC)',
CPI3.IsAcquistn AS 'Aquisition Tax',
CPI3.TaxCode AS 'Tax Code',
CPI3.TaxType AS 'Tax Type',
CPI3.WTLiable AS 'WT Liable',
CPI3.VatApplied AS 'Vat Applied',
CPI3.VatAppldFC AS 'Applied Tax (FC)',
CPI3.VatAppldSC AS 'Applied Tax (SC)',
CPI3.EquVatPer AS 'Equalization Tax %',
CPI3.EquVatSum AS 'Total Equalization Tax',
CPI3.EquVatSumF AS 'Total Equalization Tax (FC)',
CPI3.EquVatSumS AS 'Total Equalization Tax (SC)',
CPI3.LineVat AS 'Net Tax Amount',
CPI3.LineVatF AS 'Net Tax Amount (FC)',
CPI3.LineVatS AS 'Net Tax Amount (SC)',
CPI3.BaseMethod AS 'Base Method',
CPI3.Stock AS 'Stock',
CPI3.LstPchPrce AS 'Last Purchase Price',
CPI3.AnalysRpt AS 'Analysis Report',
CPI3.BaseAbsEnt AS 'Base Abs Entry',
CPI3.BaseType AS 'Base Document Type',
CPI3.BaseRef AS 'Base Document Reference',
CPI3.BaseLnNum AS 'Base Document Line No.',
CPI3.LineNum AS 'line num',
CPI3.Status AS 'Status',
CPI3.TrgType AS 'Target Type',
CPI3.TrgAbsEnt AS 'Target Abs. Entry',
CPI3.StDstr AS 'Stock Distributed Sum',
CPI3.StDstrSC AS 'Stock Distributed Sum (SC)',
CPI3.StDstrFC AS 'Stock Distributed Sum (FC)',
CPI3.FixCurr AS 'Fixation Currency',
CPI3.VatDscntPr AS 'Tax Discount %',
CPI3.OcrCode AS 'Distribution Rule',
CPI3.TaxDistMtd AS 'Tax Distribution Method',
CPI3.OcrCode2 AS 'Distribution Rule2',
CPI3.OcrCode3 AS 'Distribution Rule3',
CPI3.OcrCode4 AS 'Distribution Rule4',
CPI3.OcrCode5 AS 'Distribution Rule5',
CPI3.Project AS 'Project Code',
CPI3.VatGrpSrc AS 'VAT Group Source',
CPI3.DrawnTotal AS 'Drawn Total',
CPI3.DrawnFC AS 'Drawn Total (FC)',
CPI3.DrawnSC AS 'Drawn Total (SC)'
FROM CPI3 AS CPI3
Related information
v9.0 Base Doc Entry BaseDocEntry Property· Table: CPI3
Sets or returns the source document ID. Field name: DocEntry.
· Table: DRF3 RPC3 PCH3 CPI3 CPV3 PDN3 RPD3 POR3 PQT3 RIN3 INV3 CSI3 CSV3 DLN3 RDN3 RDR3 QUT3 Parent: Documents Additional Expenses DocumentsAdditionalExpenses Object· Table: DRF3 RPC3 PCH3 CPI3 CPV3 PDN3 RPD3 POR3 PQT3 RIN3 INV3 CSI3 CSV3 DLN3 RDN3 RDR3 QUT3 A/P Correction Invoice OCPI SQL Table
Freight Setup OEXD SQL Table
Currency Codes OCRN SQL Table
Object Settings - History ADP1 SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Sales Tax Codes OSTC SQL Table
Tax Definition OVTG SQL Table
DocumentsAdditionalExpenses
Property
BaseDocEntry
Enumeration
Method
Object
TaxJurisdictions PCH4
Property
AquisitionTax
9.0 DB
BaseDocEntry
9.0 DTW DB
BaseDocLine
9.0 DTW DB
BaseDocType
9.0 DTW DB
BaseDocumentReference
9.0 DB
DeductibleTaxSum
9.0 DTW DB
DeductibleTaxSumFC
9.0 DB
DeductibleTaxSumSys
9.0 DB
DistributionMethod
9.0 DTW DB
DistributionRule
9.0 DTW DB
DistributionRule2
9.0 DTW DB
DistributionRule3
9.0 DTW DB
DistributionRule4
9.0 DTW DB
DistributionRule5
9.0 DTW DB
EqualizationTaxFC
9.0 DB
EqualizationTaxPercent
9.0 DTW DB
EqualizationTaxSum
9.0 DTW DB
EqualizationTaxSys
9.0 DB
ExpenseCode
9.0 DTW DB
LastPurchasePrice
9.0 DTW DB
LineNum
9.0 DTW DB
LineTotal
9.0 DTW DB
LineTotalFC
9.0 DB
LineTotalSys
9.0 DB
PaidToDate
9.0 DB
PaidToDateFC
9.0 DB
PaidToDateSys
9.0 DB
Project
9.0 DTW DB
Remarks
9.0 DTW DB
Status
9.0 DB
Stock
9.0 DTW DB
TargetAbsEntry
9.0 DB
TargetType
9.0 DB
TaxCode
9.0 DTW DB
TaxLiable
9.0 DTW DB
TaxPaid
9.0 DB
TaxPaidFC
9.0 DB
TaxPaidSys
9.0 DB
TaxPercent
9.0 DTW DB
TaxSum
9.0 DTW DB
TaxSumFC
9.0 DB
TaxSumSys
9.0 DB
TaxTotalSum
9.0 DB
TaxTotalSumFC
9.0 DB
TaxTotalSumSys
9.0 DB
TaxType
9.0 DTW DB
VatGroup
9.0 DTW DB
WTLiable
9.0 DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
