biuan SAP® BUSINESS ONE SDK
API Landed Cost Cost Lines / Landed Cost Cost Line
IPF2 - Landed Costs - Costs Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUELanded Costs Internal IDInt
11OIPF
Landed Costs
PRIMARYYes
AlcCodeCost CodenVarChar
2OALC
Loading Expenses
OhTypeLoad byVarChar
F) Cash Value Before Customs
C) Cash Value After Customs
Q) Quantity
W) Weight
V) Volume
A) Equal
1
CostSumTotal CostsNum
20
CostSumFCTotal Costs (FC)Num
20
FactorFactorNum
20
CostTypeCost TypeVarChar
F) Fixed Costs
V) Variable Costs
1
F
LockedLockedVarChar
Y) Yes
N) No
1
N
LaCAllcAccLanded Costs Alloc. AccountnVarChar
15
CostSumSCTotal Costs (SC)Num
20
InCustCalcIncluded in Customs CalcVarChar
Y) Yes
N) No
1
N
OpenCostOpen CostsNum
20
OpenCostFCOpen Costs (FC)Num
20
OpenCostSCOpen Costs (SC)Num
20

Table relationship map

SELECT statement

SELECT IPF2.DocEntry AS 'Landed Costs Internal ID', IPF2.AlcCode AS 'Cost Code', IPF2.OhType AS 'Load by', IPF2.CostSum AS 'Total Costs', IPF2.CostSumFC AS 'Total Costs (FC)', IPF2.Factor AS 'Factor', IPF2.CostType AS 'Cost Type', IPF2.Locked AS 'Locked', IPF2.LaCAllcAcc AS 'Landed Costs Alloc. Account', IPF2.CostSumSC AS 'Total Costs (SC)', IPF2.InCustCalc AS 'Included in Customs Calc', IPF2.OpenCost AS 'Open Costs', IPF2.OpenCostFC AS 'Open Costs (FC)', IPF2.OpenCostSC AS 'Open Costs (SC)' FROM IPF2 AS IPF2

Related information


Landed Cost Cost Line LandedCost_CostLine Object· Table: IPF2
The LandedCost_CostLine object enables you to allocate landed costs to the various items according to specific criteria, for example volume, weight, or quantity. Source table: IPF2.
   Parent: Landed Cost Cost Lines LandedCost_CostLines Collection
Loading Expenses OALC SQL Table

Landed Costs OIPF 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