I_FINANCIALPLANDATES

CDS View

Financial Plan Dates

I_FINANCIALPLANDATES is a CDS View in S/4HANA. Financial Plan Dates. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MasterProject view left_outer CONSUMPTION Master Project

Fields (2)

KeyField CDS FieldsUsed in Views
FinancialPlanScenario FinancialPlanScenario 1
MstrProjFinancialPlanUUID MstrProjFinancialPlanUUID 1 
@AbapCatalog.sqlViewName: 'IFPDATES'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Financial Plan Dates'
@VDM.viewType: #BASIC
define view I_FinancialPlanDates
  as select from /cpd/d_pfp_ph as FP
  inner join P_Mpsingleplan on FP.mp_id_int = P_Mpsingleplan.db_key
{
//  bintohex(FP.mp_id_int)                                             as MasterProjectUUID_E,

  bintohex(FP.mp_id_int)                                             as ProjectUUID,
  FP.plan_id                                                         as MstrProjFinancialPlanUUID,
  FP.start_date                                                      as FinancialPlanStartDate,
  FP.end_date                                                        as FinancialPlanEndDate,
  FP.plan_scen_id                                                    as FinancialPlanScenario,
  P_Mpsingleplan.org_id as MasterProjectOrganization,
  P_Mpsingleplan.mp_type as MasterProjectType,
  P_Mpsingleplan.confidential as MasterProjectIsConfidential,
  P_Mpsingleplan.mp_id as MasterProject
  

}
where
  FP.sel_structure = 'E'       
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_MPSINGLEPLAN",
"/CPD/D_PFP_PH"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More