I_ResvnMatlDocumentDraftState

DDL: I_RESVNMATLDOCUMENTDRAFTSTATE SQL: IRESMATLDOCSTATE Type: view COMPOSITE Package: MM_IM_RAP_RES

Reservatio Material Document State

I_ResvnMatlDocumentDraftState is a Composite CDS View that provides data about "Reservatio Material Document State" in SAP S/4HANA. It reads from 2 data sources (I_DraftAdministrativeData, R_MaterialDocumentItemDraft) and exposes 2 fields with key fields Reservation, ReservationItem. Part of development package MM_IM_RAP_RES.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_DraftAdministrativeData _draftadmindata inner
R_MaterialDocumentItemDraft _MaterialDocumentItemDraft from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRESMATLDOCSTATE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Reservation R_MaterialDocumentItemDraft Reservation
KEY ReservationItem R_MaterialDocumentItemDraft ReservationItem 
@AbapCatalog.sqlViewName: 'IRESMATLDOCSTATE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
  usageType: {
    serviceQuality: #D,
    sizeCategory: #L,
    dataClass: #TRANSACTIONAL }
}
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view I_ResvnMatlDocumentDraftState

  as select from R_MaterialDocumentItemDraft as _MaterialDocumentItemDraft

    inner join   I_DraftAdministrativeData  as _draftadmindata on  _draftadmindata.DraftEntityType = 'R_MATERIALDOCUMENTTP'
                                                                and _draftadmindata.DraftUUID       = _MaterialDocumentItemDraft.DraftAdministrativeDataUUID
{
  key   _MaterialDocumentItemDraft.Reservation,
  key   _MaterialDocumentItemDraft.ReservationItem,

        cast ( case when _MaterialDocumentItemDraft.ParentDraftUUID is not null
         then 'X'
         else ''
         end as boole_d ) as ResvnDocItmHasMatlDocDrft
}
where
      _MaterialDocumentItemDraft.DraftEntityOperationCode = 'C'
  and _draftadmindata.CreatedByUser                       = $session.user

Learn More