SAP ABAP View J_1SLFGADR (IS-M/SD: CH/V: Delivery-Order Schedule Line-Address)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ J1SC (Package) IS-M/SD CH: Development of Swiss Version

Basic Data

View Type	D	Database View
Database View	J_1SLFGADR
Short Description	IS-M/SD: CH/V: Delivery-Order Schedule Line-Address
Root table	JVTLFZUO	IS-M/SD: Assignment of Delivery to Schedule Line

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JVTLFZUO	JVTLFZUO
2	JKEP
3	JKAP
4	JKPA
5	JGTSADR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JKEP	MANDT	JL	EQ				0	0
2	JVTLFZUO	MANDT	JR	EQ			AND	0	0
3	JKEP	VBELN	JL	EQ				0	0
4	JVTLFZUO	VBELN	JR	EQ			AND	0	0
5	JKEP	POSNR	JL	EQ				0	0
6	JVTLFZUO	POSNR	JR	EQ			AND	0	0
7	JKEP	ETENR	JL	EQ				0	0
8	JVTLFZUO	ETENR	JR	EQ			AND	0	0
9	JKAP	MANDT	JL	EQ				0	0
10	JKEP	MANDT	JR	EQ			AND	0	0
11	JKAP	VBELN	JL	EQ				0	0
12	JKEP	VBELN	JR	EQ			AND	0	0
13	JKAP	POSNR	JL	EQ				0	0
14	JKEP	POSNR	JR	EQ			AND	0	0
15	JKAP	MANDT	JL	EQ				0	0
16	JKPA	MANDT	JR	EQ			AND	0	0
17	JKAP	VBELN	JL	EQ				0	0
18	JKPA	VBELN	JR	EQ			AND	0	0
19	JKAP	POSNR	JL	EQ				0	0
20	JKPA	POSNR	JR	EQ			AND	0	0
21	JGTSADR	MANDT	JL	EQ				0	0
22	JKPA	MANDT	JR	EQ			AND	0	0
23	JGTSADR	ADRNR	JL	EQ				0	0
24	JKPA	ADRNR	JR	EQ			AND	0	0
25	JKPA	JPARVW		EQ	'WE'		AND	0	0
26	JKPA	PARZA		EQ	'000'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JVTLFZUO	MANDT		☐	MANDT	☐	Client
2	LFNGNR	JVTLFZUO	LFNGNR		☐	LFNGNR	☐	IS-M: Sequence Number for Delivery
3	NACHLFNGNR	JVTLFZUO	NACHLFNGNR		☐	NACHLFNGNR	☐	Sequence number of subsequent delivery
4	VBELN	JVTLFZUO	VBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
5	POSNR	JVTLFZUO	POSNR		☐	APNR	☐	Sales Order Item
6	ETENR	JVTLFZUO	ETENR		☐	JAENR	☐	Sales Order Schedule Line
7	JPARVW	JKPA	JPARVW		☐	JPARVW	☐	IS-M: Business Partner Role
8	PARZA	JKPA	PARZA		☐	JPARZA	☐	IS-M: Partner Role Counter
9	GUELTIGVON	JKPA	GUELTIGVON		☐	JKPAVON	☐	Date from Which Partner Data in Sales Order is Valid
10	GUELTIGBIS	JKPA	GUELTIGBIS		☐	JKPABIS	☐	Date to Which Partner Data in Sales Order is Valid
11	ADRNR	JKPA	ADRNR		☐	JADRNR	☐	IS-M: Address Number
12	PLZ_ORDER	JKPA	PLZ_ORDER		☐	PLZ_ISP	☐	IS-M: Postal Code
13	MENGEINZUO	JVTLFZUO	MENGEINZUO		☐	MENGEINZUO	☐	Sch.line qty in order-delivery assignment for partial susp.
14	ETART	JVTLFZUO	ETART		☐	ETART_ISP	☐	Schedule Line Type for Internal Sales Order Schedule Line
15	ETMENGE	JKEP	ETMENGE		☐	ETMENGE	☐	IS-M: Sales Order Schedule Line Quantity
16	ETMEINS	JKEP	ETMEINS		☐	ETMEINS	☐	IS-M: Sales Unit for Sales Order
17	ADRESSVAR	JKPA	ADRESSVAR		☐	ADRESSVAR	☐	IS-M: Address Variant
18	LAND1	JGTSADR	LAND1		☐	LAND1	☐	Country Key
19	POSTEINORT	JGTSADR	POSTEINORT		☐	JALORT	☐	IS-M: City Number (Unique)
20	POSTEINSTR	JGTSADR	POSTEINSTR		☐	STRASSENNR	☐	IS-M: Street Number
21	STRAS	JGTSADR	STRAS		☐	STRAS_ISP	☐	IS-M: Street Name
22	HAUSN	JGTSADR	HAUSN		☐	HSNMR1	☐	IS-M: House Number
23	HSNMR2	JGTSADR	HSNMR2		☐	HSNMR2	☐	IS-M: House Number Affix

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in