SAP ABAP View JGVDB_SP (IS-M/SD: View for Role - Forwarding Agent)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	JGVDB_SP
Short Description	IS-M/SD: View for Role - Forwarding Agent
Root table	JGTGPNR	IS-M: Central Business Partner Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JGTGPNR	JGTGPNR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JGTGPNR	XSPEDI		NE	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JGTGPNR	MANDT		☐	MANDT	☐	Client
2	GPNR	JGTGPNR	GPNR		☐	GPNR	☐	IS-M: Business Partner Key
3	XGPLOE	JGTGPNR	XGPLOE		☐	JXLV_GP	☐	IS-M: Deletion Flag for General Business Partner
4	XGPLOEKZ	JGTGPNR	XGPLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
5	XGPSPE	JGTGPNR	XGPSPE		☐	XGPSPE	☐	IS-M/SD: Lock Indicator for General Business Partner
6	ERFUSER	JGTGPNR	ERFUSER		☐	ERFUSER	☐	Created By
7	ERFDATE	JGTGPNR	ERFDATE		☐	ERFDATE	☐	Created On
8	ERFTIME	JGTGPNR	ERFTIME		☐	ERFTIME	☐	Time Created
9	AENUSER	JGTGPNR	AENUSER		☐	AENUSER	☐	Last Changed By
10	AENDATE	JGTGPNR	AENDATE		☐	AENDATE	☐	Date of Last Change
11	AENTIME	JGTGPNR	AENTIME		☐	AENTIME	☐	Time of Last Change
12	JKTOKD	JGTGPNR	JKTOKD		☐	JKTOKD	☐	IS-M: Business Partner Account Group
13	MAILN	JGTGPNR	MAILN		☐	JMAILN	☐	IS-M: Mail Address
14	BERUFSL	JGTGPNR	BERUFSL		☐	BERUFSL	☐	IS-M: Occupation
15	JBRSCH	JGTGPNR	BRSCH		☐	BRSCH	☐	Industry key
16	JGEBDAT	JGTGPNR	JGEBDAT		☐	JGEBDAT	☐	IS-M: Date of Birth of a Business Partner
17	GESCH	JGTGPNR	GESCH		☐	JGESCHL	☐	IS-M: Gender Key
18	JFAMST	JGTGPNR	JFAMST		☐	JFAMST	☐	IS-M: Business Partner's Marital Status
19	GPHERK	JGTGPNR	GPHERK		☐	GPHERK	☐	IS-M: Business Partner Origin
20	XNATUR	JGTGPNR	XNATUR		☐	XNATUR	☐	IS-M: Natural Person Indicator
21	XVERMSACH	JGTGPNR	XVERMSACH		☐	XVERMSACH	☐	IS-M: BP Authorized to Receive Gifts
22	XOHNE	JGTGPNR	XOHNE		☐	XCPDK	☐	Indicator: Is the account a one-time account?
23	XDEBI	JGTGPNR	XDEBI		☐	JXDEBI	☐	IS-M: Indicator: Customer Exists
24	KUNNR	JGTGPNR	KUNNR		☐	JKUNNR	☐	IS-M: Customer Number in Previous System
25	FKUNNR	JGTGPNR	FKUNNR		☐	JFKUNNR	☐	IS-M: Customer Number in Non-SAP System
26	LIFNR	JGTGPNR	LIFNR		☐	JLIFNR	☐	IS-M: Vendor Number in Previous System
27	FLIFNR	JGTGPNR	FLIFNR		☐	JFLIFNR	☐	IS-M: Vendor Number in Non-SAP System
28	XMITARB	JGTGPNR	XMITARB		☐	XMITARB	☐	IS-M: Employee Indicator
29	PERNR	JGTGPNR	PERNR		☐	JPERNR2	☐	IS-M: Personnel Number
30	XNOWERB	JGTGPNR	XNOWERB		☐	XNOWERB	☐	IS-M: No Advertising
31	XSPEDI	JGTGPNR	XSPEDI		☐	XSPEDI	☐	IS-M: Forwarding Agent Indicator
32	XSPEDLOEV	JGTGPNR	XSPEDLOEV		☐	JXLV_SP	☐	IS-M: Deletion Flag for Forwarding Agent
33	XSPEDLOEKZ	JGTGPNR	XSPEDLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
34	XSPESPE	JGTGPNR	XSPESPE		☐	XSPSPE	☐	IS-M/SD: Lock Indicator for Forwarding Agent

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	20050224
SAP Release Created in