|
|
API Landed Cost Cost Lines / Landed Cost Cost Line
IPF2 - Landed Costs - Costs Table
Landed Cost Cost Line LandedCost_CostLine Object· Table: IPF2
Parent: Landed Cost Cost Lines LandedCost_CostLines Collection
Loading Expenses OALC SQL Table
Landed Costs OIPF 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 |
|---|---|---|---|---|---|---|---|---|
| AlcCode | Cost Code | nVarChar | 2 | OALC Loading Expenses | ||||
| OhType | Load by | VarChar | F) Cash Value Before Customs C) Cash Value After Customs Q) Quantity W) Weight V) Volume A) Equal | 1 | ||||
| CostSum | Total Costs | Num | 20 | |||||
| CostSumFC | Total Costs (FC) | Num | 20 | |||||
| Factor | Factor | Num | 20 | |||||
| CostType | Cost Type | VarChar | F) Fixed Costs V) Variable Costs | 1 | F | |||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N | |||
| LaCAllcAcc | Landed Costs Alloc. Account | nVarChar | 15 | |||||
| CostSumSC | Total Costs (SC) | Num | 20 | |||||
| InCustCalc | Included in Customs Calc | VarChar | Y) Yes N) No | 1 | N | |||
| OpenCost | Open Costs | Num | 20 | |||||
| OpenCostFC | Open Costs (FC) | Num | 20 | |||||
| OpenCostSC | Open 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 CollectionLoading Expenses OALC SQL Table
Landed Costs OIPF SQL Table
LandedCost_CostLines
Object
LandedCost_CostLine
Enumeration
Method
Property
AllocationBy
DB
amount
DB
AmountFC
DB
CostType
DB
Factor
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
