SIMDQ_TRCLNS_OUT - IM in HANA output table for transactional cleanse TASK

IM in HANA output table for transactional cleanse TASK information is stored in SAP table SIMDQ_TRCLNS_OUT.
It is part of development package SEIM_IM_IN_HANA in software component BC-EIM-DQM. This development package consists of objects that can be grouped under "ABAP interface for task framework component of IMinHANA".

Fields for table SIMDQ_TRCLNS_OUT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
ADDRNUMBER	Address Number	X	AD_ADDRNUM	CHAR	20
DATE_FROM	Valid-from date	X		DATS	16
NATION	Version ID for International Addresses	X	AD_NATION	CHAR	2
.INCLUDE				SIMDQ_ADRC_STRUC	0
.INCLUDE				ADRC_STRUC	0
NAME_CO	c/o name		AD_NAME_CO	CHAR	80
CITY1	City		AD_CITY1	CHAR	80
CITY2	District		AD_CITY2	CHAR	80
CITY_CODE	City code for city/street file		AD_CITYNUM	CHAR	24	ADRCITY
CITYP_CODE	District code for City and Street file		AD_CITYPNM	CHAR	16	ADRCITYPRT
HOME_CITY	City (different from postal city)		AD_CITY3	CHAR	80
CITYH_CODE	Different city for city/street file		AD_CITYHNM	CHAR	24	ADRCITY
CHCKSTATUS	City file test status		AD_CHECKST	CHAR	2
REGIOGROUP	Regional structure grouping		REGIOGROUP	CHAR	16	ADRREGGRP
POST_CODE1	City postal code		AD_PSTCD1	CHAR	20
POST_CODE2	PO Box Postal Code		AD_PSTCD2	CHAR	20
POST_CODE3	Company Postal Code (for Large Customers)		AD_PSTCD3	CHAR	20
PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code		AD_PST1XT	CHAR	20
PCODE2_EXT	(Not Supported) PO Box Postal Code Extension		AD_PST2XT	CHAR	20
PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension		AD_PST3XT	CHAR	20
PO_BOX	PO Box		AD_POBX	CHAR	20
DONT_USE_P	PO Box Address Undeliverable Flag		AD_NO_USEP	CHAR	8	TSAD12
PO_BOX_NUM	Flag: PO Box Without Number		AD_POBXNUM	CHAR	2
PO_BOX_LOC	PO Box city		AD_POBXLOC	CHAR	80
CITY_CODE2	City PO box code (City file)		AD_CIT2NUM	CHAR	24	ADRCITY
PO_BOX_REG	Region for PO Box (Country/Region, State, Province, ...)		AD_POBXREG	CHAR	6	T005S
PO_BOX_CTY	PO Box of Country/Region		AD_POBXCTY	CHAR	6	T005
POSTALAREA	(Not Supported) Post Delivery District		AD_PSTLAR	CHAR	30
TRANSPZONE	Transportation zone to or from which the goods are delivered		LZONE	CHAR	20	TZONE
STREET	Street		AD_STREET	CHAR	120
DONT_USE_S	Street Address Undeliverable Flag		AD_NO_USES	CHAR	8	TSAD12
STREETCODE	Street Number for City/Street File		AD_STRNUM	CHAR	24	ADRSTREET
STREETABBR	(Not Supported) Abbreviation of Street Name		AD_STRABBR	CHAR	4	ADRSTRTYPE
HOUSE_NUM1	House Number		AD_HSNM1	CHAR	20
HOUSE_NUM2	House number supplement		AD_HSNM2	CHAR	20
HOUSE_NUM3	(Not supported) House Number Range		AD_HSNM3	CHAR	20
STR_SUPPL1	Street 2		AD_STRSPP1	CHAR	80
STR_SUPPL2	Street 3		AD_STRSPP2	CHAR	80
STR_SUPPL3	Street 4		AD_STRSPP3	CHAR	80
LOCATION	Street 5		AD_LCTN	CHAR	80
BUILDING	Building (Number or Code)		AD_BLDNG	CHAR	40
FLOOR	Floor in building		AD_FLOOR	CHAR	20
ROOMNUMBER	Room or Apartment Number		AD_ROOMNUM	CHAR	20
COUNTRY	Country/Region Key		LAND1	CHAR	6	T005
LANGU	Language Key		SPRAS	LANG	2	T002
REGION	Region (State, Province, County)		REGIO	CHAR	6	T005S
SORT1	Search Term 1		AD_SORT1UL	CHAR	40
SORT2	Search Term 2		AD_SORT2UL	CHAR	40
SORT_PHN	(Not Supported) Phonetic Search Sort Field		AD_SRTPHN	CHAR	40
ADDRORIGIN	(Not Supported) Address Data Source (Key)		AD_ORIGINA	CHAR	8	TSAD6
EXTENSION1	Extension (only for data conversion) (e.g. data line)		AD_EXTENS1	CHAR	80
EXTENSION2	Extension (only for data conversion) (e.g. telebox)		AD_EXTENS2	CHAR	80
TIME_ZONE	Address time zone		AD_TZONE	CHAR	12	TTZZ
TAXJURCODE	Tax Jurisdiction		AD_TXJCD	CHAR	30
ADDRESS_ID	(Not supported) Physical address ID		AD_ADDR_ID	CHAR	20
REMARK	Address notes		AD_REMARK1	CHAR	100
LANGU_CREA	Address record creation original language		AD_LANGUCR	LANG	2	T002
PO_BOX_LOBBY	PO Box Lobby		AD_PO_BOX_LBY	CHAR	80
DELI_SERV_TYPE	Type of Delivery Service		AD_DELIVERY_SERVICE_TYPE	CHAR	8	ADDRC_DELI_SERV
DELI_SERV_NUMBER	Number of Delivery Service		AD_DELIVERY_SERVICE_NUMBER	CHAR	20
COUNTY_CODE	County code for county		AD_CNTYNUM	CHAR	16	ADRCOUNTY
COUNTY	County		AD_COUNTY	CHAR	80
TOWNSHIP_CODE	Township code for Township		AD_TWSHPNUM	CHAR	16	ADRTOWNSHIP
TOWNSHIP	Township		AD_TOWNSHIP	CHAR	80
STATUS_CODE	Address Engine Status Code		SIMDQ_STATUS_CODE	CHAR	20
STATUS_CODE_PO	Address Engine Status Code		SIMDQ_STATUS_CODE	CHAR	20
INFO_CODE	Address Information Code		SIMDQ_INFO_CODE	CHAR	8
INFO_CODE_PO	Address Information Code		SIMDQ_INFO_CODE	CHAR	8
ASGMT_TYPE	Address Assignment Type		SIMDQ_ASGMT_TYPE	CHAR	10
ASGMT_TYPE_PO	Address Assignment Type		SIMDQ_ASGMT_TYPE	CHAR	10
ASGMT_LEVEL	Assignment Level		SIMDQ_ASGMT_LEVEL	CHAR	4
ASGMT_LEVEL_PO	Assignment Level		SIMDQ_ASGMT_LEVEL	CHAR	4
REPLY1	Suggestion list prompt string		SIMDQ_PROMPT_LIST	CHAR	256
REGION2_LONG	Region Long Name		SIMDQ_REGION_LONG	CHAR	120
REGION2	Region (State, Province, County)		REGIO	CHAR	6	*
PO_BOX_REG2	Region (State, Province, County)		REGIO	CHAR	6	*
SUGG_ERROR	Address Suggestion error			CHAR	4
SUGG_STATUS	Address Suggestion status			CHAR	4
ASGMT_INFO	Assignment info Street			CHAR	2
ASGMT_INFO_PO	Assignment info PO Box			CHAR	2