I_CommodityOrderFillPacket
Basic View for Cmmdty Deriv Ord Fill Pkt
I_CommodityOrderFillPacket is a Basic CDS View that provides data about "Basic View for Cmmdty Deriv Ord Fill Pkt" in SAP S/4HANA. It reads from 3 data sources (cmmfdor_d_order, cmmfdof_d_flpkt, I_CmmdtyOrderFillPacketSubAcct) and exposes 38 fields with key field CommodityOrderFillPacketUUID. It has 1 association to related views.
Data Sources (3)
| Source | Alias | Join Type |
|---|---|---|
| cmmfdor_d_order | _CommodityOrderRequest | left_outer |
| cmmfdof_d_flpkt | FillPacket | from |
| I_CmmdtyOrderFillPacketSubAcct | FillPacketSubAcct | left_outer |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_CmmdtyOrderFillPacket | _Extension | $projection.CommodityOrderFillPacketUUID = _Extension.CommodityOrderFillPacketUUID |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ICMMDTYORDFLPKT | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #BASIC | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| EndUserText.label | Basic View for Cmmdty Deriv Ord Fill Pkt | view |
Fields (38)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CommodityOrderFillPacketUUID | cmmfdof_d_flpkt | commodityorderfillpacketuuid | |
| CmmdtyOrderFillPacket | cmmfdof_d_flpkt | cmmdtyorderfillpacket | ||
| CmmdtyOrdFillPacketType | cmmfdof_d_flpkt | cmmdtyordfillpackettype | ||
| CommodityOrderFillPacketID | cmmfdof_d_flpkt | commodityorderfillpacketid | ||
| CmmdtyFillPacketMsgOrdID | cmmfdof_d_flpkt | cmmdtyfillpacketmsgordid | ||
| CmmdtyFillPacketTrdExecutionID | cmmfdof_d_flpkt | cmmdtyfillpackettrdexecutionid | ||
| CmmdtyOrderFillRequestType | cmmfdof_d_flpkt | cmmdtyorderfillrequesttype | ||
| CmmdtyOrdFillCounterPartyInfo | cmmfdof_d_flpkt | cmmdtyordfillcounterpartyinfo | ||
| CmmdtyOrdReqFilledQtyInLots | cmmfdof_d_flpkt | cmmdtyordreqfilledqtyinlots | ||
| CmmdtyOrdReqRmngQtyInLots | cmmfdof_d_flpkt | cmmdtyordreqrmngqtyinlots | ||
| CmmdtyOrderFillQuantityInLots | cmmfdof_d_flpkt | cmmdtyordreqfilledqtyinlots | ||
| CmmdtyOrdFillRejectionReason | cmmfdof_d_flpkt | cmmdtyordfillrejectionreason | ||
| CmmdtyOrdFillMultiLegType | cmmfdof_d_flpkt | cmmdtyordfillmultilegtype | ||
| CmmdtyOrderFillPacketStatus | cmmfdof_d_flpkt | cmmdtyorderfillpacketstatus | ||
| CmmdtyOrderIsFillWithOrder | cmmfdof_d_flpkt | cmmdtyorderisfillwithorder | ||
| CmmdtyOrdFillFirstDistrdDteTme | cmmfdof_d_flpkt | cmmdtyordfillfirstdistrddtetme | ||
| CmmdtyOrdFillLastDistrdDateTme | cmmfdof_d_flpkt | cmmdtyordfilllastdistrddatetme | ||
| CommodityOrderRequestTrader | cmmfdof_d_flpkt | commodityorderrequesttrader | ||
| CommodityOrderFillDecidedBy | cmmfdof_d_flpkt | decidedby | ||
| CommodityOrderFillDecidedOn | cmmfdof_d_flpkt | decidedon | ||
| CommodityasCommodity | ||||
| CommoditySubAccountUUID | I_CmmdtyOrderFillPacketSubAcct | CommoditySubAccountUUID | ||
| DerivativeContrSpecification | I_CmmdtyOrderFillPacketSubAcct | DerivativeContrSpecification | ||
| CommoditySubAccount | I_CmmdtyOrderFillPacketSubAcct | CommoditySubAccount | ||
| CommoditySubAccountName | I_CmmdtyOrderFillPacketSubAcct | CommoditySubAccountName | ||
| CommodityDerivativeBroker | I_CmmdtyOrderFillPacketSubAcct | CommodityDerivativeBroker | ||
| CompanyCode | I_CmmdtyOrderFillPacketSubAcct | CompanyCode | ||
| ProfitCenter | I_CmmdtyOrderFillPacketSubAcct | ProfitCenter | ||
| CmmdtyOrderDateTime | cmmfdor_d_order | creationdatetime | ||
| CmmdtyOrderRequestType | cmmfdor_d_order | cmmdtyorderrequesttype | ||
| CmmdtyOrderRequestSource | cmmfdor_d_order | cmmdtyorderrequestsource | ||
| CmmdtyOrderRequestReason | cmmfdor_d_order | cmmdtyorderrequestreason | ||
| CmmdtyOrdRequestQuantityInLot | cmmfdor_d_order | cmmdtyordrequestquantityinlot | ||
| CmmdtyOrderRequestQuantityUnit | cmmfdor_d_order | cmmdtydrvtvquantityunitperlot | ||
| createdbyuserasCreatedByUser | ||||
| CreationDateTime | cmmfdof_d_flpkt | creationdatetime | ||
| LastChangedByUser | cmmfdof_d_flpkt | lastchangedbyuser | ||
| lastchangedatetimeasLastChangeDateTime |
@AbapCatalog.sqlViewName: 'ICMMDTYORDFLPKT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Basic View for Cmmdty Deriv Ord Fill Pkt'
define view I_CommodityOrderFillPacket
as select from cmmfdof_d_flpkt as FillPacket
--Fill Packet Subaccount Information
left outer join I_CmmdtyOrderFillPacketSubAcct as FillPacketSubAcct on FillPacket.commodityorderfillpacketuuid = FillPacketSubAcct.CommodityOrderFillPacketUUID
--Association To get Order request
left outer join cmmfdor_d_order as _CommodityOrderRequest on FillPacket.commodityorderrequestuuid = _CommodityOrderRequest.commodityorderrequestuuid
-- Extension View for Commodity Order Fill Packet
association [0..1] to E_CmmdtyOrderFillPacket as _Extension on $projection.CommodityOrderFillPacketUUID = _Extension.CommodityOrderFillPacketUUID
{
key FillPacket.commodityorderfillpacketuuid as CommodityOrderFillPacketUUID,
-----------------------------------------------Fill Packet Information----------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------
FillPacket.commodityorderrequestuuid as CommodityOrderRequestUUID,
FillPacket.cmmdtyorderfillpacket as CmmdtyOrderFillPacket,
FillPacket.cmmdtyordfillpackettype as CmmdtyOrdFillPacketType,
FillPacket.commodityorderfillpacketid as CommodityOrderFillPacketID,
FillPacket.cmmdtyfillpacketmsgordid as CmmdtyFillPacketMsgOrdID,
FillPacket.cmmdtyfillpackettrdexecutionid as CmmdtyFillPacketTrdExecutionID,
FillPacket.cmmdtyorderfillrequesttype as CmmdtyOrderFillRequestType,
FillPacket.cmmdtyordfillcounterpartyinfo as CmmdtyOrdFillCounterPartyInfo,
FillPacket.cmmdtyordreqfilledqtyinlots as CmmdtyOrdReqFilledQtyInLots,
FillPacket.cmmdtyordreqrmngqtyinlots as CmmdtyOrdReqRmngQtyInLots,
FillPacket.cmmdtyordreqfilledqtyinlots as CmmdtyOrderFillQuantityInLots,
FillPacket.cmmdtyordfillrejectionreason as CmmdtyOrdFillRejectionReason,
FillPacket.cmmdtyordfillmultilegtype as CmmdtyOrdFillMultiLegType,
FillPacket.cmmdtyorderfillpacketstatus as CmmdtyOrderFillPacketStatus,
FillPacket.cmmdtyorderisfillwithorder as CmmdtyOrderIsFillWithOrder,
FillPacket.cmmdtyordfillfirstdistrddtetme as CmmdtyOrdFillFirstDistrdDteTme,
FillPacket.cmmdtyordfilllastdistrddatetme as CmmdtyOrdFillLastDistrdDateTme,
FillPacket.commodityorderrequesttrader as CommodityOrderRequestTrader,
FillPacket.decidedby as CommodityOrderFillDecidedBy,
FillPacket.decidedon as CommodityOrderFillDecidedOn,
--------------------------------------------------Subaccount Information----------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------
FillPacketSubAcct.Commodity as Commodity,
FillPacketSubAcct.CommoditySubAccountUUID as CommoditySubAccountUUID,
FillPacketSubAcct.DerivativeContrSpecification as DerivativeContrSpecification,
FillPacketSubAcct.CommoditySubAccount as CommoditySubAccount,
FillPacketSubAcct.CommoditySubAccountName as CommoditySubAccountName,
FillPacketSubAcct.CommodityDerivativeBroker as CommodityDerivativeBroker,
FillPacketSubAcct.CompanyCode as CompanyCode,
FillPacketSubAcct.ProfitCenter as ProfitCenter,
--------------------------------------------------Order Request Information----------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------
FillPacket.commodityorderrequest as CommodityOrderRequest,
_CommodityOrderRequest.creationdatetime as CmmdtyOrderDateTime,
_CommodityOrderRequest.cmmdtyorderrequesttype as CmmdtyOrderRequestType,
_CommodityOrderRequest.cmmdtyorderrequestsource as CmmdtyOrderRequestSource,
_CommodityOrderRequest.cmmdtyorderrequestreason as CmmdtyOrderRequestReason,
_CommodityOrderRequest.cmmdtyordrequestquantityinlot as CmmdtyOrdRequestQuantityInLot,
@Semantics.quantity.unitOfMeasure: 'CmmdtyOrderRequestQuantityUnit'
cast(( _CommodityOrderRequest.cmmdtyordrequestquantityinlot * _CommodityOrderRequest.cmmdtyderivativequantityperlot )
as cmmfdor_cmmdtyordrequestqty ) as CmmdtyOrderRequestQuantity,
_CommodityOrderRequest.cmmdtydrvtvquantityunitperlot as CmmdtyOrderRequestQuantityUnit,
----------------------------------------------------------------Admin Data-------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------
FillPacket.createdbyuser as CreatedByUser,
FillPacket.creationdatetime as CreationDateTime,
FillPacket.lastchangedbyuser as LastChangedByUser,
FillPacket.lastchangedatetime as LastChangeDateTime
----------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMMDTYORDERFILLPACKETSUBACCT",
"CMMFDOF_D_FLPKT",
"CMMFDOR_D_ORDER"
],
"ASSOCIATED":
[
"E_CMMDTYORDERFILLPACKET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA