P_ProjectWithVersion

DDL: P_PROJECTWITHVERSION SQL: PPROJWITHVERS Type: view COMPOSITE

P_ProjectWithVersion is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_Project, I_ProjectVersion) and exposes 197 fields with key fields Project, Version, Version.

Data Sources (2)

SourceAliasJoin Type
I_Project I_Project union_all
I_ProjectVersion I_ProjectVersion from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPROJWITHVERS view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #CHECK view

Fields (197)

KeyFieldSource TableSource FieldDescription
KEY Project I_ProjectVersion Project
KEY Version I_ProjectVersion Version
ProjectWithCodingMask I_ProjectVersion ProjectWithCodingMask
IsProjectVersionObject
ProjectInternalID I_ProjectVersion ProjectInternalID
ProjectDescription I_ProjectVersion ProjectDescription
ProjectObject I_ProjectVersion ProjectObject
CreatedByUser I_ProjectVersion CreatedByUser
CreationDate I_ProjectVersion CreationDate
LastChangedByUser I_ProjectVersion LastChangedByUser
LastChangeDate I_ProjectVersion LastChangeDate
ResponsiblePerson I_ProjectVersion ResponsiblePerson
ResponsiblePersonName I_ProjectVersion ResponsiblePersonName
ApplicantCode I_ProjectVersion ApplicantCode
ApplicantName I_ProjectVersion ApplicantName
CompanyCode I_ProjectVersion CompanyCode
BusinessArea I_ProjectVersion BusinessArea
ControllingArea I_ProjectVersion ControllingArea
ProfitCenter I_ProjectVersion ProfitCenter
Currency I_ProjectVersion Currency
NetworkAssignmentType I_ProjectVersion NetworkAssignmentType
WBSElmntDatesIsDetailed I_ProjectVersion WBSElmntDatesIsDetailed
PlannedStartDate I_ProjectVersion PlannedStartDate
PlannedEndDate I_ProjectVersion PlannedEndDate
Plant I_ProjectVersion Plant
FactoryCalendar I_ProjectVersion FactoryCalendar
NetworkHdrIsVisibleToUser I_ProjectVersion NetworkHdrIsVisibleToUser
NetworkProfile I_ProjectVersion NetworkProfile
ProjectProfileCode I_ProjectVersion ProjectProfileCode
BudgetProfile I_ProjectVersion BudgetProfile
Language I_ProjectVersion Language
CostCenter I_ProjectVersion CostCenter
CostObject I_ProjectVersion CostObject
BasicDatesLastScheduledDate I_ProjectVersion BasicDatesLastScheduledDate
FcstdDatesLastScheduledDate I_ProjectVersion FcstdDatesLastScheduledDate
ProjectHasOwnStock I_ProjectVersion ProjectHasOwnStock
ControllingObjectClass I_ProjectVersion ControllingObjectClass
WBSIsStatisticalWBSElement I_ProjectVersion WBSIsStatisticalWBSElement
TaxJurisdiction I_ProjectVersion TaxJurisdiction
ProjInterestCalcProfile I_ProjectVersion ProjInterestCalcProfile
InvestmentProfile I_ProjectVersion InvestmentProfile
PaymentPlanProfile I_ProjectVersion PaymentPlanProfile
ResultAnalysisInternalID I_ProjectVersion ResultAnalysisInternalID
PlanningProfile I_ProjectVersion PlanningProfile
WBSIsMarkedForIntegratedPlng I_ProjectVersion WBSIsMarkedForIntegratedPlng
IsMarkedForDeletion I_ProjectVersion IsMarkedForDeletion
InventorySpecialStockValnType I_ProjectVersion InventorySpecialStockValnType
WBSIsMarkedForAutomReqmtGrpg I_ProjectVersion WBSIsMarkedForAutomReqmtGrpg
WorkCenterLocation I_ProjectVersion WorkCenterLocation
FunctionalArea I_ProjectVersion FunctionalArea
SalesOrganization I_ProjectVersion SalesOrganization
DistributionChannel I_ProjectVersion DistributionChannel
Division I_ProjectVersion Division
DynItemProcessorPrfl I_ProjectVersion DynItemProcessorPrfl
JointVenture I_ProjectVersion JointVenture
JointVentureCostRecoveryCode I_ProjectVersion JointVentureCostRecoveryCode
JointVentureEquityType I_ProjectVersion JointVentureEquityType
JointVentureObjectType I_ProjectVersion JointVentureObjectType
JointVentureClass I_ProjectVersion JointVentureClass
JointVentureSubClass I_ProjectVersion JointVentureSubClass
WBSSchedulingProfile I_ProjectVersion WBSSchedulingProfile
PlanningMethForProjBasicDate I_ProjectVersion PlanningMethForProjBasicDate
PlanningMethForProjFcstdDate I_ProjectVersion PlanningMethForProjFcstdDate
SchedulingDurationUnit I_ProjectVersion SchedulingDurationUnit
_BusinessArea I_ProjectVersion _BusinessArea
_CompanyCode I_ProjectVersion _CompanyCode
_ControllingArea I_ProjectVersion _ControllingArea
_ControllingObjectClass I_ProjectVersion _ControllingObjectClass
_CostCenter I_ProjectVersion _CostCenter
_Plant I_ProjectVersion _Plant
_ProjectProfileCode I_ProjectVersion _ProjectProfileCode
_NetworkProfile I_ProjectVersion _NetworkProfile
_TaxJurisdiction I_ProjectVersion _TaxJurisdiction
_ProjInterestCalcProfile I_ProjectVersion _ProjInterestCalcProfile
_FunctionalArea I_ProjectVersion _FunctionalArea
_Wbsschedulingprofile I_ProjectVersion _Wbsschedulingprofile
_ProfitCenter I_ProjectVersion _ProfitCenter
_ProjBasicDatePlanMethName I_ProjectVersion _ProjBasicDatePlanMethName
_ProjFcstdDatePlanMethName I_ProjectVersion _ProjFcstdDatePlanMethName
_ResponsiblePerson I_ProjectVersion _ResponsiblePerson
_ProjectApplicant I_ProjectVersion _ProjectApplicant
FreeDefinedTableFieldSemantic FreeDefinedTableFieldSemantic
FreeDefinedAttribute01 FreeDefinedAttribute01
FreeDefinedAttribute02 FreeDefinedAttribute02
FreeDefinedAttribute03 FreeDefinedAttribute03
FreeDefinedAttribute04 FreeDefinedAttribute04
FreeDefinedQuantity1 FreeDefinedQuantity1
FreeDefinedQuantity1Unit FreeDefinedQuantity1Unit
FreeDefinedQuantity2 FreeDefinedQuantity2
FreeDefinedQuantity2Unit FreeDefinedQuantity2Unit
FreeDefinedAmount1 FreeDefinedAmount1
FreeDefinedAmount1Currency FreeDefinedAmount1Currency
FreeDefinedAmount2 FreeDefinedAmount2
FreeDefinedAmount2Currency FreeDefinedAmount2Currency
FreeDefinedDate1 FreeDefinedDate1
FreeDefinedDate2 FreeDefinedDate2
FreeDefinedIndicator1 FreeDefinedIndicator1
FreeDefinedIndicator2 FreeDefinedIndicator2
Project
KEY Version
ProjectWithCodingMask I_Project ProjectWithCodingMask
IsProjectVersionObject
ProjectInternalID I_Project ProjectInternalID
ProjectDescription I_Project ProjectDescription
ProjectObject I_Project ProjectObject
CreatedByUser I_Project CreatedByUser
CreationDate I_Project CreationDate
LastChangedByUser I_Project LastChangedByUser
LastChangeDate I_Project LastChangeDate
ResponsiblePerson I_Project ResponsiblePerson
ResponsiblePersonName I_Project ResponsiblePersonName
ApplicantCode I_Project ApplicantCode
ApplicantName I_Project ApplicantName
CompanyCode I_Project CompanyCode
BusinessArea I_Project BusinessArea
ControllingArea I_Project ControllingArea
ProfitCenter I_Project ProfitCenter
Currency I_Project Currency
NetworkAssignmentType I_Project NetworkAssignmentType
WBSElmntDatesIsDetailed I_Project WBSElmntDatesIsDetailed
PlannedStartDate I_Project PlannedStartDate
PlannedEndDate I_Project PlannedEndDate
Plant I_Project Plant
FactoryCalendar I_Project FactoryCalendar
NetworkHdrIsVisibleToUser I_Project NetworkHdrIsVisibleToUser
NetworkProfile I_Project NetworkProfile
ProjectProfileCode I_Project ProjectProfileCode
BudgetProfile I_Project BudgetProfile
Language I_Project Language
CostCenter I_Project CostCenter
CostObject I_Project CostObject
BasicDatesLastScheduledDate I_Project BasicDatesLastScheduledDate
FcstdDatesLastScheduledDate I_Project FcstdDatesLastScheduledDate
ProjectHasOwnStock I_Project ProjectHasOwnStock
ControllingObjectClass I_Project ControllingObjectClass
WBSIsStatisticalWBSElement I_Project WBSIsStatisticalWBSElement
TaxJurisdiction I_Project TaxJurisdiction
ProjInterestCalcProfile I_Project ProjInterestCalcProfile
InvestmentProfile I_Project InvestmentProfile
PaymentPlanProfile I_Project PaymentPlanProfile
ResultAnalysisInternalID I_Project ResultAnalysisInternalID
PlanningProfile I_Project PlanningProfile
WBSIsMarkedForIntegratedPlng I_Project WBSIsMarkedForIntegratedPlng
IsMarkedForDeletion I_Project IsMarkedForDeletion
InventorySpecialStockValnType I_Project InventorySpecialStockValnType
WBSIsMarkedForAutomReqmtGrpg I_Project WBSIsMarkedForAutomReqmtGrpg
WorkCenterLocation I_Project WorkCenterLocation
FunctionalArea I_Project FunctionalArea
SalesOrganization I_Project SalesOrganization
DistributionChannel I_Project DistributionChannel
Division I_Project Division
DynItemProcessorPrfl I_Project DynItemProcessorPrfl
JointVenture I_Project JointVenture
JointVentureCostRecoveryCode I_Project JointVentureCostRecoveryCode
JointVentureEquityType I_Project JointVentureEquityType
JointVentureObjectType I_Project JointVentureObjectType
JointVentureClass I_Project JointVentureClass
JointVentureSubClass I_Project JointVentureSubClass
WBSSchedulingProfile I_Project WBSSchedulingProfile
PlanningMethForProjBasicDate I_Project PlanningMethForProjBasicDate
PlanningMethForProjFcstdDate I_Project PlanningMethForProjFcstdDate
SchedulingDurationUnit I_Project SchedulingDurationUnit
_BusinessArea I_Project _BusinessArea
_CompanyCode I_Project _CompanyCode
_ControllingArea I_Project _ControllingArea
_ControllingObjectClass I_Project _ControllingObjectClass
_CostCenter I_Project _CostCenter
_Plant I_Project _Plant
_ProjectProfileCode I_Project _ProjectProfileCode
_NetworkProfile I_Project _NetworkProfile
_TaxJurisdiction I_Project _TaxJurisdiction
_ProjInterestCalcProfile I_Project _ProjInterestCalcProfile
_FunctionalArea I_Project _FunctionalArea
_Wbsschedulingprofile I_Project _Wbsschedulingprofile
_ProfitCenter I_Project _ProfitCenter
_ProjBasicDatePlanMethName I_Project _ProjBasicDatePlanMethName
_ProjFcstdDatePlanMethName I_Project _ProjFcstdDatePlanMethName
_ResponsiblePerson I_Project _ResponsiblePerson
_ProjectApplicant I_Project _ProjectApplicant
FreeDefinedTableFieldSemantic FreeDefinedTableFieldSemantic
FreeDefinedAttribute01 FreeDefinedAttribute01
FreeDefinedAttribute02 FreeDefinedAttribute02
FreeDefinedAttribute03 FreeDefinedAttribute03
FreeDefinedAttribute04 FreeDefinedAttribute04
FreeDefinedQuantity1 FreeDefinedQuantity1
FreeDefinedQuantity1Unit FreeDefinedQuantity1Unit
FreeDefinedQuantity2 FreeDefinedQuantity2
FreeDefinedQuantity2Unit FreeDefinedQuantity2Unit
FreeDefinedAmount1 FreeDefinedAmount1
FreeDefinedAmount1Currency FreeDefinedAmount1Currency
FreeDefinedAmount2 FreeDefinedAmount2
FreeDefinedAmount2Currency FreeDefinedAmount2Currency
FreeDefinedDate1 FreeDefinedDate1
FreeDefinedDate2 FreeDefinedDate2
FreeDefinedIndicator1 FreeDefinedIndicator1
FreeDefinedIndicator2 FreeDefinedIndicator2
_ProjectShortText _ProjectShortText
@AbapCatalog.sqlViewName: 'PPROJWITHVERS'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #CHECK

