SAP ABAP Table PIQDBOFFERTMPLRS (Templates for Business Event Offerings (Resources))
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 PIQDBOFFERTMPLRS   Table Relationship Diagram
Short Description Templates for Business Event Offerings (Resources)    
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 TEMPLID PIQTEMPLID SYSUUID_C CHAR 32   0   Template for Business Event Offering PIQDBOFFERT_GUID
3 SEQNR PIQTEMPLSEQNR NUMC3 NUMC 3   0   Sequence Number  
4 MONDAY PIQXFELDMONDAY CHAR1 CHAR 1   0   Monday  
5 TUESDAY PIQXFELDTUESDAY CHAR1 CHAR 1   0   Tuesday  
6 WEDNESDAY PIQXFELDWEDNESDAY CHAR1 CHAR 1   0   Wednesday  
7 THURSDAY PIQXFELDTHURSDAY CHAR1 CHAR 1   0   Thursday  
8 FRIDAY PIQXFELDFRIDAY CHAR1 CHAR 1   0   Friday  
9 SATURDAY PIQXFELDSATURDAY CHAR1 CHAR 1   0   Saturday  
10 SUNDAY PIQXFELDSUNDAY CHAR1 CHAR 1   0   Sunday  
11 BEGUZ BEGUZ UZEIT TIMS 6   0   Start Time  
12 ENDUZ ENDUZ UZEIT TIMS 6   0   End Time  
13 FREQUENCY PIQINTERVAL DEC2 DEC 2   0   Recurrence Interval  
14 FIRST_APPEARANCE PIQFIRSTDATEAFTER DEC2 DEC 2   0   First Date After Start of Classes  
15 LAST_APPEARANCE PIQLASTDATEAFTER DEC2 DEC 2   0   Last Date After Start of Classes  
16 NUMBER_OF_DATES PIQNUMBEROFDATES DEC2 DEC 2   0   Number of Dates on Which Event Is Held  
17 ROOM_OBJID ROMID HROBJID NUMC 8   0   Room *
18 INSTR_OTYPE OTYPE OTYPE CHAR 2   0   Object Type T778O
19 INSTR_OBJID PIQINSTROBJID CHAR45 CHAR 45   0   Instructor of Business Event (ID)  
20 INSTR_PROZT PROZT DEC3_2 DEC 5   2   Weighting Percentage  
21 ROOM_RESTYP HROBJID HROBJID NUMC 8   0   Object ID *
22 INSTR_RESTYP HROBJID HROBJID NUMC 8   0   Object ID *
23 RECFRQ PIQFREQUENCY DEC2 DEC 2   0   Number of Recurrences  
24 X_WEEKS WOCHE CHAR1 CHAR 1   0   Selection field for time interval unit: 'Week'  
25 X_MONTHS QMONAT CHAR1 CHAR 1   0   Selection field for time interval unit: 'Month'  
26 OIMONTH PIQOIMONTH PIQOIMONTH NUMC 1   0   Occurrence(s) per Month  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PIQDBOFFERTMPLRS INSTR_OTYPE T778O OTYPE KEY 1 CN
2 PIQDBOFFERTMPLRS MANDT T000 MANDT    
3 PIQDBOFFERTMPLRS TEMPLID PIQDBOFFERT_GUID TEMPLID KEY 1 CN
History
Last changed by/on SAP  20050411 
SAP Release Created in 464