SAP Table JJTVB
IS-M/AM: Requirement in Media Sales Agent Contract
JJTVB (IS-M/AM: Requirement in 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 JJTVB to other SAP tables.
JJTVB 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 | JJTVV | CHAR | 10 | 0 | ||||||||||
| BEDNR | IS-M: Number of Media Sales Agent Contract Requirement | VM_BEDNR | NUMC | 6 | 0 | |||||||||||
| GUELTIGAB | IS-M: "Valid From" Date | DATEVALFRM | DATS | 8 | 0 | |||||||||||
| GUELTIGBIS | IS-M: "Valid To" Date | DATEVALTO | DATS | 8 | 0 | |||||||||||
| BEDART | IS-M/AM: Requirement Type in Media Sales Agent Contract | VMBEDART | TJJ73 | CHAR | 2 | 0 | ||||||||||
| BEDGR | IS-M: Media Sales Agent Requirement Group | BEDGR | TJJ77 | CHAR | 2 | 0 | ||||||||||
| XSTDBED | IS-M: Standard Requirement | JSTDBED | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PROSL | IS-M/AM: Commission Key for Media Sales Agent | JPROVSCHL | TJH23 | CHAR | 5 | 0 | ||||||||||
| XPROV | IS-M: Qualifies for Commission Indicator | XJPROVI | CHAR | 1 | 0 |
Possible values
|
||||||||||
| XBONUS | IS-M: Indicator: Qualifies for Bonus 1 | XBONUS1 | CHAR | 1 | 0 |
Possible values
|
||||||||||
| XBONUS2 | IS-M: Indicates: Qualifies for Bonus 2 | XBONUS2 | CHAR | 1 | 0 |
Possible values
|
||||||||||
| XSTEIG | IS-M: Can be Incremented Indicator | XJSTEIG | CHAR | 1 | 0 |
Possible values
|
||||||||||
| XBERICHT | IS-M/AM: Report Required, Reference to Partner (Role) | XBESBERICH | CHAR | 1 | 0 |
Possible values
|
||||||||||
| XVORAUS | IS-M: Payment Granted in Advance | XJVORAUS | CHAR | 1 | 0 |
Possible values
|
||||||||||
| JVERMART | IS-M: Media Sales Agent Type: General/City/Special Agent | JVERMART | TJJ09 | CHAR | 2 | 0 | ||||||||||
| XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | LOEVM_ISP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| XLOEKZ | Deletion Indicator for Master Data in Media Sales & Dist. | LOEKZ_ISP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| VOR_VNR | IS-M: Sales Agnt Contract: Contract No.of Preliminary Req. | VOR_VNR | JJTVV | CHAR | 10 | 0 | ||||||||||
| VOR_BEDNR | Sales Agent Contract: Number of the Preliminary Requirement | VOR_BEDNR | JJTVB | NUMC | 6 | 0 | ||||||||||
| XNOGVZ | IS-M: Do Not Create Sales Agent Assignment Indicator | XNOGVZ | 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_BESNR | IS-M: Element Number in Media Agent Contract | JBESTNR_EX | NUMC | 6 | 0 | |||||||||||
JJTVB foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JJTVB | BEDART | JJTVB | MANDT | TJJ73 | IS-M/AM: Requirement Type for Media Sales Agent Contract | MANDT |
| JJTVB | BEDART | JJTVB | BEDART | TJJ73 | IS-M/AM: Requirement Type for Media Sales Agent Contract | BEDART |
| JJTVB | BEDGR | JJTVB | BEDGR | TJJ77 | IS-M/AM: Requirements Group for Media Sales Agent Contract | BEDGR |
| JJTVB | BEDGR | SYST | MANDT | TJJ77 | IS-M/AM: Requirements Group for Media Sales Agent Contract | MANDT |
| JJTVB | JVERMART | SYST | MANDT | TJJ09 | IS-M/AM: Sales Agent Types | MANDT |
| JJTVB | JVERMART | JJTVB | JVERMART | TJJ09 | IS-M/AM: Sales Agent Types | JVERMART |
| JJTVB | MANDT | JJTVB | MANDT | T000 | Clients | MANDT |
| JJTVB | PROSL | SYST | MANDT | TJH23 | IS-M/AM: Commission Key for Media Sales Agent | MANDT |
| JJTVB | PROSL | JJTVB | PROSL | TJH23 | IS-M/AM: Commission Key for Media Sales Agent | PRSCHL |
| JJTVB | VNR | JJTVB | VNR | JJTVV | IS-M/AM: Media Sales Agent Contract | VNR |
| JJTVB | VNR | JJTVB | MANDT | JJTVV | IS-M/AM: Media Sales Agent Contract | MANDT |
| JJTVB | VOR_BEDNR | SYST | MANDT | JJTVB | IS-M/AM: Requirement in Media Sales Agent Contract | MANDT |
| JJTVB | VOR_BEDNR | JJTVB | VOR_VNR | JJTVB | IS-M/AM: Requirement in Media Sales Agent Contract | VNR |
| JJTVB | VOR_BEDNR | JJTVB | VOR_BEDNR | JJTVB | IS-M/AM: Requirement in Media Sales Agent Contract | BEDNR |
| JJTVB | VOR_VNR | SYST | MANDT | JJTVV | IS-M/AM: Media Sales Agent Contract | MANDT |
| JJTVB | VOR_VNR | JJTVB | VOR_VNR | JJTVV | IS-M/AM: Media Sales Agent Contract | VNR |
