I_ACMTrdgContrPrcgInfo

DDL: I_ACMTRDGCONTRPRCGINFO SQL: IACMTRDGCONTRPRC Type: view COMPOSITE
33 Fields 1 Data Sources 3 Associations

Trading Contract Item Pricing

I_ACMTrdgContrPrcgInfo is a Composite CDS View that provides data about "Trading Contract Item Pricing" in SAP S/4HANA. It reads from 1 data source (I_ACMPriceFixationExercise) and exposes 33 fields with key fields TradingContractNumber, TradingContractItem, PricingConditionTerm. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ACMPriceFixationExercise ExerData inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ACMTrdgContrHdr _ContractHeader $projection.TradingContractNumber = _ContractHeader.TradingContractNumber
[*] I_ACMTrdgContrPrcFixMeth _PriceFixationMethod
[*] I_ACMTrdgContrPrcgUoMCnvrsn _PricingUoMConversion

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACMTRDGCONTRPRC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Trading Contract Item Pricing view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber PriceFixDetail TradingContractNumber Trading Contract
KEY TradingContractItem PriceFixDetail TradingContractItem Item Number
KEY PricingConditionTerm PriceFixDetail PricingConditionTerm Term Number
TrdgContrPrcgAspectSrceLotID PriceFixDetail TrdgContrPrcgAspectSrceLotID
Quantity PriceFixDetail Quantity Value
UnitOfMeasure PriceFixDetail UnitOfMeasure Unit Protected Qty
MaturityKeyDate PriceFixDetail MaturityKeyDate Maturity Key Date
DerivativeContrSpecification PriceFixDetail DerivativeContrSpecification DCS ID
ACMPricingMarketIdentifierCode PriceFixDetail ACMPricingMarketIdentifierCode MIC
ACMPrcgCndnFutureRawPrice PriceFixDetail ACMPrcgCndnFuturePrice
ACMPrcgCndnFutureTermCrcy PriceFixDetail ACMPrcgCndnFutureTermCrcy
ACMPrcgCndnFutureFixedRateQty ACMPrcgCndnFutureFixedRateQty
ACMPrcgCndnFixedRateFutureUoM ACMPrcgCndnFixedRateFutureUoM
ACMPrcgCndnBasisRawPrc ACMPrcgCndnBasisPrc
PrcgConditionTermFixedRateCrcy PriceFixDetail PrcgConditionTermFixedRateCrcy Currency Fixed Rate
ACMIsOverfillPricingLot PriceFixDetail ACMIsOverfillPricingLot
ACMPrcgCndnBasisFixedRate ACMPrcgCndnBasisFixedRate
ACMPrcgCndnFixedRateBasisUoM ACMPrcgCndnFixedRateBasisUoM
ACMPrcgCndnCumltvBsRawPrc ACMPrcgCndnCumltvBasisPrice
ACMPrcgCndnCumltvBasisCrcy ACMPrcgCndnCumltvBasisCrcy
ACMPrcgCndnFlatRawPrice ACMPrcgCndnFlatPrice Flat Price
PrcgCndnTradingContrCurrency PriceFixDetail PrcgCndnTradingContrCurrency Flat Price Currency
ACMPrcgCndnNonHedgeTermCrcy PriceFixDetail ACMPrcgCndnNonHedgeTermCrcy
ACMPrcgCndnNonHedgeFlatPrice PriceFixDetail ACMPrcgCndnNonHedgeFlatPrice
ACMPrcgNonHedgePrPerQuantity PriceFixDetail ACMPrcgCndnNonHedgePriceUnit
PrcgCndnTermCnvrsnFxdExchRate I_ACMPriceFixationExercise PrcgCndnTermCnvrsnFxdExchRate
ConditionType I_ACMPriceFixationExercise ConditionType Condition type
PrcgCndnTermCnvrsnSourceCrcy I_ACMPriceFixationExercise PrcgCndnTermCnvrsnSourceCrcy
PrcgCndnTermCnvrsnTargetCrcy I_ACMPriceFixationExercise PrcgCndnTermCnvrsnTargetCrcy
_PriceFixationMethod _PriceFixationMethod
_PricingUoMConversion _PricingUoMConversion
_ContractItem _ContractItem
_ContractHeader _ContractHeader

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_ACMTrdgContrPrcgInfo.
-- 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: IACMTRDGCONTRPRC

