SAP ABAP Table PIQOFFERTMPLRS (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
⤷ IS-HER-CM-AD (Application Component) Administration
⤷ PMIQ (Package) Campus Management
Basic Data
Table Category | INTTAB | Structure |
Structure | PIQOFFERTMPLRS | Table Relationship Diagram |
Short Description | Templates for Business Event Offerings (Resources) |
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 | 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 | PIQOFFERTMPLRS | INSTR_OTYPE | T778O | OTYPE | |||
2 | PIQOFFERTMPLRS | MANDT | T000 | MANDT | |||
3 | PIQOFFERTMPLRS | TEMPLID | PIQDBOFFERT_GUID | TEMPLID |
History
Last changed by/on | SAP | 20050411 |
SAP Release Created in | 464 |