SAP ABAP Table SPTAB (Table of Material Master Tables with Full Key)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MGA (Package) Application development R/3 material master from 3.0

Basic Data

Table Category	INTTAB	Structure
Structure	SPTAB	Table Relationship Diagram
Short Description	Table of Material Master Tables with Full Key

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	Key to Material Master Management Table SPTAB
2	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
3	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
4	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
5	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
6	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
7	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	*
8	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	*
9	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
10	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
11	MYKEY	☐	MYKEY	MYKEY	CHAR	4	0	LIFO valuation level	*
12	TBNAM	☐	TBNAM	AS4TAB	CHAR	30	0	Table name	*
13	RCODE	☐	SYSUBRC	SYST_SHORT	INT4	10	0	Return Code
14	KZMUS	☐	KZMUS	XFELD	CHAR	1	0	Exactly One Entry of Material Master Table is Relevant
15	KZSTA	☐	KZSTA	XFELD	CHAR	1	0	Indicator: Status-relevant
16	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
17	BISTSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
18	PFSTATUS	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
19	AKTVST_I	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
20	AKTVST_U	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
21	AKTVST_D	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
22	AKTVST_G	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
23	RPSRF	☐	RPSRF	PSTAT	CHAR	15	0	Referenced status for retail
24	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	*
25	BERTY	☐	BERTY	BERTY	NUMC	2	0	Type of MRP area

History

Last changed by/on	SAP	20130529
SAP Release Created in