SAP ABAP Table WSOL_MATNR (Output list for materials)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WSOR (Package) IS-R: Assortments

Basic Data

Table Category	INTTAB	Structure
Structure	WSOL_MATNR	Table Relationship Diagram
Short Description	Output list for materials

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	.INCLUDE	☐				0	0	Level of discontinuation
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
5	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
6	LOCNR	☐	LOCNR	KUNNR	CHAR	10	0	Customer Number for Plant	KNA1
7	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
8	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
9	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
10	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
11	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
12	ALDAT	☐	ALDAT	DATUM	DATS	8	0	Discontinuation date
13	BSPER	☐	BESTSPERR	DATUM	DATS	8	0	Ordering block date
14	VSPER	☐	VERKSPERR	DATUM	DATS	8	0	Sales block date
15	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
16	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
17	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
18	.INCLUDE	☐				0	0	Error log for material reorganization
19	KZKORREKT	☐	KZAUSLIST	KZAUSLIST	CHAR	1	0	Indicates whether a material can be discontinued
20	MSGNR	☐	MSGNR	MSGNR	CHAR	3	0	Message number	*
21	TABNA	☐	TABNAME	AS4TAB	CHAR	30	0	Table Name	*
22	TABKEY	☐	ITEX	ITEX	CHAR	70	0	Internal ABAP/4 text
23	VERFA	☐	AUSL_FOLGE	AUSL_FOLGE	CHAR	2	0	Follow-up action after error (material discontinuation)	*
24	SELKZ	☐	ISELK	ESELK	CHAR	1	0	Selection indicator
25	KZSPERR	☐	OLSELK	OLSELKZ	CHAR	1	0	Selection ID, material discontinuation
26	.INCLUDE	☐				0	0	Additional Fields for Material Discontinuation
27	MSGTY_01	☐	MSGTY	MSGAR	CHAR	1	0	Message Type
28	ARBGB_01	☐	ARBGB	ARBGB	CHAR	20	0	Application Area	*
29	MSGV1_01	☐	MSGV1	CHAR50	CHAR	50	0	Message variable 01
30	MSGV2_01	☐	MSGV2	CHAR50	CHAR	50	0	Message variable 02
31	MSGV3_01	☐	MSGV3	CHAR50	CHAR	50	0	Message variable 03
32	MSGV4_01	☐	MSGV4	CHAR50	CHAR	50	0	Message variable 04
33	.INCLU--AP	☐				0	0	Additional Fields in Discontinuation for Seas. Procurement
34	MSGTY	☐	MSGTY	MSGAR	CHAR	1	0	Message Type
35	ARBGB	☐	ARBGB	ARBGB	CHAR	20	0	Application Area	*
36	MSGV1	☐	MSGV1	CHAR50	CHAR	50	0	Message variable 01
37	MSGV2	☐	MSGV2	CHAR50	CHAR	50	0	Message variable 02
38	MSGV3	☐	MSGV3	CHAR50	CHAR	50	0	Message variable 03
39	MSGV4	☐	MSGV4	CHAR50	CHAR	50	0	Message variable 04

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WSOL_MATNR	BWTAR	T149D	BWTAR
2	WSOL_MATNR	EKORG	T024E	EKORG
3	WSOL_MATNR	INFNR	EINA	INFNR
4	WSOL_MATNR	LGNUM	T300	LGNUM
5	WSOL_MATNR	LGORT	T001L	LGORT
6	WSOL_MATNR	LIFNR	LFA1	LIFNR
7	WSOL_MATNR	LOCNR	KNA1	KUNNR
8	WSOL_MATNR	MANDT	T000	MANDT
9	WSOL_MATNR	MATKL	T023	MATKL
10	WSOL_MATNR	MATNR	MARA	MATNR
11	WSOL_MATNR	VKORG	TVKO	VKORG
12	WSOL_MATNR	VTWEG	TVTW	VTWEG
13	WSOL_MATNR	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in