SAP ABAP Table S165E (S165 - Structural information)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-QC-IS (Application Component) Information System
     ⤷ QG02 (Package) QM quality information system

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S165E	Table Relationship Diagram
Short Description	S165 - 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	KUNNR	☑	QKUNWE	KUNNR	CHAR	10	0	Customer (Ship-To Party)	KNA1
4	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	PRPLATZWRK	☑	WERKARBPL	WERKS	CHAR	4	0	Plant/Work Center	T001W
6	PRPLATZ	☑	QPRPLATZ	ARBPL	CHAR	8	0	Work Center
7	WERKSTPRUE	☑	WERKSTPRUE	QWERKSTPRF	CHAR	12	0	QMIS Plant/Master Inspection Characteristic
8	PLGRPLTYP	☑	QPLGRTYP	QPLGRTYP	CHAR	9	0	Combined Field Task List Type/Task List Group
9	PPLNKN	☑	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
10	MERKNR	☑	QMERKNRP	QMERKNRP	NUMC	4	0	Inspection Characteristic Number
11	WERK	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
12	PLOBJ	☐	PLOBJ	CHAR18	CHAR	18	0	Planning object
13	PERKZ	☐	PERVR	PERVR	CHAR	1	0	Period indicator
14	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
15	PLTKZ	☐	PLTKZ	CHAR01	CHAR	1	0	Indicator: element used in planning
16	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	S165E	KUNNR	KNA1	KUNNR
2	S165E	MANDT	T000	MANDT	KEY	1	CN
3	S165E	MATNR	MARA	MATNR
4	S165E	PERIV	T009	PERIV	KEY	1	CN
5	S165E	PRPLATZWRK	T001W	WERKS
6	S165E	WERK	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in