SNWD_BP_RETAIL - EPM HANA DG: RETAIL Business Partner Table
EPM HANA DG: RETAIL Business Partner Table information is stored in SAP table SNWD_BP_RETAIL.
It is part of development package S_EPM_HANA_EXT_DDIC_RETAIL in software component BC-SRV-NWD. This development package consists of objects that can be grouped under "EPM HANA: Reteil DDIC Objects".
It is part of development package S_EPM_HANA_EXT_DDIC_RETAIL in software component BC-SRV-NWD. This development package consists of objects that can be grouped under "EPM HANA: Reteil DDIC Objects".
Fields for table SNWD_BP_RETAIL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | |
| ID | X | CHAR | 80 | |||
| NAME_FIRST | CHAR | 80 | ||||
| NAME_LAST | CHAR | 80 | ||||
| TITLE_FT | CHAR | 80 | ||||
| COUNTRY_FT | CHAR | 80 | ||||
| CITY1 | CHAR | 80 | ||||
| STREET | CHAR | 80 | ||||
| HOUSE_NUM1 | CHAR | 80 | ||||
| SEX_FT | CHAR | 2 | ||||
| CONSUMER_ACCOUNT_ID | CHAR | 80 | ||||
| COMPANY_NAME | CHAR | 80 | ||||
| COMPANY_ID | CHAR | 80 | ||||
| COMPANY_ID_ORIGIN | CHAR | 80 | ||||
| PAFKT_FT | CHAR | 80 | ||||
| SMTP_ADDR | CHAR | 480 | ||||
| OPT_IN_SMTP_ADDR | CHAR | 2 | ||||
| TELNR_LONG | CHAR | 60 | ||||
| OPT_IN_TELNR_LONG | CHAR | 2 | ||||
| TELNR_MOBILE | CHAR | 60 | ||||
| OPT_IN_TELNR_MOBILE | CHAR | 2 | ||||
| OPT_IN_TELNR_MOBILE_SMS | CHAR | 2 | ||||
| DATE_OF_BIRTH | Field of type DATS | DATS | DATS | 16 | ||
| ID_TW | CHAR | 80 | ||||
| OPT_IN_TW | CHAR | 80 | ||||
| ID_FB | CHAR | 80 | ||||
| OPT_IN_FB | CHAR | 80 | ||||
| ID_GP | CHAR | 80 | ||||
| OPT_IN_GP | CHAR | 80 | ||||
| ID_ERP_CONTACT | CHAR | 80 | ||||
| SMTP_ADDR_2 | CHAR | 80 | ||||
| OPT_IN_SMTP_ADDR_2 | CHAR | 80 | ||||
| SMTP_ADDR_3 | CHAR | 80 | ||||
| OPT_IN_SMTP_ADDR_3 | CHAR | 80 | ||||
| BOOLEAN1 | CHAR | 80 | ||||
| BOOLEAN2 | CHAR | 80 | ||||
| BOOLEAN3 | CHAR | 80 | ||||
| BOOLEAN4 | CHAR | 80 | ||||
| TIME1 | CHAR | 80 | ||||
| DATE1 | CHAR | 80 | ||||
| NUMBER1 | CHAR | 80 | ||||
| NUMBER2 | CHAR | 80 | ||||
| TEXT20_1 | CHAR | 80 | ||||
| TIMESTAMP1 | CHAR | 80 | ||||
| DECIMAL1 | CHAR | 80 | ||||
| DECIMAL2 | CHAR | 80 | ||||
| TEXT40_1 | CHAR | 80 |