SAP Table JHTVAABK

IS-M/AM: Contract Settlement Header Data

JHTVAABK (IS-M/AM: Contract Settlement Header Data) 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 JHTVAABK to other SAP tables.

JHTVAABK 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
ABRGNR IS-M/AM: Contract Settlement Number ABRGNR NUMC 4 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVKOV CHAR 2 0
SPART Division SPART TVTA CHAR 2 0
VKBUR Sales Office VKBUR TVKBZ CHAR 4 0
VKGRP Sales Group VKGRP TVBVK CHAR 3 0
ABRECHK IS-M: Settlement Type ABRECHK TJH15 CHAR 1 0
JHABRDAT IS-M: Contract Settlement Date JHABRDAT DATS 8 0
R_DATUM IS-M: Date of Last Interim/Final Settlement R_DATUM DATS 8 0
ABS_TYP1 IS-M/AM: Contract Category ABS_TYP TJH11 CHAR 1 0
XBEST_PR IS-M: Apply Best Conditions to Number / Quantity XBEST_PR CHAR 1 0
X Yes
NULL No
MENGE1 IS-M/AM: Agreed Quantity to be Sold ABS_MENGE1 QUAN 12 3
EINH1 IS-M: Contract Units of Measurement AB_MEINH UNIT 3 0
AB_ZIEL1 IS-M/AM: Target Quantity for Monetary Contract AB_ZIEL1 CURR 15 2
AB_WEINH IS-M: Currency Key for Contract AB_WEINH TCURC CUKY 5 0
MENGE2 IS-M/AM: Agreed Quantity to be Sold ABS_MENGE2 QUAN 12 3
EINH2 IS-M: Contract Units of Measurement AB_MEINH UNIT 3 0
PR_BASIS IS-M: Basis for scale access (number/quantity) PR_BASIS CHAR 1 0
1 Number
2 Quantity
3 Sales volume
AB_PREIS IS-M: Current Valid Price from Contract AB_PREIS CURR 15 2
AB_KPREIS IS-M: Price from Scale AB_KPREIS CURR 15 2
AB_VPREIS IS-M: Agreed Price from Contract AB_VPREIS CURR 15 2
RKNUMV IS-M: Discount from Scale AB_RKNUMV DEC 5 2
RABATT IS-M: Current Valid Contract Discount Rate AB_RABATT DEC 5 2
VRABATT IS-M: Agreed Discount VRABATT DEC 5 2
BKNUMV IS-M/AM: Bonus from Scale AB_BKNUMV DEC 5 2
AKTBONUS IS-M/AM: Current Valid Contract Bonus AKTBONUS DEC 5 2
VBONUS IS-M: Agreed Bonus VBONUS DEC 5 2
FREITEXT IS-M: Freely Definable Text ABS_TEXT CHAR 50 0
MNGABRM IS-M: Quantity for settlement MNGABRM QUAN 12 3
MEINHABRM IS-M: Contract Units of Measurement AB_MEINH UNIT 3 0
UMSABRM IS-M: Sales Volume for Contract Settlement UMSABRM CURR 15 2
WEINHABRM IS-M: Currency Key for Contract AB_WEINH TCURC CUKY 5 0
FAKSP Block FAKSP TVFS CHAR 2 0
DATEAAFS IS-M/AM: Billing Block Date for Contract Settlement DATEAAFS DATS 8 0
SAERBMO Total sales vol.all acc.assignments qualifying for discount SRBMO CURR 15 2
SAERBMM IS-M: Total qty all acc.assignments qualifying for discount SRBMM QUAN 12 3
SAERBME IS-M: Total No.All Acc.Assignments Qualifying for Discount SRBME DEC 5 0
SAEBOMO IS-M: Total sales vol.all accept.assignments qual.for bonus SBOMO CURR 15 2
SAEBOMM IS-M: Total quantity of all accpt.assignments qual.for bonus SBOMM QUAN 12 3
SAEBOME IS-M: Total Number All Acc.Assignments Qualifying for Bonus SBOME DEC 5 0
SAEMRNRMO Total sales vol.all orig.acc.assignments count.towards disc. SMRNRMO CURR 15 2
SAEMRNRMM Total qty all acc.original assignments count.towards disc. SMRNRMM QUAN 12 3
SAEMRNRME Total No.of All Acc.Original Assignments Count.Towards Disc. SMRNRME DEC 5 0
SAEMBNBMO Total sales vol.of all acc.orig.assignments count.twrd bonus SMBNBMO CURR 15 2
SAEMBNBMM Total qty of all original acc.assignments counting twrd bon. SMBNBMM QUAN 12 3
SAEMBNBME Total No.of All Acc.Original Assignments Count.Twrds Bonus SMBNBME DEC 5 0
SAERFRRMO Total sales vol.all acc.assignments qual.for dis.frm othr BU SRFRRMO CURR 15 2
SAERFRRMM Total qty all acc.assignments qual.for disc.from other BU SRFRRMM QUAN 12 3
SAERFRRME Total No.All Acc.Assignments Qual.for Discount From Other BU SRFRRME DEC 5 0
SAEBFRMO Total sales vol. all acc.assign. qual.for bonus from othr BU SBFRMO CURR 15 2
SAEBFRMM Total qty of all accp.assignments qual.for bonus frm othr BU SBFRMM QUAN 12 3
SAEBFRME Total Number of Assignments Qualify.for Bonus From Other BU SBFRME DEC 5 0
SAEFRMO Total sales vol.of all accepted assignments from other BU SFRMO CURR 15 2
SAEFRMM IS-M: Total quantity of all accept.assignments from other BU SFRMM QUAN 12 3
SAEFRME IS-M: Total Number of All Accepted Assignments From Other BU SFRME DEC 5 0
SAEMFRBMO Total sales vol.all acc.assign.count.twrds bonus frm othr BU SMFRBMO CURR 15 2
SAEMFRBMM Total qty all acc.assignmnts count.twrds bonus from other BU SMFRBMM QUAN 12 3
SAEMFRBME Total No.All Acc.Assignmnts Count.Twrds Bonus From Other BU SMFRBME DEC 5 0
SAEVBMO IS-M: Total sales vol.all acc.assignments from other SA SVBMO CURR 15 2
SAEVBMM IS-M: Total qty all acc.assignments from other sales area SVBMM QUAN 12 3
SAEVBME IS-M: Total Number of All Accepted Assignments From Other SA SVBME DEC 5 0
SAEMAMO IS-M: Total sales volume of all accepted manual assignments SMAMO CURR 15 2
SAEMAMM IS-M: Total quantity of all manual assignments accepted SMAMM QUAN 12 3
SAEMAME IS-M: Total Number of All Manual Assignments Accepted SMAME DEC 5 0
SAEMRMO Total sales vol.from all acc.assignments count.toward disc. SMRMO CURR 15 2
SAEMRMM Total qty of all acc.assignments counting towards discount SMRMM QUAN 12 3
SAEMRME IS-M: Total No.of All Acc.Assignments Counting Towards Disc. SMRME DEC 5 0
SAEMBMO IS-M: Total sales vol.of all acc.assignments count.twd bon. SMBMO CURR 15 2
SAEMBMM IS-M: Total qty of all accept.assignments counting twrd bon. SMBMM QUAN 12 3
SAEMBME IS-M: Total No.All Accept.Assignments Which Count Twrds Bon. SMBME DEC 5 0
SFKRBMO Total sales vol.all billed assignments qualifying for disc. SRBMO_FK CURR 15 2
SFKRBMM Total qty all billed assignments qualifying for discount SRBMM_FK QUAN 12 3
SFKRBME IS-M: Total No.All Bill.Assignments Qualifying for Discount SRBME_FK DEC 5 0
SFKBOMO Total sales vol.all billed assignments qualifying for bonus SBOMO_FK CURR 15 2
SFKBOMM Total qty of all billed assignments qualifying for bonus SBOMM_FK QUAN 12 3
SFKBOME Total Number of All Billed Assignments Qualifying for Bonus SBOME_FK DEC 5 0
SFKMRNRMO Total sales vol.all billed orig.assignments count.twrd disc. SMRNRMO_FK CURR 15 2
SFKMRNRMM Total qty all billed original assignments count.twrd disc. SMRNRMM_FK QUAN 12 3
SFKMRNRME Total No.of All Billed Original Assignments Count.Twrd Disc. SMRNRME_FK DEC 5 0
SFKMBNBMO Total sales vol.all bill.original assignments count.twd bon. SMBNBMO_FK CURR 15 2
SFKMBNBMM Total qty of all billed original assignments count.twrd bon. SMBNBMM_FK QUAN 12 3
SFKMBNBME Total No.of All Billed Original Assignments Count.Twrd Bonus SMBNBME_FK DEC 5 0
SFKRFRRMO Total sales vol.all bill.assignm.qual.for disc from other BU SRFRRMO_FK CURR 15 2
SFKRFRRMM Total qty all billed assignments qual.for disc.from other BU SRFRRMM_FK QUAN 12 3
SFKRFRRME Total No.All Billed Assignments Qual.for Disc.From Other BU SRFRRME_FK DEC 5 0
SFKBFRMO Total sales vol.all bill.assign.qual.for bonus from other BU SBFRMO_FK CURR 15 2
SFKBFRMM Total qty all billed assignments qual.for bonus frm other BU SBFRMM_FK QUAN 12 3
SFKBFRME Total No.All Billed Assignments Qual.for Bonus From Other BU SBFRME_FK DEC 5 0
SFKFRMO Total sales volume of all billed assignments from other BU SFRMO_FK CURR 15 2
SFKFRMM Total quantity of all billed assignments from other BU SFRMM_FK QUAN 12 3
SFKFRME Total Number of All Billed Assignments From Other BU SFRME_FK DEC 5 0
SFKMFRBMO Total sales vol.all bill.assign.count.twrd bon.from othr BU SMFRBMO_FK CURR 15 2
SFKMFRBMM Total qty all billed assignments count.twrd bonus frm oth.BU SMFRBMM_FK QUAN 12 3
SFKMFRBME Total No.of All Bill.Assignments From Othr BU Count.Twrd Bon SMFRBME_FK DEC 5 0
SFKVBMO Total sales vol. from all billed assignments from other SAs SVBMO_FK CURR 15 2
SFKVBMM Total quantity all billed assignments from other SA SVBMM_FK QUAN 12 3
SFKVBME Total Number of All Billed Assignments From Other SA SVBME_FK DEC 5 0
SFKMAMO Total sales volume of all billed manual assignments SMAMO_FK CURR 15 2
SFKMAMM IS-M: Total quantity of all billed manual assignments SMAMM_FK QUAN 12 3
SFKMAME IS-M: Total Number of All Billed Manual Assignments SMAME_FK DEC 5 0
SFKMRMO Total sales vol.all billed assignments count.toward discount SMRMO_FK CURR 15 2
SFKMRMM Total quantity of all billed assignments counting twrd disc. SMRMM_FK QUAN 12 3
SFKMRME Total Number of All Billed Assignments Counting Toward Disc. SMRME_FK DEC 5 0
SFKMBMO Total sales vol.all billed assignments counting twrd bonus SMBMO_FK CURR 15 2
SFKMBMM Total quantity of all billed assignments counting twrd bon. SMBMM_FK QUAN 12 3
SFKMBME Total Number of All Billed Assignments That Count Twrd Bonus SMBME_FK DEC 5 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

