SAP ABAP Table JIVLFZU1_SMALL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JIVLFZU1_SMALL	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	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
21	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
22	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
23	SDOC_TYPE	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
24	ITEM_TYPE	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
25	DELIVTYPE_ORDER	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
26	ACT_COUNTRY	☐	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	T005

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JIVLFZU1_SMALL	ACT_COUNTRY	T005	LAND1	REF	C	CN
2	JIVLFZU1_SMALL	AUDITCAT	TJI01	IVWKN	REF	C	CN
3	JIVLFZU1_SMALL	AUDITCATUNPAID	TJI01	IVWKN	REF	C	CN
4	JIVLFZU1_SMALL	CUKY_SDOC	TCURC	WAERS	REF	1	CN
5	JIVLFZU1_SMALL	DELIVTYPE_ORDER	TJV01	LIEFERART	REF	C	CN
6	JIVLFZU1_SMALL	DISTR_CHAN	TVKOV	VTWEG	KEY	1	CN
7	JIVLFZU1_SMALL	EDITION_ORDER	JDTPVA	PVA	REF	C	CN
8	JIVLFZU1_SMALL	ETART	TJEP	ETART	REF	C	CN
9	JIVLFZU1_SMALL	ETENR	JKEP	ETENR	KEY	1	CN
10	JIVLFZU1_SMALL	ITEM_TYPE	TJAP	POART	REF	1	CN
11	JIVLFZU1_SMALL	LFNGNR	JVTLFNG	LFNGNR	KEY	1	CN
12	JIVLFZU1_SMALL	MANDT	T000	MANDT	KEY	1	CN
13	JIVLFZU1_SMALL	MIXTYPE	JDTBEZTYP	BEZTYP	REF	1	CN
14	JIVLFZU1_SMALL	NRMLCOUNTRY	T005	LAND1	REF	C	CN
15	JIVLFZU1_SMALL	POSNR	JKAP	POSNR	KEY	1	CN
16	JIVLFZU1_SMALL	PUBL_ORDER	JDTDRER	DRERZ	REF	C	CN
17	JIVLFZU1_SMALL	SALES_ORG	TVKO	VKORG	KEY	1	CN
18	JIVLFZU1_SMALL	SDOC_TYPE	TJAK	AUART	REF	1	CN
19	JIVLFZU1_SMALL	VBELN	JKAK	VBELN	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in