I_ACMTrdgContrOptntyDets

DDL: I_ACMTRDGCONTROPTNTYDETS SQL: IACMTRDCONTOPTNY Type: view BASIC
16 Fields 1 Data Sources 1 Associations

Trading Contract Item Optionality

I_ACMTrdgContrOptntyDets is a Basic CDS View that provides data about "Trading Contract Item Optionality" in SAP S/4HANA. It reads from 1 data source (P_ACMContractOption) and exposes 16 fields with key fields TradingContractNumber, TradingContractItem, ACMContractOptionsID, ACMContractOptionsValueType, ACMContractOptionsSequenceNmbr. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_ACMContractOption Optionality from

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACMTRDCONTOPTNY 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 #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Trading Contract Item Optionality view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber P_ACMContractOption TKONN Trading Contract
KEY TradingContractItem P_ACMContractOption TPOSN Item Number
KEY ACMContractOptionsID P_ACMContractOption OPNLTY_ID Optionality Cat. ID
KEY ACMContractOptionsValueType P_ACMContractOption VALUE_TYP Value Type
KEY ACMContractOptionsSequenceNmbr P_ACMContractOption SEQ_NO Value Number
ACMTradingContractOptionsType P_ACMContractOption OPNLTY_TYP Optionality Type
ACMContractOptionsValue P_ACMContractOption OPTN_VAL Option Value
ACMContractOptionsUnit P_ACMContractOption UOM UoM: Conv. to
ACMContractOptionsTimeUnit P_ACMContractOption UOM_TIME_UNIT Time UoM
ACMContractOptionsPremDiscType P_ACMContractOption TYPE Worklist Type
ACMContractOptionsPremDiscAmt P_ACMContractOption PREM_DISC Pre/Disc Value
ACMContractOptionsPremDiscCrcy P_ACMContractOption CURRENCY Valuation Crcy
ACMContractOptionsPremDiscQty P_ACMContractOption PER_UOM Pricing Unit
ACMContractOptionsPremDiscUnit P_ACMContractOption UOM_PD Pre/Disc UoM
_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_ACMTrdgContrOptntyDets.
-- 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: IACMTRDCONTOPTNY

CREATE VIEW I_ACMTrdgContrOptntyDets AS
SELECT
  Optionality.TKONN AS TradingContractNumber,
  Optionality.TPOSN AS TradingContractItem,
  Optionality.OPNLTY_ID AS ACMContractOptionsID,
  Optionality.VALUE_TYP AS ACMContractOptionsValueType,
  Optionality.SEQ_NO AS ACMContractOptionsSequenceNmbr,
  Optionality.OPNLTY_TYP AS ACMTradingContractOptionsType,
  Optionality.OPTN_VAL AS ACMContractOptionsValue,
  Optionality.UOM AS ACMContractOptionsUnit,
  Optionality.UOM_TIME_UNIT AS ACMContractOptionsTimeUnit,
  Optionality.TYPE AS ACMContractOptionsPremDiscType,
  Optionality.PREM_DISC AS ACMContractOptionsPremDiscAmt,
  Optionality.CURRENCY AS ACMContractOptionsPremDiscCrcy,
  Optionality.PER_UOM AS ACMContractOptionsPremDiscQty,
  Optionality.UOM_PD AS ACMContractOptionsPremDiscUnit
FROM P_ACMContractOption AS Optionality
LEFT OUTER JOIN I_ACMTrdgContrHdr AS _ContractHeader ON TradingContractNumber = _ContractHeader.TradingContractNumber  -- association [1..1]
;

Learn More