P_OrglChgFxdAstUploadPreview

DDL: P_ORGLCHGFXDASTUPLOADPREVIEW Type: view_entity COMPOSITE
26 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
I_OrglChgFxdAstUploadPreview _impFxdAst from

Annotations (3)

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

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChange I_OrglChgFxdAstUploadPreview OrganizationalChange Organizational Change
KEY UploadedByUser I_OrglChgFxdAstUploadPreview UploadedByUser Uploaded By
KEY FileLineNumber I_OrglChgFxdAstUploadPreview FileLineNumber Row No. in File
KEY OrganizationalChangeUUID I_OrglChgFxdAstUploadPreview OrganizationalChangeUUID UUID
OrganizationalChangeForEdit _OrglChangeDraft OrganizationalChangeForEdit Organizational Change
CompanyCode I_OrglChgFxdAstUploadPreview CompanyCode Receiver Company Code
MasterFixedAsset I_OrglChgFxdAstUploadPreview MasterFixedAsset Fixed Asset
FixedAsset I_OrglChgFxdAstUploadPreview FixedAsset Sub-number
ControllingArea I_OrglChgFxdAstUploadPreview ControllingArea Controlling Area
ProfitCenter I_OrglChgFxdAstUploadPreview ProfitCenter Profit Center
ProfitCenterByOrglChange I_OrglChgFxdAstUploadPreview ProfitCenterByOrglChange New Profit Center
OrglChangeMessageType I_OrglChgFxdAstUploadPreview OrglChangeMessageType Message Type
SystemMessageClass I_OrglChgFxdAstUploadPreview SystemMessageClass Message ID
SystemMessageNumber I_OrglChgFxdAstUploadPreview SystemMessageNumber Message Number
SystemMessageVariable1 I_OrglChgFxdAstUploadPreview SystemMessageVariable1 Variable 1
SystemMessageVariable2 I_OrglChgFxdAstUploadPreview SystemMessageVariable2 Variable 2
SystemMessageVariable3 I_OrglChgFxdAstUploadPreview SystemMessageVariable3 Variable 3
SystemMessageVariable4 I_OrglChgFxdAstUploadPreview SystemMessageVariable4 Variable 4
_ProfitCenterBfrOrglChangeText I_OrglChgFxdAstUploadPreview _ProfitCenterBfrOrglChangeText
_ProfitCenterByOrglChangeText I_OrglChgFxdAstUploadPreview _ProfitCenterByOrglChangeText
_OrglChangeMessageTypeText I_OrglChgFxdAstUploadPreview _OrglChangeMessageTypeText
_MasterFixedAsset I_OrglChgFxdAstUploadPreview _MasterFixedAsset
_FixedAsset I_OrglChgFxdAstUploadPreview _FixedAsset
_CompanyCode I_OrglChgFxdAstUploadPreview _CompanyCode
_ControllingArea I_OrglChgFxdAstUploadPreview _ControllingArea
_OrganizationalChange I_OrglChgFxdAstUploadPreview _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_OrglChgFxdAstUploadPreview.
-- 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_OrglChgFxdAstUploadPreview AS
SELECT
  _impFxdAst.OrganizationalChange AS OrganizationalChange,
  _impFxdAst.UploadedByUser AS UploadedByUser,
  _impFxdAst.FileLineNumber AS FileLineNumber,
  _impFxdAst.OrganizationalChangeUUID AS OrganizationalChangeUUID,
  _OrglChangeDraft.OrganizationalChangeForEdit AS OrganizationalChangeForEdit,
  _impFxdAst.CompanyCode AS CompanyCode,
  _impFxdAst.MasterFixedAsset AS MasterFixedAsset,
  _impFxdAst.FixedAsset AS FixedAsset,
  _impFxdAst.ControllingArea AS ControllingArea,
  _impFxdAst.ProfitCenter AS ProfitCenter,
  _impFxdAst.ProfitCenterByOrglChange AS ProfitCenterByOrglChange,
  _impFxdAst.OrglChangeMessageType AS OrglChangeMessageType,
  _impFxdAst.SystemMessageClass AS SystemMessageClass,
  _impFxdAst.SystemMessageNumber AS SystemMessageNumber,
  _impFxdAst.SystemMessageVariable1 AS SystemMessageVariable1,
  _impFxdAst.SystemMessageVariable2 AS SystemMessageVariable2,
  _impFxdAst.SystemMessageVariable3 AS SystemMessageVariable3,
  _impFxdAst.SystemMessageVariable4 AS SystemMessageVariable4,
  _impFxdAst._ProfitCenterBfrOrglChangeText AS _ProfitCenterBfrOrglChangeText,
  _impFxdAst._ProfitCenterByOrglChangeText AS _ProfitCenterByOrglChangeText,
  _impFxdAst._OrglChangeMessageTypeText AS _OrglChangeMessageTypeText,
  _impFxdAst._MasterFixedAsset AS _MasterFixedAsset,
  _impFxdAst._FixedAsset AS _FixedAsset,
  _impFxdAst._CompanyCode AS _CompanyCode,
  _impFxdAst._ControllingArea AS _ControllingArea,
  _impFxdAst._OrganizationalChange AS _OrganizationalChange
FROM I_OrglChgFxdAstUploadPreview AS _impFxdAst
;

Learn More