P_OrglChgProjectUploadPreview

DDL: P_ORGLCHGPROJECTUPLOADPREVIEW Type: view_entity COMPOSITE

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

1 data source(s) 21 fields

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 (21)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChange I_OrglChgProjectUploadPreview OrganizationalChange
KEY UploadedByUser I_OrglChgProjectUploadPreview UploadedByUser
KEY FileLineNumber I_OrglChgProjectUploadPreview FileLineNumber
KEY OrganizationalChangeUUID I_OrglChgProjectUploadPreview OrganizationalChangeUUID
OrganizationalChangeForEdit _OrglChangeDraft OrganizationalChangeForEdit
ProjectInternalID I_OrglChgProjectUploadPreview ProjectInternalID
ProjectExternalID I_OrglChgProjectUploadPreview ProjectExternalID
ControllingArea I_OrglChgProjectUploadPreview ControllingArea
ProfitCenter I_OrglChgProjectUploadPreview ProfitCenter
ProfitCenterByOrglChange I_OrglChgProjectUploadPreview ProfitCenterByOrglChange
OrglChangeMessageType I_OrglChgProjectUploadPreview OrglChangeMessageType
SystemMessageClass I_OrglChgProjectUploadPreview SystemMessageClass
SystemMessageNumber I_OrglChgProjectUploadPreview SystemMessageNumber
SystemMessageVariable1 I_OrglChgProjectUploadPreview SystemMessageVariable1
SystemMessageVariable2 I_OrglChgProjectUploadPreview SystemMessageVariable2
SystemMessageVariable3 I_OrglChgProjectUploadPreview SystemMessageVariable3
SystemMessageVariable4 I_OrglChgProjectUploadPreview SystemMessageVariable4
_ProjectBasicData I_OrglChgProjectUploadPreview _ProjectBasicData
_ProfitCenterBfrOrglChangeText I_OrglChgProjectUploadPreview _ProfitCenterBfrOrglChangeText
_ProfitCenterByOrglChangeText I_OrglChgProjectUploadPreview _ProfitCenterByOrglChangeText
_OrglChangeMessageTypeText I_OrglChgProjectUploadPreview _OrglChangeMessageTypeText 
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@VDM.private: true
define root view entity P_OrglChgProjectUploadPreview
  as select from           I_OrglChgProjectUploadPreview as _impOrder
    left outer to one join R_OrganizationalChangeDraft   as _OrglChangeDraft on  _impOrder.OrganizationalChangeUUID = _OrglChangeDraft.DraftUUID
                                                                             and _impOrder.OrganizationalChange     = _OrglChangeDraft.OrganizationalChange
{
  key _impOrder.OrganizationalChange,
  key _impOrder.UploadedByUser,
  key _impOrder.FileLineNumber,
  key _impOrder.OrganizationalChangeUUID,

      _OrglChangeDraft.OrganizationalChangeForEdit as OrganizationalChangeForEdit,

      _impOrder.ProjectInternalID,
      _impOrder.ProjectExternalID,
      _impOrder.ControllingArea,
      _impOrder.ProfitCenter,

      _impOrder.ProfitCenterByOrglChange,
      _impOrder.OrglChangeMessageType,
      _impOrder.SystemMessageClass,
      _impOrder.SystemMessageNumber,
      _impOrder.SystemMessageVariable1,
      _impOrder.SystemMessageVariable2,
      _impOrder.SystemMessageVariable3,
      _impOrder.SystemMessageVariable4,

      /* Associations */
      _impOrder._ProjectBasicData,
      _impOrder._ProfitCenterBfrOrglChangeText,
      _impOrder._ProfitCenterByOrglChangeText,
      _impOrder._OrglChangeMessageTypeText
}
where
  _impOrder.UploadedByUser = $session.user
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ORGLCHGPROJECTUPLOADPREVIEW",
"R_ORGANIZATIONALCHANGEDRAFT"
],
"ASSOCIATED":
[
"I_ORGLCHANGEMESSAGETYPETEXT",
"I_PROFITCENTERTEXT",
"I_PROJECTBASICDATA"
],
"BASE":
[
"I_ORGLCHGPROJECTUPLOADPREVIEW"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More