I_ACMContrItmUoMCnvrsnInfo

DDL: I_ACMCONTRITMUOMCNVRSNINFO SQL: IACMITEMUOMCONV Type: view_entity COMPOSITE
6 Fields 3 Data Sources 1 Associations

Trading Contract Item UoM Conversion

I_ACMContrItmUoMCnvrsnInfo is a Composite CDS View that provides data about "Trading Contract Item UoM Conversion" in SAP S/4HANA. It reads from 3 data sources (I_ACMBusPartUoMConfign, I_ACMTrdgContrItmDet, I_TrdgContractItemBasicData) and exposes 6 fields with key fields TradingContractNumber, TradingContractItem, PreferredUnitOfMeasure. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_ACMBusPartUoMConfign BpUomConfig inner
I_ACMTrdgContrItmDet ContractItem from
I_TrdgContractItemBasicData ContractItemBasicData inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ACMTrdgContrHdrDetData _ContractHeader $projection.TradingContractNumber = _ContractHeader.TradingContractNumber

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Trading Contract Item UoM Conversion view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber I_ACMTrdgContrItmDet TradingContractNumber Trading Contract
KEY TradingContractItem I_ACMTrdgContrItmDet TradingContractItem Item Number
KEY PreferredUnitOfMeasure I_ACMBusPartUoMConfign PreferredUnitOfMeasure
quan153endasTradingContractItemQuantity
_ContractHeader _ContractHeader
_ContractItem _ContractItem

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_ACMContrItmUoMCnvrsnInfo.
-- 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: IACMITEMUOMCONV

CREATE VIEW I_ACMContrItmUoMCnvrsnInfo AS
SELECT
  ContractItem.TradingContractNumber AS TradingContractNumber,
  ContractItem.TradingContractItem AS TradingContractItem,
  BpUomConfig.PreferredUnitOfMeasure AS PreferredUnitOfMeasure,
  case when BaseConvFactor.QuantityNumerator is not initial and BaseConvFactor.QuantityNumerator is not null and BaseConvFactor.QuantityDenominator is not initial and BaseConvFactor.QuantityDenominator is not null and PQtyConvFactor.QuantityNumerator is not initial and PQtyConvFactor.QuantityNumerator is not null and PQtyConvFactor.QuantityDenominator is not initial and PQtyConvFactor.QuantityDenominator is not null then cast(ContractItem.TradingContractItemQuantity * division((BaseConvFactor.QuantityNumerator * PQtyConvFactor.QuantityDenominator), (PQtyConvFactor.QuantityNumerator * BaseConvFactor.QuantityDenominator),9) as abap.quan( 15, 3 ) ) else cast( unit_conversion( quantity => ContractItem.TradingContractItemQuantity, source_unit => ContractItem.UnitOfMeasure, target_unit => BpUomConfig.PreferredUnitOfMeasure, error_handling => 'SET_TO_NULL') as abap.quan( 15, 3 ) ) end as TradingContractItemQuantity AS quan153endasTradingContractItemQuantity
FROM I_ACMTrdgContrItmDet AS ContractItem
INNER JOIN I_TrdgContractItemBasicData AS ContractItemBasicData ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMBusPartUoMConfign AS BpUomConfig ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMTrdgContrHdrDetData AS _ContractHeader ON TradingContractNumber = _ContractHeader.TradingContractNumber  -- association [1..1]
;

Learn More