I_ACMCmmdtyCPEContrCancln

DDL: I_ACMCMMDTYCPECONTRCANCLN Type: view_entity COMPOSITE
56 Fields 3 Data Sources

ACM Commdty Contract Cancellation

I_ACMCmmdtyCPEContrCancln is a Composite CDS View that provides data about "ACM Commdty Contract Cancellation" in SAP S/4HANA. It reads from 3 data sources (I_ACMCmmdtyContrCancln_1, I_CmmdtyPrcgPriceFixationGroup, I_CmmdtyPrcgPrcFxtnGrpOp) and exposes 56 fields with key fields TradingContractNumber, TradingContractItem, ContractSubItem, ACMPrcgCancellationUUID, ACMContractPricingLotID.

Data Sources (3)

SourceAliasJoin Type
I_ACMCmmdtyContrCancln_1 _Canc from
I_CmmdtyPrcgPriceFixationGroup _GrpDet inner
I_CmmdtyPrcgPrcFxtnGrpOp _GrpOps inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ACM Commdty Contract Cancellation view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber I_ACMCmmdtyContrCancln_1 TradingContractNumber Trading Contract
KEY TradingContractItem I_ACMCmmdtyContrCancln_1 TradingContractItem Item Number
KEY ContractSubItem I_ACMCmmdtyContrCancln_1 ContractSubItem Com. item num.
KEY ACMPrcgCancellationUUID I_ACMCmmdtyContrCancln_1 ACMPrcgCancellationUUID Contract GUID
KEY ACMContractPricingLotID I_ACMCmmdtyContrCancln_1 ACMContractPricingLotID Pricing Lot ID
ACMCancellationType I_ACMCmmdtyContrCancln_1 ACMCancellationType Cancellation Type
ACMCancellationTypeName _CancType DomainText Short Description
CreatedByUser I_ACMCmmdtyContrCancln_1 CreatedByUser User Name
CreationDate I_ACMCmmdtyContrCancln_1 CreationDate Time Stamp
LastChangedByUser I_ACMCmmdtyContrCancln_1 LastChangedByUser User Name
LastChangeDateTime I_ACMCmmdtyContrCancln_1 LastChangeDateTime Timestamp
ACMTrdgContrUnderFillID I_ACMCmmdtyContrCancln_1 ACMTrdgContrUnderFillID Underfill ID
ACMSourcePricingLotID I_ACMCmmdtyContrCancln_1 ACMSourcePricingLotID Source Prc. Lot ID
CmmdtyPrcgPriceFixationGroupID I_ACMCmmdtyContrCancln_1 CmmdtyPrcgPriceFixationGroupID UUID
CmmdtyPrcgPrcFixationGroupUUID I_ACMCmmdtyContrCancln_1 CmmdtyPrcgPrcFixationGroupUUID Price Fix Group ID
PurgReasonForDocCancellation I_ACMCmmdtyContrCancln_1 PurgReasonForDocCancellation Reas. for Canc.
ACMObligationLinkID I_ACMCmmdtyContrCancln_1 ACMObligationLinkID Obligtn LinkID
FinalSettlementIndicator I_ACMCmmdtyContrCancln_1 FinalSettlementIndicator Final Settlement
ACMContrCanclnSqncNmbr I_ACMCmmdtyContrCancln_1 ACMContrCanclnSqncNmbr Value Number
Side I_ACMCmmdtyContrCancln_1 Side Side
ACMNumberOfVehicles I_ACMCmmdtyContrCancln_1 ACMNumberOfVehicles Number of Vehicles
LinkUUID I_ACMCmmdtyContrCancln_1 LinkUUID Plot Link ID
ACMContractItemTotCancelledQty I_ACMCmmdtyContrCancln_1 ACMContractItemTotCancelledQty
TrdgContractItemUnitOfMeasure I_ACMCmmdtyContrCancln_1 TrdgContractItemUnitOfMeasure Base Unit
CmmdtyPrcgFutureConditionType I_ACMCmmdtyContrCancln_1 CmmdtyPrcgFutureConditionType Canc. Price Cond. 1
ACMFixedFuturesPrc I_CmmdtyPrcgPrcFxtnGrpOp PricingConditionTermFixedRate Fixed Rate
ACMPrcgCndnFutureTermCrcy I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnOpLdngCndnRefRateCrcy
ACMFixedFutPricePerUnitQty I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOpLdngCndnRefRateQty
ACMPrcgFuturesPriceUnit
ACMCmmdtyPrcgPrimBsCndnType I_ACMCmmdtyContrCancln_1 ACMCmmdtyPrcgPrimBsCndnType Canc. Price Cond. 2
ACMPrcgCndnCumltvBasisPrice I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnCumulativeBasisPrice
ACMPrcgCndnPrimBsTrmCrcy I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOpBsRefRateCurrency
ACMPrcgCndnBasisFixedRateQty I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOpBsRefRateQuantity
ACMPrcgCndnFixedRateBasisUoM I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOpBsRefRateQtyUnit
ACMAssignmentUUID I_ACMCmmdtyContrCancln_1 ACMAssignmentUUID Assignment GUID
PrcgCndnTrmPrSettingMethodUUID I_ACMCmmdtyContrCancln_1 PrcgCndnTrmPrSettingMethodUUID PSM GUID
PriceSettingMethodStatus I_ACMCmmdtyContrCancln_1 PriceSettingMethodStatus PSM Status
PrcFxtnGroupCancelledQuantity I_CmmdtyPrcgPriceFixationGroup PrcFxtnGroupCancelledQuantity
PriceFixationGroupQuantityUnit I_CmmdtyPrcgPriceFixationGroup PriceFixationGroupQuantityUnit Fixation Set Grp UoM
PrcFxtnGroupMaturityKeyDate I_CmmdtyPrcgPriceFixationGroup PrcFxtnGroupMaturityKeyDate Maturity Key Date
PrcFxtnGrpOpCancellationDate I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOpCancellationDate
PrcgConditionExchangeRateType I_CmmdtyPrcgPrcFxtnGrpOp PrcgConditionExchangeRateType Exch. Rate Type
PrcFxtnGrpOpCanclnEffctvDate I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOpCanclnEffctvDate
PrcFxtnGrpOperationIsReversed I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOperationIsReversed Reversed?
PrcFxtnGrpOpCanclnQuantity I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOpCanclnQuantity
PrcFxtnGrpOpQuantityUnit I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOpQuantityUnit
PrcFxtnGrpOpCancellationRate I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOpCancellationRate
PrcFxtnGrpOpCanclnCurrency I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOpCanclnCurrency
PrcFxtnGrpOpCancelRateQuantity I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOpCancelRateQuantity
PrcFxtnGrpOpCancelQuantityUnit I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOpCancelQuantityUnit
PrcFxtnGrpOperationEquityValue I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOperationEquityValue
PrcFxtnGroupOperationCurrency I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGroupOperationCurrency
PrcFxtnGrpOpFutrReferenceRate I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOpLdngCndnRefRate
PrcFxtnGrpOpBasisReferenceRate I_CmmdtyPrcgPrcFxtnGrpOp PrcFxtnGrpOpBasisReferenceRate
PriceFixationGroupOperation I_CmmdtyPrcgPrcFxtnGrpOp PriceFixationGroupOperation Transaction
PndgForCmmdtyDrvtvOrderIsSet I_CmmdtyPrcgPrcFxtnGrpOp PndgForCmmdtyDrvtvOrderIsSet

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_ACMCmmdtyCPEContrCancln.
-- 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.

