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