DIH Item

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