P_OrglChgProdUploadPreview

DDL: P_ORGLCHGPRODUPLOADPREVIEW Type: view_entity COMPOSITE
22 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
I_OrglChgProdUploadPreview _impOrder from

Annotations (3)

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

Fields (22)

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

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_OrglChgProdUploadPreview.
-- 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_OrglChgProdUploadPreview AS
SELECT
  _impOrder.OrganizationalChange AS OrganizationalChange,
  _impOrder.UploadedByUser AS UploadedByUser,
  _impOrder.FileLineNumber AS FileLineNumber,
  _impOrder.OrganizationalChangeUUID AS OrganizationalChangeUUID,
  _impOrder.Product AS Product,
  _impOrder.Plant AS Plant,
  _OrglChangeDraft.OrganizationalChangeForEdit AS OrganizationalChangeForEdit,
  _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._Plant AS _Plant,
  _impOrder._Product AS _Product,
  _impOrder._ProfitCenterBfrOrglChangeText AS _ProfitCenterBfrOrglChangeText,
  _impOrder._ProfitCenterByOrglChangeText AS _ProfitCenterByOrglChangeText,
  _impOrder._OrglChangeMessageTypeText AS _OrglChangeMessageTypeText
FROM I_OrglChgProdUploadPreview AS _impOrder
;

Learn More