SAP ABAP Table JIVLFZU1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JIVLFZU1	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	LFNGNR	☑	LFNGNR	LFNGNR	NUMC	12	0	IS-M: Sequence Number for Delivery	JVTLFNG
3	NACHLFNGNR	☑	NACHLFNGNR	NUM2	NUMC	2	0	Sequence number of subsequent delivery
4	VBELN	☑	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
5	POSNR	☑	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
6	ETENR	☑	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line	JKEP
7	MENGEINZUO	☐	MENGEINZUO	STMENGE	DEC	9	0	Sch.line qty in order-delivery assignment for partial susp.
8	ETART	☐	ETART_ISP	ETART_ISP	CHAR	2	0	Schedule Line Type for Internal Sales Order Schedule Line	TJEP
9	PUBL_ORDER	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
10	EDITION_ORDER	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
11	AUDITCAT	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	TJI01
12	AUDITCATUNPAID	☐	IVWKNFREI	IVWKN	CHAR	8	0	Circulation Report Category ID for Non-Calculation Period	TJI01
13	XFAKTURA	☐	XFAKTURA	XFELD	CHAR	1	0	Indicator: Relevant for billing
14	RECHBEGINN	☐	RECHBEGINN	DATUM	DATS	8	0	Billing From
15	RECHENDE	☐	RECHENDE	DATUM	DATS	8	0	Billing To
16	XSTORNO	☐	XJSTORNO	XFELD	CHAR	1	0	Indicator: Reversed
17	NRMLCOUNTRY	☐	LAND1_ISP	LAND1	CHAR	3	0	Normal delivery country	T005
18	CUKY_SDOC	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
19	MIXTYPE	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
20	BILLFREQ	☐	FKPER	FKPER	CHAR	2	0	Billing Frequency	TJK01
21	PRICEPER	☐	PRSPER	PRSPER	CHAR	2	0	IS-M: Price Frequency	TJK03
22	PRCGRPCUST	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
23	RATE_CODE	☐	RATE_CODE	RATE_CODE	CHAR	4	0	IS-M/SD: Rate Code	TJKRRC
24	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
25	KPOSN	☐	KPOSN_ISP	NUM6	NUMC	6	0	Condition item number
26	CUST_GROUP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
27	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
28	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
29	PYMT_METH	☐	JZAHLW	JZAHLW	CHAR	1	0	Billing method
30	SDOC_TYPE	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
31	ITEM_TYPE	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
32	DELIVTYPE_ORDER	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
33	ACT_COUNTRY	☐	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	T005
34	ETMENGE	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
35	ETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	T006
36	ETVORZEI	☐	ETVORZEI	VORZEI	CHAR	1	0	Plus/Minus Sign for Schedule Line Quantity in Sales Order
37	BEZPER	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	TJD09

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JIVLFZU1	ACT_COUNTRY	T005	LAND1	REF	C	CN
2	JIVLFZU1	AUDITCAT	TJI01	IVWKN	REF	C	CN
3	JIVLFZU1	AUDITCATUNPAID	TJI01	IVWKN	REF	C	CN
4	JIVLFZU1	BEZPER	TJD09	BEZPER	REF	1	CN
5	JIVLFZU1	BILLFREQ	TJK01	FKPER	REF	C	CN
6	JIVLFZU1	CUKY_SDOC	TCURC	WAERS	REF	1	CN
7	JIVLFZU1	CUST_GROUP	T151	KDGRP	REF	C	CN
8	JIVLFZU1	DELIVTYPE_ORDER	TJV01	LIEFERART	REF	C	CN
9	JIVLFZU1	DISTR_CHAN	TVKOV	VTWEG	KEY	1	CN
10	JIVLFZU1	EDITION_ORDER	JDTPVA	PVA	REF	C	CN
11	JIVLFZU1	ETART	TJEP	ETART	REF	C	CN
12	JIVLFZU1	ETENR	JKEP	ETENR	KEY	1	CN
13	JIVLFZU1	ETMEINS	T006	MSEHI	REF	C	CN
14	JIVLFZU1	ITEM_TYPE	TJAP	POART	REF	1	CN
15	JIVLFZU1	LFNGNR	JVTLFNG	LFNGNR	KEY	1	CN
16	JIVLFZU1	MANDT	T000	MANDT	KEY	1	CN
17	JIVLFZU1	MIXTYPE	JDTBEZTYP	BEZTYP	REF	1	CN
18	JIVLFZU1	NRMLCOUNTRY	T005	LAND1	REF	C	CN
19	JIVLFZU1	POSNR	JKAP	POSNR	KEY	1	CN
20	JIVLFZU1	PRCGRPCUST	T188	KONDA	REF	C	CN
21	JIVLFZU1	PRICEPER	TJK03	PRSPER	REF	1	CN
22	JIVLFZU1	PUBL_ORDER	JDTDRER	DRERZ	REF	C	CN
23	JIVLFZU1	RATE_CODE	TJKRRC	RCODE	REF	C	CN
24	JIVLFZU1	SALES_ORG	TVKO	VKORG	KEY	1	CN
25	JIVLFZU1	SDOC_TYPE	TJAK	AUART	REF	1	CN
26	JIVLFZU1	VBELN	JKAK	VBELN	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in