I_ProjNetworkChangeDocument

DDL: I_PROJNETWORKCHANGEDOCUMENT Type: view_entity BASIC
31 Fields 3 Data Sources 2 Associations

Change Document for Network data

I_ProjNetworkChangeDocument is a Basic CDS View that provides data about "Change Document for Network data" in SAP S/4HANA. It reads from 3 data sources (I_ProjectNetworkBasicData, I_ChangeDocument, I_ChangeDocumentItem) and exposes 31 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocTableKey. It has 2 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_ProjectNetworkBasicData aufk from
I_ChangeDocument cdhdr inner
I_ChangeDocumentItem cdpos inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ProjectData_2 _ProjectData $projection.ProjectInternalID = _ProjectData.ProjectInternalID
[0..1] I_WBSElementData_2 _WBSElementData $projection.WBSElementInternalID = _WBSElementData.WBSElementInternalID

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Change Document for Network data view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.compositionRoot true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name ProjectNetwork view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject I_ChangeDocument ChangeDocObject Object Value
KEY ChangeDocObjectClass I_ChangeDocument ChangeDocObjectClass Change Doc. Object
KEY ChangeDocument I_ChangeDocumentItem ChangeDocument Document Number
KEY DatabaseTable I_ChangeDocumentItem DatabaseTable Table Name
KEY ChangeDocTableKey I_ChangeDocumentItem ChangeDocTableKey Table Keys
KEY ChangeDocDatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField User
KEY ChangeDocItemChangeType I_ChangeDocumentItem ChangeDocItemChangeType Change Indicator
KEY ProjectNetworkInternalID I_ProjectNetworkBasicData ProjectNetworkInternalID Plan No.f.Oper.
ProjectNetwork I_ProjectNetworkBasicData ProjectNetwork Order
ChangeDocGlobalFieldName FieldmapProj GFNName
ProjectNetworkDescription I_ProjectNetworkBasicData ProjectNetworkDescription Network Name
ChangeDocPreviousUnit I_ChangeDocumentItem ChangeDocPreviousUnit
ChangeDocNewUnit I_ChangeDocumentItem ChangeDocNewUnit
ChangeDocPreviousCurrency I_ChangeDocumentItem ChangeDocPreviousCurrency
ChangeDocNewCurrency I_ChangeDocumentItem ChangeDocNewCurrency
ChangeDocumentOldFieldValue I_ChangeDocumentItem ChangeDocPreviousFieldValue Old Value
ChangeDocumentNewFieldValue I_ChangeDocumentItem ChangeDocNewFieldValue New Value
LastChangedByUser I_ChangeDocument CreatedByUser User Name
LastChangeDate I_ChangeDocument CreationDate Time Stamp
LastChangeTime I_ChangeDocument CreationTime Time of Change
WBSElementInternalID I_ProjectNetworkBasicData WBSElementInternalID WBS Internal ID
ProjectInternalID I_ProjectNetworkBasicData ProjectInternalID Project Def.
ControllingArea I_ProjectNetworkBasicData ControllingArea Controlling Area
ProfitCenter I_ProjectNetworkBasicData ProfitCenter Profit Center
Plant I_ProjectNetworkBasicData Plant Valuation Area
MRPController I_ProjectNetworkBasicData MRPController MRP Controller
_ControllingArea I_ProjectNetworkBasicData _ControllingArea
_ProfitCenter I_ProjectNetworkBasicData _ProfitCenter
_Currency _Currency
_ProjectData _ProjectData
_WBSElementData _WBSElementData

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ProjNetworkChangeDocument.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ProjNetworkChangeDocument AS
SELECT
  cdhdr.ChangeDocObject AS ChangeDocObject,
  cdhdr.ChangeDocObjectClass AS ChangeDocObjectClass,
  cdpos.ChangeDocument AS ChangeDocument,
  cdpos.DatabaseTable AS DatabaseTable,
  cdpos.ChangeDocTableKey AS ChangeDocTableKey,
  cdpos.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  cdpos.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  aufk.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  aufk.ProjectNetwork AS ProjectNetwork,
  FieldmapProj.GFNName AS ChangeDocGlobalFieldName,
  aufk.ProjectNetworkDescription AS ProjectNetworkDescription,
  cdpos.ChangeDocPreviousUnit AS ChangeDocPreviousUnit,
  cdpos.ChangeDocNewUnit AS ChangeDocNewUnit,
  cdpos.ChangeDocPreviousCurrency AS ChangeDocPreviousCurrency,
  cdpos.ChangeDocNewCurrency AS ChangeDocNewCurrency,
  cdpos.ChangeDocPreviousFieldValue AS ChangeDocumentOldFieldValue,
  cdpos.ChangeDocNewFieldValue AS ChangeDocumentNewFieldValue,
  cdhdr.CreatedByUser AS LastChangedByUser,
  cdhdr.CreationDate AS LastChangeDate,
  cdhdr.CreationTime AS LastChangeTime,
  aufk.WBSElementInternalID AS WBSElementInternalID,
  aufk.ProjectInternalID AS ProjectInternalID,
  aufk.ControllingArea AS ControllingArea,
  aufk.ProfitCenter AS ProfitCenter,
  aufk.Plant AS Plant,
  aufk.MRPController AS MRPController,
  aufk._ControllingArea AS _ControllingArea,
  aufk._ProfitCenter AS _ProfitCenter
FROM I_ProjectNetworkBasicData AS aufk
INNER JOIN I_ChangeDocument AS cdhdr ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChangeDocumentItem AS cdpos ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProjectData_2 AS _ProjectData ON ProjectInternalID = _ProjectData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementData_2 AS _WBSElementData ON WBSElementInternalID = _WBSElementData.WBSElementInternalID  -- association [0..1]
;

Learn More