SAP ABAP Table PSHLP_TREX_AFFL_ST (Work order sequence)

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_AFFL_ST	Table Relationship Diagram
Short Description	Work order sequence

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	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
2	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
3	.INCLUDE	☐				0	0	Work order sequence (Include structure)
4	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
5	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
6	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
7	PLNFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
8	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
9	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
10	FLGAT	☐	FOLGENART	FLGAT	CHAR	1	0	Sequence category	TCA07
11	BEZFL	☐	BEZFL	PLNFOLGE	CHAR	6	0	Reference sequence for a sequence
12	BKNT1	☐	BEZKNTANF	KNTNR	NUMC	8	0	Reference node for start of a sequence
13	BKNT2	☐	BEZKNTEND	KNTNR	NUMC	8	0	Finish reference node of a sequence
14	LTXA1	☐	FLGTEXT	TEXT40	CHAR	40	0	Sequence description
15	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
16	LOSVN	☐	CP_FLGLOSV	MENG13	QUAN	13	3	From lot size
17	LOSBS	☐	CP_FLGLOSB	MENG13	QUAN	13	3	To lot size
18	BSCHL1	☐	CP_BSCHL1	CP_TSCHL	CHAR	1	0	Relationship key for branch operation of parallel sequences	TCA50
19	BSCHL2	☐	CP_BSCHL2	CP_TSCHL	CHAR	1	0	Relationship key for return operation of parallel sequences	TCA50
20	AUSCHL	☐	CP_AUSCHL	CP_AUSSCHL	CHAR	1	0	Alignment key for scheduling	TCA52
21	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
22	OBJTYPE	☐	OCM_OBJ_TYPE	OCM_OBJ_TYPE	CHAR	1	0	Change indicator
23	CH_PROC	☐	OCM_CH_PROC	OCM_CH_PROC	CHAR	1	0	Process that has lead to the change of an object
24	.INCLUDE	☐				0	0	TREX Administration Data
25	LOAD_UNAME	☐	LOAD_UNAME	UNAME	CHAR	12	0	User Who Loaded Data in TREX-Based Cache
26	LOAD_DATE	☐	LOAD_DATE		DATS	8	0	Date on Which Data Was Cached in TREX-Based Cache
27	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_AFFL_ST	AENNR	AENR	AENNR	REF	1	CN
2	PSHLP_TREX_AFFL_ST	AUSCHL	TCA52	AUSCHL	REF	C	CN
3	PSHLP_TREX_AFFL_ST	BSCHL1	TCA50	TSCHL	REF	C	CN
4	PSHLP_TREX_AFFL_ST	BSCHL2	TCA50	TSCHL	REF	C	CN
5	PSHLP_TREX_AFFL_ST	FLGAT	TCA07	FLGAT
6	PSHLP_TREX_AFFL_ST	OBJNR	ONR00	OBJNR	REF	C	1
7	PSHLP_TREX_AFFL_ST	PLNTY	TCA01	PLNTY	REF	1	CN
8	PSHLP_TREX_AFFL_ST	TXTSP	T002	SPRAS	REF	C	CN

History

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