SAP ABAP Table SEPM_BPA_ET (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure SEPM_BPA_ET   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 CUSTOMER_KEY SNWD_NODE_KEY SYSUUID RAW 16   0   EPM: Generic Node Key  
3 CUSTOMER_ID SNWD_PARTNER_ID D_EPM_ID CHAR 10   0   EPM: Business Partner ID  
4 BUSINESS_PARTNER_ROLE SNWD_BUSINESS_PARTNER_ROLE D_BP_ROLE CHAR 3   0   EPM: Business Partner Role  
5 EMAIL_ADDRESS SNWD_EMAIL_ADDRESS D_CHAR_255 CHAR 255   0   EPM: E-Mail Address  
6 PHONE_NUMBER SNWD_PHONE_NUMBER   CHAR 30   0   EPM: Phone Number  
7 FAX_NUMBER SNWD_PHONE_NUMBER   CHAR 30   0   EPM: Phone Number  
8 WEB_ADDRESS SNWD_STRING   STRG 0   0   EPM: String  
9 COMPANY_NAME SNWD_COMPANY_NAME TEXT80 CHAR 80   0   EPM: Company Name  
10 LEGAL_FORM SNWD_LEGAL_FORM CHAR10 CHAR 10   0   EPM: Legal Form of Business Partner  
11 ADDRESS_KEY SNWD_NODE_KEY SYSUUID RAW 16   0   EPM: Generic Node Key SNWD_AD
12 COUNTRY SNWD_COUNTRY LAND1 CHAR 3   0   EPM: Country Code T005
13 POSTAL_CODE SNWD_POSTAL_CODE CHAR10 CHAR 10   0   EPM: Postal Code  
14 CITY SNWD_CITY D_CHAR_40 CHAR 40   0   EPM: City  
15 STREET SNWD_STREET D_CHAR_60 CHAR 60   0   EPM: Street  
16 BUILDING SNWD_BUILDING CHAR10 CHAR 10   0   EPM: Building  
17 FIRST_NAME SNWD_FIRST_NAME D_CHAR_40 CHAR 40   0   EPM: First Name  
18 LAST_NAME SNWD_LAST_NAME D_CHAR_40 CHAR 40   0   EPM: Last Name  
19 GENDER SNWD_SEX D_MF CHAR 1   0   EPM: Sex  
20 DATE_OF_BIRTH SYDATUM SYDATS DATS 8   0   System Date  
21 CHILDREN SNWD_CHILDREN   INT4 10   0   EPM HANA: No of children  
22 AVG_CHILD_AGE SNWD_CHILDRENS_AVG_AGE   INT4 10   0   EPM HANA: Average age of children  
23 VEHICLES SNWD_VEHICLES   INT4 10   0   EPM HANA: Number of vehicles  
24 AVG_VEHICLE_VAL SNWD_VEHICLE_VALUE   INT4 10   0   EPM HANA: Average vehicle value  
25 FREQUENT_TRVLR SNWD_BOOL D_BOOL CHAR 1   0   EPM: Boolean  
26 CREDIT_CARD SNWD_BOOL D_BOOL CHAR 1   0   EPM: Boolean  
27 JOB_TYPE SNWD_JOB_TYPE   CHAR 100   0   EPM HANA: Job type  
28 FAMILY_MEMBERS SNWD_FAMILY_MEMBERS   INT4 10   0   EPM HANA: Number of family members  
29 WEALTH_RANKING SNWD_WEALTH_RANKING   INT4 10   0   EPM HANA: Wealth ranking  
30 INCOME SNWD_INCOME   INT4 10   0   EPM HANA: Income  
31 DISC_PROM_PARTIC SNWD_BOOL D_BOOL CHAR 1   0   EPM: Boolean  
32 LATITUDE SNWD_LATITUDE   FLTP 16   16   EPM HANA: Latitude  
33 LONGITUDE SNWD_LONGITUDE   FLTP 16   16   EPM HANA: Longitude  
34 CREATED_BY_EMPLOYEE_KEY SNWD_NODE_KEY SYSUUID RAW 16   0   EPM: Generic Node Key SNWD_EMPLOYEES
35 CREATED_AT TIMESTAMPL TZNTSTMPL DEC 21   7   UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)  
36 CHANGED_BY_EMPLOYEE_KEY SNWD_NODE_KEY SYSUUID RAW 16   0   EPM: Generic Node Key SNWD_EMPLOYEES
37 CHANGED_AT TIMESTAMPL TZNTSTMPL DEC 21   7   UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)  
38 CURRENCY_CODE SNWD_CURR_CODE   CUKY 5   0   EPM: Currency Code  
39 CREATED_BY_EMPLOYEE_ID SNWD_ID D_EPM_ID CHAR 10   0   EPM: Employee ID  
40 CREATED_BY_EMPLOYEE_FIRST_NAME SNWD_FIRST_NAME D_CHAR_40 CHAR 40   0   EPM: First Name  
41 CREATED_BY_EMPLOYEE_LAST_NAME SNWD_LAST_NAME D_CHAR_40 CHAR 40   0   EPM: Last Name  
42 CREATED_BY_EMPLOYEE_EMAIL SNWD_EMAIL_ADDRESS D_CHAR_255 CHAR 255   0   EPM: E-Mail Address  
43 CHANGED_BY_EMPLOYEE_ID SNWD_ID D_EPM_ID CHAR 10   0   EPM: Employee ID  
44 CHANGED_BY_EMPLOYEE_FIRST_NAME SNWD_FIRST_NAME D_CHAR_40 CHAR 40   0   EPM: First Name  
45 CHANGED_BY_EMPLOYEE_LAST_NAME SNWD_LAST_NAME D_CHAR_40 CHAR 40   0   EPM: Last Name  
46 CHANGED_BY_EMPLOYEE_EMAIL SNWD_EMAIL_ADDRESS D_CHAR_255 CHAR 255   0   EPM: E-Mail Address  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SEPM_BPA_ET ADDRESS_KEY SNWD_AD NODE_KEY 1 CN
2 SEPM_BPA_ET CHANGED_BY_EMPLOYEE_KEY SNWD_EMPLOYEES NODE_KEY 1 CN
3 SEPM_BPA_ET COUNTRY T005 LAND1 1 CN
4 SEPM_BPA_ET CREATED_BY_EMPLOYEE_KEY SNWD_EMPLOYEES NODE_KEY 1 CN
5 SEPM_BPA_ET MANDT T000 MANDT 1 CN
History
Last changed by/on DDIC  20150523 
SAP Release Created in