SAP ABAP Table JKVLIEF (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JKVLIEF	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	VBELN	☑	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
3	POSNR	☑	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
4	ETENR	☑	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line
5	JPARVW	☑	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
6	PARZA	☑	JPARZA	JPARZA	NUMC	3	0	IS-M: Partner Role Counter
7	JKPAVON	☑	JKPAVON	DATUM	DATS	8	0	Date from Which Partner Data in Sales Order is Valid
8	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
9	BEZPER	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	TJD09
10	ETMENGE	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
11	ETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	T006
12	ETVORZEI	☐	ETVORZEI	VORZEI	CHAR	1	0	Plus/Minus Sign for Schedule Line Quantity in Sales Order
13	GUELTIGVON	☐	JKAPVON	DATUM	DATS	8	0	Valid-From Date of Sales Order Item
14	GUELTIGBIS	☐	JKAPBIS	DATUM	DATS	8	0	Date to which Sales Order Item is Valid
15	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
16	KUNWE	☐	GPNR_WE	GPNR	CHAR	10	0	IS-M: Business Partner Ship-to Party	JGTGPNR
17	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
18	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
19	LIEFERART	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
20	BEZUGSTYP	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
21	AEART	☐	AEART_JSDK	AEART_JSDK	CHAR	1	0	Order Change Type
22	XUNVLIEFER	☐	XUNVLIEFER	XFELD	CHAR	1	0	IS-M: Viability Data Incomplete for Item
23	ADRNR	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	JGTSADR
24	ADRESSVAR	☐	ADRESSVAR	ERSTADR	CHAR	1	0	IS-M: Address Variant
25	JKPABIS	☐	JKPABIS	DATUM	DATS	8	0	Date to Which Partner Data in Sales Order is Valid
26	AUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
27	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
28	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
29	SPART	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	TVTA
30	POART_EX	☐	POART_EX	POART_EX	CHAR	2	0	Item type of external sales order
31	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
32	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
33	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
34	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
35	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
36	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
37	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
38	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
39	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
40	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
41	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
42	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
43	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
44	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
45	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
46	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
47	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
48	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKVLIEF	ADRNR	JGTSADR	ADRNR	REF	C	CN
2	JKVLIEF	ANRED	TJG43	JANRED	REF	C	CN
3	JKVLIEF	AUART	TJAK	AUART	REF	1	CN
4	JKVLIEF	BEZPER	TJD09	BEZPER	REF	1	CN
5	JKVLIEF	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	1	CN
6	JKVLIEF	DRERZ	JDTDRER	DRERZ	REF	C	CN
7	JKVLIEF	ETMEINS	T006	MSEHI	REF	C	CN
8	JKVLIEF	JPARVW	TJG39	JPARVW	KEY	1	CN
9	JKVLIEF	KUNWE	JGTGPNR	GPNR	REF	C	CN
10	JKVLIEF	LAND1	T005	LAND1	REF	C	CN
11	JKVLIEF	LIEFERART	TJV01	LIEFERART	REF	C	CN
12	JKVLIEF	MANDT	T000	MANDT	KEY	1	CN
13	JKVLIEF	NAMZU	T535N	TITEL
14	JKVLIEF	POSNR	JKAP	POSNR	KEY	1	CN
15	JKVLIEF	PVA	JDTPVA	PVA	REF	C	CN
16	JKVLIEF	SPART	TVTA	SPART	KEY	1	CN
17	JKVLIEF	SPRAS	T002	SPRAS		1	CN
18	JKVLIEF	TITEL	T535N	TITEL
19	JKVLIEF	VBELN	JKAK	VBELN	KEY	1	CN
20	JKVLIEF	VKORG	TVKO	VKORG	KEY	1	CN
21	JKVLIEF	VORSW	T535N	TITEL
22	JKVLIEF	VTWEG	TVKOV	VTWEG	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in