SAP ABAP Table JGVDB_PV (Generated Table for View JGVDB_PV)
Basic Data
Table Category | VIEW | General view structure |
General view structure | JGVDB_PV | Table Relationship Diagram |
Short Description | Generated Table for View JGVDB_PV |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | GPNR | GPNR | GPNR | CHAR | 10 | 0 | IS-M: Business Partner Key | ||
3 | XGPLOE | JXLV_GP | XFELD | CHAR | 1 | 0 | IS-M: Deletion Flag for General Business Partner | ||
4 | XGPLOEKZ | XLOESCHKZ | XFELD | CHAR | 1 | 0 | IS-M: Deletion Indicator (Role-Specific) | ||
5 | XGPSPE | XGPSPE | XFELD | CHAR | 1 | 0 | IS-M/SD: Lock Indicator for General Business Partner | ||
6 | JKTOKD | JKTOKD | JKTOKD | CHAR | 4 | 0 | IS-M: Business Partner Account Group | TJG37 | |
7 | MAILN | JMAILN | SO_OBJ_NAM | CHAR | 12 | 0 | IS-M: Mail Address | ||
8 | BERUFSL | BERUFSL | BERUFSL | CHAR | 8 | 0 | IS-M: Occupation | TJG05 | |
9 | JBRSCH | BRSCH | BRSCH | CHAR | 4 | 0 | Industry key | T016 | |
10 | JGEBDAT | JGEBDAT | DATUM | DATS | 8 | 0 | IS-M: Date of Birth of a Business Partner | ||
11 | GESCH | JGESCHL | JGESCHL | CHAR | 1 | 0 | IS-M: Gender Key | ||
12 | JFAMST | JFAMST | JFAMST | CHAR | 1 | 0 | IS-M: Business Partner's Marital Status | TJG45 | |
13 | GPHERK | GPHERK | GPHERK | CHAR | 2 | 0 | IS-M: Business Partner Origin | TJG41 | |
14 | XNATUR | XNATUR | XFELD | CHAR | 1 | 0 | IS-M: Natural Person Indicator | ||
15 | XVERMSACH | XVERMSACH | XFELD | CHAR | 1 | 0 | IS-M: BP Authorized to Receive Gifts | ||
16 | XOHNE | XCPDK | XFELD | CHAR | 1 | 0 | Indicator: Is the account a one-time account? | ||
17 | XDEBI | JXDEBI | XFELD | CHAR | 1 | 0 | IS-M: Indicator: Customer Exists | ||
18 | KUNNR | JKUNNR | KUNNR | CHAR | 10 | 0 | IS-M: Customer Number in Previous System | KNA1 | |
19 | FKUNNR | JFKUNNR | KUNNR | CHAR | 10 | 0 | IS-M: Customer Number in Non-SAP System | ||
20 | LIFNR | JLIFNR | LIFNR | CHAR | 10 | 0 | IS-M: Vendor Number in Previous System | LFA1 | |
21 | FLIFNR | JFLIFNR | LIFNR | CHAR | 10 | 0 | IS-M: Vendor Number in Non-SAP System | ||
22 | XMITARB | XMITARB | XFELD | CHAR | 1 | 0 | IS-M: Employee Indicator | ||
23 | PERNR | JPERNR2 | JPERNR | CHAR | 20 | 0 | IS-M: Personnel Number | ||
24 | XNOWERB | XNOWERB | XFELD | CHAR | 1 | 0 | IS-M: No Advertising | ||
25 | XVERMPROVV | JXLV_PV | XFELD | CHAR | 1 | 0 | IS-M: Deletion Flag for Sales Agent/Commission Recipient | ||
26 | XVERMPROV | XVERMPROV | XFELD | CHAR | 1 | 0 | IS-M: Sales Agent - Commission Recipient | ||
27 | XVERMPROKZ | XLOESCHKZ | XFELD | CHAR | 1 | 0 | IS-M: Deletion Indicator (Role-Specific) | ||
28 | XVERSPE | XPVSPE | XFELD | CHAR | 1 | 0 | IS-M/SD: Lock Indicator for Sales Agent/Commission Recipient | ||
29 | ERFUSER | ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
30 | ERFDATE | ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
31 | ERFTIME | ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
32 | AENUSER | AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
33 | AENDATE | AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
34 | AENTIME | AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
35 | XVERLOE | XLOESCHKZ | XFELD | CHAR | 1 | 0 | IS-M: Deletion Indicator (Role-Specific) | ||
36 | VERTYP | VERTYP | VERTYP | CHAR | 2 | 0 | IS-M: Sales Agent Type | TJG11 | |
37 | VERBER | VERBER | GPNR | CHAR | 10 | 0 | IS-M: Sales Consultant | JGTGPNR | |
38 | XBUSPERRE | XBUSPERRE | XFELD | CHAR | 1 | 0 | IS-M: Settlement Posting Block | ||
39 | KAUTSATZ | KAUTSATZ | ISPNUM32 | DEC | 5 | 2 | IS-M: Security Deposit Rate in Percent | ||
40 | KAUTKONTO | KAUTKONTO | CHAR15 | CHAR | 15 | 0 | IS-M: Security Deposit Account Number | ||
41 | MAXKAUT | MAXKAUT | ISPWV072 | CURR | 9 | 2 | IS-M: Maximum Security Deposit Amount | ||
42 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
43 | KAUTZINS | KAUTZINS | ISPNUM32 | DEC | 5 | 2 | IS-M: Interest Rate for Security Deposit Account |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | JGVDB_PV | BERUFSL | TJG05 | BERUFSL | REF | C | CN |
2 | JGVDB_PV | GPHERK | TJG41 | GPHERK | REF | C | CN |
3 | JGVDB_PV | JBRSCH | T016 | BRSCH | REF | C | CN |
4 | JGVDB_PV | JFAMST | TJG45 | JFAMST | REF | C | CN |
5 | JGVDB_PV | JKTOKD | TJG37 | JKTOKD | KEY | 1 | CN |
6 | JGVDB_PV | KUNNR | KNA1 | KUNNR | REF | C | 1 |
7 | JGVDB_PV | LIFNR | LFA1 | LIFNR | REF | C | 1 |
8 | JGVDB_PV | MANDT | T000 | MANDT | KEY | 1 | CN |
9 | JGVDB_PV | VERBER | JGTGPNR | GPNR | REF | 1 | CN |
10 | JGVDB_PV | VERTYP | TJG11 | VERTYP | REF | C | CN |
11 | JGVDB_PV | WAERS | TCURC | WAERS | REF | C | CN |
History
Last changed by/on | SAP | 20050224 |
SAP Release Created in |