U_37223C SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
U_37223C is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The U_37223C table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include PLVAR (Plan Version), OTYPE (Object Type), OBJID (Object ID), RSIGN (Relationship Specification).. 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_37223C 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 | |||
RSIGN | Relationship Specification | RSIGN | CHAR | 1 | RSIGN | ||||
RELAT | Relationship Between Objects | RELAT | CHAR | 3 | T778V | RELAT | |||
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 | ||||
SCLAS | Type of Related Object | SCLAS | CHAR | 2 | T778O | OTYPE | |||
SOBID | ID of Related Object | SOBID | CHAR | 45 | CHAR45 | ||||
ADATANR | ADATA Number | HRADATANR | CHAR | 32 | HRIADATANR | HRADATANR | |||
REFDOCNO | Reference Document | HRV_REFDOC | CHAR | 10 | ALPHA | BELNR | |||
REFDOCITEM | Reference Document Item | HRV_REFDOCITEM | NUMC | 3 | NUM3 | ||||
REFDOCSEQNR | Sequence Number | SQNUR | NUMC | 3 | NUM3 | ||||
DOCDATE | Document Date | CO_BLDAT | DATS | 8 | DATUM | ||||
POSTINGDATE | Posting Date | CO_BUDAT | DATS | 8 | DATUM | ||||
DOCUNAME | User Name | UNAME | CHAR | 12 | UNAME | ||||
EVENT | Document Operation | HRV_EVENT | CHAR | 1 | HRV_EVENT | ||||
STATUS | Status of Document Operation | HRV_STATUS | CHAR | 1 | HRV_STATUS | ||||
DOCUMENT | Document number | PBELNR | CHAR | 10 | CHAR10 | ||||
HRVCOSTELEMENT | Cost item | KOBES | CHAR | 8 | KOBES | ||||
PRICE | Amount | HRVPRICE | CURR | 16(2) | CURR16 | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
QUANTITY | Total quantity entered | MBGXXX | QUAN | 15(3) | MENGV8 | ||||
UNIT | Posted Unit of Measure | MEINB | UNIT | 3 | CUNIT | MEINS | |||
ACTIVITYTYPE | Activity Type | LSTAR | CHAR | 6 | LSTAR | LAR | LART_EMPTY | ||
CONTROLLINGAREA | Controlling Area | KOKRS | CHAR | 4 | CACCD | CAC | |||
SCOSTCENTER | Sender cost center | SKOST | CHAR | 10 | ALPHA | KOSTL | KSK | ||
RCOSTCENTER | Receiver Cost Center | EKOSTL | CHAR | 10 | ALPHA | KOSTL | KSK | ||
RORDER | Receiver Order | EAUFNR | CHAR | 12 | ALPHA | AUFNR | |||
RSALESORDER | Receiver sales order | EKDAU | CHAR | 10 | ALPHA | VBELN | |||
RSALESITEM | Item number in receiver sales order | EKDPO | NUMC | 6 | POSNR | ||||
RWBSELEMENT | Receiver work breakdown structure element (WBS element) | E_PS_POSID | CHAR | 24 | PROJN | PS_POSID | |||
COSTELEMENT | Cost Element | KSTAR | CHAR | 10 | ALPHA | KSTAR | KAT | ||
DATESTAMP | Date activity was last executed | HRV_DATESTAMP | DATS | 8 | DATUM | ||||
TIMESTAMP | Time activity was last executed | HRV_TIMESTAMP | TIMS | 6 | UZEIT | ||||
PREVREFDOC | Preceding document | HRV_PREVREFDOC | CHAR | 10 | ALPHA | BELNR |
Key field | Non-key field |
How do I retrieve data from SAP table U_37223C using ABAP code
The following ABAP code Example will allow you to do a basic selection on U_37223C to SELECT all data from the tableDATA: WA_U_37223C TYPE U_37223C.
SELECT SINGLE *
FROM U_37223C
INTO CORRESPONDING FIELDS OF WA_U_37223C
WHERE...
How to access SAP table U_37223C
Within an ECC or HANA version of SAP you can also view further information about U_37223C 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