biuan SAP® BUSINESS ONE SDK
API Landed Cost Item Lines / Landed Cost Item Line
IPF1 - Landed Costs - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUELanded Costs Internal IDInt
11OIPF
Landed Costs
PRIMARYYes
LineNumRow NumberInt
11
BaseType KEYBase Document TypeInt
-1)
0
20) Goods Receipt PO
69) Landed Costs
18) A/P Invoice
11
-1BASE_LINENo
BaseEntryBase Document Internal IDInt
11
ItemCodeItem No.nVarChar
20OITM
Items
DscriptionItem DescriptionnVarChar
100
QuantityQuantityNum
20
PriceFOBBase Doc. PriceNum
20
Currency KEYPrice CurrencynVarChar
3
CURRENCYNo
RateCurrency PriceNum
20
CustomProjected CustomsNum
20
CustomFCProjected Customs (FC)Num
20
CostExpenditureNum
20
CostFCFreight (FC)Num
20
PriceAtWHWhse PriceNum
20
PricAtWHFCWhse Price (FC)Num
20
LineTotalRow TotalNum
20
TotalFrgnRow Total (FC)Num
20
VolumeVolumeNum
20
UnitCodeVolume UoMInt
6OLGT
Length Units
Weight1Weight 1Num
20
UnitCode1Unit of Weight 1Int
6OWGT
Weight Units
Weight2Weight 2Num
20
UnitCode2Unit of Weight 2Int
6OWGT
Weight Units
CardCodeVendor CodenVarChar
15OCRD
Business Partner
ReferenceReferencenVarChar
16
OrigLineBase Line NumberInt
11
FactNoCustFactor Without CustomsNum
20
FacWthCustFactor with CustomsNum
20
PriceListPrice List No.Int
6OPLN
Price Lists
CostOHCost SurchargeVarChar
Y) Yes
N) No
1
Y
StockEvalUse for Inventory ValuationVarChar
Y) Yes
N) No
1
Y
UseBaseUnInventory UoMVarChar
Y) Yes
N) No
1
BlockNumBlock No.nVarChar
100
ImportLogImport LognVarChar
20
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
OrigRowOriginal RowInt
11
LockedLockedVarChar
Y) Yes
N) No
1
N
OrigWhsOriginal WarehousenVarChar
8OWHS
Warehouses
ReleaseNumRelease NumberInt
11
VarCostsVariant CostsNum
20
ConstCostsFixed CostsNum
20
VarCostsFRVariant Costs (FC)Num
20
CnstCostFRFixed Costs (FC)Num
20
UserCustomUser Expected CustomNum
20
UsrCusomFCUser Expected Foreign CustomNum
20
FobValueBase Doc. Value Row Total (LC)Num
20
FobValueFCBase Doc. Value Row Total (FC)Num
20
TtlExpndLCAllocated Unit Costs Row TotalNum
20
TtlExpndFCAllocated Unit Costs Row TotalNum
20
TtlCustLCAllocated Unit Costs Row TotalNum
20
TtlCustFCAllocated Unit Costs Row TotalNum
20
TtlCostLCRow Ttl Cust + Alloc Costs LCNum
20
TtlCostFCRow Ttl Cust + Alloc Costs FCNum
20
TtlVolumeVolume Row TotalNum
20
TtlWeightWeight Row TotalNum
20
BaseRowNumuse IPF1_BASE_LINE_NUM insteadInt
11
TtlCustSCTtl Row Projected Customs (SC)Num
20
TtlExpndSCAllocated Costs Row Total (SC)Num
20
OriBAbsEntOriginal Base Doc. Internal IDInt
11
-1
OriBLinNumOriginal Base Doc. Row No.Int
11
-1
TargetDocTarget Document Internal No.Int
11
FobValCurrBase Doc. Value CurrencynVarChar
3
FobnLaCFOB and Included Costs (LC)Num
20
FobnLaCFCFOB and Included Costs (FC)Num
20
NumPerMsrUoM ValueNum
20
ProjectProject CodenVarChar
20OPRJ
Project Codes
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
OcrCode2Distribution Rule 2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule 3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule 4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule 5nVarChar
8OOCR
Distribution Rule
OriBDocTypOriginal Base Document TypenVarChar
-1)
18) A/P Invoice
20) Goods Receipt PO
11
-1
CustRateCustom Group RateNum
20
LFixCostLocked Fixed CostNum
20
LFixCostFCLocked Fixed Cost (FC)Num
20
LVarCostLocked Variable CostNum
20
LVarCostFCLocked Variable Cost (FC)Num
20
CstmsRateCustoms RateNum
20
VatGroupVAT CodenVarChar
8
VatPrcntVAT Rate per RowNum
20
VatSumTotal of VATNum
20
SnbTypeBatch or Serial TypenVarChar
-1)
10000045) Serial
10000044) Batch
20
-1
SnbAbsEntSnB Abs. EntryInt
11
-1
SysNumberSystem NumberInt
11
DistNumberDistinct NumbernVarChar
36
ExciseSumSum of ExciseNum
20
ExcisSumFCSum of Excise - FCNum
20
ExcInStkIs Excise in StockVarChar
Y) Yes
N) No
1
N
CustomSumSum of Customs CostNum
20
CustSumFCSum of Customs Cost in FCNum
20
CstmInStkIs Customs in StockVarChar
Y) Yes
N) No
1
Y
CstmVatSumSum of Customs Cost VATNum
20
CstmVatFCSum of Customs Cost VAT in FCNum
20
CstmVatStkIs Customs VAT in StockVarChar
Y) Yes
N) No
1
Y
CCDEntryCCD Abs. EntryInt
11
CCDNumberNumber of CCDnVarChar
20
ExcisSumSCSum of Excise - SCNum
20
CustSumSCSum of Customs Cost in SCNum
20
CstmVatSCSum of Customs Cost VAT in SCNum
20
InvQtyInventory QuantityNum
20
CCDLineNumCCD Row NumberInt
11

Table relationship map

SELECT statement

SELECT IPF1.DocEntry AS 'Landed Costs Internal ID', IPF1.LineNum AS 'Row Number', IPF1.BaseType AS 'Base Document Type', IPF1.BaseEntry AS 'Base Document Internal ID', IPF1.ItemCode AS 'Item No.', IPF1.Dscription AS 'Item Description', IPF1.Quantity AS 'Quantity', IPF1.PriceFOB AS 'Base Doc. Price', IPF1.Currency AS 'Price Currency', IPF1.Rate AS 'Currency Price', IPF1.Custom AS 'Projected Customs', IPF1.CustomFC AS 'Projected Customs (FC)', IPF1.Cost AS 'Expenditure', IPF1.CostFC AS 'Freight (FC)', IPF1.PriceAtWH AS 'Whse Price', IPF1.PricAtWHFC AS 'Whse Price (FC)', IPF1.LineTotal AS 'Row Total', IPF1.TotalFrgn AS 'Row Total (FC)', IPF1.Volume AS 'Volume', IPF1.UnitCode AS 'Volume UoM', IPF1.Weight1 AS 'Weight 1', IPF1.UnitCode1 AS 'Unit of Weight 1', IPF1.Weight2 AS 'Weight 2', IPF1.UnitCode2 AS 'Unit of Weight 2', IPF1.CardCode AS 'Vendor Code', IPF1.Reference AS 'Reference', IPF1.OrigLine AS 'Base Line Number', IPF1.FactNoCust AS 'Factor Without Customs', IPF1.FacWthCust AS 'Factor with Customs', IPF1.PriceList AS 'Price List No.', IPF1.CostOH AS 'Cost Surcharge', IPF1.StockEval AS 'Use for Inventory Valuation', IPF1.UseBaseUn AS 'Inventory UoM', IPF1.BlockNum AS 'Block No.', IPF1.ImportLog AS 'Import Log', IPF1.WhsCode AS 'Warehouse Code', IPF1.OrigRow AS 'Original Row', IPF1.Locked AS 'Locked', IPF1.OrigWhs AS 'Original Warehouse', IPF1.ReleaseNum AS 'Release Number', IPF1.VarCosts AS 'Variant Costs', IPF1.ConstCosts AS 'Fixed Costs', IPF1.VarCostsFR AS 'Variant Costs (FC)', IPF1.CnstCostFR AS 'Fixed Costs (FC)', IPF1.UserCustom AS 'User Expected Custom', IPF1.UsrCusomFC AS 'User Expected Foreign Custom', IPF1.FobValue AS 'Base Doc. Value Row Total (LC)', IPF1.FobValueFC AS 'Base Doc. Value Row Total (FC)', IPF1.TtlExpndLC AS 'Allocated Unit Costs Row Total', IPF1.TtlExpndFC AS 'Allocated Unit Costs Row Total', IPF1.TtlCustLC AS 'Allocated Unit Costs Row Total', IPF1.TtlCustFC AS 'Allocated Unit Costs Row Total', IPF1.TtlCostLC AS 'Row Ttl Cust + Alloc Costs LC', IPF1.TtlCostFC AS 'Row Ttl Cust + Alloc Costs FC', IPF1.TtlVolume AS 'Volume Row Total', IPF1.TtlWeight AS 'Weight Row Total', IPF1.BaseRowNum AS 'use IPF1_BASE_LINE_NUM instead', IPF1.TtlCustSC AS 'Ttl Row Projected Customs (SC)', IPF1.TtlExpndSC AS 'Allocated Costs Row Total (SC)', IPF1.OriBAbsEnt AS 'Original Base Doc. Internal ID', IPF1.OriBLinNum AS 'Original Base Doc. Row No.', IPF1.TargetDoc AS 'Target Document Internal No.', IPF1.FobValCurr AS 'Base Doc. Value Currency', IPF1.FobnLaC AS 'FOB and Included Costs (LC)', IPF1.FobnLaCFC AS 'FOB and Included Costs (FC)', IPF1.NumPerMsr AS 'UoM Value', IPF1.Project AS 'Project Code', IPF1.OcrCode AS 'Distribution Rule', IPF1.OcrCode2 AS 'Distribution Rule 2', IPF1.OcrCode3 AS 'Distribution Rule 3', IPF1.OcrCode4 AS 'Distribution Rule 4', IPF1.OcrCode5 AS 'Distribution Rule 5', IPF1.OriBDocTyp AS 'Original Base Document Type', IPF1.CustRate AS 'Custom Group Rate', IPF1.LFixCost AS 'Locked Fixed Cost', IPF1.LFixCostFC AS 'Locked Fixed Cost (FC)', IPF1.LVarCost AS 'Locked Variable Cost', IPF1.LVarCostFC AS 'Locked Variable Cost (FC)', IPF1.CstmsRate AS 'Customs Rate', IPF1.VatGroup AS 'VAT Code', IPF1.VatPrcnt AS 'VAT Rate per Row', IPF1.VatSum AS 'Total of VAT', IPF1.SnbType AS 'Batch or Serial Type', IPF1.SnbAbsEnt AS 'SnB Abs. Entry', IPF1.SysNumber AS 'System Number', IPF1.DistNumber AS 'Distinct Number', IPF1.ExciseSum AS 'Sum of Excise', IPF1.ExcisSumFC AS 'Sum of Excise - FC', IPF1.ExcInStk AS 'Is Excise in Stock', IPF1.CustomSum AS 'Sum of Customs Cost', IPF1.CustSumFC AS 'Sum of Customs Cost in FC', IPF1.CstmInStk AS 'Is Customs in Stock', IPF1.CstmVatSum AS 'Sum of Customs Cost VAT', IPF1.CstmVatFC AS 'Sum of Customs Cost VAT in FC', IPF1.CstmVatStk AS 'Is Customs VAT in Stock', IPF1.CCDEntry AS 'CCD Abs. Entry', IPF1.CCDNumber AS 'Number of CCD', IPF1.ExcisSumSC AS 'Sum of Excise - SC', IPF1.CustSumSC AS 'Sum of Customs Cost in SC', IPF1.CstmVatSC AS 'Sum of Customs Cost VAT in SC', IPF1.InvQty AS 'Inventory Quantity', IPF1.CCDLineNum AS 'CCD Row Number' FROM IPF1 AS IPF1

Related information


Landed Cost Item Line LandedCost_ItemLine Object· Table: IPF1
The LandedCost_ItemLine object enables you to display the data regarding the imported goods as copied from goods receipt PO documents. Source table: IPF1.
   Parent: Landed Cost Item Lines LandedCost_ItemLines Collection
Business Partner OCRD SQL Table

Landed Costs OIPF SQL Table

Items OITM SQL Table

Distribution Rule OOCR SQL Table

Warehouses OWHS SQL Table

Price Lists OPLN SQL Table

Project Codes OPRJ SQL Table

Length Units OLGT SQL Table

Weight Units OWGT SQL Table



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