/FLDQ/AD_MTCCODE SAP (FirstLogic Match Code Index Table) Table details

Dictionary Type: Table
Description: FirstLogic Match Code Index Table




ABAP Code to SELECT data from /FLDQ/AD_MTCCODE
Related tables to /FLDQ/AD_MTCCODE
Access table /FLDQ/AD_MTCCODE




Table field list including key, data, relationships and ABAP select examples

/FLDQ/AD_MTCCODE is a standard SAP Table which is used to store FirstLogic Match Code Index Table data and is available within R/3 SAP systems depending on the version and release level.

The /FLDQ/AD_MTCCODE table consists of various fields, each holding specific information or linking keys about FirstLogic Match Code Index Table data available in SAP. These include ADDRNUMBER (Address number), PERSNUMBER (Person number), ADDR_TYPE (Address type (1=Organization, 2=Person, 3=Contact person)), DATE_FROM (Valid-from date - in current Release only 00010101 possible).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP /FLDQ/AD_MTCCODE table 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
ADDRNUMBERAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
PERSNUMBERPerson number AD_PERSNUMCHAR10Assigned to domainALPHAAD_PERSNUMCDTADDRESS
ADDR_TYPEAddress type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPECHAR1AD_ADRTYPE
DATE_FROMValid-from date - in current Release only 00010101 possible AD_DATE_FRDATS8DATUM
NATIONVersion ID for International Addresses AD_NATIONCHAR1Assigned to domainAD_NATIONADDRESS_NATION
APPL_TABLEApplication table logical name (address management) AD_APPLTABCHAR10CHAR10
APPL_FIELDApplication table address where-used list logical field name AD_APPLFLDCHAR10CHAR10
MATCH_CODE1Address Match Code /FLDQ/AD_MATCH_CODECHAR20TEXT20
PO_MATCH_CODEAddress Match Code /FLDQ/AD_MATCH_CODECHAR20TEXT20
MTC_CODE_NM1Name Match Code /FLDQ/AD_NAME_MATCH_CODECHAR20TEXT20
MTC_CODE_NM2Name Match Code /FLDQ/AD_NAME_MATCH_CODECHAR20TEXT20
MTC_CODE_NM3Name Match Code /FLDQ/AD_NAME_MATCH_CODECHAR20TEXT20
MTC_CODE_NM4Name Match Code /FLDQ/AD_NAME_MATCH_CODECHAR20TEXT20
MTC_CODE_NM5Name Match Code /FLDQ/AD_NAME_MATCH_CODECHAR20TEXT20
DEPARTMENTDepartment AD_DPRTMNTCHAR40TEXT40
FUNCTIONCompany contact person function AD_FUNCCHAR40TEXT40
ID_CODEShort name for correspondence AD_ID_CODECHAR10TEXT10
IH_MAILInt. mail postal code AD_IH_MAILCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
FLOORFloor in building AD_FLOORCHAR10TEXT10
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
NAME1Name 1 AD_NAME1CHAR40TEXT40
NAME2Name 2 AD_NAME2CHAR40TEXT40
NAME3Name 3 AD_NAME3CHAR40TEXT40
NAME4Name 4 AD_NAME4CHAR40TEXT40
NAME_COc/o name AD_NAME_COCHAR40TEXT40
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
PO_BOX_CTYPO box country AD_POBXCTYCHAR3Assigned to domainLAND1
REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
SORT1Search Term 1 AD_SORT1CHAR20CHAR20
SORT2Search Term 2 AD_SORT2CHAR20CHAR20
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
NAME_FIRSTFirst name AD_NAMEFIRCHAR40TEXT40
NAME_LASTLast name AD_NAMELASCHAR40TEXT40
SMTP_ADDRE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
TEL_NUMBERFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
TEL_EXTENSFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
EXTRA1Text, 255 Characters /FLDQ/AD_TEXT255CHAR255/FLDQ/AD_TEXT255
EXTRA2Text, 255 Characters /FLDQ/AD_TEXT255CHAR255/FLDQ/AD_TEXT255
MTCSTD1Match Standard /FLDQ/AD_MATCH_STDCHAR40CHAR40
MTCSTD2Match Standard /FLDQ/AD_MATCH_STDCHAR40CHAR40

Key field Non-key field



How do I retrieve data from SAP table /FLDQ/AD_MTCCODE using ABAP code

The following ABAP code Example will allow you to do a basic selection on /FLDQ/AD_MTCCODE to SELECT all data from the table
DATA: WA_/FLDQ/AD_MTCCODE TYPE /FLDQ/AD_MTCCODE.

SELECT SINGLE *
FROM /FLDQ/AD_MTCCODE
INTO CORRESPONDING FIELDS OF WA_/FLDQ/AD_MTCCODE
WHERE...

How to access SAP table /FLDQ/AD_MTCCODE

Within an ECC or HANA version of SAP you can also view further information about /FLDQ/AD_MTCCODE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!