JGVDB_EWB SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
JGVDB_EWB is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The JGVDB_EWB table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include GPNR (IS-M: Business Partner Key), BUKRS (Company Code), XGPLOE (IS-M: Deletion Flag for General Business Partner), XGPLOEKZ (IS-M: Deletion Indicator (Role-Specific)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP JGVDB_EWB table view fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
GPNR | IS-M: Business Partner Key | GPNR | CHAR | 10 | ALPHA | GPNR | JGP | MJG0 | |
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
XGPLOE | IS-M: Deletion Flag for General Business Partner | JXLV_GP | CHAR | 1 | XFELD | ||||
XGPLOEKZ | IS-M: Deletion Indicator (Role-Specific) | XLOESCHKZ | CHAR | 1 | XFELD | ||||
XGPSPE | IS-M/SD: Lock Indicator for General Business Partner | XGPSPE | CHAR | 1 | XFELD | ||||
JKTOKD | IS-M: Business Partner Account Group | JKTOKD | CHAR | 4 | TJG37 | ALPHA | JKTOKD | JGK | |
MAILN | IS-M: Mail Address | JMAILN | CHAR | 12 | SO_OBJ_NAM | ||||
BERUFSL | IS-M: Occupation | BERUFSL | CHAR | 8 | TJG05 | ALPHA | BERUFSL | ||
JBRSCH | Industry key | BRSCH | CHAR | 4 | T016 | BRSCH | |||
JGEBDAT | IS-M: Date of Birth of a Business Partner | JGEBDAT | DATS | 8 | DATUM | ||||
GESCH | IS-M: Gender Key | JGESCHL | CHAR | 1 | JGESCHL | ||||
JFAMST | IS-M: Business Partner's Marital Status | JFAMST | CHAR | 1 | TJG45 | JFAMST | |||
GPHERK | IS-M: Business Partner Origin | GPHERK | CHAR | 2 | TJG41 | ALPHA | GPHERK | ||
XNATUR | IS-M: Natural Person Indicator | XNATUR | CHAR | 1 | XFELD | ||||
XVERMSACH | IS-M: BP Authorized to Receive Gifts | XVERMSACH | CHAR | 1 | XFELD | ||||
XOHNE | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | XFELD | ||||
XDEBI | IS-M: Indicator: Customer Exists | JXDEBI | CHAR | 1 | XFELD | ||||
KUNNR | IS-M: Customer Number in Previous System | JKUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
FKUNNR | IS-M: Customer Number in Non-SAP System | JFKUNNR | CHAR | 10 | ALPHA | KUNNR | |||
XKREDI | IS-M: Indicator: Vendor Exists | XKREDI | CHAR | 1 | XFELD | ||||
LIFNR | IS-M: Vendor Number in Previous System | JLIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
FLIFNR | IS-M: Vendor Number in Non-SAP System | JFLIFNR | CHAR | 10 | ALPHA | LIFNR | |||
XMITARB | IS-M: Employee Indicator | XMITARB | CHAR | 1 | XFELD | ||||
PERNR | IS-M: Personnel Number | JPERNR2 | CHAR | 20 | JPERNR | ||||
XNOWERB | IS-M: No Advertising | XNOWERB | CHAR | 1 | XFELD | ||||
XEUW | IS-M: Retailer Indicator | XEUW | CHAR | 1 | XFELD | ||||
XEUWLOEV | IS-M: Deletion Flag for Retailer | JXLV_EW | CHAR | 1 | XFELD | ||||
XEUWLOEKZ | IS-M: Deletion Indicator (Role-Specific) | XLOESCHKZ | CHAR | 1 | XFELD | ||||
XEUWSPE | IS-M/SD: Lock Indicator - Retailer | XEWSPE | CHAR | 1 | XFELD | ||||
KTOKD | Customer Account Group | KTOKD | CHAR | 4 | T077D | KTOKD | KGD | ||
LOCCO | City Coordinates | LOCCO | CHAR | 10 | LOCCO | ||||
LOEVM | Central Deletion Flag for Master Record | LOEVM_X | CHAR | 1 | XFELD | ||||
COUNC | County Code | COUNC | CHAR | 3 | COUNC | ||||
CITYC | City Code | CITYC | CHAR | 4 | CITYC | ||||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
SPERR | Central posting block | SPERB_X | CHAR | 1 | XFELD | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
STKZU | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
GFORM | Legal status | GFORM | CHAR | 2 | TVGF | GFORM | |||
STKZN | Natural Person | STKZN | CHAR | 1 | STKZN | ||||
SPERR_B | Posting block for company code | SPERB_B | CHAR | 1 | XFELD | ||||
LOEVM_B | Deletion Flag for Master Record (Company Code Level) | LOEVM_B | CHAR | 1 | XFELD | ||||
ZUAWA | Key for sorting according to assignment numbers | DZUAWA | CHAR | 3 | TZUN | ZUAWA | |||
BUSAB | Accounting clerk | BUSAB | CHAR | 2 | T001S | BUSAB | |||
AKONT | Reconciliation Account in General Ledger | AKONT | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
ZAHLS | Block Key for Payment | DZAHLS | CHAR | 1 | T008 | ZAHLS | |||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZSABE | User at customer | DZSABE_D | CHAR | 15 | TEXT15 | ||||
KVERM | Memo | KVERM | CHAR | 30 | TEXT30 | ||||
ERDAT | Date on which the Record Was Created | ERDAT_RF | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM_RF | CHAR | 12 | USNAM | ||||
BEGRU | Authorization Group | BRGRU | CHAR | 4 | BRGRU | ||||
KNRZE | Head office account number (in branch accounts) | KNRZE | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
KNRZB | Account number of an alternative payer | KNRZB | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
ZAMIM | Indicator: Payment notice to customer (with cleared items)? | DZAMIM | CHAR | 1 | XFELD | ||||
ZAMIV | Indicator: payment notice to sales department? | DZAMIV | CHAR | 1 | XFELD | ||||
ZAMIR | Indicator: payment notice to legal department? | DZAMIR | CHAR | 1 | XFELD | ||||
ZAMIB | Indicator: Payment notice to the accounting department ? | DZAMIB | CHAR | 1 | XFELD | ||||
ZAMIO | Indicator: payment notice to customer (w/o cleared items)? | DZAMIO | CHAR | 1 | XFELD | ||||
ZWELS | List of the Payment Methods to be Considered | DZWELS | CHAR | 10 | ZWELS | ||||
XVERR | Indicator: Clearing between customer and vendor ? | XVERR_KNB1 | CHAR | 1 | XFELD | ||||
WAKON | Terms of payment key for bill of exchange charges | WAKON | CHAR | 4 | ZTERM | ||||
VZSKZ | Interest calculation indicator | VZSKZ | CHAR | 2 | T056 | VZSKZ | |||
ZINDT | Key date of the last interest calculation | DZINDT | DATS | 8 | DATUM | ||||
ZINRT | Interest calculation frequency in months | DZINRT | NUMC | 2 | ZINRT | ||||
EIKTO | Our account number at customer | EIKTO_D | CHAR | 12 | CHAR12 | ||||
FDGRV | Planning group | FDGRV | CHAR | 10 | T035 | ALPHA | FDGRP | ||
VRBKZ | Export credit insurance institution number | VRBKZ | CHAR | 2 | VRBKZ | ||||
VLIBB | Amount Insured | VLIBB | CURR | 13(2) | WERT7 | ||||
VRSZL | Insurance lead months | VRSZL | DEC | 3 | PACK2 | ||||
VRSPR | Deductible percentage rate | VRSPR | DEC | 3 | PACK2 | ||||
VRSNR | Insurance number | VRSNR | CHAR | 10 | CHAR10 | ||||
VERDT | Insurance validity date | VERDT | DATS | 8 | DATUM | ||||
PERKZ | Collective invoice variant | PERKZ_KNB1 | CHAR | 1 | PERKZ_KNB1 | ||||
XDEZV | Indicator: Local processing? | XDEZV | CHAR | 1 | XFELD | ||||
XAUSZ | Indicator for periodic account statements | XAUSZ | CHAR | 1 | T048K | AUSZG | |||
WEBTR | Bill of exchange limit (in local currency) | WEBTR | CURR | 13(2) | WERT7 | ||||
REMIT | Next payee | REMIT | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
DATLZ | Date of the last interest calculation run | DATLZ | DATS | 8 | DATUM | ||||
XZVER | Indicator: Record Payment History ? | XZVER | CHAR | 1 | XFELD | ||||
TOGRU | Tolerance group for the business partner/G/L account | TOGRU | CHAR | 4 | T043G | TOGRU | |||
KULTG | Probable time until check is paid | KULTG | DEC | 3 | PACK2 | ||||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
XPORE | Indicator: Pay all items separately ? | XPORE | CHAR | 1 | XFELD | ||||
BLNKZ | Subsidy indicator for determining the reduction rates | BLNKZ | CHAR | 2 | BLNKZ | ||||
ALTKN | Previous Master Record Number | ALTKN | CHAR | 10 | CHAR10 | ||||
ZGRUP | Key for Payment Grouping | DZGRUP | CHAR | 2 | TZGR | ZGRUP | |||
URLID | Short Key for Known/Negotiated Leave | URLID | CHAR | 4 | T052A | URLID | |||
MGRUP | Key for dunning notice grouping | MGRUP | CHAR | 2 | T047R | MGRUP |
Key field | Non-key field |
How do I retrieve data from SAP table JGVDB_EWB using ABAP code
The following ABAP code Example will allow you to do a basic selection on JGVDB_EWB to SELECT all data from the tableDATA: WA_JGVDB_EWB TYPE JGVDB_EWB.
SELECT SINGLE *
FROM JGVDB_EWB
INTO CORRESPONDING FIELDS OF WA_JGVDB_EWB
WHERE...
How to access SAP table JGVDB_EWB
Within an ECC or HANA version of SAP you can also view further information about JGVDB_EWB and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects