P_RSHProjectAsgChangeDocHeader

DDL: P_RSHPROJECTASGCHANGEDOCHEADER SQL: PRSHPROJASGCDHDR Type: view CONSUMPTION

Change document headers for AMDP function

P_RSHProjectAsgChangeDocHeader is a Consumption CDS View that provides data about "Change document headers for AMDP function" in SAP S/4HANA. It reads from 1 data source (I_ChangeDocument) and exposes 8 fields with key fields ChangeDocObjectClass, ChangeDocObject, ChangeDocument.

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocument I_ChangeDocument from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PRSHPROJASGCDHDR view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Change document headers for AMDP function view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObjectClass I_ChangeDocument ChangeDocObjectClass
KEY ChangeDocObject I_ChangeDocument ChangeDocObject
KEY ChangeDocument I_ChangeDocument ChangeDocument
CreatedByUser I_ChangeDocument CreatedByUser
CreationDate I_ChangeDocument CreationDate
CreationTime I_ChangeDocument CreationTime
ResourceDemandUUID
EmploymentInternalID
@AbapCatalog.sqlViewName: 'PRSHPROJASGCDHDR'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Change document headers for AMDP function'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_RSHProjectAsgChangeDocHeader
  as select from I_ChangeDocument
{

  key I_ChangeDocument.ChangeDocObjectClass,
  key I_ChangeDocument.ChangeDocObject,
  key I_ChangeDocument.ChangeDocument,
      I_ChangeDocument.CreatedByUser,
      I_ChangeDocument.CreationDate,
      I_ChangeDocument.CreationTime,
      @Consumption.hidden: true
      cast( left (I_ChangeDocument.ChangeDocObject, 32) as char32 preserving type) as ResourceDemandUUID,
      //    cast( ChgDocHdr.objectid as /cpd/demand_key ) as ResourceDemandUUID2, <- Once this is possible in CDS we remove the AMDP

      @Consumption.hidden: true
      right(I_ChangeDocument.ChangeDocObject, 8)                                   as EmploymentInternalID

}