SAP ABAP Table JHV_MOT_ALI01 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHV_MOT_ALI01	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	AVM_NR	☑	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
3	POS_NR	☑	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
4	UPOS_NR	☑	UPOS_NR	AVM_UPNR	NUMC	4	0	IS-M: Order Sub-Item Number	JHAU
5	EIN_NR	☑	EIN_NR	AVMENR	NUMC	6	0	IS-M: Schedule Line	JHAEA
6	MOTIV	☑	MOTIV_NR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Number (Ad)	JHAMOT
7	MOTIVID	☐	MOTIVID	MOTIVID	CHAR	12	0	IS-M: Assigned ad spec/ad spec file in technical system
8	AZART_SOND	☐	AZART_SOND	AZART_SOND	CHAR	2	0	IS-M: Ad Type - Special Handling Type	TJJ49
9	AZART_GEST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
10	AZART_FORM	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	TJJ17
11	AZART_AREA	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	TJJ13
12	HOEHE_I	☐	HOEHE_I	GROESSE	QUAN	7	3	IS-M: Actual height of the ad spec
13	HOEHE_I_EH	☐	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	TJH61
14	BREITE_I	☐	BREITE_I	GROESSE	QUAN	7	3	IS-M: Actual Ad Spec Width
15	BREITE_IEH	☐	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	TJH57
16	HOEHE_S	☐	HOEHE_S	GROESSE	QUAN	7	3	IS-M: Planned Height of the Ad Spec
17	HOEHE_S_EH	☐	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	TJH61
18	BREITE_S	☐	BREITE_S	GROESSE	QUAN	7	3	IS-M: Planned Ad Spec Width
19	BREITE_SEH	☐	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	TJH57
20	AZART_FARB	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	TJJ11
21	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
22	XPRNOTW	☐	XPRNOTW	XFELD	CHAR	1	0	IS-M: Ad Spec Check Required But Not Performed
23	XPRINHNOTW	☐	XPRINHNOTW	XFELD	CHAR	1	0	IS-M: Content Check Required But Not Performed
24	XKUNK_NOTW	☐	XKUNK_NOTW	XFELD	CHAR	1	0	IS-M: Customer correction necessary but not performed
25	XMOTPROD	☐	XMOTPROD	XFELD	CHAR	1	0	IS-M: Ad Spec Technically Complete Indicator
26	XDIFF_SIZE	☐	XDIFF_SIZE	XFELD	CHAR	1	0	IS-M: Alternative Actual Size
27	MOTIVSTAT	☐	MOTIVSTAT	PAM_STATUS	CHAR	2	0	IS-M: Ad spec status
28	XUVMOT	☐	XUVMOT	XFELD	CHAR	1	0	IS-M: "Ad spec data incomplete" indicator
29	SEITE_FSP	☐	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	TJJ47
30	NOTIZ	☐	MOTIVNOTIZ	TEXT50	CHAR	50	0	IS-M: Note for Ad Spec Design
31	TEXTSPITZE	☐	TEXTSPITZE	TEXT25	CHAR	25	0	IS-M: Ad Text Header
32	RULE_GROUP_CV	☐	ISM_RULE_GROUP_CV_AMC	ISM_RULE_GROUP_CV_AMC	CHAR	20	0	IS-M: Ad Content Validation Rule Group in IS-M/AMC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHV_MOT_ALI01	AVM_NR	JHAK	AVM_NR		1	CN
2	JHV_MOT_ALI01	AZART_AREA	TJJ13	AZART_AREA	REF	1	CN
3	JHV_MOT_ALI01	AZART_FARB	TJJ11	AZART_FARB
4	JHV_MOT_ALI01	AZART_FORM	TJJ17	AZART_FORM	REF	1	CN
5	JHV_MOT_ALI01	AZART_GEST	TJJ19	AZART_GEST	REF	1	CN
6	JHV_MOT_ALI01	AZART_SOND	TJJ49	AZART_SOND	REF	1	CN
7	JHV_MOT_ALI01	BREITE_IEH	TJH57	ISPEINHEIT	REF	1	CN
8	JHV_MOT_ALI01	BREITE_SEH	TJH57	ISPEINHEIT	REF	1	CN
9	JHV_MOT_ALI01	EIN_NR	JHAEA	EIN_NR	KEY	1	C
10	JHV_MOT_ALI01	HOEHE_I_EH	TJH61	ISPEINH_H	REF	1	CN
11	JHV_MOT_ALI01	HOEHE_S_EH	TJH61	ISPEINH_H	REF	1	CN
12	JHV_MOT_ALI01	MANDT	T000	MANDT		1	CN
13	JHV_MOT_ALI01	MOTIV	JHAMOT	MOTIV		1	CN
14	JHV_MOT_ALI01	POS_NR	JHAP	POS_NR		1	CN
15	JHV_MOT_ALI01	SEITE_FSP	TJJ47	SEITE_FSP	REF	1	CN
16	JHV_MOT_ALI01	UPOS_NR	JHAU	UPOS_NR	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in