SAP ABAP Table PSHLP_TREX_AFPO_ST (Order Item)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PS (Application Component) Project System
     ⤷ PS_HLP_CACHE (Package) Handling Large Projects:-Cache

Basic Data

Table Category	INTTAB	Structure
Structure	PSHLP_TREX_AFPO_ST	Table Relationship Diagram
Short Description	Order Item

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	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
2	POSNR	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
3	.INCLUDE	☐				0	0	Order item (Include structure)
4	PSOBS	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
5	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
6	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
7	PROJN	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
8	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	*
9	STRMP	☐	CO_STRMP	DATUM	DATS	8	0	Start date of the planned order
10	ETRMP	☐	CO_ETRMP	DATUM	DATS	8	0	Opening date of the planned order
11	KDAUF	☐	CO_KDAUF	VBELN	CHAR	10	0	Sales order number	VBUK
12	KDPOS	☐	CO_KDPOS	POSNR	NUMC	6	0	Sales order item	*
13	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
14	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
15	PSAMG	☐	CO_PSAMG	MENG13	QUAN	13	3	Scrap quantity in item
16	PSMNG	☐	CO_PSMNG	MENG13	QUAN	13	3	Order item quantity
17	WEMNG	☐	CO_WEMNG	MENG13	QUAN	13	3	Quantity of goods received for the order item
18	IAMNG	☐	CO_IAMNG	MENG13V	QUAN	13	3	Expected surplus/deficit for goods receipt
19	AMEIN	☐	CO_AUFME	MEINS	UNIT	3	0	Unit of measure for in-house production	T006
20	MEINS	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
21	MATNR	☐	CO_MATNR	MATNR	CHAR	18	0	Material Number for Order	MARA
22	PAMNG	☐	AVMNG	MENG13	QUAN	13	3	Fixed quantity of scrap from production
23	PGMNG	☐	GSMNG	MENG13	QUAN	13	3	Total planned order quantity
24	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
25	TPAUF	☐	TPAUF	CHAR1	CHAR	1	0	Indicator: Partial conversion
26	LTRMI	☐	CO_LTRMI	DATUM	DATS	8	0	Actual delivery/finish date
27	LTRMP	☐	CO_LTRMP	DATUM	DATS	8	0	Delivery date from planned order
28	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
29	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
30	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
31	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
32	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
33	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
34	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
35	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	T149C
36	PWERK	☐	CO_PWERK	WERKS	CHAR	4	0	Planning plant for the order	T001W
37	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
38	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
39	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
40	WEBAZ	☐	PLWEZ	DEC3	DEC	3	0	Goods receipt processing time in days
41	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
42	SAFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	*
43	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
44	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
45	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
46	DWERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
47	DAUTY	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
48	DAUAT	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
49	DGLTP	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
50	DGLTS	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
51	DFREI	☐	CO_FREI	CHAR1	CHAR	1	0	Indicator: Order released/partially released (for MRP)
52	DNREL	☐	CO_DNREL	CHAR1	CHAR	1	0	Indicator: Order item not relevant for MRP
53	VERTO	☐	SA_VERTL	SA_VERTL	CHAR	4	0	MRP Distribution Key	T437V
54	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
55	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
56	WEWRT	☐	WEWRT	WERT7	CURR	13	2	Value of goods received in local currency
57	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
58	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
59	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
60	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
61	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
62	WEAED	☐	CO_WEAE	XFELD	CHAR	1	0	Indicator: Goods receipt indicator can be changed
63	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
64	KBNKZ	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
65	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
66	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
67	KRSNR	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
68	KRSPS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
69	KCKEY	☐	CCKEY	CCKEY	CHAR	23	0	Cost collector key
70	RTP01	☐	RTP01	XFELD	CHAR	1	0	Cost collector for repetitive manufacturing
71	RTP02	☐	RTP02	XFELD	CHAR	1	0	Cost collector for KANBAN
72	RTP03	☐	RTP03	XFELD	CHAR	1	0	Cost collector for valuated sales order stock
73	RTP04	☐	RTP04	XFELD	CHAR	1	0	Cost collector for external PPC
74	KSVON	☐	KSVON	DATUM	DATS	8	0	Cost collector valid from
75	KSBIS	☐	KSBIS	DATUM	DATS	8	0	Cost collector valid to
76	OBJNP	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
77	NDISR	☐	CO_NDISR	CHAR1	CHAR	1	0	Ind.: Material in order item is not relevant for MRP
78	VFMNG	☐	CO_VFMNG	MENG13	QUAN	13	3	Committed quantity for order acc. to ATP check components
79	GSBTR	☐	CO_GSBTR	DATUM	DATS	8	0	Overall commitment date
80	KZAVC	☐	KZAVC	KZAVC	CHAR	1	0	Indicator for type of availability check
81	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
82	XLOEK	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
83	SERNP	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	T377P
84	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
85	OBJTYPE	☐	OCM_OBJ_TYPE	OCM_OBJ_TYPE	CHAR	1	0	Change indicator
86	CH_PROC	☐	OCM_CH_PROC	OCM_CH_PROC	CHAR	1	0	Process that has lead to the change of an object
87	FXPRU	☐	CK_FIXPRKU	XFELD	CHAR	1	0	Fixed-Price Co-Product
88	CUOBJ_ROOT	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
89	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	*
90	TECHS_COPY	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
91	.INCLUDE	☐				0	0	TREX Administration Data
92	LOAD_UNAME	☐	LOAD_UNAME	UNAME	CHAR	12	0	User Who Loaded Data in TREX-Based Cache
93	LOAD_DATE	☐	LOAD_DATE		DATS	8	0	Date on Which Data Was Cached in TREX-Based Cache
94	EXPIRY_DATE	☐	PS_EXPIRY_DATE		DATS	8	0	Date from Which Cached Data Is Invalid

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PSHLP_TREX_AFPO_ST	AMEIN	T006	MSEHI	REF	C	CN
2	PSHLP_TREX_AFPO_ST	BWTAR	T149D	BWTAR	REF	C	CN
3	PSHLP_TREX_AFPO_ST	BWTTY	T149C	BWTTY	REF	C	CN
4	PSHLP_TREX_AFPO_ST	CHARG	MCHA	CHARG	REF	C	CN
5	PSHLP_TREX_AFPO_ST	DAUAT	T003O	AUART	REF	1	CN
6	PSHLP_TREX_AFPO_ST	DWERK	T001W	WERKS	REF	1	CN
7	PSHLP_TREX_AFPO_ST	GSBER	TGSB	GSBER	REF	C	CN
8	PSHLP_TREX_AFPO_ST	KDAUF	VBUK	VBELN
9	PSHLP_TREX_AFPO_ST	KNTTP	T163K	KNTTP	KEY	1	CN
10	PSHLP_TREX_AFPO_ST	LGORT	T001L	LGORT	REF	C	CN
11	PSHLP_TREX_AFPO_ST	MATNR	MARA	MATNR	REF	1	CN
12	PSHLP_TREX_AFPO_ST	MEINS	T006	MSEHI	REF	1	CN
13	PSHLP_TREX_AFPO_ST	PROJN	PRPS	PSPNR	REF	C	CN
14	PSHLP_TREX_AFPO_ST	PWERK	T001W	WERKS	REF	C	CN
15	PSHLP_TREX_AFPO_ST	SERNP	T377P	SERAIL
16	PSHLP_TREX_AFPO_ST	SERNR	SNUM	SERNR
17	PSHLP_TREX_AFPO_ST	SOBKZ	T148	SOBKZ	REF	C	CN
18	PSHLP_TREX_AFPO_ST	VERTO	T437V	VERTL	REF	C	CN

History

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