SAP table S036 (LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EXG))

SAP table S036 has 16 primary key fields being MANDT,SSOUR,VRSIO,SPMON,SPTAG,SPWOC,SPBUP,MATREF,MATNR,WERKS,EXGPTR,UPENR,EXGTYP,EXGNUM,MATINEX,OIBASPROD.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
SSOUR Statistic(s) origin CHAR 4 0 SSOUR
VRSIO Version number in the information structure CHAR 3 0 P44V VRSIO
SPMON Calendar year / month NUMC 6 0 RSCALMONTH
SPTAG Calendar day DATS 8 0 RSCALDAY
SPWOC Calendar year / week NUMC 6 0 RSCALWEEK
SPBUP Period to analyze - posting period NUMC 6 0 SPBUP
MATREF Material group reference for exchange balance reporting CHAR 20 0 OIA_MATREF
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
EXGPTR Exchange partner (vendor number) CHAR 10 0 LFA1 OIA_EXGPTR
UPENR Constant to identify logical inventory adjustment CHAR 3 0 OIA_UPENR
EXGTYP Exchange type CHAR 4 0 TOIA2 OIA_EXGTYP
EXGNUM Exchange agreement number CHAR 10 0 OIA01 OIA_EXGNUM
MATINEX Posting rules for material CHAR 1 0 OIA_MATPST
1 Material external
2 Mat. and taxes internal
3 Mat. internal, taxes external
OIBASPROD Base product number CHAR 40 0 MARA OIA_SBMAT
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
VWDAT Pointer to administrative data NUMC 10 0 VWDAT
BASME Base Unit of Measure UNIT 3 0 T006 MEINS
RECPT Exchange receipts QUAN 15 3 OIA_RECPT
LIFTS Exchange deliveries QUAN 15 3 OIA_DELIV

S036 foreign key relationships

Table Field Check Table Check Field
0 S036 BASME T006 Units of Measurement MANDT
1 S036 EXGNUM OIA01 Exchange header (IS-Oil EXG standard/core object) EXGNUM
0 S036 EXGPTR LFA1 Supplier Master (General Section) MANDT
0 S036 EXGPTR LFA1 Supplier Master (General Section) LIFNR
1 S036 EXGTYP TOIA2 Exchange types MANDT
1 S036 EXGTYP TOIA2 Exchange types EXGTYP
0 S036 MATNR MARA General Material Data MANDT
0 S036 MATNR MARA General Material Data MATNR
1 S036 OIBASPROD MARA General Material Data MANDT
1 S036 OIBASPROD MARA General Material Data MATNR
0 S036 PERIV T009 Fiscal Year Variants MANDT
0 S036 PERIV T009 Fiscal Year Variants PERIV
1 S036 VRSIO P44V Planning Versions MANDT
1 S036 VRSIO P44V Planning Versions VRSIO
0 S036 WERKS T001W Plants/Branches WERKS