P_OrglChgProjectUploadCheck

DDL: P_ORGLCHGPROJECTUPLOADCHECK Type: view_entity COMPOSITE

P_OrglChgProjectUploadCheck is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_ProjectBasicData, I_OrglChgProjectUploadPreview, I_OrganizationalChangeProject) and exposes 17 fields with key fields OrganizationalChange, UploadedByUser, FileLineNumber, OrganizationalChangeUUID.

3 data source(s) 17 fields

Data Sources (3)

SourceAliasJoin Type
I_ProjectBasicData Project inner
I_OrglChgProjectUploadPreview ProjectImport from
I_OrganizationalChangeProject ProjectOrglChange inner

Annotations (3)

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

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChange I_OrglChgProjectUploadPreview OrganizationalChange
KEY UploadedByUser I_OrglChgProjectUploadPreview UploadedByUser
KEY FileLineNumber I_OrglChgProjectUploadPreview FileLineNumber
KEY OrganizationalChangeUUID I_OrglChgProjectUploadPreview OrganizationalChangeUUID
ProjectInternalID I_OrglChgProjectUploadPreview ProjectInternalID
ProjectExternalID I_ProjectBasicData ProjectExternalID
ProfitCenter I_OrglChgProjectUploadPreview ProfitCenter
ControllingArea I_OrglChgProjectUploadPreview ControllingArea
ProfitCenterByImport I_OrglChgProjectUploadPreview ProfitCenterByOrglChange
ProfitCenterByOrglChange I_OrganizationalChangeProject ProfitCenterByOrglChange
SystemMessageType
SystemMessageClass
SystemMessageNumber
SystemMessageVariable1 I_OrglChgProjectUploadPreview ProfitCenterByOrglChange
SystemMessageVariable2 I_OrganizationalChangeProject ProfitCenterByOrglChange
SystemMessageVariable3
SystemMessageVariable4 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_OrglChgProjectUploadCheck
  as select from I_OrglChgProjectUploadPreview as ProjectImport
    inner join   I_OrganizationalChangeProject as ProjectOrglChange on  ProjectOrglChange.OrganizationalChange = ProjectImport.OrganizationalChange
                                                                    and ProjectOrglChange.ProjectInternalID    = ProjectImport.ProjectInternalID
    inner join   I_ProjectBasicData            as Project           on Project.ProjectInternalID = ProjectImport.ProjectInternalID
{
  key ProjectImport.OrganizationalChange         as OrganizationalChange,
  key ProjectImport.UploadedByUser               as UploadedByUser,
  key ProjectImport.FileLineNumber               as FileLineNumber,
  key ProjectImport.OrganizationalChangeUUID     as OrganizationalChangeUUID,
      ProjectImport.ProjectInternalID            as ProjectInternalID,
      Project.ProjectExternalID                  as ProjectExternalID,
      ProjectImport.ProfitCenter                 as ProfitCenter,
      ProjectImport.ControllingArea              as ControllingArea,
      ProjectImport.ProfitCenterByOrglChange     as ProfitCenterByImport,
      ProjectOrglChange.ProfitCenterByOrglChange as ProfitCenterByOrglChange,
      'W'                                        as SystemMessageType,
      'FINOC_XLSX_IMPORT'                        as SystemMessageClass,
      '060'                                      as SystemMessageNumber,
      ProjectImport.ProfitCenterByOrglChange     as SystemMessageVariable1,
      ProjectOrglChange.ProfitCenterByOrglChange as SystemMessageVariable2,
      ''                                         as SystemMessageVariable3,
      ''                                         as SystemMessageVariable4
}
where
  ProjectImport.ProfitCenterByOrglChange <> ProjectOrglChange.ProfitCenterByOrglChange

Learn More