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).

Description

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.