CREATE VIEW I_ACMCmmdtyCPEContrCancln AS
SELECT
  _Canc.TradingContractNumber AS TradingContractNumber,
  _Canc.TradingContractItem AS TradingContractItem,
  _Canc.ContractSubItem AS ContractSubItem,
  _Canc.ACMPrcgCancellationUUID AS ACMPrcgCancellationUUID,
  _Canc.ACMContractPricingLotID AS ACMContractPricingLotID,
  _Canc.ACMCancellationType AS ACMCancellationType,
  _CancType.DomainText AS ACMCancellationTypeName,
  _Canc.CreatedByUser AS CreatedByUser,
  _Canc.CreationDate AS CreationDate,
  _Canc.LastChangedByUser AS LastChangedByUser,
  _Canc.LastChangeDateTime AS LastChangeDateTime,
  _Canc.ACMTrdgContrUnderFillID AS ACMTrdgContrUnderFillID,
  _Canc.ACMSourcePricingLotID AS ACMSourcePricingLotID,
  _Canc.CmmdtyPrcgPriceFixationGroupID AS CmmdtyPrcgPriceFixationGroupID,
  _Canc.CmmdtyPrcgPrcFixationGroupUUID AS CmmdtyPrcgPrcFixationGroupUUID,
  _Canc.PurgReasonForDocCancellation AS PurgReasonForDocCancellation,
  _Canc.ACMObligationLinkID AS ACMObligationLinkID,
  _Canc.FinalSettlementIndicator AS FinalSettlementIndicator,
  _Canc.ACMContrCanclnSqncNmbr AS ACMContrCanclnSqncNmbr,
  _Canc.Side AS Side,
  _Canc.ACMNumberOfVehicles AS ACMNumberOfVehicles,
  _Canc.LinkUUID AS LinkUUID,
  _Canc.ACMContractItemTotCancelledQty AS ACMContractItemTotCancelledQty,
  _Canc.TrdgContractItemUnitOfMeasure AS TrdgContractItemUnitOfMeasure,
  _Canc.CmmdtyPrcgFutureConditionType AS CmmdtyPrcgFutureConditionType,
  _GrpOps.PricingConditionTermFixedRate AS ACMFixedFuturesPrc,
  _GrpOps.PrcFxtnOpLdngCndnRefRateCrcy AS ACMPrcgCndnFutureTermCrcy,
  _GrpOps.PrcFxtnGrpOpLdngCndnRefRateQty AS ACMFixedFutPricePerUnitQty,
  _GrpOps. PrcFxtnOpLdngCndnRefRateQtyUnt AS ACMPrcgFuturesPriceUnit,
  _Canc.ACMCmmdtyPrcgPrimBsCndnType AS ACMCmmdtyPrcgPrimBsCndnType,
  _GrpOps.PrcFxtnCumulativeBasisPrice AS ACMPrcgCndnCumltvBasisPrice,
  _GrpOps.PrcFxtnGrpOpBsRefRateCurrency AS ACMPrcgCndnPrimBsTrmCrcy,
  _GrpOps.PrcFxtnGrpOpBsRefRateQuantity AS ACMPrcgCndnBasisFixedRateQty,
  _GrpOps.PrcFxtnGrpOpBsRefRateQtyUnit AS ACMPrcgCndnFixedRateBasisUoM,
  _Canc.ACMAssignmentUUID AS ACMAssignmentUUID,
  _Canc.PrcgCndnTrmPrSettingMethodUUID AS PrcgCndnTrmPrSettingMethodUUID,
  _Canc.PriceSettingMethodStatus AS PriceSettingMethodStatus,
  _GrpDet.PrcFxtnGroupCancelledQuantity AS PrcFxtnGroupCancelledQuantity,
  _GrpDet.PriceFixationGroupQuantityUnit AS PriceFixationGroupQuantityUnit,
  _GrpDet.PrcFxtnGroupMaturityKeyDate AS PrcFxtnGroupMaturityKeyDate,
  _GrpOps.PrcFxtnGrpOpCancellationDate AS PrcFxtnGrpOpCancellationDate,
  _GrpOps.PrcgConditionExchangeRateType AS PrcgConditionExchangeRateType,
  _GrpOps.PrcFxtnGrpOpCanclnEffctvDate AS PrcFxtnGrpOpCanclnEffctvDate,
  _GrpOps.PrcFxtnGrpOperationIsReversed AS PrcFxtnGrpOperationIsReversed,
  _GrpOps.PrcFxtnGrpOpCanclnQuantity AS PrcFxtnGrpOpCanclnQuantity,
  _GrpOps.PrcFxtnGrpOpQuantityUnit AS PrcFxtnGrpOpQuantityUnit,
  _GrpOps.PrcFxtnGrpOpCancellationRate AS PrcFxtnGrpOpCancellationRate,
  _GrpOps.PrcFxtnGrpOpCanclnCurrency AS PrcFxtnGrpOpCanclnCurrency,
  _GrpOps.PrcFxtnGrpOpCancelRateQuantity AS PrcFxtnGrpOpCancelRateQuantity,
  _GrpOps.PrcFxtnGrpOpCancelQuantityUnit AS PrcFxtnGrpOpCancelQuantityUnit,
  _GrpOps.PrcFxtnGrpOperationEquityValue AS PrcFxtnGrpOperationEquityValue,
  _GrpOps.PrcFxtnGroupOperationCurrency AS PrcFxtnGroupOperationCurrency,
  _GrpOps.PrcFxtnGrpOpLdngCndnRefRate AS PrcFxtnGrpOpFutrReferenceRate,
  _GrpOps.PrcFxtnGrpOpBasisReferenceRate AS PrcFxtnGrpOpBasisReferenceRate,
  _GrpOps.PriceFixationGroupOperation AS PriceFixationGroupOperation,
  _GrpOps.PndgForCmmdtyDrvtvOrderIsSet AS PndgForCmmdtyDrvtvOrderIsSet
FROM I_ACMCmmdtyContrCancln_1 AS _Canc
INNER JOIN I_CmmdtyPrcgPriceFixationGroup AS _GrpDet ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyPrcgPrcFxtnGrpOp AS _GrpOps ON /* join condition not captured in parsed metadata */
;

Learn More