LDA_QUERY_MAP SAP table for – HR LDAP: Mapping Query Field Name <-> LDAP Attribute Name

Here we would like to draw your attention to LDA_QUERY_MAP table in SAP. As we know it is being mainly used with the SAP PA-IS (HR Information Systems in PA) component which is coming under HR (HCM) PA module (Personnel Management). LDA_QUERY_MAP is a SAP standard transp table used for storing HR LDAP: Mapping Query Field Name <-> LDAP Attribute Name related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PP0L_LDA_HRLDAP_EXTRACT.

SAP LDA_QUERY_MAP table

Table LDA_QUERY_MAP technical data

TableLDA_QUERY_MAP
Data storingHR LDAP: Mapping Query Field Name <-> LDAP Attribute Name
ModulePA
Sub ModulePA-IS
SAP PackagePP0L_LDA_HRLDAP_EXTRACT
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP LDA_QUERY_MAP 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 LDA_QUERY_MAP table.

  • WORKSPACE : SAP Query (S): Work Area ID
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • USERGROUP : SAP Query (S): Name of a user group
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • QUERYNAME : SAP Query (S): Query name
    Its a key field. Its data type is CHAR (Character String) with field length 14
  • QUERY_FIELD : SAP Query (L): Original field name
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • ATTR_TABNAME : Table Name
    Its data type is CHAR (Character String) with field length 30
  • ATTR_FIELDNAME : Field Name
    Its data type is CHAR (Character String) with field length 30
  • TECH_FLAG : HR LDAP: Technical Use (Flag)
    Its data type is CHAR (Character String) with field length 1
  • RAWDATA_FLAG : HR LDAP: Interpretation as Hexadecimal Number (Flag)
    Its data type is CHAR (Character String) with field length 1
  • KEY_FLAG : HR LDAP: Use Key Determination (Flag)
    Its data type is CHAR (Character String) with field length 1