JHTVAABK SAP (IS-M/AM: Contract Settlement Header Data) Table details
Dictionary Type: Table
Description: IS-M/AM: Contract Settlement Header Data
Description: IS-M/AM: Contract Settlement Header Data
Table field list including key, data, relationships and ABAP select examples
JHTVAABK is a standard SAP Table which is used to store IS-M/AM: Contract Settlement Header Data data and is available within R/3 SAP systems depending on the version and release level.
The JHTVAABK table consists of various fields, each holding specific information or linking keys about IS-M/AM: Contract Settlement Header Data data available in SAP. These include VTNR (IS-M: Contract Number), ABRGNR (IS-M/AM: Contract Settlement Number), VKORG (Sales Organization), VTWEG (Distribution Channel).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP JHTVAABK table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VTNR | IS-M: Contract Number | ABS_VTNR | NUMC | 6 | JHTVKO | ABS_VTNR | JHW | MJHW | |
ABRGNR | IS-M/AM: Contract Settlement Number | ABRGNR | NUMC | 4 | ABRGNR | ||||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVKOV | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | TVTA | SPART | SPA | C_SPART | |
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVKBZ | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | VKGRP | VKG | ||
ABRECHK | IS-M: Settlement Type | ABRECHK | CHAR | 1 | TJH15 | ABRECHK | |||
JHABRDAT | IS-M: Contract Settlement Date | JHABRDAT | DATS | 8 | DATUM | ||||
R_DATUM | IS-M: Date of Last Interim/Final Settlement | R_DATUM | DATS | 8 | DATUM | ||||
ABS_TYP1 | IS-M/AM: Contract Category | ABS_TYP | CHAR | 1 | TJH11 | ABS_TYP | JHM_TYP | ||
XBEST_PR | IS-M: Apply Best Conditions to Number / Quantity | XBEST_PR | CHAR | 1 | XFELD | JHM_XBP | |||
MENGE1 | IS-M/AM: Agreed Quantity to be Sold | ABS_MENGE1 | QUAN | 12(3) | ABS_MENGE | ||||
EINH1 | IS-M: Contract Units of Measurement | AB_MEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | MJJ006 | |
AB_ZIEL1 | IS-M/AM: Target Quantity for Monetary Contract | AB_ZIEL1 | CURR | 15(2) | WERTV8 | ||||
AB_WEINH | IS-M: Currency Key for Contract | AB_WEINH | CUKY | 5 | TCURC | WAERS | FWS | ||
MENGE2 | IS-M/AM: Agreed Quantity to be Sold | ABS_MENGE2 | QUAN | 12(3) | ABS_MENGE | ||||
EINH2 | IS-M: Contract Units of Measurement | AB_MEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | MJJ006 | |
PR_BASIS | IS-M: Basis for scale access (number/quantity) | PR_BASIS | CHAR | 1 | PR_BASIS | ||||
AB_PREIS | IS-M: Current Valid Price from Contract | AB_PREIS | CURR | 15(2) | WERTV8 | ||||
AB_KPREIS | IS-M: Price from Scale | AB_KPREIS | CURR | 15(2) | WERTV8 | ||||
AB_VPREIS | IS-M: Agreed Price from Contract | AB_VPREIS | CURR | 15(2) | WERTV8 | ||||
RKNUMV | IS-M: Discount from Scale | AB_RKNUMV | DEC | 5(2) | RABATT | ||||
RABATT | IS-M: Current Valid Contract Discount Rate | AB_RABATT | DEC | 5(2) | RABATT | ||||
VRABATT | IS-M: Agreed Discount | VRABATT | DEC | 5(2) | RABATT | ||||
BKNUMV | IS-M/AM: Bonus from Scale | AB_BKNUMV | DEC | 5(2) | RABATT | ||||
AKTBONUS | IS-M/AM: Current Valid Contract Bonus | AKTBONUS | DEC | 5(2) | RABATT | ||||
VBONUS | IS-M: Agreed Bonus | VBONUS | DEC | 5(2) | RABATT | ||||
FREITEXT | IS-M: Freely Definable Text | ABS_TEXT | CHAR | 50 | FREITEXT | ||||
MNGABRM | IS-M: Quantity for settlement | MNGABRM | QUAN | 12(3) | ABS_MENGE | ||||
MEINHABRM | IS-M: Contract Units of Measurement | AB_MEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | MJJ006 | |
UMSABRM | IS-M: Sales Volume for Contract Settlement | UMSABRM | CURR | 15(2) | WERTV8 | ||||
WEINHABRM | IS-M: Currency Key for Contract | AB_WEINH | CUKY | 5 | TCURC | WAERS | FWS | ||
FAKSP | Block | FAKSP | CHAR | 2 | TVFS | FAKSP | |||
DATEAAFS | IS-M/AM: Billing Block Date for Contract Settlement | DATEAAFS | DATS | 8 | DATUM | ||||
SAERBMO | Total sales vol.all acc.assignments qualifying for discount | SRBMO | CURR | 15(2) | WERTV8 | ||||
SAERBMM | IS-M: Total qty all acc.assignments qualifying for discount | SRBMM | QUAN | 12(3) | SAEMM | ||||
SAERBME | IS-M: Total No.All Acc.Assignments Qualifying for Discount | SRBME | DEC | 5 | SAEME | ||||
SAEBOMO | IS-M: Total sales vol.all accept.assignments qual.for bonus | SBOMO | CURR | 15(2) | WERTV8 | ||||
SAEBOMM | IS-M: Total quantity of all accpt.assignments qual.for bonus | SBOMM | QUAN | 12(3) | SAEMM | ||||
SAEBOME | IS-M: Total Number All Acc.Assignments Qualifying for Bonus | SBOME | DEC | 5 | SAEME | ||||
SAEMRNRMO | Total sales vol.all orig.acc.assignments count.towards disc. | SMRNRMO | CURR | 15(2) | WERTV8 | ||||
SAEMRNRMM | Total qty all acc.original assignments count.towards disc. | SMRNRMM | QUAN | 12(3) | SAEMM | ||||
SAEMRNRME | Total No.of All Acc.Original Assignments Count.Towards Disc. | SMRNRME | DEC | 5 | SAEME | ||||
SAEMBNBMO | Total sales vol.of all acc.orig.assignments count.twrd bonus | SMBNBMO | CURR | 15(2) | WERTV8 | ||||
SAEMBNBMM | Total qty of all original acc.assignments counting twrd bon. | SMBNBMM | QUAN | 12(3) | SAEMM | ||||
SAEMBNBME | Total No.of All Acc.Original Assignments Count.Twrds Bonus | SMBNBME | DEC | 5 | SAEME | ||||
SAERFRRMO | Total sales vol.all acc.assignments qual.for dis.frm othr BU | SRFRRMO | CURR | 15(2) | WERTV8 | ||||
SAERFRRMM | Total qty all acc.assignments qual.for disc.from other BU | SRFRRMM | QUAN | 12(3) | SAEMM | ||||
SAERFRRME | Total No.All Acc.Assignments Qual.for Discount From Other BU | SRFRRME | DEC | 5 | SAEME | ||||
SAEBFRMO | Total sales vol. all acc.assign. qual.for bonus from othr BU | SBFRMO | CURR | 15(2) | WERTV8 | ||||
SAEBFRMM | Total qty of all accp.assignments qual.for bonus frm othr BU | SBFRMM | QUAN | 12(3) | SAEMM | ||||
SAEBFRME | Total Number of Assignments Qualify.for Bonus From Other BU | SBFRME | DEC | 5 | SAEME | ||||
SAEFRMO | Total sales vol.of all accepted assignments from other BU | SFRMO | CURR | 15(2) | WERTV8 | ||||
SAEFRMM | IS-M: Total quantity of all accept.assignments from other BU | SFRMM | QUAN | 12(3) | SAEMM | ||||
SAEFRME | IS-M: Total Number of All Accepted Assignments From Other BU | SFRME | DEC | 5 | SAEME | ||||
SAEMFRBMO | Total sales vol.all acc.assign.count.twrds bonus frm othr BU | SMFRBMO | CURR | 15(2) | WERTV8 | ||||
SAEMFRBMM | Total qty all acc.assignmnts count.twrds bonus from other BU | SMFRBMM | QUAN | 12(3) | SAEMM | ||||
SAEMFRBME | Total No.All Acc.Assignmnts Count.Twrds Bonus From Other BU | SMFRBME | DEC | 5 | SAEME | ||||
SAEVBMO | IS-M: Total sales vol.all acc.assignments from other SA | SVBMO | CURR | 15(2) | WERTV8 | ||||
SAEVBMM | IS-M: Total qty all acc.assignments from other sales area | SVBMM | QUAN | 12(3) | SAEMM | ||||
SAEVBME | IS-M: Total Number of All Accepted Assignments From Other SA | SVBME | DEC | 5 | SAEME | ||||
SAEMAMO | IS-M: Total sales volume of all accepted manual assignments | SMAMO | CURR | 15(2) | WERTV8 | ||||
SAEMAMM | IS-M: Total quantity of all manual assignments accepted | SMAMM | QUAN | 12(3) | SAEMM | ||||
SAEMAME | IS-M: Total Number of All Manual Assignments Accepted | SMAME | DEC | 5 | SAEME | ||||
SAEMRMO | Total sales vol.from all acc.assignments count.toward disc. | SMRMO | CURR | 15(2) | WERTV8 | ||||
SAEMRMM | Total qty of all acc.assignments counting towards discount | SMRMM | QUAN | 12(3) | SAEMM | ||||
SAEMRME | IS-M: Total No.of All Acc.Assignments Counting Towards Disc. | SMRME | DEC | 5 | SAEME | ||||
SAEMBMO | IS-M: Total sales vol.of all acc.assignments count.twd bon. | SMBMO | CURR | 15(2) | WERTV8 | ||||
SAEMBMM | IS-M: Total qty of all accept.assignments counting twrd bon. | SMBMM | QUAN | 12(3) | SAEMM | ||||
SAEMBME | IS-M: Total No.All Accept.Assignments Which Count Twrds Bon. | SMBME | DEC | 5 | SAEME | ||||
SFKRBMO | Total sales vol.all billed assignments qualifying for disc. | SRBMO_FK | CURR | 15(2) | WERTV8 | ||||
SFKRBMM | Total qty all billed assignments qualifying for discount | SRBMM_FK | QUAN | 12(3) | SAEMM | ||||
SFKRBME | IS-M: Total No.All Bill.Assignments Qualifying for Discount | SRBME_FK | DEC | 5 | SAEME | ||||
SFKBOMO | Total sales vol.all billed assignments qualifying for bonus | SBOMO_FK | CURR | 15(2) | WERTV8 | ||||
SFKBOMM | Total qty of all billed assignments qualifying for bonus | SBOMM_FK | QUAN | 12(3) | SAEMM | ||||
SFKBOME | Total Number of All Billed Assignments Qualifying for Bonus | SBOME_FK | DEC | 5 | SAEME | ||||
SFKMRNRMO | Total sales vol.all billed orig.assignments count.twrd disc. | SMRNRMO_FK | CURR | 15(2) | WERTV8 | ||||
SFKMRNRMM | Total qty all billed original assignments count.twrd disc. | SMRNRMM_FK | QUAN | 12(3) | SAEMM | ||||
SFKMRNRME | Total No.of All Billed Original Assignments Count.Twrd Disc. | SMRNRME_FK | DEC | 5 | SAEME | ||||
SFKMBNBMO | Total sales vol.all bill.original assignments count.twd bon. | SMBNBMO_FK | CURR | 15(2) | WERTV8 | ||||
SFKMBNBMM | Total qty of all billed original assignments count.twrd bon. | SMBNBMM_FK | QUAN | 12(3) | SAEMM | ||||
SFKMBNBME | Total No.of All Billed Original Assignments Count.Twrd Bonus | SMBNBME_FK | DEC | 5 | SAEME | ||||
SFKRFRRMO | Total sales vol.all bill.assignm.qual.for disc from other BU | SRFRRMO_FK | CURR | 15(2) | WERTV8 | ||||
SFKRFRRMM | Total qty all billed assignments qual.for disc.from other BU | SRFRRMM_FK | QUAN | 12(3) | SAEMM | ||||
SFKRFRRME | Total No.All Billed Assignments Qual.for Disc.From Other BU | SRFRRME_FK | DEC | 5 | SAEME | ||||
SFKBFRMO | Total sales vol.all bill.assign.qual.for bonus from other BU | SBFRMO_FK | CURR | 15(2) | WERTV8 | ||||
SFKBFRMM | Total qty all billed assignments qual.for bonus frm other BU | SBFRMM_FK | QUAN | 12(3) | SAEMM | ||||
SFKBFRME | Total No.All Billed Assignments Qual.for Bonus From Other BU | SBFRME_FK | DEC | 5 | SAEME | ||||
SFKFRMO | Total sales volume of all billed assignments from other BU | SFRMO_FK | CURR | 15(2) | WERTV8 | ||||
SFKFRMM | Total quantity of all billed assignments from other BU | SFRMM_FK | QUAN | 12(3) | SAEMM | ||||
SFKFRME | Total Number of All Billed Assignments From Other BU | SFRME_FK | DEC | 5 | SAEME | ||||
SFKMFRBMO | Total sales vol.all bill.assign.count.twrd bon.from othr BU | SMFRBMO_FK | CURR | 15(2) | WERTV8 | ||||
SFKMFRBMM | Total qty all billed assignments count.twrd bonus frm oth.BU | SMFRBMM_FK | QUAN | 12(3) | SAEMM | ||||
SFKMFRBME | Total No.of All Bill.Assignments From Othr BU Count.Twrd Bon | SMFRBME_FK | DEC | 5 | SAEME | ||||
SFKVBMO | Total sales vol. from all billed assignments from other SAs | SVBMO_FK | CURR | 15(2) | WERTV8 | ||||
SFKVBMM | Total quantity all billed assignments from other SA | SVBMM_FK | QUAN | 12(3) | SAEMM | ||||
SFKVBME | Total Number of All Billed Assignments From Other SA | SVBME_FK | DEC | 5 | SAEME | ||||
SFKMAMO | Total sales volume of all billed manual assignments | SMAMO_FK | CURR | 15(2) | WERTV8 | ||||
SFKMAMM | IS-M: Total quantity of all billed manual assignments | SMAMM_FK | QUAN | 12(3) | SAEMM | ||||
SFKMAME | IS-M: Total Number of All Billed Manual Assignments | SMAME_FK | DEC | 5 | SAEME | ||||
SFKMRMO | Total sales vol.all billed assignments count.toward discount | SMRMO_FK | CURR | 15(2) | WERTV8 | ||||
SFKMRMM | Total quantity of all billed assignments counting twrd disc. | SMRMM_FK | QUAN | 12(3) | SAEMM | ||||
SFKMRME | Total Number of All Billed Assignments Counting Toward Disc. | SMRME_FK | DEC | 5 | SAEME | ||||
SFKMBMO | Total sales vol.all billed assignments counting twrd bonus | SMBMO_FK | CURR | 15(2) | WERTV8 | ||||
SFKMBMM | Total quantity of all billed assignments counting twrd bon. | SMBMM_FK | QUAN | 12(3) | SAEMM | ||||
SFKMBME | Total Number of All Billed Assignments That Count Twrd Bonus | SMBME_FK | DEC | 5 | SAEME | ||||
ERFUSER | Created By | ERFUSER | CHAR | 12 | USNAM | ||||
ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
ERFTIME | Time Created | ERFTIME | TIMS | 6 | UZEIT | ||||
AENUSER | Last Changed By | AENUSER | CHAR | 12 | USNAM | ||||
AENDATE | Date of Last Change | AENDATE | DATS | 8 | DATUM | ||||
AENTIME | Time of Last Change | AENTIME | TIMS | 6 | UZEIT |
Key field | Non-key field |
How do I retrieve data from SAP table JHTVAABK using ABAP code
The following ABAP code Example will allow you to do a basic selection on JHTVAABK to SELECT all data from the tableDATA: WA_JHTVAABK TYPE JHTVAABK.
SELECT SINGLE *
FROM JHTVAABK
INTO CORRESPONDING FIELDS OF WA_JHTVAABK
WHERE...
How to access SAP table JHTVAABK
Within an ECC or HANA version of SAP you can also view further information about JHTVAABK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects