P_OrglChgWBSElmntUploadPreview

DDL: P_ORGLCHGWBSELMNTUPLOADPREVIEW Type: view_entity COMPOSITE Package: ODATA_ORGL_CHANGE_IMPORT
23 Fields 1 Data Sources

Uploaded WBS Elements

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

Data Sources (1)

SourceAliasJoin Type
I_OrglChgWBSElmntUploadPreview _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_OrglChgWBSElmntUploadPreview OrganizationalChange Organizational Change
KEY UploadedByUser I_OrglChgWBSElmntUploadPreview UploadedByUser Uploaded By
KEY FileLineNumber I_OrglChgWBSElmntUploadPreview FileLineNumber Row No. in File
KEY OrganizationalChangeUUID I_OrglChgWBSElmntUploadPreview OrganizationalChangeUUID UUID
OrganizationalChangeForEdit _OrglChangeDraft OrganizationalChangeForEdit Organizational Change
WBSElementInternalID I_OrglChgWBSElmntUploadPreview WBSElementInternalID WBS Internal ID
WBSElementExternalID I_OrglChgWBSElmntUploadPreview WBSElementExternalID WBS Element External ID
ControllingArea I_OrglChgWBSElmntUploadPreview ControllingArea Controlling Area
ProfitCenter I_OrglChgWBSElmntUploadPreview ProfitCenter Profit Center
ProfitCenterByOrglChange I_OrglChgWBSElmntUploadPreview ProfitCenterByOrglChange New Profit Center
OrglChangeMessageType I_OrglChgWBSElmntUploadPreview OrglChangeMessageType Message Type
SystemMessageClass I_OrglChgWBSElmntUploadPreview SystemMessageClass Message ID
SystemMessageNumber I_OrglChgWBSElmntUploadPreview SystemMessageNumber Message Number
SystemMessageVariable1 I_OrglChgWBSElmntUploadPreview SystemMessageVariable1 Variable 1
SystemMessageVariable2 I_OrglChgWBSElmntUploadPreview SystemMessageVariable2 Variable 2
SystemMessageVariable3 I_OrglChgWBSElmntUploadPreview SystemMessageVariable3 Variable 3
SystemMessageVariable4 I_OrglChgWBSElmntUploadPreview SystemMessageVariable4 Variable 4
_ProfitCenterBfrOrglChangeText I_OrglChgWBSElmntUploadPreview _ProfitCenterBfrOrglChangeText
_ProfitCenterByOrglChangeText I_OrglChgWBSElmntUploadPreview _ProfitCenterByOrglChangeText
_WBSElement I_OrglChgWBSElmntUploadPreview _WBSElement
_OrglChangeMessageTypeText I_OrglChgWBSElmntUploadPreview _OrglChangeMessageTypeText
_ControllingArea I_OrglChgWBSElmntUploadPreview _ControllingArea
_OrganizationalChange I_OrglChgWBSElmntUploadPreview _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_OrglChgWBSElmntUploadPreview.
-- 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_OrglChgWBSElmntUploadPreview AS
SELECT
  _impOrder.OrganizationalChange AS OrganizationalChange,
  _impOrder.UploadedByUser AS UploadedByUser,
  _impOrder.FileLineNumber AS FileLineNumber,
  _impOrder.OrganizationalChangeUUID AS OrganizationalChangeUUID,
  _OrglChangeDraft.OrganizationalChangeForEdit AS OrganizationalChangeForEdit,
  _impOrder.WBSElementInternalID AS WBSElementInternalID,
  _impOrder.WBSElementExternalID AS WBSElementExternalID,
  _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._ProfitCenterBfrOrglChangeText AS _ProfitCenterBfrOrglChangeText,
  _impOrder._ProfitCenterByOrglChangeText AS _ProfitCenterByOrglChangeText,
  _impOrder._WBSElement AS _WBSElement,
  _impOrder._OrglChangeMessageTypeText AS _OrglChangeMessageTypeText,
  _impOrder._ControllingArea AS _ControllingArea,
  _impOrder._OrganizationalChange AS _OrganizationalChange
FROM I_OrglChgWBSElmntUploadPreview AS _impOrder
;

Learn More