DIH Transactions (Production, Bookings, Manual Posting etc.)

Administration > Data Integration Hub > Data integration hub > Import Definition > Definition Data Target > DIH Transactions (Production, Bookings, Manual Posting etc.)

Top  Previous  Next
Expand/Collapse Toggles

Material transactions are defined in a definition file: "Transaction plan lines".

Different transaction types like receipt and issue, goods receipt etc. can be executed here.

The transaction type is indicated in the "Transaction Type" field.

 

The following transaction are supported:

- Work order Receipt / Issue

- Manual Receipt / Issue

 

Note: The system creates one document PER import line.

This means: If you import 200 lines, the system will create 200 documents.

 

See also DIH Material management transaction plan lines.

 

All the fields in this table are mandatory related to document type and item management method.

Field

Value

Transaction Type

Define the type of transaction type

Transaction Typ

Description

WOISSUE

Production – Material issue (or "WOIM")

WORECEIPT

Production – Material / Assembly receipt  

ISSUE

manual Issue

RECEIPT

manual receipt

Link Document Type

"WO"

Link Document

Work order Number (BEAS_FTHAUPT.BELNR_ID)

Link Line 1

Work order Position (BEAS_FTPOS.BELPOS_ID)

Link Line 2

Only for Bill of Material: Internal Bill of Material Position (BEAS_FTSTL.POS_ID)
For assemlby: Don't define it or 0

ItemCode

The Item Number (Assembly: BEAS_FTPOS.ItemCode, Bill of Material: BEAS_FTSTL.ART1_ID)

Quantity

the Issue Quantity in Inventory UoM

WareHouse

The Warehouse from the Item  OWHS.WhsCode

Bincode

Bincode if warehouse is a bin-managed warehouse

Supported: SAP, WMS and Beas bin-management

If this is a WMS or Beas bin-managed warehouse, the bin code is mandatory.

RFID / LUID

The RFID (beas) or LUID (WMS) Number for current Bin code

DistNumber

The visible Serial/Batch Number

 

Normal Item: Empty

Batch Administration: OBTN.DistNumber

Serial Administration: OSRN.DistNumber

 
If this is a work order receipt or purchase receipt and batch number generation is activated, it is not mandatory to fill it.

SysNumber

Only for Issue documents

Alternative to DistNumber (visible Batch/Serial Number) you can use the internal System Number. (OBTN.SysNumber, OSRN.SysNumber) Don't define both. Don't use it for receipt documents.

Batch Number

Not supported anymore. Please use DistNumber or SysNumber

Price

 

Important:

The data must be checked for correctness before the import. There is no further check in the import process.

The values must be checked in the Import Preview function or all necessary checks must be defined in the Source – Target – Link.

 

Complete list:

Field

Name

M

Type

Description

LineType

Transaction Type

X

nvarchar(20)

transaction line per line. Import: it's mandatory
Valid values: issue work order material=WOISSUE
receipt work order assembly or material=WORECEIPT
issue work order material (compatible)=WOIM
receipt work order assemlby or material (compatible)=WORM
Manual receipt=RECEIPT
Manual issue=ISSUE

DocDate

Document Valid Date


datetime(8)

best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.

Notes

Documetn remarks


nvarchar(255)


CardCode

Business partner


nvarchar(20)


Project

Project


nvarchar(20)


BASE_DOCTYPE

Link Document Type


nvarchar(20)

Type of base document
Example: WO = Workorder

BASE_DOCENTRY

Link Document


int(4)

Document entry
Example: work order = BEAS_FTHAUPT.BELNR_ID

BASE_LINENUM

Link Line 1


int(4)

Document entry
Example: work order position = BEAS_FTFTPOS.BELPOS_ID

BASE_LINENUM2

Link Line 2


int(4)

Document entry line 2
Example: work order bom position = BEAS_FTSTL.POS_ID

ItemCode

Itemcode


nvarchar(50)


Quantity

Quantity

X

decimal(9)


WhsCode

Warehouse


nvarchar(20)


BINCODE

Bincode


nvarchar(20)


RFID

RFID


nvarchar(20)


Version

Version


nvarchar(20)


DistNumber

DistNumber


nvarchar(40)

The "visible" Batch- and Serial number

SysNumber

Internal Batch/Serial number


int(4)

Describe the internal batch/serial number
you can define this in issue documents for define exact correct Serial/Batch Number

MnfSerial

Batch attribute 1


nvarchar(40)


LotNumber

Batch attribute 2


nvarchar(40)


InDate

date of entry


datetime(8)

best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.

MnfDate

Manufacturing Date


datetime(8)

best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.

ExpDate

Expir. date


datetime(8)

best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.

PERS_ID

personnel number


nvarchar(20)


USER_ID

User WEB User


nvarchar(20)


Price

Price


decimal(9)

Define the Price in defined currency
Import information:
Work order issue/receipt: not supported
Manual Issue: only if "Use Perpetual Inventory" is disabled
Manual Recept with follow rule:
If in first import line a price is defined, the system will use the prices defined in the import lines.
If no price defined in first line, the system will ignore prices from all lines.

Currency

Currency


nvarchar(5)


STATION_ID

Work station


nvarchar(50)


BatchNum

Batchnumber


nvarchar(1024)


UDF1

Userfield 1


nvarchar(100)


UDF2

Userfield 2


nvarchar(100)


UDF3

Userfield 3


nvarchar(100)


UDF4

Userfield 4


nvarchar(100)


 

 


Help URL: https://help.beascloud.com/beas202402/index.html?dih_transactions_production__b.htm