CREATE VIEW I_ACMTrdgContrPrcgInfo AS
SELECT
  PriceFixDetail.TradingContractNumber AS TradingContractNumber,
  PriceFixDetail.TradingContractItem AS TradingContractItem,
  PriceFixDetail.PricingConditionTerm AS PricingConditionTerm,
  PriceFixDetail.TrdgContrPrcgAspectSrceLotID AS TrdgContrPrcgAspectSrceLotID,
  PriceFixDetail.Quantity AS Quantity,
  PriceFixDetail.UnitOfMeasure AS UnitOfMeasure,
  PriceFixDetail.MaturityKeyDate AS MaturityKeyDate,
  PriceFixDetail.DerivativeContrSpecification AS DerivativeContrSpecification,
  PriceFixDetail.ACMPricingMarketIdentifierCode AS ACMPricingMarketIdentifierCode,
  PriceFixDetail.ACMPrcgCndnFuturePrice AS ACMPrcgCndnFutureRawPrice,
  PriceFixDetail.ACMPrcgCndnFutureTermCrcy AS ACMPrcgCndnFutureTermCrcy,
  ACMPrcgCndnFutureFixedRateQty,
  ACMPrcgCndnFixedRateFutureUoM,
  ACMPrcgCndnBasisPrc AS ACMPrcgCndnBasisRawPrc,
  PriceFixDetail.PrcgConditionTermFixedRateCrcy AS PrcgConditionTermFixedRateCrcy,
  PriceFixDetail.ACMIsOverfillPricingLot AS ACMIsOverfillPricingLot,
  ACMPrcgCndnBasisFixedRate,
  ACMPrcgCndnFixedRateBasisUoM,
  ACMPrcgCndnCumltvBasisPrice AS ACMPrcgCndnCumltvBsRawPrc,
  ACMPrcgCndnCumltvBasisCrcy,
  ACMPrcgCndnFlatPrice AS ACMPrcgCndnFlatRawPrice,
  PriceFixDetail.PrcgCndnTradingContrCurrency AS PrcgCndnTradingContrCurrency,
  PriceFixDetail.ACMPrcgCndnNonHedgeTermCrcy AS ACMPrcgCndnNonHedgeTermCrcy,
  PriceFixDetail.ACMPrcgCndnNonHedgeFlatPrice AS ACMPrcgCndnNonHedgeFlatPrice,
  PriceFixDetail.ACMPrcgCndnNonHedgePriceUnit AS ACMPrcgNonHedgePrPerQuantity,
  ExerData.PrcgCndnTermCnvrsnFxdExchRate AS PrcgCndnTermCnvrsnFxdExchRate,
  ExerData.ConditionType AS ConditionType,
  ExerData.PrcgCndnTermCnvrsnSourceCrcy AS PrcgCndnTermCnvrsnSourceCrcy,
  ExerData.PrcgCndnTermCnvrsnTargetCrcy AS PrcgCndnTermCnvrsnTargetCrcy
INNER JOIN I_ACMPriceFixationExercise AS ExerData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMTrdgContrHdr AS _ContractHeader ON TradingContractNumber = _ContractHeader.TradingContractNumber  -- association [1..1]
LEFT OUTER JOIN I_ACMTrdgContrPrcFixMeth AS _PriceFixationMethod ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN I_ACMTrdgContrPrcgUoMCnvrsn AS _PricingUoMConversion ON /* condition not available in parsed metadata */  -- association [*]
;

Learn More