I_CMMDTYORDERFILLPACKETSUBACCT

CDS View

Basic View for Fill Packet Subaccount

I_CMMDTYORDERFILLPACKETSUBACCT is a CDS View in S/4HANA. Basic View for Fill Packet Subaccount. It contains 7 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 7 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CmmdtyOrdFillPacketCommodity view left_outer BASIC Basic View for Cmmdty Deriv Ord Fill Pkt
I_CommodityOrderFillPacket view left_outer BASIC Basic View for Cmmdty Deriv Ord Fill Pkt

Fields (7)

KeyField CDS FieldsUsed in Views
CommodityDerivativeBroker CommodityDerivativeBroker 2
CommoditySubAccount CommoditySubAccount 2
CommoditySubAccountName CommoditySubAccountName 2
CommoditySubAccountUUID CommoditySubAccountUUID 2
CompanyCode CompanyCode 2
DerivativeContrSpecification DerivativeContrSpecification 2
ProfitCenter ProfitCenter 2 
@AbapCatalog.sqlViewName: 'IFILLPKTSUBACC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Basic View for Fill Packet Subaccount'
@VDM.viewType                               : #BASIC
@ObjectModel.usageType.sizeCategory         : #S
@ObjectModel.usageType.serviceQuality       : #B
@ObjectModel.usageType.dataClass            : #MIXED
@Metadata.ignorePropagatedAnnotations       : true
@ClientHandling: {
  type:      #CLIENT_DEPENDENT,
  algorithm: #SESSION_VARIABLE
}
define view I_CmmdtyOrderFillPacketSubAcct
  as select distinct from cmmfdof_d_fill   as Fill

  -- Subaccount Information
    left outer join       cmmfsa_d_subacct as SubaccountInfo on
    //   I_CommoditySubAccount as SubaccountInfo on

    Fill.commoditysubaccountuuid = SubaccountInfo.commoditysubaccountuuid

{
  key commodityorderfillpacketuuid                                                                                      as  CommodityOrderFillPacketUUID,

      ------------------------------------------------------Subaccount Information--------------------------------------------------------------------
      Fill.commoditysubaccountuuid                                                                                      as  CommoditySubAccountUUID,
      Fill.commodity                                                                                                    as  Commodity,
      Fill.derivativecontrspecification                                                                                 as  DerivativeContrSpecification,
      SubaccountInfo.commoditysubaccount                                                                                as  CommoditySubAccount,
      SubaccountInfo.commoditysubaccountname                                                                            as  CommoditySubAccountName,
      SubaccountInfo.commodityderivativebroker                                                                          as  CommodityDerivativeBroker,
      SubaccountInfo.companycode                                                                                        as  CompanyCode,
      SubaccountInfo.profitcenter                                                                                       as  ProfitCenter
      ------------------------------------------------------------------------------------------------------------------------------------------------

}
where
  Fill.cmmdtyorderreqlegownerrole = 'O'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CMMFDOF_D_FILL",
"CMMFSA_D_SUBACCT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More