Fact table of stock journals

The fact table of stock transactions belongs to the Stock datamart. It contains elements coming from the stock journal table.

Prerequisites

The STOJOU table must be parameterized to be audited for the BI if data synchronization should be incremental (update of the elements modified since the last synchronization only).

One of the objectives of the universe dedicated to stock journals is to facilitate data handling by inexperienced users, it is in no way to duplicate data:

Some information deemed secondary is not transmitted.
Conversely, other information is calculated.
Finally, information is restructured if needed.

Data detail

Field code	Normal title	Menu	Table	Object type
STOFCY	Site - Transactions	0	0	Dimension
ITMREF	Product - Transactions	0	0	Dimension
LOC	Location	0	0	Dimension
IPTDAT	Posting date:	0	0	Dimension
CPY	Company	0	0	Dimension
FIYNUM	Financial year	0	0	Technical
PERNUM	Period	0	0	Dimension
TRSTYP	Movement type	704	0	Dimension
VCRTYP	Journal type	701	0	Dimension
VCRNUM	Journal number	0	0	Information
VCRLIN	Journal line no	0	0	Information
VCRTYPORI	Original journal type	701	0	Dimension
VCRNUMORI	Original journal	0	0	Information
VCRLINORI	Original journal line no	0	0	Information
QTYSTU	STK quantity	0	0	Measurement
AMTVAL	Transaction amount	0	0	Measurement
AMTORD	Order amount	0	0	Measurement
AMTDEV	Non absorbed variance	0	0	Measurement
AMTVALR	Tcn amount reporting cur.	0	0	Measurement
AMTORDR	Order amount reporting cur.	0	0	Measurement
AMTDEVR	Non absorbed variance rep. cur.	0	0	Measurement
BPRNUM	BP (Business Partners)	0	0	Dimension
PJT	Project	0	0	Dimension
STAORI	Status of origin	0	0	Dimension
STADST	Destination status	0	0	Dimension
RCPFLG	Enter	1	0	Dimension
ISSFLG	ISSUE	1	0	Dimension

Technical additions

Synchronization rules

The fact table of stock journals is loaded on the basis of a synchronization rule:

STOJOU1: for the stock transactions.

Specific loading functions

TRTX3BI.GETCPY([F:STJ]STOFCY): This function returns the company of the storage site
TRTX3BI.GETEXE([F:STJ]STOFCY,[F:STJ]IPTDAT): This function is used to return the fiscal year of the transaction posting date.
TRTX3BI.GETPER([F:STJ]STOFCY,[F:STJ]STODAT): This function is used to return the period of the transaction posting date.
TRTX3BI.CNVCPYRPT([F:STJ]STOFCY,[F:STJ]IPTDAT,*): This function is uued to return an amount in reporting currency
TRTSTOBI.GETBPRNUM ([F:STJ]VCRTYP,[F:STJ]VCRNUM,[F:STJ]VCRLIN,[F:STJ]BPRNUM): This function is used to return the supplier for the quality controls further to the receipt.
TRTSTOBI.GETSTOQLYD ([F:STJ]VCRTYP,[F:STJ]VCRNUM,[F:STJ]VCRLIN,[F:STJ]QTYSTU): This function is used to return the original status of the quality control.