Data Element list used by SAP ABAP Table JSBW_SD_INVOICE (IS-M: BW Structure for Full Billing Data Extraction)
SAP ABAP Table
JSBW_SD_INVOICE (IS-M: BW Structure for Full Billing Data Extraction) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ADDRSECABBREV | IS-M: Secondary Address Text | ||
| 2 | ADDRSECNUMBER | IS-M: Secondary Address Number | ||
| 3 | ADRESSVAR | IS-M: Address Variant | ||
| 4 | ADRNR | Address | ||
| 5 | ADRZUS2 | Classification Using a Further Address Affix | ||
| 6 | ALAND | Departure country (country from which the goods are sent) | ||
| 7 | ALIASNAME | IS-M: Alias Text (Street Name + Suffix) | ||
| 8 | APNR | Sales Order Item | ||
| 9 | APNR | Sales Order Item | ||
| 10 | APNR_UR | Original Item in Publishing Sales Order | ||
| 11 | AUART_ISP | IS-M/SD: Sales Document Types | ||
| 12 | AVNR | IS-M/SD: Publishing Sales Order | ||
| 13 | AVNR | IS-M/SD: Publishing Sales Order | ||
| 14 | BEZUGSTYP_JE_PVA | Mix Type | ||
| 15 | BUKRS | Company Code | ||
| 16 | CHAR24 | Character field length 24 | ||
| 17 | CITYC | City Code | ||
| 18 | COUNC | County Code | ||
| 19 | CYCLENR | IS-M/SD: Billing Cycle Number | ||
| 20 | CYCLENR | IS-M/SD: Billing Cycle Number | ||
| 21 | DIRECTIONAL | IS-M: Direction for Street | ||
| 22 | DIRECTIONAL | IS-M: Direction for Street | ||
| 23 | DRERZ | Publication | ||
| 24 | ERDAT | Date on which the record was created | ||
| 25 | ERNAM | Name of Person who Created the Object | ||
| 26 | ERSCHDAT | Publication Date | ||
| 27 | ERZET | Entry time | ||
| 28 | ETART_ISP | Schedule Line Type for Internal Sales Order Schedule Line | ||
| 29 | ETEEX_ISP | IS-M: External Schedule Line Number | ||
| 30 | ETMEINS | IS-M: Sales Unit for Sales Order | ||
| 31 | ETMENGE | IS-M: Sales Order Schedule Line Quantity | ||
| 32 | FAKBIS | IS-M: Billing Period To | ||
| 33 | FAKVON | IS-M: Billing Period From | ||
| 34 | FBUDA | Date When Services Rendered | ||
| 35 | FKDAT | Billing date for billing index and printout | ||
| 36 | FKIMG | Actual billed quantity | ||
| 37 | FKPERBIS | IS-M: Closing Date of Full Billing Period | ||
| 38 | FKPERVON | IS-M: Initial Date of Full Billing Period | ||
| 39 | GPNR | IS-M: Business Partner Key | ||
| 40 | GSBER | Business Area | ||
| 41 | HSNMR1 | IS-M: House Number | ||
| 42 | HSNMR2 | IS-M: House Number Affix | ||
| 43 | ISPANZET | IS-M: Number of Publication Dates | ||
| 44 | ISPAUAGRP | IS-M: Sales Document Type Grouping for Sales Order | ||
| 45 | ISPBRTWR | IS-M: Gross Value in Document Currency | ||
| 46 | ISPETVOR | IS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Order | ||
| 47 | ISPFAKNRRUECK | IS-M: Recalculated Billing Document | ||
| 48 | ISPINKGP | IS-M: Field Collector is Employee | ||
| 49 | ISPINKVSG | IS-M: Field Collector is Service Company | ||
| 50 | ISPKOSTL_L | IS-M: Cost Center to be Charged | ||
| 51 | ISPPOSNR | IS-M: Billing Item | ||
| 52 | ISPVBELN | IS-M/SD: Billing Document | ||
| 53 | IVWDATUM | Date of Audit Report for Returns | ||
| 54 | IVWKN | Circulation Audit Report Category ID | ||
| 55 | JADRNR | IS-M: Address Number | ||
| 56 | JAENR | Sales Order Schedule Line | ||
| 57 | JALORT | IS-M: City Number (Unique) | ||
| 58 | JANRED | IS-M: Form-of-Address Key | ||
| 59 | JFKART | IS-M: Billing/Settlement Type | ||
| 60 | JSTOGRDF | IS-M: Billing Document Reversal Reason | ||
| 61 | JZSKLS | Time slice classification for sales order | ||
| 62 | KALSMASD | Sales and Distribution: Pricing Procedure in Pricing | ||
| 63 | KDGRP | Customer group | ||
| 64 | KDGRP | Customer group | ||
| 65 | KNUMV | Number of the document condition | ||
| 66 | KONDA | Price Group (Customer) | ||
| 67 | KONDA | Price Group (Customer) | ||
| 68 | KTGRD | Account assignment group for this customer | ||
| 69 | KUNAG | Sold-to party | ||
| 70 | KUNNR | Customer Number | ||
| 71 | KUNRG | Payer | ||
| 72 | LAND1 | Country Key | ||
| 73 | LANDE_ISP | Current country being supplied | ||
| 74 | LIEFERART | Delivery Type | ||
| 75 | MATKL | Material Group | ||
| 76 | MEINS | Base Unit of Measure | ||
| 77 | NAME1_ISP | IS-M: Business Partner Name | ||
| 78 | NAME2_ISP | IS-M: First Name of Business Partner | ||
| 79 | NAME3_ISP | IS-M: Further Name Field for Business Partner | ||
| 80 | NAME4_ISP | IS-M: Further Name Field for Business Partner | ||
| 81 | NAMZU_ISP | IS-M: Name Affix | ||
| 82 | NETWR_FP | Net value of the billing item in document currency | ||
| 83 | NIELS | Nielsen ID | ||
| 84 | ORT01_ISP | IS-M: City | ||
| 85 | ORT02_ISP | IS-M: City District | ||
| 86 | ORTPF | IS-M: City for PO Box | ||
| 87 | PARVW | Partner Role | ||
| 88 | PFACH_ISP | IS-M: Post Office Box | ||
| 89 | PLTYP | Price list type | ||
| 90 | PLZPF | IS-M: Postal Code for PO Box | ||
| 91 | PLZ_ISP | IS-M: Postal Code | ||
| 92 | POART_ISP | Internal Item Type for Sales Order | ||
| 93 | POSEX_ISP | External Item Number (Purchase Order Item) | ||
| 94 | PSTL2_ADDON | IS-M: Extension to 5-Character ZIP Code (PO Box) | ||
| 95 | PSTL3 | IS-M: Company Postal Code | ||
| 96 | PSTL3_ADDON | IS-M: Extension to 5-Character ZIP Code (Company) | ||
| 97 | PSTLZ_ADDON | IS-M: Extension to 5-Character ZIP Code | ||
| 98 | PVA | Edition | ||
| 99 | REGIO | Region (State, Province, County) | ||
| 100 | RPMKR | Regional market | ||
| 101 | SCHZW_BSEG | Payment Method | ||
| 102 | SHKZG | Debit/Credit Indicator | ||
| 103 | SHKZG_VA | Returns Item | ||
| 104 | SKFBP | Amount eligible for cash discount in document currency | ||
| 105 | SPART | Division | ||
| 106 | SPART_AK | Division for order header | ||
| 107 | STAFO | Update group for statistics update | ||
| 108 | STOCK | Floor | ||
| 109 | STRAS_ISP | IS-M: Street Name | ||
| 110 | STREET2_ISM | IS-M: Second street line | ||
| 111 | TITEL_ISP | IS-M: Title | ||
| 112 | VAUSGB | Issue | ||
| 113 | VBTYP | SD document category | ||
| 114 | VKBURZUS | Sales office responsible | ||
| 115 | VKORG | Sales Organization | ||
| 116 | VORSW_ISP | IS-M: Name Prefix | ||
| 117 | VRKME | Sales unit | ||
| 118 | VRSNDDATUM | IS-M: Shipping Date | ||
| 119 | VTWEG | Distribution Channel | ||
| 120 | WAERK | SD document currency | ||
| 121 | WAVWR | Cost in document currency | ||
| 122 | WERBEAKT | Sales Promotion | ||
| 123 | WERBEART | Sales Source | ||
| 124 | WERKS_D | Plant | ||
| 125 | WKCOU | County in which plant is located | ||
| 126 | WKCTY | City in which plant is located | ||
| 127 | WKREG | Region in which plant is located | ||
| 128 | XAUTO_REN | IS-M/SD: Customer Requests Automatic Renewal | ||
| 129 | XFKRUECK | IS-M: Retroactive Billing of Period Already Billed | ||
| 130 | XFKVDICHT | IS-M: Summarize deliveries according to billing item | ||
| 131 | XIVW | Indicator: Relevant for audit report | ||
| 132 | XKINKASSO | IS-M: Payment by field collector | ||
| 133 | XNEGOPTION | IS-M: Item with Automatic Transformation to Chargeable | ||
| 134 | XRENEWAL | IS-M/SD: Order extended by renewal offer | ||
| 135 | XSTORNO_KZ | IS-M: Reversal BW (0Recordmode) | ||
| 136 | XWBZABO | IS-M: WBZ subscription | ||
| 137 | X_DIENSTAG | IS-M: Tuesday | ||
| 138 | X_DONNETAG | IS-M: Thursday | ||
| 139 | X_FREITAG | IS-M: Friday | ||
| 140 | X_MITTWOCH | IS-M: Wednesday | ||
| 141 | X_MONTAG | IS-M: Monday | ||
| 142 | X_SAMSTAG | IS-M: Saturday | ||
| 143 | X_SONNTAG | IS-M: Sunday |