SAP ABAP Table VIGW_V_VZGPO (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | VIGW_V_VZGPO |
![]() |
Short Description | Generated Table for View |
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 | CLNT | 3 | 0 | Client | T000 | |
2 | ![]() |
VVNUMOBJ | VVNUMOBJ | CHAR | 2 | 0 | Key for number range object | ||
3 | ![]() |
VVSOBJGPO | CHAR13 | CHAR | 13 | 0 | Internal key for object for business partner table | ||
4 | ![]() |
BP_PARTNR | BP_PARTNR | CHAR | 10 | 0 | Business Partner Number | BP000 | |
5 | ![]() |
BP_ROLETYP | BP_ROLETYP | CHAR | 4 | 0 | Business Partner Role Category | TPZ3 | |
6 | ![]() |
VVDTRANS | DATUM | DATS | 8 | 0 | Flow data key: System date | ||
7 | ![]() |
DBEBEZ | DATUM | DATS | 8 | 0 | Date of start of relationship | ||
8 | ![]() |
DENBEZ | DATUM | DATS | 8 | 0 | Date of end of relationship | ||
9 | ![]() |
BP_APPL | BP_APPL | CHAR | 4 | 0 | Application Category | TPZ12 | |
10 | ![]() |
BP_ADR_REF | BP_ADR_REF | CHAR | 10 | 0 | Address ID | * | |
11 | ![]() |
BP_ROLE | BP_ROLE | CHAR | 4 | 0 | Business Partner Role Type | TPZ6 | |
12 | ![]() |
PBEZ | DEC3_7 | DEC | 10 | 7 | Percentage rate of relationship | ||
13 | ![]() |
BBEZ | WERTV7 | CURR | 13 | 2 | Relationship amount | ||
14 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
15 | ![]() |
KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
16 | ![]() |
VVGZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method for credit memos | * | |
17 | ![]() |
BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
18 | ![]() |
DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
19 | ![]() |
SDUNNDOC | SDUNNDOC | CHAR | 1 | 0 | Type of Dunning Letter | ||
20 | ![]() |
SDUNNBUC | XFELD | CHAR | 1 | 0 | Post Dunning Charges and Interest to This Partner | ||
21 | ![]() |
NORDER | NUM8 | NUMC | 8 | 0 | Order Number | ||
22 | ![]() |
CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
23 | ![]() |
BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
24 | ![]() |
AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | ADRP | |
25 | ![]() |
BU_GROUP | BU_GROUP | CHAR | 4 | 0 | Business Partner Grouping | * | |
26 | ![]() |
BP_EXT_PNR | CHAR15 | CHAR | 15 | 0 | External Business Partner ID | ||
27 | ![]() |
KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
28 | ![]() |
BP_TYPE_OLD | BP_TYPE | CHAR | 1 | 0 | Partner category | ||
29 | ![]() |
BP_GROUP | XFELD | CHAR | 1 | 0 | BP: Collective Business Partner Indicator | ||
30 | ![]() |
BP_GRP_ID_OLD | BP_GRP_ID | CHAR | 4 | 0 | Business Partner Grouping | TPZ2 | |
31 | ![]() |
BP_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 (surname for persons, otherwise company name) | ||
32 | ![]() |
BP_NAME2 | TEXT40 | CHAR | 40 | 0 | Name 2 (Continuation of NAME 1) | ||
33 | ![]() |
LANGU | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
34 | ![]() |
BP_TITLE_OLD | BP_TITLE | NUMC | 2 | 0 | Form of Address (Key) | TP01 | |
35 | ![]() |
BP_TITL_LT | BP_TITL_LT | NUMC | 2 | 0 | Salutation | TP02 | |
36 | ![]() |
BP_SORT1 | CHAR20 | CHAR | 20 | 0 | Sort Field 1 | ||
37 | ![]() |
BP_SORT2 | CHAR20 | CHAR | 20 | 0 | Sort Field 2 | ||
38 | ![]() |
BP_SORT_PH | CHAR20 | CHAR | 20 | 0 | Sort Field for Phonetic Search; Obsolete | ||
39 | ![]() |
BP_MC_NAM1 | CHAR25 | CHAR | 25 | 0 | Field NAME1 in Upper Case | ||
40 | ![]() |
BP_MC_NAM2 | CHAR25 | CHAR | 25 | 0 | Field NAME2 in Upper Case | ||
41 | ![]() |
BP_SOURCE | BP_SOURCE | CHAR | 4 | 0 | Source Key of Business Partner Data | ||
42 | ![]() |
BP_CRUSER | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
43 | ![]() |
BP_CRDAT | DATUM | DATS | 8 | 0 | Creation Date | ||
44 | ![]() |
BP_VIP | PAVIP | CHAR | 1 | 0 | Business Partner: VIP Partner | TVIP | |
45 | ![]() |
BP_GROUP_D | BP_GROUP_D | CHAR | 4 | 0 | Target Group | TP13 | |
46 | ![]() |
BP_DEL_IND | XFELD | CHAR | 1 | 0 | Deletion Flag | ||
47 | ![]() |
BEGRU | BEGRU | CHAR | 4 | 0 | Authorization Group | ||
48 | ![]() |
BP_XTITLE | TEXT50 | CHAR | 50 | 0 | Text of Form of Address | ||
49 | ![]() |
BP_XTIT_LE | TEXT50 | CHAR | 50 | 0 | Salutation | ||
50 | ![]() |
BP_PAR_REL | BP_PAR_REL | CHAR | 1 | 0 | Business Partner Released | ||
51 | ![]() |
BP_NAMLAST | TEXT40 | CHAR | 40 | 0 | Last Name | ||
52 | ![]() |
BP_NAMFRST | TEXT40 | CHAR | 40 | 0 | First Name | ||
53 | ![]() |
BP_TITL_AC_OLD | TEXT20 | CHAR | 20 | 0 | Academic Title | ||
54 | ![]() |
BP_PREFIX_OLD | TEXT20 | CHAR | 20 | 0 | Name Prefix | ||
55 | ![]() |
BP_ADDITN_OLD | TEXT20 | CHAR | 20 | 0 | Name Affix | ||
56 | ![]() |
BP_NICKNAM | TEXT20 | CHAR | 20 | 0 | Known As | ||
57 | ![]() |
BP_SEX_OLD | BP_SEX | CHAR | 1 | 0 | Gender of Business Partner | ||
58 | ![]() |
BP_PROFESS_OLD | TEXT40 | CHAR | 40 | 0 | Description of Occupation for Business Partner | ||
59 | ![]() |
BP_CNTR_N | LAND1 | CHAR | 3 | 0 | Nationality | T005 | |
60 | ![]() |
BP_CNTR_ST | LAND1 | CHAR | 3 | 0 | Citizenship | T005 | |
61 | ![]() |
BP_BIRTHD | DATUM | DATS | 8 | 0 | Date of Birth of Business Partner | ||
62 | ![]() |
BP_BIRTHPL | TEXT40 | CHAR | 40 | 0 | Birthplace | ||
63 | ![]() |
BP_BIRTHNA | TEXT40 | CHAR | 40 | 0 | Name at Birth | ||
64 | ![]() |
BP_BIRTH_A | TEXT40 | CHAR | 40 | 0 | Name at Birth Affix | ||
65 | ![]() |
BP_DEATH_D | DATUM | DATS | 8 | 0 | Date of Death | ||
66 | ![]() |
BP_MARITAL_OLD | BP_MARITAL | NUMC | 2 | 0 | Marital Status | TP03 | |
67 | ![]() |
BP_PROPRTY_OLD | BP_PROPRTY | NUMC | 2 | 0 | Marital property regime | TP04 | |
68 | ![]() |
BP_CHILDRN | DEC2 | DEC | 2 | 0 | Number of Children Belonging to the Business Partner | ||
69 | ![]() |
BP_MEM_HOU | DEC2 | DEC | 2 | 0 | Number of People Living in the Household | ||
70 | ![]() |
BP_INC_CUR | WAERS | CUKY | 5 | 0 | Currency of Net Income | TCURC | |
71 | ![]() |
BP_NET_INC | WERTV8 | CURR | 15 | 2 | Net Annual Income | ||
72 | ![]() |
BP_MO_INC | WERTV8 | CURR | 15 | 2 | Monthly Net Income of Business Partner | ||
73 | ![]() |
BP_N_INC_Y | GJAHR | NUMC | 4 | 0 | Year of Net Annual Income | ||
74 | ![]() |
BP_M_INC_M | BP_M_INC_M | NUMC | 2 | 0 | Calendar Month of Monthly Net Income | ||
75 | ![]() |
BP_M_INC_Y | GJAHR | NUMC | 4 | 0 | Year of Monthly Net Income | ||
76 | ![]() |
BP_PERS_NR | CHAR15 | CHAR | 15 | 0 | Personnel Number | ||
77 | ![]() |
BP_STAFF_G | BP_STAFF_G | CHAR | 4 | 0 | Employee Group | TP05 | |
78 | ![]() |
HR_ORG_REF | XFELD | CHAR | 1 | 0 | HR Org. Link | ||
79 | ![]() |
XUBNAME | XUBNAME | CHAR | 12 | 0 | User Name in User Master Record | USR02 | |
80 | ![]() |
BP_STAFF_R | XFELD | CHAR | 1 | 0 | Employee | ||
81 | ![]() |
BP_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 (surname for persons, otherwise company name) | ||
82 | ![]() |
BP_NAME2 | TEXT40 | CHAR | 40 | 0 | Name 2 (Continuation of NAME 1) | ||
83 | ![]() |
BP_CAL_ID | WFCID | CHAR | 2 | 0 | Factory calendar | TFACD | |
84 | ![]() |
BP_LEG_ETY_OLD | BP_LEG_ETY | NUMC | 2 | 0 | Legal Form of Organization | TP08 | |
85 | ![]() |
BP_LEG_ORG_OLD | BP_LEG_ORG | NUMC | 2 | 0 | Legal Entity of Organization | TP09 | |
86 | ![]() |
BP_BAL_FLG | BP_BAL_FLG | CHAR | 1 | 0 | Balance Sheet Display | ||
87 | ![]() |
BP_FOUND_Y | GJAHR | NUMC | 4 | 0 | Foundation Year of Organization | ||
88 | ![]() |
BP_COM_REG | TEXT50 | CHAR | 50 | 0 | Entry in Commercial Register | ||
89 | ![]() |
BP_COM_R_D | DATUM | DATS | 8 | 0 | Date of Entry in Commercial Register | ||
90 | ![]() |
BP_CNTR_HD | LAND1 | CHAR | 3 | 0 | Country of Organization's Registered Office | T005 | |
91 | ![]() |
BP_REGIO_HD | REGIO | CHAR | 3 | 0 | Region of Registered Office | T005S | |
92 | ![]() |
BP_COMP_HD | TEXT35 | CHAR | 35 | 0 | Registered Office | ||
93 | ![]() |
BP_LIQUI_D | DATUM | DATS | 8 | 0 | Date of Liquidation | ||
94 | ![]() |
BBBNR | NUM07 | NUMC | 7 | 0 | International location number (part 1) | ||
95 | ![]() |
BBSNR | NUM05 | NUMC | 5 | 0 | International location number (Part 2) | ||
96 | ![]() |
BUBKZ | NUM01 | NUMC | 1 | 0 | Check digit for the international location number | ||
97 | ![]() |
BP_BRSCH_OLD | BRSCH | CHAR | 4 | 0 | Industry Keys | T016 | |
98 | ![]() |
BP_MIN_RSV | XFELD | CHAR | 1 | 0 | Bank Subject to Minimum Reserve Requirement | ||
99 | ![]() |
BP_BAL_CUR | WAERS | CUKY | 5 | 0 | Balance Sheet Currency | TCURC | |
100 | ![]() |
BP_CA_IN_A | WERTV8 | CURR | 15 | 2 | Amount of last capital increase | ||
101 | ![]() |
BP_CA_IN_Y | GJAHR | NUMC | 4 | 0 | Year of Last Capital Increase | ||
102 | ![]() |
BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
103 | ![]() |
BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
104 | ![]() |
BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |