SAP ABAP View V_JSBW_ACCOUNT (IS-M/SD: BW View for Reading Liability Accounts)

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_ACCOUNT
Short Description	IS-M/SD: BW View for Reading Liability Accounts
Root table	JKAK	Sales Order Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JKAK	JKAK
2	JKAP
3	JKACCOUNT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JKAP	MANDT	JL	EQ				0	0
2	JKAK	MANDT	JR	EQ			AND	0	0
3	JKAP	VBELN	JL	EQ				0	0
4	JKAK	VBELN	JR	EQ			AND	0	0
5	JKACCOUNT	MANDT	JL	EQ				0	0
6	JKAK	MANDT	JR	EQ			AND	0	0
7	JKACCOUNT	VBELN	JL	EQ				0	0
8	JKAP	VBELN	JR	EQ			AND	0	0
9	JKACCOUNT	POSNR_UR	JL	EQ				0	0
10	JKAP	POSNR	JR	EQ			AND	0	0
11	JKAK	VBTYP		EQ	'C'		AND	0	0
12	JKAK	TRVOG		EQ	'0'		AND	0	0
13	JKAK	AUARTGRP		EQ	'1'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JKAK	MANDT		☐	MANDT	☐	Client
2	VBELN	JKAK	VBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
3	VBTYP	JKAK	VBTYP		☐	VBTYP_ISP	☐	Sales document category, IS-M
4	TRVOG	JKAK	TRVOG		☐	TRVOG_ISP	☐	Transaction Group for IS-M Order Processing
5	AUART	JKAK	AUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
6	AUARTGRP	JKAK	AUARTGRP		☐	JAUARTGRP	☐	IS-M/SD: Sales document type grouping
7	XFKVDICHT	JKAK	XFKVDICHT		☐	XFKVDICHT	☐	IS-M: Summarize deliveries according to billing item
8	XRENEWAL	JKAK	XRENEWAL		☐	XRENEWAL	☐	IS-M/SD: Order extended by renewal offer
9	POSNR	JKAP	POSNR		☐	APNR	☐	Sales Order Item
10	GUELTIGVON	JKAP	GUELTIGVON		☐	JKAPVON	☐	Valid-From Date of Sales Order Item
11	GUELTIGBIS	JKAP	GUELTIGBIS		☐	JKAPBIS	☐	Date to which Sales Order Item is Valid
12	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
13	POSEX	JKAP	POSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
14	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
15	PVA	JKAP	PVA		☐	PVA	☐	Edition
16	BEZUGSTYP	JKAP	BEZUGSTYP		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
17	LIEFERART	JKAP	LIEFERART		☐	LIEFERART	☐	Delivery Type
18	UNTBRGRD	JKAP	UNTBRGRD		☐	UNTBRGRD	☐	Reason for Suspension
19	XURPOS	JKAP	XURPOS		☐	XURPOS	☐	Original item in publishing sales order
20	POSNR_UR	JKAP	POSNR_UR		☐	APNR_UR	☐	Original Item in Publishing Sales Order
21	POSNR_VG	JKAP	POSNR_VG		☐	APNR_VG	☐	Preceding Item in Publishing Sales Order
22	VBELN_VL	JKAP	VBELN_VL		☐	AVNR_VL	☐	Reference Document
23	POSNR_VL	JKAP	POSNR_VL		☐	APNR_VL	☐	Reference Document Item
24	XSTORNO	JKAP	XSTORNO		☐	XJSTORNO	☐	Indicator: Reversed
25	STORNOGRD	JKAP	STORNOGRD		☐	STORNOGRD	☐	Reversal Reason
26	POSNR_MAIN	JKAP	POSNR_MAIN		☐	APNR_MAIN	☐	IS-M/SD: Main Item in Sales Order
27	POSNR_SUB	JKAP	POSNR_SUB		☐	APNR_SUB	☐	IS-M/SD: Sub-Item in Sales Order
28	XMAINSPLIT	JKAP	XMAINSPLIT		☐	XMAINSPLIT	☐	Item for this Alternating Add. Element is a Main Sub-Item
29	X_MONTAG	JKAP	X_MONTAG		☐	X_MONTAG	☐	IS-M: Monday
30	X_DIENSTAG	JKAP	X_DIENSTAG		☐	X_DIENSTAG	☐	IS-M: Tuesday
31	X_MITTWOCH	JKAP	X_MITTWOCH		☐	X_MITTWOCH	☐	IS-M: Wednesday
32	X_DONNETAG	JKAP	X_DONNETAG		☐	X_DONNETAG	☐	IS-M: Thursday
33	X_FREITAG	JKAP	X_FREITAG		☐	X_FREITAG	☐	IS-M: Friday
34	X_SAMSTAG	JKAP	X_SAMSTAG		☐	X_SAMSTAG	☐	IS-M: Saturday
35	X_SONNTAG	JKAP	X_SONNTAG		☐	X_SONNTAG	☐	IS-M: Sunday
36	CAMPAIGN	JKAP	CAMPAIGN		☐	ISM_MARKETING_CAMPAIGN	☐	IS-M: Marketing Campaign
37	CYCLENR	JKACCOUNT	CYCLENR		☐	CYCLENR	☐	IS-M/SD: Billing Cycle Number
38	ZBETR	JKACCOUNT	ZBETR		☐	BETRZ	☐	IS-M/SD: Payment Amount in Local Currency
39	AMOBETR	JKACCOUNT	AMOBETR		☐	AMOBETR	☐	IS-M/SD: Amortization Amount
40	VAUSGB_F	JKACCOUNT	VAUSGB_F		☐	VAUSGB_F	☐	IS-M/SD: First Issue Delivered in Billing Cycle
41	VAUSGB_L	JKACCOUNT	VAUSGB_L		☐	VAUSGB_L	☐	IS-M/SD: Last Issue Delivered in Billing Cycle
42	VAUSGB_LBI	JKACCOUNT	VAUSGB_LBI		☐	VAUSGB_LBI	☐	IS-M/SD: Last issue delivered before billing doc.transfer
43	XCYCLE_FIN	JKACCOUNT	XCYCLE_FIN		☐	XCYCLE_FIN	☐	IS-M/SD: Amortization Complete for Liability Account
44	EXPDATE	JKACCOUNT	EXPDATE		☐	EXP_DATE	☐	IS-M/SD: Expiration Date of Subscription
45	DELIV_BILL	JKACCOUNT	DELIV_BILL		☐	DELIV_BILL	☐	Number of Deliveries Billed in Billing Cycle
46	DELIV_AMO	JKACCOUNT	DELIV_AMO		☐	DELIV_AMO	☐	Number of Amortized Deliveries in Billing Cycle
47	TFBETR	JKACCOUNT	TFBETR		☐	TFBETR	☐	IS-M/SD: Transfer amount
48	WAERK	JKACCOUNT	WAERK		☐	WAERK	☐	SD document currency
49	KURST	JKACCOUNT	KURST		☐	KURST	☐	Exchange Rate Type
50	TRANS_DATE	JKACCOUNT	TRANS_DATE		☐	WWERT_D	☐	Translation date
51	UKURS	JKACCOUNT	UKURS		☐	UKURS_CURR	☐	Exchange Rate
52	XINVOICE	JKACCOUNT	XINVOICE		☐	XINVOICE	☐	IS-M/SD: Billing and Transfer Performed for Cycle
53	XGOLIVE	JKACCOUNT	XGOLIVE		☐	XGOLIVE	☐	IS-M/SD: Cycle from Data Transfer
54	XFKRUECK	JKACCOUNT	XFKRUECK		☐	XFKRUECK	☐	IS-M: Retroactive Billing of Period Already Billed
55	POSNR_NP_LAST	JKACCOUNT	POSNR_NP_LAST		☐	POSNR_NP_LAST_AMO	☐	Standard Item Last Amortized Within Original Item
56	XADVANCE_BILL	JKACCOUNT	XADVANCE_BILL		☐	XADVANCE_BILL	☐	IS-M/SD: Perform Billing in Advance
57	XAMO_ARCHIVED	JKACCOUNT	XAMO_ARCHIVED		☐	XAMO_ARCHIVED	☐	IS-M/SD: Amortization Data on Cycle Activated

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	20110901
SAP Release Created in	471