SAP ABAP View /SAPNEA/JSCDIEV3 (View for die master)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ MM (Application Component) Materials Management
     ⤷ /SAPNEA/J_SC1 (Package) Subcontracting Management

Basic Data

View Type	D	Database View
Database View	/SAPNEA/JSCDIEV3
Short Description	View for die master
Root table	/SAPNEA/JSCDIE	Die management master table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	/SAPNEA/JSCDIE	/SAPNEA/JSCDIE
2	/SAPNEA/JSCDIEH
3	/SAPNEA/JSCDIET
4	LFA1
5	/SAPNEA/JSCDIEI
6	MARA
7	T001W
8	MAKT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	/SAPNEA/JSCDIE	MANDT	JL	EQ				0	0
2	/SAPNEA/JSCDIEH	MANDT	JR	EQ			AND	0	0
3	/SAPNEA/JSCDIE	DIEID	JL	EQ				0	0
4	/SAPNEA/JSCDIEH	DIEID	JR	EQ			AND	0	0
5	/SAPNEA/JSCDIE	MANDT	JL	EQ				0	0
6	/SAPNEA/JSCDIET	MANDT	JR	EQ			AND	0	0
7	/SAPNEA/JSCDIE	DIEID	JL	EQ				0	0
8	/SAPNEA/JSCDIET	DIEID	JR	EQ			AND	0	0
9	LFA1	MANDT	JL	EQ				0	0
10	/SAPNEA/JSCDIEH	MANDT	JR	EQ			AND	0	0
11	LFA1	LIFNR	JL	EQ				0	0
12	/SAPNEA/JSCDIEH	LIFNR	JR	EQ			AND	0	0
13	/SAPNEA/JSCDIEH	MANDT	JL	EQ				0	0
14	/SAPNEA/JSCDIEI	MANDT	JR	EQ			AND	0	0
15	/SAPNEA/JSCDIEH	DIEID	JL	EQ				0	0
16	/SAPNEA/JSCDIEI	DIEID	JR	EQ			AND	0	0
17	/SAPNEA/JSCDIEH	LIFNR	JL	EQ				0	0
18	/SAPNEA/JSCDIEI	LIFNR	JR	EQ			AND	0	0
19	MARA	MANDT	JL	EQ				0	0
20	/SAPNEA/JSCDIEI	MANDT	JR	EQ			AND	0	0
21	MARA	MATNR	JL	EQ				0	0
22	/SAPNEA/JSCDIEI	MATNR	JR	EQ			AND	0	0
23	T001W	MANDT	JL	EQ				0	0
24	/SAPNEA/JSCDIEI	MANDT	JR	EQ			AND	0	0
25	T001W	WERKS	JL	EQ				0	0
26	/SAPNEA/JSCDIEI	WERKS	JR	EQ			AND	0	0
27	MARA	MANDT	JL	EQ				0	0
28	MAKT	MANDT	JR	EQ			AND	0	0
29	MARA	MATNR	JL	EQ				0	0
30	MAKT	MATNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	/SAPNEA/JSCDIEH	MANDT		☐	MANDT	☐	Client
2	DIEID	/SAPNEA/JSCDIEH	DIEID		☐	/SAPNEA/J_SC_DIEID	☐	Die ID
3	LIFNR	/SAPNEA/JSCDIEH	LIFNR		☐	/SAPNEA/J_SC_LIFNR	☐	Subcon vendor
4	SPRAS	/SAPNEA/JSCDIET	SPRAS		☐	SPRAS	☐	Language Key
5	DTEXT	/SAPNEA/JSCDIET	DTEXT		☐	/SAPNEA/J_SC_DTEXT	☐	Die text
6	ERSDA	/SAPNEA/JSCDIEH	ERSDA		☐	ERSDA	☐	Created On
7	ERNAM	/SAPNEA/JSCDIEH	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
8	LAEDA	/SAPNEA/JSCDIEH	LAEDA		☐	LAEDA	☐	Date of Last Change
9	AENAM	/SAPNEA/JSCDIEH	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
10	DCOST	/SAPNEA/JSCDIEH	DCOST		☐	/SAPNEA/J_SC_DCOST	☐	Die cost
11	DCURR	/SAPNEA/JSCDIEH	DCURR		☐	/SAPNEA/J_SC_WAERS	☐	Currency key for die depreciation
12	DPPLN	/SAPNEA/JSCDIEH	DPPLN		☐	/SAPNEA/J_SC_DPPLN	☐	Depreciation quantity -planed
13	DPACT	/SAPNEA/JSCDIEH	DPACT		☐	/SAPNEA/J_SC_DPACT	☐	Depreciation quantity -actual
14	MEINS	/SAPNEA/JSCDIEH	MEINS		☐	/SAPNEA/J_SC_MEINS	☐	Base unit of measure for die depreciation
15	DATAB	/SAPNEA/JSCDIEH	DATAB		☐	DATAB	☐	Valid-From Date
16	DATBI	/SAPNEA/JSCDIEH	DATBI		☐	DATBI	☐	Valid To Date
17	DPCFG	/SAPNEA/JSCDIEH	DPCFG		☐	/SAPNEA/J_SC_DPCFG	☐	Depreciation completion flag
18	DPDFG	/SAPNEA/JSCDIEH	DPDFG		☐	/SAPNEA/J_SC_DPDFG	☐	Die deletion flag
19	DPCDA	/SAPNEA/JSCDIEH	DPCDA		☐	/SAPNEA/J_SC_DPCDA	☐	Date of depreciation complete
20	NAME1	LFA1	NAME1		☐	NAME1_GP	☐	Name 1
21	WERKS	/SAPNEA/JSCDIEI	WERKS		☐	WERKS_D	☐	Plant
22	MATNR	/SAPNEA/JSCDIEI	MATNR		☐	MATNR	☐	Material Number
23	P_NAME	T001W	NAME1		☐	NAME1	☐	Name
24	M_NAME	MAKT	MAKTX		☐	MAKTX	☐	Material description

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140121
SAP Release Created in