SAP ABAP View V_JSBW_INVOICE (IS-M: View for Reading All Billing Data)

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

View Type	D	Database View
Database View	V_JSBW_INVOICE
Short Description	IS-M: View for Reading All Billing Data
Root table	JFRK	IS-M/SD: Billing - Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JFRK	JFRK
2	JFRP
3	JFPA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JFRP	MANDT	JL	EQ				0	0
2	JFRK	MANDT	JR	EQ			AND	0	0
3	JFRP	VBELN	JL	EQ				0	0
4	JFRK	VBELN	JR	EQ			AND	0	0
5	JFPA	MANDT	JL	EQ				0	0
6	JFRK	MANDT	JR	EQ			AND	0	0
7	JFPA	VBELN	JL	EQ				0	0
8	JFRK	VBELN	JR	EQ			AND	0	0
9	JFPA	PARVW		EQ	'RE'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JFRK	MANDT		☐	MANDT	☐	Client
2	VBELN	JFRK	VBELN		☐	ISPVBELN	☐	IS-M/SD: Billing Document
3	FKART	JFRK	FKART		☐	JFKART	☐	IS-M: Billing/Settlement Type
4	VBTYP	JFRK	VBTYP		☐	VBTYP	☐	SD document category
5	WAERK	JFRK	WAERK		☐	WAERK	☐	SD document currency
6	VKORG	JFRK	VKORG		☐	VKORG	☐	Sales Organization
7	VTWEG	JFRK	VTWEG		☐	VTWEG	☐	Distribution Channel
8	KALSM	JFRK	KALSM		☐	KALSMASD	☐	Sales and Distribution: Pricing Procedure in Pricing
9	KNUMV	JFRK	KNUMV		☐	KNUMV	☐	Number of the document condition
10	FKDAT	JFRK	FKDAT		☐	FKDAT	☐	Billing date for billing index and printout
11	KONDA	JFRK	KONDA		☐	KONDA	☐	Price Group (Customer)
12	KDGRP	JFRK	KDGRP		☐	KDGRP	☐	Customer group
13	PLTYP	JFRK	PLTYP		☐	PLTYP	☐	Price list type
14	ZLSCH	JFRK	ZLSCH		☐	SCHZW_BSEG	☐	Payment Method
15	KTGRD	JFRK	KTGRD		☐	KTGRD	☐	Account assignment group for this customer
16	REGIO	JFRK	REGIO		☐	REGIO	☐	Region (State, Province, County)
17	COUNC	JFRK	COUNC		☐	COUNC	☐	County Code
18	CITYC	JFRK	CITYC		☐	CITYC	☐	City Code
19	BUKRS	JFRK	BUKRS		☐	BUKRS	☐	Company Code
20	KUNRG	JFRK	KUNRG		☐	KUNRG	☐	Payer
21	KUNAG	JFRK	KUNAG		☐	KUNAG	☐	Sold-to party
22	ISPSHKZGK	JFRK	ISPSHKZGK		☐	SHKZG	☐	Debit/Credit Indicator
23	ISPSTOGRD	JFRK	ISPSTOGRD		☐	JSTOGRDF	☐	IS-M: Billing Document Reversal Reason
24	ISPXINK	JFRK	ISPXINK		☐	XKINKASSO	☐	IS-M: Payment by field collector
25	ISPXWBZABO	JFRK	ISPXWBZABO		☐	XWBZABO	☐	IS-M: WBZ subscription
26	ISPINKVSG	JFRK	ISPINKVSG		☐	ISPINKVSG	☐	IS-M: Field Collector is Service Company
27	ISPINKGP	JFRK	ISPINKGP		☐	ISPINKGP	☐	IS-M: Field Collector is Employee
28	ISPXVDICHT	JFRK	ISPXVDICHT		☐	XFKVDICHT	☐	IS-M: Summarize deliveries according to billing item
29	XRENEWAL	JFRK	XRENEWAL		☐	XRENEWAL	☐	IS-M/SD: Order extended by renewal offer
30	POSNR	JFRP	POSNR		☐	ISPPOSNR	☐	IS-M: Billing Item
31	FKIMG	JFRP	FKIMG		☐	FKIMG	☐	Actual billed quantity
32	VRKME	JFRP	VRKME		☐	VRKME	☐	Sales unit
33	MEINS	JFRP	MEINS		☐	MEINS	☐	Base Unit of Measure
34	GSBER	JFRP	GSBER		☐	GSBER	☐	Business Area
35	FBUDA	JFRP	FBUDA		☐	FBUDA	☐	Date When Services Rendered
36	NETWR	JFRP	NETWR		☐	NETWR_FP	☐	Net value of the billing item in document currency
37	MATKL	JFRP	MATKL		☐	MATKL	☐	Material Group
38	SPART	JFRP	SPART		☐	SPART	☐	Division
39	WERKS	JFRP	WERKS		☐	WERKS_D	☐	Plant
40	ALAND	JFRP	ALAND		☐	ALAND	☐	Departure country (country from which the goods are sent)
41	WKREG	JFRP	WKREG		☐	WKREG	☐	Region in which plant is located
42	WKCOU	JFRP	WKCOU		☐	WKCOU	☐	County in which plant is located
43	WKCTY	JFRP	WKCTY		☐	WKCTY	☐	City in which plant is located
44	SKFBP	JFRP	SKFBP		☐	SKFBP	☐	Amount eligible for cash discount in document currency
45	SPARA	JFRP	SPARA		☐	SPART_AK	☐	Division for order header
46	SHKZG	JFRP	SHKZG		☐	SHKZG_VA	☐	Returns Item
47	ERNAM	JFRP	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
48	ERDAT	JFRP	ERDAT		☐	ERDAT	☐	Date on which the record was created
49	ERZET	JFRP	ERZET		☐	ERZET	☐	Entry time
50	STAFO	JFRP	STAFO		☐	STAFO	☐	Update group for statistics update
51	WAVWR	JFRP	WAVWR		☐	WAVWR	☐	Cost in document currency
52	ISPAUART	JFRP	ISPAUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
53	ISPAUAGRP	JFRP	ISPAUAGRP		☐	ISPAUAGRP	☐	IS-M: Sales Document Type Grouping for Sales Order
54	ISPKOSTL_L	JFRP	ISPKOSTL_L		☐	ISPKOSTL_L	☐	IS-M: Cost Center to be Charged
55	ISPDRERZ	JFRP	ISPDRERZ		☐	DRERZ	☐	Publication
56	ISPPVA	JFRP	ISPPVA		☐	PVA	☐	Edition
57	ISPBEZ	JFRP	ISPBEZ		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
58	ISPLIFART	JFRP	ISPLIFART		☐	LIEFERART	☐	Delivery Type
59	ISPPOSEX	JFRP	ISPPOSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
60	ISPVBELN	JFRP	ISPVBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
61	ISPPOSNR	JFRP	ISPPOSNR		☐	APNR	☐	Sales Order Item
62	ISPETENR	JFRP	ISPETENR		☐	JAENR	☐	Sales Order Schedule Line
63	ISPETEEX	JFRP	ISPETEEX		☐	ETEEX_ISP	☐	IS-M: External Schedule Line Number
64	ISPETART	JFRP	ISPETART		☐	ETART_ISP	☐	Schedule Line Type for Internal Sales Order Schedule Line
65	ISPETMENGE	JFRP	ISPETMENGE		☐	ETMENGE	☐	IS-M: Sales Order Schedule Line Quantity
66	ISPETMEINS	JFRP	ISPETMEINS		☐	ETMEINS	☐	IS-M: Sales Unit for Sales Order
67	ISPETVOR	JFRP	ISPETVOR		☐	ISPETVOR	☐	IS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Order
68	ISPANZET	JFRP	ISPANZET		☐	ISPANZET	☐	IS-M: Number of Publication Dates
69	ISPERSDAT	JFRP	ISPERSDAT		☐	ERSCHDAT	☐	Publication Date
70	ISPWRBAKT	JFRP	ISPWRBAKT		☐	WERBEAKT	☐	Sales Promotion
71	ISPFAKVON	JFRP	ISPFAKVON		☐	FAKVON	☐	IS-M: Billing Period From
72	ISPFAKBIS	JFRP	ISPFAKBIS		☐	FAKBIS	☐	IS-M: Billing Period To
73	ISPKONDA	JFRP	ISPKONDA		☐	KONDA	☐	Price Group (Customer)
74	ISPKDGRP	JFRP	ISPKDGRP		☐	KDGRP	☐	Customer group
75	ISPPOART	JFRP	ISPPOART		☐	POART_ISP	☐	Internal Item Type for Sales Order
76	ISPBRTWR_P	JFRP	ISPBRTWR_P		☐	ISPBRTWR	☐	IS-M: Gross Value in Document Currency
77	ISPVERSDAT	JFRP	ISPVERSDAT		☐	VRSNDDATUM	☐	IS-M: Shipping Date
78	ISPLANDE	JFRP	ISPLANDE		☐	LANDE_ISP	☐	Current country being supplied
79	ISPVAUSGB	JFRP	ISPVAUSGB		☐	VAUSGB	☐	Issue
80	ISPVKBURZU	JFRP	ISPVKBURZU		☐	VKBURZUS	☐	Sales office responsible
81	ISPXFKRUEK	JFRP	ISPXFKRUEK		☐	XFKRUECK	☐	IS-M: Retroactive Billing of Period Already Billed
82	ISPIVWKN	JFRP	ISPIVWKN		☐	IVWKN	☐	Circulation Audit Report Category ID
83	ISPXIVW	JFRP	ISPXIVW		☐	XIVW	☐	Indicator: Relevant for audit report
84	XNEGOPTION	JFRP	XNEGOPTION		☐	XNEGOPTION	☐	IS-M: Item with Automatic Transformation to Chargeable
85	IVWDATUM	JFRP	IVWDATUM		☐	IVWDATUM	☐	Date of Audit Report for Returns
86	CAMPAIGN	JFRP	CAMPAIGN		☐	ISM_MARKETING_CAMPAIGN	☐	IS-M: Marketing Campaign
87	FKPERVON	JFRP	FKPERVON		☐	FKPERVON	☐	IS-M: Initial Date of Full Billing Period
88	FKPERBIS	JFRP	FKPERBIS		☐	FKPERBIS	☐	IS-M: Closing Date of Full Billing Period
89	ISPZSKLS	JFRP	ISPZSKLS		☐	JZSKLS	☐	Time slice classification for sales order
90	ISPWRBART	JFRP	ISPWRBART		☐	WERBEART	☐	Sales Source
91	POSNR_UR	JFRP	POSNR_UR		☐	APNR_UR	☐	Original Item in Publishing Sales Order
92	CYCLENR	JFRP	CYCLENR		☐	CYCLENR	☐	IS-M/SD: Billing Cycle Number
93	FAKNRRUECK	JFRP	FAKNRRUECK		☐	ISPFAKNRRUECK	☐	IS-M: Recalculated Billing Document
94	XAUTO_REN	JFRP	XAUTO_REN		☐	XAUTO_REN	☐	IS-M/SD: Customer Requests Automatic Renewal
95	X_MONTAG	JFRP	X_MONTAG		☐	X_MONTAG	☐	IS-M: Monday
96	X_DIENSTAG	JFRP	X_DIENSTAG		☐	X_DIENSTAG	☐	IS-M: Tuesday
97	X_MITTWOCH	JFRP	X_MITTWOCH		☐	X_MITTWOCH	☐	IS-M: Wednesday
98	X_DONNETAG	JFRP	X_DONNETAG		☐	X_DONNETAG	☐	IS-M: Thursday
99	X_FREITAG	JFRP	X_FREITAG		☐	X_FREITAG	☐	IS-M: Friday
100	X_SAMSTAG	JFRP	X_SAMSTAG		☐	X_SAMSTAG	☐	IS-M: Saturday
101	X_SONNTAG	JFRP	X_SONNTAG		☐	X_SONNTAG	☐	IS-M: Sunday
102	VBELN_FROM	JFRP	VBELN_FROM		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
103	POSNR_UR_FROM	JFRP	POSNR_UR_FROM		☐	APNR	☐	Sales Order Item
104	CYCLENR_FROM	JFRP	CYCLENR_FROM		☐	CYCLENR	☐	IS-M/SD: Billing Cycle Number
105	PARVW	JFPA	PARVW		☐	PARVW	☐	Partner Role
106	KUNNR	JFPA	KUNNR		☐	KUNNR	☐	Customer Number
107	ADRNR	JFPA	ADRNR		☐	ADRNR	☐	Address
108	LAND1	JFPA	LAND1		☐	LAND1	☐	Country Key
109	ISPADRNR	JFPA	ISPADRNR		☐	JADRNR	☐	IS-M: Address Number
110	ISPADRVAR	JFPA	ISPADRVAR		☐	ADRESSVAR	☐	IS-M: Address Variant

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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