define view P_ProjectWithVersion
  as select from I_ProjectVersion

{
  key I_ProjectVersion.Project,
  key I_ProjectVersion.Version,
      I_ProjectVersion.ProjectWithCodingMask, //Not finalized field - please donot use

      'X' as IsProjectVersionObject,
      I_ProjectVersion.ProjectInternalID,
      I_ProjectVersion.ProjectDescription,
      I_ProjectVersion.ProjectObject,
      I_ProjectVersion.CreatedByUser,
      I_ProjectVersion.CreationDate,
      I_ProjectVersion.LastChangedByUser,
      I_ProjectVersion.LastChangeDate,
      I_ProjectVersion.ResponsiblePerson,
      I_ProjectVersion.ResponsiblePersonName,
      I_ProjectVersion.ApplicantCode,
      I_ProjectVersion.ApplicantName,
      I_ProjectVersion.CompanyCode,
      I_ProjectVersion.BusinessArea,
      I_ProjectVersion.ControllingArea,
      I_ProjectVersion.ProfitCenter,
      I_ProjectVersion.Currency,
      I_ProjectVersion.NetworkAssignmentType,
      I_ProjectVersion.WBSElmntDatesIsDetailed,
      I_ProjectVersion.PlannedStartDate,
      I_ProjectVersion.PlannedEndDate,
      I_ProjectVersion.Plant,
      I_ProjectVersion.FactoryCalendar,
      I_ProjectVersion.NetworkHdrIsVisibleToUser,
      I_ProjectVersion.NetworkProfile,
      I_ProjectVersion.ProjectProfileCode,
      I_ProjectVersion.BudgetProfile,
      I_ProjectVersion.Language,
      I_ProjectVersion.CostCenter,
      I_ProjectVersion.CostObject,
      I_ProjectVersion.BasicDatesLastScheduledDate,
      I_ProjectVersion.FcstdDatesLastScheduledDate,
      I_ProjectVersion.ProjectHasOwnStock,
      I_ProjectVersion.ControllingObjectClass,
      I_ProjectVersion.WBSIsStatisticalWBSElement,
      I_ProjectVersion.TaxJurisdiction,
      I_ProjectVersion.ProjInterestCalcProfile,
      I_ProjectVersion.InvestmentProfile,
      I_ProjectVersion.PaymentPlanProfile,
      I_ProjectVersion.ResultAnalysisInternalID,
      I_ProjectVersion.PlanningProfile,
      I_ProjectVersion.WBSIsMarkedForIntegratedPlng,
      I_ProjectVersion.IsMarkedForDeletion,
      I_ProjectVersion.InventorySpecialStockValnType,
      I_ProjectVersion.WBSIsMarkedForAutomReqmtGrpg,
      I_ProjectVersion.WorkCenterLocation,
      I_ProjectVersion.FunctionalArea,
      I_ProjectVersion.SalesOrganization,
      I_ProjectVersion.DistributionChannel,
      I_ProjectVersion.Division,
      I_ProjectVersion.DynItemProcessorPrfl,
      I_ProjectVersion.JointVenture,
      I_ProjectVersion.JointVentureCostRecoveryCode,
      I_ProjectVersion.JointVentureEquityType,
      I_ProjectVersion.JointVentureObjectType,
      I_ProjectVersion.JointVentureClass,
      I_ProjectVersion.JointVentureSubClass,
      I_ProjectVersion.ForecastedStartDate,
      I_ProjectVersion.ForecastedEndDate,
      I_ProjectVersion.WBSSchedulingProfile,
      I_ProjectVersion.PlanningMethForProjBasicDate,
      I_ProjectVersion.PlanningMethForProjFcstdDate,
      I_ProjectVersion.SchedulingDurationUnit,

      //-->Associations


      I_ProjectVersion._BusinessArea,
      I_ProjectVersion._CompanyCode,
      I_ProjectVersion._ControllingArea,
      I_ProjectVersion._ControllingObjectClass,
      I_ProjectVersion._CostCenter,
      I_ProjectVersion._Plant,
      I_ProjectVersion._ProjectProfileCode,
      //I_ProjectVersion._ProjLangBsdDescription,

      I_ProjectVersion._NetworkProfile,
      I_ProjectVersion._TaxJurisdiction,
      I_ProjectVersion._ProjInterestCalcProfile,
      I_ProjectVersion._FunctionalArea,
      I_ProjectVersion._Wbsschedulingprofile,
      I_ProjectVersion._ProfitCenter,
      I_ProjectVersion._ProjBasicDatePlanMethName,
      I_ProjectVersion._ProjFcstdDatePlanMethName,
      I_ProjectVersion._ResponsiblePerson,
      I_ProjectVersion._ProjectApplicant,
      FreeDefinedTableFieldSemantic,
      FreeDefinedAttribute01,
      FreeDefinedAttribute02,
      FreeDefinedAttribute03,
      FreeDefinedAttribute04,
      FreeDefinedQuantity1,
      FreeDefinedQuantity1Unit,
      FreeDefinedQuantity2,
      FreeDefinedQuantity2Unit,
      FreeDefinedAmount1,
      FreeDefinedAmount1Currency,
      FreeDefinedAmount2,
      FreeDefinedAmount2Currency,
      FreeDefinedDate1,
      FreeDefinedDate2,
      FreeDefinedIndicator1,
      FreeDefinedIndicator2,
      _ProjectShortText
      //<--Associations

}

