C_ACMMntnPrcLotCmmdtyOrder

DDL: C_ACMMNTNPRCLOTCMMDTYORDER SQL: CPLOTCDOTES Type: view CONSUMPTION
11 Fields 1 Data Sources

Consumption for Price Lot Commodity Order

C_ACMMntnPrcLotCmmdtyOrder is a Consumption CDS View that provides data about "Consumption for Price Lot Commodity Order" in SAP S/4HANA. It reads from 1 data source (I_ACMMntnPrcgLotCmmdtyOrder) and exposes 11 fields with key fields TradingContractNumber, TradingContractItem, PricingConditionTerm, CommodityOrderRequest.

Data Sources (1)

SourceAliasJoin Type
I_ACMMntnPrcgLotCmmdtyOrder PriceCommOrder from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPLOTCDOTES view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Consumption for Price Lot Commodity Order view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber
KEY TradingContractItem
KEY PricingConditionTerm I_ACMMntnPrcgLotCmmdtyOrder PricingConditionTerm Term Number
KEY CommodityOrderRequest CommodityOrderRequest Order Request ID
CommodityOrderRequestUUID CommodityOrderRequestUUID Key
CmmdtyOrderRequestReason CmmdtyOrderRequestReason Order Request Reason
CmmdtyOrderRequestReasonText CmmdtyOrderRequestReasonText
DateRecordCreated DateRecordCreated Created on
TimeRecordCreated TimeRecordCreated Created At
CmmdtyOrderRequestStatus CmmdtyOrderRequestStatus Order Status
CmmdtyOrderRequestStatusText CmmdtyOrderRequestStatusText Short Description

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 C_ACMMntnPrcLotCmmdtyOrder.
-- 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: CPLOTCDOTES

CREATE VIEW C_ACMMntnPrcLotCmmdtyOrder AS
SELECT
  cast(PriceCommOrder.TradingContractNumber as tkonn ) AS TradingContractNumber,
  cast(PriceCommOrder.TradingContractItem as tposn ) AS TradingContractItem,
  PriceCommOrder.PricingConditionTerm AS PricingConditionTerm,
  CommodityOrderRequest,
  CommodityOrderRequestUUID,
  CmmdtyOrderRequestReason,
  CmmdtyOrderRequestReasonText,
  DateRecordCreated,
  TimeRecordCreated,
  CmmdtyOrderRequestStatus,
  CmmdtyOrderRequestStatusText
FROM I_ACMMntnPrcgLotCmmdtyOrder AS PriceCommOrder
;

Learn More