SNWD_CEI_B2C - EPM HANA: CEI DG POC - Business Partner Table (non-EPM)
EPM HANA: CEI DG POC - Business Partner Table (non-EPM) information is stored in SAP table SNWD_CEI_B2C.
It is part of development package S_EPM_HANA_EXT_DDIC_CEI in software component BC-SRV-NWD. This development package consists of objects that can be grouped under "EPM HANA: CEI specific DDIC artifacts".
It is part of development package S_EPM_HANA_EXT_DDIC_CEI in software component BC-SRV-NWD. This development package consists of objects that can be grouped under "EPM HANA: CEI specific DDIC artifacts".
Fields for table SNWD_CEI_B2C
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| 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_SHORT | CHAR | 6 | ||||
| COUNTRY_LONG | CHAR | 80 | ||||
| CITY | CHAR | 80 | ||||
| STATE | CHAR | 80 | ||||
| STREET | CHAR | 128 | ||||
| STREET_NO | CHAR | 10 | ||||
| PHONE | CHAR | 60 | ||||
| MOBILE | CHAR | 60 | ||||
| CHAR | 100 | |||||
| HOBBY | CHAR | 40 | ||||
| MARITAL_STATUS | CHAR | 20 | ||||
| LOYALITY_STATUS | CHAR | 20 | ||||
| CHILDREN | INT4 | 4 | ||||
| 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 |