SAP ABAP View V_JSBW_RECL_ACC (IS-M/SD: BW View for Reading Complaint Liability Accts)

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

Table

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

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JKAK	MANDT		☐	MANDT	☐	Client
2	VBTYP	JKAK	VBTYP		☐	VBTYP_ISP	☐	Sales document category, IS-M
3	TRVOG	JKAK	TRVOG		☐	TRVOG_ISP	☐	Transaction Group for IS-M Order Processing
4	AUART	JKAK	AUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
5	AUARTGRP	JKAK	AUARTGRP		☐	JAUARTGRP	☐	IS-M/SD: Sales document type grouping
6	VBELN_V	JFFA	VBELN_V		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
7	VBELN_N	JFFA	VBELN_N		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
8	POSNR_UR	JKACCOUNT	POSNR_UR		☐	APNR_UR	☐	Original Item in Publishing Sales Order
9	CYCLENR	JKACCOUNT	CYCLENR		☐	CYCLENR	☐	IS-M/SD: Billing Cycle Number
10	ZBETR	JKACCOUNT	ZBETR		☐	BETRZ	☐	IS-M/SD: Payment Amount in Local Currency
11	AMOBETR	JKACCOUNT	AMOBETR		☐	AMOBETR	☐	IS-M/SD: Amortization Amount
12	VAUSGB_F	JKACCOUNT	VAUSGB_F		☐	VAUSGB_F	☐	IS-M/SD: First Issue Delivered in Billing Cycle
13	VAUSGB_L	JKACCOUNT	VAUSGB_L		☐	VAUSGB_L	☐	IS-M/SD: Last Issue Delivered in Billing Cycle
14	VAUSGB_LBI	JKACCOUNT	VAUSGB_LBI		☐	VAUSGB_LBI	☐	IS-M/SD: Last issue delivered before billing doc.transfer
15	XCYCLE_FIN	JKACCOUNT	XCYCLE_FIN		☐	XCYCLE_FIN	☐	IS-M/SD: Amortization Complete for Liability Account
16	EXPDATE	JKACCOUNT	EXPDATE		☐	EXP_DATE	☐	IS-M/SD: Expiration Date of Subscription
17	DELIV_BILL	JKACCOUNT	DELIV_BILL		☐	DELIV_BILL	☐	Number of Deliveries Billed in Billing Cycle
18	DELIV_AMO	JKACCOUNT	DELIV_AMO		☐	DELIV_AMO	☐	Number of Amortized Deliveries in Billing Cycle
19	TFBETR	JKACCOUNT	TFBETR		☐	TFBETR	☐	IS-M/SD: Transfer amount
20	WAERK	JKACCOUNT	WAERK		☐	WAERK	☐	SD document currency
21	KURST	JKACCOUNT	KURST		☐	KURST	☐	Exchange Rate Type
22	TRANS_DATE	JKACCOUNT	TRANS_DATE		☐	WWERT_D	☐	Translation date
23	UKURS	JKACCOUNT	UKURS		☐	UKURS_CURR	☐	Exchange Rate
24	XINVOICE	JKACCOUNT	XINVOICE		☐	XINVOICE	☐	IS-M/SD: Billing and Transfer Performed for Cycle
25	XADVANCE_BILL	JKACCOUNT	XADVANCE_BILL		☐	XADVANCE_BILL	☐	IS-M/SD: Perform Billing in Advance
26	POSNR_V	JFFA	POSNR_V		☐	APNR	☐	Sales Order Item
27	ETENR_V	JFFA	ETENR_V		☐	JAENR	☐	Sales Order Schedule Line
28	POSNR_N	JFFA	POSNR_N		☐	APNR	☐	Sales Order Item
29	ETENR_N	JFFA	ETENR_N		☐	JAENR	☐	Sales Order Schedule Line
30	OBJART_V	JFFA	OBJART_V		☐	OBJART_V	☐	IS-M: Previous object type
31	OBJART_N	JFFA	OBJART_N		☐	OBJART_N	☐	IS-M: Subsequent Object Type
32	VBELN	JKACCOUNT	VBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order

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