SNWD_IC_R_TELCO - EPM HANA: TELCO DG - Business Partner Table

EPM HANA: TELCO DG - Business Partner Table information is stored in SAP table SNWD_IC_R_TELCO.
It is part of development package S_EPM_HANA_EXT_DDIC_TELCO in software component BC-SRV-NWD. This development package consists of objects that can be grouped under "EPM HANA: TELCO DDIC Objects".

Fields for table SNWD_IC_R_TELCO

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	*
DB_KEY	NodeID	X		RAW	16
NAME_TEXT	Full Name of Person			CHAR	160
NAME_FIRST	First Name			CHAR	80
NAME_LAST	Last Name			CHAR	80
TITLE	Form-of-Address Key			CHAR	8
TITLE_FT	Title			CHAR	80
COUNTRY	Country Key			CHAR	6
COUNTRY_FT	Country			CHAR	80
REGION	Region (State, Province, County)			CHAR	6
REGION_FT	Region			CHAR	80
CITY1	City			CHAR	80
POSTCODE1	City postal code			CHAR	20
STREET	Street			CHAR	120
HOUSE_NUM1	House Number			CHAR	20
LANGUAGE	Language Key			LANG	2
LANGUAGE_FT	Language			CHAR	80
SEX	Gender key			CHAR	2
SEX_FT	Gender			CHAR	80
MARITAL_STATUS	Marital Status of Business Partner			CHAR	2
MARITAL_STATUS_FT	Marital Status			CHAR	40
CONSUMER_ACCOUNT_ID	Account ID With Alpha Conversion			CHAR	20
KUNNR	Account ID With Alpha Conversion			CHAR	20
COMPANY_NAME	Company Name			CHAR	80
BRSCH	Industry Key			CHAR	8
BRSCH_FT	Customer Industry Code			CHAR	80
ABTNR	Contact Person Department			CHAR	8
ABTNR_FT	Department			CHAR	80
PAFKT	Function of Contact			CHAR	8
PAFKT_FT	Function			CHAR	80
SMTP_ADDR	E-Mail Address			CHAR	482
TELNR_LONG	Complete number: dialling code+number+extension			CHAR	60
TELNR_MOBILE	Complete number: dialling code+number+extension			CHAR	60
FAXNR_LONG	Complete number: dialling code+number+extension			CHAR	60
DATE_OF_BIRTH	Date of Birth of Business Partner			DATS	16
IS_CONTACT	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')			CHAR	2
IS_CONSUMER	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')			CHAR	2
OBSOLETE	Object is obsolete ('X' = yes)			CHAR	2
EMAIL_OPTIN	Email Address Opt-In			CHAR	2
PHONE_OPTIN	Phone Opt-In (Landline)			CHAR	2
MOBILE_OPTIN	Cell Phone Opt-In			CHAR	2
POSTAL_OPTIN	Postal Opt-In			CHAR	2
FOR_REVIEW	Interaction contact data require clarification ('X' = yes)			CHAR	2
VALIDATION_STATUS	Validation Status Code			CHAR	4
KUNNR_SOURCE_SYSTEM_TYPE	OBSOLETE			CHAR	6
ANONYMIZED	Contact Demands Data Privacy ('X' = yes)			CHAR	2
CONTAINER	Container for Interactions of multiple Contacts ('X' = yes)			CHAR	2
_DATAAGING	Data Filter Value for Data Aging			DATS	16
LATITUDE	Latitude			QUAN	11
LONGITUDE	Longitude			QUAN	11
UNIT	Unit of Measure			UNIT	6
LAST_IA_TIMESTAMP	Timestamp of Last Interaction or Facet by IC			DEC	11
CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)		TIMESTAMPL	DEC	11
CREA_UNAME	User Name		UNAME	CHAR	24
LCHG_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)		TIMESTAMPL	DEC	11
LCHG_UNAME	User Name		UNAME	CHAR	24