SNWD_BP_CRM - EPM HANA DG: CRM Business Partner Table (non-EPM)

EPM HANA DG: CRM Business Partner Table (non-EPM) information is stored in SAP table SNWD_BP_CRM.
It is part of development package S_EPM_HANA_EXT_DDIC_CRM in software component BC-SRV-NWD. This development package consists of objects that can be grouped under "EPM HANA: CRM specific DDIC artifacts".

Fields for table SNWD_BP_CRM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	*
BP_ID		X		CHAR	20
LAST_NAME				CHAR	120
FIRST_NAME				CHAR	80
GENDER				CHAR	12
BIRTHDAY	Field of type DATS		DATS	DATS	16
COUNTRY				CHAR	6
COUNTRY_LONG				CHAR	80
CITY				CHAR	80
STATE				CHAR	80
STREET				CHAR	128
STREET_NO				CHAR	10
PHONE				CHAR	60
FAX				CHAR	60
MOBILE				CHAR	60
EMAIL				CHAR	100
HOBBY				CHAR	40
MARITAL_STATUS				CHAR	20
LOYALITY_STATUS				CHAR	20
CHILDREN				INT1	1
EMAIL_FLAG				CHAR	6
PHONE_FLAG				CHAR	6
MARKETING_OPT_IN				CHAR	6
REG_CHANNEL				CHAR	20
PREF_CHANNEL				CHAR	20
CUSTOMER_TYPE				CHAR	16
CUSTOMER_SINCE	Field of type DATS		DATS	DATS	16
LAST_CONTACT_DATE	Field of type DATS		DATS	DATS	16
CURRENCY				CHAR	6
SALES_ORG				CHAR	20
DISTRIBUTION_CHANNEL				CHAR	20
DIVISION				CHAR	4
ACCOUNT_GROUP				CHAR	20
SALES_VOLUME				DEC	6
LAST_CONTACT				CHAR	40
AGE				INT4	4
CUSTOMER_TENURE				INT4	4