I_CmmdtyOrdDraftAdminvData

DDL: I_CMMDTYORDDRAFTADMINVDATA SQL: ICMMDTYORDDRAFT Type: view BASIC

Order Request Draft Administrative Data

I_CmmdtyOrdDraftAdminvData is a Basic CDS View that provides data about "Order Request Draft Administrative Data" in SAP S/4HANA. It reads from 2 data sources (cmmfdor_d_ord_d, sdraft_admin) and exposes 3 fields with key field DraftUUID.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
cmmfdor_d_ord_d _OrderReqDraft left_outer
sdraft_admin sdraft_admin from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ICMMDTYORDDRAFT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Order Request Draft Administrative Data view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY DraftUUID draft_key
CommodityOrderRequest cmmfdor_d_ord_d commodityorderrequest
InProcessByUser in_process_by 
@AbapCatalog.sqlViewName                    : 'ICMMDTYORDDRAFT'
@AbapCatalog.compiler.compareFilter         : true
@AbapCatalog.preserveKey                    : true
@VDM.viewType                               : #BASIC
@ObjectModel.usageType.sizeCategory         : #S
@ObjectModel.usageType.serviceQuality       : #B
@ObjectModel.usageType.dataClass            : #TRANSACTIONAL
@ClientHandling.type                        : #CLIENT_DEPENDENT
@ClientHandling.algorithm                   : #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Order Request Draft Administrative Data'
@Metadata.ignorePropagatedAnnotations       : true
@Search.searchable: true


define view I_CmmdtyOrdDraftAdminvData
  as select from           sdraft_admin 
    left outer join cmmfdor_d_ord_d as _OrderReqDraft on _OrderReqDraft.commodityorderrequestuuid = sdraft_admin.draft_key
{
      @UI.hidden
  key draft_key                        as DraftUUID,       // Raw16 key of the Draft Instance

  
      @UI.hidden
     _OrderReqDraft.commodityorderrequest as CommodityOrderRequest,
     
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
      in_process_by                    as InProcessByUser

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CMMFDOR_D_ORD_D",
"SDRAFT_ADMIN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More