U_37100C SAP (Generated Table for View U_37100C) Table View details
Dictionary Type: Table View
Description: Generated Table for View U_37100C
Description: Generated Table for View U_37100C
Table View field list including key, data, relationships and ABAP select examples
U_37100C is a standard SAP Table View which is used to store Generated Table for View U_37100C data and is available within R/3 SAP systems depending on the version and release level.
The U_37100C table consists of various fields, each holding specific information or linking keys about Generated Table for View U_37100C data available in SAP. These include PLVAR (Plan Version), OTYPE (Object Type), OBJID (Object ID), REPAIR (Repair Flag for Object).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP U_37100C table view fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PLVAR | Plan Version | PLVAR | CHAR | 2 | T778P | PLVAR | POP | ||
OTYPE | Object Type | OTYPE | CHAR | 2 | T778O | OTYPE | POT | ||
OBJID | Object ID | HROBJID | NUMC | 8 | HROBJID | PON | |||
REPAIR | Repair Flag for Object | HRREPAIR | CHAR | 1 | CHAR1_X | ||||
SHORT | Object Abbreviation | SHORT_D | CHAR | 12 | TEXT12 | ||||
STEXT | Object Name | STEXT | CHAR | 40 | TEXT40 | ||||
GDATE | Delimitation date | GDATE | DATS | 8 | DATUM | ||||
MC_SHORT | Object Abbreviation | HR_MCSHORT | CHAR | 12 | CHAR12 | ||||
MC_STEXT | Name | HR_MCSTEXT | CHAR | 40 | CHAR40 | ||||
MC_SEARK | Search Term | HR_MCSEARK | CHAR | 52 | CHAR52 | ||||
LANGU | Language Key | LANGU | LANG | 1 | T002 | ISOLA | SPRAS | ||
TABNR | Reference Number to Table Part | HRTABNR | CHAR | 32 | HRITABNR | HRTABNR | |||
TABSEQNR | Sequence Number in Table Part of Table Infotype | HRTABSEQNR | NUMC | 6 | NUM06 | ||||
TLINE | Line With Length 79 for Infotype 1002 | HRLINE79 | CHAR | 79 | TEXT79 | ||||
TFORMAT | Tag column | TDFORMAT | CHAR | 2 | TDELEMSTYL | ||||
ISTAT | Planning Status | ISTAT_D | CHAR | 1 | T778S | ISTAT | PST | ||
BEGDA | Start Date | BEGDATUM | DATS | 8 | DATUM | BEG | |||
ENDDA | End Date | ENDDATUM | DATS | 8 | DATUM | END | |||
VARYF | Variation Field for File PLOG | VARYF | CHAR | 10 | CHAR10 | ||||
SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | NUM03 | ||||
INFTY | Infotype | INFOTYP | CHAR | 4 | T778T | INFOTYP | HRBAS00INFTY | ||
OTJID | Concatenation of Object Type and Object ID | OTJID | CHAR | 10 | CHAR10 | ||||
AEDTM | Changed on | AEDTM | DATS | 8 | DATUM | ||||
UNAME | User Name | USRNAME | CHAR | 12 | CHAR12 | ||||
REASN | Reason | REASN | CHAR | 2 | CHAR2 | ||||
HISTO | Historical Record Flag | HISTO | CHAR | 1 | CHAR1 | ||||
ITXNR | Text Module for Infotype | ITXNR | NUMC | 8 | NUM08 | ||||
RTEXT | Flag for reading business event text from event itself | FKURSTXT | NUMC | 1 | NUM01 | ||||
INKBR | Indicator for inclusion in business event brochure | INKBR | NUMC | 1 | NUM01 | ||||
KONGX | Indicator for convention | KONGX | CHAR | 1 | CHAR1_X | ||||
NO_INT_INST | No integration for instructors | INT_OFF_INST | CHAR | 1 | CHAR1_X | ||||
NO_INT_PART | No integration for attendees | INT_OFF_PART | CHAR | 1 | CHAR1_X | ||||
DAYS_OFF_INST | Allowed in instructor's time off | DAYS_OFF_INST | CHAR | 1 | CHAR1_X | ||||
DAYS_OFF_PART | Allowed in attendee's time off | DAYS_OFF_PART | CHAR | 1 | CHAR1_X | ||||
MINPRESENCE | Minimum percentage attendance | MINPRESENCE | DEC | 5(2) | DEC3_2 | ||||
NYEARS | Number of years | NYEARS | DEC | 3 | DEC3 | ||||
NMONTHS | Number of Months | NMONTHS | DEC | 3 | DEC3 | ||||
N_TYPE | Flag: 'Depreciation Meter/Validity' Infotype | N_TYPE | CHAR | 1 | N_TYPE | ||||
TEILN_TYP | Attendee type | TEILNTYP | CHAR | 2 | T778O | OTYPE | POT | ||
BCHECK | Check for bookings for same business event type | BCHECK | CHAR | 1 | BCHECK | ||||
VCHECK | Check for prebookings on same business event type | VCHECK | CHAR | 1 | VCHECK | ||||
KCHECK | Check for prerequisite business event | KCHECK | CHAR | 1 | VCHECK | ||||
QCHECK | Check Attendee's Qualification | QCHECK | CHAR | 1 | VCHECK | ||||
QASSIGN | Transfer objectives to attendee as qualifications | QASSIGN | CHAR | 1 | CHAR1_X | ||||
DELRKURS | Delete relationship business event/attendee after bus.event | DELRKURS | CHAR | 1 | CHAR1_X | ||||
INSRKTYP | Create relationship event type / attendee after bus. event | INSRKTYP | CHAR | 1 | CHAR1_X | ||||
XDATA | Reserve field PX030 | XDATA | CHAR | 6 | CHAR6 |
Key field | Non-key field |
How do I retrieve data from SAP table U_37100C using ABAP code
The following ABAP code Example will allow you to do a basic selection on U_37100C to SELECT all data from the tableDATA: WA_U_37100C TYPE U_37100C.
SELECT SINGLE *
FROM U_37100C
INTO CORRESPONDING FIELDS OF WA_U_37100C
WHERE...
How to access SAP table U_37100C
Within an ECC or HANA version of SAP you can also view further information about U_37100C and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects