SAP ABAP Table JGVDB_VB (Generated Table for View JGVDB_VB)
Basic Data
Table Category VIEW    General view structure 
General view structure JGVDB_VB   Table Relationship Diagram
Short Description Generated Table for View JGVDB_VB    
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 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
7 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
8 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
9 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
10 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
11 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
12 JKTOKD JKTOKD JKTOKD CHAR 4   0   IS-M: Business Partner Account Group TJG37
13 MAILN JMAILN SO_OBJ_NAM CHAR 12   0   IS-M: Mail Address  
14 BERUFSL BERUFSL BERUFSL CHAR 8   0   IS-M: Occupation TJG05
15 JBRSCH BRSCH BRSCH CHAR 4   0   Industry key T016
16 JGEBDAT JGEBDAT DATUM DATS 8   0   IS-M: Date of Birth of a Business Partner  
17 GESCH JGESCHL JGESCHL CHAR 1   0   IS-M: Gender Key  
18 JFAMST JFAMST JFAMST CHAR 1   0   IS-M: Business Partner's Marital Status TJG45
19 GPHERK GPHERK GPHERK CHAR 2   0   IS-M: Business Partner Origin TJG41
20 XNATUR XNATUR XFELD CHAR 1   0   IS-M: Natural Person Indicator  
21 XVERMSACH XVERMSACH XFELD CHAR 1   0   IS-M: BP Authorized to Receive Gifts  
22 XOHNE XCPDK XFELD CHAR 1   0   Indicator: Is the account a one-time account?  
23 XDEBI JXDEBI XFELD CHAR 1   0   IS-M: Indicator: Customer Exists  
24 KUNNR JKUNNR KUNNR CHAR 10   0   IS-M: Customer Number in Previous System KNA1
25 FKUNNR JFKUNNR KUNNR CHAR 10   0   IS-M: Customer Number in Non-SAP System  
26 XKREDI XKREDI XFELD CHAR 1   0   IS-M: Indicator: Vendor Exists  
27 LIFNR JLIFNR LIFNR CHAR 10   0   IS-M: Vendor Number in Previous System LFA1
28 FLIFNR JFLIFNR LIFNR CHAR 10   0   IS-M: Vendor Number in Non-SAP System  
29 XMITARB XMITARB XFELD CHAR 1   0   IS-M: Employee Indicator  
30 PERNR JPERNR2 JPERNR CHAR 20   0   IS-M: Personnel Number  
31 XNOWERB XNOWERB XFELD CHAR 1   0   IS-M: No Advertising  
32 XVERB XVERB XFELD CHAR 1   0   IS-M: Association Indicator  
33 XVEBLOEV XLOESCH XFELD CHAR 1   0   IS-M: Deletion Flag (Role-Specific)  
34 XVEBSPE XSPERR XFELD CHAR 1   0   IS-M: Lock Indicator (Role-Specific)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JGVDB_VB BERUFSL TJG05 BERUFSL REF C CN
2 JGVDB_VB GPHERK TJG41 GPHERK REF C CN
3 JGVDB_VB JBRSCH T016 BRSCH REF C CN
4 JGVDB_VB JFAMST TJG45 JFAMST REF C CN
5 JGVDB_VB JKTOKD TJG37 JKTOKD KEY 1 CN
6 JGVDB_VB KUNNR KNA1 KUNNR REF C 1
7 JGVDB_VB LIFNR LFA1 LIFNR REF C 1
8 JGVDB_VB MANDT T000 MANDT KEY 1 CN
History
Last changed by/on SAP  20050224 
SAP Release Created in