SAP Table JHTVKO
IS-M/AM: Contract
JHTVKO (IS-M/AM: Contract) 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 JHTVKO to other SAP tables.
JHTVKO 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 |
NUMC
|
6 | 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 | |||||||||||||
|
XORG_ERG
IS-M: Contract has Explicitly Assigned Sales Areas
|
XORG_ERG |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABINHNR
IS-M/AM: Number of Contract Holder
|
ABINHNR | JGTGPNR |
CHAR
|
10 | 0 | |||||||||||||
|
IHREZ
Your Reference
|
IHREZ |
CHAR
|
12 | 0 | ||||||||||||||
|
KDMI
IS-M: Contact Person for Contract Holder
|
ISM_CP_CNTRCT_HLDR |
CHAR
|
10 | 0 | ||||||||||||||
|
XQUASI
IS-M: System Contracts Yes/No Indicator
|
XQUASI |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XGE_GESCH
IS-M: Barter Deal Indicator
|
XGE_GESCH |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XKUBO
IS-M: Indicator Customer Bonus Contract
|
XKUBO |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XTO_BEST
IS-M: "Confirnation Required" Indicator
|
XTO_BEST |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XTO_WARN
IS-M: Advance Warning Indicator
|
XTO_WARN |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XWARN_GEN
IS-M: Generate non-fulfillment warning
|
XWARN_GEN |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XTO_HINW
IS-M: Generate end note indicator
|
XTO_HINW |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XHINW_GEN
IS-M: Generate validity period end note indicator
|
XHINW_GEN |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XBESTK
IS-M: Contract Status (Created/Confirmed)
|
XBESTK |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
B_DATUM
IS-M: Confirmation Date
|
B_DATUM |
DATS
|
8 | 0 | ||||||||||||||
|
XNEUSTAT
IS-M: Renewal status (renewed y/n)
|
XNEUSTAT |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
E_DATUM
IS-M: Contract Renewal Date
|
ER_DATUM |
DATS
|
8 | 0 | ||||||||||||||
|
V_NUMMER
IS-M: Current Number of Advance Warning
|
V_NUMMER |
NUMC
|
1 | 0 | ||||||||||||||
|
V_DATUM
IS-M: Advance Warning Date
|
V_DATUM |
DATS
|
8 | 0 | ||||||||||||||
|
XENDK
IS-M: Status of runtime end note
|
XENDK |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
H_DATUM
IS-M: Date of End of Validity Period Note (Contract)
|
H_DATUM |
DATS
|
8 | 0 | ||||||||||||||
|
XABRSPERR
IS-M: Settlement Block
|
XABRSPERR |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABRECHK
IS-M: Settlement Type
|
ABRECHK |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XABR
IS-M: Perform Settlement Yes/No Indicator
|
XABR |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
R_DATUM
IS-M: Date of Last Interim/Final Settlement
|
R_DATUM |
DATS
|
8 | 0 | ||||||||||||||
|
ABRGNR
IS-M/AM: Contract Settlement Number
|
ABRGNR |
NUMC
|
4 | 0 | ||||||||||||||
|
EABR_NACHL
IS-M: Time of Final Settlement After Runtime (in Months)
|
EABR_NACHL |
NUMC
|
2 | 0 | ||||||||||||||
|
XLOEVM
Deletion Flag for Master Data in Media Sales & Distribution
|
LOEVM_ISP |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XLOEKZ
Deletion Indicator for Master Data in Media Sales & Dist.
|
LOEKZ_ISP |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XLFZAEN
IS-M: Validity Period in Contract Changed
|
XLFZAEN |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LFZBEG
IS-M: Start of Validity Period
|
LFZBEG |
DATS
|
8 | 0 | ||||||||||||||
|
LFZEND
IS-M: End of Validity Period
|
LFZEND |
DATS
|
8 | 0 | ||||||||||||||
|
B_AUSR
IS-M: Rule for Contract Start
|
ABSCHL_BEG | TJJV14 |
CHAR
|
1 | 0 | |||||||||||||
|
E_AUSR
IS-M: Rule for Contract End
|
ABSCHL_END | TJJV15 |
CHAR
|
1 | 0 | |||||||||||||
|
XABE
IS-M: Automatic Contract Renewal?
|
XABSCH_ERN |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
FVTNR
IS-M: Number of Follow-On Contract
|
ABS_FVTNR | JHTVKO |
NUMC
|
6 | 0 | |||||||||||||
|
VVTNR
IS-M: Predecessor to Current Contract
|
ABS_VVTNR | JHTVKO |
NUMC
|
6 | 0 | |||||||||||||
|
XNOBEL
IS-M: Do Not Perform Subsequent Debit
|
XNOBEL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XZWABR
IS-M: Perform Interim Settlement Automatically
|
XZWABR |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XBEARB
IS-M: Postprocess/Approve Contract
|
XGENEHM |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABS_NACHB
IS-M: Post-Editing Reason
|
ABS_NACHB |
CHAR
|
73 | 0 | ||||||||||||||
|
XKONZERN
IS-M: Group Contract
|
XKONZERN |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XINSKUM
IS-M: Cumulation Rule for Contract Assignments
|
XINSKUM |
CHAR
|
1 | 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 | ||||||||||||||
|
||||||||||||||||||
|
XPOSAEN
IS-M: "Contract Item Changed" Indicator
|
XPOSAEN |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XZIELAEN
IS-M: "Target Quantities in COA Changed" Indicator
|
XZIELAEN |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PR_BASIS
IS-M: Basis for scale access (number/quantity)
|
PR_BASIS |
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 | |||||||||||||
|
RKSCHL
Condition Type
|
KSCHL |
CHAR
|
4 | 0 | ||||||||||||||
|
BKSCHL
Condition Type
|
KSCHL |
CHAR
|
4 | 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 | ||||||||||||||
|
MEINH
IS-M: Contract Units of Measurement
|
AB_MEINH | T006 |
UNIT
|
3 | 0 | |||||||||||||
|
ORIG_MENG1
IS-M/AM: Agreed Quantity to be Sold
|
ABS_MENGE1 |
QUAN
|
12 | 3 | ||||||||||||||
|
ORIG_MENG2
IS-M/AM: Agreed Quantity to be Sold
|
ABS_MENGE2 |
QUAN
|
12 | 3 | ||||||||||||||
|
ORIG_ZIEL1
IS-M/AM: Target Quantity for Monetary Contract
|
AB_ZIEL1 |
CURR
|
15 | 2 | ||||||||||||||
|
XAB_PREIS
IS-M/AM: Basic Price from Contract Indicator
|
XAB_PREIS |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XAB_PRLST
IS-M: Do not Overfulfill Contract Indicator
|
XAB_PRLST |
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 | ||||||||||||||
|
FMP_KPEIN
Condition pricing unit
|
KPEIN |
DEC
|
5 | 0 | ||||||||||||||
|
FMP_KMEIN
Condition unit
|
KMEIN | T006 |
UNIT
|
3 | 0 | |||||||||||||
|
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 | ||||||||||||||
|
XRABAEN
IS-M/AM: Discount Changed Manually
|
XRABAEN |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XRAB_CH
IS-M: Current discount change
|
XRAB_CH |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XRABA
IS-M/AM: Indicator: Adjust Discount During Contract Period?
|
XRABATTANP |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XERFUELLT
IS-M/AM: Contract Fulfilled Yes/No Indicator
|
XERFUELLT |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XRABAN
IS-M: Next discount level characteristic reached
|
XRABAN |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XRABAZW
IS-M/AM: Discount change with next interim settlement
|
XRABAZW |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XRABSPERR
IS-M: Block higher-level discounts indicator
|
XRABSPERR |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XBRUTTO
IS-M: Gross Contract Characteristic
|
XBRUTTO |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
BKNUMV
IS-M/AM: Bonus from Scale
|
AB_BKNUMV |
DEC
|
5 | 2 | ||||||||||||||
|
XVBONUS
IS-M: Advance Bonus Indicator
|
XVBONUS |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
AKTBONUS
IS-M/AM: Current Valid Contract Bonus
|
AKTBONUS |
DEC
|
5 | 2 | ||||||||||||||
|
VBONUS
IS-M: Agreed Bonus
|
VBONUS |
DEC
|
5 | 2 | ||||||||||||||
|
XGUTSCHR
IS-M: Do not perform credit memo characteristic
|
XGUTSCHR |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ZTERM
Terms of Payment Key
|
DZTERM |
CHAR
|
4 | 0 | ||||||||||||||
|
FREITEXT
IS-M: Freely Definable Text
|
ABS_TEXT |
CHAR
|
50 | 0 | ||||||||||||||
|
L_FKT_DAT
IS-M: Last Actual Billing Date
|
L_FKT_DAT |
DATS
|
8 | 0 | ||||||||||||||
|
L_AE_DAT
IS-M: Last Publication Date
|
L_AE_DAT |
DATS
|
8 | 0 | ||||||||||||||
|
ABS_ZUST
IS-M: Person Responsible
|
ABS_ZUST | USR02 |
CHAR
|
12 | 0 | |||||||||||||
|
FRD_VTNR
IS-M: Externally Assigned Contract Number
|
FRD_VTNR |
CHAR
|
15 | 0 | ||||||||||||||
|
MM_VTNR
IS-M: Contract Number for Media-Mix Contract
|
MM_VTNR | JHTMXK |
CHAR
|
10 | 0 | |||||||||||||
|
KOFRS
IS-M: Scale Base Formula Provided From the Contract
|
ISM_CONKOFRS | TFRM |
NUMC
|
3 | 0 | |||||||||||||
|
LEVEL_BP
IS-M/AM: Contract BW Classification for Contract Holder
|
JH_BWCOALEVEL_BP |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LEVEL_BU
IS-M/AM: Contract BW Classification for Booking Unit
|
JH_BWCOALEVEL_BU |
CHAR
|
1 | 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 | ||||||||||||||
JHTVKO foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| JHTVKO | ABINHNR | JHTVKO | MANDT |
JGTGPNR
IS-M: Central Business Partner Table
|
MANDT |
| JHTVKO | ABINHNR | JHTVKO | ABINHNR |
JGTGPNR
IS-M: Central Business Partner Table
|
GPNR |
| JHTVKO | ABS_TYP1 | JHTVKO | MANDT |
TJH11
IS-M/AM: Data Table for Contract Category
|
MANDT |
| JHTVKO | ABS_TYP1 | JHTVKO | ABS_TYP1 |
TJH11
IS-M/AM: Data Table for Contract Category
|
ABS_TYP |
| JHTVKO | ABS_ZUST | JHTVKO | MANDT |
USR02
Logon Data (Kernel-Side Use)
|
MANDT |
| JHTVKO | ABS_ZUST | JHTVKO | ABS_ZUST |
USR02
Logon Data (Kernel-Side Use)
|
BNAME |
| JHTVKO | AB_WEINH | JHTVKO | MANDT |
TCURC
Currency Codes
|
MANDT |
| JHTVKO | AB_WEINH | JHTVKO | AB_WEINH |
TCURC
Currency Codes
|
WAERS |
| JHTVKO | B_AUSR | JHTVKO | B_AUSR |
TJJV14
IS-M: Rules for Start of Contract Validity Period
|
B_AUSR |
| JHTVKO | E_AUSR | JHTVKO | E_AUSR |
TJJV15
IS-M: Rules for End of Contract Validity Period
|
E_AUSR |
| JHTVKO | FMP_KMEIN | JHTVKO | MANDT |
T006
Units of Measurement
|
MANDT |
| JHTVKO | FMP_KMEIN | JHTVKO | FMP_KMEIN |
T006
Units of Measurement
|
MSEHI |
| JHTVKO | FVTNR | JHTVKO | MANDT |
JHTVKO
IS-M/AM: Contract
|
MANDT |
| JHTVKO | FVTNR | JHTVKO | FVTNR |
JHTVKO
IS-M/AM: Contract
|
VTNR |
| JHTVKO | KOFRS | JHTVKO | KOFRS |
TFRM
Form Routines for Requirements/Formulas/Data Transports
|
GRPNO |
| JHTVKO | KOFRS | 'PFRS' |
TFRM
Form Routines for Requirements/Formulas/Data Transports
|
GRPZE | |
| JHTVKO | MANDT | JHTVKO | MANDT |
T000
Clients
|
MANDT |
| JHTVKO | MEINH | JHTVKO | MANDT |
T006
Units of Measurement
|
MANDT |
| JHTVKO | MEINH | JHTVKO | MEINH |
T006
Units of Measurement
|
MSEHI |
| JHTVKO | MM_VTNR | JHTVKO | MANDT |
JHTMXK
IS-M: Media-Mix Contract Header Data
|
MANDT |
| JHTVKO | MM_VTNR | JHTVKO | MM_VTNR |
JHTMXK
IS-M: Media-Mix Contract Header Data
|
VTNR |
| JHTVKO | SPART | JHTVKO | MANDT |
TVTA
Organizational Unit: Sales Area(s)
|
MANDT |
| JHTVKO | SPART | JHTVKO | VKORG |
TVTA
Organizational Unit: Sales Area(s)
|
VKORG |
| JHTVKO | SPART | JHTVKO | VTWEG |
TVTA
Organizational Unit: Sales Area(s)
|
VTWEG |
| JHTVKO | SPART | JHTVKO | SPART |
TVTA
Organizational Unit: Sales Area(s)
|
SPART |
| JHTVKO | VKBUR | JHTVKO | SPART |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
SPART |
| JHTVKO | VKBUR | JHTVKO | VKBUR |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
VKBUR |
| JHTVKO | VKBUR | JHTVKO | MANDT |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
MANDT |
| JHTVKO | VKBUR | JHTVKO | VKORG |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
VKORG |
| JHTVKO | VKBUR | JHTVKO | VTWEG |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
VTWEG |
| JHTVKO | VKGRP | JHTVKO | VKBUR |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
VKBUR |
| JHTVKO | VKGRP | JHTVKO | VKGRP |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
VKGRP |
| JHTVKO | VKGRP | JHTVKO | MANDT |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
MANDT |
| JHTVKO | VKORG | JHTVKO | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| JHTVKO | VKORG | JHTVKO | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| JHTVKO | VTWEG | JHTVKO | VKORG |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
VKORG |
| JHTVKO | VTWEG | JHTVKO | VTWEG |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
VTWEG |
| JHTVKO | VTWEG | JHTVKO | MANDT |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
MANDT |
| JHTVKO | VVTNR | JHTVKO | MANDT |
JHTVKO
IS-M/AM: Contract
|
MANDT |
| JHTVKO | VVTNR | JHTVKO | VVTNR |
JHTVKO
IS-M/AM: Contract
|
VTNR |