SAP ABAP Table J_1SVAUFTR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	J_1SVAUFTR	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
4	GUELTIGVON	☐	JKAPVON	DATUM	DATS	8	0	Valid-From Date of Sales Order Item
5	GUELTIGBIS	☐	JKAPBIS	DATUM	DATS	8	0	Date to which Sales Order Item is Valid
6	XDISPO	☐	XDISPO	XFELD	CHAR	1	0	Indicator: relevant to planning
7	IVWKN	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	TJI01
8	XIVW	☐	XIVW	XFELD	CHAR	1	0	Indicator: Relevant for audit report
9	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
10	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
11	SPART	☐	SPARTDRERZ	SPART	CHAR	2	0	Division for publication	TSPA
12	BEZUGSTYP	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
13	AEART	☐	AEART_JSDK	AEART_JSDK	CHAR	1	0	Order Change Type
14	LIEFERART	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
15	VSAUSSTART	☐	VSAUSSTART	VSAUSSTART	CHAR	2	0	Shipping outsorting type	TJV09
16	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
17	JKAPVON	☐	JKAPVON	DATUM	DATS	8	0	Valid-From Date of Sales Order Item
18	IVWLAND	☐	LAND1_ISP	LAND1	CHAR	3	0	Normal delivery country	T005
19	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
20	AUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
21	AUARTGRP	☐	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
22	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
23	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
24	POART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
25	DRUCKEREI	☐	JWERK	WERKS	CHAR	4	0	Plant	T001W

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1SVAUFTR	AUART	TJAK	AUART	REF	1	CN
2	J_1SVAUFTR	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	1	CN
3	J_1SVAUFTR	DRERZ	JDTDRER	DRERZ	REF	C	CN
4	J_1SVAUFTR	DRUCKEREI	T001W	WERKS	REF	C	CN
5	J_1SVAUFTR	IVWKN	TJI01	IVWKN	REF	C	CN
6	J_1SVAUFTR	IVWLAND	T005	LAND1	REF	C	CN
7	J_1SVAUFTR	KDGRP	T151	KDGRP	REF	C	CN
8	J_1SVAUFTR	LIEFERART	TJV01	LIEFERART	REF	C	CN
9	J_1SVAUFTR	MANDT	T000	MANDT	KEY	1	CN
10	J_1SVAUFTR	POART	TJAP	POART	REF	1	CN
11	J_1SVAUFTR	PVA	JDTPVA	PVA	REF	C	CN
12	J_1SVAUFTR	SPART	TSPA	SPART	REF	C	CN
13	J_1SVAUFTR	VBELN	JKAK	VBELN	KEY	1	CN
14	J_1SVAUFTR	VKORG	TVKO	VKORG	KEY	1	CN
15	J_1SVAUFTR	VSAUSSTART	TJV09	VSAUSSTART	REF	C	CN
16	J_1SVAUFTR	VTWEG	TVKOV	VTWEG	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in