SAP ABAP Table JHATPSI (OPM Prod.Sched.Line - Actual Message with Plnd/Act Variation)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JHATPSI	Table Relationship Diagram
Short Description	OPM Prod.Sched.Line - Actual Message with Plnd/Act Variation

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	JHAE
6	ISTMELD_NR	☑	ISTMELD_NR	NUMC6	NUMC	6	0	IS-M: Actual Message Number from Technical System
7	.INCLUDE	☐				0	0	IS-M: Include for ad.production sched.line - actual message
8	AENVERS_NR	☐	AENVERS_NR	AENVERS_NR	NUMC	4	0	IS-M: Last Change Version for Technical System
9	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
10	STATUSPROD	☐	STATUSPROD	PAM_STATUS	CHAR	2	0	IS-M: Ad Production Status
11	STATUSPLAZ	☐	STATUSPLAZ	PAM_STATUS	CHAR	2	0	IS-M: Positioning status
12	MOTIV	☐	MOTIV_NR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Number (Ad)	*
13	MOTIVID	☐	MOTIVID	MOTIVID	CHAR	12	0	IS-M: Assigned ad spec/ad spec file in technical system
14	BELEGEINH	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
15	VAUSGB	☐	VAUSGB	VAUSGB	CHAR	10	0	Issue	JDTVAUSGB
16	E_TERMIN	☐	E_TERMIN	DATUM	DATS	8	0	IS-M: Publication Date
17	INHK_PLAZ	☐	INHK_PLAZ	INHALTSKOM	CHAR	8	0	IS-M: Positioning content component	JJTIKO
18	INHK_SOVER	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
19	FARB_SEITE	☐	FARB_SEITE	AZART_FARB	CHAR	4	0	IS-M: Actual Page Color Scheme	TJJ11
20	PLAZ_SEITE	☐	PLAZ_SV	PLAZSEITE	CHAR	4	0	IS-M: Positioning - From-Page Number
21	PLAZ_SB	☐	PLAZ_SB	PLAZSEITE	CHAR	4	0	IS-M: Positioning - To-Page Number
22	PLAZ_POS	☐	PLAZ_POS	PLAZPOS	CHAR	6	0	IS-M: Position on Page for Technical System	*
23	PLAZ_SLAGE	☐	PLAZ_SLAGE	PLAZLAGE	CHAR	2	0	IS-M: Position on Page	TJJAB
24	PLAZ_ART	☐	PLAZ_ART	PLAZARTIK	CHAR	8	0	IS-M: Name of Article for Positioning
25	E_HEFT	☐	E_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Publication Copy Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHATPSI	AVM_NR	JHAK	AVM_NR	KEY	1	CN
2	JHATPSI	BELEGEINH	JJTBE	BELEINH	REF	1	CN
3	JHATPSI	EIN_NR	JHAE	EIN_NR	KEY	1	CN
4	JHATPSI	FARB_SEITE	TJJ11	AZART_FARB	REF	1	CN
5	JHATPSI	INHK_PLAZ	JJTIKO	INHALTSKOM	REF	1	CN
6	JHATPSI	INHK_SOVER	JJTIKO	INHALTSKOM	REF	1	CN
7	JHATPSI	MANDT	T000	MANDT	KEY	1	CN
8	JHATPSI	PLAZ_SLAGE	TJJAB	PLAZ_SLAGE	REF	1	CN
9	JHATPSI	POS_NR	JHAP	POS_NR	KEY	1	CN
10	JHATPSI	UPOS_NR	JHAU	UPOS_NR	KEY	1	CN
11	JHATPSI	VAUSGB	JDTVAUSGB	VAUSGB	REF	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in