SAP ABAP Table JHTVABRUF (IS-M/AM: Contract Access)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷
IS-M (Application Component) SAP Media
⤷
JAS (Package) Application development R/3 Publishing Advertising System***
IS-M (Software Component) SAP MEDIA⤷
IS-M (Application Component) SAP Media⤷
JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | JHTVABRUF |
Table Relationship Diagram 
|
| Short Description | IS-M/AM: Contract Access |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | VTNR |
ABS_VTNR | ABS_VTNR | NUMC | 6 | 0 | IS-M: Contract Number | JHTVKO | |
| 3 | POSNR |
ABS_POSNR | ABS_POSNR | NUMC | 4 | 0 | IS-M: Contract, Item Number | JHTVPO | |
| 4 | AVM_NR |
AVM_NR | AVM_NR | CHAR | 10 | 0 | IS-M/AM: Sales Document Number | JHAGA | |
| 5 | POS_NR |
POS_NR | AVM_PNR | NUMC | 3 | 0 | IS-M: Order Item Number | JHAGA | |
| 6 | GRUPPABRNR |
GRUPPABRNR | GRUPPABR | NUMC | 3 | 0 | IS-M/AM: Billing Dataset | JHAGA | |
| 7 | RABATT_NR |
RABATT_NR | RABATT_NR | NUMC | 1 | 0 | IS-M: Class of Discount in a Billing Dataset | ||
| 8 | INSERENT |
INSERENT | GPNR | CHAR | 10 | 0 | IS-M: Advertiser | JJVDB_MK_FK | |
| 9 | AGENTUR |
AGENTUR | GPNR | CHAR | 10 | 0 | IS-M: Agency | JGTGPNR | |
| 10 | PRODH |
J_PRODH | J_PRODH | CHAR | 18 | 0 | IS-M/AM: Product Hierarchy | * | |
| 11 | ABR_DAT |
ABRUF_DAT | DATUM | DATS | 8 | 0 | IS-M: Allocation Date of Contract Assignment | ||
| 12 | XFAKTURA |
XFAK_ZUO | XFELD | CHAR | 1 | 0 | IS-M: Billed Assignment Indicator | ||
| 13 | RABATT |
AB_RABATT | RABATT | DEC | 5 | 2 | IS-M: Current Valid Contract Discount Rate | ||
| 14 | BONUS |
AKTBONUS | RABATT | DEC | 5 | 2 | IS-M/AM: Current Valid Contract Bonus | ||
| 15 | AB_PREIS |
AB_PREIS | WERTV8 | CURR | 15 | 2 | IS-M: Current Valid Price from Contract | ||
| 16 | FMP_WAERS |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
| 17 | FMP_KPEIN |
KPEIN | KPEIN | DEC | 5 | 0 | Condition pricing unit | ||
| 18 | FMP_KMEIN |
KMEIN | MEINS | UNIT | 3 | 0 | Condition Unit | T006 | |
| 19 | KAUSSCHL |
JH_KAUSSCHL | JH_KAUSSCHL | CHAR | 1 | 0 | IS-M: Condition Exclusion Rule for Media-Mix Contract | TJJV5 | |
| 20 | XRABATT |
XRABATT | XFELD | CHAR | 1 | 0 | IS-M: Assignment Qualifies for Discount | ||
| 21 | XMITZRAB |
XMITZRAB | XFELD | CHAR | 1 | 0 | IS-M: Assignment Counts Towards Discount Fulfillment | ||
| 22 | XBONUS |
XBONUS | XFELD | CHAR | 1 | 0 | IS-M: Assignment Qualifies for Bonus | ||
| 23 | XMITZBON |
XMITZBON | XFELD | CHAR | 1 | 0 | IS-M: Assignment Counts Towards Bonus Fulfillment | ||
| 24 | XMANZUO |
XMANZUO | JH_MANZUO | CHAR | 1 | 0 | IS-M: Level of Manual Influence for a Contract Assignment | ||
| 25 | XFRZUO |
XFRZUO | XFELD | CHAR | 1 | 0 | IS-M/AM: Indirect COA Assignment Via Hierarchy | ||
| 26 | XAZORIG |
XAZORIG | XFELD | CHAR | 1 | 0 | IS-M: Indicator for Original Contract Assignment | ||
| 27 | XVBZUO |
XVBZUO | XFELD | CHAR | 1 | 0 | IS-M/AM: COA Assignment From Other Sales Area | ||
| 28 | XPAR_ABS |
XPAR_ABS | XFELD | CHAR | 1 | 0 | IS-M: Work With Parallel Contracts Indicator | ||
| 29 | ABR_ZSTAT |
ABR_ZSTAT | ABR_ZSTAT | CHAR | 1 | 0 | IS-M: Settlement Status of the Assignment | ||
| 30 | XSTORNIERT |
XSTORNIERT | XFELD | CHAR | 1 | 0 | IS-M: Canceled Order Object Indicator | ||
| 31 | XLOEVM |
LOEVM_ISP | XFELD | CHAR | 1 | 0 | Deletion Flag for Master Data in Media Sales & Distribution | ||
| 32 | VBSTAT |
ABS_VBSTAT | ABS_VBSTAT | CHAR | 1 | 0 | IS-M: Assignment Not Updated in Contract Standing | ||
| 33 | AB_BRUTTO |
AB_BRUTTO | WERTV8 | CURR | 15 | 2 | IS-M: Contract Gross | ||
| 34 | ABRMM |
ABRMM | SAEMM | QUAN | 12 | 3 | IS-M: Quantity (mm, Pages, Seconds) | ||
| 35 | ABRME |
ABRME | SAEME | DEC | 5 | 0 | IS-M: Number | ||
| 36 | ORIG_VTNR |
ABS_VTNR | ABS_VTNR | NUMC | 6 | 0 | IS-M: Contract Number | JHTVKO | |
| 37 | XFR_AVM |
XFR_AVM | XFELD | CHAR | 1 | 0 | IS-M: Assignment from data transfer legacy system indicator | ||
| 38 | PSTYV |
PSTYV_PAM | PSTYV_PAM | CHAR | 4 | 0 | IS-M: Item Category for Sales Document | TJHAP |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | JHTVABRUF | AGENTUR |  JGTGPNR |
GPNR |
|||
| 2 | JHTVABRUF | AVM_NR | JHAGA |
AVM_NR |
KEY | 1 | CN |
| 3 | JHTVABRUF | FMP_KMEIN | T006 |
MSEHI |
REF | C | CN |
| 4 | JHTVABRUF | FMP_WAERS | TCURC |
WAERS |
REF | C | CN |
| 5 | JHTVABRUF | GRUPPABRNR | JHAGA |
GRUPPABRNR |
KEY | 1 | CN |
| 6 | JHTVABRUF | INSERENT | JJVDB_MK_FK |
GPNR |
REF | 1 | CN |
| 7 | JHTVABRUF | KAUSSCHL | TJJV5 |
KAUSSCHL |
REF | C | CN |
| 8 | JHTVABRUF | MANDT | T000 |
MANDT |
KEY | 1 | CN |
| 9 | JHTVABRUF | ORIG_VTNR | JHTVKO |
VTNR |
REF | C | CN |
| 10 | JHTVABRUF | POSNR | JHTVPO |
POSNR |
KEY | 1 | CN |
| 11 | JHTVABRUF | POS_NR | JHAGA |
POS_NR |
KEY | 1 | CN |
| 12 | JHTVABRUF | PSTYV | TJHAP |
PSTYV |
REF | C | CN |
| 13 | JHTVABRUF | VTNR | JHTVKO |
VTNR |
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20050224 |
| SAP Release Created in |
