1. Home
  2. Resources
  3. SAP Tables
  4. JJVVE - Generated Table for View

SAP Table JJVVE

Generated Table for View

JJVVE (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link JJVVE to other SAP tables.

JJVVE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
VANR IS-M: Extra commission/exclusion JVANR CHAR 5 0
GUELTIGAB IS-M: "Valid From" Date DATEVALFRM DATS 8 0
GUELTIGBIS IS-M: "Valid To" Date DATEVALTO DATS 8 0
XLOESCHVM Deletion Flag for Master Data in Media Sales & Distribution LOEVM_ISP CHAR 1 0
X Yes
NULL No
BEDART IS-M: Requirement Type for Extra Commission Entitlement JJBEDARTZP TJJ73 CHAR 2 0
BEDGR IS-M: Media Sales Agent Requirement Group BEDGR TJJ77 CHAR 2 0
PROSL IS-M/AM: Commission Key for Media Sales Agent JPROVSCHL TJH23 CHAR 5 0
KURZTEXT IS-M: Short Text BEZEICHN15 CHAR 15 0
ZUOFUNKT IS-M: Assignment Function (Inclusive, Exclusive) JZFKT CHAR 1 0
NULL Inclusive assignment
- Exclusive assignment
BELEINH IS-M/AM: Booking Unit BELEGEINH JJTBE CHAR 10 0
INHK_TECH2 IS-M: Special Publication Content Component INHK_SOVER JJTIKO CHAR 8 0
INHK_KFM IS-M: Business Content Component INHK_KFM JJTIKO CHAR 8 0
AVMPOS_ART IS-M: Order-Publishing-Media - Item Type AVMPOS_ART TJH17 CHAR 2 0
BRAN1 IS-M: Industry Sector for Advertiser BRAN_PAM TBRC CHAR 10 0
KUKARR IS-M: Customer Profile JKUKARR TJJ95 CHAR 2 0
IN_GPNR IS-M: Advertiser INSERENT JJVDB_MK_FK CHAR 10 0
AR_GPNR IS-M: Agency AGENTUR JGTGPNR CHAR 10 0
BEZIRK_AG IS-M: Sales Agent Zone of the Agency VERMBEZ_AG JVTBEZIRK CHAR 10 0
BEZIRK_IS IS-M: Sales Agent Zone of Advertiser VERMBEZ_IS JVTBEZIRK CHAR 10 0
PRDHA IS-M/AM: Product Hierarchy J_PRODH JJT179 CHAR 18 0
VTNR IS-M: Contract Number ABS_VTNR JHTVKO NUMC 6 0
MATNR IS-M: Service material number MATNR_DIEN JJTDIEN CHAR 18 0
DIENTYP IS-M: Service Type DIENTYP TJH71 CHAR 4 0
FATBB1 IS-M: Free Attribute 1 Requirement Element JJFATBB1 TJJFA CHAR 1 0
FATBB2 IS-M: Free Attribute 2 Requirement Element JJFATBB2 TJJFC CHAR 1 0
FATBB3 IS-M: Free Attribute 3 Requirement Element JJFATBB3 TJJFE CHAR 1 0
FATBB4 IS-M: Free Attribute 4 Requirement Element JJFATBB4 TJJFG CHAR 2 0
FATBB5 IS-M: Free Attribute 5 Requirement Element JJFATBB5 TJJFI CHAR 2 0
FATBB6 IS-M: Free Attribute 6 Requirement Element JJFATBB6 TJJFK CHAR 4 0
FATBB7 IS-M: Free Attribute 7 Requirement Element JJFATBB7 TJJFM CHAR 10 0
ERFUSER Created By ERFUSER CHAR 12 0
ERFDATE Created On ERFDATE DATS 8 0
ERFTIME Time Created ERFTIME TIMS 6 0
AENUSER Last Changed By AENUSER CHAR 12 0
AENDATE Date of Last Change AENDATE DATS 8 0
AENTIME Time of Last Change AENTIME TIMS 6 0
FAUS IS-M: Field Selection String for an Element JVMVFAUS CHAR 50 0
BEDARTT IS-M: Short Text BEZEICHN15 CHAR 15 0
BEDGRT IS-M: Short Text BEZEICHN15 CHAR 15 0
VKORGT Name VTXTK CHAR 20 0
VTWEGT Name VTXTK CHAR 20 0
SPARTT Name VTXTK CHAR 20 0
PROSLT IS-M: Short Text BEZEICHN15 CHAR 15 0

JJVVE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JJVVE AR_GPNR SYST MANDT JGTGPNR IS-M: Central Business Partner Table MANDT
JJVVE AR_GPNR JJVVE AR_GPNR JGTGPNR IS-M: Central Business Partner Table GPNR
JJVVE AVMPOS_ART JJVVE AVMPOS_ART TJH17 IS-M/AM: OPM Item Type AVMPOS_ART
JJVVE AVMPOS_ART SYST MANDT TJH17 IS-M/AM: OPM Item Type MANDT
JJVVE BEDART JJVVE BEDART TJJ73 IS-M/AM: Requirement Type for Media Sales Agent Contract BEDART
JJVVE BEDART JJVVE MANDT TJJ73 IS-M/AM: Requirement Type for Media Sales Agent Contract MANDT
JJVVE BEDGR JJVVE MANDT TJJ77 IS-M/AM: Requirements Group for Media Sales Agent Contract MANDT
JJVVE BEDGR JJVVE BEDGR TJJ77 IS-M/AM: Requirements Group for Media Sales Agent Contract BEDGR
JJVVE BELEINH SYST MANDT JJTBE IS-M/AM: Booking Units MANDT
JJVVE BELEINH JJVVE BELEINH JJTBE IS-M/AM: Booking Units BELEINH
JJVVE BEZIRK_AG SYST MANDT JVTBEZIRK IS-M: Carrier Route (Generalization) MANDT
JJVVE BEZIRK_AG JJVVE BEZIRK_AG JVTBEZIRK IS-M: Carrier Route (Generalization) BEZIRK
JJVVE BEZIRK_IS JJVVE BEZIRK_IS JVTBEZIRK IS-M: Carrier Route (Generalization) BEZIRK
JJVVE BEZIRK_IS SYST MANDT JVTBEZIRK IS-M: Carrier Route (Generalization) MANDT
JJVVE BRAN1 SYST MANDT TBRC Industry Code (Customer Master) MANDT
JJVVE BRAN1 JJVVE BRAN1 TBRC Industry Code (Customer Master) BRACO
JJVVE DIENTYP SYST MANDT TJH71 IS-M/AM: Service Type MANDT
JJVVE DIENTYP JJVVE DIENTYP TJH71 IS-M/AM: Service Type DIENTYP
JJVVE FATBB1 SYST MANDT TJJFA IS-M/AM: Free Attribute 1 Requirement Element MANDT
JJVVE FATBB1 JJVVE FATBB1 TJJFA IS-M/AM: Free Attribute 1 Requirement Element FATBB1
JJVVE FATBB2 SYST MANDT TJJFC IS-M/AM: Free Attribute 2 Requirement Element MANDT
JJVVE FATBB2 JJVVE FATBB2 TJJFC IS-M/AM: Free Attribute 2 Requirement Element FATBB2
JJVVE FATBB3 JJVVE FATBB3 TJJFE IS-M/AM: Free Attribute 3 Requirement Element FATBB3
JJVVE FATBB3 SYST MANDT TJJFE IS-M/AM: Free Attribute 3 Requirement Element MANDT
JJVVE FATBB4 SYST MANDT TJJFG IS-M/AM: Free Attribute 4 Requirement Element MANDT
JJVVE FATBB4 JJVVE FATBB4 TJJFG IS-M/AM: Free Attribute 4 Requirement Element FATBB4
JJVVE FATBB5 SYST MANDT TJJFI IS-M/AM: Free Attribute 5 Requirement Element MANDT
JJVVE FATBB5 JJVVE FATBB5 TJJFI IS-M/AM: Free Attribute 5 Requirement Element FATBB5
JJVVE FATBB6 JJVVE FATBB6 TJJFK IS-M/AM: Free Attribute 6 Requirement Element FATBB6
JJVVE FATBB6 SYST MANDT TJJFK IS-M/AM: Free Attribute 6 Requirement Element MANDT
JJVVE FATBB7 SYST MANDT TJJFM IS-M/AM: Free Attribute 7 Requirement Element MANDT
JJVVE FATBB7 JJVVE FATBB7 TJJFM IS-M/AM: Free Attribute 7 Requirement Element FATBB7
JJVVE INHK_KFM SYST MANDT JJTIKO IS-M/AM: Content Component MANDT
JJVVE INHK_KFM JJVVE INHK_KFM JJTIKO IS-M/AM: Content Component INHALTSKOM
JJVVE INHK_TECH2 SYST MANDT JJTIKO IS-M/AM: Content Component MANDT
JJVVE INHK_TECH2 JJVVE INHK_TECH2 JJTIKO IS-M/AM: Content Component INHALTSKOM
JJVVE IN_GPNR SYST MANDT JJVDB_MK_FK Generierte Tabelle zu einem View MANDT
JJVVE IN_GPNR JJVVE IN_GPNR JJVDB_MK_FK Generierte Tabelle zu einem View GPNR
JJVVE KUKARR SYST MANDT TJJ95 IS-M/AM: Customer Status MANDT
JJVVE KUKARR JJVVE KUKARR TJJ95 IS-M/AM: Customer Status KUKARR
JJVVE MANDT JJVVE MANDT T000 Clients MANDT
JJVVE MATNR SYST MANDT JJTDIEN IS-M/AM: Service MANDT
JJVVE MATNR JJVVE MATNR JJTDIEN IS-M/AM: Service MATNR
JJVVE PRDHA JJVVE MANDT JJT179 IS-M/AM: Product Hierarchy MANDT
JJVVE PRDHA JJVVE PRDHA JJT179 IS-M/AM: Product Hierarchy PRODH
JJVVE PROSL JJVVE MANDT TJH23 IS-M/AM: Commission Key for Media Sales Agent MANDT
JJVVE PROSL JJVVE PROSL TJH23 IS-M/AM: Commission Key for Media Sales Agent PRSCHL
JJVVE SPART JJVVE MANDT TSPA Organizational Unit: Sales Divisions MANDT
JJVVE SPART JJVVE SPART TSPA Organizational Unit: Sales Divisions SPART
JJVVE VKORG JJVVE MANDT TVKO Organizational Unit: Sales Organizations MANDT
JJVVE VKORG JJVVE VKORG TVKO Organizational Unit: Sales Organizations VKORG
JJVVE VTNR JJVVE VTNR JHTVKO IS-M/AM: Contract VTNR
JJVVE VTNR SYST MANDT JHTVKO IS-M/AM: Contract MANDT
JJVVE VTWEG JJVVE MANDT TVTW Organizational Unit: Distribution Channels MANDT
JJVVE VTWEG JJVVE VTWEG TVTW Organizational Unit: Distribution Channels VTWEG