/FLDQ/HNA_MTC_SH - Match shadow table for hana real time duplication
Match shadow table for hana real time duplication information is stored in SAP table /FLDQ/HNA_MTC_SH.
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".
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_MTC_SH
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 |