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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||
| 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 |
Possible values
|
||||||||
| 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 |
Possible values
|
||||||||
| XLOESCHVM | Deletion Flag for Master Data in Media Sales & Distribution | LOEVM_ISP | CHAR | 1 | 0 |
Possible values
|
||||||||
| XLOESCHKZ | Deletion Indicator for Master Data in Media Sales & Dist. | LOEKZ_ISP | CHAR | 1 | 0 |
Possible values
|
||||||||
| 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 | JJTVV | ABRKP | 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 | BEZKB1 | SYST | MANDT | TJJ83 | IS-M/AM: Condition Reference | MANDT |
| JJTVV | BEZKB1 | '01' | TJJ83 | IS-M/AM: Condition Reference | BEZ_TYP | |
| JJTVV | BEZKB1 | JJTVV | BEZKB1 | TJJ83 | IS-M/AM: Condition Reference | BEZKOND |
| JJTVV | BEZKB2 | JJTVV | BEZKB2 | TJJ83 | IS-M/AM: Condition Reference | BEZKOND |
| JJTVV | BEZKB2 | SYST | MANDT | TJJ83 | IS-M/AM: Condition Reference | MANDT |
| JJTVV | BEZKB2 | '01' | TJJ83 | IS-M/AM: Condition Reference | BEZ_TYP | |
| JJTVV | BEZKP | SYST | MANDT | TJJ83 | IS-M/AM: Condition Reference | MANDT |
| JJTVV | BEZKP | '01' | TJJ83 | IS-M/AM: Condition Reference | BEZ_TYP | |
| JJTVV | BEZKP | JJTVV | BEZKP | TJJ83 | IS-M/AM: Condition Reference | BEZKOND |
| 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 | KALSK | TJJ85 | Sales Agent Procedure (for Pricing Procedure Determination) | KALSK |
| JJTVV | KALSK | JJTVV | MANDT | TJJ85 | Sales Agent Procedure (for Pricing Procedure Determination) | MANDT |
| JJTVV | KTGRV | JJTVV | MANDT | TJJAF | IS-M/AM: Account Assignment Group for Sales Agent Contract | MANDT |
| JJTVV | KTGRV | JJTVV | KTGRV | TJJAF | IS-M/AM: Account Assignment Group for Sales Agent Contract | KTGRV |
| 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 | SY | MANDT | T052 | Terms of Payment | MANDT |
| JJTVV | ZTERM | JJTVV | ZTERM | T052 | Terms of Payment | ZTERM |
| JJTVV | ZTERM | * | T052 | Terms of Payment | ZTAGG | |
