SAP ABAP Table /ISDFPS/NOUPS_HEADER (DFPS: Notification Header - 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/NOUPS_HEADER	Table Relationship Diagram
Short Description	DFPS: Notification Header - 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	NOTIF_NO	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
2	PLANPLANT	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
3	LOC_ACC	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	*
4	EQUIPMENT	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
5	EQUIPMENT_DESC	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
6	EQUIPMENT_CREATE	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
7	ASSEMBLY	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
8	ASSEMBLY_DESC	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
9	BREAKDOWN	☐	MSAUS	XFELD	CHAR	1	0	Breakdown Indicator
10	STRMLFNDATE	☐	AUSVN	DATUM	DATS	8	0	Start of Malfunction (Date)
11	ENDMLFNDATE	☐	AUSBS	DATUM	DATS	8	0	End of Malfunction (Date)
12	STRMLFNTIME	☐	AUZTV	UHRZT	TIMS	6	0	Start of Malfunction (Time)
13	ENDMLFNTIME	☐	AUZTB	UHRZT	TIMS	6	0	End of Malfunction (Time)
14	DOWNTIME	☐	AUSZT	FLTP	FLTP	16	16	Breakdown Duration
15	UNIT	☐	MAUEH	MEINS	UNIT	3	0	Unit for Breakdown Duration	T006
16	ISOCODE_UNIT	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
17	PLANGROUP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
18	MNTPLAN	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
19	MNTCALL_NO	☐	ABNUM	ABNUM	INT4	10	0	Maintenance Plan Call Number
20	MAINTITEM	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item	MPOS
21	NOTIF_TYPE	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
22	SHORT_TEXT	☐	QMTXT	TEXT40	CHAR	40	0	Short Text
23	PRIOTYPE	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
24	PRIORITY	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
25	NOTIFTIME	☐	MZEIT	UHRZT	TIMS	6	0	Notification Time
26	NOTIF_DATE	☐	QMDAT	DATUM	DATS	8	0	Date of Notification
27	REPORTEDBY	☐	QMNAM	USNAM	CHAR	12	0	Name of declarant
28	DESSTDATE	☐	STRMN	DATUM	DATS	8	0	Desired Start Date
29	DESSTTIME	☐	STRUR	UZEIT	TIMS	6	0	Desired Start Time
30	DESENDDATE	☐	LTRMN	DATUM	DATS	8	0	Required Finish Date
31	DESENDTM	☐	LTRUR	UZEIT	TIMS	6	0	Required End Date-Time
32	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
33	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
34	MATL_DESC	☐	MAKTX	TEXT40	CHAR	40	0	Material description
35	CUST_NO	☐	QKUNUM	KUNNR	CHAR	10	0	Account Number of Customer	KNA1
36	OBJECT_NO	☐	QMOBJNR	J_OBJNR	CHAR	22	0	Object Number for Status Management	ONR00
37	COMPDATE	☐	QMDAB	DATUM	DATS	8	0	Date for Completion of Notification
38	COMPTIME	☐	QMZAB	UZEIT	TIMS	6	0	Completion Time of Notification
39	CATPROFILE	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
40	LONG_TEXT	☐	INDLTX	CHAR1	CHAR	1	0	Object Long Text Available
41	PRILANG	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
42	REFDATE	☐	BEZDT	DATUM	DATS	8	0	Notification Reference Date
43	REFTIME	☐	BEZUR_D	UZEIT	TIMS	6	0	Notification Reference Time
44	SALES_ORD	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
45	PURCH_NO_C	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
46	PURCH_DATE	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
47	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	TSPA
48	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
49	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
50	ADDR_NUMBER	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
51	CAT_TYPE	☐	QMKAT	QKATART	CHAR	1	0	Catalog type - coding	TQ15
52	CODE_GROUP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	QPGR
53	CODING	☐	QMCOD	QCODE	CHAR	4	0	Coding	QPCD
54	PM_WKCTR	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
55	SERIALNO	☐	GERNR	GERNR	CHAR	18	0	Serial Number
56	DELETE_FLAG	☐	KZLOESCH	CHAR1	CHAR	1	0	Delete Data Record
57	DEVICEDATA	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
58	SALES_OFFICE	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
59	SALES_GRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
60	NOTIFTMEZ	☐	TZONSO	TZNZONE	CHAR	6	0	Time zone for notification	TTZZ
61	FUNCT_LOC	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
62	FUNCLOC_DISP	☐	ILOM_STRNO	ILOM_STRNO	CHAR	40	0	Functional location label
63	FUNCLOC_DESC	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
64	FUNCLOC_CREATE	☐	ILOM_STRNO	ILOM_STRNO	CHAR	40	0	Functional location label
65	ABCINDIC	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
66	SORTFIELD	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
67	MAINTPLANT	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
68	MAINTLOC	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
69	MAINTROOM	☐	RAUMNR	CHAR8	CHAR	8	0	Room
70	PLSECTN	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
71	PP_WKCTR	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	CRID
72	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
73	CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
74	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
75	WBS_ELEMENT	☐	PM_POSID_HEADER	PS_POSID	CHAR	24	0	Work breakdown structure element (WBS element) order header
76	ASSET_NO	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
77	SUB_NUMBER	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
78	STDGORD	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
79	STLMTORDER	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	AUFK
80	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
81	SALES_ORG_LOC_ACC	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
82	DIVISION_LOC_ACC	☐	SPART	SPART	CHAR	2	0	Division	TSPA
83	DIST_CHAN_LOC_ACC	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
84	ADDR_NO_LOC_ACC	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
85	DOC_NUMBER	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
86	ITM_NUMBER	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
87	SCENARIO	☐	QAUSWIRK	QAUSWIRK	CHAR	4	0	Effect of Notification	*
88	REFOBJECTTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
89	REFOBJECTKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
90	REFRELTYPE	☐	BINRELTYP	BINRELTYP	CHAR	4	0	Relationship type	*
91	XA_STAT_PROF	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
92	MN_WK_CTR	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
93	PLANT	☐	WERGW	WERKS	CHAR	4	0	Plant associated with main work center	*
94	/ISDFPS/OBJECT_NO	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
95	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
96	/ISDFPS/MEQUI	☐	/ISDFPS/MEQUI	EQUNR	CHAR	18	0	Master Equipment	*
97	BTPLN	☐	BTPLN	TPLNR	CHAR	30	0	Functional Location Affected	*
98	BEQUI	☐	BEQUI	EQUNR	CHAR	18	0	Equipment Affected	*
99	REVNR	☐	REVNI	REVNI	CHAR	8	0	Revision of Plant Maintenance and Customer Service	*
100	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	*
101	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
102	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ISDFPS/NOUPS_HEADER	ABCINDIC	T370C	ABCKZ	REF
2	/ISDFPS/NOUPS_HEADER	ASSEMBLY	MARA	MATNR
3	/ISDFPS/NOUPS_HEADER	ASSET_NO	ANLH	ANLN1	REF
4	/ISDFPS/NOUPS_HEADER	BUS_AREA	TGSB	GSBER	REF
5	/ISDFPS/NOUPS_HEADER	CATPROFILE	T352B	RBNR	REF
6	/ISDFPS/NOUPS_HEADER	CAT_TYPE	TQ15	KATALOGART	REF
7	/ISDFPS/NOUPS_HEADER	CODE_GROUP	QPGR	CODEGRUPPE	REF
8	/ISDFPS/NOUPS_HEADER	CODING	QPCD	CODE
9	/ISDFPS/NOUPS_HEADER	COMP_CODE	T001	BUKRS
10	/ISDFPS/NOUPS_HEADER	COSTCENTER	CSKS	KOSTL	REF
11	/ISDFPS/NOUPS_HEADER	CO_AREA	TKA01	KOKRS	REF
12	/ISDFPS/NOUPS_HEADER	CUST_NO	KNA1	KUNNR	REF
13	/ISDFPS/NOUPS_HEADER	DISTR_CHAN	TVTW	VTWEG	REF
14	/ISDFPS/NOUPS_HEADER	DIST_CHAN_LOC_ACC	TVTW	VTWEG	REF
15	/ISDFPS/NOUPS_HEADER	DIVISION	TSPA	SPART	REF
16	/ISDFPS/NOUPS_HEADER	DIVISION_LOC_ACC	TSPA	SPART	REF
17	/ISDFPS/NOUPS_HEADER	DOC_NUMBER	VBUK	VBELN	REF
18	/ISDFPS/NOUPS_HEADER	EQUIPMENT	EQUI	EQUNR	REF
19	/ISDFPS/NOUPS_HEADER	FUNCT_LOC	IFLOT	TPLNR	REF
20	/ISDFPS/NOUPS_HEADER	ITM_NUMBER	VBUP	POSNR	REF
21	/ISDFPS/NOUPS_HEADER	MAINTITEM	MPOS	WAPOS	REF
22	/ISDFPS/NOUPS_HEADER	MAINTLOC	T499S	STAND	REF
23	/ISDFPS/NOUPS_HEADER	MAINTPLANT	T001W	WERKS	REF
24	/ISDFPS/NOUPS_HEADER	MATERIAL	MARA	MATNR	REF
25	/ISDFPS/NOUPS_HEADER	MNTPLAN	MPLA	WARPL	REF
26	/ISDFPS/NOUPS_HEADER	NOTIFTMEZ	TTZZ	TZONE	REF
27	/ISDFPS/NOUPS_HEADER	NOTIF_TYPE	TQ80	QMART	REF
28	/ISDFPS/NOUPS_HEADER	OBJECT_NO	ONR00	OBJNR	REF
29	/ISDFPS/NOUPS_HEADER	ORDERID	AUFK	AUFNR	REF
30	/ISDFPS/NOUPS_HEADER	PLANGROUP	T024I	INGRP	REF
31	/ISDFPS/NOUPS_HEADER	PLANPLANT	T399I	IWERK	REF
32	/ISDFPS/NOUPS_HEADER	PLSECTN	T357	BEBER	REF
33	/ISDFPS/NOUPS_HEADER	PM_WKCTR	CRID	OBJID	REF
34	/ISDFPS/NOUPS_HEADER	PP_WKCTR	CRID	OBJID	REF
35	/ISDFPS/NOUPS_HEADER	PRIORITY	T356	PRIOK	REF
36	/ISDFPS/NOUPS_HEADER	PRIOTYPE	T356A	ARTPR	REF
37	/ISDFPS/NOUPS_HEADER	SALES_GRP	TVKGR	VKGRP	REF
38	/ISDFPS/NOUPS_HEADER	SALES_OFFICE	TVBUR	VKBUR	REF
39	/ISDFPS/NOUPS_HEADER	SALES_ORD	VBUK	VBELN	REF
40	/ISDFPS/NOUPS_HEADER	SALES_ORG	TVKO	VKORG	REF
41	/ISDFPS/NOUPS_HEADER	SALES_ORG_LOC_ACC	TVKO	VKORG	REF
42	/ISDFPS/NOUPS_HEADER	STDGORD	AUFK	AUFNR	REF
43	/ISDFPS/NOUPS_HEADER	STLMTORDER	AUFK	AUFNR	REF
44	/ISDFPS/NOUPS_HEADER	SUB_NUMBER	ANLA	ANLN2	REF
45	/ISDFPS/NOUPS_HEADER	UNIT	T006	MSEHI

History

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