SAP ABAP View JKVAK_CMPL_CIC (IS-M/SD: View for High-Performing Complaint Search (w/o BP))
Hierarchy
IS-M (Software Component) SAP MEDIA
   IS-M (Application Component) SAP Media
     JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
Basic Data
View Type D Database View 
Database View JKVAK_CMPL_CIC  
Short Description IS-M/SD: View for High-Performing Complaint Search (w/o BP)    
Root table JFFA   IS-M/SD: Object Flow 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 JFFA JFFA
2 JKAK  
3 JKAP  
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 JKAK VBELN JL EQ 0 0
4 JFFA VBELN_V JR EQ AND 0 0
5 JKAP MANDT JL EQ 0 0
6 JFFA MANDT JR EQ AND 0 0
7 JKAP VBELN JL EQ 0 0
8 JFFA VBELN_V JR EQ AND 0 0
9 JKAP POSNR JL EQ 0 0
10 JFFA POSNR_V JR EQ AND 0 0
11 JFFA ETENR_V EQ '0001' AND 0 0
12 JFFA ETENR_N EQ '0001' AND 0 0
13 JFFA OBJART_V EQ 'AUFP' AND 0 0
14 JFFA OBJART_N EQ 'KORP' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT JFFA MANDT   MANDT Client
2 VBELN_ORDER JFFA VBELN_V   AVNR IS-M/SD: Publishing Sales Order
3 POSNR_ORDER JFFA POSNR_V   APNR Sales Order Item
4 VBELN JFFA VBELN_N   AVNR IS-M/SD: Publishing Sales Order
5 POSNR JFFA POSNR_N   APNR Sales Order Item
6 VBTYP JKAK VBTYP   VBTYP_ISP Sales document category, IS-M
7 AUART JKAK AUART   AUART_ISP IS-M/SD: Sales Document Types
8 AUARTGRP JKAK AUARTGRP   JAUARTGRP IS-M/SD: Sales document type grouping
9 VKORG JKAK VKORG   VKORG Sales Organization
10 VTWEG JKAK VTWEG   VTWEG Distribution Channel
11 SPART JKAK SPART   SPART_AK Division for order header
12 REKLDATUM JKAK REKLDATUM   ISM_COMPLDATE IS-M/SD: Complaint Date
13 POSEX_ORDER JKAP POSEX   POSEX_ISP External Item Number (Purchase Order Item)
                 
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