SAP ABAP Table SNWD_PD (EPM: Product Data Table)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-NWD (Application Component) NetWeaver Demonstration
     ⤷ S_NWDEMO_MODEL_DDIC (Package) Common Data Dictionary Objects (only) for EPM and NWDEMO

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SNWD_PD	Table Relationship Diagram
Short Description	EPM: Product Data Table

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	NODE_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	.INCLUDE	☐				0	0	EPM: Include-Structure for various tables
7	CREATED_BY	☐	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_BY	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_EMPLOYEES
10	CHANGED_AT	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
11	NAME_GUID	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_TEXT_KEY
12	DESC_GUID	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_TEXT_KEY
13	SUPPLIER_GUID	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_BPA
14	TAX_TARIF_CODE	☐	SNWD_PRODUCT_TAX_TARIF_CODE	D_PR_TAX	INT1	3	0	EPM: Product Tax Tariff Code
15	MEASURE_UNIT	☐	SNWD_QUANTITY_UNIT	MEINS	UNIT	3	0	EPM: Quantity Unit	T006
16	WEIGHT_MEASURE	☐	SNWD_WEIGHT_MEASURE	MENG13	QUAN	13	3	EPM: Weight Measure
17	WEIGHT_UNIT	☐	SNWD_WEIGHT_UNIT	MEINS	UNIT	3	0	EPM: Weight Unit	T006
18	CURRENCY_CODE	☐	SNWD_CURR_CODE		CUKY	5	0	EPM: Currency Code
19	PRICE	☐	SNWD_UNIT_PRICE		CURR	15	2	EPM: Product Unit Price
20	PRODUCT_PIC_URL	☐	SNWD_PRODUCT_PIC_URL		CHAR	255	0	EPM: URL of Product Image
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
24	DIM_UNIT	☐	SNWD_DIM_UNIT	MEINS	UNIT	3	0	EPM: Dimension Unit	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SNWD_PD	CATEGORY	SNWD_PD_CATGOS	CATEGORY		1	CN
2	SNWD_PD	CHANGED_BY	SNWD_EMPLOYEES	NODE_KEY		1	CN
3	SNWD_PD	CLIENT	T000	MANDT		1	CN
4	SNWD_PD	CREATED_BY	SNWD_EMPLOYEES	NODE_KEY		1	CN
5	SNWD_PD	DESC_GUID	SNWD_TEXT_KEY	NODE_KEY
6	SNWD_PD	DIM_UNIT	T006	MSEHI		1	CN
7	SNWD_PD	MEASURE_UNIT	T006	MSEHI		1	CN
8	SNWD_PD	NAME_GUID	SNWD_TEXT_KEY	NODE_KEY
9	SNWD_PD	SUPPLIER_GUID	SNWD_BPA	NODE_KEY	KEY	1	CN
10	SNWD_PD	WEIGHT_UNIT	T006	MSEHI		1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	720