SAP ABAP Table JSBW_SD_INVOICE (IS-M: BW Structure for Full Billing Data Extraction)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ 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_INVOICE	Table Relationship Diagram
Short Description	IS-M: BW Structure for Full Billing Data Extraction

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	VBELN	☐	ISPVBELN	ISPVBELN	CHAR	10	0	IS-M/SD: Billing Document	*
3	FKART	☐	JFKART	JFKART	CHAR	4	0	IS-M: Billing/Settlement Type	*
4	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
5	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
6	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
7	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
8	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	*
9	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
10	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
11	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	*
12	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
13	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	*
14	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	*
15	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	*
16	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
17	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
18	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	*
19	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
20	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
21	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
22	ISPSHKZGK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
23	ISPSTOGRD	☐	JSTOGRDF	JSTOGRDF	CHAR	3	0	IS-M: Billing Document Reversal Reason	*
24	ISPXINK	☐	XKINKASSO	XFELD	CHAR	1	0	IS-M: Payment by field collector
25	ISPXWBZABO	☐	XWBZABO	XFELD	CHAR	1	0	IS-M: WBZ subscription
26	ISPINKVSG	☐	ISPINKVSG	KUNNR	CHAR	10	0	IS-M: Field Collector is Service Company	*
27	ISPINKGP	☐	ISPINKGP	KUNNR	CHAR	10	0	IS-M: Field Collector is Employee	*
28	ISPXVDICHT	☐	XFKVDICHT	XFELD	CHAR	1	0	IS-M: Summarize deliveries according to billing item
29	XRENEWAL	☐	XRENEWAL	XFELD	CHAR	1	0	IS-M/SD: Order extended by renewal offer
30	POSNR	☐	ISPPOSNR	ISPPOSNR	NUMC	6	0	IS-M: Billing Item	*
31	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
32	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
33	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
34	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
35	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
36	NETWR	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
37	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
38	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
39	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
40	ALAND	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	*
41	WKREG	☐	WKREG	REGIO	CHAR	3	0	Region in which plant is located	*
42	WKCOU	☐	WKCOU	CHAR3	CHAR	3	0	County in which plant is located
43	WKCTY	☐	WKCTY	CHAR4	CHAR	4	0	City in which plant is located
44	SKFBP	☐	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
45	SPARA	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	*
46	SHKZG	☐	SHKZG_VA	XFELD	CHAR	1	0	Returns Item
47	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
48	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
49	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
50	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
51	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
52	ISPAUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	*
53	ISPAUAGRP	☐	ISPAUAGRP	JAUARTGRP	CHAR	1	0	IS-M: Sales Document Type Grouping for Sales Order
54	ISPKOSTL_L	☐	ISPKOSTL_L	KOSTL	CHAR	10	0	IS-M: Cost Center to be Charged	*
55	ISPDRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	*
56	ISPPVA	☐	PVA	PVA	CHAR	8	0	Edition	*
57	ISPBEZ	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	*
58	ISPLIFART	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	*
59	ISPPOSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
60	ISPVBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
61	ISPPOSNR	☐	APNR	APNR	NUMC	6	0	Sales Order Item	*
62	ISPETENR	☐	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line	*
63	ISPETEEX	☐	ETEEX_ISP	ETEEX	NUMC	6	0	IS-M: External Schedule Line Number
64	ISPETART	☐	ETART_ISP	ETART_ISP	CHAR	2	0	Schedule Line Type for Internal Sales Order Schedule Line	*
65	ISPETMENGE	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
66	ISPETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	*
67	ISPETVOR	☐	ISPETVOR	VORZEI	CHAR	1	0	IS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Order
68	ISPANZET	☐	ISPANZET	ANZET	DEC	5	0	IS-M: Number of Publication Dates
69	ISPERSDAT	☐	ERSCHDAT	DATUM	DATS	8	0	Publication Date
70	ISPWRBAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	*
71	ISPFAKVON	☐	FAKVON	DATUM	DATS	8	0	IS-M: Billing Period From
72	ISPFAKBIS	☐	FAKBIS	DATUM	DATS	8	0	IS-M: Billing Period To
73	ISPKONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	*
74	ISPKDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
75	ISPPOART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	*
76	ISPBRTWR_P	☐	ISPBRTWR	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency
77	ISPVERSDAT	☐	VRSNDDATUM	DATUM	DATS	8	0	IS-M: Shipping Date
78	ISPLANDE	☐	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	*
79	ISPVAUSGB	☐	VAUSGB	VAUSGB	CHAR	10	0	Issue	*
80	ISPVKBURZU	☐	VKBURZUS	VKBUR	CHAR	4	0	Sales office responsible	*
81	ISPXFKRUEK	☐	XFKRUECK	XFELD	CHAR	1	0	IS-M: Retroactive Billing of Period Already Billed
82	ISPIVWKN	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	*
83	ISPXIVW	☐	XIVW	XFELD	CHAR	1	0	Indicator: Relevant for audit report
84	XNEGOPTION	☐	XNEGOPTION	XFELD	CHAR	1	0	IS-M: Item with Automatic Transformation to Chargeable
85	IVWDATUM	☐	IVWDATUM	DATUM	DATS	8	0	Date of Audit Report for Returns
86	CAMPAIGN_INV	☐	CHAR24	CHAR24	CHAR	24	0	Character field length 24
87	FKPERVON	☐	FKPERVON	DATUM	DATS	8	0	IS-M: Initial Date of Full Billing Period
88	FKPERBIS	☐	FKPERBIS	DATUM	DATS	8	0	IS-M: Closing Date of Full Billing Period
89	ISPZSKLS	☐	JZSKLS	JZSKLS	CHAR	1	0	Time slice classification for sales order
90	ISPWRBART	☐	WERBEART	WERBEART	CHAR	4	0	Sales Source	*
91	POSNR_UR	☐	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	*
92	CYCLENR	☐	CYCLENR	CYCLENR	NUMC	3	0	IS-M/SD: Billing Cycle Number	*
93	FAKNRRUECK	☐	ISPFAKNRRUECK	ISPVBELN	CHAR	10	0	IS-M: Recalculated Billing Document	*
94	XAUTO_REN	☐	XAUTO_REN	XFELD	CHAR	1	0	IS-M/SD: Customer Requests Automatic Renewal
95	X_MONTAG	☐	X_MONTAG	XFELD	CHAR	1	0	IS-M: Monday
96	X_DIENSTAG	☐	X_DIENSTAG	XFELD	CHAR	1	0	IS-M: Tuesday
97	X_MITTWOCH	☐	X_MITTWOCH	XFELD	CHAR	1	0	IS-M: Wednesday
98	X_DONNETAG	☐	X_DONNETAG	XFELD	CHAR	1	0	IS-M: Thursday
99	X_FREITAG	☐	X_FREITAG	XFELD	CHAR	1	0	IS-M: Friday
100	X_SAMSTAG	☐	X_SAMSTAG	XFELD	CHAR	1	0	IS-M: Saturday
101	X_SONNTAG	☐	X_SONNTAG	XFELD	CHAR	1	0	IS-M: Sunday
102	VBELN_FROM	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
103	POSNR_UR_FROM	☐	APNR	APNR	NUMC	6	0	Sales Order Item	*
104	CYCLENR_FROM	☐	CYCLENR	CYCLENR	NUMC	3	0	IS-M/SD: Billing Cycle Number	*
105	PARVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
106	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
107	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
108	ISPADRNR	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	*
109	ISPADRVAR	☐	ADRESSVAR	ERSTADR	CHAR	1	0	IS-M: Address Variant
110	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	*
111	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
112	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
113	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
114	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
115	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	*
116	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	*
117	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	*
118	.INCLUDE	☐				0	0	Core address data
119	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
120	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
121	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
122	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
123	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
124	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
125	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
126	PSTL3_ADDON	☐	PSTL3_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (Company)
127	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
128	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
129	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
130	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
131	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
132	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
133	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
134	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
135	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
136	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
137	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
138	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
139	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
140	.INCLUDE	☐				0	0	Include Structure for Alias (Alias Name)
141	ALIASNAME	☐	ALIASNAME	TEXT50	CHAR	50	0	IS-M: Alias Text (Street Name + Suffix)
142	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	*
143	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	*
144	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
145	GP_REF	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JSBW_SD_INVOICE	ADDRSECABBREV	TJS43	ADDRSECABBREV	KEY	1	CN
2	JSBW_SD_INVOICE	LAND1	T005	LAND1	REF	C	CN
3	JSBW_SD_INVOICE	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
4	JSBW_SD_INVOICE	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	472