SAP ABAP Table JSBW_SD_INV_ITEM (IS-M/SD: BW Structure for Billing Items)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M-IS (Application Component) Information System
⤷ JSBW (Package) IS-M: Link to Business Information Warehouse
⤷ IS-M-IS (Application Component) Information System
⤷ JSBW (Package) IS-M: Link to Business Information Warehouse
Basic Data
Table Category | INTTAB | Structure |
Structure | JSBW_SD_INV_ITEM | Table Relationship Diagram |
Short Description | IS-M/SD: BW Structure for Billing Items |
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 | VBELN | ISPVBELN | ISPVBELN | CHAR | 10 | 0 | IS-M/SD: Billing Document | * | |
2 | POSNR | ISPPOSNR | ISPPOSNR | NUMC | 6 | 0 | IS-M: Billing Item | * | |
3 | FKIMG | FKIMG | MENG13 | QUAN | 13 | 3 | Actual billed quantity | ||
4 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
5 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
6 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
7 | PRSDT | PRSDT | DATUM | DATS | 8 | 0 | Date for pricing and exchange rate | ||
8 | FBUDA | FBUDA | DATUM | DATS | 8 | 0 | Date When Services Rendered | ||
9 | KURSK | KURSK | KURRF | DEC | 9 | 5 | Exchange Rate for Pricing and Statistics | ||
10 | NETWR | NETWR_FP | WERTV8 | CURR | 15 | 2 | Net value of the billing item in document currency | ||
11 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
12 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
13 | POSPA | ISPPOSPA | ISPPOSNR | NUMC | 6 | 0 | IS-M: Item Number of Partner Segment | * | |
14 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
15 | ALAND | ALAND | LAND1 | CHAR | 3 | 0 | Departure country (country from which the goods are sent) | * | |
16 | WKREG | WKREG | REGIO | CHAR | 3 | 0 | Region in which plant is located | * | |
17 | WKCOU | WKCOU | CHAR3 | CHAR | 3 | 0 | County in which plant is located | ||
18 | WKCTY | WKCTY | CHAR4 | CHAR | 4 | 0 | City in which plant is located | ||
19 | TAXM1 | TAXM1 | TAXKM | CHAR | 1 | 0 | Tax classification material | * | |
20 | TAXM2 | TAXM2 | TAXKM | CHAR | 1 | 0 | Tax classification material | * | |
21 | TAXM3 | TAXM3 | TAXKM | CHAR | 1 | 0 | Tax classification material | * | |
22 | TAXM4 | TAXM4 | TAXKM | CHAR | 1 | 0 | Tax Classification 4 Material | * | |
23 | TAXM5 | TAXM5 | TAXKM | CHAR | 1 | 0 | Tax classification 5 for material | * | |
24 | TAXM6 | TAXM6 | TAXKM | CHAR | 1 | 0 | Tax classification 6 for material | * | |
25 | TAXM7 | TAXM7 | TAXKM | CHAR | 1 | 0 | Tax classification 7 for material | * | |
26 | TAXM8 | TAXM8 | TAXKM | CHAR | 1 | 0 | Tax Classification 8 Material | * | |
27 | TAXM9 | TAXM9 | TAXKM | CHAR | 1 | 0 | Tax Classification 9 Material | * | |
28 | SKTOF | SKTOF | XFELD | CHAR | 1 | 0 | Cash discount indicator | ||
29 | SKFBP | SKFBP | WERTV7 | CURR | 13 | 2 | Amount eligible for cash discount in document currency | ||
30 | SPARA | SPART_AK | SPART | CHAR | 2 | 0 | Division for order header | * | |
31 | SHKZG | SHKZG_VA | XFELD | CHAR | 1 | 0 | Returns Item | ||
32 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
33 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
34 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
35 | STAFO | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
36 | WAVWR | WAVWR | WERTV7 | CURR | 13 | 2 | Cost in document currency | ||
37 | STCUR | STCUR_AP | KURRF | DEC | 9 | 5 | Exchange rate for statistics (Exch.rate at time of creation) | ||
38 | UVPRS | UVPRS | XFELD | CHAR | 1 | 0 | Incomplete with respect to pricing | ||
39 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
40 | .INCLUDE | 0 | 0 | IS-M/SD: Item Data for Billing | |||||
41 | ISPAUART | AUART_ISP | AUART_ISP | CHAR | 4 | 0 | IS-M/SD: Sales Document Types | TJAK | |
42 | ISPAUAGRP | ISPAUAGRP | JAUARTGRP | CHAR | 1 | 0 | IS-M: Sales Document Type Grouping for Sales Order | ||
43 | ISPKOSTL_L | ISPKOSTL_L | KOSTL | CHAR | 10 | 0 | IS-M: Cost Center to be Charged | * | |
44 | ISPDRERZ | DRERZ | DRERZ | CHAR | 8 | 0 | Publication | JDTDRER | |
45 | ISPPVA | PVA | PVA | CHAR | 8 | 0 | Edition | JDTPVA | |
46 | ISPBEZ | BEZUGSTYP_JE_PVA | BEZUGSTYP_JE_PVA | CHAR | 2 | 0 | Mix Type | JDTBEZTYP | |
47 | ISPLIFART | LIEFERART | LIEFERART | CHAR | 2 | 0 | Delivery Type | TJV01 | |
48 | ISPDRUCK | ISPDRUCK | WERKS | CHAR | 4 | 0 | IS-M: Plant (Printing Works) | T001W | |
49 | ISPGUTSCH | ISPGUTSCH | GUTSCHEIN | NUMC | 8 | 0 | IS-M: Coupon Number | ||
50 | ISPXLOGO | XLOGO | XFELD | CHAR | 1 | 0 | Print Logo | ||
51 | ISPPVAKNTG | ISPPVAKNTG | KTGRM | CHAR | 2 | 0 | IS-M: Account Assignment Grouping for Edition | TVKM | |
52 | ISPPVAKONG | ISPPVAKONG | KONDM | CHAR | 2 | 0 | IS-M: Edition Condition Grouping | T178 | |
53 | ISPPVABONG | ISPPVABONG | BONUS | CHAR | 2 | 0 | IS-M: Bonus Grouping for Edition | TVBO | |
54 | ISPFKPER | FKPER | FKPER | CHAR | 2 | 0 | Billing Frequency | TJK01 | |
55 | ISPPERFK | PERFK | WFCID | CHAR | 2 | 0 | Invoice dates (calendar identification) | TFACD | |
56 | ISPZAHLW | JZAHLW | JZAHLW | CHAR | 1 | 0 | Billing method | ||
57 | ISPPOSEX | POSEX_ISP | POSEX_ISP | NUMC | 6 | 0 | External Item Number (Purchase Order Item) | ||
58 | ISPJPERIOD | JPERIOD | XFELD | CHAR | 1 | 0 | IS-M: Periodic settlement | ||
59 | ISPVBELN | AVNR | AVNR | CHAR | 10 | 0 | IS-M/SD: Publishing Sales Order | JKAK | |
60 | ISPPOSNR | APNR | APNR | NUMC | 6 | 0 | Sales Order Item | JKAP | |
61 | ISPETENR | JAENR | AENR | NUMC | 4 | 0 | Sales Order Schedule Line | JKEP | |
62 | ISPETEEX | ETEEX_ISP | ETEEX | NUMC | 6 | 0 | IS-M: External Schedule Line Number | ||
63 | ISPETART | ETART_ISP | ETART_ISP | CHAR | 2 | 0 | Schedule Line Type for Internal Sales Order Schedule Line | TJEP | |
64 | ISPETMENGE | ETMENGE | MENGGPOS | QUAN | 10 | 0 | IS-M: Sales Order Schedule Line Quantity | ||
65 | ISPETMEINS | ETMEINS | MEINS | UNIT | 3 | 0 | IS-M: Sales Unit for Sales Order | T006 | |
66 | ISPETVOR | ISPETVOR | VORZEI | CHAR | 1 | 0 | IS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Order | ||
67 | ISPKPOSN | KPOSN | NUM6 | NUMC | 6 | 0 | Condition Item Number | ||
68 | ISPPRBAS | ISPPRBAS | PRBAS_ISP | CHAR | 1 | 0 | IS-M: Price Basis | ||
69 | ISPPRSPER | ISPPRSPER | PRSPER | CHAR | 2 | 0 | IS-M: Price Frequency | TJK03 | |
70 | ISPBZPERF | ISPBZPERF | BEZPER | CHAR | 5 | 0 | IS-M: Service Type for Billing | TJD09 | |
71 | ISPPRSMLT | ISPPRSMLT | PRSMLT | DEC | 5 | 0 | IS-M: Numerator in Conversion Factor for Frequencies | ||
72 | ISPPRSDIV | ISPPRSDIV | PRSDIV | DEC | 5 | 0 | IS-M: Denominator for Frequency Conversion Factor | ||
73 | ISPAEART | ISPAEART | AEART_JSDK | CHAR | 1 | 0 | IS-M: Order Change Type | ||
74 | ISPANZET | ISPANZET | ANZET | DEC | 5 | 0 | IS-M: Number of Publication Dates | ||
75 | ISPERSDAT | ERSCHDAT | DATUM | DATS | 8 | 0 | Publication Date | ||
76 | ISPWRBAKT | WERBEAKT | WERBEAKT | CHAR | 8 | 0 | Sales Promotion | TJWAK | |
77 | ISPFAKVON | FAKVON | DATUM | DATS | 8 | 0 | IS-M: Billing Period From | ||
78 | ISPFAKBIS | FAKBIS | DATUM | DATS | 8 | 0 | IS-M: Billing Period To | ||
79 | ISPKONDA | KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | T188 | |
80 | ISPKDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | T151 | |
81 | ISPPOART | POART_ISP | POART_ISP | CHAR | 2 | 0 | Internal Item Type for Sales Order | TJAP | |
82 | ISPPRSANTZ | PRSANTZ | ISPWERT8 | DEC | 8 | 0 | IS-M: Numerator for proportional prices | ||
83 | ISPPRSANTN | PRSANTN | ISPWERT8 | DEC | 8 | 0 | IS-M: Denominator for proportional prices | ||
84 | ISPPRSANZP | PRSANZP | ISPWERT8 | DEC | 8 | 0 | IS-M: Number of periods in billing period | ||
85 | ISPBRTWR_P | ISPBRTWR | WERTV8 | CURR | 15 | 2 | IS-M: Gross Value in Document Currency | ||
86 | ISPPRBAS_V | PRBAS_VK | PRBAS_ISP | CHAR | 1 | 0 | Price Basis for Shipping Costs | ||
87 | ISPLAGRP_V | LANDGRP_VK | LANDGRP_VK | CHAR | 2 | 0 | Country grouping for shipping costs | TJG92 | |
88 | ISPXFKKOMP | XFKKOMP | XFELD | CHAR | 1 | 0 | Indicator: Perform Billing in Full for Billing Period | ||
89 | ISPXFKENDE | XFKENDE | XFELD | CHAR | 1 | 0 | Indicator: Billing at end of calculation | ||
90 | ISPSFPOS | XSEPFKPOS | XFELD | CHAR | 1 | 0 | Separate billing document for order item | ||
91 | ISPXKOMPP | XKOMPP | XFELD | CHAR | 1 | 0 | IS-M: Full period (billing) | ||
92 | ISPVERSDAT | VRSNDDATUM | DATUM | DATS | 8 | 0 | IS-M: Shipping Date | ||
93 | ISPLANDE | LANDE_ISP | LAND1 | CHAR | 3 | 0 | Current country being supplied | * | |
94 | ISPRKAUFNR | J_RK_AUFNR | J_RK_AUFNR | CHAR | 8 | 0 | Order Number of RK Order for Account Assignment | ||
95 | ISPRKPOSNR | J_RK_POSNR | J_RK_POSNR | NUMC | 2 | 0 | Item Number of RK Order for Account Assignment | ||
96 | ISPCOAUFNR | J_CO_AUFNR | AUFNR | CHAR | 12 | 0 | Order number of internal CO order for account assignment | AUFK | |
97 | ISPVAUSGB | VAUSGB | VAUSGB | CHAR | 10 | 0 | Issue | JDTVAUSGB | |
98 | ISPXFKBALF | XFKBASLIEF | XFELD | CHAR | 1 | 0 | IS-M: Billing based on delivery | ||
99 | ISPXFKBAAU | XFKBASAUFT | XFELD | CHAR | 1 | 0 | IS-M: Billing based on order | ||
100 | ISPVKBURZU | VKBURZUS | VKBUR | CHAR | 4 | 0 | Sales office responsible | * | |
101 | ISPXSTABGR | JXMWSTABGR | XFELD | CHAR | 1 | 0 | VAT to be accrued proportionally for payment in billing | ||
102 | ISPXIMMAT | XIMMATRIK | XFELD | CHAR | 1 | 0 | Indicator: Proof of matriculation provided | ||
103 | ISPIMMATD | IMMATDAT | DATUM | DATS | 8 | 0 | Matriculation Certificate Valid To | ||
104 | ISPXFKRUEK | XFKRUECK | XFELD | CHAR | 1 | 0 | IS-M: Retroactive Billing of Period Already Billed | ||
105 | ISPIVWKN | IVWKN | IVWKN | CHAR | 8 | 0 | Circulation Audit Report Category ID | * | |
106 | ISPXIVW | XIVW | XFELD | CHAR | 1 | 0 | Indicator: Relevant for audit report | ||
107 | ISPJKPAVRG | JKPAVONREG | DATUM | DATS | 8 | 0 | Normal Start of Address Validity for Retro.Order Items | ||
108 | ISPJKPABRG | JKPABISREG | DATUM | DATS | 8 | 0 | End of Address Validity if End of Billing Delayed | ||
109 | XNEGOPTION | XNEGOPTION | XFELD | CHAR | 1 | 0 | IS-M: Item with Automatic Transformation to Chargeable | ||
110 | IVWDATUM | IVWDATUM | DATUM | DATS | 8 | 0 | Date of Audit Report for Returns | ||
111 | CAMPAIGN | ISM_MARKETING_CAMPAIGN | ISM_MARKETING_CAMPAIGN | RAW | 16 | 0 | IS-M: Marketing Campaign | ||
112 | ISPBDPER | BDPER | DATUM | DATS | 8 | 0 | IS-M: Basic Date for Billing Frequency | ||
113 | FKPERVON | FKPERVON | DATUM | DATS | 8 | 0 | IS-M: Initial Date of Full Billing Period | ||
114 | FKPERBIS | FKPERBIS | DATUM | DATS | 8 | 0 | IS-M: Closing Date of Full Billing Period | ||
115 | ISPZSKLS | JZSKLS | JZSKLS | CHAR | 1 | 0 | Time slice classification for sales order | ||
116 | ISPWRBART | WERBEART | WERBEART | CHAR | 4 | 0 | Sales Source | * | |
117 | POSNR_UR | APNR_UR | APNR | NUMC | 6 | 0 | Original Item in Publishing Sales Order | * | |
118 | CYCLENR | CYCLENR | CYCLENR | NUMC | 3 | 0 | IS-M/SD: Billing Cycle Number | * | |
119 | FAKNRRUECK | ISPFAKNRRUECK | ISPVBELN | CHAR | 10 | 0 | IS-M: Recalculated Billing Document | * | |
120 | XFIXED | XINDEXFIXED | XFELD | CHAR | 1 | 0 | Indicator: Billing Index Fixed and Cannot be Deleted | ||
121 | RCODE | RATE_CODE | RATE_CODE | CHAR | 4 | 0 | IS-M/SD: Rate Code | * | |
122 | XAUTO_REN | XAUTO_REN | XFELD | CHAR | 1 | 0 | IS-M/SD: Customer Requests Automatic Renewal | ||
123 | STBFREI | JSTBFREI | JSTBFREI | CHAR | 2 | 0 | Type of Tax Exemption | * | |
124 | XNFAK | ISPXNFAK | XFELD | CHAR | 1 | 0 | IS-M: Indicator - Repeat Billing After Reversal | ||
125 | DELIVSPLIT | DELIVSPLIT | DELIVSPLIT | CHAR | 8 | 0 | IS-M/SD: Alternating Address Element | * | |
126 | DELIVSPLITGRP | DELIVSPLITGRP | DELIVSPLITGRP | CHAR | 10 | 0 | IS-M/SD: Address Alternation Group | * | |
127 | POSNR_MAIN | APNR_MAIN | APNR | NUMC | 6 | 0 | IS-M/SD: Main Item in Sales Order | * | |
128 | POSNR_SUB | APNR_SUB | APNR | NUMC | 6 | 0 | IS-M/SD: Sub-Item in Sales Order | * | |
129 | .INCLUDE | 0 | 0 | IS-M/SD: Field String for Weekdays | |||||
130 | X_MONTAG | X_MONTAG | XFELD | CHAR | 1 | 0 | IS-M: Monday | ||
131 | X_DIENSTAG | X_DIENSTAG | XFELD | CHAR | 1 | 0 | IS-M: Tuesday | ||
132 | X_MITTWOCH | X_MITTWOCH | XFELD | CHAR | 1 | 0 | IS-M: Wednesday | ||
133 | X_DONNETAG | X_DONNETAG | XFELD | CHAR | 1 | 0 | IS-M: Thursday | ||
134 | X_FREITAG | X_FREITAG | XFELD | CHAR | 1 | 0 | IS-M: Friday | ||
135 | X_SAMSTAG | X_SAMSTAG | XFELD | CHAR | 1 | 0 | IS-M: Saturday | ||
136 | X_SONNTAG | X_SONNTAG | XFELD | CHAR | 1 | 0 | IS-M: Sunday | ||
137 | VBELN_FROM | AVNR | AVNR | CHAR | 10 | 0 | IS-M/SD: Publishing Sales Order | * | |
138 | POSNR_UR_FROM | APNR | APNR | NUMC | 6 | 0 | Sales Order Item | * | |
139 | CYCLENR_FROM | CYCLENR | CYCLENR | NUMC | 3 | 0 | IS-M/SD: Billing Cycle Number | * | |
140 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * |
Foreign Keys
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 471 |