SAP ABAP Table JKVWWWTEMP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JKVWWWTEMP	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
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_AK	SPART	CHAR	2	0	Division for order header	TSPA
6	AUART	☑	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
7	VKBUR	☑	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
8	VKGRP	☑	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
9	KURST	☑	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
10	WAERS	☑	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
11	XWEOBL	☑	XWEOBL	XFELD	CHAR	1	0	Alternative Ship-To Party Required in Order
12	XREOBL	☑	XREOBL	XFELD	CHAR	1	0	Alternative Bill-To Party Required in Order
13	KEY_CHECK_AG	☑	JWWWKEY_CHECK_AG	JWWWKEY_CHECK	CHAR	10	0	IS-M/SD: Key for Check to Identify Sold-To Party	TJKWWW_CHECK
14	KEY_CHECK_WE	☑	JWWWKEY_CHECK_WE	JWWWKEY_CHECK	CHAR	10	0	IS-M/SD: Key for Check to Identify Ship-To Party	TJKWWW_CHECK
15	KEY_CHECK_RE	☑	JWWWKEY_CHECK_RE	JWWWKEY_CHECK	CHAR	10	0	IS-M/SD: Key for Check to Identify Bill-To Party	TJKWWW_CHECK
16	KEY_CHECK_VM	☑	JWWWKEY_CHECK_VM	JWWWKEY_CHECK	CHAR	10	0	IS-M/SD: Key for Check to Identify Sales Agent	TJKWWW_CHECK
17	DATA_TARGET	☑	DATA_TARGET	DATA_TARGET	CHAR	1	0	IS-M: Destination for Saving Internet Data
18	DRERZ	☑	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
19	PVA	☑	PVA	PVA	CHAR	8	0	Edition	JDTPVA
20	BEZUGSTYP	☑	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
21	LIEFERART	☑	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
22	POART	☑	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
23	WERBEART	☑	WERBEART	WERBEART	CHAR	4	0	Sales Source	TJWAR
24	WERBEAKT	☑	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	TJWAK
25	BEZPER	☑	BEZPER	BEZPER	CHAR	5	0	Service Type	TJD09
26	BEZUGGRD	☑	BEZUGGRD	BEZUGGRD	CHAR	3	0	Purchase Reason	TJK87
27	PERFK	☑	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
28	FKPER	☑	FKPER	FKPER	CHAR	2	0	Billing Frequency	TJK01
29	KDGRP	☑	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
30	KONDA	☑	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
31	RCODE	☑	RATE_CODE	RATE_CODE	CHAR	4	0	IS-M/SD: Rate Code	TJKRRC
32	ETMENGE	☑	ETMENGE_N	ETMENGE_N	NUMC	10	0	IS-M: Numerical Schedule Line Quantity
33	MATNR	☑	MATNR_SAPR	MATNR_ISP	CHAR	18	0	IS-M: Material number for gift	JMTMAT
34	VALDAYS	☑	JVALDAYS	NUMC03	NUMC	3	0	Validity Period in Days
35	VALISSUES	☑	JVALISSUES	NUMC3	NUMC	3	0	Validity Period in Copies
36	LAND1_INIT	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
37	XINET_USER	☑	XINET_USER	XFELD	CHAR	1	0	Create Internet User with Password for BP
38	GUELTIGVON	☑	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
39	GUELTIGVON_INPUT	☑	GUELTIGVONIN	DATS	DATS	8	0	IS-M/SD: Desired Start Date of Order
40	GUELTIGBIS	☑	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
41	PASSWORD_BP	☑	ISM_XUBCODE	XUBCODE	CHAR	40	0	User Password
42	PASSWORD_REPEAT	☑	ISM_XUBCCODE	XUBCODE	CHAR	40	0	Confirm User Password
43	ZLSCH	☑	JZLSCH	ZLSCH	CHAR	1	0	IS-M: Payment Method	T042Z
44	BANKS	☑	BANKS	LAND1	CHAR	3	0	Bank country key	T005
45	BANKL	☑	BANKK	BANKK	CHAR	15	0	Bank Keys
46	BANKN	☑	BANKN	BANKN	CHAR	18	0	Bank account number
47	BANKA	☑	BANKA	TEXT60	CHAR	60	0	Name of bank
48	BKONT	☑	BKONT	BKONT	CHAR	2	0	Bank Control Key
49	IBAN	☑	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
50	XEZER	☑	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
51	CCINS	☑	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	TVCIN
52	CCNUM	☑	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number
53	DATBI	☑	DATBI	DATUM	DATS	8	0	Valid To Date
54	CCTYP	☑	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	TVCTY
55	MSGID	☑	SYMSGID	ARBGB	CHAR	20	0	Message Class
56	MSGNO	☑	SYMSGNO	SYMSGNO	NUMC	3	0	Message Number
57	MSGTY	☑	SYMSGTY	SYCHAR01	CHAR	1	0	Message Type
58	MSGV1	☑	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
59	MSGV2	☑	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
60	MSGV3	☑	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
61	MSGV4	☑	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
62	ERFDATE	☑	ERFDATE	DATUM	DATS	8	0	Created On
63	ERFTIME	☑	ERFTIME	UZEIT	TIMS	6	0	Time Created
64	NATXTP	☑	JNATXTP	CHAR100	CHAR	100	0	Message Text with Parameters Used
65	JPARVW	☑	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role
66	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
67	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
68	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
69	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
70	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
71	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
72	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
73	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
74	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
75	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
76	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
77	STRASSEWWW	☐	STRASSEWWW	TEXT55	CHAR	55	0	IS-M: Street in WWW (Contains Street Name and Directionals)
78	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
79	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
80	ERSTADR	☐	ERSTADR	ERSTADR	CHAR	1	0	IS-M: Address Proposal for Alternatives
81	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
82	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
83	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text
84	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
85	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
86	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
87	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
88	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
89	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
90	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address
91	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key
92	KUENDGRD	☐	KUENDGRD	KUENDGRD	CHAR	3	0	Reason for end of delivery	TJK83
93	XCCARD_TO_BP	☐	XCCARD_TO_BP	XFELD	CHAR	1	0	IS-M: WWW, Indicator - Save Credit Card Data with BP
94	ICON_STATUS	☐	ICON_L4	ICON	CHAR	4	0	Icon with output length 4
95	VBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order
96	POSNR	☐	APNR	APNR	NUMC	6	0	Sales Order Item
97	XCANCELLATION	☐	XCANCELLATION	XFELD	CHAR	1	0	IS-M/SD: Right to Cancel Read for Subscription
98	KEY_FIX	☐	JWWWKEY_FIX	JWWWKEY_FIX	CHAR	10	0	IS-M/SD: WWW, Key for Fixed Order Values	TJKWWW_FIX
99	KEY_VAR	☐	JWWWKEY_VAR	JWWWKEY_VAR	CHAR	10	0	IS-M/SD: WWW, Key for Variable Order Values	TJKWWW_VAR
100	GPAG_LOGON	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key
101	PASSWORD_LOGON	☐	ISM_XUBCODE	XUBCODE	CHAR	40	0	User Password
102	GPVERM_LOGON	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key
103	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
104	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
105	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
106	HAUSNWWW	☐	HSNMRWWW	HAUSNUMMER	CHAR	10	0	IS-M: House Number in WWW (Contains House Number and Affix)
107	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
108	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
109	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
110	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
111	UVADR_ST	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
112	UVADR_PF	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
113	UVADR_GK	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
114	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)
115	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number
116	PEINORTPF	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box
117	MARKETING_CAMP	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
118	XNEGOPTION	☐	XNEGOPTION	XFELD	CHAR	1	0	IS-M: Item with Automatic Transformation to Chargeable
119	XIMMATRIK	☐	XIMMATRIK	XFELD	CHAR	1	0	Indicator: Proof of matriculation provided
120	USERALIAS_IU	☐	USALIAS	USALIAS	CHAR	40	0	Internet user alias
121	IMMATDAT	☐	IMMATDAT	DATUM	DATS	8	0	Matriculation Certificate Valid To
122	REFBELEG	☐	REMELD_ISP	CHAR20	CHAR	20	0	IS-M/SD: Reference Document in Legacy System
123	DATA_ORIGIN	☐	ISM_DATA_ORIGIN	ISM_DATA_ORIGIN	CHAR	1	0	IS-M: Origin of Data in Order Postprocessing
124	TEMPL_DOC	☐	ISM_TEMPL_DOC_MSD	AVNR	CHAR	10	0	IS-M: Offer for Media Sales and Distribution
125	DUEDAY	☐	DUEDAY	DUEDAY	NUMC	2	0	IS-M/SD: Renewals, Due Day
126	XIAC_PROTOCOL	☐	XIAC_PROTOCOL	XFELD	CHAR	1	0	IS-M: Log Orders/Changes from Internet
127	UVADR_ACCEPT	☐	UVADR_ACCEPT	UVADR_ACCEPT	CHAR	1	0	IS-M: Accepted Coding Status for Address
128	XFICA_ACTIVE	☐	XFICA_ACTIVE	XFELD	CHAR	1	0	IS-M/SD: Billing Document Transfer to FI-CA
129	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number
130	BKVID	☐	BU_BKVID	CHAR4	CHAR	4	0	Bank details ID
131	CCNAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
132	AUDAT	☐	AUDAT_CC	DATUM	DATS	8	0	Payment cards: Authorization date
133	AUTIM	☐	AUTIM	UZEIT	TIMS	6	0	Payment cards: Authorization time
134	AUNUM	☐	AUNUM	CHAR10	CHAR	10	0	Payment cards: Authorization number
135	AUTRA	☐	AUTRA	CHAR15	CHAR	15	0	Payment cards: Authoriz. reference code of clearing house
136	ISM_CVVAL	☐	ISM_CVVAL	ISM_CVVAL	CHAR	6	0	Card Verification Value
137	ISM_CVVCT	☐	ISM_CVVCT	ISM_CVVCT	CHAR	1	0	Control Field for Card Verification Value
138	ISM_CVVST	☐	ISM_CVVST	ISM_CVVST	CHAR	1	0	Usage Status of Card Verification Value
139	ISM_RCCVV	☐	ISM_RCCVV_CC	CHAR4	CHAR	4	0	Results Check for Card Verification Value	TCCRC
140	XRECHDRUCK	☐	XRECHDRUCK	XFELD	CHAR	1	0	IS-M: Print Invoice
141	WERBTRAEG	☐	WERBTRAEG	WERBTRAEG	CHAR	10	0	Advertising Medium	TJW09

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in