S034

INVCO: Movements (Batches) | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
WERKS FK Plant
LGORT FK Storage location
MATNR FK Material Number
CHARG FK Batch Number
Column Name Description
💲 Local Currency (HWAER):
CWZUBB Valuated stock receipts value
CWAGBB Value of valuated stock that has been issued
CWGVBR Total usage value
CWUVBR Unplanned usage value
Column Name Description
📏 Base Unit of Measure (BASME):
CMZUBB Valuated stock receipts quantity
CMZUKB Consignment stock receipts quantity
CMAGBB Quantity of valuated stock issues
CMAGKB Quantity of consignment stock that has been issued
CMGVBR Total usage quantity
CMUVBR Unplanned usage quantity
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
CAZUBB Number of times that valuated stock has been received ANZAHL
CAZUKB Number of times that consignment stock has been received ANZAHL
CAAGBB Number of times valuated stock has been issued ANZAHL
CAAGKB Number of times consignment stock has been issued ANZAHL
CAMBWG Number of material movements ANZAHL
CAGVBR Number of times that total usage has been updated ANZAHL
CAUVBR Number of times an unplanned usage has been recorded ANZAHL
CASTOR Number of cancelation documents to date ANZAHL
Master Data Relations Join Conditions
Base Unit of Measure
  • S034.MANDT == T006.MANDT
  • S034.BASME == T006.MSEHI
Batch number
  • Material Number
  • Batch Number
  • Plant
  • S034.MANDT == MCHA.MANDT
  • S034.MATNR == MCHA.MATNR
  • S034.CHARG == MCHA.CHARG
  • S034.WERKS == MCHA.WERKS
Currency key
  • S034.MANDT == TCURC.MANDT
  • S034.HWAER == TCURC.WAERS
Storage location
  • Storage location
  • Client
  • Plant
  • S034.LGORT == T001L.LGORT
  • S034.MANDT == T001L.MANDT
  • S034.WERKS == T001L.WERKS
Client S034.MANDT == T000.MANDT
Material No.
  • Material Number
  • Client
  • S034.MATNR == MARA.MATNR
  • S034.MANDT == MARA.MANDT
Plant
  • S034.MANDT == T001W.MANDT
  • S034.WERKS == T001W.WERKS