SAP ABAP Table PAD25_QUE (Structure for Additional Data in Query)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ PE (Application Component) Training and Event Management
     ⤷ PP09 (Package) Training and Event Management

Basic Data

Table Category	INTTAB	Structure
Structure	PAD25_QUE	Table Relationship Diagram
Short Description	Structure for Additional Data in Query

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
3	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
4	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
5	IT0_INFTY	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype
6	IT0_SUBTY	☐	SUBTYP	SUBTYP	CHAR	4	0	Subtype	*
7	IT0_ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	*
8	IT0_PRIOX	☐	PRIOX	CHAR2	CHAR	2	0	Priority
9	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
10	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
11	IT0_LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	*
12	IT0_SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
13	IT0_AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
14	IT0_UNAME	☐	USRNAME	CHAR12	CHAR	12	0	User Name
15	IT0_REASN	☐	REASN	CHAR2	CHAR	2	0	Reason
16	IT0_HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
17	IT0_ITXNR	☐	ITXNR	NUM08	NUMC	8	0	Text Module for Infotype
18	SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
19	STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
20	GDATE	☐	GDATE	DATUM	DATS	8	0	Delimitation date
21	IT1_RSIGN	☐	RSIGN	RSIGN	CHAR	1	0	Relationship Specification
22	IT1_RELAT	☐	RELAT	RELAT	CHAR	3	0	Relationship Between Objects	*
23	IT1_ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	*
24	IT1_PRIOX	☐	PRIOX	CHAR2	CHAR	2	0	Priority
25	IT1_BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
26	IT1_ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
27	IT1_AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
28	IT1_UNAME	☐	USRNAME	CHAR12	CHAR	12	0	User Name
29	IT1_REASN	☐	REASN	CHAR2	CHAR	2	0	Reason
30	IT1_HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
31	IT1_ITXNR	☐	ITXNR	NUM08	NUMC	8	0	Text Module for Infotype
32	IT1_SCLAS	☐	SCLAS	OTYPE	CHAR	2	0	Type of Related Object	*
33	IT1_SOBID	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
34	IT1_PROZT	☐	PROZT	DEC3_2	DEC	5	2	Weighting Percentage
35	.INCLU-_X	☐				0	0	Additional Data for Relationship "Takes Part In"
36	TPARTDOCNO_X	☐	PARTIC_TPARTDOCNO	BELNR	CHAR	10	0	Course Participation - Document
37	MANZL_X	☐	BMANZL	DEC3	DEC	3	0	Number of attendances
38	BUDAT_X	☐	PBUDAT	DATUM	DATS	8	0	Booking date
39	INTEX_X	☐	INTEX	CHAR1	CHAR	1	0	Indicator for internal/external bus.event costs transferred
40	KKOST_X	☐	KKOST	CURR16	CURR	16	2	Attendance or cancellation fee
41	KWAER_X	☐	EXWAER	WAERS	CUKY	5	0	Currency key for fees	TCURC
42	KOKRS_X	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
43	KOSTL_X	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
44	ZDATA_X	☐	DZDATA	CHAR50	CHAR	50	0	Variable end-user field
45	BELNR_X	☐	PBELNR	CHAR10	CHAR	10	0	Document number
46	CONFIRMED_X	☐	PARTICCONF	PARTICCONF	CHAR	1	0	Participation Confirmed
47	PASSED_X	☐	PARTIC_PASSED	PARTIC_PASSED	CHAR	1	0	Course Passed
48	FAILED_X	☐	LSO_FAILED	LSO_FAILED_REASON	NUMC	4	0	Reason for Course Failed	T77FAR
49	FOLLOW_UP_X	☐	PARTIC_FOLLOWUP	PARTIC_FOLLOWUP	CHAR	1	0	Participation Was Followed Up
50	CAATR_X	☐	CAATR	CAATR	NUMC	4	0	Key: reason for attendance cancellation	T77CAR
51	PREVSCLAS_X	☐	SCLAS	OTYPE	CHAR	2	0	Type of Related Object	*
52	PREVSOBID_X	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
53	EVENT_X	☐	HRV_EVENT	HRV_EVENT	CHAR	1	0	Document Operation
54	STATUS_X	☐	HRV_STATUS	HRV_STATUS	CHAR	1	0	Status of Document Operation
55	REFDOCNO_X	☐	PECO_REFBN	BELNR	CHAR	10	0	Reference Document Number
56	REFDOCITEM_X	☐	PEHRAABPOS	NUM3	NUMC	3	0	Document Item
57	DOCUMENTDATE_X	☐	PECO_BLDAT	DATUM	DATS	8	0	Document Date
58	POSTINGDATE_X	☐	PECO_BUDAT	DATUM	DATS	8	0	Booking Date
59	DOCUNAME_X	☐	PEUNAME	UNAME	CHAR	12	0	User Name
60	CREDITBELNR_X	☐	PBELNR	CHAR10	CHAR	10	0	Document number
61	CREDITSTATUS_X	☐	HRV_STATUS	HRV_STATUS	CHAR	1	0	Status of Document Operation
62	SCOSTCENTER_X	☐	PESKOST	KOSTL	CHAR	10	0	Sender Cost Center	*
63	RECEIVEORDER_X	☐	PEEAUFNR	AUFNR	CHAR	12	0	Receiving Order	*
64	RSALESORDER_X	☐	PEEKDAU	VBELN	CHAR	10	0	Receiver Sales Order	*
65	RSALESITEM_X	☐	PEEKDPO	POSNR	NUMC	6	0	Item Number in Receiver Sales Order	*
66	ACTIVITYTYPE_X	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
67	QUANTITY_X	☐	PEMBGXXX	MENGV8	QUAN	15	3	Total Quantity Entered
68	UNIT_X	☐	PEMEINB	MEINS	UNIT	3	0	Posted Unit of Measure	*
69	SOLD_TO_X	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
70	BILL_TO_X	☐	PEKUNRE	KUNNR	CHAR	10	0	Bill-To Party	*
71	PAYER_X	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
72	SHIP_TO_X	☐	PEKUNWE	KUNNR	CHAR	10	0	Ship-To Party	*
73	NET_PRICE_X	☐	NETKOST	CURR16	CURR	16	2	Net value of attendance fees
74	TAX_PRICE_X	☐	TAXKOST	CURR16	CURR	16	2	Tax amount for attendance fees
75	PURCH_ORDER_X	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
76	CC_TYPE_X	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
77	CC_NUMBER_X	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
78	CC_VALID_TO_X	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
79	CC_NAME_X	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
80	RWBSELEMENT_X	☐	E_PS_POSID	PS_POSID	CHAR	24	0	Receiver work breakdown structure element (WBS element)
81	PAY_STATUS_X	☐	HRV_PAY_STATUS	HRV_PAY_STATUS	CHAR	1	0	Payment Status Billing
82	CC_NUMBER_CHECK_X	☐	HRV_CC_NUMBER_CHECK	HRV_CC_NUMBER_CHECK	CHAR	1	0	Payment Cards: Credit Card Check (Number)
83	CC_AUTH_STATUS_X	☐	HRV_CC_AUTH_STATUS	HRV_CC_AUTH_STATUS	CHAR	1	0	Payment Cards: Authorization Status
84	REFDOCSEQNR_X	☐	PESQNUR	NUM3	NUMC	3	0	Sequence Number
85	LEARN_STATUS_X	☐	LSO_LS_AC0	LSO_LS_AC0	CHAR	1	0	Completion Status of Course Content
86	ACCESS_COUNTER_X	☐	LSO_ACCESS_COUNTER_AC0	NUMC4	NUMC	4	0	Number of Accesses to Course Content
87	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PAD25_QUE	CAATR_X	T77CAR	CAATR		1	CN
2	PAD25_QUE	FAILED_X	T77FAR	FAILED
3	PAD25_QUE	KOKRS_X	TKA01	KOKRS
4	PAD25_QUE	KOSTL_X	CSKS	KOSTL
5	PAD25_QUE	KWAER_X	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in