biuan SAP® BUSINESS ONE SDK
DTW Landed Costs
API Landed Costs Service / Landed Cost
OIPF - Landed Costs Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocNum KEY UNIQUEDocument NumberInt
11
NUMYes
DocDatePosting DateDate
8
DocDueDateDue DateDate
8
CardCode KEYVendor CodenVarChar
15OCRD
Business Partner
SUPPLIERNo
SuppNameVendor NamenVarChar
100
AgentCode KEYSubst. CodenVarChar
15OCRD
Business Partner
AGENTNo
AgentNameSubst. NamenVarChar
100
DocStatusDocument StatusVarChar
C) Closed
O) Open
1
O
AgentNumFile NumbernVarChar
16
DescrRemarksnVarChar
127
Ref1Reference 1nVarChar
11
Ref2Reference 2nVarChar
11
DocCur KEYDocument CurrencynVarChar
3
CURRENCYNo
DocRateDocument RateNum
20
ExpCustomProjected CustomsNum
20
ActCustomAct. Import DutyNum
20
Vat1Tax 2Num
20
Vat2Tax 2Num
20
BeforeVatTotal Before TaxNum
20
DocTotalDocument TotalNum
20
CostSumTotal CostsNum
20
DocTimeGeneration TimeInt
6
CanceledCanceledVarChar
Y) Yes
N) No
1
N
ExCustomFCProjected Customs (FC)Num
20
AcCustomFCAct. Import Duty in FCNum
20
Vat1FCTax 1 (FC)Num
20
Vat2FCTax 2 (FC)Num
20
BeforVatFCTotal Before Tax (FC)Num
20
DocTotalFCDocument Total (FC)Num
20
CostSumFCTotal Costs (FC)Num
20
CloseDateClosing DateDate
8
Cost_MatchExpenses Diff. for ReconciliationNum
20
C_Match_FCExpenses Diff. for Recon. (FC)Num
20
BillOfLadBill of Lading No.nVarChar
20
TrnspCodeDelivery CategoryInt
6OSHP
Delivery Types
CostFactorExpenses FactorNum
20
UpdateDateDate of UpdateDate
8
CreateDateCreation DateDate
8
TransferedYear TransferVarChar
Y) Yes
N) No
1
N
InstanceInstanceInt
6
0
TaxDateDocument DateDate
8
Series KEYSeriesInt
6
SERIESNo
JdtNumJournal NumberInt
11OJDT
Journal Entry
JdtMemoTransaction DetailsnVarChar
50
DataSourceData SourceVarChar
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
UserSignUser SignatureInt
6OUSR
Users
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
69
ExCustomSCProjected Customs (SC)Num
20
ActCustSCActual Customs (SC)Num
20
TtlCostSCTotal Expenditure (SC)Num
20
VersionNumVersion NumbernVarChar
11
OpenForLaCOpen For Landed CostsVarChar
Y) Yes
N) No
1
Y
incCustomInclude Customs ExpensesVarChar
1
Y
SeqCodeSequence CodeInt
6
SerialSerial NumberInt
11
SeriesStrSeries StringnVarChar
3
SubStrSubseries StringnVarChar
3
BuildDescBuild DescriptornVarChar
50
SupplCodeSupplementary CodenVarChar
127
AtcEntryAttachment EntryInt
11
CustDateCustoms DateDate
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates