SAP ABAP Table JHWWWTEMP_ORDER (IS-M/AM: Temporary Table for Order Data from the Internet)

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	JHWWWTEMP_ORDER	Table Relationship Diagram
Short Description	IS-M/AM: Temporary Table for Order Data from the Internet

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	*
2	SESSIONNO	☑	SESSIONNO	SESSIONNO	CHAR	10	0	IS-M: Key for Temporary Storage of Internet Data
3	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
4	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
5	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
6	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
7	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
8	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
9	ERSCH_T	☐	ERSCH_T	DATUM	DATS	8	0	IS-M: Publication Date
10	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
11	VORL_POSNR	☐	VORL_POSNR	AVM_PNR	NUMC	3	0	IS-M: Item number of the Preceding Item	*
12	.INCLUDE	☐				0	0	IS-M/AM: IAC Enter Classified Ad: Ad Spec Data (Temp.Table)
13	JWWWKEY	☐	JWWWKEY_JHAW	JWWWKEY_IAC	CHAR	10	0	IS-M/AM: Key for Order Data	*
14	AVM_NR	☐	AVM_NR_WITHOUT_SEARCHHELP	AVM_NR	CHAR	10	0	IS-M: Order	*
15	MOTIV	☐	MOTIV_NR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Number (Ad)	*
16	TEC_AVM_NR	☐	TEC_AVM_NR	CHAR10	CHAR	10	0	IS-M: Order number in technical system
17	MOTIVID	☐	MOTIVID	MOTIVID	CHAR	12	0	IS-M: Assigned ad spec/ad spec file in technical system
18	BELEGEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
19	INHK_KLEV1	☐	INHK_PUBREL	INHALTSKOM	CHAR	8	0	IS-M: Publication-Relevant Content Component	JJTIKO
20	AZART_GEST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
21	AZFARB_IST	☐	AZFARB_IST	AZART_FARB	CHAR	4	0	IS-M: Actual Color Scheme Ad Type	TJJ11
22	GRUNFARBEI	☐	FARBNAME	FARBNAME	CHAR	8	0	IS-M: Color Name	TJH33
23	FARBNAME1I	☐	FARBNAME	FARBNAME	CHAR	8	0	IS-M: Color Name	TJH33
24	FARBNAME2I	☐	FARBNAME	FARBNAME	CHAR	8	0	IS-M: Color Name	TJH33
25	FARBNAME3I	☐	FARBNAME	FARBNAME	CHAR	8	0	IS-M: Color Name	TJH33
26	SEITE_FSP	☐	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	TJJ47
27	XANSCHNITT	☐	XANSCHNITT	XFELD	CHAR	1	0	IS-M: Bled Ad Spec Indicator
28	XUEBERBUND	☐	XUEBERBUND	XFELD	CHAR	1	0	IS-M: Indicates That The Ad Spec Overlaps Gutter Margin
29	HOEHE_I	☐	HOEHE_ITMM	GROESSETMM	NUMC	7	0	IS-M: Actual Ad Spec Height to a Thousandth of a Unit of M.
30	HOEHE_I_EH	☐	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	TJH61
31	BREITE_I	☐	BREITEITMM	GROESSETMM	NUMC	7	0	IS-M: Actual Ad Spec Width to Thousandth of UM
32	BREITE_IEH	☐	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	TJH57
33	ANZWORT1_I	☐	ANZWOERTER	GROESSETMM	NUMC	7	0	IS-M: Number of Words in a Text-Based Ad in Units of 1000
34	ANZWORT2_I	☐	ANZWOERTER	GROESSETMM	NUMC	7	0	IS-M: Number of Words in a Text-Based Ad in Units of 1000
35	ANZZEIL1_I	☐	ANZZEILEN	GROESSETMM	NUMC	7	0	IS-M: Number of Lines for a Line-Based Ad in Units of 1000
36	ANZZEIL2_I	☐	ANZZEILEN	GROESSETMM	NUMC	7	0	IS-M: Number of Lines for a Line-Based Ad in Units of 1000
37	ANZZEICH_I	☐	ANZZEICHEN	GROESSETMM	NUMC	7	0	IS-M: No.of Characters for a Char.-Based Ad (1000 Units)
38	TYPO_NR_IS	☐	TYPO_NR	TYPONR	CHAR	8	0	IS-M: Typography Number
39	RAHMENTYPI	☐	RAHMENTYP	RAHMENTYP	CHAR	8	0	IS-M: Border Type	TJH35
40	RAHMENSTAI	☐	RAHMENSTAE	NUM2	NUMC	2	0	IS-M: Border Width
41	RAHMENEINH	☐	RAHMENEINH	MEINS	UNIT	3	0	IS-M: Unit of measurement for border width	T006
42	TEXTSPITZE	☐	TEXTSPITZE	TEXT25	CHAR	25	0	IS-M: Ad Text Header
43	INVERSKNZI	☐	INVERSKNZ	XFELD	CHAR	1	0	IS-M: Reversed Indicator
44	RASTER_IST	☐	RASTERUNG	RASTERUNG	CHAR	2	0	IS-M: Grid Spacing	TJH37
45	MOTIV_URL	☐	MOTIV_URL	TEXT255	CHAR	255	0	IS-M/AM: URL for Ad Spec
46	CHIFFRE_NR	☐	CHIFFRE	CHIFFRE_NR	CHAR	10	0	IS-M/AM: Box Number
47	CHIFFRE_KZ	☐	CHIFFRE_KZ	CHIFFRE_KZ	CHAR	1	0	IS-M: Box Number Indicator	TJH59
48	CHIFFRE_OR	☐	CHIFFRE_OR	VKBUR	CHAR	4	0	IS-M: Box Number Location	TVBUR
49	VORL_AVMNR	☐	VORL_AVMNR	AVM_NR	CHAR	10	0	IS-M: Order Number of the Preceding Document	*
50	VORL_MOTNR	☐	VORL_MOTNR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Template (Ad)	*
51	VORL_TECID	☐	VORL_TECID	MOTIVID	CHAR	12	0	IS-M: Ad spec template (description in technical system)
52	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	*
53	XAGENTUR	☐	XAGENTUR	XFELD	CHAR	1	0	IS-M: Agency Indicator
54	.INCLUDE	☐				0	0	IS-M/SD: Structure for WWW, Payment Data
55	ZLSCH	☐	JZLSCH	ZLSCH	CHAR	1	0	IS-M: Payment Method	*
56	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
57	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
58	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
59	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
60	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
61	XSEPAACTIVE	☐	XSEPAACTIVE	XFELD	CHAR	1	0	IS-M: Create SEPA Mandate with the Active Status
62	SIGN_CITY	☐	SEPA_SIGN_CITY	TEXT40	CHAR	40	0	Location of Signature
63	SIGN_DATE	☐	SEPA_SIGN_DATE	DATUM	DATS	8	0	Date of Signature
64	BANKA	☐	BANKA	TEXT60	CHAR	60	0	Name of bank
65	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
66	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
67	.INCLUDE	☐				0	0	Credit Card Encryption
68	CGUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
69	ENCTP	☐	CCSECA_ENCTYPE	CCSECA_ENCTYPE	CHAR	1	0	Type of Encryption
70	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
71	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
72	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
73	CCTYP	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	*
74	BKVID	☐	BU_BKVID	CHAR4	CHAR	4	0	Bank details ID
75	CCNAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
76	AUDAT	☐	AUDAT_CC	DATUM	DATS	8	0	Payment cards: Authorization date
77	AUTIM	☐	AUTIM	UZEIT	TIMS	6	0	Payment cards: Authorization time
78	AUNUM	☐	AUNUM	CHAR10	CHAR	10	0	Payment cards: Authorization number
79	AUTRA	☐	AUTRA	CHAR15	CHAR	15	0	Payment cards: Authoriz. reference code of clearing house
80	.INCLUDE	☐				0	0	Card Verification Value
81	ISM_CVVAL	☐	ISM_CVVAL	ISM_CVVAL	CHAR	6	0	Card Verification Value
82	ISM_CVVCT	☐	ISM_CVVCT	ISM_CVVCT	CHAR	1	0	Control Field for Card Verification Value
83	ISM_CVVST	☐	ISM_CVVST	ISM_CVVST	CHAR	1	0	Usage Status of Card Verification Value
84	.INCLUDE	☐				0	0	Response for Card Verification Value
85	ISM_RCCVV	☐	ISM_RCCVV_CC	CHAR4	CHAR	4	0	Results Check for Card Verification Value	TCCRC
86	.INCLU-_1	☐				0	0	IS-M: Additional Payments
87	ADDPAY_TYPE_1	☐	ISM_ADDPAYMENT_TYPE	ISM_ADDPAYMENT_TYPE	CHAR	2	0	IS-M/SD: Additional Payment Type	TJK21
88	ADDPAY_VALUE_1	☐	ISM_ADDPAYMENT_VALUE	WERT5	CURR	9	2	IS-M/SD: Additional Payment Amount
89	WAERK_1	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
90	XNONRECURRING_1	☐	ISM_ADDPAYMENT_XNONRECURRING	XFELD	CHAR	1	0	IS-M/SD: One-Time Additional Payment
91	XRECURRING_1	☐	ISM_ADDPAYMENT_XRECURRING	XFELD	CHAR	1	0	IS-M/SD: Additional Payment is Repeated Periodically
92	.INCLU-_2	☐				0	0	IS-M: Additional Payments
93	ADDPAY_TYPE_2	☐	ISM_ADDPAYMENT_TYPE	ISM_ADDPAYMENT_TYPE	CHAR	2	0	IS-M/SD: Additional Payment Type	TJK21
94	ADDPAY_VALUE_2	☐	ISM_ADDPAYMENT_VALUE	WERT5	CURR	9	2	IS-M/SD: Additional Payment Amount
95	WAERK_2	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
96	XNONRECURRING_2	☐	ISM_ADDPAYMENT_XNONRECURRING	XFELD	CHAR	1	0	IS-M/SD: One-Time Additional Payment
97	XRECURRING_2	☐	ISM_ADDPAYMENT_XRECURRING	XFELD	CHAR	1	0	IS-M/SD: Additional Payment is Repeated Periodically
98	.INCLUDE	☐				0	0	IS-M: Message Data
99	MSGID	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
100	MSGNO	☐	SYMSGNO	SYMSGNO	NUMC	3	0	Message Number
101	MSGTY	☐	SYMSGTY	SYCHAR01	CHAR	1	0	Message Type
102	.INCLUDE	☐				0	0	IS-M: Message Variables
103	MSGV1	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
104	MSGV2	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
105	MSGV3	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
106	MSGV4	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
107	XINET_USER	☐	XINET_USER	XFELD	CHAR	1	0	Create Internet User with Password for BP
108	PASSWORD_BP	☐	XUNCODE	XUBCODE	CHAR	40	0	New password
109	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
110	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
111	NATXTP	☐	JNATXTP	CHAR100	CHAR	100	0	Message Text with Parameters Used
112	ICON_STATUS	☐	ICON_L4	ICON	CHAR	4	0	Icon with output length 4	*
113	USERALIAS	☐	USALIAS	USALIAS	CHAR	40	0	Internet user alias
114	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
115	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
116	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
117	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHWWWTEMP_ORDER	ADDPAY_TYPE_1	TJK21	ADDPAYMENT_TYPE
2	JHWWWTEMP_ORDER	ADDPAY_TYPE_2	TJK21	ADDPAYMENT_TYPE
3	JHWWWTEMP_ORDER	AUART	TJHAK	AUART	REF	1	CN
4	JHWWWTEMP_ORDER	AZART_GEST	TJJ19	AZART_GEST	REF	1	CN
5	JHWWWTEMP_ORDER	AZFARB_IST	TJJ11	AZART_FARB	REF	1	CN
6	JHWWWTEMP_ORDER	BELEGEINH	JJTBE	BELEINH	REF	1	CN
7	JHWWWTEMP_ORDER	BREITE_IEH	TJH57	ISPEINHEIT	REF	1	CN
8	JHWWWTEMP_ORDER	CHIFFRE_KZ	TJH59	CHIFFRE_KZ	REF	1	CN
9	JHWWWTEMP_ORDER	CHIFFRE_OR	TVBUR	VKBUR	REF	1	CN
10	JHWWWTEMP_ORDER	FARBNAME1I	TJH33	FARBNAME	REF	1	CN
11	JHWWWTEMP_ORDER	FARBNAME2I	TJH33	FARBNAME	REF	1	CN
12	JHWWWTEMP_ORDER	FARBNAME3I	TJH33	FARBNAME		1	CN
13	JHWWWTEMP_ORDER	GRUNFARBEI	TJH33	FARBNAME	REF	1	CN
14	JHWWWTEMP_ORDER	HOEHE_I_EH	TJH61	ISPEINH_H	REF	1	CN
15	JHWWWTEMP_ORDER	INHK_KFM	JJTIKO	INHALTSKOM	REF	1	CN
16	JHWWWTEMP_ORDER	INHK_KLEV1	JJTIKO	INHALTSKOM	REF	1	CN
17	JHWWWTEMP_ORDER	ISM_RCCVV	TCCRC	RCODE
18	JHWWWTEMP_ORDER	RAHMENEINH	T006	MSEHI	REF	1	CN
19	JHWWWTEMP_ORDER	RAHMENTYPI	TJH35	RAHMENTYP	REF	1	CN
20	JHWWWTEMP_ORDER	RASTER_IST	TJH37	RASTER	REF	1	CN
21	JHWWWTEMP_ORDER	SEITE_FSP	TJJ47	SEITE_FSP	REF	1	CN
22	JHWWWTEMP_ORDER	SPART	TSPA	SPART	REF	1	CN
23	JHWWWTEMP_ORDER	VKBUR	TVBUR	VKBUR	REF	1	CN
24	JHWWWTEMP_ORDER	VKGRP	TVKGR	VKGRP	REF	1	CN
25	JHWWWTEMP_ORDER	VKORG	TVKO	VKORG	REF	1	CN
26	JHWWWTEMP_ORDER	VTWEG	TVTW	VTWEG	REF	1	CN
27	JHWWWTEMP_ORDER	WAEHRG	TCURC	WAERS

History

Last changed by/on	SAP	20131127
SAP Release Created in	462