SAP ABAP Table STPOI (Internal BOM Items (for APIs))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PRO (Application Component) Products
     ⤷ CS (Package) R/3 Application development: PP Bills of Material

Basic Data

Table Category	INTTAB	Structure
Structure	STPOI	Table Relationship Diagram
Short Description	Internal BOM Items (for APIs)

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	BOM item
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
4	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
5	STLKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
6	STPOZ	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
7	DATUV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
8	TECHV	☐	TECHV	TECHS	CHAR	12	0	Technical status from
9	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
10	LKENZ	☐	LKENZ	XFELD	CHAR	1	0	Deletion Indicator
11	VGKNT	☐	VGKNT	KNTNR	NUMC	8	0	Preceding Nodes
12	VGPZL	☐	VGPZL	CIM_COUNT	NUMC	8	0	Previous Item Counter
13	ANDAT	☐	ANDAT	DATUM	DATS	8	0	Date Record Created on
14	ANNAM	☐	ANNAM	USNAM	CHAR	12	0	User Who Created Record
15	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
16	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
17	IDNRK	☐	IDNRK	MATNR	CHAR	18	0	BOM Component	*
18	PSWRK	☐	PSWRK	WERKS	CHAR	4	0	Issuing Plant	T001W
19	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	T418
20	POSNR	☐	SPOSN	SPOSN	CHAR	4	0	BOM Item Number
21	SORTF	☐	SORTP	CHAR10	CHAR	10	0	Sort String
22	MEINS	☐	KMPME	MEINS	UNIT	3	0	Component Unit of Measure	T006
23	MENGE	☐	KMPMG	MENGV13	QUAN	13	3	Component Quantity
24	FMENG	☐	FMNGE	XFELD	CHAR	1	0	Fixed Quantity
25	AUSCH	☐	KAUSF	DEC3_2	DEC	5	2	Component scrap in percent
26	AVOAU	☐	AVOAU	DEC3_2	DEC	5	2	Operation Scrap
27	NETAU	☐	NETAU	XFELD	CHAR	1	0	Indicator: Net Scrap
28	SCHGT	☐	SCHGT	XFELD	CHAR	1	0	Indicator: bulk material
29	BEIKZ	☐	BEIKZ	BEIKZ	CHAR	1	0	Material Provision Indicators	T417
30	ERSKZ	☐	ERSKZ	ERSKZ	CHAR	1	0	Indicator: Spare Part	T413
31	RVREL	☐	RVREL	RVREL	CHAR	1	0	Indicator: Item Relevant to Sales	TVRL
32	SANFE	☐	SANFE	XFELD	CHAR	1	0	Indicator: Item Relevant to Production
33	SANIN	☐	SANIN	XFELD	CHAR	1	0	Indicator: Item Relevant to Plant Maintenance
34	SANKA	☐	CS_SANKA	CK_SELKZ	CHAR	1	0	Indicator: Item Relevant to Costing	TCK08
35	SANKO	☐	SANKO	XFELD	CHAR	1	0	Indicator: Item Relevant to Engineering/Design
36	SANVS	☐	SANVS	XFELD	CHAR	1	0	Indicator: High-Level Configuration
37	STKKZ	☐	STKKZ	XFELD	CHAR	1	0	Indicator: Plant Maintenance (PM) Assembly
38	REKRI	☐	REKRI	XFELD	CHAR	1	0	Indicator: BOM is Recursive
39	REKRS	☐	REKRS	XFELD	CHAR	1	0	Indicator: Recursiveness Allowed
40	CADPO	☐	CADPO	XFELD	CHAR	1	0	CAD Indicator
41	NFMAT	☐	CS_NFMAT	MATNR	CHAR	18	0	Follow-Up Material in BOM Item - NOT IN USE	MARA
42	NLFZT	☐	NLFZT	NLFZT	DEC	3	0	Lead-Time Offset
43	VERTI	☐	SA_VERTI	SA_VERTL	CHAR	4	0	Distribution key for component consumption	T437V
44	ALPOS	☐	ALPOS	XFELD	CHAR	1	0	Indicator: Alternative Item
45	EWAHR	☐	EWAHR	DEC3	DEC	3	0	Usage Probability in % (Alternative Item)
46	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
47	LIFZT	☐	LIFZT	DEC3	DEC	3	0	Delivery Time in Days
48	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
49	PREIS	☐	CPREI	WERT11	CURR	11	2	Price
50	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
51	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
52	SAKTO	☐	SAKTO	SAKNR	CHAR	10	0	Cost Element	*
53	ROANZ	☐	ROANZ	MENG13	QUAN	13	3	Number of Variable-Size Items
54	ROMS1	☐	ROMS1	MENG13	QUAN	13	3	Size 1
55	ROMS2	☐	ROMS2	MENG13	QUAN	13	3	Size 2
56	ROMS3	☐	ROMS3	MENG13	QUAN	13	3	Size 3
57	ROMEI	☐	ROMEI	MEINS	UNIT	3	0	Unit of measure for sizes 1 to 3	T006
58	ROMEN	☐	ROMEN	MENG13	QUAN	13	3	VarSizeItem Qty
59	RFORM	☐	RFORM	RFORM	CHAR	2	0	Formula Key	T418F
60	UPSKZ	☐	UPSKZ	XFELD	CHAR	1	0	Indicator: Subitems Exist
61	VALKZ	☐	VALKZ	XFELD	CHAR	1	0	Indicator: Item in More Than One Alternative
62	LTXSP	☐	LTXSP_CP	SPRAS	LANG	1	0	Long Text Language, for Creation of a Change Document	T002
63	POTX1	☐	POTX1	TEXT40	CHAR	40	0	BOM Item Text (Line 1)
64	POTX2	☐	POTX2	TEXT40	CHAR	40	0	BOM Item Text (Line 2)
65	OBJTY	☐	OBJTY	OBJTY	CHAR	1	0	Object Type (BOM Item)	*
66	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
67	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
68	DOKAR	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
69	DOKNR	☐	DOKNR	DOKNR	CHAR	25	0	Document number	*
70	DOKVR	☐	DOKVR	DOKVR	CHAR	2	0	Document version
71	DOKTL	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
72	CSSTR	☐	CSSTR	DEC3_2	DEC	5	2	Average Material Purity in %
73	CLASS	☐	KLASSE_D	KLASSE	CHAR	18	0	Class number
74	KLART	☐	KLASSENART	KLASSENART	CHAR	3	0	Class Type	TCLA
75	POTPR	☐	POTPR	POSTP	CHAR	1	0	Resulting item category	T418
76	AWAKZ	☐	AWAKZ	AWAKZ	CHAR	1	0	Selection Indicator for Configurable BOMs
77	INSKZ	☐	INSKZ	X	CHAR	1	0	Instance Indicator
78	VCEKZ	☐	VCEKZ	X	CHAR	1	0	Indicator: Not Displayed in Configuration Editor
79	VSTKZ	☐	VSTKZ	X	CHAR	1	0	Indicator: Not Displayed in Single-Level Configuration
80	VACKZ	☐	VACKZ	X	CHAR	1	0	Indicator: Not Displayed in Automatic Configuration
81	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
82	CLOBK	☐	CLOBK	XFELD	CHAR	1	0	Required Component
83	CLMUL	☐	CLMULT	XFELD	CHAR	1	0	Multiple Selection Allowed
84	CLALT	☐	CLALT	XFELD	CHAR	1	0	Alternative Display Format
85	CVIEW	☐	ABTEILUNG	CHAR10	CHAR	10	0	Organizational Area
86	KNOBJ	☐	KNOBJ	KNOBJ	NUMC	18	0	Number of Object with Assigned Dependencies
87	LGORT	☐	CSLGO	LGORT	CHAR	4	0	Issue Location for Production Order	T001L
88	KZKUP	☐	KZKUP	XFELD	CHAR	1	0	Indicator: Co-Product
89	INTRM	☐	INTRM	MATNR	CHAR	18	0	Intra Material	*
90	TPEKZ	☐	TPEKZ	XFELD	CHAR	1	0	Indicator: Restrictions Exist
91	STVKN	☐	STVKN	KNTNR	NUMC	8	0	Inherited Node Number of BOM Item
92	DVDAT	☐	DVDAT	DATUM	DATS	8	0	Date of Last Date Shift
93	DVNAM	☐	DVNAM	USNAM	CHAR	12	0	Name of the User Who Carried out the Date Shift
94	DSPST	☐	CS_DISPO	CS_DISPO	CHAR	2	0	Explosion Types	T414
95	ALPST	☐	CS_ALPST	CS_ALPST	CHAR	1	0	Alternative Item: Strategy
96	ALPRF	☐	CS_ALPRF	NUM2	NUMC	2	0	Alternative Item: Ranking Order
97	ALPGR	☐	CS_ALPGR	CHAR2	CHAR	2	0	Alternative Item: Group
98	KZNFP	☐	CS_KZNFP	XFELD	CHAR	1	0	Indicator: Follow-Up Item
99	NFGRP	☐	CS_NFGRP	CHAR2	CHAR	2	0	Follow-Up Group
100	NFEAG	☐	CS_NFEAG	CHAR2	CHAR	2	0	Discontinuation Group
101	KNDVB	☐	CS_KNDVB	CHAR1	CHAR	1	0	Indicator: Manual Change to Sales Order BOM
102	KNDBZ	☐	CS_KNDBZ	CHAR1	CHAR	1	0	Indicator: BOM Item Changed/Selected via Obj. Dependencies
103	KSTTY	☐	CS_KSTTY	STLTY	CHAR	1	0	BOM Category of Original Sales Order BOM Item
104	KSTNR	☐	CS_KSTNR	STNUM	CHAR	8	0	Bill of Material for Original Sales Order BOM Item
105	KSTKN	☐	CS_KSTKN	KNTNR	NUMC	8	0	Node Number of Original Sales Order BOM Item
106	KSTPZ	☐	CS_KSTPZ	CIM_COUNT	NUMC	8	0	Counter for Original Sales Order BOM Item
107	CLSZU	☐	CS_CLSZU	NUM8	NUMC	8	0	Classification Number
108	KZCLB	☐	CS_KZCLB	XFELD	CHAR	1	0	Indicator: Classification as Selection Condition
109	AEHLP	☐	CC_AEHLP	CC_AEHLP	NUMC	2	0	Date Shift Hierarchy Indicator
110	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area	PVBE
111	NLFZV	☐	CS_NLFZV	NLFZT	DEC	3	0	Lead-time offset for operation
112	NLFMV	☐	CS_NLFMV	MEINS	UNIT	3	0	Unit for lead-time offset for operation	T006
113	IDPOS	☐	CS_IDPOS	CS_IDPOS	CHAR	20	0	Item group
114	IDHIS	☐	CS_IDHIS	NUMC5	NUMC	5	0	History counter
115	IDVAR	☐	CS_IDVAR	CS_IDVAR	CHAR	5	0	Item variant
116	ALEKZ	☐	CS_ALEKZ	XFELD	CHAR	1	0	ALE indicator
117	ITMID	☐	CS_ITMID	CHAR8	CHAR	8	0	Item Identification
118	GUID	☐	CS_CHAR22	SYCHAR22	CHAR	22	0	Temporarily not used
119	ITSOB	☐	CS_SOBSL	SOBSL	CHAR	2	0	Special procurement type for BOM item	*
120	RFPNT	☐	CN_RFPNT	CN_RFPNT	CHAR	20	0	Reference point for BOM transfer	TCNRFP
121	GUIDX	☐	CS_GUID	SYSUUID	RAW	16	0	Global identification of an item's change status
122	.INCLUDE	☐				0	0
123	.INCLU--AP	☐				0	0	CU specific APPEND for BOM item
124	.INCLUDE	☐				0	0	CU specific data for a BOM item
125	CUFACTOR	☐	/CUM/CUFACTOR	/CUM/CUFACTOR	NUMC	6	0	CU: Number of CU Instances	*
126	.INCLU--AP	☐				0	0	Enhancement for A&D Configuration Control (BOMs)
127	FUNCID	☐	CCC_FUNCID	CHAR40	CHAR	40	0	Function Identifier
128	KZWPF	☐	KZWPF	XFELD	CHAR	1	0	Indicator: dependencies maintained in BOM
129	KZDMU	☐	CS_KZDMU	XFELD	CHAR	1	0	Indicator: Maintaining DMU-transfer matrix in BOM completed
130	KZDOC	☐	CS_KZDOC	XFELD	CHAR	1	0	Indicator: Maintain document assignment in BOM complete
131	DATUB	☐	DATUB	DATUM	DATS	8	0	Valid-to date
132	AENRA	☐	AENRA	AENNR	CHAR	12	0	Change Number To	*
133	IDENTIFIER	☐	CS_IDENT	CHAR10	CHAR	10	0	Customer-specific object identifier for APIs
134	FLDEL	☐	FLLKENZ	XFELD	CHAR	1	0	Deletion Indicator
135	.INCLUDE	☐				0	0	Identification of BOM item for APIs internal
136	ID_ITM_CTG	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	*
137	ID_ITEM_NO	☐	SPOSN	SPOSN	CHAR	4	0	BOM Item Number
138	ID_COMP	☐	IDNRK	MATNR	CHAR	18	0	BOM Component	*
139	ID_CLASS	☐	KLASSE_D	KLASSE	CHAR	18	0	Class number
140	ID_CL_TYPE	☐	KLASSENART	KLASSENART	CHAR	3	0	Class Type	*
141	ID_DOC	☐	DOKNR	DOKNR	CHAR	25	0	Document number	*
142	ID_DOC_TYP	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	*
143	ID_DOC_PRT	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
144	ID_DOC_VRS	☐	DOKVR	DOKVR	CHAR	2	0	Document version
145	ID_SORT	☐	SORTP	CHAR10	CHAR	10	0	Sort String
146	ID_GUID	☐	CS_GUID	SYSUUID	RAW	16	0	Global identification of an item's change status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	STPOI	AENNR	AENR	AENNR	REF	C	CN
2	STPOI	BEIKZ	T417	BEIKZ	REF	C	CN
3	STPOI	DOKAR	TDWA	DOKAR	REF	C	CN
4	STPOI	DSPST	T414	DISPO	REF	C	CN
5	STPOI	EKGRP	T024	EKGRP	REF	C	CN
6	STPOI	EKORG	T024E	EKORG	REF	C	CN
7	STPOI	ERSKZ	T413	ERSKZ	REF	C	CN
8	STPOI	KLART	TCLA	KLART	REF	C	CN
9	STPOI	LGORT	T001L	LGORT	REF	C	CN
10	STPOI	LIFNR	LFA1	LIFNR	REF	C	CN
11	STPOI	LTXSP	T002	SPRAS	REF	C	CN
12	STPOI	MANDT	T000	MANDT	KEY	1	CN
13	STPOI	MATKL	T023	MATKL	REF	C	CN
14	STPOI	MEINS	T006	MSEHI	REF	1	CN
15	STPOI	NFMAT	MARA	MATNR	REF	C	CN
16	STPOI	NLFMV	T006	MSEHI	REF	C	CN
17	STPOI	POSTP	T418	POSTP	REF	1	CN
18	STPOI	POTPR	T418	POSTP	REF	C	CN
19	STPOI	PRVBE	PVBE	PRVBE	REF	C	CN
20	STPOI	PSWRK	T001W	WERKS	REF	C	CN
21	STPOI	RFORM	T418F	RFORM	REF	C	CN
22	STPOI	RFPNT	TCNRFP	RFPNT	REF	C	CN
23	STPOI	ROMEI	T006	MSEHI	REF	C	CN
24	STPOI	RVREL	TVRL	RVREL	REF	C	CN
25	STPOI	SANKA	TCK08	SELKZ	REF	C	CN
26	STPOI	VERTI	T437V	VERTL	REF	C	CN
27	STPOI	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in