T77QUERY_FIELDS SAP table for – OM: Desired Output Fields of a Query (Transportable)

Here we would like to draw your attention to T77QUERY_FIELDS table in SAP. As we know it is being mainly used with the SAP PA-OS (Organizational Structure in PA) component which is coming under HR (HCM) PA module (Personnel Management). T77QUERY_FIELDS is a SAP standard transp table used for storing OM: Desired Output Fields of a Query (Transportable) related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PP0E.

SAP T77QUERY_FIELDS table

Table T77QUERY_FIELDS technical data

TableT77QUERY_FIELDS
Data storingOM: Desired Output Fields of a Query (Transportable)
ModulePA
Sub ModulePA-OS-BS
SAP PackagePP0E
Delivery ClassS – System table, data changes have the status of program changes
ComponentSAP_HRRXX
Table CategoryTRANSP

SAP T77QUERY_FIELDS Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in T77QUERY_FIELDS table.

  • QUERY_GUID : GUID in ‘CHAR’ Format in Uppercase
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • COUNTER : Sequence Number
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • .INCLUDE : Description of Field for Selection/Data Retrieval
  • INFTY : Infotype
    Its data type is CHAR (Character String) with field length 4
  • FIELDNAME : Field Name
    Its data type is CHAR (Character String) with field length 30
  • FIELDKIND : Type of Field (Infotype, Additional, Text, …)
    Its data type is CHAR (Character String) with field length 4
  • DESCRIPTION : Description
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Field Description of Query Fields for OM Column Concept
  • FIELDKEY : Field Key
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • TYPE : SAP Query (S): ABAP type
    Its data type is CHAR (Character String) with field length 1
  • INT_LENGTH : SAP Query (S): Length
    Its data type is CHAR (Character String) with field length 3
  • OUT_LENGTH : SAP Query (S): Length
    Its data type is CHAR (Character String) with field length 3
  • CONVEXIT : Conversion Routine
    Its data type is CHAR (Character String) with field length 5
  • HEADING : SAP Query (L): Field description
    Its data type is CHAR (Character String) with field length 40