I_ACMContractOption

DDL: I_ACMCONTRACTOPTION SQL: ICONTROPTN Type: view BASIC
22 Fields 1 Data Sources

Basic View on Contract Optionality

I_ACMContractOption is a Basic CDS View that provides data about "Basic View on Contract Optionality" in SAP S/4HANA. It reads from 1 data source (P_ACMContractOption) and exposes 22 fields with key fields TradingContractNumber, TradingContractItem, ACMContractOptionsID, ACMContractOptionsValueType, ACMContractOptionsSequenceNmbr.

Data Sources (1)

SourceAliasJoin Type
P_ACMContractOption P_ACMContractOption from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICONTROPTN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Basic View on Contract Optionality view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #REQUIRED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber TKONN Trading Contract
KEY TradingContractItem TPOSN Item Number
KEY ACMContractOptionsID OPNLTY_ID Optionality Cat. ID
KEY ACMContractOptionsValueType VALUE_TYP Value Type
KEY ACMContractOptionsSequenceNmbr SEQ_NO Value Number
ACMContractOptionBuyerSeller OPTN_BUY_SEL Buyer/Seller Opt.
ACMTradingContractOptionsType OPNLTY_TYP Optionality Type
ContractOptionsDeclarationDate DECL_BY_DT Opt. Decl. by Date
ACMSettlmtOptionsCatDesc OPTN_TEXT Optionality Cat Dsc.
ACMContractOptionsCropSeasonID CROP_SEASON_ID Crop Season ID
ACMContrOptionsSourceLocation SOURCE_LOC Source Location
ACMModeOfTransport MODE_ID MOT Line
ACMContrOptionsMnsOfTransport MEANS_ID Means of Transport
ACMContractOptionsValue OPTN_VAL Option Value
ACMContractOptionsUnit UOM UoM: Conv. to
ACMContractOptionsTimeUnit UOM_TIME_UNIT Time UoM
ACMContractOptionsPremDiscType TYPE Worklist Type
ACMContractOptionsPremDiscVal PREM_DISC Pre/Disc Value
ACMContractOptionsPremDiscCrcy CURRENCY Valuation Crcy
ACMContractOptionsPremDiscQty PER_UOM Pricing Unit
ACMContractOptionsPremDiscUnit UOM_PD Pre/Disc UoM
ACMIsDefaultContractOptions DEFAULT_OPTN Default

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_ACMContractOption.
-- 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: ICONTROPTN

CREATE VIEW I_ACMContractOption AS
SELECT
  TKONN AS TradingContractNumber,
  TPOSN AS TradingContractItem,
  OPNLTY_ID AS ACMContractOptionsID,
  VALUE_TYP AS ACMContractOptionsValueType,
  SEQ_NO AS ACMContractOptionsSequenceNmbr,
  OPTN_BUY_SEL AS ACMContractOptionBuyerSeller,
  OPNLTY_TYP AS ACMTradingContractOptionsType,
  DECL_BY_DT AS ContractOptionsDeclarationDate,
  OPTN_TEXT AS ACMSettlmtOptionsCatDesc,
  CROP_SEASON_ID AS ACMContractOptionsCropSeasonID,
  SOURCE_LOC AS ACMContrOptionsSourceLocation,
  MODE_ID AS ACMModeOfTransport,
  MEANS_ID AS ACMContrOptionsMnsOfTransport,
  OPTN_VAL AS ACMContractOptionsValue,
  UOM AS ACMContractOptionsUnit,
  UOM_TIME_UNIT AS ACMContractOptionsTimeUnit,
  TYPE AS ACMContractOptionsPremDiscType,
  PREM_DISC AS ACMContractOptionsPremDiscVal,
  CURRENCY AS ACMContractOptionsPremDiscCrcy,
  PER_UOM AS ACMContractOptionsPremDiscQty,
  UOM_PD AS ACMContractOptionsPremDiscUnit,
  DEFAULT_OPTN AS ACMIsDefaultContractOptions
FROM P_ACMContractOption
;

Learn More