I_PROJECTNETWORKVERSION
Project Network with Version
I_PROJECTNETWORKVERSION is a CDS View in S/4HANA. Project Network with Version. It contains 89 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ProjectNetworkVersionVH | view | from | COMPOSITE | Project Network with Version Value Help |
| P_ProjNetworkWithVersion | view | from | COMPOSITE |
Fields (89)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ProjectNetwork | ProjectNetwork | 2 |
| KEY | Version | Version | 2 |
| _BusinessArea | _BusinessArea | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _ControllingObjectClass | _ControllingObjectClass | 1 | |
| _CostCenter | _CostCenter | 1 | |
| _Currency | _Currency | 1 | |
| _FunctionalArea | _FunctionalArea | 1 | |
| _MRPController | _MRPController | 1 | |
| _NetworkProfile | _NetworkProfile | 1 | |
| _OrderCategory | _OrderCategory | 1 | |
| _OrderType | _OrderType | 1 | |
| _Plant | _Plant | 1 | |
| _Prioritycode | _Prioritycode | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _ResponsiblePlannerGroup | _ResponsiblePlannerGroup | 1 | |
| _SalesOrder | _SalesOrder | 1 | |
| _SalesOrderItem | _SalesOrderItem | 1 | |
| _TaxJurisdiction | _TaxJurisdiction | 1 | |
| ActualCostsCostingVariant | ActualCostsCostingVariant | 1 | |
| ActualEndDate | ActualEndDate | 1 | |
| ActualReleasedDate | ActualReleasedDate | 1 | |
| ActualStartDate | ActualStartDate | 1 | |
| BaseUnit | BaseUnit | 1 | |
| BasicSchedulingType | BasicSchedulingType | 1 | |
| BusinessArea | BusinessArea | 1 | |
| CapacityRequirement | CapacityRequirement | 1 | |
| ChangeNumber | ChangeNumber | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ConfirmedEndDate | ConfirmedEndDate | 1 | |
| ControllingArea | ControllingArea | 1 | |
| ControllingObjectClass | ControllingObjectClass | 1 | |
| CostCenter | CostCenter | 1 | |
| CostElement | CostElement | 1 | |
| CostingSheet | CostingSheet | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| CreationTime | CreationTime | 1 | |
| Currency | Currency | 1 | |
| ForecastedEndDate | ForecastedEndDate | 1 | |
| ForecastedStartDate | ForecastedStartDate | 1 | |
| ForecastSchedulingType | ForecastSchedulingType | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| IsMarkedForDeletion | IsMarkedForDeletion | 1 | |
| JointVenture | JointVenture | 1 | |
| JointVentureClass | JointVentureClass | 1 | |
| JointVentureObjectType | JointVentureObjectType | 1 | |
| JointVentureOriginalCostObject | JointVentureOriginalCostObject | 1 | |
| JointVentureSubClass | JointVentureSubClass | 1 | |
| LastChangeDate | LastChangeDate | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| LastChangeTime | LastChangeTime | 1 | |
| LastScheduledDate | LastScheduledDate | 1 | |
| MRPController | MRPController | 1 | |
| NetworkActivityConfirmation | NetworkActivityConfirmation | 1 | |
| NetworkIsAccountAssigned | NetworkIsAccountAssigned | 1 | |
| NetworkProfile | NetworkProfile | 1 | |
| OrderCategory | OrderCategory | 1 | |
| OrderID | OrderID | 1 | |
| OrderIsNotCostedAutomatically | OrderIsNotCostedAutomatically | 1 | |
| OrderType | ProjectNetworkType | 1 | |
| OrdIsNotSchedldAutomatically | OrdIsNotSchedldAutomatically | 1 | |
| OverheadCode | OverheadCode | 1 | |
| PlannedCostsCostingVariant | PlannedCostsCostingVariant | 1 | |
| PlannedEndDate | PlannedEndDate | 1 | |
| PlannedStartDate | PlannedStartDate | 1 | |
| Plant | Plant | 1 | |
| PriorityCode | PriorityCode | 1 | |
| ProductConfiguration | ProductConfiguration | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProjectInternalID | ProjectInternalID | 1 | |
| ProjectNetworkDescription | ProjectNetworkDescription | 2 | |
| ProjectNetworkInternalID | ProjectNetworkInternalID | 1 | |
| ProjectNetworkObject | ProjectNetworkObject | 1 | |
| ProjNtwkInterestCalcProfile | ProjNtwkInterestCalcProfile | 1 | |
| Reservation | Reservation | 1 | |
| ResponsiblePlannerGroup | ResponsiblePlannerGroup | 1 | |
| SalesOrder | SalesOrder | 1 | |
| SalesOrderItem | SalesOrderItem | 1 | |
| ScheduledBasicEndDate | ScheduledBasicEndDate | 1 | |
| ScheduledBasicStartDate | ScheduledBasicStartDate | 1 | |
| ScheduledFcstdReleaseDate | ScheduledFcstdReleaseDate | 1 | |
| ScheduledForecastedEndDate | ScheduledForecastedEndDate | 1 | |
| ScheduledForecastedStartDate | ScheduledForecastedStartDate | 1 | |
| ScheduledReleaseDate | ScheduledReleaseDate | 1 | |
| SuperiorProjectNetwork | SuperiorProjectNetwork | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| WBSElementInternalID | WBSElementInternalID | 1 |
@AbapCatalog.sqlViewName: 'IPROJNTWKVERS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_MRPController'] //, '_Extension']
@VDM.viewType: #BASIC
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Project Network with Version'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view I_ProjectNetworkVersion
as select from vsaufk_cn as OrderMasterData
left outer join vsafko_cn as OrderHeaderData on OrderHeaderData.aufnr = OrderMasterData.aufnr
and OrderHeaderData.vsnmr = OrderMasterData.vsnmr
// left outer join cnldst_shorttx on OrderMasterData.objnr = cnldst_shorttx.objnr
// and cnldst_shorttx.language = $session.system_language
//left outer join stxl on OrderMasterData.objnr = stxl.tdname and stxl.tdspras = $session.system_language
association [0..1] to I_ProjectVersion as _Project on $projection.ProjectInternalID = _Project.ProjectInternalID
and $projection.Version = _Project.Version
association [0..1] to I_WBSElementVersion as _WBSElement on $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
and $projection.Version = _WBSElement.Version
association [0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [0..*] to I_ProfitCenter as _ProfitCenter on $projection.ControllingArea = _ProfitCenter.ControllingArea
and $projection.ProfitCenter = _ProfitCenter.ProfitCenter
association [0..*] to I_CostCenter as _CostCenter on $projection.ControllingArea = _CostCenter.ControllingArea
and $projection.CostCenter = _CostCenter.CostCenter
association [1..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association [0..1] to I_SalesOrder as _SalesOrder on $projection.SalesOrder = _SalesOrder.SalesOrder
association [0..1] to I_SalesOrderItem as _SalesOrderItem on $projection.SalesOrder = _SalesOrderItem.SalesOrder
and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem
association [0..1] to I_MRPController as _MRPController on $projection.Plant = _MRPController.Plant
and $projection.MRPController = _MRPController.MRPController
association [0..1] to I_UnitOfMeasure as _BaseUnit on $projection.BaseUnit = _BaseUnit.UnitOfMeasure
association [0..1] to I_Currency as _Currency on $projection.Currency = _Currency.Currency
//association [0..*] to I_ProjectNetworkDescText as _ProjectNetworkLangDescription on $projection.ProjectNetworkObject = _ProjectNetworkLangDescription.ProjectNetworkObject
association [0..1] to I_OrderCategory as _OrderCategory on $projection.OrderCategory = _OrderCategory.OrderCategory
association [0..*] to I_NetworkProfile as _NetworkProfile on $projection.NetworkProfile = _NetworkProfile.NetworkProfile
association [0..1] to I_ResponsiblePlannerGroup as _ResponsiblePlannerGroup on $projection.ResponsiblePlannerGroup = _ResponsiblePlannerGroup.ResponsiblePlannerGroup
and $projection.Plant = _ResponsiblePlannerGroup.Plant
association [0..1] to I_FunctionalArea as _FunctionalArea on $projection.FunctionalArea = _FunctionalArea.FunctionalArea
association [0..1] to I_Prioritycode as _Prioritycode on $projection.PriorityCode = _Prioritycode.PriorityCode
// association [0..1] to I_InternalOrder as _InternalOrder on $projection.OrderID = _InternalOrder.InternalOrder
association [0..1] to I_ControllingObjectClass as _ControllingObjectClass on $projection.ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass
association [0..*] to I_TaxJurisdiction as _TaxJurisdiction on $projection.TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction
association [1..1] to I_WBSElement as _WBSElementText on $projection.WBSElementInternalID = _WBSElementText.WBSElementInternalID
association [0..1] to I_OrderType as _OrderType on $projection.OrderType = _OrderType.OrderType
association [1..1] to E_ProjectNetworkVersion as _Extension on OrderMasterData.aufnr = _Extension.Version
and OrderMasterData.vsnmr = _Extension.ProjectNetwork
// Multilanguage Short text
association [0..1] to I_ProjectObjectShortText as _NetworkShortText on _NetworkShortText.Language = $session.system_language
and _NetworkShortText.ProjectApplicationIdentifier = 'PS'
and _NetworkShortText.ProjectObjectType = 'NP'
and $projection.ProjectNetworkObject = _NetworkShortText.ProjectObjectNode
{
// @ObjectModel.text.association: '_ProjectNetworkLangDescription'
//key cast(OrderMasterData.aufnr as ps_s4_aufnr) as ProjectNetwork,
key cast ((case when OrderMasterData.aufnr like '?!%' then OrderMasterData.ext_aufnr else OrderMasterData.aufnr end) as ps_s4_aufnr) as ProjectNetwork,
key OrderMasterData.vsnmr as Version,
cast(OrderMasterData.ktext as ps_s4_auftext) as ProjectNetworkDescription,
// cnldst_shorttx.shorttext as ProjectNetworkLangDescription,
// @ObjectModel.foreignKey.association: '_Project'
cast ( OrderHeaderData.pronr as ps_s4_proj_pspnr preserving type ) as ProjectInternalID,
// @ObjectModel.foreignKey.association: '_WBSElement'
cast ( OrderMasterData.pspel as ps_s4_pspnr preserving type ) as WBSElementInternalID,
OrderHeaderData.aufpl as ProjectNetworkInternalID,
@ObjectModel.foreignKey.association: '_BusinessArea'
OrderMasterData.gsber as BusinessArea,
@ObjectModel.foreignKey.association: '_CompanyCode'
OrderMasterData.bukrs as CompanyCode,
@ObjectModel.foreignKey.association: '_ControllingArea'
OrderMasterData.kokrs as ControllingArea,
@ObjectModel.foreignKey.association: '_ProfitCenter'
OrderMasterData.prctr as ProfitCenter,
@ObjectModel.foreignKey.association: '_CostCenter'
OrderMasterData.kostl as CostCenter,
@ObjectModel.foreignKey.association: '_Plant'
OrderMasterData.werks as Plant,
@ObjectModel.foreignKey.association: '_SalesOrder'
OrderMasterData.kdauf as SalesOrder,
@ObjectModel.foreignKey.association: '_SalesOrderItem'
OrderMasterData.kdpos as SalesOrderItem,
@ObjectModel.foreignKey.association: '_MRPController'
OrderHeaderData.dispo as MRPController,
// Needs to add the planner group text association [No view found]
cast(OrderHeaderData.plgrp as cp_s_vagrp) as ResponsiblePlannerGroup,
//OrderHeaderData.aennr as EngineeringChangeOrder,
OrderHeaderData.aennr as ChangeNumber,
OrderHeaderData.aprio as PriorityCode,
OrderHeaderData.aufnt as SuperiorProjectNetwork,
OrderHeaderData.cuobj as ProductConfiguration,
// Dates and Times
OrderHeaderData.trmdt as LastScheduledDate,
@Semantics.calendarItem.dtEnd: true
OrderHeaderData.getri as ConfirmedEndDate,
OrderHeaderData.ftrms as ScheduledReleaseDate,
cast( OrderHeaderData.ftrmi as fis_co_ftrmi ) as ActualReleasedDate,
@Semantics.calendarItem.dtStart: true
cast( OrderHeaderData.gstri as cgpl_actualstartdate ) as ActualStartDate,
@Semantics.calendarItem.dtEnd: true
cast (OrderHeaderData.gltri as pshlp_actual_finish_de ) as ActualEndDate,
@Semantics.calendarItem.dtStart: true
OrderHeaderData.gstrp as PlannedStartDate,
@Semantics.calendarItem.dtEnd: true
OrderHeaderData.gltrp as PlannedEndDate,
@Semantics.calendarItem.dtStart: true
OrderHeaderData.gstpp as ForecastedStartDate,
@Semantics.calendarItem.dtEnd: true
OrderHeaderData.gltpp as ForecastedEndDate,
@Semantics.calendarItem.dtStart: true
OrderHeaderData.gstps as ScheduledForecastedStartDate,
@Semantics.calendarItem.dtEnd: true
OrderHeaderData.gltps as ScheduledForecastedEndDate,
OrderHeaderData.ftrps as ScheduledFcstdReleaseDate,
@Semantics.calendarItem.dtStart: true
OrderHeaderData.gstrs as ScheduledBasicStartDate,
@Semantics.calendarItem.dtEnd: true
OrderHeaderData.gltrs as ScheduledBasicEndDate,
OrderHeaderData.rsnum as Reservation,
@Semantics.businessDate.createdAt: true
OrderMasterData.erdat as CreationDate,
OrderMasterData.erfzeit as CreationTime,
@Semantics.user.createdBy: true
cast(OrderMasterData.ernam as crcreatus) as CreatedByUser,
@Semantics.businessDate.lastChangedAt: true
cast(OrderMasterData.aedat as iw_mo_date) as LastChangeDate,
OrderMasterData.aezeit as LastChangeTime,
@Semantics.user.lastChangedBy: true
cast(OrderMasterData.aenam as cvdichuser) as LastChangedByUser,
cast(OrderMasterData.auart as ps_s4_aufart) as OrderType,
OrderMasterData.autyp as OrderCategory,
OrderMasterData.jv_oco as JointVentureOriginalCostObject,
OrderMasterData.otype as JointVentureObjectType,
OrderMasterData.vname as JointVenture,
OrderMasterData.jv_jibcl as JointVentureClass,
OrderMasterData.jv_jibsa as JointVentureSubClass,
cast(OrderMasterData.txjcd as wb2_txjcd_busvol) as TaxJurisdiction,
OrderMasterData.kalsm as CostingSheet,
OrderMasterData.kstar as CostElement,
OrderMasterData.objnr as ProjectNetworkObject,
@ObjectModel.foreignKey.association: '_Currency'
OrderMasterData.waers as Currency,
OrderMasterData.zschl as OverheadCode,
OrderMasterData.zschm as ProjNtwkInterestCalcProfile,
OrderHeaderData.rueck as NetworkActivityConfirmation,
OrderMasterData.loekz as IsMarkedForDeletion,
OrderHeaderData.klvari as ActualCostsCostingVariant,
OrderHeaderData.klvarp as PlannedCostsCostingVariant,
OrderHeaderData.trkzp as ForecastSchedulingType,
OrderHeaderData.terkz as BasicSchedulingType,
@Semantics.unitOfMeasure: true
OrderHeaderData.gmein as BaseUnit,
//new addition. ,
// OrderHeaderData.aucost as OrderIsCostedAutomatically ,
// OrderHeaderData.auterm as OrderIsShedldAutomatically ,
OrderMasterData.func_area as FunctionalArea,
cast( OrderHeaderData.bedid as ps_s4_bedid) as CapacityRequirement,
OrderHeaderData.profid as NetworkProfile,
OrderMasterData.aufnr as OrderID,
cast ( OrderMasterData.scope as ps_s4_scope_cv ) as ControllingObjectClass,
/* Calculated Fields */
case when OrderHeaderData.aucost = 'X' then
' '
else
'X'
end as OrderIsNotCostedAutomatically,
case when OrderHeaderData.auterm = 'X' then
' '
else
'X'
end as OrdIsNotSchedldAutomatically,
case when OrderHeaderData.netzkont = '1' then
'X'
else
' '
end as NetworkIsAccountAssigned,
/* Associations */
_Project,
_WBSElement,
_BusinessArea,
_CompanyCode,
_ControllingArea,
_ProfitCenter,
_CostCenter,
_Plant,
_SalesOrder,
_SalesOrderItem,
_MRPController,
_BaseUnit,
_Currency,
// _ProjectNetworkLangDescription,
_OrderCategory,
_NetworkProfile,
_ResponsiblePlannerGroup,
_Prioritycode,
_FunctionalArea,
_TaxJurisdiction,
_WBSElementText,
// _InternalOrder,
_ControllingObjectClass,
_OrderType,
_NetworkShortText
}
where
OrderMasterData.autyp = '20'