S036

LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EXG) | #transactional | Component: Exchanges
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO FK Version number in the information structure
SPMON Calendar year / month
SPTAG Calendar day
SPWOC Calendar year / week
SPBUP Period to analyze - posting period
MATREF Material group reference for exchange balance reporting
MATNR FK Material Number
WERKS FK Plant
EXGPTR FK Exchange partner (vendor number)
UPENR Constant to identify logical inventory adjustment
EXGTYP FK Exchange type
EXGNUM FK Exchange agreement number
MATINEX Posting rules for material Show values
OIBASPROD FK Base product number
Column Name Description
Column Name Description
📏 Base Unit of Measure (BASME):
RECPT Exchange receipts
LIFTS Exchange deliveries
Column Name Description
SPTAG Calendar day
Column Name Description
MATINEX Posting rules for material Show values
Column Name Description Domain name
VWDAT Pointer to administrative data VWDAT
Master Data Relations Join Conditions
Base Unit of Measure
  • S036.MANDT == T006.MANDT
  • S036.BASME == T006.MSEHI
Exchange agreement number
  • Exchange agreement number
  • Client
  • S036.EXGNUM == OIA01.EXGNUM
  • S036.MANDT == OIA01.MANDT
Exchange partner (vendor number)
  • S036.MANDT == LFA1.MANDT
  • S036.EXGPTR == LFA1.LIFNR
Exchange type
  • S036.MANDT == TOIA2.MANDT
  • S036.EXGTYP == TOIA2.EXGTYP
Client S036.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S036.MATNR == MARA.MATNR
  • S036.MANDT == MARA.MANDT
Base product number
  • Base product number
  • Client
  • S036.OIBASPROD == MARA.MATNR
  • S036.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S036.PERIV == T009.PERIV
  • S036.MANDT == T009.MANDT
Version number in the information structure
  • Statistic(s) origin
  • Version number in the information structure
  • ?
  • S036.MANDT == P44V.MANDT
  • S036.SSOUR == P44V.SSOUR
  • S036.VRSIO == P44V.VRSIO
  • S036.[column in domain "GSTRU"] == P44V.GSTRU
Plant
  • S036.MANDT == T001W.MANDT
  • S036.WERKS == T001W.WERKS