Document Material Movement (write optimized)

DataStore object: 0RT_DS61

The main purpose of this DSO Object is to store all material movement documents (2LIS_03_BF) as a starting point for an audit trail. The audit trail has to fullfill two requirements a fast storage and an optimized storage of the data, because the DSO will grow fast. For example a midsize retailer has to upload about 500.000 material movement documents per day to BI.

A write optimized DSO supports here a faster storage compared to a standard DSO with changeLog functionality. To get a better reading performance in the access service methods additional indexes will be delivered in Standard Business Content.

Transformation TRCS 0RT_SL_01 -> 0RT_DS61:

Startroutine:

In the Start routine all records that are not stock relevant are filtered out.

Routines for calculating Original Price Gross/ Original Price Netto:

The Original Price should be stored in the document DSO, because the requirement is to display the original price at the time when the document is uploaded to BI. This key figure routine accesses the Data Store Object 0RT_DS01 during the upload with the key information material/plant to find the corresponding original price. In case that no original price is found the value stays empty.

Routine for calculating RMA Object:

The RMA is determined based on Material, Plant and Fiscal Variant information coming from the DataSource. Only in Case that no recasting is used the RMA Object is filled. If Recasting is used the RMA Object stays empty.

Routine of calculating Source of Markup/Markdown:

Depending on the process key the value Source of Markup/Markdown will be filled.

Delivered Indexes:

For a fast excess of the audit trail it is necessary to deliver two additional indexes for a read using the article or the RMA object.

Index 1 consists of the following fields:

0PLANT
0MATERIAL
0PROCESSKEY
0PSTING_DATE
0MOVETYPE
0STOCKCAT

Index 2 consists of the following fields:

0PLANT
0RMA_OBJ
0PROCESSKEY
0PSTING_DATE
0MOVETYPE
0STOCKCAT

Structure

Delta Update

The following delta update is supported for this DataStore object:

Delta update:
DataSource:

Data Modeling

Key Fields
Object Type	Name	Technical Name
Characteristic	Additional Key Field Revaluation Document Record	`0BWCOUNTER`
Data packet characteristic	Data Package	`0DATAPAKID`
Characteristic	BW: Document Item Number	`0DOC_ITEM`
Characteristic	BW: Document Number	`0DOC_NUM`
Characteristic	BW: Document Year	`0DOC_YEAR`
Characteristic	BW: Transaction Key	`0PROCESSKEY`
Data packet characteristic	Data Record Number	`0RECORD`
Data packet characteristic	Request GUID	`0REQUEST`

Data Fields
Object Type	Name	Technical Name
Unit of measurement	Base Unit of Measure	`0BASE_UOM`
Key figure	Delta PO/GR Order Quantity	`0CPDEOGQUOU`
Key figure	BW: Purchase Value in Local Currency	`0CPPVLC`
Key figure	BW: Amount in base unit of measure	`0CPQUABU`
Key figure	BW: Sales Value in Local Currency	`0CPSTLC`
Key figure	BW: Sales Value in Local Currency	`0CPSVLC`
Unit of measurement	Local currency	`0LOC_CURRCY`
Characteristic	Source System	`0LOGSYS`
Characteristic	Material	`0MATERIAL`
Characteristic	Reason for Goods Movement	`0MATMREA`
Characteristic	Movement Type (Inventory Management)	`0MOVETYPE`
Characteristic	Receiving Plant/Issuing Plant	`0MOVE_PLANT`
Characteristic	Purchasing document number	`0OI_EBELN`
Characteristic	Item number of purchasing document	`0OI_EBELP`
Characteristic	Plant	`0PLANT`
Unit of measurement	Order unit	`0PO_UNIT`
Characteristic	Posting date in the document	`0PSTNG_DATE`
Data packet characteristic	BW Delta Process: Update Mode	`0RECORDMODE`
Characteristic	RMA Object	`0RMA_OBJ`
Characteristic	RMA Cross-Company Code Stock Transfer	`0RMA_XCC`
Key figure	Original Price Gross (Receiving/Issuing Plant)	`0RT_OPB_MPT`
Key figure	Original Price Net (Receiving/Issuing Plant)	`0RT_OPN_MPT`
Characteristic	Source of Markdown/Markup	`0RT_REV_SRC`
Key figure	Original Price Gross	`0RT_VP_BT`
Key figure	Original Price Net	`0RT_VP_NT`
Unit of measurement	Original Price Currency Gross	`0RT_VWAERBT`
Unit of measurement	Original Price Currency Net	`0RT_VWAERNT`
Characteristic	Stock Categories	`0STOCKCAT`
Characteristic	Vendor	`0VENDOR`