SAP ABAP Table JGTBV (IS-M/SD: Employment Relationship)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-MD (Application Component) Master Data
     ⤷ JMDGEN (Package) Generic Master Data Media

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JGTBV	Table Relationship Diagram
Short Description	IS-M/SD: Employment Relationship

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	BVNR	☑	JBVNR	JBVNR	CHAR	10	0	IS-M: Number of employment relationship
3	VSG	☐	VERSERVGES	GPNR	CHAR	10	0	IS-M: Service Company	JGTVSG
4	VSG_MA	☐	VSG_MA	GPNR	CHAR	10	0	IS-M: Employee	JGTGPNR
5	JPARVW	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
6	XLOESCHKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
7	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
8	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
9	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
10	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
11	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
12	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
13	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
14	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
15	KTGRD_MA	☐	JKTGRD_MA	JKTGRD_MA	CHAR	2	0	IS-M: Expense Account Assignment Group for SC Employees	TJL21
16	.INCLUDE	☐				0	0	IS-PSD: Settlement Data for SC / Employees
17	ABRKAL	☐	JABRKAL	WFCID	CHAR	2	0	IS-M: Settlement Calendar	TJG63
18	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
21	GPNR_ZE	☐	GPNR_ZE	GPNR	CHAR	10	0	IS-M/SD: Business Partner Alternative Payee	JGTGPNR
22	MONBEW	☐	MONBEW	MONBEW	CHAR	1	0	IS-M/SD: Type of valuation ( - / quantity / qty*price )
23	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
24	MWSKZ_ISP	☐	MWSKZ_ISP	MWSKZ_ISP	CHAR	2	0	IS-M: Tax Code	TJL17
25	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
26	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
27	UEBERLART	☐	UEBERLART	UEBERLART	CHAR	1	0	IS-M: Transfer type
28	ANZTAG	☐	ANZTAG	ANZTAG	NUMC	4	0	IS-M: Number of Days for Which Deposit Is Retained
29	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JGTBV	ABRKAL	TJG63	IDENT
2	JGTBV	GPNR_ZE	JGTGPNR	GPNR	KEY	1	CN
3	JGTBV	JPARVW	TJG39	JPARVW	KEY	1	CN
4	JGTBV	KALSM	T683	KALSM	KEY	1	CN
5	JGTBV	KAPPL	T681A	KAPPL	KEY	1	CN
6	JGTBV	KTGRD_MA	TJL21	JKTGRD_MA	KEY	1	CN
7	JGTBV	KURST	TCURV	KURST	KEY	1	CN
8	JGTBV	LAND1	T005	LAND1	KEY	1	CN
9	JGTBV	MANDT	T000	MANDT	KEY	1	CN
10	JGTBV	MWSKZ_ISP	TJL17	MWSKZ_ISP
11	JGTBV	VSG	JGTVSG	VERSERVGES	KEY	1	CN
12	JGTBV	VSG_MA	JGTGPNR	GPNR	KEY	1	CN
13	JGTBV	WAERS	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in