SAP ABAP Table TJL42 (IS-M/SD: Master Data for External Contract Arrangement Det.)

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	TJL42	Table Relationship Diagram
Short Description	IS-M/SD: Master Data for External Contract Arrangement Det.

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	VERSERVGES	☑	VERSERVGES	GPNR	CHAR	10	0	IS-M: Service Company	JGTGPNR
3	GPNR	☑	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
4	LIEFERART	☑	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
5	BEZIRK	☑	BEZIRK	BEZIRK	CHAR	10	0	Carrier Route	JVTBEZIRK
6	BEZRUNDE	☑	BEZRUNDE	BEZRUNDE	CHAR	10	0	IS-M: Delivery Round	JVTBEZRND
7	MATERIAL	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
8	GUELTIGVON	☑	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
9	JZUMOD	☐	JZUMOD	JZUSTMOD	CHAR	4	0	IS-M/SD: Contract arrangements for home delivery	TJLZM

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TJL42	BEZIRK	JVTBEZIRK	BEZIRK
2	TJL42	BEZRUNDE	JVTBEZRND	BEZRUNDE
3	TJL42	GPNR	JGTGPNR	GPNR
4	TJL42	JZUMOD	TJLZM	JZUMOD
5	TJL42	LIEFERART	TJV01	LIEFERART
6	TJL42	MANDT	T000	MANDT
7	TJL42	MATERIAL	MARA	MATNR	KEY	1	CN
8	TJL42	VERSERVGES	JGTGPNR	GPNR

History

Last changed by/on	SAP	20050224
SAP Release Created in	600