|
|
DTW Landed Costs
API Landed Costs Service / Landed Cost
OIPF - Landed Costs Table
Landed Cost LandedCost Object· Table: OIPF
Parent: Landed Costs Service LandedCostsService Service· Table: OIPF
Landed Costs Service LandedCostsService Service· Table: OIPF
OIPF SQL Table
Business Partner OCRD SQL Table
Journal Entry OJDT SQL Table
Object Settings - History ADP1 SQL Table
Delivery Types OSHP SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DocNum KEY UNIQUE | Document Number | Int | 11 | NUM | Yes | |||
| DocDate | Posting Date | Date | 8 | |||||
| DocDueDate | Due Date | Date | 8 | |||||
| CardCode KEY | Vendor Code | nVarChar | 15 | OCRD Business Partner | SUPPLIER | No | ||
| SuppName | Vendor Name | nVarChar | 100 | |||||
| AgentCode KEY | Subst. Code | nVarChar | 15 | OCRD Business Partner | AGENT | No | ||
| AgentName | Subst. Name | nVarChar | 100 | |||||
| DocStatus | Document Status | VarChar | C) Closed O) Open | 1 | O | |||
| AgentNum | File Number | nVarChar | 16 | |||||
| Descr | Remarks | nVarChar | 127 | |||||
| Ref1 | Reference 1 | nVarChar | 11 | |||||
| Ref2 | Reference 2 | nVarChar | 11 | |||||
| DocCur KEY | Document Currency | nVarChar | 3 | CURRENCY | No | |||
| DocRate | Document Rate | Num | 20 | |||||
| ExpCustom | Projected Customs | Num | 20 | |||||
| ActCustom | Act. Import Duty | Num | 20 | |||||
| Vat1 | Tax 2 | Num | 20 | |||||
| Vat2 | Tax 2 | Num | 20 | |||||
| BeforeVat | Total Before Tax | Num | 20 | |||||
| DocTotal | Document Total | Num | 20 | |||||
| CostSum | Total Costs | Num | 20 | |||||
| DocTime | Generation Time | Int | 6 | |||||
| Canceled | Canceled | VarChar | Y) Yes N) No | 1 | N | |||
| ExCustomFC | Projected Customs (FC) | Num | 20 | |||||
| AcCustomFC | Act. Import Duty in FC | Num | 20 | |||||
| Vat1FC | Tax 1 (FC) | Num | 20 | |||||
| Vat2FC | Tax 2 (FC) | Num | 20 | |||||
| BeforVatFC | Total Before Tax (FC) | Num | 20 | |||||
| DocTotalFC | Document Total (FC) | Num | 20 | |||||
| CostSumFC | Total Costs (FC) | Num | 20 | |||||
| CloseDate | Closing Date | Date | 8 | |||||
| Cost_Match | Expenses Diff. for Reconciliation | Num | 20 | |||||
| C_Match_FC | Expenses Diff. for Recon. (FC) | Num | 20 | |||||
| BillOfLad | Bill of Lading No. | nVarChar | 20 | |||||
| TrnspCode | Delivery Category | Int | 6 | OSHP Delivery Types | ||||
| CostFactor | Expenses Factor | Num | 20 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| Transfered | Year Transfer | VarChar | Y) Yes N) No | 1 | N | |||
| Instance | Instance | Int | 6 | 0 | ||||
| TaxDate | Document Date | Date | 8 | |||||
| Series KEY | Series | Int | 6 | SERIES | No | |||
| JdtNum | Journal Number | Int | 11 | OJDT Journal Entry | ||||
| JdtMemo | Transaction Details | nVarChar | 50 | |||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 69 | |||
| ExCustomSC | Projected Customs (SC) | Num | 20 | |||||
| ActCustSC | Actual Customs (SC) | Num | 20 | |||||
| TtlCostSC | Total Expenditure (SC) | Num | 20 | |||||
| VersionNum | Version Number | nVarChar | 11 | |||||
| OpenForLaC | Open For Landed Costs | VarChar | Y) Yes N) No | 1 | Y | |||
| incCustom | Include Customs Expenses | VarChar | 1 | Y | ||||
| SeqCode | Sequence Code | Int | 6 | |||||
| Serial | Serial Number | Int | 11 | |||||
| SeriesStr | Series String | nVarChar | 3 | |||||
| SubStr | Subseries String | nVarChar | 3 | |||||
| BuildDesc | Build Descriptor | nVarChar | 50 | |||||
| SupplCode | Supplementary Code | nVarChar | 127 | |||||
| AtcEntry | Attachment Entry | Int | 11 | |||||
| CustDate | Customs Date | Date | 8 |
Table relationship map
SELECT statement
SELECT
OIPF.DocEntry AS 'Internal Number',
OIPF.DocNum AS 'Document Number',
OIPF.DocDate AS 'Posting Date',
OIPF.DocDueDate AS 'Due Date',
OIPF.CardCode AS 'Vendor Code',
OIPF.SuppName AS 'Vendor Name',
OIPF.AgentCode AS 'Subst. Code',
OIPF.AgentName AS 'Subst. Name',
OIPF.DocStatus AS 'Document Status',
OIPF.AgentNum AS 'File Number',
OIPF.Descr AS 'Remarks',
OIPF.Ref1 AS 'Reference 1',
OIPF.Ref2 AS 'Reference 2',
OIPF.DocCur AS 'Document Currency',
OIPF.DocRate AS 'Document Rate',
OIPF.ExpCustom AS 'Projected Customs',
OIPF.ActCustom AS 'Act. Import Duty',
OIPF.Vat1 AS 'Tax 2',
OIPF.Vat2 AS 'Tax 2',
OIPF.BeforeVat AS 'Total Before Tax',
OIPF.DocTotal AS 'Document Total',
OIPF.CostSum AS 'Total Costs',
OIPF.DocTime AS 'Generation Time',
OIPF.Canceled AS 'Canceled',
OIPF.ExCustomFC AS 'Projected Customs (FC)',
OIPF.AcCustomFC AS 'Act. Import Duty in FC',
OIPF.Vat1FC AS 'Tax 1 (FC)',
OIPF.Vat2FC AS 'Tax 2 (FC)',
OIPF.BeforVatFC AS 'Total Before Tax (FC)',
OIPF.DocTotalFC AS 'Document Total (FC)',
OIPF.CostSumFC AS 'Total Costs (FC)',
OIPF.CloseDate AS 'Closing Date',
OIPF.Cost_Match AS 'Expenses Diff. for Reconciliation',
OIPF.C_Match_FC AS 'Expenses Diff. for Recon. (FC)',
OIPF.BillOfLad AS 'Bill of Lading No.',
OIPF.TrnspCode AS 'Delivery Category',
OIPF.CostFactor AS 'Expenses Factor',
OIPF.UpdateDate AS 'Date of Update',
OIPF.CreateDate AS 'Creation Date',
OIPF.Transfered AS 'Year Transfer',
OIPF.Instance AS 'Instance',
OIPF.TaxDate AS 'Document Date',
OIPF.Series AS 'Series',
OIPF.JdtNum AS 'Journal Number',
OIPF.JdtMemo AS 'Transaction Details',
OIPF.DataSource AS 'Data Source',
OIPF.UserSign AS 'User Signature',
OIPF.ObjType AS 'Object Type',
OIPF.ExCustomSC AS 'Projected Customs (SC)',
OIPF.ActCustSC AS 'Actual Customs (SC)',
OIPF.TtlCostSC AS 'Total Expenditure (SC)',
OIPF.VersionNum AS 'Version Number',
OIPF.OpenForLaC AS 'Open For Landed Costs',
OIPF.incCustom AS 'Include Customs Expenses',
OIPF.SeqCode AS 'Sequence Code',
OIPF.Serial AS 'Serial Number',
OIPF.SeriesStr AS 'Series String',
OIPF.SubStr AS 'Subseries String',
OIPF.BuildDesc AS 'Build Descriptor',
OIPF.SupplCode AS 'Supplementary Code',
OIPF.AtcEntry AS 'Attachment Entry',
OIPF.CustDate AS 'Customs Date'
FROM OIPF AS OIPF
Related information
Landed Cost LandedCost Object· Table: OIPF
Represents a landed costs document, which is used for recording and allocating the costs incurred when importing goods.
Source table: OIPF.
Parent: Landed Costs Service LandedCostsService Service· Table: OIPF Landed Costs Service LandedCostsService Service· Table: OIPF
The LandedCostsService service enables you to add, look up, update, cancel, and close landed costs documents.
Source table: OIPF.
OIPF SQL Table
Business Partner OCRD SQL Table
Journal Entry OJDT SQL Table
Object Settings - History ADP1 SQL Table
Delivery Types OSHP SQL Table
Users OUSR SQL Table
LandedCostsService
Object
LandedCost
Collection
Enumeration
Method
Property
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates