P_OrglChgProjectUploadPreview

DDL: P_ORGLCHGPROJECTUPLOADPREVIEW Type: view_entity COMPOSITE
23 Fields 1 Data Sources

P_OrglChgProjectUploadPreview is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_OrglChgProjectUploadPreview) and exposes 23 fields with key fields OrganizationalChange, UploadedByUser, FileLineNumber, OrganizationalChangeUUID.

Data Sources (1)

SourceAliasJoin Type
I_OrglChgProjectUploadPreview _impOrder from

Annotations (3)

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

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChange I_OrglChgProjectUploadPreview OrganizationalChange Organizational Change
KEY UploadedByUser I_OrglChgProjectUploadPreview UploadedByUser Uploaded By
KEY FileLineNumber I_OrglChgProjectUploadPreview FileLineNumber Row No. in File
KEY OrganizationalChangeUUID I_OrglChgProjectUploadPreview OrganizationalChangeUUID UUID
OrganizationalChangeForEdit _OrglChangeDraft OrganizationalChangeForEdit Organizational Change
ProjectInternalID I_OrglChgProjectUploadPreview ProjectInternalID Project Def.
ProjectExternalID I_OrglChgProjectUploadPreview ProjectExternalID Project def.
ControllingArea I_OrglChgProjectUploadPreview ControllingArea Controlling Area
ProfitCenter I_OrglChgProjectUploadPreview ProfitCenter Profit Center
ProfitCenterByOrglChange I_OrglChgProjectUploadPreview ProfitCenterByOrglChange New Profit Center
OrglChangeMessageType I_OrglChgProjectUploadPreview OrglChangeMessageType Message Type
SystemMessageClass I_OrglChgProjectUploadPreview SystemMessageClass Message ID
SystemMessageNumber I_OrglChgProjectUploadPreview SystemMessageNumber Message Number
SystemMessageVariable1 I_OrglChgProjectUploadPreview SystemMessageVariable1 Variable 1
SystemMessageVariable2 I_OrglChgProjectUploadPreview SystemMessageVariable2 Variable 2
SystemMessageVariable3 I_OrglChgProjectUploadPreview SystemMessageVariable3 Variable 3
SystemMessageVariable4 I_OrglChgProjectUploadPreview SystemMessageVariable4 Variable 4
_ProjectBasicData I_OrglChgProjectUploadPreview _ProjectBasicData
_ProfitCenterBfrOrglChangeText I_OrglChgProjectUploadPreview _ProfitCenterBfrOrglChangeText
_ProfitCenterByOrglChangeText I_OrglChgProjectUploadPreview _ProfitCenterByOrglChangeText
_OrglChangeMessageTypeText I_OrglChgProjectUploadPreview _OrglChangeMessageTypeText
_ControllingArea I_OrglChgProjectUploadPreview _ControllingArea
_OrganizationalChange I_OrglChgProjectUploadPreview _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_OrglChgProjectUploadPreview.
-- 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_OrglChgProjectUploadPreview AS
SELECT
  _impOrder.OrganizationalChange AS OrganizationalChange,
  _impOrder.UploadedByUser AS UploadedByUser,
  _impOrder.FileLineNumber AS FileLineNumber,
  _impOrder.OrganizationalChangeUUID AS OrganizationalChangeUUID,
  _OrglChangeDraft.OrganizationalChangeForEdit AS OrganizationalChangeForEdit,
  _impOrder.ProjectInternalID AS ProjectInternalID,
  _impOrder.ProjectExternalID AS ProjectExternalID,
  _impOrder.ControllingArea AS ControllingArea,
  _impOrder.ProfitCenter AS ProfitCenter,
  _impOrder.ProfitCenterByOrglChange AS ProfitCenterByOrglChange,
  _impOrder.OrglChangeMessageType AS OrglChangeMessageType,
  _impOrder.SystemMessageClass AS SystemMessageClass,
  _impOrder.SystemMessageNumber AS SystemMessageNumber,
  _impOrder.SystemMessageVariable1 AS SystemMessageVariable1,
  _impOrder.SystemMessageVariable2 AS SystemMessageVariable2,
  _impOrder.SystemMessageVariable3 AS SystemMessageVariable3,
  _impOrder.SystemMessageVariable4 AS SystemMessageVariable4,
  _impOrder._ProjectBasicData AS _ProjectBasicData,
  _impOrder._ProfitCenterBfrOrglChangeText AS _ProfitCenterBfrOrglChangeText,
  _impOrder._ProfitCenterByOrglChangeText AS _ProfitCenterByOrglChangeText,
  _impOrder._OrglChangeMessageTypeText AS _OrglChangeMessageTypeText,
  _impOrder._ControllingArea AS _ControllingArea,
  _impOrder._OrganizationalChange AS _OrganizationalChange
FROM I_OrglChgProjectUploadPreview AS _impOrder
;

Learn More