SAP ABAP Table /ISDFPS/TLUPS_PLMK (DFPS: Inspection Plan Characteristics - UPS Distribution)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-PDR (Application Component) Master Data Distribution
     ⤷ /ISDFPS/UPS_EXTENSIONS_ASSET (Package) Asset Objects in UPS

Basic Data

Table Category	INTTAB	Structure
Structure	/ISDFPS/TLUPS_PLMK	Table Relationship Diagram
Short Description	DFPS: Inspection Plan Characteristics - UPS Distribution

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	Inspection plan characteristics
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	*
4	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
5	PLNKN	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
6	KZEINSTELL	☐	QKZEINSTMK	QKZEINSTMK	CHAR	1	0	Characteristic Type
7	MERKNR	☐	QMERKNRP	QMERKNRP	NUMC	4	0	Inspection Characteristic Number
8	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
9	GUELTIGAB	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
10	SERNV	☐	TECHV	TECHS	CHAR	12	0	Technical status from
11	LOEKZ	☐	LKENZ	XFELD	CHAR	1	0	Deletion Indicator
12	PARKZ	☐	PARKZ	XFELD	CHAR	1	0	Indicator: inactive changes
13	AENDERGNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	*
14	ERSTELLER	☐	ANNAM	USNAM	CHAR	12	0	User Who Created Record
15	ERSTELLDAT	☐	ANDAT	DATUM	DATS	8	0	Date Record Created on
16	AENDERER	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
17	AENDERDAT	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
18	STEUERKZ	☐	QMKCONTROL	QMKCONTROL	CHAR	30	0	Cntrl Indicator String for Insp. Char./Master Insp. Char.
19	QMTB_WERKS	☐	Q_METH_PLANT	WERKS	CHAR	4	0	Plant for Inspection Method	T001W
20	PMETHODE	☐	QPMETHODE	QPMETHODE	CHAR	8	0	Inspection Method	QMTB
21	PMTVERSION	☐	QVERSNRPM	QVERSNR	CHAR	6	0	Version Number of the Inspection Method
22	QPMK_REF	☐	QKZ_REF	QKZ	CHAR	1	0	Reference to Master Insp. Characteristic in Task List
23	QPMK_ZAEHL	☐	QZAEHLER	QZAEHLER	CHAR	4	0	Plant for the Master Inspection Characteristic
24	VERWMERKM	☐	QMERKNR	QMERKNR	CHAR	8	0	Master Inspection Characteristics	QPMK
25	MKVERSION	☐	QVERSNRMK	QVERSNR	CHAR	6	0	Version Number of the Master Inspection Characteristic
26	MKVERSDAT	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
27	MERKGEW	☐	QMERKGEW	QMERKKLAS	CHAR	2	0	Weighting of the Characteristic	TQ17A
28	PROBENR	☐	QPROBEPL	QPROBEPL	NUMC	3	0	Partial Sample No. for Inspection Charac. in Task List
29	PRUEFQUALI	☐	QPRQUALIF	QPRQUALIF	CHAR	5	0	Inspector Qualification	TQ11
30	TOLERANZSL	☐	QTOLERANZ	QTOLERANZ	CHAR	4	0	Tolerance Key	TQ29
31	KURZTEXT	☐	QTXT_CHA	QKURZTEXT	CHAR	40	0	Short Text for Inspection Characteristic
32	LTEXTKZ	☐	QLTEXTKZ	QKZ	CHAR	1	0	Inspection Characteristic Long Text Exists
33	LTEXTSPR	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
34	LTEXTEKZ	☐	QKZPRZIEH	QKZWSP	CHAR	1	0	Physical-Sample-Drawing Text Exists
35	LTXTENTSPR	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
36	STELLEN	☐	QSTELLEN	QSTELLEN	INT1	3	0	Number of Places to the Right of a Decimal Point (Accuracy)
37	MASSEINHSW	☐	QMASSEH	MEINS	UNIT	3	0	Unit of Measurement, in Which Quantitative Data Is Stored	T006
38	.INCLUDE	☐				0	0	Quantitative data for the inspection characteristic
39	SOLLWERT	☐	QSOLLWERTE	QSOLLWERTE	FLTP	16	16	Target Value for a Quantitative Characteristic
40	SOLLWNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
41	TOLERANZOB	☐	QTOLOB	QSOLLWERTE	FLTP	16	16	Upper Specification Limit
42	TOLOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
43	TOLERANZUN	☐	QTOLUN	QSOLLWERTE	FLTP	16	16	Lower Tolerance Limit
44	TOLUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
45	KLASANZAHL	☐	QKLASSZAHL	QKLASSZAHL	INT1	3	0	Number of Value Classes for Inspection Results
46	KLASBREITE	☐	QKLASSBR	QSOLLWERTE	FLTP	16	16	Class Width
47	KLASBRNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
48	KLASMITTE	☐	QKLASSMIT	QSOLLWERTE	FLTP	16	16	Class Midpoint
49	KLASMINI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
50	GRENZEOB1	☐	QGRENZOB1	QSOLLWERTE	FLTP	16	16	First Upper Specification Limit
51	GRENZOB1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
52	GRENZEUN1	☐	QGRENZUN1	QSOLLWERTE	FLTP	16	16	First Lower Specification Limit
53	GRENZUN1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
54	GRENZEOB2	☐	QGRENZOB2	QSOLLWERTE	FLTP	16	16	Second Upper Specification Limit
55	GRENZOB2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
56	GRENZEUN2	☐	QGRENZUN2	QSOLLWERTE	FLTP	16	16	Second Lower Specification Limit
57	GRENZUN2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
58	PLAUSIOBEN	☐	QPLAUSIOB	QSOLLWERTE	FLTP	16	16	Upper Plausibility Limit
59	PLAUSIOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
60	PLAUSIUNTE	☐	QPLAUSIUN	QSOLLWERTE	FLTP	16	16	Lower Plausibility Limit
61	PLAUSIUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
62	TOLERWEIOB	☐	QTOLWOB	QSOLLWERTE	FLTP	16	16	Change to Upper Specification Limit
63	TOLWOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
64	TOLERWEIUN	☐	QTOLWUN	QSOLLWERTE	FLTP	16	16	Change to Lower Specification Limit
65	TOLWUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
66	TOLERWAB	☐	QTOLWAB	DATUM	DATS	8	0	Date from Which the Tolerance Change Is Valid
67	TOLERWBIS	☐	QTOLWBIS	DATUM	DATS	8	0	Date Until Which the Tolerance Change Is Valid
68	STICHPRVER	☐	QSTICHVERF	QSTPRVER	CHAR	8	0	Sampling Procedure in Inspection Characteristic	*
69	FAKPLANME	☐	QUMREN	QUMRENFAK	FLTP	16	16	Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure
70	FAKPROBME	☐	QUMRENPME	QUMRENFAK	FLTP	16	16	Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure
71	PROBEMGEH	☐	QPROBME	MEINS	UNIT	3	0	Sample Unit of Measure	T006
72	PRUEFEINH	☐	QPROBEFAK	QPROBEFAK	DEC	5	2	Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.)
73	DYNKRIT	☐	QDYNSTRING	QDYNSTRING	CHAR	10	0	String for Dynamic Modification Criteria (Database Relevant)
74	FORMELSL	☐	QFORMELSL	QFORMELSL	CHAR	1	0	Check and Calculate Formula in QM
75	FORMEL1	☐	QFORMEL	QFORMEL	CHAR	60	0	Formula Field
76	FORMEL2	☐	QFORMEL	QFORMEL	CHAR	60	0	Formula Field
77	CODEGR9U	☐	QCODEGRPU	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Lower Tolerance	*
78	CODE9U	☐	QCODEU	QCODE	CHAR	4	0	Defect Code for Rejection at Lower Specification Limit	*
79	CODEVR9U	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
80	CODEGR9O	☐	QCODEGRPO	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Upper Tolerance	*
81	CODE9O	☐	QCODEO	QCODE	CHAR	4	0	Defect Code for Rejection at Upper Specification Limit	*
82	CODEVR9O	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
83	KATAB1	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
84	KATALGART1	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
85	AUSWMENGE1	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
86	AUSWMGWRK1	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
87	AUSWVERS1	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
88	AUSWDAT1	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
89	KATAB2	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
90	KATALGART2	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
91	AUSWMENGE2	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
92	AUSWMGWRK2	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
93	AUSWVERS2	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
94	AUSWDAT2	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
95	KATAB3	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
96	KATALGART3	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
97	AUSWMENGE3	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
98	AUSWMGWRK3	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
99	AUSWVERS3	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
100	AUSWDAT3	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
101	KATAB4	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
102	KATALGART4	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
103	AUSWMENGE4	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
104	AUSWMGWRK4	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
105	AUSWVERS4	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
106	AUSWDAT4	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
107	KATAB5	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
108	KATALGART5	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
109	AUSWMENGE5	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
110	AUSWMGWRK5	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
111	AUSWVERS5	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
112	AUSWDAT5	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
113	DUMMY10	☐	QTXT10	QTXT10	CHAR	10	0	Text Line for Additional Information
114	DUMMY20	☐	QTXT20	QTXT20	CHAR	20	0	Text Line for Additional Information
115	DUMMY40	☐	QTXT40	QTXT40	CHAR	40	0	Text Line for Additional Information
116	CHARACT_ID1	☐	QCHARACT_ID1	QCHARACT_ID	CHAR	40	0	Characteristic Description for Quality Data Exchange
117	QERGDATH	☐	QERGDATHPL	QERGDATH	CHAR	2	0	Planned Results Data Origin	TQ73
118	EEANTVERF	☐	QEANTVERF	QEANTVERF	CHAR	2	0	Fraction Calculation	TQ72
119	QDYNREGEL	☐	QDYNREGEL	QDYNREGEL	CHAR	3	0	Dynamic Modification Rule	QDDR
120	DYNMERKREF	☐	QMERKDYN	QMERKNRP	NUMC	4	0	Characteristic (in Plan) whose Q-Level Will Be Copied
121	PZLFH	☐	QPZLFH	PZLFH	NUMC	8	0	Assigned Test Equipment
122	CODEGRQUAL	☐	QCODEGRPQL	QCODEGRP	CHAR	8	0	Defect Code Group for General Rejection	*
123	CODEQUAL	☐	QCODEQL	QCODE	CHAR	4	0	Defect Code for Rejection: General	*
124	SPCKRIT	☐	QSPCKRIT	QSPCKRIT	CHAR	3	0	SPC Criterion	QPSP
125	.INCLUDE	☐				0	0
126	INPPROC	☐	QINPPROC	CHAR3	CHAR	3	0	Parameters for Input Processing in QM Results Recording	TQ71
127	RES_PLAN	☐	QP_RESPLAN	QP_RESPLAN	CHAR	3	0	Response Plan	TQPC_RESPLAN
128	CTRMETH	☐	QP_CTRMETH	QP_CTRMETH	CHAR	3	0	Control Method	TQPC_CTRMETH
129	CHAORIG	☐	QP_CHAORIG	QP_CHAORIG	CHAR	3	0	Inspection Characteristic Origin	TQPC_CHAORIG
130	CHAORIG_GUID	☐	QP_CHAORIG_GUID	PLM_AUDIT_GUID_AUD	RAW	16	0	Reference to Characteristic That Was Adopted
131	NO_INSPECTION	☐	QP_NO_INSPECTION	QKZ	CHAR	1	0	Do Not Copy Inspection Characteristic to Inspection Lot
132	QP_CHAORIG_ID	☐	QMIP_CHAORIG_ID	QMIP_CHAORIG_ID	CHAR	40	0	Original Identification for Characteristic

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ISDFPS/TLUPS_PLMK	AUSWMGWRK1	T001W	WERKS	REF	C	CN
2	/ISDFPS/TLUPS_PLMK	AUSWMGWRK2	T001W	WERKS	REF	C	CN
3	/ISDFPS/TLUPS_PLMK	AUSWMGWRK3	T001W	WERKS	REF	C	CN
4	/ISDFPS/TLUPS_PLMK	AUSWMGWRK4	T001W	WERKS	REF	C	CN
5	/ISDFPS/TLUPS_PLMK	AUSWMGWRK5	T001W	WERKS	REF	C	CN
6	/ISDFPS/TLUPS_PLMK	CHAORIG	TQPC_CHAORIG	CHAORIG
7	/ISDFPS/TLUPS_PLMK	CTRMETH	TQPC_CTRMETH	CTRMETH
8	/ISDFPS/TLUPS_PLMK	EEANTVERF	TQ72	ANTVERF	REF	C	CN
9	/ISDFPS/TLUPS_PLMK	INPPROC	TQ71	INPPROC
10	/ISDFPS/TLUPS_PLMK	KATALGART1	TQ15	KATALOGART	REF	C	CN
11	/ISDFPS/TLUPS_PLMK	KATALGART2	TQ15	KATALOGART	REF	C	CN
12	/ISDFPS/TLUPS_PLMK	KATALGART3	TQ15	KATALOGART	REF	C	CN
13	/ISDFPS/TLUPS_PLMK	KATALGART4	TQ15	KATALOGART	REF	C	CN
14	/ISDFPS/TLUPS_PLMK	KATALGART5	TQ15	KATALOGART	REF	C	CN
15	/ISDFPS/TLUPS_PLMK	MASSEINHSW	T006	MSEHI	REF	C	CN
16	/ISDFPS/TLUPS_PLMK	MERKGEW	TQ17A	MERKKLASSE	REF	C	CN
17	/ISDFPS/TLUPS_PLMK	PMETHODE	QMTB	PMTNR
18	/ISDFPS/TLUPS_PLMK	PROBEMGEH	T006	MSEHI	REF	C	N
19	/ISDFPS/TLUPS_PLMK	PRUEFQUALI	TQ11	PRFQL	REF	C	CN
20	/ISDFPS/TLUPS_PLMK	QDYNREGEL	QDDR	DYNREGEL	REF	C	CN
21	/ISDFPS/TLUPS_PLMK	QERGDATH	TQ73	QERGDATH
22	/ISDFPS/TLUPS_PLMK	QMTB_WERKS	T001W	WERKS	REF	C	N
23	/ISDFPS/TLUPS_PLMK	RES_PLAN	TQPC_RESPLAN	RES_PLAN
24	/ISDFPS/TLUPS_PLMK	SPCKRIT	QPSP	SPCKRIT	REF	C	CN
25	/ISDFPS/TLUPS_PLMK	TOLERANZSL	TQ29	TOLERANZSL	REF	C	CN
26	/ISDFPS/TLUPS_PLMK	VERWMERKM	QPMK	MKMNR

History

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