SAP Table JJTVV
IS-M/AM: Media Sales Agent Contract
JJTVV (IS-M/AM: Media Sales Agent Contract) 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 JJTVV to other SAP tables.
JJTVV table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
VNR
IS-M: Media Sales Agent Contract Number
|
JVMVVNR |
CHAR
|
10 | 0 | ||||||||||
|
VTYP
IS-M: Contract Category for Media Sales Agent Contract
|
JVERMVTYP |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
VERM
IS-M: Media Sales Agent
|
VERM_MEDIA | JJVDB_MV_FK |
CHAR
|
10 | 0 | |||||||||
|
EKORG
Purchasing Organization
|
EKORG | T024E |
CHAR
|
4 | 0 | |||||||||
|
VKBUR
Sales Office
|
VKBUR | TVBUR |
CHAR
|
4 | 0 | |||||||||
|
VKGRP
Sales Group
|
VKGRP | TVBVK |
CHAR
|
3 | 0 | |||||||||
|
XSTDV
IS-M: Standard Sales Agent Contract Indicator
|
JSTD_VERMV |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
STD_PROSL
IS-M: Standard Commission Key
|
JSTDPROSL | TJH23 |
CHAR
|
5 | 0 | |||||||||
|
POOLNR
IS-M: Media Sales Agent Pool
|
POOLNR | JJTPO |
CHAR
|
6 | 0 | |||||||||
|
VGRUP
IS-M: Media Sales Agent Contract Grouping
|
JVGRUP | TJJV1 |
CHAR
|
6 | 0 | |||||||||
|
KTGRV
IS-M: Account Assignment Group for Sales Agent Contract
|
KTGRV | TJJAF |
CHAR
|
2 | 0 | |||||||||
|
BEZKP
Condition Reference For Sales Vol.Dependent Commission Det.
|
BEZKONDP | TJJ83 |
CHAR
|
2 | 0 | |||||||||
|
BEZKB1
Condition Reference for Determining Sales Agent Bonus 1
|
BEZKONDB1 | TJJ83 |
CHAR
|
2 | 0 | |||||||||
|
BEZKB2
Condition Reference for Determining Sales Agent Bonus 2
|
BEZKONDB2 | TJJ83 |
CHAR
|
2 | 0 | |||||||||
|
KALSK
IS-M: Sales Agent Det.Proc. (for Pricing Proc.Determination)
|
JKALKSK | TJJ85 |
CHAR
|
2 | 0 | |||||||||
|
PERNR
IS-M: Personnel Number
|
JJPERNR |
CHAR
|
20 | 0 | ||||||||||
|
ABRKP
IS-M: Commission Settlement Calendar for Media Sales Agent
|
JABRKALVMP | TJJ81 |
CHAR
|
2 | 0 | |||||||||
|
ABRKB1
IS-M/AM: Bonus Settlement Calendar 1 for Media Sales Agent
|
JABRKALVMB | TJJ81 |
CHAR
|
2 | 0 | |||||||||
|
ABRKB2
IS-M: Bonus Settlement Calendar 2 for Media Sales Agent
|
JABRKALVM2 | TJJ81 |
CHAR
|
2 | 0 | |||||||||
|
BO1SL
IS-M/AM: Bonus 1: Commission Key for Media Sales Agent
|
JJBONSCHL1 | TJH23 |
CHAR
|
5 | 0 | |||||||||
|
BO2SL
IS-M: Bonus 2: Commission Key for Media Sales Agent
|
JJBONSCHL2 | TJH23 |
CHAR
|
5 | 0 | |||||||||
|
ZTERM
Terms of Payment Key
|
DZTERM | T052 |
CHAR
|
4 | 0 | |||||||||
|
WAERS
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||
|
KURST
Exchange Rate Type
|
KURST | TCURV |
CHAR
|
4 | 0 | |||||||||
|
GPNR_ZE
IS-M/SD: Business Partner Alternative Payee
|
GPNR_ZE | JGTGPNR |
CHAR
|
10 | 0 | |||||||||
|
TACLGP
Tax Classification for Media Sales Agent Business Partner
|
JTACLGPMV | TJJ35 |
CHAR
|
1 | 0 | |||||||||
|
UEBERLART
IS-M: Transfer Destination
|
UEBERLZIEL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XLOESCHVM
Deletion Flag for Master Data in Media Sales & Distribution
|
LOEVM_ISP |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XLOESCHKZ
Deletion Indicator for Master Data in Media Sales & Dist.
|
LOEKZ_ISP |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
KURZTEXT
IS-M: Short Text
|
BEZEICHN15 |
CHAR
|
15 | 0 | ||||||||||
|
LANGTEXT
IS-M: Long Text
|
BEZEICHN50 |
CHAR
|
50 | 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 | ||||||||||
|
LAST_BEDNR
IS-M: Number of Media Sales Agent Contract Requirement
|
VM_BEDNR |
NUMC
|
6 | 0 | ||||||||||
JJTVV foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| JJTVV | ABRKB1 | SYST | MANDT |
TJJ81
IS-M/AM: Settlement Calendar for Media Sales Agent
|
MANDT |
| JJTVV | ABRKB1 | JJTVV | ABRKB1 |
TJJ81
IS-M/AM: Settlement Calendar for Media Sales Agent
|
IDENT |
| JJTVV | ABRKB2 | SYST | MANDT |
TJJ81
IS-M/AM: Settlement Calendar for Media Sales Agent
|
MANDT |
| JJTVV | ABRKB2 | JJTVV | ABRKB2 |
TJJ81
IS-M/AM: Settlement Calendar for Media Sales Agent
|
IDENT |
| JJTVV | ABRKP | SYST | MANDT |
TJJ81
IS-M/AM: Settlement Calendar for Media Sales Agent
|
MANDT |
| JJTVV | ABRKP | JJTVV | ABRKP |
TJJ81
IS-M/AM: Settlement Calendar for Media Sales Agent
|
IDENT |
| JJTVV | BEZKB1 | '01' |
TJJ83
IS-M/AM: Condition Reference
|
BEZ_TYP | |
| JJTVV | BEZKB1 | JJTVV | BEZKB1 |
TJJ83
IS-M/AM: Condition Reference
|
BEZKOND |
| JJTVV | BEZKB1 | SYST | MANDT |
TJJ83
IS-M/AM: Condition Reference
|
MANDT |
| JJTVV | BEZKB2 | SYST | MANDT |
TJJ83
IS-M/AM: Condition Reference
|
MANDT |
| JJTVV | BEZKB2 | '01' |
TJJ83
IS-M/AM: Condition Reference
|
BEZ_TYP | |
| JJTVV | BEZKB2 | JJTVV | BEZKB2 |
TJJ83
IS-M/AM: Condition Reference
|
BEZKOND |
| JJTVV | BEZKP | '01' |
TJJ83
IS-M/AM: Condition Reference
|
BEZ_TYP | |
| JJTVV | BEZKP | JJTVV | BEZKP |
TJJ83
IS-M/AM: Condition Reference
|
BEZKOND |
| JJTVV | BEZKP | SYST | MANDT |
TJJ83
IS-M/AM: Condition Reference
|
MANDT |
| JJTVV | BO1SL | SYST | MANDT |
TJH23
IS-M/AM: Commission Key for Media Sales Agent
|
MANDT |
| JJTVV | BO1SL | JJTVV | BO1SL |
TJH23
IS-M/AM: Commission Key for Media Sales Agent
|
PRSCHL |
| JJTVV | BO2SL | SYST | MANDT |
TJH23
IS-M/AM: Commission Key for Media Sales Agent
|
MANDT |
| JJTVV | BO2SL | JJTVV | BO2SL |
TJH23
IS-M/AM: Commission Key for Media Sales Agent
|
PRSCHL |
| JJTVV | EKORG | JJTVV | MANDT |
T024E
Purchasing Organizations
|
MANDT |
| JJTVV | EKORG | JJTVV | EKORG |
T024E
Purchasing Organizations
|
EKORG |
| JJTVV | GPNR_ZE | JJTVV | MANDT |
JGTGPNR
IS-M: Central Business Partner Table
|
MANDT |
| JJTVV | GPNR_ZE | JJTVV | GPNR_ZE |
JGTGPNR
IS-M: Central Business Partner Table
|
GPNR |
| JJTVV | KALSK | JJTVV | MANDT |
TJJ85
Sales Agent Procedure (for Pricing Procedure Determination)
|
MANDT |
| JJTVV | KALSK | JJTVV | KALSK |
TJJ85
Sales Agent Procedure (for Pricing Procedure Determination)
|
KALSK |
| JJTVV | KTGRV | JJTVV | KTGRV |
TJJAF
IS-M/AM: Account Assignment Group for Sales Agent Contract
|
KTGRV |
| JJTVV | KTGRV | JJTVV | MANDT |
TJJAF
IS-M/AM: Account Assignment Group for Sales Agent Contract
|
MANDT |
| JJTVV | KURST | SYST | MANDT |
TCURV
Exchange rate types for currency translation
|
MANDT |
| JJTVV | KURST | JJTVV | KURST |
TCURV
Exchange rate types for currency translation
|
KURST |
| JJTVV | MANDT | JJTVV | MANDT |
T000
Clients
|
MANDT |
| JJTVV | POOLNR | SYST | MANDT |
JJTPO
IS-M/AM: Media Sales Agent Pool
|
MANDT |
| JJTVV | POOLNR | JJTVV | POOLNR |
JJTPO
IS-M/AM: Media Sales Agent Pool
|
POOLNR |
| JJTVV | STD_PROSL | SYST | MANDT |
TJH23
IS-M/AM: Commission Key for Media Sales Agent
|
MANDT |
| JJTVV | STD_PROSL | JJTVV | STD_PROSL |
TJH23
IS-M/AM: Commission Key for Media Sales Agent
|
PRSCHL |
| JJTVV | TACLGP | SYST | MANDT |
TJJ35
IS-M/AM: Vendor Tax Classification
|
MANDT |
| JJTVV | TACLGP | TJJAJ | TATYP |
TJJ35
IS-M/AM: Vendor Tax Classification
|
TATYP |
| JJTVV | TACLGP | JJTVV | TACLGP |
TJJ35
IS-M/AM: Vendor Tax Classification
|
TACLGP |
| JJTVV | VERM | JJTVV | MANDT |
JJVDB_MV_FK
Generierte Tabelle zu einem View
|
MANDT |
| JJTVV | VERM | JJTVV | VERM |
JJVDB_MV_FK
Generierte Tabelle zu einem View
|
GPNR |
| JJTVV | VGRUP | SYST | MANDT |
TJJV1
IS-M/AM: Sales Agent Contract Datasets
|
MANDT |
| JJTVV | VGRUP | JJTVV | VGRUP |
TJJV1
IS-M/AM: Sales Agent Contract Datasets
|
VGRUP |
| JJTVV | VKBUR | JJTVV | MANDT |
TVBUR
Organizational Unit: Sales Offices
|
MANDT |
| JJTVV | VKBUR | JJTVV | VKBUR |
TVBUR
Organizational Unit: Sales Offices
|
VKBUR |
| JJTVV | VKGRP | SYST | MANDT |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
MANDT |
| JJTVV | VKGRP | JJTVV | VKBUR |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
VKBUR |
| JJTVV | VKGRP | JJTVV | VKGRP |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
VKGRP |
| JJTVV | WAERS | JJTVV | MANDT |
TCURC
Currency Codes
|
MANDT |
| JJTVV | WAERS | JJTVV | WAERS |
TCURC
Currency Codes
|
WAERS |
| JJTVV | ZTERM | * |
T052
Terms of Payment
|
ZTAGG | |
| JJTVV | ZTERM | SY | MANDT |
T052
Terms of Payment
|
MANDT |
| JJTVV | ZTERM | JJTVV | ZTERM |
T052
Terms of Payment
|
ZTERM |