C_CmmdtyOrdFillPacketAssgdFill
Fill Packet Assigned Fills Consump. View
C_CmmdtyOrdFillPacketAssgdFill is a Consumption CDS View that provides data about "Fill Packet Assigned Fills Consump. View" in SAP S/4HANA. It reads from 6 data sources and exposes 8 fields with key field CommodityOrderFillUUID. It has 1 association to related views. Part of development package FS_CMM_CDOTE_ORDER_FILL.
Data Sources (6)
| Source | Alias | Join Type |
|---|---|---|
| I_CmmdtyOrderFutureIDVH | _CommodityFutureID | left_outer |
| I_DerivativeContractSpecText | _DerivativeContractSpecText | left_outer |
| i_MarketIdentifierCodeText | _MarketIdentifierCodeText | left_outer |
| I_CmmdtyDrvtvFlowTypeText | CmmdtyOrdFillPositionText | left_outer |
| I_CommodityOrderRequestFill | CommodityOrderFill | from |
| I_CmmdtyDrvtvContrKeyDates | DerivativeContractKeyDates | left_outer |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_CmmdtyOrdFillPacketCommodity | _FillPacket | $projection.CommodityOrderFillPacketUUID = _FillPacket.CommodityOrderFillPacketUUID |
Annotations (18)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CCMMDTYPKTDOCTP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Fill Packet Assigned Fills Consump. View | view | |
| VDM.viewType | #CONSUMPTION | view | |
| Search.searchable | false | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| Metadata.allowExtensions | true | view | |
| ClientHandling.type | #CLIENT_DEPENDENT | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| UI.presentationVariant.sortOrder.by | CommodityOrderFill | view | |
| UI.presentationVariant.sortOrder.direction | #DESC | view | |
| UI.headerInfo.typeNamePlural | Fills | view | |
| UI.headerInfo.typeName | Fill | view | |
| UI.headerInfo.title.value | CommodityOrderFill | view |
Fields (8)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CommodityOrderFillUUID | I_CommodityOrderRequestFill | CommodityOrderFillUUID | |
| CommodityOrderFillPacketUUID | I_CommodityOrderRequestFill | CommodityOrderFillPacketUUID | ||
| CommodityOrderFillasCommodityOrderFill | ||||
| CommodityasCommodity | ||||
| CompanyCode | I_CommodityOrderRequestFill | CompanyCode | ||
| DerivativeContrSpecName | I_DerivativeContractSpecText | DerivativeContrSpecName | ||
| MarketIdentifierCodeName | i_MarketIdentifierCodeText | MarketIdentifierCodeName | ||
| Associations_FillPacket |
@AbapCatalog.sqlViewName: 'CCMMDTYPKTDOCTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Fill Packet Assigned Fills Consump. View'
@VDM.viewType: #CONSUMPTION
@Search.searchable: false
@ObjectModel.semanticKey : ['CommodityOrderFill']
@ObjectModel.usageType: {
serviceQuality : #D,
sizeCategory : #L,
dataClass : #TRANSACTIONAL }
@Metadata.allowExtensions: true
@ClientHandling: {
type: #CLIENT_DEPENDENT,
algorithm: #SESSION_VARIABLE }
@UI.presentationVariant:{
groupBy : [ 'CommodityOrderFillPacketUUID' ],
requestAtLeast: ['CmmdtyOrderFillPrice' , 'CmmdtyOrderFillPriceCrcy' ,
'CmmdtyOrderFillQuantityUnit' , 'CmmdtyOrdFillPricePerFillText' ,
'DerivativeContrSpecification' ],
sortOrder:{
by: 'CommodityOrderFill',
direction: #DESC
}}
-- Header Title of Commodity Order Fill Packet Page
@UI.headerInfo : {
typeNamePlural : 'Fills',
typeName : 'Fill',
title : { value : 'CommodityOrderFill' } }
define view C_CmmdtyOrdFillPacketAssgdFill
as select from I_CommodityOrderRequestFill as CommodityOrderFill // I_CommodityOrderFill as CommodityOrderFill
-- Derivative Contracts Key Dates
left outer join I_CmmdtyDrvtvContrKeyDates as DerivativeContractKeyDates on CommodityOrderFill.DerivativeContrSpecification = DerivativeContractKeyDates.DerivativeContrSpecification
and CommodityOrderFill.MaturityKeyDate = DerivativeContractKeyDates.MaturityKeyDate
-- Association to get text for Commodity Order Position Type
left outer join I_CmmdtyDrvtvFlowTypeText as CmmdtyOrdFillPositionText on CommodityOrderFill.CmmdtyOrderRequestFlowType = CmmdtyOrdFillPositionText.CmmdtyOrderRequestFlowType
-- Association to get search help value for Future ID
left outer join I_CmmdtyOrderFutureIDVH as _CommodityFutureID on CommodityOrderFill.CmmdtyOrderFillFutureID = _CommodityFutureID.CmmdtyOrderFillFutureID
and CommodityOrderFill.MaturityKeyDate = _CommodityFutureID.MaturityKeyDate
-- Association to get text for Derivative Contract Specification
left outer join I_DerivativeContractSpecText as _DerivativeContractSpecText on CommodityOrderFill.DerivativeContrSpecification = _DerivativeContractSpecText.DerivativeContrSpecification
and Language = $session.system_language
-- Association to get text for Market Identifier Code
left outer join i_MarketIdentifierCodeText as _MarketIdentifierCodeText on CommodityOrderFill.MarketIdentifierCode = _MarketIdentifierCodeText.MarketIdentifierCode
and _MarketIdentifierCodeText.Language = $session.system_language
--Association To get Fill Packet Info
// association [1..1] to I_CommodityOrderFillPacket as _FillPacket on $projection.CommodityOrderFillPacketUUID = _FillPacket.CommodityOrderFillPacketUUID
association [1..1] to I_CmmdtyOrdFillPacketCommodity as _FillPacket on $projection.CommodityOrderFillPacketUUID = _FillPacket.CommodityOrderFillPacketUUID
{
@UI.hidden: true
key CommodityOrderFill.CommodityOrderFillUUID as CommodityOrderFillUUID,
--------------------------------------------------------------------------Assigned Fill Information---------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@UI.hidden: true
CommodityOrderFill.CommodityOrderRequestUUID as CommodityOrderRequestUUID,
@UI.hidden: true
CommodityOrderFill.CommodityOrderFillPacketUUID as CommodityOrderFillPacketUUID,
--Commodity Fill
@UI.lineItem.position: 10
CommodityOrderFill.CommodityOrderFill as CommodityOrderFill,
--Price Per Fill Unit
CommodityOrderFill.CmmdtyOrderFillQuantityUnit as CmmdtyOrderFillQuantityUnit,
--Price Per Fill
CommodityOrderFill.CmmdtyOrderFillPrice as CmmdtyOrderFillPrice,
--Price Per Fill Currency
CommodityOrderFill.CmmdtyOrderFillPriceCrcy as CmmdtyOrderFillPriceCrcy,
--Price Per Fill Text
@UI.lineItem.position: 60
@ObjectModel:{
readOnly: true,
virtualElement: true,
virtualElementCalculatedBy: 'ABAP:CL_CMMFDOF_DERIVE_CALCD_FIELDS'
}
cast( 0 as cmmfdor_priceperfilltext )
as CmmdtyOrdFillPricePerFillText,
--Fill Packet Status
@UI.hidden: true
case _FillPacket.CmmdtyOrderFillPacketStatus
when '09' then 3
else 1
end as Criticality,
--Distributed On
@Search.defaultSearchElement : true
@Search.fuzzinessThreshold : 1.0
@Search.ranking : #HIGH
@ObjectModel.readOnly: true
@Consumption.filter.hidden: true
@UI.lineItem: { position: 80, criticality:'Criticality', criticalityRepresentation: #WITHOUT_ICON}
cast (case when _FillPacket.CmmdtyOrderFillPacketStatus = '09'
then 'X'
else ' '
end as cmmfdof_dist_follow_on_system preserving type ) as CmmdtyOrdFillFollowOnSystems,
--Lots of Fill
@UI.lineItem.position: 40
cast( CommodityOrderFill.CmmdtyOrderFillQuantityInLots as cmmfdof_cmmdtyfilllots preserving type ) as CmmdtyOrderFillQuantityInLots,
--Fill Type
@UI.hidden: true
CommodityOrderFill.CmmdtyOrderFillRequestType as CmmdtyOrderFillRequestType,
--Commodity
@UI.hidden: true
CommodityOrderFill.Commodity as Commodity,
--Transaction Time
@UI.lineItem.position: 20
cast( CommodityOrderFill.CmmdtyOrderFillDateTime as cmmfdof_transactiondatetime preserving type ) as CmmdtyOrderFillDateTime,
--Filled Quantity Unit
@UI.hidden: true
CommodityOrderFill.CmmdtyOrderFillQuantityUnit as CmmdtyOrdFillCumulativeQtyUnit,
@UI.hidden: true
CommodityOrderFill.CompanyCode as CompanyCode,
--Filled Quantity
@UI.lineItem.position: 50
@Semantics.quantity.unitOfMeasure: 'CmmdtyOrdFillCumulativeQtyUnit'
cast(CommodityOrderFill.CmmdtyOrderFillQuantity as cmmfdof_cmmdtyordfilledqty preserving type ) as CmmdtyOrderFillQuantity,
--Flow Type
@UI.lineItem.position: 70
@ObjectModel.text.element: 'CmmdtyDerivativeFlowTypeText'
CommodityOrderFill.CmmdtyOrderRequestFlowType as CmmdtyOrderRequestFlowType,
--Flow Type Description
@UI.hidden: true
cast( CmmdtyOrdFillPositionText.CmmdtyDerivativeFlowTypeText as cmmfdor_ordreqflowtypetext preserving type ) as CmmdtyDerivativeFlowTypeText,
--Future
@UI.lineItem.position: 90
@ObjectModel.text.element: 'CmmdtyOrderFillFutureName'
CommodityOrderFill.CmmdtyOrderFillFutureID as CmmdtyOrderFillFutureID,
--Future Description
@UI.hidden: true
_CommodityFutureID.CmmdtyOrderFillFutureName as CmmdtyOrderFillFutureName,
--DCS
@UI.lineItem.position: 100
@ObjectModel.text.element: 'DerivativeContrSpecName'
CommodityOrderFill.DerivativeContrSpecification as DerivativeContrSpecification,
@UI.hidden : true
_DerivativeContractSpecText.DerivativeContrSpecName as DerivativeContrSpecName,
--MIC
@UI.lineItem.position: 110
@ObjectModel.text.element: 'MarketIdentifierCodeName'
cast(CommodityOrderFill.MarketIdentifierCode as cmmfdof_mic preserving type ) as MarketIdentifierCode,
@UI.hidden : true
_MarketIdentifierCodeText.MarketIdentifierCodeName as MarketIdentifierCodeName,
--Contract Maturity Code
@UI.lineItem.position: 115
cast( DerivativeContractKeyDates.ContrDrvtvContrMaturityCode as cmmfdof_contract_code preserving type )
as ContrDrvtvContrMaturityCode,
--Maturity key date
@UI.lineItem.position: 120
cast(CommodityOrderFill.MaturityKeyDate as cmmfdof_keydate preserving type )
as MaturityKeyDate,
---------------------------------------------------------------------------Associations--------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
_FillPacket
}
where
CommodityOrderFill.CommodityOrderRequestUUID is not null
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