/FLDQ/HNA_MTCSH2 - Match shadow2 table for hana real time duplication

Match shadow2 table for hana real time duplication information is stored in SAP table /FLDQ/HNA_MTCSH2.
It is part of development package /FLDQ/DQM_ON_HANA in software component EIM-DQM-SAP. This development package consists of objects that can be grouped under "Development Package for Data Quality on SAP HANA".

Fields for table /FLDQ/HNA_MTCSH2

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
.INCLUDE		X		ADDR_KEYNR	0
ADDRNUMBER	Address Number	X	AD_ADDRNUM	CHAR	20	*
PERSNUMBER	Person Number	X	AD_PERSNUM	CHAR	20
ADDR_TYPE	Address type (1=Organization, 2=Person, 3=Contact person)	X	AD_ADRTYPE	CHAR	2
DATE_FROM	Valid-from date - in current Release only 00010101 possible	X	AD_DATE_FR	DATS	16
NATION	Version ID for International Addresses	X	AD_NATION	CHAR	2
APPL_TABLE	Application table logical name (address management)	X	AD_APPLTAB	CHAR	20
APPL_FIELD	Application table address where-used list logical field name	X	AD_APPLFLD	CHAR	20
.INCLUDE				/FLDQ/HNA_ADDR_MATCHFIELD_STR	0
MATCH_ADDR_COUNTRY				CHAR	4
MATCH_ADDR_POSTCODE1				CHAR	20
MATCH_ADDR_REGION				CHAR	40
MATCH_ADDR_LOCALITY				CHAR	100
MATCH_ADDR_LOCALITY2				CHAR	100
MATCH_ADDR_BUILDING				CHAR	100
MATCH_ADDR_PRIM_NAME				CHAR	100
MATCH_ADDR_PRIM_NAME2				CHAR	100
MATCH_ADDR_PRIM_TYPE				CHAR	40
MATCH_ADDR_PRIM_DIR				CHAR	24
MATCH_ADDR_PRIM_NUMBER				CHAR	24
MATCH_ADDR_BLOCK				CHAR	24
MATCH_ADDR_STAIRWELL				CHAR	24
MATCH_ADDR_WING				CHAR	24
MATCH_ADDR_FLOOR				CHAR	24
MATCH_ADDR_UNIT				CHAR	24
ADDR_SCRIPT_CODE				CHAR	8
ADDR_ASMT_LEVEL				CHAR	6
ADDR_ASMT_TYPE				CHAR	10
STD_ADDR_PO_BOX_NUMBER	Necessary as a cleanse output to generate addr2 fields			CHAR	24
.INCLUDE				/FLDQ/HNA_ADDR2_MATCHFIELD_STR	0
MATCH_ADDR2_COUNTRY				CHAR	4
MATCH_ADDR2_POSTCODE1				CHAR	20
MATCH_ADDR2_REGION				CHAR	40
MATCH_ADDR2_LOCALITY				CHAR	100
MATCH_ADDR2_LOCALITY2				CHAR	100
MATCH_ADDR2_BUILDING				CHAR	100
MATCH_ADDR2_PRIM_NAME				CHAR	100
MATCH_ADDR2_PRIM_NAME2				CHAR	100
MATCH_ADDR2_PRIM_TYPE				CHAR	40
MATCH_ADDR2_PRIM_DIR				CHAR	24
MATCH_ADDR2_PRIM_NUMBER				CHAR	24
MATCH_ADDR2_BLOCK				CHAR	24
MATCH_ADDR2_STAIRWELL				CHAR	24
MATCH_ADDR2_WING				CHAR	24
MATCH_ADDR2_FLOOR				CHAR	24
MATCH_ADDR2_UNIT				CHAR	24
ADDR2_SCRIPT_CODE				CHAR	8
ADDR2_ASMT_LEVEL				CHAR	6
ADDR2_ASMT_TYPE				CHAR	10
.INCLUDE				/FLDQ/HNA_PERS_MATCHFIELD_STR	0
MATCH_PERSON_GN				CHAR	60
MATCH_PERSON_GN_STD				CHAR	60
MATCH_PERSON_GN_STD2				CHAR	60
MATCH_PERSON_GN_STD3				CHAR	60
MATCH_PERSON_GN_STD4				CHAR	60
MATCH_PERSON_GN_STD5				CHAR	60
MATCH_PERSON_GN_STD6				CHAR	60
MATCH_PERSON_GN2				CHAR	60
MATCH_PERSON_GN2_STD				CHAR	60
MATCH_PERSON_GN2_STD2				CHAR	60
MATCH_PERSON_GN2_STD3				CHAR	60
MATCH_PERSON_GN2_STD4				CHAR	60
MATCH_PERSON_GN2_STD5				CHAR	60
MATCH_PERSON_GN2_STD6				CHAR	60
MATCH_PERSON_FN				CHAR	100
MATCH_PERSON_FN_STD				CHAR	100
MATCH_PERSON_MATPOST				CHAR	20
MATCH_PERSON_MATPOST_STD				CHAR	20
.INCLUDE				/FLDQ/HNA_FIRM_MATCHFIELD_STR	0
MATCH_FIRM				CHAR	200
MATCH_FIRM_STD				CHAR	200
MATCH_FIRM2				CHAR	200
MATCH_FIRM2_STD				CHAR	200
RECORD_ACTION	Address transfer structure change flag		AD_UPDFLAG	CHAR	2