SAP ABAP Table PIQDBOFFERTMPL (Templates for Business Event Offerings (Gen.))

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AD (Application Component) Administration
     ⤷ PMIQ (Package) Campus Management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PIQDBOFFERTMPL	Table Relationship Diagram
Short Description	Templates for Business Event Offerings (Gen.)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	T000
2	PLVAR	☑	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
3	SM_OBJID	☑	PIQ_SM_OBJID	HROBJID	NUMC	8	0	Module Object ID	*
4	SEQNR	☑	PIQTEMPLSEQNR	NUMC3	NUMC	3	0	Sequence Number
5	D_OBJID	☐	ETYID	HROBJID	NUMC	8	0	Business event type: key	*
6	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
7	OFFERPATTERN	☐	PIQOFFERPATTERN	PIQOFFERPATTERN	CHAR	4	0	Session Pattern	T7PIQOFFERPAT
8	LOCATION	☐	LOCID	HROBJID	NUMC	8	0	Business Event Location	*
9	CAPACITY_MIN	☐	KAPZ1	DEC5	DEC	5	0	Minimum capacity
10	CAPACITY_OPT	☐	KAPZ2	DEC5	DEC	5	0	Optimum capacity
11	CAPACITY_MAX	☐	KAPZ3	DEC5	DEC	5	0	Maximum capacity
12	CONTACTHOURS	☐	PIQCONTACTHOURS	PIQNUMB	DEC	5	2	Contact Hours
13	CHOURUNIT	☐	PIQCHOURUNIT	PIQCHOURUNIT	CHAR	4	0	Unit for Teaching Effort or Contact Hours	*
14	UNITNUMBER	☐	PIQNUMB	PIQNUMB	DEC	5	2	Number
15	TEMPLUNIT	☐	PIQTEMPLUNIT	PIQTEMPLUNIT	CHAR	2	0	Unit for Class Period
16	TEMPLID	☐	PIQTEMPLID	SYSUUID_C	CHAR	32	0	Template for Business Event Offering	PIQDBOFFERT_GUID
17	PLPERLIMEND	☐	PIQPLPERLIMEND	PIQNUMB	DEC	5	2	Relative End of Planning Period
18	PLPERLIMEUNIT	☐	PIQPLPERENDUNIT	PIQTEMPLUNIT	CHAR	2	0	Unit for Relative End of Planning Period
19	SCHEDBEGDAY	☐	PIQSCHEDBGDAY	DAYS17	NUMC	1	0	Start Day of Business Event Schedule

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQDBOFFERTMPL	ISTAT	T778S	ISTAT	REF	1	CN
2	PIQDBOFFERTMPL	MANDT	T000	MANDT	KEY	1	CN
3	PIQDBOFFERTMPL	OFFERPATTERN	T7PIQOFFERPAT	OFFERPATTERN	KEY	1	CN
4	PIQDBOFFERTMPL	PLVAR	T778P	PLVAR	KEY	1	CN
5	PIQDBOFFERTMPL	TEMPLID	PIQDBOFFERT_GUID	TEMPLID	KEY	1	1

History

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