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
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
X Yes
NULL No
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
X Yes
NULL No
XGE_GESCH IS-M: Barter Deal Indicator XGE_GESCH CHAR 1 0
X Yes
NULL No
XKUBO IS-M: Indicator Customer Bonus Contract XKUBO CHAR 1 0
X Yes
NULL No
XTO_BEST IS-M: "Confirnation Required" Indicator XTO_BEST CHAR 1 0
X Yes
NULL No
XTO_WARN IS-M: Advance Warning Indicator XTO_WARN CHAR 1 0
X Yes
NULL No
XWARN_GEN IS-M: Generate non-fulfillment warning XWARN_GEN CHAR 1 0
X Yes
NULL No
XTO_HINW IS-M: Generate end note indicator XTO_HINW CHAR 1 0
X Yes
NULL No
XHINW_GEN IS-M: Generate validity period end note indicator XHINW_GEN CHAR 1 0
X Yes
NULL No
XBESTK IS-M: Contract Status (Created/Confirmed) XBESTK CHAR 1 0
X Yes
NULL No
B_DATUM IS-M: Confirmation Date B_DATUM DATS 8 0
XNEUSTAT IS-M: Renewal status (renewed y/n) XNEUSTAT CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
ABRECHK IS-M: Settlement Type ABRECHK CHAR 1 0
NULL Settlement not Performed
1 Interim Settlement Performed
2 Final Settlement Performed
3 Blank Settlement
4 Settlement not Possible
XABR IS-M: Perform Settlement Yes/No Indicator XABR CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
XLOEKZ Deletion Indicator for Master Data in Media Sales & Dist. LOEKZ_ISP CHAR 1 0
X Yes
NULL No
XLFZAEN IS-M: Validity Period in Contract Changed XLFZAEN CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
XZWABR IS-M: Perform Interim Settlement Automatically XZWABR CHAR 1 0
X Yes
NULL No
XBEARB IS-M: Postprocess/Approve Contract XGENEHM CHAR 1 0
X Yes
NULL No
ABS_NACHB IS-M: Post-Editing Reason ABS_NACHB CHAR 73 0
XKONZERN IS-M: Group Contract XKONZERN CHAR 1 0
X Yes
NULL No
XINSKUM IS-M: Cumulation Rule for Contract Assignments XINSKUM CHAR 1 0
X Yes
NULL No
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
XPOSAEN IS-M: "Contract Item Changed" Indicator XPOSAEN CHAR 1 0
X Yes
NULL No
XZIELAEN IS-M: "Target Quantities in COA Changed" Indicator XZIELAEN CHAR 1 0
X Yes
NULL No
PR_BASIS IS-M: Basis for scale access (number/quantity) PR_BASIS CHAR 1 0
1 Number
2 Quantity
3 Sales volume
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
X Yes
NULL No
XAB_PRLST IS-M: Do not Overfulfill Contract Indicator XAB_PRLST CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
XRAB_CH IS-M: Current discount change XRAB_CH CHAR 1 0
X Yes
NULL No
XRABA IS-M/AM: Indicator: Adjust Discount During Contract Period? XRABATTANP CHAR 1 0
X Yes
NULL No
XERFUELLT IS-M/AM: Contract Fulfilled Yes/No Indicator XERFUELLT CHAR 1 0
X Yes
NULL No
XRABAN IS-M: Next discount level characteristic reached XRABAN CHAR 1 0
X Yes
NULL No
XRABAZW IS-M/AM: Discount change with next interim settlement XRABAZW CHAR 1 0
X Yes
NULL No
XRABSPERR IS-M: Block higher-level discounts indicator XRABSPERR CHAR 1 0
X Yes
NULL No
XBRUTTO IS-M: Gross Contract Characteristic XBRUTTO CHAR 1 0
X Yes
NULL No
BKNUMV IS-M/AM: Bonus from Scale AB_BKNUMV DEC 5 2
XVBONUS IS-M: Advance Bonus Indicator XVBONUS CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
1 Group-Wide Contracts
2 Non-Group Contracts
3 Contracts for Individual Corporate Groups
4 Sub-Group Contracts
LEVEL_BU IS-M/AM: Contract BW Classification for Booking Unit JH_BWCOALEVEL_BU CHAR 1 0
1 not yet supported
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 FMP_KMEIN T006 Units of Measurement MSEHI
JHTVKO FMP_KMEIN JHTVKO MANDT T006 Units of Measurement MANDT
JHTVKO FVTNR JHTVKO MANDT JHTVKO IS-M/AM: Contract MANDT
JHTVKO FVTNR JHTVKO FVTNR JHTVKO IS-M/AM: Contract VTNR
JHTVKO KOFRS 'PFRS' TFRM Form Routines for Requirements/Formulas/Data Transports GRPZE
JHTVKO KOFRS JHTVKO KOFRS TFRM Form Routines for Requirements/Formulas/Data Transports GRPNO
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 VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
JHTVKO SPART JHTVKO SPART TVTA Organizational Unit: Sales Area(s) SPART
JHTVKO SPART JHTVKO MANDT TVTA Organizational Unit: Sales Area(s) MANDT
JHTVKO SPART JHTVKO VKORG TVTA Organizational Unit: Sales Area(s) VKORG
JHTVKO VKBUR JHTVKO VTWEG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
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 VKGRP JHTVKO MANDT TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
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 VKORG JHTVKO MANDT TVKO Organizational Unit: Sales Organizations MANDT
JHTVKO VKORG JHTVKO VKORG TVKO Organizational Unit: Sales Organizations VKORG
JHTVKO VTWEG JHTVKO MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
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 VVTNR JHTVKO MANDT JHTVKO IS-M/AM: Contract MANDT
JHTVKO VVTNR JHTVKO VVTNR JHTVKO IS-M/AM: Contract VTNR