P_OrglChgOrderUploadPreview

DDL: P_ORGLCHGORDERUPLOADPREVIEW Type: view_entity COMPOSITE
20 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
I_OrglChgOrderUploadPreview _impOrder from

Annotations (3)

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

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChange I_OrglChgOrderUploadPreview OrganizationalChange Organizational Change
KEY UploadedByUser I_OrglChgOrderUploadPreview UploadedByUser Uploaded By
KEY FileLineNumber I_OrglChgOrderUploadPreview FileLineNumber Row No. in File
KEY OrganizationalChangeUUID I_OrglChgOrderUploadPreview OrganizationalChangeUUID UUID
OrganizationalChangeForEdit _OrglChangeDraft OrganizationalChangeForEdit Organizational Change
OrderID I_OrglChgOrderUploadPreview OrderID Order ID
ControllingArea I_OrglChgOrderUploadPreview ControllingArea Controlling Area
ProfitCenter I_OrglChgOrderUploadPreview ProfitCenter Profit Center
ProfitCenterByOrglChange I_OrglChgOrderUploadPreview ProfitCenterByOrglChange New Profit Center
OrglChangeMessageType I_OrglChgOrderUploadPreview OrglChangeMessageType Message Type
SystemMessageClass I_OrglChgOrderUploadPreview SystemMessageClass Message ID
SystemMessageNumber I_OrglChgOrderUploadPreview SystemMessageNumber Message Number
SystemMessageVariable1 I_OrglChgOrderUploadPreview SystemMessageVariable1 Variable 1
SystemMessageVariable2 I_OrglChgOrderUploadPreview SystemMessageVariable2 Variable 2
SystemMessageVariable3 I_OrglChgOrderUploadPreview SystemMessageVariable3 Variable 3
SystemMessageVariable4 I_OrglChgOrderUploadPreview SystemMessageVariable4 Variable 4
_ProfitCenterBfrOrglChangeText I_OrglChgOrderUploadPreview _ProfitCenterBfrOrglChangeText
_ProfitCenterByOrglChangeText I_OrglChgOrderUploadPreview _ProfitCenterByOrglChangeText
_OrglChangeMessageTypeText I_OrglChgOrderUploadPreview _OrglChangeMessageTypeText
_OrderID I_OrglChgOrderUploadPreview _OrderID

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_OrglChgOrderUploadPreview.
-- 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_OrglChgOrderUploadPreview AS
SELECT
  _impOrder.OrganizationalChange AS OrganizationalChange,
  _impOrder.UploadedByUser AS UploadedByUser,
  _impOrder.FileLineNumber AS FileLineNumber,
  _impOrder.OrganizationalChangeUUID AS OrganizationalChangeUUID,
  _OrglChangeDraft.OrganizationalChangeForEdit AS OrganizationalChangeForEdit,
  _impOrder.OrderID AS OrderID,
  _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._OrglChangeMessageTypeText AS _OrglChangeMessageTypeText,
  _impOrder._OrderID AS _OrderID
FROM I_OrglChgOrderUploadPreview AS _impOrder
;

Learn More