I_CMMDTYORDERFILLPACKETRCVDON

CDS View

Basic View for Fill Packet Recieved On

I_CMMDTYORDERFILLPACKETRCVDON is a CDS View in S/4HANA. Basic View for Fill Packet Recieved On. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CommodityOrdFillPacketTP view left_outer TRANSACTIONAL Tran. View for Cmmdty Deriv Ord Fill Pkt 
@AbapCatalog.sqlViewName: 'ICMMDTYPKTRCVDON'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Basic View for Fill Packet Recieved On'
@ClientHandling: {
  type:      #CLIENT_DEPENDENT,
  algorithm: #SESSION_VARIABLE
}
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropagatedAnnotations:true

define view I_CmmdtyOrderFillPacketRcvdOn  as  select  from  P_CmmdtyOrdFillPacketFirstFill  as FillPacketFirstFill

left outer join cmmfdof_d_fill as  CmmdtyFill on FillPacketFirstFill.CommodityOrderFillPacketUUID = CmmdtyFill.commodityorderfillpacketuuid
                                              and FillPacketFirstFill.CommodityOrderFill = CmmdtyFill.commodityorderfill

 {
 
  key  FillPacketFirstFill.CommodityOrderFillPacketUUID as CommodityOrderFillPacketUUID,
  
  --First Fill in FillPacket
  FillPacketFirstFill.CommodityOrderFill as CommodityOrderFill,
  
  --Find the Date Time of First Recieved Fill
  CmmdtyFill.cmmdtyorderfilldatetime as CmmdtyOrderFillDateTime
  
  }

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

Learn More