SAP Table S806E

S806 - Structural information

S806E (S806 - Structural information) 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 S806E to other SAP tables.

S806E table fields

Field		Data element	Checktable	Datatype	Length	Decimals
MANDT	Client	MANDT	T000	CLNT	3	0
SSOUR	Statistic(s) origin	SSOUR		CHAR	4	0
BUKRS	Company Code	BUKRS	T001	CHAR	4	0
EKORG	Purchasing Organization	EKORG	T024E	CHAR	4	0
EKGRP	Purchasing Group	BKGRP	T024	CHAR	3	0
LAND1	Country key of vendor	MCLANDL	T005	CHAR	3	0
LIFNR	Vendor Account Number	ELIFN	LFA1	CHAR	10	0
WERKS	Plant	EWERK	T001W	CHAR	4	0
LGORT	Storage Location	LGORT_D	T001L	CHAR	4	0
MATNR	Material Number	MATNR	MARA	CHAR	18	0
EBELN	Purchasing Document Number	EBELN	EKKO	CHAR	10	0
BASME	Base Unit of Measure	MEINS	T006	UNIT	3	0
UBASME	Conversion factor: quantities	UMREFF		FLTP	16	16
PLOBJ	Planning object	PLOBJ		CHAR	18	0
PERKZ	Period indicator	PERVR		CHAR	1	0
PERIV	Fiscal Year Variant	PERIV	T009	CHAR	2	0
PLTKZ	Indicator: element used in planning	PLTKZ		CHAR	1	0
ANTEI	Proportional factor (%) for disaggregation of product group	DANTEF		FLTP	16	16

S806E foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
S806E	BASME	S806E	MANDT	T006	Units of Measurement	MANDT
S806E	BASME	S806E	BASME	T006	Units of Measurement	MSEHI
S806E	BUKRS	S806E	BUKRS	T001	Company Codes	BUKRS
S806E	BUKRS	S806E	MANDT	T001	Company Codes	MANDT
S806E	EBELN	S806E	MANDT	EKKO	Purchasing Document Header	MANDT
S806E	EBELN	S806E	EBELN	EKKO	Purchasing Document Header	EBELN
S806E	EKGRP	S806E	MANDT	T024	Purchasing Groups	MANDT
S806E	EKGRP	S806E	EKGRP	T024	Purchasing Groups	EKGRP
S806E	EKORG	S806E	MANDT	T024E	Purchasing Organizations	MANDT
S806E	EKORG	S806E	EKORG	T024E	Purchasing Organizations	EKORG
S806E	LAND1	S806E	MANDT	T005	Countries	MANDT
S806E	LAND1	S806E	LAND1	T005	Countries	LAND1
S806E	LGORT	S806E	MANDT	T001L	Storage Locations	MANDT
S806E	LGORT	S806E	WERKS	T001L	Storage Locations	WERKS
S806E	LGORT	S806E	LGORT	T001L	Storage Locations	LGORT
S806E	LIFNR	S806E	LIFNR	LFA1	Vendor Master (General Section)	LIFNR
S806E	LIFNR	S806E	MANDT	LFA1	Vendor Master (General Section)	MANDT
S806E	MANDT	S806E	MANDT	T000	Clients	MANDT
S806E	MATNR	S806E	MANDT	MARA	General Material Data	MANDT
S806E	MATNR	S806E	MATNR	MARA	General Material Data	MATNR
S806E	PERIV	S806E	PERIV	T009	Fiscal Year Variants	PERIV
S806E	PERIV	S806E	MANDT	T009	Fiscal Year Variants	MANDT
S806E	WERKS	S806E	MANDT	T001W	Plants/Branches	MANDT
S806E	WERKS	S806E	WERKS	T001W	Plants/Branches	WERKS