SAP ABAP Table JVTLIEFBAR (IS-M/SD: Delivery/Home Delivery/Pickup Viability Sets)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JVTLIEFBAR	Table Relationship Diagram
Short Description	IS-M/SD: Delivery/Home Delivery/Pickup Viability Sets

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	LIEFBARNR	☑	LIEFBARNR	LIEFBARNR	CHAR	9	0	Sequence number for delivery/home delivery viability set
3	GUELTIGAB	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
4	GUELTIGBIS	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
5	GBISBEEND	☐	GBISBEEND	DATUM	DATS	8	0	Valid to Date After Closed Delivery Via. Sets are Released
6	XAUFTRREL	☐	XAUFTRREL	XFELD	CHAR	1	0	IS-M: Use of delivery viability set possible in order
7	LOESCH_KZ	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
8	.INCLUDE	☐				0	0	IS-PSD: Canonical Key for Delivery Viability w/Printg Works
9	.INCLUDE	☐				0	0	IS-PSD: Secondary Key for Delivery Viability Set
10	DRUERZART	☐	DRUERZART	DRUERZART	CHAR	1	0	Publication Type	TJD17
11	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
12	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
13	BEZUGSTYP	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
14	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
15	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
16	LIEFERART	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
17	GEOEIN	☐	GEOEIN	GEOEIN	CHAR	10	0	Number of Geographical Unit	JSTGEOEINH
18	BEZIRK	☐	BEZIRK	BEZIRK	CHAR	10	0	Carrier Route	JVTBEZIRK
19	ABHOLSTELL	☐	ABHOLSTELL	GPNR	CHAR	10	0	IS-M/SD: Customer Pickup Point	JGTGPNR
20	BEZRUNDE	☐	BEZRUNDE	BEZRUNDE	CHAR	10	0	IS-M: Delivery Round	JVTRUNDE
21	DRUCKEREI	☐	JWERK	WERKS	CHAR	4	0	Plant	T001W
22	.INCLUDE	☐				0	0	Change data: Standard references
23	AENDNRBIS	☐	AENDNRBIS	AENDNR	CHAR	9	0	Change Number for To-Date of Structural Change	JSTAENDER
24	AENDNRBISD	☐	AENDNRBISD	AENDNRARTD	CHAR	1	0	Date of Change Number Used to Change To-Date
25	AENDNRAB	☐	AENDNRAB	AENDNR	CHAR	9	0	Change Number for From-Date of Structure Change	JSTAENDER
26	AENDNRABD	☐	AENDNRABD	AENDNRARTD	CHAR	1	0	Date of Change Number Used to Change From-Date
27	AENDNRINIT	☐	AENDNRINIT	AENDNR	CHAR	9	0	Initiating Change Number	JSTAENDER
28	AENDLFDNRI	☐	AENDLFDNRI	AENDLFDNR	NUMC	4	0	Sequence Number of Initiating Change Number
29	AENDNRAKT	☐	AENDNRAKT	AENDNR	CHAR	9	0	Change Number in Process	JSTAENDER
30	AENDLFDNRA	☐	AENDLFDNRA	AENDLFDNR	NUMC	4	0	Sequence Number of Currently Operative Change Number
31	XAENDER	☐	XAENDER	XFELD	CHAR	1	0	Structure information being changed on other change number
32	XSTRUAKTIV	☐	XSTRUAKTIV	XSTRUAKTIV	CHAR	1	0	Structure information inactive
33	FCCODE	☐	FCCODE	FCCODE	CHAR	2	0	Function Control Code for Structure Changes
34	DBCODEFREI	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
35	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
36	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
37	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
38	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
39	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
40	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
41	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JVTLIEFBAR	ABHOLSTELL	JGTGPNR	GPNR	KEY	1	CN
2	JVTLIEFBAR	AENDNRAB	JSTAENDER	AENDNR
3	JVTLIEFBAR	AENDNRAKT	JSTAENDER	AENDNR
4	JVTLIEFBAR	AENDNRBIS	JSTAENDER	AENDNR
5	JVTLIEFBAR	AENDNRINIT	JSTAENDER	AENDNR
6	JVTLIEFBAR	BEZIRK	JVTBEZIRK	BEZIRK	REF	C	CN
7	JVTLIEFBAR	BEZRUNDE	JVTRUNDE	RUNDE	KEY	1	CN
8	JVTLIEFBAR	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	C	CN
9	JVTLIEFBAR	DRERZ	JDTDRER	DRERZ	REF	C	CN
10	JVTLIEFBAR	DRUCKEREI	T001W	WERKS	KEY	1	CN
11	JVTLIEFBAR	DRUERZART	TJD17	DEART	KEY	1	CN
12	JVTLIEFBAR	GEOEIN	JSTGEOEINH	GEOEIN	REF	C	CN
13	JVTLIEFBAR	LIEFERART	TJV01	LIEFERART	KEY	1	CN
14	JVTLIEFBAR	MANDT	T000	MANDT	KEY	1	CN
15	JVTLIEFBAR	PVA	JDTPVA	PVA	REF	C	CN
16	JVTLIEFBAR	VKORG	TVKO	VKORG	KEY	1	CN
17	JVTLIEFBAR	VTWEG	TVTW	VTWEG	KEY	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in