R_ACMTrdgContrOptntyDetsTP

DDL: R_ACMTRDGCONTROPTNTYDETSTP SQL: RACMCONTROPNTYTP Type: view_entity TRANSACTIONAL
16 Fields 1 Data Sources 1 Associations

Transaction Processing View: Optionality

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

Data Sources (1)

SourceAliasJoin Type
I_ACMTrdgContrOptntyDets I_ACMTrdgContrOptntyDets from

Associations (1)

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

Annotations (7)

NameValueLevelField
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transaction Processing View: Optionality view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber TradingContractNumber Trading Contract
KEY TradingContractItem TradingContractItem Item Number
KEY ACMContractOptionsID ACMContractOptionsID Optionality Cat. ID
KEY ACMContractOptionsValueType ACMContractOptionsValueType Value Type
KEY ACMContractOptionsSequenceNmbr ACMContractOptionsSequenceNmbr Value Number
ACMTradingContractOptionsType ACMTradingContractOptionsType Optionality Type
ACMContractOptionsValue ACMContractOptionsValue Option Value
ACMContractOptionsUnit ACMContractOptionsUnit UoM: Conv. to
ACMContractOptionsTimeUnit ACMContractOptionsTimeUnit Time UoM
ACMContractOptionsPremDiscType ACMContractOptionsPremDiscType Worklist Type
ACMContractOptionsPremDiscAmt ACMContractOptionsPremDiscAmt Pre/Disc Value
ACMContractOptionsPremDiscCrcy ACMContractOptionsPremDiscCrcy Valuation Crcy
ACMContractOptionsPremDiscQty ACMContractOptionsPremDiscQty Pricing Unit
ACMContractOptionsPremDiscUnit ACMContractOptionsPremDiscUnit 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 R_ACMTrdgContrOptntyDetsTP.
-- 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: RACMCONTROPNTYTP

CREATE VIEW R_ACMTrdgContrOptntyDetsTP AS
SELECT
  TradingContractNumber,
  TradingContractItem,
  ACMContractOptionsID,
  ACMContractOptionsValueType,
  ACMContractOptionsSequenceNmbr,
  ACMTradingContractOptionsType,
  ACMContractOptionsValue,
  ACMContractOptionsUnit,
  ACMContractOptionsTimeUnit,
  ACMContractOptionsPremDiscType,
  ACMContractOptionsPremDiscAmt,
  ACMContractOptionsPremDiscCrcy,
  ACMContractOptionsPremDiscQty,
  ACMContractOptionsPremDiscUnit
FROM I_ACMTrdgContrOptntyDets
LEFT OUTER JOIN R_ACMTrdgContrHdrTP AS _ContractHeader ON TradingContractNumber = _ContractHeader.TradingContractNumber  -- association [1..1]
;

Learn More