For detailed information on how to import see Data Integration Hub and Source-Target-Link.
DIH Item - BoM Positions
DIH Item - BoM Header
DIH Item - BoM Alternative items
DIH Routing Header
DIH Routing positions
DIH Routing Tool - alternative-parallel resource
DIH Documents - Item OP catalog
DIH Item parameter
DIH Documents Item Version
DIH Item version Status
Import and match items.
When a new item is imported, the "default item" from the Configuration Wizard is used as a reference. As an alternative, it can be set in the "e_sourceitem" variable (to define in conversion script from field "Itemcode") and an alternative default item can be used.
item import procedure:
1.Define the default item. Fill all fields (unit of measure, planning method, procurement method etc.).
2.Set the default item in the Configuration Wizard.
3.Define and perform import
Note:
Material group, unit of measure and item group can be created automatically, if Extended / Create groups and units was enabled in the import . If the data is incomplete, the data set is not created.
The following fields have extended settings:
All unit of measure fields
|
In case a unit of measure that does not yet exist in the UoM table, is imported, it is automatically created.
|
Material group (u_BEAS_GRUPPE)
|
Material group is automatically created, if it does not exist.
|
Item group
|
When, instead of the item group ID, the item group description is indicated, the internal item group ID is determined and used automatically in the description.
When the item group is not found, it is automatically created.
|
Procurement method
|
If enabled, the scheduling ID is set to storage-related assembly, otherwise to it is set to Purchase item.
|
I-Version
|
If a version number is entered, an item version is created immediately. This is done independently of the Create groups and units settings.
|
Series
|
Only for item generation: Define series defined in SAP Document Numbering - Setup. You must define the internal Id (NNM1.Series)
If you have only the SersiesName in the import file, you can convert it with follow syntax in source-target defintion:
// search for series name and return the series number
select "Series" into value from "NNM1" where "SeriesName"='<import.series>' and "ObjectCode"=4
|
Field
|
Name
|
M
|
Type
|
Description
|
ItemCode
|
Itemcode
|
X
|
nvarchar(50)
|
|
ItemName
|
Description
|
|
nvarchar(100)
|
|
Series
|
Serie
|
|
int(4)
|
For number generation you can define the series in system init - Document Numbering - Object "Items"
DIH: here you can define the name of series (NNM1.Seriess) as Number
If you'Ve only series name, you can use follow script :
select "Series" into value from "NNM1" where "SeriesName"='' and "ObjectCode"=4
|
U_beas_ver
|
Item Version
|
|
nvarchar(20)
|
Version number of the item
editable. If it's defined in Item Version Control, it's not editable and the system is working with Item Version control
|
FrgnName
|
Description in foreing language
|
|
nvarchar(100)
|
|
ItemType
|
Item type
|
|
char(1)
|
|
ItmsGrpCod
|
ItemGroup
|
|
smallint(2)
|
|
CodeBars
|
Bar code
|
|
nvarchar(254)
|
|
InvntItem
|
Stock item
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
SellItem
|
Sell item
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
PrchseItem
|
Purchase item
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
AssetItem
|
Fixed assets
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
VATLiable
|
VAT binding
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
U_match
|
Match code
|
|
nvarchar(50)
|
|
U_din
|
DIN
|
|
nvarchar(50)
|
|
U_znr
|
Drawing number
|
|
nvarchar(50)
|
|
FirmCode
|
Manufacturer
|
|
smallint(2)
|
Firmcode, Manufacturer
Import: You can import with FirmName (Manucturename) or the id from OMRC
Attention: You can't update this field! Use this only for create new item entries
|
SWW
|
Additional identifier
|
|
nvarchar(16)
|
|
U_wst_id
|
Raw material
|
|
nvarchar(20)
|
|
U_sachb_id
|
Employee
|
|
nvarchar(50)
|
|
U_gruppe
|
Material group
|
|
nvarchar(20)
|
|
U_prccode
|
Cost center
|
|
nvarchar(20)
|
|
ValidFrom
|
Available From
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
ValidTo
|
Available To
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
ValidComm
|
Available Comment
|
|
nvarchar(30)
|
|
ValidFor
|
Active
|
|
char(1)
|
Valid values: Yes=1
No=0
|
frozenFor
|
Inactive
|
|
char(1)
|
Valid values: Yes=1
No=0
|
U_dispo
|
Breakdown
|
|
char(0)
|
|
PrcrmntMtd
|
Production method
|
|
char(1)
|
|
U_beas_VerControl
|
Version Administration
|
|
int(4)
|
Valid values: No=0
extented view=1
separate bom=2
|
U_me_verbr
|
Cosumption unit
|
|
nvarchar(20)
|
|
U_losgr
|
Lot size production
|
|
numeric(4)
|
|
IssueMthd
|
Issue method
|
|
char(1)
|
Issue methode of the item
Attention: Serial and batch items: You must set this to "M"
Valid values: Backflush=B
Manuell=M
|
U_aussch
|
Cut-Off (%)
|
|
numeric(4)
|
|
U_verschn
|
Verschnittfaktor
|
|
nvarchar(20)
|
|
Phantom
|
Phantom Item
|
|
char(1)
|
Phantom Item
Valid values: Yes=Y
No=N
|
U_kzdruck
|
Withdrawal document
|
|
char(1)
|
|
U_sa
|
Made-to-order
|
|
char(1)
|
|
U_bereitst
|
Allocate
|
|
char(1)
|
|
U_beas_prodrelease
|
Release production
|
|
char(1)
|
|
U_brgew
|
Gross weight
|
|
numeric(4)
|
|
CardCode
|
Preffered vendor
|
|
nvarchar(15)
|
|
SuppCatNum
|
Mf. Catalog Number
|
|
nvarchar(50)
|
|
BuyUnitMsr
|
Purchasing UoM
|
|
nvarchar(100)
|
|
NumInBuy
|
Items per purchase UoM
|
|
numeric(4)
|
|
PurPackMsr
|
Packaging UoM
|
|
nvarchar(30)
|
|
CstGrpCode
|
Custom group
|
|
smallint(2)
|
|
U_zollt
|
Customs Tariff No
|
|
nvarchar(20)
|
|
U_uland
|
Originating country
|
|
nvarchar(3)
|
|
TaxType
|
Tax group
|
|
char(1)
|
|
BLength1
|
Buy length
|
|
numeric(4)
|
|
BWidth1
|
Buy Width
|
|
numeric(4)
|
|
BHeight1
|
Buy Height
|
|
numeric(4)
|
|
BVolume
|
Buy Volume
|
|
numeric(4)
|
|
BWeight1
|
Buy Weight
|
|
numeric(4)
|
|
BLen1Unit
|
Buy length unit
|
|
smallint(2)
|
|
BWdth1Unit
|
Buy width unit
|
|
smallint(2)
|
|
BHght1Unit
|
Buy height unit
|
|
smallint(2)
|
|
BVolUnit
|
Buy volume unit
|
|
smallint(2)
|
|
BWght1Unit
|
Buy weight unit
|
|
smallint(2)
|
|
PurFactor1
|
Factor 1
|
|
numeric(4)
|
|
PurFactor2
|
Factor 2
|
|
numeric(4)
|
|
PurFactor3
|
Factor 3
|
|
numeric(4)
|
|
PurFactor4
|
Factor 4
|
|
numeric(4)
|
|
SalUnitMsr
|
Sales UoM Name
|
|
nvarchar(100)
|
Unit of Measurement for sales
|
NumInSale
|
Items per Sales Unit
|
|
numeric(4)
|
|
SalPackMsr
|
Packaging UoM Name
|
|
nvarchar(30)
|
|
SalPackUn
|
Quantity per Package UoM
|
|
numeric(4)
|
|
SLength1
|
Sale length
|
|
numeric(4)
|
|
SWidth1
|
Sale width
|
|
numeric(4)
|
|
SHeight1
|
Sale height
|
|
numeric(4)
|
|
SVolume
|
Sale volume
|
|
numeric(4)
|
|
SWeight1
|
Sale Weight
|
|
numeric(4)
|
|
SLen1Unit
|
Sales length unit
|
|
smallint(2)
|
|
SWdth1Unit
|
Sales width unit
|
|
smallint(2)
|
|
SHght1Unit
|
Sales height unit
|
|
smallint(2)
|
|
SVolUnit
|
Sales volume unit
|
|
smallint(2)
|
|
SWght1Unit
|
Sales weight unit
|
|
smallint(2)
|
|
SalFactor1
|
Sales Factor 1
|
|
numeric(4)
|
|
SalFactor2
|
Sales Factor 2
|
|
numeric(4)
|
|
SalFactor3
|
Sales Factor 3
|
|
numeric(4)
|
|
SalFactor4
|
Sales Factor 2
|
|
numeric(4)
|
|
GLMethod
|
Set G/L account by
|
|
char(1)
|
|
InvntryUom
|
Inventory UoM
|
|
nvarchar(100)
|
|
DfltWH
|
Primary Warehouse
|
|
nvarchar(8)
|
|
EvalSystem
|
Valuation Method
|
|
char(1)
|
Define the CostAccounting Method (Evaluation Method)
Valid values: Moving Average=A
Standard=S
FIFO=F
Serie | Charge=B
=
|
AvgPrice
|
Item costs
|
|
numeric(4)
|
|
ByWh
|
Stock management by Warehouse No.
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
ReorderQty
|
Required (Purchasing UoM)
|
|
numeric(4)
|
|
MinLevel
|
Minimum Inventory
|
|
numeric(4)
|
|
MaxLevel
|
Max. Stock
|
|
numeric(4)
|
|
U_batchroh
|
Batch determination
|
|
char(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.
Valid values: batchnum is same as last cunsumed material=J
automatic batch number generation=N
manual batch number=M
|
U_haltbark
|
Shelf life in days
|
|
numeric(4)
|
|
U_haltbar2
|
Shelf Life 2 Batch
|
|
numeric(4)
|
|
MngMethod
|
Only at issue
|
|
char(1)
|
|
PlaningSys
|
Planning method
|
|
char(1)
|
Valid values: Keine=N
Disposition=M
|
OrdrMulti
|
Order multiple
|
|
numeric(4)
|
|
MinOrdrQty
|
Min order quantity
|
|
numeric(4)
|
|
LeadTime
|
Lead time
|
|
int(4)
|
|
ToleranDay
|
tolerance days
|
|
int(4)
|
Tolerance days
|
UserText
|
Description User
|
|
ntext(8)
|
|
U_text_d
|
Long description
|
|
ntext(8)
|
|
U_text_eng
|
Foregn language
|
|
ntext(8)
|
|
U_beas_kumulierung
|
MRP Sum grouping
|
|
nvarchar(10)
|
Valid values: Detail=
Day=D
Week=W
Month=M
Sum=S
|
U_bestellt
|
Pur. order description
|
|
ntext(8)
|
|
U_beas_BinGroup
|
Warehouse Rule
|
|
nvarchar(20)
|
|
Slength2
|
Sale length 2
|
|
numeric(4)
|
|
SHeight2
|
Sale height 2
|
|
numeric(4)
|
|
SHght2Unit
|
Sales height unit 2
|
|
smallint(2)
|
|
SWidth2
|
|
|
numeric(4)
|
|
SWdth2Unit
|
|
|
smallint(2)
|
|
SWeight2
|
|
|
numeric(4)
|
|
SWght2Unit
|
|
|
smallint(2)
|
|
BHght2Unit
|
Buy height unit 2
|
|
smallint(2)
|
|
BWidth2
|
Buy Width 2
|
|
numeric(4)
|
|
VatGourpSa
|
Sales VAT Group
|
|
nvarchar(8)
|
|
Blength2
|
Buy length 2
|
|
numeric(4)
|
|
BWght2Unit
|
Buy weight unit 2
|
|
smallint(2)
|
|
ManSerNum
|
Stock by serial number
|
|
char(1)
|
activ = Item per serial number.
Attention: set issue method to NO
Valid values: Yes=Y
No=N
|
frozenFrom
|
Locked from
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
frozenTo
|
Locked To
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
FrozenComm
|
locked Comment
|
|
nvarchar(30)
|
|
UgpEntry
|
Unit Group Id
|
|
int(4)
|
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
|
SUoMEntry
|
Sales Uom Code
|
|
int(4)
|
|
IUomEntry
|
Inventory Uom Entry
|
|
int(4)
|
|
U_kalksche
|
Calculation schema
|
|
nvarchar(20)
|
|
PicturName
|
Picture 1
|
|
nvarchar(200)
|
|
U_picture3
|
Picture 3
|
|
nvarchar(100)
|
|
VatGroupPu
|
Purchase VAT Group
|
|
nvarchar(8)
|
|
PUoMEntry
|
Purchase Uom Code
|
|
int(4)
|
|
U_kalk_pr
|
Calculation price
|
|
numeric(4)
|
|
U_picture2
|
Picture 2
|
|
nvarchar(100)
|
|
U_spezgew
|
Spezifisches Weight
|
|
numeric(4)
|
|
U_beasprio
|
Priority
|
|
int(4)
|
|
U_beas_shortvariantd
|
Variant Description
|
|
ntext(16000)
|
|
QryGroup1
|
Property 1
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup2
|
Property 2
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup3
|
Property 3
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup4
|
Property 4
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup5
|
Property 5
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup6
|
Property 6
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup7
|
Property 7
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup8
|
Property 8
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup9
|
Property 9
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup10
|
Property 10
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup11
|
Property 11
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup12
|
Property 12
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup13
|
Property 13
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup14
|
Property 14
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup15
|
Property 15
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup16
|
Property 16
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup17
|
Property 17
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup18
|
Property 18
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup19
|
Property 19
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup20
|
Property 20
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
U_fert_vk
|
--
|
|
numeric(4)
|
Valid values: Yes=Y
No=N
|
U_mat_gk
|
--
|
|
numeric(4)
|
Valid values: Yes=Y
No=N
|
QryGroup21
|
Property 21
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup22
|
Property 22
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup23
|
Property 23
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup24
|
Property 24
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup25
|
Property 25
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup26
|
Property 26
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup27
|
Property 27
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup28
|
Property 28
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup29
|
Property 29
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup30
|
Property 30
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup31
|
Property 31
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup32
|
Property 32
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup33
|
Property 33
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup34
|
Property 34
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup35
|
Property 35
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup36
|
Property 36
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup37
|
Property 37
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup38
|
Property 38
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup39
|
Property 39
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup40
|
Property 40
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup41
|
Property 41
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup42
|
Property 42
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup43
|
Property 43
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup44
|
Property 44
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup45
|
Property 45
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup46
|
Property 46
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup47
|
Property 47
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup48
|
Property 48
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup49
|
Property 49
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup50
|
Property 50
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup51
|
Property 51
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup52
|
Property 52
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup53
|
Property 53
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup54
|
Property 54
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup55
|
Property 55
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup56
|
Property 56
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup57
|
Property 57
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup58
|
Property 58
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup59
|
Property 59
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup60
|
Property 60
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup61
|
Property 61
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup62
|
Property 62
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup63
|
Property 63
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
QryGroup64
|
Property 64
|
|
char(1)
|
Valid values: Yes=Y
No=N
|
ManBtchNum
|
Batch management
|
|
char(1)
|
activ = Item per batch number.
Attention: set issue method to NO
Valid values: Yes=Y
No=N
|
|
Help URL: https://help.beascloud.com/beas202206/index.html?dih_item.htm
|