I_CMMDTYORDERREQUESTTYPE

CDS View

Cmmdty Order Request Type

I_CMMDTYORDERREQUESTTYPE is a CDS View in S/4HANA. Cmmdty Order Request Type. It contains 4 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 4 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_CmmdtyOrderRequestStatus view left_outer CONSUMPTION Consumption View for Order Req Status
C_CmmdtyOrdFillRelatedFill view left_outer CONSUMPTION Assigned Fills Consumption View
I_CommodityOrderFillTP view left_outer TRANSACTIONAL Commodity Order Fill Transactional View
I_CommodityOrderRequestTP view left_outer TRANSACTIONAL Commodity Order Req. Transactional View
I_CommodityOrderRequestVH view left_outer COMPOSITE Value Help View for Order Request
I_CommodityOrdFillPacketTP view left_outer TRANSACTIONAL Tran. View for Cmmdty Deriv Ord Fill Pkt

Fields (4)

KeyField CDS FieldsUsed in Views
CmmdtyOrderReqDocCardinalValue CmmdtyOrderReqDocCardinalValue 1
CmmdtyOrderRequestKind CmmdtyOrderRequestKind 2
CmmdtyOrderRequestTypeText CmmdtyOrderRequestTypeText 1
Counterparty Counterparty 2 
@AbapCatalog.sqlViewName: 'ICMMDTYORDTYP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Cmmdty Order Request Type'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType:{ serviceQuality: #C, sizeCategory : #L, dataClass: #MIXED}
@VDM.viewType: #BASIC

define view I_CmmdtyOrderRequestType
  as select from cmmfdor_c_ordtyp as OrderType
    inner join   cmmfdor_d_ordctg as OrderCtg on OrderCtg.ordercategory = OrderType.ordercategory

  --Association to get Commodity Order Request Type Text
  association [0..1] to I_CmmdtyOrdRequestTypeText as _CmmdtyOrdRequestTypeText  on $projection.CmmdtyOrderRequestType = _CmmdtyOrdRequestTypeText.CmmdtyOrderRequestType

  --Association to get Commodity Order Request Kind Text
  association [0..1] to I_CmmdtyOrdRequestKindText as _CmmdtyOrdRequestKindText  on $projection.CmmdtyOrderRequestKind = _CmmdtyOrdRequestKindText.CmmdtyOrderRequestKind

  --Association to get Commodity Order Request Counterparty Info Text
  association [0..1] to I_CmmdtyOrdReqCntrPtyText  as _CmmdtyOrdReqCntrPtyText   on $projection.Counterparty = _CmmdtyOrdReqCntrPtyText.CmmdtyOrdFillCounterPartyInfo

{
  key   OrderType.ordertype                                                           as CmmdtyOrderRequestType,
        _CmmdtyOrdRequestTypeText.CmmdtyOrderRequestTypeText                          as CmmdtyOrderRequestTypeText,
        OrderCtg.ordercategory                                                        as CommodityOrderFillCategory,
        OrderCtg.derivativetype                                                       as CmmdtyOrdFillDrvtvType,
        OrderCtg.orderkind                                                            as CmmdtyOrderRequestKind,
        _CmmdtyOrdRequestKindText.CmmdtyOrderRequestKindText                          as CmmdtyOrderRequestKindText,
        OrderCtg.counterpartyinfo                                                     as Counterparty,
        _CmmdtyOrdReqCntrPtyText.CmmdtyDrvtvCounterPartyInfoTxt                       as CmmdtyDrvtvCounterPartyInfoTxt,
        OrderType.cmmdtyordreqisdefaulttype                                           as CmmdtyOrdReqIsDefaultType,
        OrderType.cmmdtyorderfillstatus                                               as CmmdtyOrderFillStatus,
        OrderType.position_hiding_enabled                                             as CmmdtyOrdReqTypeIsPosRptgEnbld,
        OrderType.cmmdtyordreqsendtobrkrisautom                                       as CmmdtyOrdReqSendToBrkrIsAutom,
        OrderType.cmmdtyorderreqdoccardinalvalue                                      as CmmdtyOrderReqDocCardinalValue,
        OrderType.cmmdtyordrequestquantityinlot                                       as CmmdtyOrdRequestQuantityInLot,
        OrderType.cmmdtyordreqprcgexecinstrn                                          as CmmdtyOrdReqPrcgExecInstrn,
        OrderType.cmmdtyordreqexprtninstruction                                       as CmmdtyOrdReqExprtnInstruction,
        OrderType.cmmdtyorderconsolidation                                            as CmmdtyOrderConsolidation 

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMMDTYORDREQCNTRPTYTEXT",
"I_CMMDTYORDREQUESTKINDTEXT",
"I_CMMDTYORDREQUESTTYPETEXT",
"CMMFDOR_C_ORDTYP",
"CMMFDOR_D_ORDCTG"
],
"ASSOCIATED":
[
"I_CMMDTYORDREQCNTRPTYTEXT",
"I_CMMDTYORDREQUESTKINDTEXT",
"I_CMMDTYORDREQUESTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More