union all

select from I_Project

{
  key I_Project.Project,
  key '' as Version,
      I_Project.ProjectWithCodingMask, //Not finalized field - please donot use

      '' as IsProjectVersionObject,
      I_Project.ProjectInternalID,
      I_Project.ProjectDescription,
      I_Project.ProjectObject,
      I_Project.CreatedByUser,
      I_Project.CreationDate,
      I_Project.LastChangedByUser,
      I_Project.LastChangeDate,
      I_Project.ResponsiblePerson,
      I_Project.ResponsiblePersonName,
      I_Project.ApplicantCode,
      I_Project.ApplicantName,
      I_Project.CompanyCode,
      I_Project.BusinessArea,
      I_Project.ControllingArea,
      I_Project.ProfitCenter,
      I_Project.Currency,
      I_Project.NetworkAssignmentType,
      I_Project.WBSElmntDatesIsDetailed,
      I_Project.PlannedStartDate,
      I_Project.PlannedEndDate,
      I_Project.Plant,
      I_Project.FactoryCalendar,
      I_Project.NetworkHdrIsVisibleToUser,
      I_Project.NetworkProfile,
      I_Project.ProjectProfileCode,
      I_Project.BudgetProfile,
      I_Project.Language,
      I_Project.CostCenter,
      I_Project.CostObject,
      I_Project.BasicDatesLastScheduledDate,
      I_Project.FcstdDatesLastScheduledDate,
      I_Project.ProjectHasOwnStock,
      I_Project.ControllingObjectClass,
      I_Project.WBSIsStatisticalWBSElement,
      I_Project.TaxJurisdiction,
      I_Project.ProjInterestCalcProfile,
      I_Project.InvestmentProfile,
      I_Project.PaymentPlanProfile,
      I_Project.ResultAnalysisInternalID,
      I_Project.PlanningProfile,
      I_Project.WBSIsMarkedForIntegratedPlng,
      I_Project.IsMarkedForDeletion,
      I_Project.InventorySpecialStockValnType,
      I_Project.WBSIsMarkedForAutomReqmtGrpg,
      I_Project.WorkCenterLocation,
      I_Project.FunctionalArea,
      I_Project.SalesOrganization,
      I_Project.DistributionChannel,
      I_Project.Division,
      I_Project.DynItemProcessorPrfl,
      I_Project.JointVenture,
      I_Project.JointVentureCostRecoveryCode,
      I_Project.JointVentureEquityType,
      I_Project.JointVentureObjectType,
      I_Project.JointVentureClass,
      I_Project.JointVentureSubClass,
      I_Project.ForecastedStartDate,
      I_Project.ForecastedEndDate,
      I_Project.WBSSchedulingProfile,
      I_Project.PlanningMethForProjBasicDate,
      I_Project.PlanningMethForProjFcstdDate,
      I_Project.SchedulingDurationUnit,

      //-->Associations


      I_Project._BusinessArea,
      I_Project._CompanyCode,
      I_Project._ControllingArea,
      I_Project._ControllingObjectClass,
      I_Project._CostCenter,
      I_Project._Plant,
      I_Project._ProjectProfileCode,
      //I_Project._ProjLangBsdDescription,

      I_Project._NetworkProfile,
      I_Project._TaxJurisdiction,
      I_Project._ProjInterestCalcProfile,
      I_Project._FunctionalArea,
      I_Project._Wbsschedulingprofile,
      I_Project._ProfitCenter,
      I_Project._ProjBasicDatePlanMethName,
      I_Project._ProjFcstdDatePlanMethName,
      I_Project._ResponsiblePerson,
      I_Project._ProjectApplicant,
      FreeDefinedTableFieldSemantic,
      FreeDefinedAttribute01,
      FreeDefinedAttribute02,
      FreeDefinedAttribute03,
      FreeDefinedAttribute04,
      FreeDefinedQuantity1,
      FreeDefinedQuantity1Unit,
      FreeDefinedQuantity2,
      FreeDefinedQuantity2Unit,
      FreeDefinedAmount1,
      FreeDefinedAmount1Currency,
      FreeDefinedAmount2,
      FreeDefinedAmount2Currency,
      FreeDefinedDate1,
      FreeDefinedDate2,
      FreeDefinedIndicator1,
      FreeDefinedIndicator2,
      _ProjectShortText
      //<--Associations

} 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECT",
"I_PROJECTVERSION"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_CONTROLLINGOBJECTCLASS",
"I_COSTCENTER",
"I_FUNCTIONALAREA",
"I_INTERESTCALCULATIONPROFILE",
"I_NETWORKPROFILE",
"I_PLANNINGMETHOD",
"I_PLANT",
"I_PROFITCENTER",
"I_PROJECTAPPLICANT",
"I_PROJECTOBJECTSHORTTEXT",
"I_PROJECTPROFILECODE",
"I_PROJECTRESPONSIBLEPERSON",
"I_TAXJURISDICTION",
"I_WBSSCHEDULINGPROFILE"
],
"BASE":
[
"I_PROJECTVERSION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/