SAP ABAP Table ISMAM_TXW_JHTFP (DART IS-M/AM: Billing/Settlement Documents - Item)
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_JHTFP   Table Relationship Diagram
Short Description DART IS-M/AM: Billing/Settlement Documents - Item    
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 VBELN JJBELNR JJBELNR CHAR 10   0   IS-M/AM: Billing Document JHTFK
3 POSNR JJPOSNR JJPOSNR NUMC 6   0   IS-M/AM: Item (number) in settlement document *
4 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
5 SPART SPART SPART CHAR 2   0   Division TSPA
6 KDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
7 KONDA KONDA KONDA CHAR 2   0   Price Group (Customer) T188
8 KAPPL KAPPL KAPPL CHAR 2   0   Application T681A
9 KALSM KALSMASD KALSM CHAR 6   0   Sales and Distribution: Pricing Procedure in Pricing T683
10 ARKTX ISM_ARKTX TEXT40 CHAR 40   0   IS-M: Short Text for Document Item (Billing Doc.,Settlement)  
11 AUBEL AVM_NR AVM_NR CHAR 10   0   IS-M/AM: Sales Document Number JHAK
12 AUPOS POS_NR AVM_PNR NUMC 3   0   IS-M: Order Item Number JHAP
13 AUGRP GRUPPABRNR GRUPPABR NUMC 3   0   IS-M/AM: Billing Dataset JHAGA
14 AUETE EIN_NR AVMENR NUMC 6   0   IS-M: Schedule Line JHAE
15 AVMAUART AUART_PAM AUART_PAM CHAR 4   0   IS-M: Sales Document Type TJHAK
16 AUREF AUREF XFELD CHAR 1   0   Sales document was created from reference  
17 BEINH BELEGEINH BELEINH CHAR 10   0   IS-M/AM: Booking Unit JJTBE
18 BEINH_BAS BE_BASIS BELEINH CHAR 10   0   IS-M: Basic Booking Unit JJTBE
19 DRERZ JHDRERZ DRERZ CHAR 8   0   IS-M: Publication JDTDRER
20 PVA PVA PVA CHAR 8   0   Edition JDTPVA
21 IHKOMP IKO_PREIS INHALTSKOM CHAR 8   0   IS-M: Content component for pricing call JJTIKO
22 INHK_KFM INHK_KFM INHALTSKOM CHAR 8   0   IS-M: Business Content Component JJTIKO
23 INHK_TECH2 INHK_SOVER INHALTSKOM CHAR 8   0   IS-M: Special Publication Content Component JJTIKO
24 AZAFOV AZART_AREA AZART_AREA CHAR 4   0   IS-M/AM: Fixed Format Proposal /Ad Dimensions TJJ13
25 AZAFO AZART_FORM AZART_FORM CHAR 4   0   IS-M: Shape Ad Type TJJ17
26 AZAFA AZART_FARB AZART_FARB CHAR 4   0   IS-M: Color Scheme Ad Type TJJ11
27 AZAGST AZART_GEST AZART_GEST CHAR 4   0   IS-M: Design Ad Type TJJ19
28 TERMINSPEZ TERMINSPEZ TERMINSPEZ CHAR 6   0   IS-M/AM: Specify Dates for Date Combinations *
29 VAVTYP VAVARTYP VAVARTYP CHAR 2   0   Issue Variant Type TJD05
30 CHIFFRE CHIFFRE_KZ CHIFFRE_KZ CHAR 1   0   IS-M: Box Number Indicator TJH59
31 ABSRB ISMAM_TXW_AB_RABATT CHAR15 CHAR 15   0   DART IS-M/AM: Current Valid Contract Discount Rate  
32 ABSBO ISMAM_TXW_AKTBONUS CHAR15 CHAR 15   0   DART IS-M/AM: Current Valid Contract Bonus  
33 ABSFMPR ISMAM_TXW_AB_PREIS CHAR17 CHAR 17   0   IS-M: Current Valid Price from Contract  
34 GO_PREIS GO_PREIS GO_PREIS CHAR 1   0   IS-M: Basic/Local Price  
35 INSERENT INSERENT GPNR CHAR 10   0   IS-M: Advertiser JJVDB_MK_FK
36 STICHW STICHW TEXT40 CHAR 40   0   IS-M: Keyword  
37 DIENSTL MATNR_DIEN MATNR_DIEN CHAR 18   0   IS-M: Service material number JJTDIEN
38 DITYP DIENTYP DIENTYP CHAR 4   0   IS-M: Service Type TJH71
39 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
40 EAN11 EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
41 FBUDA FBUDA DATUM DATS 8   0   Date When Services Rendered  
42 FSART ISP_FSART ISP_FSART CHAR 1   0   IS-M/AM: Billing Method  
43 KTGRM KTGRM KTGRM CHAR 2   0   Account assignment group for this material TVKM
44 KTGRB KTGRB KTGRB CHAR 2   0   IS-M: Booking Unit Account Assignment Group TJJ39
45 PRSFD PRSFD PRSFD CHAR 1   0   Carry out pricing  
46 KURSK ISMAM_TXW_KURSK CHAR15 CHAR 15   0   Exchange Rate for Pricing  
47 PRSDT PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
48 SHKZG JHSHKZG JHSHKZG CHAR 1   0   IS-M: Debit/Credit indicator  
49 SMENG ISMAM_TXW_SMENG CHAR15 CHAR 15   0   Scale Quantity in Base Unit of Measure  
50 FKIMG ISMAM_TXW_FKIMG CHAR15 CHAR 15   0   Actual Billed Quantity  
51 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
52 BRGEW ISMAM_TXW_BRGEW CHAR15 CHAR 15   0   DART: Gross Weight  
53 NTGEW ISMAM_TXW_NTGEW CHAR15 CHAR 15   0   Net Weight  
54 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit T006
55 VGBEL JHVGBEL JHVGBEL CHAR 10   0   IS-M: Document Number of Template Document  
56 VGPOS JHVGPOS JHVGPOS NUMC 6   0   IS-M: Item Number of the Template Business Item  
57 VGETE GRABR_VG GRUPPABR NUMC 3   0   IS-M: Group/Settlement Number of Template Document *
58 VGTYP ISPVBTYP_V ISPVBTYP CHAR 1   0   IS-M: Preceding Sales Document Category  
59 VGOBJ JHOBJAR_V JHOBJKT CHAR 2   0   IS-M: Preceding object type TJH97
60 VGFKTYP JHVGFKTYP JHFKTYP CHAR 1   0   IS-M: Billing Category for Preceding Billing Document TJH19
61 VBELV ISMVBELV ISMVBELV CHAR 10   0   IS-M: Originating sales document  
62 POSNV ISMPOSNV ISMPOSNR NUMC 6   0   IS-M: Originating item  
63 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVBUR
64 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVKGR
65 VRKME VRKME MEINS UNIT 3   0   Sales unit T006
66 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
67 POSAR AVMPOS_ART AVMPOS_ART CHAR 2   0   IS-M: Order-Publishing-Media - Item Type TJH17
68 PRODH J_PRODH J_PRODH CHAR 18   0   IS-M/AM: Product Hierarchy JJT179
69 PSTYV PSTYV_PAM PSTYV_PAM CHAR 4   0   IS-M: Item Category for Sales Document TJHAP
70 TAXM1 TAXM1 TAXKM CHAR 1   0   Tax classification material *
71 TAXM2 TAXM2 TAXKM CHAR 1   0   Tax classification material *
72 TAXM3 TAXM3 TAXKM CHAR 1   0   Tax classification material *
73 TAXM4 TAXM4 TAXKM CHAR 1   0   Tax Classification 4 Material *
74 TAXM5 TAXM5 TAXKM CHAR 1   0   Tax classification 5 for material *
75 TAXM6 TAXM6 TAXKM CHAR 1   0   Tax classification 6 for material *
76 TAXM7 TAXM7 TAXKM CHAR 1   0   Tax classification 7 for material *
77 TAXM8 TAXM8 TAXKM CHAR 1   0   Tax Classification 8 Material *
78 TAXM9 TAXM9 TAXKM CHAR 1   0   Tax Classification 9 Material *
79 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
80 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
81 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
82 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
83 RK_AUFNR J_RK_AUFNR J_RK_AUFNR CHAR 8   0   Order Number of RK Order for Account Assignment  
84 RK_POSNR J_RK_POSNR J_RK_POSNR NUMC 2   0   Item Number of RK Order for Account Assignment  
85 KOSTL_R2 KOSTL_R2 KOSTL_R2 CHAR 8   0   Cost center in R/2  
86 STGRB BEGRP_STAT BEGRP_STAT CHAR 4   0   IS-M: BU Grouping for Statistics TJJ67
87 STAFO JHSTAFO STAFO CHAR 6   0   IS-M: Update group for statistics update TMCB
88 SKTOF SKTOF XFELD CHAR 1   0   Cash discount indicator  
89 RRREL ISMRR_RELTYP ISMRR_RELTYP CHAR 1   0   IS-M/AM: Revenue Recognition Category  
90 RRSTA     CHAR 1   0    
91 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
92 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
93 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
94 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
95 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
96 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
97 KUNAG GPAG GPNR CHAR 10   0   Business Partner: Sold-to Party JGTGPNR
98 ELAND LLAND LAND1 CHAR 3   0   Destination Country T005
99 POSPA POSPA POSNR NUMC 6   0   Item number in the partner segment *
100 PLTYP_AUFT PLTYP_AUFT PLTYP CHAR 2   0   Price list type of sales order *
101 MPROK MPROK MPROK CHAR 1   0   Status manual price change  
102 KOWRR KOWRR KOWRR CHAR 1   0   Statistical values  
103 BONBA ISMAM_TXW_BONBA CHAR18 CHAR 18   0   DART: Bonus Basis 1  
104 KZWI1 ISMAM_TXW_KZWI1 CHAR18 CHAR 18   0   Condition Subtotal 1 from Pricing Procedure  
105 KZWI2 ISMAM_TXW_KZWI2 CHAR18 CHAR 18   0   Condition Subtotal 2 from Pricing Procedure  
106 KZWI3 ISMAM_TXW_KZWI3 CHAR18 CHAR 18   0   Condition Subtotal 3 from Pricing Procedure  
107 KZWI4 ISMAM_TXW_KZWI4 CHAR18 CHAR 18   0   Condition Subtotal 4 from Pricing Procedure  
108 KZWI5 ISMAM_TXW_KZWI5 CHAR18 CHAR 18   0   Condition Subtotal 5 from Pricing Procedure  
109 KZWI6 ISMAM_TXW_KZWI6 CHAR18 CHAR 18   0   Condition Subtotal 6 from Pricing Procedure  
110 WAVWR ISMAM_TXW_WAVWR CHAR18 CHAR 18   0   Cost in Document Currency  
111 SKFBP ISMAM_TXW_SKFBP CHAR18 CHAR 18   0   Amount Eligible for Cash Discount in Document Currency  
112 BRTWP ISMAM_TXW_JHBRTWRP CHAR18 CHAR 18   0   IS-M: Gross Value in Document Currency (Item)  
113 NETWP ISMAM_TXW_NETWR_FP CHAR18 CHAR 18   0   Net Value of the Billing Item in Document Currency  
114 MWSBP ISMAM_TXW_MWSBP CHAR18 CHAR 18   0   Tax Amount in Document Currency  
115 UVPRS ISM_UVPRS XFELD CHAR 1   0   Incomplete with Regard to Pricing  
116 UVALL JHUVALL XFELD CHAR 1   0   IS-M: Generally incomplete  
117 XERLV JHXERLV JHXERLV CHAR 1   0   IS-M: Revenue Distribution Status  
118 XPEAB JHXPEAB XFELD CHAR 1   0   IS-M: Period end accrual performed indicator  
119 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
120 UMVKZ ISMAM_TXW_UMVKZ CHAR15 CHAR 15   0   Numerator (Factor) for Conversion of Sales Quantity into SKU  
121 UMVKN ISMAM_TXW_UMVKN CHAR15 CHAR 15   0   Denominator (Divisor) for Conversion of Sales Qty. into SKU  
122 STCUR ISMAM_TXW_STCUR_AP CHAR15 CHAR 15   0   Exchange Rate for Statistics (Exch.Rate at Time of Creation)  
123 PAOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
124 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
125 ZUONR JHZUONR ZUONR CHAR 18   0   IS-M: Assignment number in FI document  
126 KOUPD KOUPD XFELD CHAR 1   0   Condition update  
127 XCNCL JH_XCNCL XFELD CHAR 1   0   IS-M/AM: Reversal Indicator for Billing Item  
128 BEDNR VM_BEDNR VM_BEDNR NUMC 6   0   IS-M: Number of Media Sales Agent Contract Requirement JJTVB
129 PROVTYP PROVTYP PROVTYP CHAR 1   0   IS-M/AM: Commission Category  
130 VZUONR JH_VZUONR JH_VZUONR NUMC 2   0   IS-M/AM: Sales Agent Assignment Number (Corrections) *
131 BERART JBERART BERART CHAR 1   0   IS-M/AM: Calculation Type for Media Sales Agent Commission  
132 PBSCHL JPROVSCHL PRSCHL CHAR 5   0   IS-M/AM: Commission Key for Media Sales Agent TJH23
133 SCBAS JHSCBAS JHSCBAS CHAR 1   0   IS-M/AM: Scale Base Value for Commission Key  
134 VERMART JVERMART JVERMART CHAR 2   0   IS-M: Media Sales Agent Type: General/City/Special Agent TJJ09
135 PR_BETRAG ISMAM_TXW_VPROZP CHAR15 CHAR 15   0   IS-M: Sales Agent Share of Commission (in %)  
136 PBBASIS ISMAM_TXW_JPBBASIS CHAR18 CHAR 18   0   IS-M/AM: Commission/Bonus Basis Amount (Percentage Calc.)  
137 ISPBEDART VMBEDART JVMBEDART CHAR 2   0   IS-M/AM: Requirement Type in Media Sales Agent Contract *
138 ALAND ALAND LAND1 CHAR 3   0   Departure country (country from which the goods are sent) T005
139 XSTEIG XJSTEIG XFELD CHAR 1   0   IS-M: Can be Incremented Indicator  
140 VKORG_AUFT JHVKORGAUF VKORG CHAR 4   0   IS-M: Sales Organization for Customer Order TVKO
141 EPROZ ISMAM_TXW_ISPPROZERL CHAR15 CHAR 15   0   IS-M: Percentage Rate from Rev.Distributed Billing Item  
142 NETWPV ISMAM_TXW_NETWR_FP CHAR18 CHAR 18   0   Net Value of the Billing Item in Document Currency  
143 KTGRP JPVAKNTGRP KTGRM CHAR 2   0   Account assignment grouping for edition TVKM
144 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ISMAM_TXW_JHTFP ALAND T005 LAND1    
2 ISMAM_TXW_JHTFP AUBEL JHAK AVM_NR REF 1 CN
3 ISMAM_TXW_JHTFP AUETE JHAE EIN_NR 1 CN
4 ISMAM_TXW_JHTFP AUFNR AUFK AUFNR KEY 1 CN
5 ISMAM_TXW_JHTFP AUGRP JHAGA GRUPPABRNR REF 1 CN
6 ISMAM_TXW_JHTFP AUPOS JHAP POS_NR REF 1 CN
7 ISMAM_TXW_JHTFP AVMAUART TJHAK AUART REF 1 CN
8 ISMAM_TXW_JHTFP AZAFA TJJ11 AZART_FARB REF 1 CN
9 ISMAM_TXW_JHTFP AZAFO TJJ17 AZART_FORM REF 1 CN
10 ISMAM_TXW_JHTFP AZAFOV TJJ13 AZART_AREA REF 1 CN
11 ISMAM_TXW_JHTFP AZAGST TJJ19 AZART_GEST REF 1 CN
12 ISMAM_TXW_JHTFP BEDNR JJTVB BEDNR REF 1 CN
13 ISMAM_TXW_JHTFP BEINH JJTBE BELEINH REF 1 CN
14 ISMAM_TXW_JHTFP BEINH_BAS JJTBE BELEINH REF 1 CN
15 ISMAM_TXW_JHTFP CHIFFRE TJH59 CHIFFRE_KZ REF 1 CN
16 ISMAM_TXW_JHTFP DIENSTL JJTDIEN MATNR REF 1 CN
17 ISMAM_TXW_JHTFP DITYP TJH71 DIENTYP REF 1 CN
18 ISMAM_TXW_JHTFP DRERZ JDTDRER DRERZ REF 1 CN
19 ISMAM_TXW_JHTFP ELAND T005 LAND1    
20 ISMAM_TXW_JHTFP GEWEI T006 MSEHI REF 1 CN
21 ISMAM_TXW_JHTFP GSBER TGSB GSBER REF 1 CN
22 ISMAM_TXW_JHTFP IHKOMP JJTIKO INHALTSKOM REF 1 CN
23 ISMAM_TXW_JHTFP INHK_KFM JJTIKO INHALTSKOM REF 1 CN
24 ISMAM_TXW_JHTFP INHK_TECH2 JJTIKO INHALTSKOM REF 1 CN
25 ISMAM_TXW_JHTFP INSERENT JJVDB_MK_FK GPNR REF 1 CN
26 ISMAM_TXW_JHTFP KALSM T683 KALSM REF 1 CN
27 ISMAM_TXW_JHTFP KAPPL T681A KAPPL REF 1 CN
28 ISMAM_TXW_JHTFP KDGRP T151 KDGRP REF 1 CN
29 ISMAM_TXW_JHTFP KOKRS TKA01 KOKRS REF 1 CN
30 ISMAM_TXW_JHTFP KONDA T188 KONDA REF 1 CN
31 ISMAM_TXW_JHTFP KOSTL CSKS KOSTL REF 1 CN
32 ISMAM_TXW_JHTFP KTGRB TJJ39 KTGRB REF 1 CN
33 ISMAM_TXW_JHTFP KTGRM TVKM KTGRM REF 1 CN
34 ISMAM_TXW_JHTFP KTGRP TVKM KTGRM REF 1 CN
35 ISMAM_TXW_JHTFP KUNAG JGTGPNR GPNR    
36 ISMAM_TXW_JHTFP MANDT T000 MANDT KEY 1 CN
37 ISMAM_TXW_JHTFP MATNR MARA MATNR REF 1 CN
38 ISMAM_TXW_JHTFP MEINS T006 MSEHI REF 1 CN
39 ISMAM_TXW_JHTFP PBSCHL TJH23 PRSCHL REF C CN
40 ISMAM_TXW_JHTFP POSAR TJH17 AVMPOS_ART REF 1 CN
41 ISMAM_TXW_JHTFP PRCTR CEPC PRCTR REF 1 CN
42 ISMAM_TXW_JHTFP PRODH JJT179 PRODH REF 1 CN
43 ISMAM_TXW_JHTFP PSTYV TJHAP PSTYV REF 1 CN
44 ISMAM_TXW_JHTFP PVA JDTPVA PVA REF 1 CN
45 ISMAM_TXW_JHTFP SPART TSPA SPART REF 1 CN
46 ISMAM_TXW_JHTFP STAFO TMCB STAFO REF 1 CN
47 ISMAM_TXW_JHTFP STGRB TJJ67 BEGRP_STAT REF 1 CN
48 ISMAM_TXW_JHTFP VAVTYP TJD05 VAVARTYP REF 1 CN
49 ISMAM_TXW_JHTFP VBELN JHTFK VBELN KEY 1 CN
50 ISMAM_TXW_JHTFP VERMART TJJ09 JVERMART REF C CN
51 ISMAM_TXW_JHTFP VGFKTYP TJH19 FKTYP    
52 ISMAM_TXW_JHTFP VGOBJ TJH97 OBJKT REF    
53 ISMAM_TXW_JHTFP VKBUR TVBUR VKBUR REF 1 CN
54 ISMAM_TXW_JHTFP VKGRP TVKGR VKGRP REF 1 CN
55 ISMAM_TXW_JHTFP VKORG_AUFT TVKO VKORG REF 1 CN
56 ISMAM_TXW_JHTFP VRKME T006 MSEHI REF 1 CN
57 ISMAM_TXW_JHTFP VTWEG TVTW VTWEG REF 1 CN
58 ISMAM_TXW_JHTFP WERKS T001W WERKS REF 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in 471