SAP ABAP Table JGVDB_EW (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | JGVDB_EW |
![]() |
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 | ![]() |
GPNR | GPNR | CHAR | 10 | 0 | IS-M: Business Partner Key | ||
3 | ![]() |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
4 | ![]() |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
5 | ![]() |
SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
6 | ![]() |
JXLV_GP | XFELD | CHAR | 1 | 0 | IS-M: Deletion Flag for General Business Partner | ||
7 | ![]() |
XLOESCHKZ | XFELD | CHAR | 1 | 0 | IS-M: Deletion Indicator (Role-Specific) | ||
8 | ![]() |
XGPSPE | XFELD | CHAR | 1 | 0 | IS-M/SD: Lock Indicator for General Business Partner | ||
9 | ![]() |
JGESCHL | JGESCHL | CHAR | 1 | 0 | IS-M: Gender Key | ||
10 | ![]() |
JFAMST | JFAMST | CHAR | 1 | 0 | IS-M: Business Partner's Marital Status | TJG45 | |
11 | ![]() |
GPHERK | GPHERK | CHAR | 2 | 0 | IS-M: Business Partner Origin | TJG41 | |
12 | ![]() |
XNATUR | XFELD | CHAR | 1 | 0 | IS-M: Natural Person Indicator | ||
13 | ![]() |
JKTOKD | JKTOKD | CHAR | 4 | 0 | IS-M: Business Partner Account Group | TJG37 | |
14 | ![]() |
JMAILN | SO_OBJ_NAM | CHAR | 12 | 0 | IS-M: Mail Address | ||
15 | ![]() |
BERUFSL | BERUFSL | CHAR | 8 | 0 | IS-M: Occupation | TJG05 | |
16 | ![]() |
BRSCH | BRSCH | CHAR | 4 | 0 | Industry key | T016 | |
17 | ![]() |
JGEBDAT | DATUM | DATS | 8 | 0 | IS-M: Date of Birth of a Business Partner | ||
18 | ![]() |
XVERMSACH | XFELD | CHAR | 1 | 0 | IS-M: BP Authorized to Receive Gifts | ||
19 | ![]() |
XCPDK | XFELD | CHAR | 1 | 0 | Indicator: Is the account a one-time account? | ||
20 | ![]() |
JXDEBI | XFELD | CHAR | 1 | 0 | IS-M: Indicator: Customer Exists | ||
21 | ![]() |
JKUNNR | KUNNR | CHAR | 10 | 0 | IS-M: Customer Number in Previous System | KNA1 | |
22 | ![]() |
JFKUNNR | KUNNR | CHAR | 10 | 0 | IS-M: Customer Number in Non-SAP System | ||
23 | ![]() |
XKREDI | XFELD | CHAR | 1 | 0 | IS-M: Indicator: Vendor Exists | ||
24 | ![]() |
JLIFNR | LIFNR | CHAR | 10 | 0 | IS-M: Vendor Number in Previous System | LFA1 | |
25 | ![]() |
JFLIFNR | LIFNR | CHAR | 10 | 0 | IS-M: Vendor Number in Non-SAP System | ||
26 | ![]() |
XMITARB | XFELD | CHAR | 1 | 0 | IS-M: Employee Indicator | ||
27 | ![]() |
JPERNR2 | JPERNR | CHAR | 20 | 0 | IS-M: Personnel Number | ||
28 | ![]() |
XNOWERB | XFELD | CHAR | 1 | 0 | IS-M: No Advertising | ||
29 | ![]() |
XEUW | XFELD | CHAR | 1 | 0 | IS-M: Retailer Indicator | ||
30 | ![]() |
JXLV_EW | XFELD | CHAR | 1 | 0 | IS-M: Deletion Flag for Retailer | ||
31 | ![]() |
XLOESCHKZ | XFELD | CHAR | 1 | 0 | IS-M: Deletion Indicator (Role-Specific) | ||
32 | ![]() |
XEWSPE | XFELD | CHAR | 1 | 0 | IS-M/SD: Lock Indicator - Retailer | ||
33 | ![]() |
AUFSD_X | KAUFS | CHAR | 2 | 0 | Central order block for customer | TVAST | |
34 | ![]() |
BAHNE | BAHNH | CHAR | 25 | 0 | Express train station | ||
35 | ![]() |
BAHNS | BAHNH | CHAR | 25 | 0 | Train station | ||
36 | ![]() |
BBBNR | NUM07 | NUMC | 7 | 0 | International location number (part 1) | ||
37 | ![]() |
BBSNR | NUM05 | NUMC | 5 | 0 | International location number (Part 2) | ||
38 | ![]() |
BRGRU | BRGRU | CHAR | 4 | 0 | Authorization Group | ||
39 | ![]() |
BRSCH | BRSCH | CHAR | 4 | 0 | Industry key | T016 | |
40 | ![]() |
BUBKZ | NUM01 | NUMC | 1 | 0 | Check digit for the international location number | ||
41 | ![]() |
DATLT | TEXT14 | CHAR | 14 | 0 | Data communication line no. | ||
42 | ![]() |
EXABL | XFELD | CHAR | 1 | 0 | Indicator: Unloading points exist | ||
43 | ![]() |
FAKSD_X | FAKSP | CHAR | 2 | 0 | Central billing block for customer | TVFS | |
44 | ![]() |
KNAZK | WFCID | CHAR | 2 | 0 | Working Time Calendar | TFACD | |
45 | ![]() |
FISKN_D | KUNNR | CHAR | 10 | 0 | Account number of the master record with the fiscal address | KNA1 | |
46 | ![]() |
KNRZA | KUNNR | CHAR | 10 | 0 | Account number of an alternative payer | KNA1 | |
47 | ![]() |
KONZS | KONZS | CHAR | 10 | 0 | Group key | ||
48 | ![]() |
KUKLA | KUKLA | CHAR | 2 | 0 | Customer classification | TKUKL | |
49 | ![]() |
KTOKD | KTOKD | CHAR | 4 | 0 | Customer Account Group | T077D | |
50 | ![]() |
LAND1_GP | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
51 | ![]() |
LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
52 | ![]() |
LIFSD_X | LIFSP | CHAR | 2 | 0 | Central delivery block for the customer | TVLS | |
53 | ![]() |
LOCCO | LOCCO | CHAR | 10 | 0 | City Coordinates | ||
54 | ![]() |
LOEVM_X | XFELD | CHAR | 1 | 0 | Central Deletion Flag for Master Record | ||
55 | ![]() |
NIELS | NIELS | CHAR | 2 | 0 | Nielsen ID | TNLS | |
56 | ![]() |
COUNC | COUNC | CHAR | 3 | 0 | County Code | T005E | |
57 | ![]() |
CITYC | CITYC | CHAR | 4 | 0 | City Code | T005G | |
58 | ![]() |
RPMKR | RPMKR | CHAR | 5 | 0 | Regional market | ||
59 | ![]() |
SORTL | CHAR10 | CHAR | 10 | 0 | Sort field | ||
60 | ![]() |
SPERB_X | XFELD | CHAR | 1 | 0 | Central posting block | ||
61 | ![]() |
SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
62 | ![]() |
STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
63 | ![]() |
STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
64 | ![]() |
STKZA | STKZA | CHAR | 1 | 0 | Indicator: Business Partner Subject to Equalization Tax? | ||
65 | ![]() |
STKZU | XFELD | CHAR | 1 | 0 | Liable for VAT | ||
66 | ![]() |
LZONE | ZONE | CHAR | 10 | 0 | Transportation zone to or from which the goods are delivered | TZONE | |
67 | ![]() |
XCPDK | XFELD | CHAR | 1 | 0 | Indicator: Is the account a one-time account? | ||
68 | ![]() |
XREGU | XFELD | CHAR | 1 | 0 | Indicator: Is an alternative payer allowed in document? | ||
69 | ![]() |
RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | T880 | |
70 | ![]() |
STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
71 | ![]() |
DEAR1 | XFELD | CHAR | 1 | 0 | Indicator: Competitor | ||
72 | ![]() |
DEAR2 | XFELD | CHAR | 1 | 0 | Indicator: Sales partner | ||
73 | ![]() |
DEAR3 | DEAR3 | CHAR | 1 | 0 | Indicator: Sales prospect | ||
74 | ![]() |
DEAR4 | XFELD | CHAR | 1 | 0 | Indicator for customer type 4 | ||
75 | ![]() |
DEAR5 | XFELD | CHAR | 1 | 0 | ID for default sold-to party | ||
76 | ![]() |
GFORM | GFORM | CHAR | 2 | 0 | Legal status | TVGF | |
77 | ![]() |
BRAN1_D | BRACO | CHAR | 10 | 0 | Industry code 1 | TBRC | |
78 | ![]() |
BRAN2 | BRACO | CHAR | 10 | 0 | Industry code 2 | TBRC | |
79 | ![]() |
BRAN3 | BRACO | CHAR | 10 | 0 | Industry code 3 | TBRC | |
80 | ![]() |
BRAN4 | BRACO | CHAR | 10 | 0 | Industry code 4 | TBRC | |
81 | ![]() |
BRAN5 | BRACO | CHAR | 10 | 0 | Industry code 5 | TBRC | |
82 | ![]() |
EKONT | VBELN | CHAR | 10 | 0 | Initial contact | VBUK | |
83 | ![]() |
UMSAT | UMSAT | CURR | 8 | 2 | Annual sales | ||
84 | ![]() |
UMJAH | JAHR | NUMC | 4 | 0 | Year For Which Sales are Given | ||
85 | ![]() |
UWAER | WAERS | CUKY | 5 | 0 | Currency of Sales Volume | TCURC | |
86 | ![]() |
JMZAH | JMZAH | NUMC | 6 | 0 | Yearly number of employees | ||
87 | ![]() |
JMJAH | JAHR | NUMC | 4 | 0 | Year for which the number of employees is given | ||
88 | ![]() |
KATR1 | ATTR1 | CHAR | 2 | 0 | Attribute 1 | TVK1 | |
89 | ![]() |
KATR2 | ATTR2 | CHAR | 2 | 0 | Attribute 2 | TVK2 | |
90 | ![]() |
KATR3 | ATTR3 | CHAR | 2 | 0 | Attribute 3 | TVK3 | |
91 | ![]() |
KATR4 | ATTR4 | CHAR | 2 | 0 | Attribute 4 | TVK4 | |
92 | ![]() |
KATR5 | ATTR5 | CHAR | 2 | 0 | Attribute 5 | TVK5 | |
93 | ![]() |
KATR6 | ATTR6 | CHAR | 3 | 0 | Attribute 6 | TVK6 | |
94 | ![]() |
KATR7 | ATTR7 | CHAR | 3 | 0 | Attribute 7 | TVK7 | |
95 | ![]() |
KATR8 | ATTR8 | CHAR | 3 | 0 | Attribute 8 | TVK8 | |
96 | ![]() |
KATR9 | ATTR9 | CHAR | 3 | 0 | Attribute 9 | TVK9 | |
97 | ![]() |
KATR10 | ATTR10 | CHAR | 3 | 0 | Attribute 10 | TVK0 | |
98 | ![]() |
STKZN | STKZN | CHAR | 1 | 0 | Natural Person | ||
99 | ![]() |
UMSA1 | UMSA1 | CURR | 15 | 2 | Annual sales | ||
100 | ![]() |
TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | TTXJ | |
101 | ![]() |
ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
102 | ![]() |
ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
103 | ![]() |
BEGRU | BEGRU | CHAR | 4 | 0 | Authorization Group | ||
104 | ![]() |
LOEVM_V | XFELD | CHAR | 1 | 0 | Deletion flag for customer (sales level) | ||
105 | ![]() |
STGKU | STGKU | CHAR | 1 | 0 | Customer Statistics Group | TVSD | |
106 | ![]() |
AUFSD_V | KAUFS | CHAR | 2 | 0 | Customer order block (sales area) | TVAST | |
107 | ![]() |
KALKS | KALKS | CHAR | 1 | 0 | Pricing procedure assigned to this customer | TVKD | |
108 | ![]() |
KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | T151 | |
109 | ![]() |
BZIRK | BZIRK | CHAR | 6 | 0 | Sales district | T171 | |
110 | ![]() |
KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | T188 | |
111 | ![]() |
PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | T189 | |
112 | ![]() |
AWAHR | AWAHR | NUMC | 3 | 0 | Order probability of the item | ||
113 | ![]() |
INCO1 | INCO1 | CHAR | 3 | 0 | Incoterms (part 1) | TINC | |
114 | ![]() |
INCO2 | INCO2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
115 | ![]() |
LIFSD_V | LIFSP | CHAR | 2 | 0 | Customer delivery block (sales area) | TVLS | |
116 | ![]() |
AUTLF | XFELD | CHAR | 1 | 0 | Complete delivery defined for each sales order? | ||
117 | ![]() |
ANTLF | ANTLF | DEC | 1 | 0 | Maximum number of partial deliveries allowed per item | ||
118 | ![]() |
KZTLF | KZTLF | CHAR | 1 | 0 | Partial delivery at item level | ||
119 | ![]() |
KZAZU_D | XFELD | CHAR | 1 | 0 | Order combination indicator | ||
120 | ![]() |
CHSPL | XFELD | CHAR | 1 | 0 | Batch split allowed | ||
121 | ![]() |
LPRIO | LPRIO | NUMC | 2 | 0 | Delivery priority | TPRIO | |
122 | ![]() |
EIKTO | CHAR12 | CHAR | 12 | 0 | Shipper's (Our) Account Number at the Customer or Vendor | ||
123 | ![]() |
VSBED | VSBED | CHAR | 2 | 0 | Shipping conditions | TVSB | |
124 | ![]() |
FAKSD_V | FAKSP | CHAR | 2 | 0 | Billing block for customer (sales and distribution) | TVFS | |
125 | ![]() |
MRNKZ | XFELD | CHAR | 1 | 0 | Manual invoice maintenance | ||
126 | ![]() |
PERFK | WFCID | CHAR | 2 | 0 | Invoice dates (calendar identification) | TFACD | |
127 | ![]() |
PERRL | WFCID | CHAR | 2 | 0 | Invoice list schedule (calendar identification) | TFACD | |
128 | ![]() |
KVAKZ | XFELD | CHAR | 1 | 0 | Cost estimate indicator (inactive) | ||
129 | ![]() |
KVAWT | WERT7 | CURR | 13 | 2 | Value limit for cost estimate (inactive) | ||
130 | ![]() |
WAERS_V02D | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
131 | ![]() |
KLABC | KLABC | CHAR | 2 | 0 | Customer classification (ABC analysis) | ||
132 | ![]() |
KTGRD | KTGRD | CHAR | 2 | 0 | Account assignment group for this customer | TVKT | |
133 | ![]() |
DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
134 | ![]() |
DWERK_EXT | WERKS | CHAR | 4 | 0 | Delivering Plant (Own or External) | TVKWZ | |
135 | ![]() |
VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | TVBVK | |
136 | ![]() |
VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | TVBUR | |
137 | ![]() |
VSORT | VBELN | CHAR | 10 | 0 | Item proposal | VBUK | |
138 | ![]() |
KVGR1 | KVGR1 | CHAR | 3 | 0 | Customer group 1 | TVV1 | |
139 | ![]() |
KVGR2 | KVGR2 | CHAR | 3 | 0 | Customer group 2 | TVV2 | |
140 | ![]() |
KVGR3 | KVGR3 | CHAR | 3 | 0 | Customer group 3 | TVV3 | |
141 | ![]() |
KVGR4 | KVGR4 | CHAR | 3 | 0 | Customer group 4 | TVV4 | |
142 | ![]() |
KVGR5 | KVGR5 | CHAR | 3 | 0 | Customer group 5 | TVV5 | |
143 | ![]() |
KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | TCURV | |
144 | ![]() |
ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
145 | ![]() |
ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
146 | ![]() |
ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
147 | ![]() |
AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
148 | ![]() |
AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
149 | ![]() |
AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
150 | ![]() |
XLOESCHKZ | XFELD | CHAR | 1 | 0 | IS-M: Deletion Indicator (Role-Specific) | ||
151 | ![]() |
VERKGB | TEXT50 | CHAR | 50 | 0 | IS-M: Sales Region | ||
152 | ![]() |
VGEINW | ANZPERS | NUMC | 10 | 0 | IS-M: Population of Sales Area | ||
153 | ![]() |
ANZMIT | JANZMA | NUMC | 5 | 0 | IS-M: Number of Retail Employees | ||
154 | ![]() |
MBRSYS | MBRSYS | CHAR | 2 | 0 | IS-M: Automatic Payment System | TJG15 | |
155 | ![]() |
EVKSTART | EVKSTART | CHAR | 2 | 0 | IS-M: Point of Sale Category | TJG17 | |
156 | ![]() |
EVKSTBEZ | EVKSTBEZ | CHAR | 4 | 0 | POS Type | TJG19 | |
157 | ![]() |
XLOTTO | XFELD | CHAR | 1 | 0 | IS-M: Lottery Agent Indicator | ||
158 | ![]() |
EVKFLAECHE | EVKFLAECHE | CHAR | 2 | 0 | IS-M: POS Area Key | TJG21 | |
159 | ![]() |
EUMSEINFL | EUMSEINFL | CHAR | 2 | 0 | External Sales Influence at POS (Primary) | TJG25 | |
160 | ![]() |
EBEDIENART | EBEDIENART | CHAR | 1 | 0 | Service Type for Point of Sale | TJG23 | |
161 | ![]() |
EFREQUENZ | EFREQUENZ | CHAR | 1 | 0 | IS-M: POS Customer Frequency per Week | TJG27 | |
162 | ![]() |
BAGNR | TEXT5 | CHAR | 5 | 0 | IS-M: BAG Transaction Number | ||
163 | ![]() |
ISPCNR | TEXT10 | CHAR | 10 | 0 | IS-M: ISPC Number | ||
164 | ![]() |
VDZNR | VDZNR | CHAR | 20 | 0 | IS-M: VDZ Number | ||
165 | ![]() |
OEFFZT | OEFFZT | CHAR | 1 | 0 | IS-M: Point of Sale Opening Time | TJG29 | |
166 | ![]() |
SCHLZT | CHAR | 1 | 0 | IS-M: POS Closing Time | TJG31 | ||
167 | ![]() |
OEFFMO | OEFFTG | CHAR | 1 | 0 | IS-M: Opening Type Monday | TJG33 | |
168 | ![]() |
OEFFDI | OEFFTG | CHAR | 1 | 0 | IS-M: Opening Type Tuesday | TJG33 | |
169 | ![]() |
OEFFMI | OEFFTG | CHAR | 1 | 0 | IS-M: Opening Type Wednesday | TJG33 | |
170 | ![]() |
OEFFDO | OEFFTG | CHAR | 1 | 0 | IS-M: Opening Type Thursday | TJG33 | |
171 | ![]() |
OEFFFR | OEFFTG | CHAR | 1 | 0 | IS-M: Opening Type Friday | TJG33 | |
172 | ![]() |
OEFFSA | OEFFTG | CHAR | 1 | 0 | IS-M: Opening Type Saturday | TJG33 | |
173 | ![]() |
OEFFSO | OEFFTG | CHAR | 1 | 0 | IS-M: Opening Type Sunday | TJG33 | |
174 | ![]() |
XREMRECHT | XFELD | CHAR | 1 | 0 | IS-M: Right of Return | ||
175 | ![]() |
REMART | REMART | CHAR | 1 | 0 | Return Type | ||
176 | ![]() |
REMWEISE | REMWEISE | CHAR | 1 | 0 | Return Method | ||
177 | ![]() |
REMSP | XFELD | CHAR | 1 | 0 | IS-M: Billing Block for Return Notification | ||
178 | ![]() |
KOMM50 | TEXT50 | CHAR | 50 | 0 | IS-M: Comment 50 Characters in Length | ||
179 | ![]() |
REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S |
Foreign Keys
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |