SAP ABAP View PS_FVKPG (View of Selection of Account Holders for Account)
Hierarchy
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   IS-PS-CA (Application Component) Public Sector Contract Accounting
     FMCA_PSOB (Package) PSCD: Contract Object
Basic Data
View Type D Database View 
Database View PS_FVKPG  
Short Description View of Selection of Account Holders for Account    
Root table FKKVK   Contract Account Header 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 FKKVK FKKVK
2 FKKVKP FKKVKP
3 TFK002F  
4 BUT000  
5 BUT020  
6 BUT100  
7 ADRC  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 BUT000 CLIENT JL EQ 0 0
2 BUT020 CLIENT JR EQ AND 0 0
3 BUT000 PARTNER JL EQ 0 0
4 BUT020 PARTNER JR EQ AND 0 0
5 FKKVK MANDT JL EQ 0 0
6 FKKVKP MANDT JR EQ AND 0 0
7 FKKVK VKONT JL EQ 0 0
8 FKKVKP VKONT JR EQ AND 0 0
9 FKKVKP MANDT JL EQ 0 0
10 BUT000 CLIENT JR EQ AND 0 0
11 FKKVKP GPART JL EQ 0 0
12 BUT000 PARTNER JR EQ AND 0 0
13 TFK002F MANDT JL EQ 0 0
14 FKKVKP MANDT JR EQ AND 0 0
15 TFK002F VKPBZ JL EQ 0 0
16 FKKVKP VKPBZ JR EQ AND 0 0
17 BUT000 CLIENT JL EQ 0 0
18 BUT100 MANDT JR EQ AND 0 0
19 BUT000 PARTNER JL EQ 0 0
20 BUT100 PARTNER JR EQ AND 0 0
21 FKKVKP MANDT JL EQ 0 0
22 BUT020 CLIENT JR EQ AND 0 0
23 FKKVKP GPART JL EQ 0 0
24 BUT020 PARTNER JR EQ AND 0 0
25 FKKVKP MANDT JL EQ 0 0
26 BUT100 MANDT JR EQ AND 0 0
27 FKKVKP GPART JL EQ 0 0
28 BUT100 PARTNER JR EQ AND 0 0
29 BUT100 MANDT JL EQ 0 0
30 BUT020 CLIENT JR EQ AND 0 0
31 BUT100 PARTNER JL EQ 0 0
32 BUT020 PARTNER JR EQ AND 0 0
33 BUT020 CLIENT JL EQ 0 0
34 ADRC CLIENT JR EQ AND 0 0
35 BUT020 ADDRNUMBER JL EQ 0 0
36 ADRC ADDRNUMBER JR EQ AND 0 0
37 BUT020 DATE_FROM JL EQ 0 0
38 ADRC DATE_FROM JR EQ AND 0 0
39 BUT020 NATION JL EQ 0 0
40 ADRC NATION JR EQ AND 0 0
41 TFK002F XKTIN EQ 'X' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT ADRC CLIENT   MANDT Client
2 DFVAL BUT100 DFVAL   BU_DFVAL BP: Differentiation type value
3 VKONT FKKVKP VKONT   VKONT_KK Contract Account Number
4 GPART FKKVKP GPART   GPART_KK Business Partner Number
5 VKTYP FKKVK VKTYP   VKTYP_KK Contract Account Category
6 BEGRU FKKVKP BEGRU   BEGRU Authorization Group
7 ADDRNUMBER BUT020 ADDRNUMBER   AD_ADDRNUM Address number
8 NATION ADRC NATION   AD_NATION Version ID for International Addresses
9 MC_NAME1 BUT000 MC_NAME1   BU_MCNAME1 Search Help Field 1 (Name 1/Last Name)
10 MC_NAME2 BUT000 MC_NAME2   BU_MCNAME2 Search Help Field 2 (Name 2/First Name)
11 CITY1 ADRC MC_CITY1   AD_MC_CITY City name in upper case for search help
12 POST_CODE1 ADRC POST_CODE1   AD_PSTCD1 City postal code
13 STREET ADRC MC_STREET   AD_MC_STRT Street name in upper case for search help
14 HOUSE_NUM1 ADRC HOUSE_NUM1   AD_HSNM1 House Number
15 COUNTRY ADRC COUNTRY   LAND1 Country Key
16 TEL_NUMBER ADRC TEL_NUMBER   AD_TLNMBR1 First telephone no.: dialling code+number
17 TEL_EXTENS ADRC TEL_EXTENS   AD_TLXTNS1 First Telephone No.: Extension
18 PO_BOX ADRC PO_BOX   AD_POBX PO Box
19 RLTYP BUT100 RLTYP   BU_PARTNERROLE BP Role
20 AUGRP BUT000 AUGRP   BU_AUGRP Authorization Group
21 VALID_FROM BUT020 ADDR_VALID_FROM   BU_ADDR_VALID_FROM Validity Start of a Business Partner Address
22 VALID_TO BUT020 ADDR_VALID_TO   BU_ADDR_VALID_TO Validity End of a Business Partner Address
                 
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  20140121 
SAP Release Created in 471