P_OrglChgWBSElmntUploadCheck

DDL: P_ORGLCHGWBSELMNTUPLOADCHECK Type: view_entity COMPOSITE

P_OrglChgWBSElmntUploadCheck is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_WBSElementBasicData, I_OrglChgWBSElmntUploadPreview, I_OrglChangeWBSElement) and exposes 18 fields with key fields OrganizationalChange, UploadedByUser, FileLineNumber, OrganizationalChangeUUID.

3 data source(s) 18 fields

Data Sources (3)

SourceAliasJoin Type
I_WBSElementBasicData WBSElement inner
I_OrglChgWBSElmntUploadPreview WBSImport from
I_OrglChangeWBSElement WBSOrglChange inner

Annotations (3)

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

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChange I_OrglChgWBSElmntUploadPreview OrganizationalChange
KEY UploadedByUser I_OrglChgWBSElmntUploadPreview UploadedByUser
KEY FileLineNumber I_OrglChgWBSElmntUploadPreview FileLineNumber
KEY OrganizationalChangeUUID I_OrglChgWBSElmntUploadPreview OrganizationalChangeUUID
WBSElementInternalID I_OrglChgWBSElmntUploadPreview WBSElementInternalID
WBSElementExternalID I_WBSElementBasicData WBSElementExternalID
WBSDescription I_WBSElementBasicData WBSDescription
ProfitCenter I_OrglChgWBSElmntUploadPreview ProfitCenter
ControllingArea I_OrglChgWBSElmntUploadPreview ControllingArea
ProfitCenterByImport I_OrglChgWBSElmntUploadPreview ProfitCenterByOrglChange
ProfitCenterByOrglChange I_OrglChangeWBSElement ProfitCenterByOrglChange
SystemMessageType
SystemMessageClass
SystemMessageNumber
SystemMessageVariable1 I_OrglChgWBSElmntUploadPreview ProfitCenterByOrglChange
SystemMessageVariable2 I_OrglChangeWBSElement ProfitCenterByOrglChange
SystemMessageVariable3
SystemMessageVariable4 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_OrglChgWBSElmntUploadCheck
  as select from I_OrglChgWBSElmntUploadPreview as WBSImport
    inner join   I_OrglChangeWBSElement         as WBSOrglChange on  WBSOrglChange.OrganizationalChange = WBSImport.OrganizationalChange
                                                                 and WBSOrglChange.WBSElementInternalID = WBSImport.WBSElementInternalID
    inner join   I_WBSElementBasicData          as WBSElement    on WBSElement.WBSElementInternalID = WBSImport.WBSElementInternalID
{
  key WBSImport.OrganizationalChange         as OrganizationalChange,
  key WBSImport.UploadedByUser               as UploadedByUser,
  key WBSImport.FileLineNumber               as FileLineNumber, 
  key WBSImport.OrganizationalChangeUUID     as OrganizationalChangeUUID,  
      WBSImport.WBSElementInternalID         as WBSElementInternalID,
      WBSElement.WBSElementExternalID        as WBSElementExternalID,
      WBSElement.WBSDescription              as WBSDescription,
      WBSImport.ProfitCenter                 as ProfitCenter,
      WBSImport.ControllingArea              as ControllingArea,
      WBSImport.ProfitCenterByOrglChange     as ProfitCenterByImport,
      WBSOrglChange.ProfitCenterByOrglChange as ProfitCenterByOrglChange,
      'W'                                    as SystemMessageType,
      'FINOC_XLSX_IMPORT'                    as SystemMessageClass,
      '060'                                  as SystemMessageNumber,
      WBSImport.ProfitCenterByOrglChange     as SystemMessageVariable1,
      WBSOrglChange.ProfitCenterByOrglChange as SystemMessageVariable2,
      ''                                     as SystemMessageVariable3,
      ''                                     as SystemMessageVariable4
}
where
  WBSImport.ProfitCenterByOrglChange <> WBSOrglChange.ProfitCenterByOrglChange
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ORGLCHANGEWBSELEMENT",
"I_ORGLCHGWBSELMNTUPLOADPREVIEW",
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More