SAP ABAP Table JKWWWTEMP_ORDER (IS-M/SD: WWW Temporary Table for Order Data from Internet)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JKWWWTEMP_ORDER	Table Relationship Diagram
Short Description	IS-M/SD: WWW Temporary Table for Order Data from 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	.INCLUDE	☐				0	0	IS-M/SD: Structure for Internet Subscription Sales
4	.INCLUDE	☐				0	0	IS-M/SD: Structure for WWW, Fixed Order Values
5	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
6	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
7	SPART	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	TSPA
8	AUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
9	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
10	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
11	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
12	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
13	POART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
14	XNEGOPTION	☐	XNEGOPTION	XFELD	CHAR	1	0	IS-M: Item with Automatic Transformation to Chargeable
15	WERBEART	☐	WERBEART	WERBEART	CHAR	4	0	Sales Source	TJWAR
16	WERBEAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	TJWAK
17	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
18	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
19	RCODE	☐	RATE_CODE	RATE_CODE	CHAR	4	0	IS-M/SD: Rate Code	TJKRRC
20	KUENDGRD	☐	KUENDGRD	KUENDGRD	CHAR	3	0	Reason for end of delivery	TJK83
21	WERBTRAEG	☐	WERBTRAEG	WERBTRAEG	CHAR	10	0	Advertising Medium	TJW09
22	.INCLUDE	☐				0	0	IS-M/SD: Structure for WWW, Variable Order Values
23	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
24	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
25	BEZUGSTYP	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
26	LIEFERART	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
27	BEZPER	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	TJD09
28	BEZUGGRD	☐	BEZUGGRD	BEZUGGRD	CHAR	3	0	Purchase Reason	TJK87
29	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
30	FKPER	☐	FKPER	FKPER	CHAR	2	0	Billing Frequency	TJK01
31	ETMENGE	☐	ETMENGE_N	ETMENGE_N	NUMC	10	0	IS-M: Numerical Schedule Line Quantity
32	MATNR	☐	MATNR_SAPR	MATNR_ISP	CHAR	18	0	IS-M: Material number for gift	JMTMAT
33	XINET_USER	☐	XINET_USER	XFELD	CHAR	1	0	Create Internet User with Password for BP
34	XCANCELLATION	☐	XCANCELLATION	XFELD	CHAR	1	0	IS-M/SD: Right to Cancel Read for Subscription
35	XIMMATRIK	☐	XIMMATRIK	XFELD	CHAR	1	0	Indicator: Proof of matriculation provided
36	DUEDAY	☐	DUEDAY	DUEDAY	NUMC	2	0	IS-M/SD: Renewals, Due Day
37	XRECHDRUCK	☐	XRECHDRUCK	XFELD	CHAR	1	0	IS-M: Print Invoice
38	.INCLUDE	☐				0	0	IS-M/SD: Variant of IAC Subscription Sales: Data and Control
39	TEXT_IAC	☐	TEXTIAC_CONTROL	TEXT50	CHAR	50	0	IS-M: Text Describing Variant of an IAC
40	KEY_FIX	☐	JWWWKEY_FIX	JWWWKEY_FIX	CHAR	10	0	IS-M/SD: WWW, Key for Fixed Order Values	TJKWWW_FIX
41	KEY_VAR	☐	JWWWKEY_VAR	JWWWKEY_VAR	CHAR	10	0	IS-M/SD: WWW, Key for Variable Order Values	TJKWWW_VAR
42	XWEOBL	☐	XWEOBL	XFELD	CHAR	1	0	Alternative Ship-To Party Required in Order
43	XREOBL	☐	XREOBL	XFELD	CHAR	1	0	Alternative Bill-To Party Required in Order
44	XVM_NE_AG	☐	XVM_NE_AG	XFELD	CHAR	1	0	IS-M/SD: Sales Agent Cannot be Sold-To Party
45	KEY_CHECK_AG	☐	JWWWKEY_CHECK_AG	JWWWKEY_CHECK	CHAR	10	0	IS-M/SD: Key for Check to Identify Sold-To Party	TJKWWW_CHECK
46	KEY_CHECK_WE	☐	JWWWKEY_CHECK_WE	JWWWKEY_CHECK	CHAR	10	0	IS-M/SD: Key for Check to Identify Ship-To Party	TJKWWW_CHECK
47	KEY_CHECK_RE	☐	JWWWKEY_CHECK_RE	JWWWKEY_CHECK	CHAR	10	0	IS-M/SD: Key for Check to Identify Bill-To Party	TJKWWW_CHECK
48	KEY_CHECK_VM	☐	JWWWKEY_CHECK_VM	JWWWKEY_CHECK	CHAR	10	0	IS-M/SD: Key for Check to Identify Sales Agent	TJKWWW_CHECK
49	DATA_TARGET	☐	DATA_TARGET	DATA_TARGET	CHAR	1	0	IS-M: Destination for Saving Internet Data
50	XCCARD_TO_BP	☐	XCCARD_TO_BP	XFELD	CHAR	1	0	IS-M: WWW, Indicator - Save Credit Card Data with BP
51	VALDAYS	☐	JVALDAYS	NUMC03	NUMC	3	0	Validity Period in Days
52	VALISSUES	☐	JVALISSUES	NUMC3	NUMC	3	0	Validity Period in Copies
53	LAND1_INIT	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
54	ALIAS_HANDLING	☐	ALIAS_HANDLING	ALIAS_HANDLING	CHAR	1	0	IS-M: Setting to Determine User Name
55	FM_ALIAS_SYSTEM	☐	FM_ALIAS_SYSTEM	FUNCNAME	CHAR	30	0	IS-M: Function Module for Generating an Alias/User Name	*
56	PASSW_HANDLING	☐	PASSW_HANDLING	PASSW_HANDLING	CHAR	1	0	IS-M: Setting for Password and Access Data
57	IAC2CRM_CONNECT	☐	ISM_IAC2CRM_CONNECT	ISM_IAC2CRM_CONNECT	CHAR	1	0	IS-M: Connection Between IAC and CRM Mail Campaign
58	BPCRM_ROLE	☐	ISM_BPCRM_ROLE	ISM_BPCRM_ROLE	CHAR	2	0	IS-M/SD: Role of Cust. from CRM Mail Camp. in IAC Subs.Sales
59	XIAC_PROTOCOL	☐	XIAC_PROTOCOL	XFELD	CHAR	1	0	IS-M: Log Orders/Changes from Internet
60	JKTOKD_AG	☐	JKTOKD_AG	JKTOKD	CHAR	4	0	IS-M: Account Group for Creating Sold-To Party from Order	*
61	JKTOKD_WE	☐	JKTOKD_WE	JKTOKD	CHAR	4	0	IS-M: Create Account Group for Ship-To Party from Order	*
62	JKTOKD_RE	☐	JKTOKD_RE	JKTOKD	CHAR	4	0	IS-M: Create Account Group for Bill-To Party from Order	*
63	JKTOKD_VM	☐	JKTOKD_VM	JKTOKD	CHAR	4	0	IS-M: Create Account Group for Sales Agent from Order	*
64	UVADR_ACCEPT	☐	UVADR_ACCEPT	UVADR_ACCEPT	CHAR	1	0	IS-M: Accepted Coding Status for Address
65	DUBL_EMAIL	☐	ISM_WWW_DUBL	ISM_WWW_DUBL	CHAR	1	0	IS-M: IAC, Response for Duplicates
66	DUBL_TEL	☐	ISM_WWW_DUBL	ISM_WWW_DUBL	CHAR	1	0	IS-M: IAC, Response for Duplicates
67	GUELTIGVON	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
68	GUELTIGVON_INPUT	☐	GUELTIGVONIN	DATS	DATS	8	0	IS-M/SD: Desired Start Date of Order
69	GUELTIGBIS	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
70	PASSWORD_BP	☐	ISM_XUBCODE	XUBCODE	CHAR	40	0	User Password
71	PASSWORD_REPEAT	☐	ISM_XUBCCODE	XUBCODE	CHAR	40	0	Confirm User Password
72	GPAG_LOGON	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
73	PASSWORD_LOGON	☐	ISM_XUBCODE	XUBCODE	CHAR	40	0	User Password
74	GPVERM_LOGON	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
75	USERALIAS_LOGON	☐	USALIAS	USALIAS	CHAR	40	0	Internet user alias
76	MARKETING_CAMP	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
77	USERALIAS_IU	☐	USALIAS	USALIAS	CHAR	40	0	Internet user alias
78	XEMAIL_ADD_TO_BP	☐	XEMAIL_ADD_TO_BP	XFELD	CHAR	1	0	IS-M: E-Mail Address must be Added to Business Partner Data
79	XFICA_ACTIVE	☐	XFICA_ACTIVE	XFELD	CHAR	1	0	IS-M/SD: Billing Document Transfer to FI-CA
80	IMMATDAT	☐	IMMATDAT	DATUM	DATS	8	0	Matriculation Certificate Valid To
81	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*
82	REFBELEG	☐	REMELD_ISP	CHAR20	CHAR	20	0	IS-M/SD: Reference Document in Legacy System
83	.INCLUDE	☐				0	0	IS-M/SD: Structure for WWW, Payment Data
84	ZLSCH	☐	JZLSCH	ZLSCH	CHAR	1	0	IS-M: Payment Method	T042Z
85	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
86	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
87	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
88	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
89	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
90	XSEPAACTIVE	☐	XSEPAACTIVE	XFELD	CHAR	1	0	IS-M: Create SEPA Mandate with the Active Status
91	SIGN_CITY	☐	SEPA_SIGN_CITY	TEXT40	CHAR	40	0	Location of Signature
92	SIGN_DATE	☐	SEPA_SIGN_DATE	DATUM	DATS	8	0	Date of Signature
93	BANKA	☐	BANKA	TEXT60	CHAR	60	0	Name of bank
94	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
95	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
96	.INCLUDE	☐				0	0	Credit Card Encryption
97	CGUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
98	ENCTP	☐	CCSECA_ENCTYPE	CCSECA_ENCTYPE	CHAR	1	0	Type of Encryption
99	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	TVCIN
100	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
101	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
102	CCTYP	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	TVCTY
103	BKVID	☐	BU_BKVID	CHAR4	CHAR	4	0	Bank details ID
104	CCNAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
105	AUDAT	☐	AUDAT_CC	DATUM	DATS	8	0	Payment cards: Authorization date
106	AUTIM	☐	AUTIM	UZEIT	TIMS	6	0	Payment cards: Authorization time
107	AUNUM	☐	AUNUM	CHAR10	CHAR	10	0	Payment cards: Authorization number
108	AUTRA	☐	AUTRA	CHAR15	CHAR	15	0	Payment cards: Authoriz. reference code of clearing house
109	.INCLUDE	☐				0	0	Card Verification Value
110	ISM_CVVAL	☐	ISM_CVVAL	ISM_CVVAL	CHAR	6	0	Card Verification Value
111	ISM_CVVCT	☐	ISM_CVVCT	ISM_CVVCT	CHAR	1	0	Control Field for Card Verification Value
112	ISM_CVVST	☐	ISM_CVVST	ISM_CVVST	CHAR	1	0	Usage Status of Card Verification Value
113	.INCLUDE	☐				0	0	Response for Card Verification Value
114	ISM_RCCVV	☐	ISM_RCCVV_CC	CHAR4	CHAR	4	0	Results Check for Card Verification Value	TCCRC
115	.INCLU-_1	☐				0	0	IS-M: Additional Payments
116	ADDPAY_TYPE_1	☐	ISM_ADDPAYMENT_TYPE	ISM_ADDPAYMENT_TYPE	CHAR	2	0	IS-M/SD: Additional Payment Type	TJK21
117	ADDPAY_VALUE_1	☐	ISM_ADDPAYMENT_VALUE	WERT5	CURR	9	2	IS-M/SD: Additional Payment Amount
118	WAERK_1	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
119	XNONRECURRING_1	☐	ISM_ADDPAYMENT_XNONRECURRING	XFELD	CHAR	1	0	IS-M/SD: One-Time Additional Payment
120	XRECURRING_1	☐	ISM_ADDPAYMENT_XRECURRING	XFELD	CHAR	1	0	IS-M/SD: Additional Payment is Repeated Periodically
121	.INCLU-_2	☐				0	0	IS-M: Additional Payments
122	ADDPAY_TYPE_2	☐	ISM_ADDPAYMENT_TYPE	ISM_ADDPAYMENT_TYPE	CHAR	2	0	IS-M/SD: Additional Payment Type	TJK21
123	ADDPAY_VALUE_2	☐	ISM_ADDPAYMENT_VALUE	WERT5	CURR	9	2	IS-M/SD: Additional Payment Amount
124	WAERK_2	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
125	XNONRECURRING_2	☐	ISM_ADDPAYMENT_XNONRECURRING	XFELD	CHAR	1	0	IS-M/SD: One-Time Additional Payment
126	XRECURRING_2	☐	ISM_ADDPAYMENT_XRECURRING	XFELD	CHAR	1	0	IS-M/SD: Additional Payment is Repeated Periodically
127	.INCLUDE	☐				0	0	IS-M: Message Data
128	MSGID	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
129	MSGNO	☐	SYMSGNO	SYMSGNO	NUMC	3	0	Message Number
130	MSGTY	☐	SYMSGTY	SYCHAR01	CHAR	1	0	Message Type
131	.INCLUDE	☐				0	0	IS-M: Message Variables
132	MSGV1	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
133	MSGV2	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
134	MSGV3	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
135	MSGV4	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
136	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
137	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
138	NATXTP	☐	JNATXTP	CHAR100	CHAR	100	0	Message Text with Parameters Used
139	ICON_STATUS	☐	ICON_L4	ICON	CHAR	4	0	Icon with output length 4	*
140	VBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
141	POSNR	☐	APNR	APNR	NUMC	6	0	Sales Order Item	*
142	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
143	DATA_ORIGIN	☐	ISM_DATA_ORIGIN	ISM_DATA_ORIGIN	CHAR	1	0	IS-M: Origin of Data in Order Postprocessing
144	TEMPL_DOC	☐	ISM_TEMPL_DOC_MSD	AVNR	CHAR	10	0	IS-M: Offer for Media Sales and Distribution	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKWWWTEMP_ORDER	ADDPAY_TYPE_1	TJK21	ADDPAYMENT_TYPE
2	JKWWWTEMP_ORDER	ADDPAY_TYPE_2	TJK21	ADDPAYMENT_TYPE
3	JKWWWTEMP_ORDER	AUART	TJAK	AUART	REF	1	CN
4	JKWWWTEMP_ORDER	BANKS	T005	LAND1
5	JKWWWTEMP_ORDER	BEZPER	TJD09	BEZPER	REF	1	CN
6	JKWWWTEMP_ORDER	BEZUGGRD	TJK87	BEZUGGRD	REF	1	CN
7	JKWWWTEMP_ORDER	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	1	CN
8	JKWWWTEMP_ORDER	CCINS	TVCIN	CCINS
9	JKWWWTEMP_ORDER	CCTYP	TVCTY	CCTYP
10	JKWWWTEMP_ORDER	DRERZ	JDTDRER	DRERZ	REF	1	CN
11	JKWWWTEMP_ORDER	FKPER	TJK01	FKPER	REF	1	CN
12	JKWWWTEMP_ORDER	ISM_RCCVV	TCCRC	RCODE
13	JKWWWTEMP_ORDER	KDGRP	T151	KDGRP	REF	1	CN
14	JKWWWTEMP_ORDER	KEY_CHECK_AG	TJKWWW_CHECK	KEY_CHECK
15	JKWWWTEMP_ORDER	KEY_CHECK_RE	TJKWWW_CHECK	KEY_CHECK
16	JKWWWTEMP_ORDER	KEY_CHECK_VM	TJKWWW_CHECK	KEY_CHECK
17	JKWWWTEMP_ORDER	KEY_CHECK_WE	TJKWWW_CHECK	KEY_CHECK
18	JKWWWTEMP_ORDER	KEY_FIX	TJKWWW_FIX	KEY_FIX
19	JKWWWTEMP_ORDER	KEY_VAR	TJKWWW_VAR	KEY_VAR
20	JKWWWTEMP_ORDER	KONDA	T188	KONDA	REF	1	CN
21	JKWWWTEMP_ORDER	KUENDGRD	TJK83	KUENDGRD
22	JKWWWTEMP_ORDER	KURST	TCURV	KURST	REF	1	CN
23	JKWWWTEMP_ORDER	LAND1_INIT	T005	LAND1
24	JKWWWTEMP_ORDER	LIEFERART	TJV01	LIEFERART	REF	1	CN
25	JKWWWTEMP_ORDER	MATNR	JMTMAT	MATNR	REF	1	CN
26	JKWWWTEMP_ORDER	PERFK	TFACD	IDENT	REF	1	CN
27	JKWWWTEMP_ORDER	POART	TJAP	POART
28	JKWWWTEMP_ORDER	PVA	JDTPVA	PVA	REF	1	CN
29	JKWWWTEMP_ORDER	RCODE	TJKRRC	RCODE	REF	1	CN
30	JKWWWTEMP_ORDER	SPART	TSPA	SPART	REF	1	CN
31	JKWWWTEMP_ORDER	VKBUR	TVBUR	VKBUR	REF	1	CN
32	JKWWWTEMP_ORDER	VKGRP	TVKGR	VKGRP	REF	1	CN
33	JKWWWTEMP_ORDER	VKORG	TVKO	VKORG	REF	1	CN
34	JKWWWTEMP_ORDER	VTWEG	TVTW	VTWEG	REF	1	CN
35	JKWWWTEMP_ORDER	WAERS	TCURC	WAERS	REF	1	CN
36	JKWWWTEMP_ORDER	WERBEAKT	TJWAK	WERBEAKT	REF	1	CN
37	JKWWWTEMP_ORDER	WERBEART	TJWAR	WERBEART	REF	1	CN
38	JKWWWTEMP_ORDER	WERBTRAEG	TJW09	WERBTRAEG
39	JKWWWTEMP_ORDER	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20131127
SAP Release Created in