SAP ABAP View RMXTW_PRODH (Find Trials by Product Hierarchy)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PLM-RM (Application Component) Recipe Management
     ⤷ RMXTAPI (Package) Main Package - Trial: API, Database, Customizing

Basic Data

View Type	D	Database View
Database View	RMXTW_PRODH
Short Description	Find Trials by Product Hierarchy
Root table	MARA	General Material Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MARA	MARA
2	RMXTT_TRIAL_HD

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MARA	MANDT	JL	EQ				0	0
2	RMXTT_TRIAL_HD	MANDT	JR	EQ			AND	0	0
3	MARA	MATNR	JL	EQ				0	0
4	RMXTT_TRIAL_HD	PRODUCT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	MARA	MANDT		☐	MANDT	☐	Client
2	MATNR	MARA	MATNR		☐	MATNR	☐	Material Number
3	PRDHA	MARA	PRDHA		☐	PRODH_D	☐	Product Hierarchy
4	TRIALID	RMXTT_TRIAL_HD	TRIALID		☐	RMXTE_TRIALID	☐	Trial Number
5	TRIALTYPE	RMXTT_TRIAL_HD	TRIALTYPE		☐	RMXTE_TRIALTYPE	☐	Trial Type
6	OBJNR	RMXTT_TRIAL_HD	OBJNR		☐	J_OBJNR	☐	Object number
7	TRIALNAME	RMXTT_TRIAL_HD	TRIALNAME		☐	RMXTE_TRIALNAME	☐	Trial Name
8	PRODUCT	RMXTT_TRIAL_HD	PRODUCT		☐	MATNR	☐	Material Number
9	PLANT	RMXTT_TRIAL_HD	PLANT		☐	WERKS_D	☐	Plant
10	PROJECT	RMXTT_TRIAL_HD	PROJECT		☐	RMXTE_PS_POSNR	☐	WBS Element
11	BATCH	RMXTT_TRIAL_HD	BATCH		☐	CHARG_D	☐	Batch Number
12	LINE	RMXTT_TRIAL_HD	LINE		☐	RMXTE_RESSOURCE	☐	Resource
13	RESPONSIBLE	RMXTT_TRIAL_HD	RESPONSIBLE		☐	RCPE_REALO	☐	Responsibility
14	ORGID	RMXTT_TRIAL_HD	ORGID		☐	OTYPE	☐	Object Type
15	SOURCE_RCP	RMXTT_TRIAL_HD	SOURCE_RCP		☐	RMXTE_GUID	☐	Globally Unique Identifier
16	RCP_AENNR	RMXTT_TRIAL_HD	RCP_AENNR		☐	AENNR	☐	Change Number
17	DAY_REQ_START	RMXTT_TRIAL_HD	DAY_REQ_START		☐	RMXTE_REQ_START	☐	Requested Date (Start) for Trial
18	DAY_REQ_END	RMXTT_TRIAL_HD	DAY_REQ_END		☐	RMXTE_REQ_END	☐	Requested Date (End) for Trial
19	DAY_SHD_START	RMXTT_TRIAL_HD	DAY_SHD_START		☐	RMXTE_SHD_START	☐	Planned Date (Start) for Trial
20	DAY_SHD_END	RMXTT_TRIAL_HD	DAY_SHD_END		☐	RMXTE_SHD_END	☐	Planned Date (End) for Trial
21	DAY_EXE_START	RMXTT_TRIAL_HD	DAY_EXE_START		☐	RMXTE_EXE_START	☐	Execution Date (Start) of Trial
22	DAY_EXE_END	RMXTT_TRIAL_HD	DAY_EXE_END		☐	RMXTE_EXE_END	☐	Execution Date (End) of Trial
23	ADM_CREA_BY	RMXTT_TRIAL_HD	ADM_CREA_BY		☐	RMXTE_CREA_BY	☐	Created by
24	ADM_CREA_AT	RMXTT_TRIAL_HD	ADM_CREA_AT		☐	RMXTE_CREA_AT	☐	Created on
25	ADM_CHG_BY	RMXTT_TRIAL_HD	ADM_CHG_BY		☐	RMXTE_CHG_BY	☐	Changed by
26	ADM_CHG_AT	RMXTT_TRIAL_HD	ADM_CHG_AT		☐	RMXTE_CHG_AT	☐	Changed on

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	471