SAP ABAP Table ISMAM_TXW_JHTVKO (DART IS-M/AM: Contract)
Hierarchy
☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
Table Category INTTAB    Structure 
Structure ISMAM_TXW_JHTVKO   Table Relationship Diagram
Short Description DART IS-M/AM: Contract    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 VTNR ABS_VTNR ABS_VTNR NUMC 6   0   IS-M: Contract Number *
3 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
4 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVKOV
5 SPART SPART SPART CHAR 2   0   Division TVTA
6 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVKBZ
7 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
8 XORG_ERG XORG_ERG XFELD CHAR 1   0   IS-M: Contract has Explicitly Assigned Sales Areas  
9 ABINHNR ABINHNR GPNR CHAR 10   0   IS-M/AM: Number of Contract Holder JGTGPNR
10 IHREZ IHREZ TEXT12 CHAR 12   0   Your Reference  
11 KDMI ISM_CP_CNTRCT_HLDR BU_PARTNER CHAR 10   0   IS-M: Contact Person for Contract Holder *
12 XQUASI XQUASI XFELD CHAR 1   0   IS-M: System Contracts Yes/No Indicator  
13 XGE_GESCH XGE_GESCH XFELD CHAR 1   0   IS-M: Barter Deal Indicator  
14 XKUBO XKUBO XFELD CHAR 1   0   IS-M: Indicator Customer Bonus Contract  
15 XTO_BEST XTO_BEST XFELD CHAR 1   0   IS-M: "Confirnation Required" Indicator  
16 XTO_WARN XTO_WARN XFELD CHAR 1   0   IS-M: Advance Warning Indicator  
17 XWARN_GEN XWARN_GEN XFELD CHAR 1   0   IS-M: Generate non-fulfillment warning  
18 XTO_HINW XTO_HINW XFELD CHAR 1   0   IS-M: Generate end note indicator  
19 XHINW_GEN XHINW_GEN XFELD CHAR 1   0   IS-M: Generate validity period end note indicator  
20 XBESTK XBESTK XFELD CHAR 1   0   IS-M: Contract Status (Created/Confirmed)  
21 B_DATUM B_DATUM DATUM DATS 8   0   IS-M: Confirmation Date  
22 XNEUSTAT XNEUSTAT XFELD CHAR 1   0   IS-M: Renewal status (renewed y/n)  
23 E_DATUM ER_DATUM   DATS 8   0   IS-M: Contract Renewal Date  
24 V_NUMMER V_NUMMER SYNUM01 NUMC 1   0   IS-M: Current Number of Advance Warning  
25 V_DATUM V_DATUM DATUM DATS 8   0   IS-M: Advance Warning Date  
26 XENDK XENDK XFELD CHAR 1   0   IS-M: Status of runtime end note  
27 H_DATUM H_DATUM DATUM DATS 8   0   IS-M: Date of End of Validity Period Note (Contract)  
28 XABRSPERR XABRSPERR XFELD CHAR 1   0   IS-M: Settlement Block  
29 ABRECHK ABRECHK ABRECHK CHAR 1   0   IS-M: Settlement Type *
30 XABR XABR XFELD CHAR 1   0   IS-M: Perform Settlement Yes/No Indicator  
31 R_DATUM R_DATUM DATUM DATS 8   0   IS-M: Date of Last Interim/Final Settlement  
32 ABRGNR ABRGNR ABRGNR NUMC 4   0   IS-M/AM: Contract Settlement Number *
33 EABR_NACHL EABR_NACHL SYNUM02 NUMC 2   0   IS-M: Time of Final Settlement After Runtime (in Months)  
34 XLOEVM LOEVM_ISP XFELD CHAR 1   0   Deletion Flag for Master Data in Media Sales & Distribution  
35 XLOEKZ LOEKZ_ISP XFELD CHAR 1   0   Deletion Indicator for Master Data in Media Sales & Dist.  
36 XLFZAEN XLFZAEN XFELD CHAR 1   0   IS-M: Validity Period in Contract Changed  
37 LFZBEG LFZBEG DATUM DATS 8   0   IS-M: Start of Validity Period  
38 LFZEND LFZEND DATUM DATS 8   0   IS-M: End of Validity Period  
39 B_AUSR ABSCHL_BEG ABSCHL_BEG CHAR 1   0   IS-M: Rule for Contract Start TJJV14
40 E_AUSR ABSCHL_END ABSCHL_END CHAR 1   0   IS-M: Rule for Contract End TJJV15
41 XABE XABSCH_ERN XFELD CHAR 1   0   IS-M: Automatic Contract Renewal?  
42 FVTNR ABS_FVTNR ABS_VTNR NUMC 6   0   IS-M: Number of Follow-On Contract JHTVKO
43 VVTNR ABS_VVTNR ABS_VTNR NUMC 6   0   IS-M: Predecessor to Current Contract JHTVKO
44 XNOBEL XNOBEL XFELD CHAR 1   0   IS-M: Do Not Perform Subsequent Debit  
45 XZWABR XZWABR XFELD CHAR 1   0   IS-M: Perform Interim Settlement Automatically  
46 XBEARB XGENEHM XFELD CHAR 1   0   IS-M: Postprocess/Approve Contract  
47 ABS_NACHB ABS_NACHB NATXT CHAR 73   0   IS-M: Post-Editing Reason  
48 XKONZERN XKONZERN XFELD CHAR 1   0   IS-M: Group Contract  
49 XINSKUM XINSKUM XFELD CHAR 1   0   IS-M: Cumulation Rule for Contract Assignments  
50 ABS_TYP1 ABS_TYP ABS_TYP CHAR 1   0   IS-M/AM: Contract Category TJH11
51 XBEST_PR XBEST_PR XFELD CHAR 1   0   IS-M: Apply Best Conditions to Number / Quantity  
52 XPOSAEN XPOSAEN XFELD CHAR 1   0   IS-M: "Contract Item Changed" Indicator  
53 XZIELAEN XZIELAEN XFELD CHAR 1   0   IS-M: "Target Quantities in COA Changed" Indicator  
54 PR_BASIS PR_BASIS PR_BASIS CHAR 1   0   IS-M: Basis for scale access (number/quantity)  
55 MENGE1 ISMAM_TXW_ABS_MENGE1 CHAR15 CHAR 15   0   IS-M/AM: Agreed Quantity To Be Sold  
56 EINH1 AB_MEINH MEINS UNIT 3   0   IS-M: Contract Units of Measurement *
57 AB_ZIEL1 ISMAM_TXW_AB_ZIEL1 CHAR17 CHAR 17   0   IS-M/AM: Target Quantity for Monetary Contract  
58 AB_WEINH AB_WEINH WAERS CUKY 5   0   IS-M: Currency Key for Contract TCURC
59 RKSCHL KSCHL KSCHL CHAR 4   0   Condition Type *
60 BKSCHL KSCHL KSCHL CHAR 4   0   Condition Type *
61 MENGE2 ISMAM_TXW_ABS_MENGE2 CHAR15 CHAR 15   0   IS-M/AM: Agreed Quantity To Be Sold  
62 EINH2 AB_MEINH MEINS UNIT 3   0   IS-M: Contract Units of Measurement *
63 MEINH AB_MEINH MEINS UNIT 3   0   IS-M: Contract Units of Measurement T006
64 ORIG_MENG1 ISMAM_TXW_ABS_MENGE1 CHAR15 CHAR 15   0   IS-M/AM: Agreed Quantity To Be Sold  
65 ORIG_MENG2 ISMAM_TXW_ABS_MENGE2 CHAR15 CHAR 15   0   IS-M/AM: Agreed Quantity To Be Sold  
66 ORIG_ZIEL1 ISMAM_TXW_AB_ZIEL1 CHAR17 CHAR 17   0   IS-M/AM: Target Quantity for Monetary Contract  
67 XAB_PREIS XAB_PREIS XFELD CHAR 1   0   IS-M/AM: Basic Price from Contract Indicator  
68 XAB_PRLST XAB_PRLST XFELD CHAR 1   0   IS-M: Do not Overfulfill Contract Indicator  
69 AB_PREIS ISMAM_TXW_AB_PREIS CHAR17 CHAR 17   0   IS-M: Current Valid Price from Contract  
70 AB_KPREIS ISMAM_TXW_AB_KPREIS CHAR17 CHAR 17   0   IS-M: Price from Scale  
71 AB_VPREIS ISMAM_TXW_AB_VPREIS CHAR17 CHAR 17   0   IS-M: Agreed Price from Contract  
72 FMP_KPEIN ISMAM_TXW_KPEIN CHAR5 CHAR 5   0   Condition pricing unit  
73 FMP_KMEIN KMEIN MEINS UNIT 3   0   Condition Unit T006
74 RKNUMV ISMAM_TXW_AB_RKNUMV CHAR17 CHAR 17   0   IS-M: Discount from Scale  
75 RABATT ISMAM_TXW_AB_RABATT CHAR15 CHAR 15   0   DART IS-M/AM: Current Valid Contract Discount Rate  
76 VRABATT ISMAM_TXW_VRABATT CHAR5 CHAR 5   0   IS-M: Agreed Discount  
77 XRABAEN XRABAEN XFELD CHAR 1   0   IS-M/AM: Discount Changed Manually  
78 XRAB_CH XRAB_CH XFELD CHAR 1   0   IS-M: Current discount change  
79 XRABA XRABATTANP XFELD CHAR 1   0   IS-M/AM: Indicator: Adjust Discount During Contract Period?  
80 XERFUELLT XERFUELLT XFELD CHAR 1   0   IS-M/AM: Contract Fulfilled Yes/No Indicator  
81 XRABAN XRABAN XFELD CHAR 1   0   IS-M: Next discount level characteristic reached  
82 XRABAZW XRABAZW XFELD CHAR 1   0   IS-M/AM: Discount change with next interim settlement  
83 XRABSPERR XRABSPERR XFELD CHAR 1   0   IS-M: Block higher-level discounts indicator  
84 XBRUTTO XBRUTTO XFELD CHAR 1   0   IS-M: Gross Contract Characteristic  
85 BKNUMV ISMAM_TXW_AB_BKNUMV CHAR5 CHAR 5   0   IS-M/AM: Bonus from Scale  
86 XVBONUS XVBONUS XFELD CHAR 1   0   IS-M: Advance Bonus Indicator  
87 AKTBONUS ISMAM_TXW_AKTBONUS CHAR15 CHAR 15   0   DART IS-M/AM: Current Valid Contract Bonus  
88 VBONUS ISMAM_TXW_VBONUS CHAR7 CHAR 7   0   IS-M: Agreed Bonus  
89 XGUTSCHR XGUTSCHR XFELD CHAR 1   0   IS-M: Do not perform credit memo characteristic  
90 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
91 FREITEXT ABS_TEXT FREITEXT CHAR 50   0   IS-M: Freely Definable Text  
92 L_FKT_DAT L_FKT_DAT DATUM DATS 8   0   IS-M: Last Actual Billing Date  
93 L_AE_DAT L_AE_DAT DATUM DATS 8   0   IS-M: Last Publication Date  
94 ABS_ZUST ABS_ZUST XUBNAME CHAR 12   0   IS-M: Person Responsible USR02
95 FRD_VTNR FRD_VTNR CHAR15 CHAR 15   0   IS-M: Externally Assigned Contract Number  
96 MM_VTNR MM_VTNR MM_VTNR CHAR 10   0   IS-M: Contract Number for Media-Mix Contract JHTMXK
97 KOFRS ISM_CONKOFRS GRPNO NUMC 3   0   IS-M: Scale Base Formula Provided From the Contract TFRM
98 LEVEL_BP JH_BWCOALEVEL_BP JH_BWCOALEVEL_BP CHAR 1   0   IS-M/AM: Contract BW Classification for Contract Holder  
99 LEVEL_BU JH_BWCOALEVEL_BU JH_BWCOALEVEL_BU CHAR 1   0   IS-M/AM: Contract BW Classification for Booking Unit  
100 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
101 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
102 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
103 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
104 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
105 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
106 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ISMAM_TXW_JHTVKO ABINHNR JGTGPNR GPNR REF 1 CN
2 ISMAM_TXW_JHTVKO ABS_TYP1 TJH11 ABS_TYP REF 1 CN
3 ISMAM_TXW_JHTVKO ABS_ZUST USR02 BNAME KEY 1 CN
4 ISMAM_TXW_JHTVKO AB_WEINH TCURC WAERS REF 1 CN
5 ISMAM_TXW_JHTVKO B_AUSR TJJV14 B_AUSR REF 1 CN
6 ISMAM_TXW_JHTVKO E_AUSR TJJV15 E_AUSR REF 1 CN
7 ISMAM_TXW_JHTVKO FMP_KMEIN T006 MSEHI REF C CN
8 ISMAM_TXW_JHTVKO FVTNR JHTVKO VTNR REF C C
9 ISMAM_TXW_JHTVKO KOFRS TFRM GRPNO REF C CN
10 ISMAM_TXW_JHTVKO MANDT T000 MANDT KEY 1 CN
11 ISMAM_TXW_JHTVKO MEINH T006 MSEHI REF 1 CN
12 ISMAM_TXW_JHTVKO MM_VTNR JHTMXK VTNR REF C CN
13 ISMAM_TXW_JHTVKO SPART TVTA SPART REF 1 CN
14 ISMAM_TXW_JHTVKO VKBUR TVKBZ VKBUR REF 1 CN
15 ISMAM_TXW_JHTVKO VKGRP TVBVK VKGRP REF 1 CN
16 ISMAM_TXW_JHTVKO VKORG TVKO VKORG REF 1 CN
17 ISMAM_TXW_JHTVKO VTWEG TVKOV VTWEG REF 1 CN
18 ISMAM_TXW_JHTVKO VVTNR JHTVKO VTNR    
History
Last changed by/on SAP  20110901 
SAP Release Created in 471