|
|
API IPF3
IPF3 - Landed Costs - Customs Summary Table
Landed Costs OIPF SQL Table
Tax Definition OVTG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Landed Costs Internal ID | Int | 11 | OIPF Landed Costs | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| Dscription | Summary Description | nVarChar | 100 | |||||
| LaCAllcAcc | Landed Costs Alloc. Account | nVarChar | 15 | |||||
| CustSum | Customs Summary | Num | 20 | |||||
| CustSumFC | Customs Summary FC | Num | 20 | |||||
| CustSumSC | Customs Summary SC | Num | 20 | |||||
| OpenSum | Open Customs Summary | Num | 20 | |||||
| OpenSumFC | Open Customs Summary (FC) | Num | 20 | |||||
| OpenSumSC | Open Customs Summary (SC) | Num | 20 | |||||
| AccType | Type of Account of Summarized | Int | 11 | |||||
| VatGroup | VAT Code | nVarChar | 8 | OVTG Tax Definition | ||||
| CstmVatStk | Is Customs VAT in Stock | VarChar | Y) Yes N) No | 1 | Y | |||
| CCDEntry | CCD Abs. Entry | Int | 11 |
Table relationship map
SELECT statement
SELECT
IPF3.DocEntry AS 'Landed Costs Internal ID',
IPF3.LineNum AS 'Row Number',
IPF3.Dscription AS 'Summary Description',
IPF3.LaCAllcAcc AS 'Landed Costs Alloc. Account',
IPF3.CustSum AS 'Customs Summary',
IPF3.CustSumFC AS 'Customs Summary FC',
IPF3.CustSumSC AS 'Customs Summary SC',
IPF3.OpenSum AS 'Open Customs Summary',
IPF3.OpenSumFC AS 'Open Customs Summary (FC)',
IPF3.OpenSumSC AS 'Open Customs Summary (SC)',
IPF3.AccType AS 'Type of Account of Summarized',
IPF3.VatGroup AS 'VAT Code',
IPF3.CstmVatStk AS 'Is Customs VAT in Stock',
IPF3.CCDEntry AS 'CCD Abs. Entry'
FROM IPF3 AS IPF3
Related information
Landed Costs OIPF SQL Table
Tax Definition OVTG SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