JHTVAABK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JHTVAABK ABRECHK JHTVAABK MANDT TJH15 IS-M/AM: Data Table for Contract Settlement Indicator MANDT
JHTVAABK ABRECHK JHTVAABK ABRECHK TJH15 IS-M/AM: Data Table for Contract Settlement Indicator ABRECHK
JHTVAABK ABS_TYP1 JHTVAABK MANDT TJH11 IS-M/AM: Data Table for Contract Category MANDT
JHTVAABK ABS_TYP1 JHTVAABK ABS_TYP1 TJH11 IS-M/AM: Data Table for Contract Category ABS_TYP
JHTVAABK AB_WEINH JHTVAABK AB_WEINH TCURC Currency Codes WAERS
JHTVAABK AB_WEINH JHTVAABK MANDT TCURC Currency Codes MANDT
JHTVAABK FAKSP JHTVAABK MANDT TVFS Billing: Reasons for Blocking MANDT
JHTVAABK FAKSP JHTVAABK FAKSP TVFS Billing: Reasons for Blocking FAKSP
JHTVAABK MANDT JHTVAABK MANDT T000 Clients MANDT
JHTVAABK SPART JHTVAABK MANDT TVTA Organizational Unit: Sales Area(s) MANDT
JHTVAABK SPART JHTVAABK VKORG TVTA Organizational Unit: Sales Area(s) VKORG
JHTVAABK SPART JHTVAABK VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
JHTVAABK SPART JHTVAABK SPART TVTA Organizational Unit: Sales Area(s) SPART
JHTVAABK VKBUR JHTVAABK VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKBUR
JHTVAABK VKBUR JHTVAABK MANDT TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit MANDT
JHTVAABK VKBUR JHTVAABK VKORG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKORG
JHTVAABK VKBUR JHTVAABK VTWEG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
JHTVAABK VKBUR JHTVAABK SPART TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit SPART
JHTVAABK VKGRP JHTVAABK MANDT TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
JHTVAABK VKGRP JHTVAABK VKBUR TVBVK Organizational Unit: Sales Groups per Sales Office VKBUR
JHTVAABK VKGRP JHTVAABK VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office VKGRP
JHTVAABK VKORG JHTVAABK MANDT TVKO Organizational Unit: Sales Organizations MANDT
JHTVAABK VKORG JHTVAABK VKORG TVKO Organizational Unit: Sales Organizations VKORG
JHTVAABK VTNR JHTVAABK MANDT JHTVKO IS-M/AM: Contract MANDT
JHTVAABK VTNR JHTVAABK VTNR JHTVKO IS-M/AM: Contract VTNR
JHTVAABK VTWEG JHTVAABK VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
JHTVAABK VTWEG JHTVAABK MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
JHTVAABK VTWEG JHTVAABK VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
JHTVAABK WEINHABRM JHTVAABK MANDT TCURC Currency Codes MANDT
JHTVAABK WEINHABRM JHTVAABK WEINHABRM TCURC Currency Codes WAERS