SAP ABAP View JGVDB_PV (IS-M/SD: Database View for Role - Sales Agent/Comm.Recipient)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M-MD (Application Component) Master Data
⤷ JMDGEN (Package) Generic Master Data Media
⤷ IS-M-MD (Application Component) Master Data
⤷ JMDGEN (Package) Generic Master Data Media
Basic Data
View Type | D | Database View |
Database View | JGVDB_PV | |
Short Description | IS-M/SD: Database View for Role - Sales Agent/Comm.Recipient | |
Root table | JGTGPNR | IS-M: Central Business Partner Table |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | JGTGPNR | JGTGPNR | ||
2 | JGTVERM |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | JGTGPNR | MANDT | JL | EQ | 0 | 0 | ||||
2 | JGTVERM | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | JGTGPNR | GPNR | JL | EQ | 0 | 0 | ||||
4 | JGTVERM | VERMITTLER | JR | EQ | AND | 0 | 0 | |||
5 | JGTGPNR | XVERMPROV | 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 | JKTOKD | JGTGPNR | JKTOKD | JKTOKD | IS-M: Business Partner Account Group | |||
7 | MAILN | JGTGPNR | MAILN | JMAILN | IS-M: Mail Address | |||
8 | BERUFSL | JGTGPNR | BERUFSL | BERUFSL | IS-M: Occupation | |||
9 | JBRSCH | JGTGPNR | BRSCH | BRSCH | Industry key | |||
10 | JGEBDAT | JGTGPNR | JGEBDAT | JGEBDAT | IS-M: Date of Birth of a Business Partner | |||
11 | GESCH | JGTGPNR | GESCH | JGESCHL | IS-M: Gender Key | |||
12 | JFAMST | JGTGPNR | JFAMST | JFAMST | IS-M: Business Partner's Marital Status | |||
13 | GPHERK | JGTGPNR | GPHERK | GPHERK | IS-M: Business Partner Origin | |||
14 | XNATUR | JGTGPNR | XNATUR | XNATUR | IS-M: Natural Person Indicator | |||
15 | XVERMSACH | JGTGPNR | XVERMSACH | XVERMSACH | IS-M: BP Authorized to Receive Gifts | |||
16 | XOHNE | JGTGPNR | XOHNE | XCPDK | Indicator: Is the account a one-time account? | |||
17 | XDEBI | JGTGPNR | XDEBI | JXDEBI | IS-M: Indicator: Customer Exists | |||
18 | KUNNR | JGTGPNR | KUNNR | JKUNNR | IS-M: Customer Number in Previous System | |||
19 | FKUNNR | JGTGPNR | FKUNNR | JFKUNNR | IS-M: Customer Number in Non-SAP System | |||
20 | LIFNR | JGTGPNR | LIFNR | JLIFNR | IS-M: Vendor Number in Previous System | |||
21 | FLIFNR | JGTGPNR | FLIFNR | JFLIFNR | IS-M: Vendor Number in Non-SAP System | |||
22 | XMITARB | JGTGPNR | XMITARB | XMITARB | IS-M: Employee Indicator | |||
23 | PERNR | JGTGPNR | PERNR | JPERNR2 | IS-M: Personnel Number | |||
24 | XNOWERB | JGTGPNR | XNOWERB | XNOWERB | IS-M: No Advertising | |||
25 | XVERMPROVV | JGTGPNR | XVERMPROVV | JXLV_PV | IS-M: Deletion Flag for Sales Agent/Commission Recipient | |||
26 | XVERMPROV | JGTGPNR | XVERMPROV | XVERMPROV | IS-M: Sales Agent - Commission Recipient | |||
27 | XVERMPROKZ | JGTGPNR | XVERMPROKZ | XLOESCHKZ | IS-M: Deletion Indicator (Role-Specific) | |||
28 | XVERSPE | JGTGPNR | XVERSPE | XPVSPE | IS-M/SD: Lock Indicator for Sales Agent/Commission Recipient | |||
29 | ERFUSER | JGTVERM | ERFUSER | ERFUSER | Created By | |||
30 | ERFDATE | JGTVERM | ERFDATE | ERFDATE | Created On | |||
31 | ERFTIME | JGTVERM | ERFTIME | ERFTIME | Time Created | |||
32 | AENUSER | JGTVERM | AENUSER | AENUSER | Last Changed By | |||
33 | AENDATE | JGTVERM | AENDATE | AENDATE | Date of Last Change | |||
34 | AENTIME | JGTVERM | AENTIME | AENTIME | Time of Last Change | |||
35 | XVERLOE | JGTVERM | XVERLOE | XLOESCHKZ | IS-M: Deletion Indicator (Role-Specific) | |||
36 | VERTYP | JGTVERM | VERTYP | VERTYP | IS-M: Sales Agent Type | |||
37 | VERBER | JGTVERM | VERBER | VERBER | IS-M: Sales Consultant | |||
38 | XBUSPERRE | JGTVERM | XBUSPERRE | XBUSPERRE | IS-M: Settlement Posting Block | |||
39 | KAUTSATZ | JGTVERM | KAUTSATZ | KAUTSATZ | IS-M: Security Deposit Rate in Percent | |||
40 | KAUTKONTO | JGTVERM | KAUTKONTO | KAUTKONTO | IS-M: Security Deposit Account Number | |||
41 | MAXKAUT | JGTVERM | MAXKAUT | MAXKAUT | IS-M: Maximum Security Deposit Amount | |||
42 | WAERS | JGTVERM | WAERS | WAERS | Currency Key | |||
43 | KAUTZINS | JGTVERM | KAUTZINS | KAUTZINS | IS-M: Interest Rate for Security Deposit Account | |||
Maintenance Status
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 |