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