SAP ABAP Table S036BIWS (S036BIWS * LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EX)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS (Application Component) Downstream
     ⤷ OI0_BW (Package) Oil/BW Business Information Warehouse (extractors,..)

Basic Data

Table Category	INTTAB	Structure
Structure	S036BIWS	Table Relationship Diagram
Short Description	S036BIWS * LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EX

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	STORNO	☐	STORNO	CHAR1_X	CHAR	1	0	Indicator: Data to Be Canceled
2	WRTTP	☐	RSVTYPE	RSVTYPE	NUMC	3	0	Value type for Reporting	*
3	SSOUR	☐	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
4	VRSIO	☐	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	P44V
5	SPMON	☐	RSCALMONTH	RSCALMONTH	NUMC	6	0	Calendar year / month
6	SPTAG	☐	RSCALDAY	DATUM	DATS	8	0	Calendar day
7	SPWOC	☐	RSCALWEEK	RSCALWEEK	NUMC	6	0	Calendar year / week
8	SPBUP	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
9	MATREF	☐	OIA_MATREF	OIA_MATREF	CHAR	20	0	Material group reference for exchange balance reporting
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
11	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
12	EXGPTR	☐	OIA_EXGPTR	LIFNR	CHAR	10	0	Exchange partner (vendor number)	LFA1
13	UPENR	☐	OIA_UPENR	CHAR3	CHAR	3	0	Constant to identify logical inventory adjustment
14	EXGTYP	☐	OIA_EXGTYP	OIA_EXGTYP	CHAR	4	0	Exchange type	TOIA2
15	EXGNUM	☐	OIA_EXGNUM	OIA_EXGNUM	CHAR	10	0	Exchange agreement number	OIA01
16	MATINEX	☐	OIA_MATPST	OIA_MATPST	CHAR	1	0	Posting rules for material
17	OIBASPROD	☐	OIA_SBMAT	MATNR	CHAR	18	0	Base product number	MARA
18	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
19	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
20	RECPT	☐	OIA_RECPT	MENG15	QUAN	15	3	Exchange receipts
21	LIFTS	☐	OIA_DELIV	MENG15	QUAN	15	3	Exchange deliveries

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S036BIWS	EXGNUM	OIA01	EXGNUM	KEY	C	CN
2	S036BIWS	EXGPTR	LFA1	LIFNR
3	S036BIWS	EXGTYP	TOIA2	EXGTYP	KEY	C	CN
4	S036BIWS	MATNR	MARA	MATNR
5	S036BIWS	OIBASPROD	MARA	MATNR
6	S036BIWS	VRSIO	P44V	VRSIO
7	S036BIWS	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20050224
SAP Release Created in