SAP ABAP Table SEPM_SDDL_PROD (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure SEPM_SDDL_PROD   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 PRODUCT_KEY SNWD_NODE_KEY SYSUUID RAW 16   0   EPM: Generic Node Key  
3 PRODUCT_ID SNWD_PRODUCT_ID   CHAR 10   0   EPM: Product ID  
4 TYPE_CODE SNWD_PRODUCT_TYPE_CODE D_PR_TYPE CHAR 2   0   EPM: Product Type Code  
5 CATEGORY SNWD_PRODUCT_CATEGORY D_PD_CAT CHAR 40   0   EPM: Product Category SNWD_PD_CATGOS
6 CREATED_BY_EMPLOYEE_KEY SNWD_NODE_KEY SYSUUID RAW 16   0   EPM: Generic Node Key SNWD_EMPLOYEES
7 CHANGED_BY_EMPLOYEE_KEY SNWD_NODE_KEY SYSUUID RAW 16   0   EPM: Generic Node Key SNWD_EMPLOYEES
8 CREATED_AT TIMESTAMPL TZNTSTMPL DEC 21   7   UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)  
9 CHANGED_AT TIMESTAMPL TZNTSTMPL DEC 21   7   UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)  
10 PRODUCT_NAME_KEY SNWD_NODE_KEY SYSUUID RAW 16   0   EPM: Generic Node Key SNWD_TEXT_KEY
11 PRODUCT_DESCRIPTION_KEY SNWD_NODE_KEY SYSUUID RAW 16   0   EPM: Generic Node Key SNWD_TEXT_KEY
12 SUPPLIER_KEY SNWD_NODE_KEY SYSUUID RAW 16   0   EPM: Generic Node Key SNWD_BPA
13 TAX_TARIF_CODE SNWD_PRODUCT_TAX_TARIF_CODE D_PR_TAX INT1 3   0   EPM: Product Tax Tariff Code  
14 MEASURE_UNIT SNWD_QUANTITY_UNIT MEINS UNIT 3   0   EPM: Quantity Unit T006
15 WEIGHT_UNIT SNWD_WEIGHT_UNIT MEINS UNIT 3   0   EPM: Weight Unit T006
16 WEIGHT_MEASURE SNWD_WEIGHT_MEASURE MENG13 QUAN 13   3   EPM: Weight Measure  
17 CURRENCY_CODE SNWD_CURR_CODE   CUKY 5   0   EPM: Currency Code  
18 PRICE SNWD_UNIT_PRICE   CURR 15   2   EPM: Product Unit Price  
19 PRODUCT_PIC_URL     CHAR 1333   0    
20 DIM_UNIT SNWD_DIM_UNIT MEINS UNIT 3   0   EPM: Dimension Unit T006
21 WIDTH SNWD_DIMENSION MENG13 QUAN 13   3   EPM: Dimension  
22 DEPTH SNWD_DIMENSION MENG13 QUAN 13   3   EPM: Dimension  
23 HEIGHT SNWD_DIMENSION MENG13 QUAN 13   3   EPM: Dimension  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SEPM_SDDL_PROD CATEGORY SNWD_PD_CATGOS CATEGORY 1 CN
2 SEPM_SDDL_PROD CHANGED_BY_EMPLOYEE_KEY SNWD_EMPLOYEES NODE_KEY 1 CN
3 SEPM_SDDL_PROD CREATED_BY_EMPLOYEE_KEY SNWD_EMPLOYEES NODE_KEY 1 CN
4 SEPM_SDDL_PROD DIM_UNIT T006 MSEHI 1 CN
5 SEPM_SDDL_PROD MANDT T000 MANDT 1 CN
6 SEPM_SDDL_PROD MEASURE_UNIT T006 MSEHI 1 CN
7 SEPM_SDDL_PROD PRODUCT_DESCRIPTION_KEY SNWD_TEXT_KEY NODE_KEY    
8 SEPM_SDDL_PROD PRODUCT_NAME_KEY SNWD_TEXT_KEY NODE_KEY    
9 SEPM_SDDL_PROD SUPPLIER_KEY SNWD_BPA NODE_KEY KEY 1 CN
10 SEPM_SDDL_PROD WEIGHT_UNIT T006 MSEHI 1 CN
History
Last changed by/on DDIC  20150523 
SAP Release Created in