SAP Table JHTVABRUF
IS-M/AM: Contract Access
JHTVABRUF (IS-M/AM: Contract Access) 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 JHTVABRUF to other SAP tables.
JHTVABRUF table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||
| VTNR | IS-M: Contract Number | ABS_VTNR | JHTVKO | NUMC | 6 | 0 | ||||||||||||||
| POSNR | IS-M: Contract, Item Number | ABS_POSNR | JHTVPO | NUMC | 4 | 0 | ||||||||||||||
| AVM_NR | IS-M/AM: Sales Document Number | AVM_NR | JHAGA | CHAR | 10 | 0 | ||||||||||||||
| POS_NR | IS-M: Order Item Number | POS_NR | JHAGA | NUMC | 3 | 0 | ||||||||||||||
| GRUPPABRNR | IS-M/AM: Billing Dataset | GRUPPABRNR | JHAGA | NUMC | 3 | 0 | ||||||||||||||
| RABATT_NR | IS-M: Class of Discount in a Billing Dataset | RABATT_NR | NUMC | 1 | 0 |
Possible values
|
||||||||||||||
| INSERENT | IS-M: Advertiser | INSERENT | JJVDB_MK_FK | CHAR | 10 | 0 | ||||||||||||||
| AGENTUR | IS-M: Agency | AGENTUR | JGTGPNR | CHAR | 10 | 0 | ||||||||||||||
| PRODH | IS-M/AM: Product Hierarchy | J_PRODH | CHAR | 18 | 0 | |||||||||||||||
| ABR_DAT | IS-M: Allocation Date of Contract Assignment | ABRUF_DAT | DATS | 8 | 0 | |||||||||||||||
| XFAKTURA | IS-M: Billed Assignment Indicator | XFAK_ZUO | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| RABATT | IS-M: Current Valid Contract Discount Rate | AB_RABATT | DEC | 5 | 2 | |||||||||||||||
| BONUS | IS-M/AM: Current Valid Contract Bonus | AKTBONUS | DEC | 5 | 2 | |||||||||||||||
| AB_PREIS | IS-M: Current Valid Price from Contract | AB_PREIS | CURR | 15 | 2 | |||||||||||||||
| FMP_WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||||||||
| FMP_KPEIN | Condition pricing unit | KPEIN | DEC | 5 | 0 | |||||||||||||||
| FMP_KMEIN | Condition unit | KMEIN | T006 | UNIT | 3 | 0 | ||||||||||||||
| KAUSSCHL | IS-M: Condition Exclusion Rule for Media-Mix Contract | JH_KAUSSCHL | TJJV5 | CHAR | 1 | 0 | ||||||||||||||
| XRABATT | IS-M: Assignment Qualifies for Discount | XRABATT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| XMITZRAB | IS-M: Assignment Counts Towards Discount Fulfillment | XMITZRAB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| XBONUS | IS-M: Assignment Qualifies for Bonus | XBONUS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| XMITZBON | IS-M: Assignment Counts Towards Bonus Fulfillment | XMITZBON | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| XMANZUO | IS-M: Level of Manual Influence for a Contract Assignment | XMANZUO | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| XFRZUO | IS-M/AM: Indirect COA Assignment Via Hierarchy | XFRZUO | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| XAZORIG | IS-M: Indicator for Original Contract Assignment | XAZORIG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| XVBZUO | IS-M/AM: COA Assignment From Other Sales Area | XVBZUO | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| XPAR_ABS | IS-M: Work With Parallel Contracts Indicator | XPAR_ABS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| ABR_ZSTAT | IS-M: Settlement Status of the Assignment | ABR_ZSTAT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| XSTORNIERT | IS-M: Canceled Order Object Indicator | XSTORNIERT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | LOEVM_ISP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| VBSTAT | IS-M: Assignment Not Updated in Contract Standing | ABS_VBSTAT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| AB_BRUTTO | IS-M: Contract Gross | AB_BRUTTO | CURR | 15 | 2 | |||||||||||||||
| ABRMM | IS-M: Quantity (mm, Pages, Seconds) | ABRMM | QUAN | 12 | 3 | |||||||||||||||
| ABRME | IS-M: Number | ABRME | DEC | 5 | 0 | |||||||||||||||
| ORIG_VTNR | IS-M: Contract Number | ABS_VTNR | JHTVKO | NUMC | 6 | 0 | ||||||||||||||
| XFR_AVM | IS-M: Assignment from data transfer legacy system indicator | XFR_AVM | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| PSTYV | IS-M: Item Category for Sales Document | PSTYV_PAM | TJHAP | CHAR | 4 | 0 | ||||||||||||||
JHTVABRUF foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JHTVABRUF | AGENTUR | JHTVABRUF | MANDT | JGTGPNR | IS-M: Central Business Partner Table | MANDT |
| JHTVABRUF | AGENTUR | JHTVABRUF | AGENTUR | JGTGPNR | IS-M: Central Business Partner Table | GPNR |
| JHTVABRUF | AVM_NR | JHTVABRUF | AVM_NR | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | AVM_NR |
| JHTVABRUF | AVM_NR | JHTVABRUF | POS_NR | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | POS_NR |
| JHTVABRUF | AVM_NR | JHTVABRUF | GRUPPABRNR | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | GRUPPABRNR |
| JHTVABRUF | AVM_NR | JHTVABRUF | MANDT | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | MANDT |
| JHTVABRUF | FMP_KMEIN | JHTVABRUF | MANDT | T006 | Units of Measurement | MANDT |
| JHTVABRUF | FMP_KMEIN | JHTVABRUF | FMP_KMEIN | T006 | Units of Measurement | MSEHI |
| JHTVABRUF | FMP_WAERS | JHTVABRUF | MANDT | TCURC | Currency Codes | MANDT |
| JHTVABRUF | FMP_WAERS | JHTVABRUF | FMP_WAERS | TCURC | Currency Codes | WAERS |
| JHTVABRUF | GRUPPABRNR | JHTVABRUF | POS_NR | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | POS_NR |
| JHTVABRUF | GRUPPABRNR | JHTVABRUF | GRUPPABRNR | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | GRUPPABRNR |
| JHTVABRUF | GRUPPABRNR | JHTVABRUF | MANDT | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | MANDT |
| JHTVABRUF | GRUPPABRNR | JHTVABRUF | AVM_NR | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | AVM_NR |
| JHTVABRUF | INSERENT | JHTVABRUF | MANDT | JJVDB_MK_FK | Generierte Tabelle zu einem View | MANDT |
| JHTVABRUF | INSERENT | JHTVABRUF | INSERENT | JJVDB_MK_FK | Generierte Tabelle zu einem View | GPNR |
| JHTVABRUF | KAUSSCHL | JHTVABRUF | MANDT | TJJV5 | IS-M: Condition Exclusion Rule | MANDT |
| JHTVABRUF | KAUSSCHL | JHTVABRUF | KAUSSCHL | TJJV5 | IS-M: Condition Exclusion Rule | KAUSSCHL |
| JHTVABRUF | MANDT | JHTVABRUF | MANDT | T000 | Clients | MANDT |
| JHTVABRUF | ORIG_VTNR | JHTVABRUF | MANDT | JHTVKO | IS-M/AM: Contract | MANDT |
| JHTVABRUF | ORIG_VTNR | JHTVABRUF | ORIG_VTNR | JHTVKO | IS-M/AM: Contract | VTNR |
| JHTVABRUF | POSNR | JHTVABRUF | VTNR | JHTVPO | IS-M/AM: Contract Item | VTNR |
| JHTVABRUF | POSNR | JHTVABRUF | POSNR | JHTVPO | IS-M/AM: Contract Item | POSNR |
| JHTVABRUF | POSNR | JHTVABRUF | MANDT | JHTVPO | IS-M/AM: Contract Item | MANDT |
| JHTVABRUF | POS_NR | JHTVABRUF | MANDT | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | MANDT |
| JHTVABRUF | POS_NR | JHTVABRUF | AVM_NR | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | AVM_NR |
| JHTVABRUF | POS_NR | JHTVABRUF | POS_NR | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | POS_NR |
| JHTVABRUF | POS_NR | JHTVABRUF | GRUPPABRNR | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | GRUPPABRNR |
| JHTVABRUF | PSTYV | JHTVABRUF | MANDT | TJHAP | IS-M/AM: Order-Publishing-Media: Item Categories | MANDT |
| JHTVABRUF | PSTYV | JHTVABRUF | PSTYV | TJHAP | IS-M/AM: Order-Publishing-Media: Item Categories | PSTYV |
| JHTVABRUF | VTNR | JHTVABRUF | MANDT | JHTVKO | IS-M/AM: Contract | MANDT |
| JHTVABRUF | VTNR | JHTVABRUF | VTNR | JHTVKO | IS-M/AM: Contract | VTNR |
