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***
⤷ 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
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 471 |