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 | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
||||||||||||||
|
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 | MANDT |
TCURC
Currency Codes
|
MANDT |
| JHTVAABK | AB_WEINH | JHTVAABK | AB_WEINH |
TCURC
Currency Codes
|
WAERS |
| 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 | 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 | SPART | JHTVAABK | MANDT |
TVTA
Organizational Unit: Sales Area(s)
|
MANDT |
| 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 | VKBUR | JHTVAABK | VKBUR |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
VKBUR |
| 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 | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| JHTVAABK | VKORG | JHTVAABK | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| JHTVAABK | VTNR | JHTVAABK | MANDT |
JHTVKO
IS-M/AM: Contract
|
MANDT |
| JHTVAABK | VTNR | JHTVAABK | VTNR |
JHTVKO
IS-M/AM: Contract
|
VTNR |
| 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 | VTWEG | JHTVAABK | VTWEG |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
VTWEG |
| JHTVAABK | WEINHABRM | JHTVAABK | WEINHABRM |
TCURC
Currency Codes
|
WAERS |
| JHTVAABK | WEINHABRM | JHTVAABK | MANDT |
TCURC
Currency Codes
|
MANDT |