P_OrglChgNtwkActyUploadPreview

DDL: P_ORGLCHGNTWKACTYUPLOADPREVIEW Type: view_entity COMPOSITE Package: ODATA_ORGL_CHANGE_IMPORT
24 Fields 1 Data Sources

Uploaded Network Activities

P_OrglChgNtwkActyUploadPreview is a Composite CDS View that provides data about "Uploaded Network Activities" in SAP S/4HANA. It reads from 1 data source (I_OrglChgNtwkActyUploadPreview) and exposes 24 fields with key fields OrganizationalChange, UploadedByUser, FileLineNumber, OrganizationalChangeUUID. Part of development package ODATA_ORGL_CHANGE_IMPORT.

Data Sources (1)

SourceAliasJoin Type
I_OrglChgNtwkActyUploadPreview _impNtwkActy from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChange I_OrglChgNtwkActyUploadPreview OrganizationalChange Organizational Change
KEY UploadedByUser I_OrglChgNtwkActyUploadPreview UploadedByUser Uploaded By
KEY FileLineNumber I_OrglChgNtwkActyUploadPreview FileLineNumber Row No. in File
KEY OrganizationalChangeUUID I_OrglChgNtwkActyUploadPreview OrganizationalChangeUUID UUID
OrganizationalChangeForEdit _OrglChangeDraft OrganizationalChangeForEdit Organizational Change
ProjectNetwork I_OrglChgNtwkActyUploadPreview ProjectNetwork Order
NetworkActivity I_OrglChgNtwkActyUploadPreview NetworkActivity Operation/Activity
ControllingArea I_OrglChgNtwkActyUploadPreview ControllingArea Controlling Area
ProfitCenter I_OrglChgNtwkActyUploadPreview ProfitCenter Profit Center
ProfitCenterByOrglChange I_OrglChgNtwkActyUploadPreview ProfitCenterByOrglChange New Profit Center
OrglChangeMessageType I_OrglChgNtwkActyUploadPreview OrglChangeMessageType Message Type
SystemMessageClass I_OrglChgNtwkActyUploadPreview SystemMessageClass Message ID
SystemMessageNumber I_OrglChgNtwkActyUploadPreview SystemMessageNumber Message Number
SystemMessageVariable1 I_OrglChgNtwkActyUploadPreview SystemMessageVariable1 Variable 1
SystemMessageVariable2 I_OrglChgNtwkActyUploadPreview SystemMessageVariable2 Variable 2
SystemMessageVariable3 I_OrglChgNtwkActyUploadPreview SystemMessageVariable3 Variable 3
SystemMessageVariable4 I_OrglChgNtwkActyUploadPreview SystemMessageVariable4 Variable 4
_ProfitCenterBfrOrglChangeText I_OrglChgNtwkActyUploadPreview _ProfitCenterBfrOrglChangeText
_ProfitCenterByOrglChangeText I_OrglChgNtwkActyUploadPreview _ProfitCenterByOrglChangeText
_OrglChangeMessageTypeText I_OrglChgNtwkActyUploadPreview _OrglChangeMessageTypeText
_ControllingArea I_OrglChgNtwkActyUploadPreview _ControllingArea
_ProjectNetwork I_OrglChgNtwkActyUploadPreview _ProjectNetwork
_NetworkActivity I_OrglChgNtwkActyUploadPreview _NetworkActivity
_OrganizationalChange I_OrglChgNtwkActyUploadPreview _OrganizationalChange

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 P_OrglChgNtwkActyUploadPreview.
-- 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 P_OrglChgNtwkActyUploadPreview AS
SELECT
  _impNtwkActy.OrganizationalChange AS OrganizationalChange,
  _impNtwkActy.UploadedByUser AS UploadedByUser,
  _impNtwkActy.FileLineNumber AS FileLineNumber,
  _impNtwkActy.OrganizationalChangeUUID AS OrganizationalChangeUUID,
  _OrglChangeDraft.OrganizationalChangeForEdit AS OrganizationalChangeForEdit,
  _impNtwkActy.ProjectNetwork AS ProjectNetwork,
  _impNtwkActy.NetworkActivity AS NetworkActivity,
  _impNtwkActy.ControllingArea AS ControllingArea,
  _impNtwkActy.ProfitCenter AS ProfitCenter,
  _impNtwkActy.ProfitCenterByOrglChange AS ProfitCenterByOrglChange,
  _impNtwkActy.OrglChangeMessageType AS OrglChangeMessageType,
  _impNtwkActy.SystemMessageClass AS SystemMessageClass,
  _impNtwkActy.SystemMessageNumber AS SystemMessageNumber,
  _impNtwkActy.SystemMessageVariable1 AS SystemMessageVariable1,
  _impNtwkActy.SystemMessageVariable2 AS SystemMessageVariable2,
  _impNtwkActy.SystemMessageVariable3 AS SystemMessageVariable3,
  _impNtwkActy.SystemMessageVariable4 AS SystemMessageVariable4,
  _impNtwkActy._ProfitCenterBfrOrglChangeText AS _ProfitCenterBfrOrglChangeText,
  _impNtwkActy._ProfitCenterByOrglChangeText AS _ProfitCenterByOrglChangeText,
  _impNtwkActy._OrglChangeMessageTypeText AS _OrglChangeMessageTypeText,
  _impNtwkActy._ControllingArea AS _ControllingArea,
  _impNtwkActy._ProjectNetwork AS _ProjectNetwork,
  _impNtwkActy._NetworkActivity AS _NetworkActivity,
  _impNtwkActy._OrganizationalChange AS _OrganizationalChange
FROM I_OrglChgNtwkActyUploadPreview AS _impNtwkActy
;

Learn More