C_TrdgContractOptionItemDet

DDL: C_TRDGCONTRACTOPTIONITEMDET SQL: CTRDGCONTOPTITM Type: view CONSUMPTION
28 Fields 2 Data Sources

Consumption Query for Trading Contract Optionality Details

C_TrdgContractOptionItemDet is a Consumption CDS View that provides data about "Consumption Query for Trading Contract Optionality Details" in SAP S/4HANA. It reads from 2 data sources (I_TrdgContractOptionItemDet, I_ACMTradingContractData) and exposes 28 fields with key fields TradingContractNumber, TradingContractItem, ACMContractOptionsID, ACMContractOptionsValueType, ACMContractOptionsSequenceNmbr.

Data Sources (2)

SourceAliasJoin Type
I_TrdgContractOptionItemDet I_TrdgContractOptionItemDet from
I_ACMTradingContractData TrdgContrHdr inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CTRDGCONTOPTITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Consumption Query for Trading Contract Optionality Details view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber I_TrdgContractOptionItemDet TradingContractNumber Trading Contract
KEY TradingContractItem I_TrdgContractOptionItemDet TradingContractItem Item Number
KEY ACMContractOptionsID ACMContractOptionsID Optionality Category
KEY ACMContractOptionsValueType ACMContractOptionsValueType Optionality Value Type
KEY ACMContractOptionsSequenceNmbr ACMContractOptionsSequenceNmbr Value Number
ACMTradingContractOptionsType ACMTradingContractOptionsType Optionality Type
ACMContractOptionsValue ACMContractOptionsValue Optionality Value
ACMContractOptionalityValDesc ACMContractOptionalityValDesc
ACMContractOptionsUnit ACMContractOptionsUnit Optionality UoM
ACMContractOptionsPremDiscType ACMContractOptionsPremDiscType Premium/Discount Type
ACMContractOptionsTimeUnit ACMContractOptionsTimeUnit Time UoM
DurationUnitName DurationUnitName Meas. Unit Text
ACMContractOptionsPremDiscAmt ACMContractOptionsPremDiscVal Premium/Discount Value
ACMContractOptionsPremDiscCrcy ACMContractOptionsPremDiscCrcy Premium/Discount Currency
ACMContractOptionsPremDiscQty ACMContractOptionsPremDiscQty Premium/Discount Per Unit
ACMContractOptionsPremDiscUnit ACMContractOptionsPremDiscUnit Premium/Discount UoM
ACMIsDefaultContractOptions ACMIsDefaultContractOptions Default Optionality
ACMContractOptionsCategoryName ACMContractOptionsCategoryName User Group
ACMContractOptionsCropSeasonID ACMContractOptionsCropSeasonID Crop Season ID
ACMContrOptionsSourceLocation ACMContrOptionsSourceLocation Source Location
ModeOfTransport ModeOfTransport Mode of Transp.
ACMContrOptionsMnsOfTransport ACMContrOptionsMnsOfTransport Means of Transport
TradingContractType I_ACMTradingContractData TradingContractType Contract Type
SalesOrganization I_ACMTradingContractData SalesOrganization Sales Organization
DistributionChannel I_ACMTradingContractData DistributionChannel RefDistCh-Cust/Mat.
Division I_ACMTradingContractData Division Internal Division ID
PurchasingGroup Business PurchasingGroup Purchasing Group
PurchasingOrganization Business PurchasingOrganization Purchasing Organization

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 C_TrdgContractOptionItemDet.
-- 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: CTRDGCONTOPTITM

CREATE VIEW C_TrdgContractOptionItemDet AS
SELECT
  I_TrdgContractOptionItemDet.TradingContractNumber AS TradingContractNumber,
  I_TrdgContractOptionItemDet.TradingContractItem AS TradingContractItem,
  ACMContractOptionsID,
  ACMContractOptionsValueType,
  ACMContractOptionsSequenceNmbr,
  ACMTradingContractOptionsType,
  ACMContractOptionsValue,
  ACMContractOptionalityValDesc,
  ACMContractOptionsUnit,
  ACMContractOptionsPremDiscType,
  ACMContractOptionsTimeUnit,
  DurationUnitName,
  ACMContractOptionsPremDiscVal AS ACMContractOptionsPremDiscAmt,
  ACMContractOptionsPremDiscCrcy,
  ACMContractOptionsPremDiscQty,
  ACMContractOptionsPremDiscUnit,
  ACMIsDefaultContractOptions,
  ACMContractOptionsCategoryName,
  ACMContractOptionsCropSeasonID,
  ACMContrOptionsSourceLocation,
  ModeOfTransport,
  ACMContrOptionsMnsOfTransport,
  TrdgContrHdr.TradingContractType AS TradingContractType,
  TrdgContrHdr.SalesOrganization AS SalesOrganization,
  TrdgContrHdr.DistributionChannel AS DistributionChannel,
  TrdgContrHdr.Division AS Division,
  Business.PurchasingGroup AS PurchasingGroup,
  Business.PurchasingOrganization AS PurchasingOrganization
FROM I_TrdgContractOptionItemDet
INNER JOIN I_ACMTradingContractData AS TrdgContrHdr ON /* join condition not captured in parsed metadata */
;

Learn More