SAP ABAP Table PSHLP_ALV_MATERIAL_ST (Material ALV UI)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PS-ST (Application Component) Structures
     ⤷ PS_HLP_MD (Package) Handling Large Projects:-Master Data

Basic Data

Table Category	INTTAB	Structure
Structure	PSHLP_ALV_MATERIAL_ST	Table Relationship Diagram
Short Description	Material ALV UI

Delivery and Maintenance

Pool/cluster
Delivery Class
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	POSNR	☐	APOSN	SPOSN	CHAR	4	0	BOM item number
2	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
4	MENGE	☐	CO_MENGE	MENGV13	QUAN	13	3	Requirement quantity of the component
5	EINHEIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
6	MFLIC	☐	CN_MFLIC	CN_MFLIC	CHAR	3	0	Procurement indicator	TCNMF
7	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	T418
8	AUDISP	☐	AUDISP_PLUS	AUDISP	CHAR	1	0	Reservation Relevance/Generation of Purchase Requisition
9	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
10	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
11	MATXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
12	SORTF	☐	SORTP	CHAR10	CHAR	10	0	Sort String
13	BDTER	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
14	SCHED_START	☐	SCHED_START	XFELD	CHAR	1	0	Scheduling aligned with activity start date
15	SCHED_END	☐	SCHED_END	XFELD	CHAR	1	0	Scheduling aligned with activity finish date
16	KZMPF	☐	KZMPF	XFELD	CHAR	1	0	Manual Maintenance of Requirement Date
17	NLFZV	☐	CS_NLFZV	NLFZT	DEC	3	0	Lead-time offset for operation
18	NLFMV	☐	CS_NLFMV	MEINS	UNIT	3	0	Unit for lead-time offset for operation	T006
19	VERTI	☐	SA_VERTL	SA_VERTL	CHAR	4	0	MRP Distribution Key	T437V
20	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
21	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
22	GRP_IND	☐	PS_GRP_IND	PS_GRP_IND	CHAR	20	0	Collective Purchase Requisition Indicator	*
23	LTEXT	☐	AUFLTEXT	XFELD	CHAR	1	0	Long Text Exists
24	PSPEL	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
25	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
26	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
27	ASSEMBLY	☐	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	*
28	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
29	MAINBOM	☐	BAGRP	MATNR	CHAR	18	0	Assembly	*
30	MAINTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
31	BRTDATE	☐	BRUTR	DATUM	DATS	8	0	Fixed key date
32	SANKA	☐	CK_SELKZ	CK_SELKZ	CHAR	1	0	Indicator for Relevancy to Costing	TCK08
33	KZEKL	☐	KZEKL	XFELD	CHAR	1	0	Indicator: Unit costing exists
34	KZFIX	☐	CN_KZFIX	XFELD	CHAR	1	0	Indicator: Purchasing info record data are fixed
35	XWAOK	☐	XWAOK	XFELD	CHAR	1	0	Goods movement for reservation allowed
36	KZEAR	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
37	SCHGT	☐	SCHGT	XFELD	CHAR	1	0	Indicator: bulk material
38	RGEKZ	☐	RGEKZ	XFELD	CHAR	1	0	Indicator: Backflush
39	VORAB	☐	VORABKZ	XFELD	CHAR	1	0	Ind: Preliminary order
40	STRECKE	☐	STRECKE	XFELD	CHAR	1	0	Ind.: Third-party requisition
41	XFEHL	☐	XFEHL	XFELD	CHAR	1	0	Pre-allocated stock
42	FLG_PURS	☐	FLG_PURS	KREUZ	CHAR	1	0	Indicator: Purchase order exists
43	KZKFG	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
44	DUMPS	☐	DUMPS	XFELD	CHAR	1	0	Phantom item indicator
45	KZAUS	☐	AUSLF	AUSLF	CHAR	1	0	Discontinuation type
46	ALPOS	☐	ALTPS	XFELD	CHAR	1	0	Alternative item indicator
47	SPLKZ	☐	CHSPLIT	CHSPLIT	CHAR	1	0	Batch key
48	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
49	PRCTYPE	☐	NW_PRCTYPE	TEXT40	CHAR	40	0	Procurement Type
50	XLOEK	☐	XLOEK	XFELD	CHAR	1	0	Item is deleted
51	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
52	ENMNG	☐	ENMNG	MENG13	QUAN	13	3	Quantity withdrawn
53	FLMNG	☐	FLMNG	MENG13	QUAN	13	3	Shortfall quantity of the component in the order
54	VMENG	☐	VMENG	MENG15	QUAN	15	3	Confirmed quantity for availability check in SKU
55	WEMNG_CMP	☐	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
56	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
57	CELLTAB	☐	LVC_T_STYL		TTYP	0	0
58	COLOR_TAB	☐	LVC_T_SCOL		TTYP	0	0
59	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PSHLP_ALV_MATERIAL_ST	CHARG	MCHA	CHARG	REF	C	CN
2	PSHLP_ALV_MATERIAL_ST	EINHEIT	T006	MSEHI
3	PSHLP_ALV_MATERIAL_ST	EKORG	T024E	EKORG		1	N
4	PSHLP_ALV_MATERIAL_ST	INFNR	EINA	INFNR	REF	C	CN
5	PSHLP_ALV_MATERIAL_ST	KDAUF	VBUK	VBELN	REF	C	CN
6	PSHLP_ALV_MATERIAL_ST	LGORT	T001L	LGORT	REF	C	CN
7	PSHLP_ALV_MATERIAL_ST	MATNR	MARA	MATNR	REF	1	CN
8	PSHLP_ALV_MATERIAL_ST	MFLIC	TCNMF	MFLIC		C	CN
9	PSHLP_ALV_MATERIAL_ST	NLFMV	T006	MSEHI		1	N
10	PSHLP_ALV_MATERIAL_ST	POSTP	T418	POSTP	REF	C	CN
11	PSHLP_ALV_MATERIAL_ST	SANKA	TCK08	SELKZ	KEY	1	CN
12	PSHLP_ALV_MATERIAL_ST	SERNR	SNUM	SERNR	REF	C	CN
13	PSHLP_ALV_MATERIAL_ST	SOBKZ	T148	SOBKZ	REF	C	CN
14	PSHLP_ALV_MATERIAL_ST	VERTI	T437V	VERTL	REF	C	CN
15	PSHLP_ALV_MATERIAL_ST	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	606