I_CommodityOrderFillType

DDL: I_COMMODITYORDERFILLTYPE SQL: ICMMDTYORDFILLTY Type: view BASIC
7 Fields 2 Data Sources

Commodity Order Fill Type

I_CommodityOrderFillType is a Basic CDS View that provides data about "Commodity Order Fill Type" in SAP S/4HANA. It reads from 2 data sources (cmmfdof_c_fillty, cmmfdof_c_flctg) and exposes 7 fields with key field CmmdtyOrderFillRequestType.

Data Sources (2)

SourceAliasJoin Type
cmmfdof_c_fillty cmmfdof_c_fillty from
cmmfdof_c_flctg fillctg inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMMDTYORDFILLTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Commodity Order Fill Type view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.authorizationCheck #NOT_ALLOWED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyOrderFillRequestType commodityderivativefilltype Fill Packet Type
CommodityOrderFillCategory cmmfdof_c_flctg cmmdtydrvtvfillcategor Fill Packet Category
CmmdtyOrderFillAssignedToOrder assign_to_order Assign To Order
CmmdtyOrderFillIsMultiLegOrder multileg_order Multileg Order
CmmdtyOrdFillDrvtvType cmmfdof_c_flctg cmmdtydrvtvkind Derivative Type
CmmdtyOrdFillIsOutOfSequence fillisoutofsequence_for_amend Out Of Seq Amendment
CmmdtyFillSubAcctIsAutoDtmnd subaccount_autodetect Auto Deter. Sub Acct

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CommodityOrderFillType.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICMMDTYORDFILLTY

CREATE VIEW I_CommodityOrderFillType AS
SELECT
  commodityderivativefilltype AS CmmdtyOrderFillRequestType,
  fillctg.cmmdtydrvtvfillcategor AS CommodityOrderFillCategory,
  assign_to_order AS CmmdtyOrderFillAssignedToOrder,
  multileg_order AS CmmdtyOrderFillIsMultiLegOrder,
  fillctg.cmmdtydrvtvkind AS CmmdtyOrdFillDrvtvType,
  fillisoutofsequence_for_amend AS CmmdtyOrdFillIsOutOfSequence,
  subaccount_autodetect AS CmmdtyFillSubAcctIsAutoDtmnd
FROM cmmfdof_c_fillty
INNER JOIN cmmfdof_c_flctg AS fillctg ON /* join condition not captured in parsed metadata */
;

Learn More