Name
|
Type
|
Description
|
ItemCode
|
Edm.String(50)
|
Entity Relation: ItemWareHouse -> ItemCode
Entity Relation: ItemVersion -> ItemCode
Entity Relation: ItemDocuments -> ItemCode
Integration hub: Importable
Mandatory field
Primary key
Database: "OITM"."ItemCode"
|
|
ItemName
|
Edm.String(100)
|
Integration hub: Importable
Database: "OITM"."ItemName"
|
|
IVersionId
|
Edm.String(20)
|
Database: case when rtrim(coalesce("OITM"."U_beas_ver",''))='' then '' else "OITM"."U_beas_ver" end
|
|
ForeignName
|
Edm.String(100)
|
Integration hub: Importable
Database: "OITM"."FrgnName"
|
|
MainSupplier
|
Edm.String(15)
|
Linked table: OCRD
Linked column: CardCode
Integration hub: Importable
Database: "OITM"."CardCode"
|
|
Barcode
|
Edm.String(254)
|
Integration hub: Importable
Database: "OITM"."CodeBars"
|
|
CardCode
|
Edm.String(20)
|
Linked table: OCRD
Linked column: CardCode
Integration hub: Importable
Database: "OITM"."CardCode"
|
|
ItemType
|
Edm.String(1)
|
Integration hub: Importable
Database: "OITM"."ItemType"
|
|
InventoryItem
|
Edm.Boolean
|
Database: case when "OITM"."InvntItem" = 'Y' then 1 else 0 end
|
|
ManageBatchNumbers
|
Edm.Boolean
|
Database: case when "OITM"."ManBtchNum" = 'Y' then 1 else 0 end
|
|
ManageSerialNumbers
|
Edm.Boolean
|
Database: case when "OITM"."ManSerNum" = 'Y' then 1 else 0 end
|
|
BatchnumberGeneration
|
Edm.String(1)
|
Define automatic batch number / serial number generation
can generate the batch automatically for a receipt transaction.
Here you can set up whether the batch is entered manually or generated automatically when posing in material.
Batch according to material
===========================
If an assembly is posted in, as batch number is determined that one of the first material in the BOM of the assembly which was last posted in.
Example:
Assembly: "Paste y in container x"
|- Bill of Materials: Paste y
|---|- 1. issue batch aaa
|---|- 2. issue batch bbb
If "Paste y in container x" is now produced and posted in, the batch number of "Paste y" of the last posting, i.e. batch "bbb" is assigned.
Automatic batch determination
=============================
Batches are generated automatically, at stock correction the next number can be requested.
see Batch generation
Special case at SAP-posting processes:
If the entry field for quantity is left with Ctrl-Tab, the batch assignment screen opens. There is a button "next batch"
Clicking there, the next batch number according to SAP - batch determination program is determined and entered to the current field.
Batches are always determined automatically.
Manual batch input
==================
If activated, manual batch input is always performed for this item.
Default Value: M
Constraints:
batchnum is same as last cunsumed material=J
automatic batch number generation=N
manual batch number=M
Integration hub: Importable
Database: "OITM"."U_batchroh"
|
|
Breakdown
|
Edm.String(1)
|
|
ProcurementMethod
|
Edm.String(1)
|
|
PlanningSystem
|
Edm.String(1)
|
Database: case when "OITM"."PlaningSys"= 'Y' then 1 else 0 end
|
|
IssueMethod
|
Edm.String(1)
|
Return the Issue Method for this item
(Defined in Item Master Data)
B = Backflush
M = Manual
Batch- and Serial number related items always "M"
But you can overwrite this in configuration wizzard - Production - Material Posting - Backflush -
also post batch numbers
also post serial numbers
if this is activated, the system return "B" for Batch or/and Serial numbers too
Database: case when "OITM"."ManBtchNum"='Y' and 'J' = 'J' then 'B' when "OITM"."ManSerNum"='Y' and 'J' = 'J' then 'B' else "OITM"."IssueMthd" end
|
|
ItemVersionAdministration
|
Edm.Int32
|
Default Value: 0
Constraints:
No=0
extented view=1
separate bom=2
Integration hub: Importable
Database: coalesce("OITM"."U_beas_VerControl",0)
|
|
ItemVersionCount
|
Edm.Int32
|
Database: (select count(*) from "BEAS_ITEM_VERSION" where "BEAS_ITEM_VERSION"."ItemCode"="OITM"."ItemCode")
|
|
CalculationPrice
|
Edm.Decimal
|
Integration hub: Importable
Database: "OITM"."U_kalk_pr"
|
|
CalcLotSizeInventoryUOM
|
Edm.Decimal
|
Database: coalesce("OITM"."U_losgr_ka",0)
|
|
CalcLotSizeProductionUoM
|
Edm.Decimal
|
Database: coalesce("OITM"."U_beas_CalcLotsizeWoUnit","OITM"."U_losgr_ka")
|
|
ProductionLotSize
|
Edm.Decimal
|
Default Value: 0
Integration hub: Importable
Database: coalesce("OITM"."U_losgr",0)
|
|
ProductionLotSizeUnit
|
Edm.String(100)
|
Database: case when coalesce("OITM"."U_beas_prlotsizeU",0)=0 then "OITM"."InvntryUom" else "OITM"."U_me_verbr" end
|
|
MinimumOrderQuantity
|
Edm.Decimal
|
Default Value: 0
Integration hub: Importable
Database: coalesce("OITM"."MinOrdrQty",0)
|
|
OrderMultiple
|
Edm.Decimal
|
Default Value: 0
Integration hub: Importable
Database: coalesce("OITM"."OrdrMulti",0)
|
|
ScrapPercent
|
Edm.Int32
|
Default Value: 0
Integration hub: Importable
Database: "OITM"."U_aussch"
|
|
ScrapTable
|
Edm.String(20)
|
Integration hub: Importable
Database: "OITM"."U_verschn"
|
|
InventoryUOM
|
Edm.String(20)
|
Integration hub: Importable
Database: "OITM"."InvntryUom"
|
|
ProductionUnit
|
Edm.String(20)
|
Linked table: BEAS_ME
Linked column: ME_ID
Integration hub: Importable
Database: "OITM"."U_me_verbr"
|
|
PurchaseUnit
|
Edm.String(20)
|
Integration hub: Importable
Database: "OITM"."BuyUnitMsr"
|
|
UnitGroupId
|
Edm.Int32
|
Entity Relation: UnitGroup -> UnitGroupId
Unit of measure groups (UoM groups) are groups of one or more units of measure that you either
allow as units of measure for a product or exclude from the set of possible UoMs for the product.
You can assign UoM groups for the products of both the deliverying and receiving locations.
Linked BSL objects:
UnitGroup, UnitGroupLines
Linked table: OUGP
Linked column: UgpEntry
Integration hub: Importable
Database: "OITM"."UgpEntry"
|
|
OnHand
|
Edm.Decimal
|
Database: "OITM"."OnHand"
|
|
DefaultWareHouse
|
Edm.String(20)
|
Linked table: OWHS
Linked column: WhsCode
Integration hub: Importable
Database: coalesce("OITM"."DfltWH",'')
|
|
WareHouseRuleId
|
Edm.String(50)
|
Integration hub: Importable
Database: "OITM"."U_beas_BinGroup"
|
|
CostAccountingMethod
|
Edm.String(1)
|
Define the CostAccounting Method (Evaluation Method)
Default Value: A
Constraints:
Moving Average=A
Standard=S
FIFO=F
Serie | Charge=B
=
Integration hub: Importable
Database: "OITM"."EvalSystem"
|
|
ManageStockByWarehouse
|
Edm.String(1)
|
Default Value: N
Constraints:
Yes=Y
No=N
Integration hub: Importable
Database: "OITM"."ByWh"
|
|
DrawingNumber
|
Edm.String(50)
|
Integration hub: Importable
Database: "OITM"."U_znr"
|
|
MatchCode
|
Edm.String(20)
|
Integration hub: Importable
Database: "OITM"."U_match"
|
|
DIN
|
Edm.String(50)
|
Integration hub: Importable
Database: "OITM"."U_din"
|
|
ItemGroupCode
|
Edm.Int32
|
Entity Relation: ItemGroup -> ItemGroupCode
Integration hub: Importable
Database: "OITM"."ItmsGrpCod"
|
|
MaterialGroupId
|
Edm.String(20)
|
Entity Relation: MaterialGroupId ->
Integration hub: Importable
Database: "OITM"."U_gruppe"
|
|
ShelfLife
|
Edm.Int32
|
Integration hub: Importable
Database: "OITM"."U_haltbark"
|
|
RawMaterialId
|
Edm.String(20)
|
Entity Relation: RawMaterial -> RawMaterialId
Linked table: BEAS_WST
Linked column: WST_ID
Integration hub: Importable
Database: "OITM"."U_wst_id"
|
|
SpecificWeight
|
Edm.Decimal
|
Related to the settings of "artikel_spezgew":
If "J" (by Item) then OITM.U_BEAS_DICHTE
If "N" then BEAS_WST.DICHTE
If NULL value, then 1
Integration hub: Importable
Database: coalesce("OITM"."U_spezgew",1)
|
|
PurchaseUnitHeight1
|
Edm.Decimal
|
Default Value: 0
Integration hub: Importable
Database: coalesce("OITM"."BHeight1",0)
|
|
PurchaseHeightUoM1
|
Edm.String(20)
|
Database: (select "OLGT"."UnitDisply" from "OLGT" where "UnitCode"="OITM"."BWdth1Unit")
|
|
PurchaseUnitWidth1
|
Edm.Decimal
|
Default Value: 0
Integration hub: Importable
Database: coalesce("OITM"."BWidth1",0)
|
|
PurchaseWidthUoM1
|
Edm.String(1)
|
Database: (select "OLGT"."UnitDisply" from "OLGT" where "UnitCode"="OITM"."BWdth1Unit")
|
|
PurchaseUnitLength1
|
Edm.Decimal
|
Default Value: 0
Integration hub: Importable
Database: coalesce("OITM"."BLength1",0)
|
|
PurchaseLengthUoM1
|
Edm.String(1)
|
Database: (select "OLGT"."UnitDisply" from "OLGT" where "UnitCode"="OITM"."BLen1Unit")
|
|
Picture1
|
Edm.String(50)
|
Integration hub: Importable
Database: "OITM"."PicturName"
|
|
Picture2
|
Edm.String(50)
|
Integration hub: Importable
Database: "OITM"."U_picture2"
|
|
Picture3
|
Edm.String(50)
|
Integration hub: Importable
Database: "OITM"."U_picture3"
|
|