SAP Table S036
LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EXG)
S036 (LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EXG)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link S036 to other SAP tables.
Source: S036 (LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EXG))
S036 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | 0 | |||||||||
| VRSIO | Version number in the information structure | VRSIO | P44V | CHAR | 3 | 0 | ||||||||
| SPMON | Calendar year / month | RSCALMONTH | NUMC | 6 | 0 | |||||||||
| SPTAG | Calendar day | RSCALDAY | DATS | 8 | 0 | |||||||||
| SPWOC | Calendar year / week | RSCALWEEK | NUMC | 6 | 0 | |||||||||
| SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | 0 | |||||||||
| MATREF | Material group reference for exchange balance reporting | OIA_MATREF | CHAR | 20 | 0 | |||||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||
| EXGPTR | Exchange partner (vendor number) | OIA_EXGPTR | LFA1 | CHAR | 10 | 0 | ||||||||
| UPENR | Constant to identify logical inventory adjustment | OIA_UPENR | CHAR | 3 | 0 | |||||||||
| EXGTYP | Exchange type | OIA_EXGTYP | TOIA2 | CHAR | 4 | 0 | ||||||||
| EXGNUM | Exchange agreement number | OIA_EXGNUM | OIA01 | CHAR | 10 | 0 | ||||||||
| MATINEX | Posting rules for material | OIA_MATPST | CHAR | 1 | 0 |
Possible values
|
||||||||
| OIBASPROD | Base product number | OIA_SBMAT | MARA | CHAR | 18 | 0 | ||||||||
| PERIV | Fiscal Year Variant | PERIV | T009 | CHAR | 2 | 0 | ||||||||
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | 0 | |||||||||
| BASME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||
| RECPT | Exchange receipts | OIA_RECPT | QUAN | 15 | 3 | |||||||||
| LIFTS | Exchange deliveries | OIA_DELIV | QUAN | 15 | 3 | |||||||||
S036 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| S036 | BASME | S036 | BASME | T006 | Units of Measurement | MSEHI |
| S036 | BASME | S036 | MANDT | T006 | Units of Measurement | MANDT |
| S036 | EXGNUM | S036 | EXGNUM | OIA01 | Exchange header (IS-Oil EXG standard/core object) | EXGNUM |
| S036 | EXGNUM | S036 | MANDT | OIA01 | Exchange header (IS-Oil EXG standard/core object) | MANDT |
| S036 | EXGPTR | S036 | EXGPTR | LFA1 | Vendor Master (General Section) | LIFNR |
| S036 | EXGPTR | S036 | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| S036 | EXGTYP | S036 | EXGTYP | TOIA2 | Exchange types | EXGTYP |
| S036 | EXGTYP | S036 | MANDT | TOIA2 | Exchange types | MANDT |
| S036 | MANDT | S036 | MANDT | T000 | Clients | MANDT |
| S036 | MATNR | S036 | MATNR | MARA | General Material Data | MATNR |
| S036 | MATNR | S036 | MANDT | MARA | General Material Data | MANDT |
| S036 | OIBASPROD | S036 | OIBASPROD | MARA | General Material Data | MATNR |
| S036 | OIBASPROD | S036 | MANDT | MARA | General Material Data | MANDT |
| S036 | PERIV | S036 | MANDT | T009 | Fiscal Year Variants | MANDT |
| S036 | PERIV | S036 | PERIV | T009 | Fiscal Year Variants | PERIV |
| S036 | VRSIO | S036 | MANDT | P44V | Planning Versions | MANDT |
| S036 | VRSIO | S036 | VRSIO | P44V | Planning Versions | VRSIO |
| S036 | VRSIO | S036 | SSOUR | P44V | Planning Versions | SSOUR |
| S036 | VRSIO | * | P44V | Planning Versions | GSTRU | |
| S036 | WERKS | S036 | WERKS | T001W | Plants/Branches | WERKS |
| S036 | WERKS | S036 | MANDT | T001W | Plants/Branches | MANDT |
