I_ORGLCHGPROJECTUPLOADPREVIEW

CDS View

Uploaded Projects

I_ORGLCHGPROJECTUPLOADPREVIEW is a CDS View in S/4HANA. Uploaded Projects. It contains 20 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 20 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_OrglChgProjectUploadCheck view_entity from COMPOSITE
P_OrglChgProjectUploadPreview view_entity from COMPOSITE

Fields (20)

KeyField CDS FieldsUsed in Views
KEY FileLineNumber FileLineNumber 2
KEY OrganizationalChange OrganizationalChange 2
KEY OrganizationalChangeUUID OrganizationalChangeUUID 2
KEY UploadedByUser UploadedByUser 2
_OrglChangeMessageTypeText _OrglChangeMessageTypeText 1
_ProfitCenterBfrOrglChangeText _ProfitCenterBfrOrglChangeText 1
_ProfitCenterByOrglChangeText _ProfitCenterByOrglChangeText 1
_ProjectBasicData _ProjectBasicData 1
ControllingArea ControllingArea 2
OrglChangeMessageType OrglChangeMessageType 1
ProfitCenter ProfitCenter 2
ProfitCenterByOrglChange ProfitCenterByImport,ProfitCenterByOrglChange,SystemMessageVariable1 2
ProjectExternalID ProjectExternalID 1
ProjectInternalID ProjectInternalID 2
SystemMessageClass SystemMessageClass 1
SystemMessageNumber SystemMessageNumber 1
SystemMessageVariable1 SystemMessageVariable1 1
SystemMessageVariable2 SystemMessageVariable2 1
SystemMessageVariable3 SystemMessageVariable3 1
SystemMessageVariable4 SystemMessageVariable4 1 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Uploaded Projects'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MIXED
define root view entity I_OrglChgProjectUploadPreview
  as select from finoc_imp_pro
  association [1]    to I_ProjectBasicData          as _ProjectBasicData              on  $projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID
  association [0..*] to I_ProfitCenterText          as _ProfitCenterBfrOrglChangeText on  $projection.ControllingArea                    = _ProfitCenterBfrOrglChangeText.ControllingArea
                                                                                      and $projection.ProfitCenter                       = _ProfitCenterBfrOrglChangeText.ProfitCenter
                                                                                      and _ProfitCenterBfrOrglChangeText.ValidityEndDate = '99991231'
  association [0..*] to I_ProfitCenterText          as _ProfitCenterByOrglChangeText  on  $projection.ControllingArea                   = _ProfitCenterByOrglChangeText.ControllingArea
                                                                                      and $projection.ProfitCenterByOrglChange          = _ProfitCenterByOrglChangeText.ProfitCenter
                                                                                      and _ProfitCenterByOrglChangeText.ValidityEndDate = '99991231'
  association [1..*] to I_OrglChangeMessageTypeText as _OrglChangeMessageTypeText     on  $projection.OrglChangeMessageType = _OrglChangeMessageTypeText.OrglChangeMessageType

{
  key orgl_change                                                 as OrganizationalChange,
  key imported_by                                                 as UploadedByUser,
  key file_row_number                                             as FileLineNumber,
  key draftuuid                                                   as OrganizationalChangeUUID,
      cast (ps_prj_pnr as fis_projectint_no_conv preserving type) as ProjectInternalID,
      cast (ps_pspid as fis_projectext_no_conv preserving type)   as ProjectExternalID,
      kokrs                                                       as ControllingArea,
      prctr                                                       as ProfitCenter,
      prctr_new                                                   as ProfitCenterByOrglChange,
      msg_type                                                    as OrglChangeMessageType,
      msg_id                                                      as SystemMessageClass,
      msg_number                                                  as SystemMessageNumber,
      msg_v1                                                      as SystemMessageVariable1,
      msg_v2                                                      as SystemMessageVariable2,
      msg_v3                                                      as SystemMessageVariable3,
      msg_v4                                                      as SystemMessageVariable4,


      _ProfitCenterBfrOrglChangeText,
      _ProfitCenterByOrglChangeText,
      _OrglChangeMessageTypeText,
      _ProjectBasicData
}

Learn More