I_ACMIntTrdgContrPricingDetail

DDL: I_ACMINTTRDGCONTRPRICINGDETAIL Type: view_entity COMPOSITE
67 Fields 2 Data Sources

Pricing Details for Inter and Intra Company Contracts

I_ACMIntTrdgContrPricingDetail is a Composite CDS View that provides data about "Pricing Details for Inter and Intra Company Contracts" in SAP S/4HANA. It reads from 2 data sources (I_ACMContrNonPrcdTmpLotDets, I_ACMTrdgContrPricingAspects) and exposes 67 fields with key fields TradingContractNumber, TradingContractItem, ACMPricingAspect, ACMPricingAspectValue, TradingContractItem.

Data Sources (2)

SourceAliasJoin Type
I_ACMContrNonPrcdTmpLotDets NPELots union
I_ACMTrdgContrPricingAspects PricingAspect from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Pricing Details for Inter and Intra Company Contracts view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber I_ACMTrdgContrPricingAspects TradingContractNumber Trading Contract
KEY TradingContractItem I_ACMTrdgContrPricingAspects TradingContractItem Item Number
KEY ACMPricingAspect I_ACMTrdgContrPricingAspects ACMPricingAspect Pricing Aspect
KEY ACMPricingAspectValue I_ACMTrdgContrPricingAspects ACMPricingAspectValue Aspect Counter
TrdgContrPrcgAspectSrceLotID TrdgContrPrcgAspectSrceLotID Short Description
TrdgContrPrcgAspectDummyLotID
ContractTradeQuantity ContractTradeQuantity Qty In Trade UoM
ContractTradeUnit ContractTradeUnit Term UoM
PrcgCndnTradingContrCurrency I_ACMTrdgContrPricingAspects PrcgCndnTradingContrCurrency Term Currency
ACMPrcgFixationStatus ACMPrcgFixationStatus Prc. Fix. Status
PricingConditionTermKey PricingConditionTermKey Term Key
PricingConditionTerm PricingConditionTerm Term Number
ACMIsOverfill I_ACMTrdgContrPricingAspects ACMIsOverfill Overfill Indicator
ACMPrcgPrimBsCrcy
RecordCreatedDate I_ACMTrdgContrPricingAspects RecordCreatedDate Created On
RecordCreatedByUser I_ACMTrdgContrPricingAspects RecordCreatedByUser Created By
LastChangeByUser I_ACMTrdgContrPricingAspects LastChangeByUser User Name
LastChangedDate I_ACMTrdgContrPricingAspects LastChangedDate Created On
ACMContrPrcgCumltvBsAmt I_ACMTrdgContrPricingAspects ACMContrPrcgCumltvBsAmt CmltBasisAmnt
ACMPrcgCndnCumltvBasisCrcy I_ACMTrdgContrPricingAspects ACMPrcgCndnCumltvBasisCrcy
ACMPrcgCumltvPerUnitQuantity I_ACMTrdgContrPricingAspects ACMPrcgCumltvPerUnitQuantity Pricing Unit
ACMPrcgCndnCumltvBasisPrUoM I_ACMTrdgContrPricingAspects ACMPrcgCndnCumltvBasisPrUoM
ACMPrcgCndnFlatPrice I_ACMTrdgContrPricingAspects ACMPrcgCndnFlatPrice Total Amount
ACMContrPrcgTotAmtCrcy I_ACMTrdgContrPricingAspects ACMContrPrcgTotAmtCrcy
ACMPrcgConditionPerUnitQty I_ACMTrdgContrPricingAspects ACMPrcgConditionPerUnitQty PrcFix Price Unit
ACMPrcgTotAmtUnit I_ACMTrdgContrPricingAspects ACMPrcgTotAmtUnit
ACMPrcgPrimaryBasisPrice I_ACMTrdgContrPricingAspects ACMPrcgPrimaryBasisPrice
ACMPrcgPrimBsCrcy I_ACMTrdgContrPricingAspects ACMPrcgPrimBsCrcy
ACMBasisPricingQuantity I_ACMTrdgContrPricingAspects ACMBasisPricingQuantity
ACMPrcgPrimBasisPriceUnit I_ACMTrdgContrPricingAspects ACMPrcgPrimBasisPriceUnit
ACMPrcgFuturesPrice I_ACMTrdgContrPricingAspects ACMPrcgFuturesPrice Amount
ACMFuturesPriceCurrency I_ACMTrdgContrPricingAspects ACMFuturesPriceCurrency
ACMFuturePricingQuantity I_ACMTrdgContrPricingAspects ACMFuturePricingQuantity
TradingContractNumber Trading Contract
KEY TradingContractItem I_ACMContrNonPrcdTmpLotDets TradingContractItem Item Number
KEY ACMPricingAspect Pricing Aspect
KEY ACMPricingAspectValue PricingAspects ACMPricingAspectValue Aspect Counter
TrdgContrPrcgAspectSrceLotID dummy_lot DomainText Short Description
TrdgContrPrcgAspectDummyLotID
ContractTradeQuantity I_ACMContrNonPrcdTmpLotDets ContractTradeQuantity Qty In Trade UoM
ContractTradeUnit I_ACMContrNonPrcdTmpLotDets OpenQuantityUnit Term UoM
PrcgCndnTradingContrCurrency I_ACMContrNonPrcdTmpLotDets PrcgCndnTradingContrCurrency Term Currency
ACMPrcgFixationStatus Prc. Fix. Status
PricingConditionTermKey Term Key
PricingConditionTerm I_ACMContrNonPrcdTmpLotDets PricingConditionTerm Term Number
ACMIsOverfill PricingAspects ACMIsOverfill Overfill Indicator
ACMPrcgPrimBsCrcy
RecordCreatedDate PricingAspects RecordCreatedDate Created On
RecordCreatedByUser PricingAspects RecordCreatedByUser Created By
LastChangeByUser PricingAspects LastChangeByUser User Name
LastChangedDate PricingAspects LastChangedDate Created On
ACMContrPrcgCumltvBsAmt PricingAspects ACMContrPrcgCumltvBsAmt CmltBasisAmnt
ACMPrcgCndnCumltvBasisCrcy PricingAspects ACMPrcgCndnCumltvBasisCrcy
ACMPrcgCumltvPerUnitQuantity PricingAspects ACMPrcgCumltvPerUnitQuantity Pricing Unit
ACMPrcgCndnCumltvBasisPrUoM PricingAspects ACMPrcgCndnCumltvBasisPrUoM
ACMPrcgCndnFlatPrice PricingAspects ACMPrcgCndnFlatPrice Total Amount
ACMContrPrcgTotAmtCrcy PricingAspects ACMContrPrcgTotAmtCrcy
ACMPrcgConditionPerUnitQty PricingAspects ACMPrcgConditionPerUnitQty PrcFix Price Unit
ACMPrcgTotAmtUnit PricingAspects ACMPrcgTotAmtUnit
ACMPrcgPrimaryBasisPrice PricingAspects ACMPrcgPrimaryBasisPrice
ACMPrcgPrimBsCrcy PricingAspects ACMPrcgPrimBsCrcy
ACMBasisPricingQuantity PricingAspects ACMBasisPricingQuantity
ACMPrcgPrimBasisPriceUnit PricingAspects ACMPrcgPrimBasisPriceUnit
ACMPrcgFuturesPrice PricingAspects ACMPrcgFuturesPrice Amount
ACMFuturesPriceCurrency PricingAspects ACMFuturesPriceCurrency
ACMFuturePricingQuantity PricingAspects ACMFuturePricingQuantity
ACMPrcgFuturesPriceUnit PricingAspects ACMPrcgFuturesPriceUnit

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_ACMIntTrdgContrPricingDetail.
-- 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_ACMIntTrdgContrPricingDetail AS
SELECT
  PricingAspect.TradingContractNumber AS TradingContractNumber,
  PricingAspect.TradingContractItem AS TradingContractItem,
  PricingAspect.ACMPricingAspect AS ACMPricingAspect,
  PricingAspect.ACMPricingAspectValue AS ACMPricingAspectValue,
  TrdgContrPrcgAspectSrceLotID,
  cast( ' ' as /accgo/e_dummy_source_lot_id ) AS TrdgContrPrcgAspectDummyLotID,
  ContractTradeQuantity,
  ContractTradeUnit,
  PricingAspect.PrcgCndnTradingContrCurrency AS PrcgCndnTradingContrCurrency,
  ACMPrcgFixationStatus,
  PricingConditionTermKey,
  PricingConditionTerm,
  PricingAspect.ACMIsOverfill AS ACMIsOverfill,
  PricingAspect.RecordCreatedDate AS RecordCreatedDate,
  PricingAspect.RecordCreatedByUser AS RecordCreatedByUser,
  PricingAspect.LastChangeByUser AS LastChangeByUser,
  PricingAspect.LastChangedDate AS LastChangedDate,
  PricingAspect.ACMContrPrcgCumltvBsAmt AS ACMContrPrcgCumltvBsAmt,
  PricingAspect.ACMPrcgCndnCumltvBasisCrcy AS ACMPrcgCndnCumltvBasisCrcy,
  PricingAspect.ACMPrcgCumltvPerUnitQuantity AS ACMPrcgCumltvPerUnitQuantity,
  PricingAspect.ACMPrcgCndnCumltvBasisPrUoM AS ACMPrcgCndnCumltvBasisPrUoM,
  PricingAspect.ACMPrcgCndnFlatPrice AS ACMPrcgCndnFlatPrice,
  PricingAspect.ACMContrPrcgTotAmtCrcy AS ACMContrPrcgTotAmtCrcy,
  PricingAspect.ACMPrcgConditionPerUnitQty AS ACMPrcgConditionPerUnitQty,
  PricingAspect.ACMPrcgTotAmtUnit AS ACMPrcgTotAmtUnit,
  PricingAspect.ACMPrcgPrimaryBasisPrice AS ACMPrcgPrimaryBasisPrice,
  PricingAspect.ACMPrcgPrimBsCrcy AS ACMPrcgPrimBsCrcy,
  PricingAspect.ACMBasisPricingQuantity AS ACMBasisPricingQuantity,
  PricingAspect.ACMPrcgPrimBasisPriceUnit AS ACMPrcgPrimBasisPriceUnit,
  PricingAspect.ACMPrcgFuturesPrice AS ACMPrcgFuturesPrice,
  PricingAspect.ACMFuturesPriceCurrency AS ACMFuturesPriceCurrency,
  PricingAspect.ACMFuturePricingQuantity AS ACMFuturePricingQuantity,
  PricingAspects.ACMPrcgFuturesPriceUnit AS ACMPrcgFuturesPriceUnit
FROM I_ACMTrdgContrPricingAspects AS PricingAspect
-- UNION with additional select branch(es): I_ACMContrNonPrcdTmpLotDets
;

Learn More