SAP ABAP Table MBSTOCKKEY (List with Keys for APO Stock Selection)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SCM-BAS (Application Component) SCM Basis
     ⤷ CIFA (Package) CIF: Composite Package for Application Add-Ons

Basic Data

Table Category	INTTAB	Structure
Structure	MBSTOCKKEY	Table Relationship Diagram
Short Description	List with Keys for APO Stock Selection

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	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
2	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
3	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
4	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
5	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
6	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
7	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
8	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
9	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
10	PSPNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
11	BSTTYP	☐	BSTTYP_APO	BSTTYP_APO	CHAR	1	0	Stock categories in APO

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MBSTOCKKEY	KUNNR	KNA1	KUNNR	KEY	1	CN
2	MBSTOCKKEY	LGORT	T001L	LGORT	KEY	1	CN
3	MBSTOCKKEY	LIFNR	LFA1	LIFNR	KEY	1	CN
4	MBSTOCKKEY	POSNR	VBUP	POSNR	KEY	1	CN
5	MBSTOCKKEY	PSPNR	PRPS	PSPNR	KEY	1	CN
6	MBSTOCKKEY	SOBKZ	T148	SOBKZ	KEY	1	CN
7	MBSTOCKKEY	VBELN	VBUK	VBELN	KEY	1	CN
8	MBSTOCKKEY	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in