SAP ABAP Table S097E (S097 - Structural Information)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S097E	Table Relationship Diagram
Short Description	S097 - Structural Information

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	QMART	☑	QMART	QMART	CHAR	2	0	Message Type	TQ80
5	MAWERK	☑	QMAWERKS	WERKS	CHAR	4	0	Plant for Material	T001W
6	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
7	UBASME	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
8	PLOBJ	☐	PLOBJ	CHAR18	CHAR	18	0	Planning object
9	PERKZ	☐	PERVR	PERVR	CHAR	1	0	Period indicator
10	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
11	PLTKZ	☐	PLTKZ	CHAR01	CHAR	1	0	Indicator: element used in planning
12	ANTEI	☐	DANTEF	FLTP	FLTP	16	16	Proportional factor (%) for disaggregation of product group

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S097E	BASME	T006	MSEHI
2	S097E	MANDT	T000	MANDT	KEY	1	CN
3	S097E	MATNR	MARA	MATNR
4	S097E	MAWERK	T001W	WERKS
5	S097E	PERIV	T009	PERIV	KEY	1	CN
6	S097E	QMART	TQ80	QMART

History

Last changed by/on	SAP	20130529
SAP Release Created in