I_ACMTrdgContrPrcgTermData

DDL: I_ACMTRDGCONTRPRCGTERMDATA SQL: ICONTPRCTERMDATA Type: view COMPOSITE
31 Fields 2 Data Sources

Interface view for Contr Prcg Term Data

I_ACMTrdgContrPrcgTermData is a Composite CDS View that provides data about "Interface view for Contr Prcg Term Data" in SAP S/4HANA. It reads from 2 data sources (I_ACMTrdgContrConditionNmbr, I_ACMMntnPrcgGrpAndFormulaDet) and exposes 31 fields with key fields TradingContractNumber, TradingContractItem, ConditionType, PricingCndnTermExtensionGroup, ACMConditionTermNumber.

Data Sources (2)

SourceAliasJoin Type
I_ACMTrdgContrConditionNmbr ConditionNumber from
I_ACMMntnPrcgGrpAndFormulaDet cped inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICONTPRCTERMDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Interface view for Contr Prcg Term Data view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber I_ACMTrdgContrConditionNmbr TradingContractNumber Trading Contract
KEY TradingContractItem I_ACMTrdgContrConditionNmbr TradingContractItem Item Number
KEY ConditionType I_ACMMntnPrcgGrpAndFormulaDet ConditionType Condition type
KEY PricingCndnTermExtensionGroup I_ACMMntnPrcgGrpAndFormulaDet PricingCndnTermExtensionGroup Extension Group
KEY ACMConditionTermNumber I_ACMMntnPrcgGrpAndFormulaDet ACMConditionTermNumber Term Number
KEY PrcgConditionFormulaInputUUID I_ACMMntnPrcgGrpAndFormulaDet PrcgConditionFormulaInputUUID Doc. Form. GUID
ACMPrcgTermInputUUID I_ACMMntnPrcgGrpAndFormulaDet ACMPrcgTermInputUUID
PricingConditionTermFixedRate I_ACMMntnPrcgGrpAndFormulaDet PricingConditionTermFixedRate Fixed Rate
PrcgConditionTermFixedRateCrcy I_ACMMntnPrcgGrpAndFormulaDet PrcgConditionTermFixedRateCrcy Currency Fixed Rate
PrcgConditionTermFixedRateQty I_ACMMntnPrcgGrpAndFormulaDet PrcgConditionTermFixedRateQty PrcUnit Fixed Value
PrcgCndnTermFixedRateQtyUnit I_ACMMntnPrcgGrpAndFormulaDet PrcgCndnTermFixedRateQtyUnit UoM for Fixed Value
DerivativeContrSpecification I_ACMMntnPrcgGrpAndFormulaDet DerivativeContrSpecification DCS ID
ACMPricingMarketIdentifierCode I_ACMMntnPrcgGrpAndFormulaDet ACMPricingMarketIdentifierCode MIC
MaturityKeyDate I_ACMMntnPrcgGrpAndFormulaDet MaturityKeyDate Maturity Key Date
PricingConditionQuotationKey I_ACMMntnPrcgGrpAndFormulaDet PricingConditionQuotationKey Quot. Key Type
CmmdtyMaturityMonthYear I_ACMMntnPrcgGrpAndFormulaDet CmmdtyMaturityMonthYear
ConditionTermExtensionUsage I_ACMMntnPrcgGrpAndFormulaDet ConditionTermExtensionUsage Extension Usage
ConditionTermQuantity I_ACMMntnPrcgGrpAndFormulaDet ConditionTermQuantity Commodity Qty
ConditionTermUnit I_ACMMntnPrcgGrpAndFormulaDet ConditionTermUnit Comm. Qty UoM
ACMTermCalcType I_ACMMntnPrcgGrpAndFormulaDet ACMTermCalcType
PrcgCndnTradingContrCurrency I_ACMTrdgContrConditionNmbr PrcgCndnTradingContrCurrency Term Currency
PrcgCndnTermConversionRsltUUID I_ACMMntnPrcgGrpAndFormulaDet PrcgCndnTermConversionRsltUUID ConvResultGUID
PrcgCndnTrmConversionInputUUID I_ACMMntnPrcgGrpAndFormulaDet PrcgCndnTrmConversionInputUUID ConvInputGUID
BasisID I_ACMMntnPrcgGrpAndFormulaDet BasisID Basis ID
PriceQuotationType I_ACMMntnPrcgGrpAndFormulaDet PriceQuotationType Price Type
CmmdtyOrdReqDocExternalID I_ACMMntnPrcgGrpAndFormulaDet CmmdtyOrdReqDocExternalID Assigned Ref Doc Id
PrcgCndnFmlaFixedRateCurrency I_ACMMntnPrcgGrpAndFormulaDet PrcgCndnFmlaFixedRateCurrency Term Currency
PrcgCndnFmlaFxdRateQtyUnit I_ACMMntnPrcgGrpAndFormulaDet PrcgCndnFmlaFxdRateQtyUnit Term UoM
ACMPricingRate I_ACMMntnPrcgGrpAndFormulaDet ACMPricingRate CPE - Used for internal calculation (rounding, conversion)
ACMFormulaUoM I_ACMMntnPrcgGrpAndFormulaDet ACMFormulaUoM Formula UoM
PricingDocument I_ACMTrdgContrConditionNmbr PricingDocument Document Condition

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_ACMTrdgContrPrcgTermData.
-- 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: ICONTPRCTERMDATA

CREATE VIEW I_ACMTrdgContrPrcgTermData AS
SELECT
  ConditionNumber.TradingContractNumber AS TradingContractNumber,
  ConditionNumber.TradingContractItem AS TradingContractItem,
  cped.ConditionType AS ConditionType,
  cped.PricingCndnTermExtensionGroup AS PricingCndnTermExtensionGroup,
  cped.ACMConditionTermNumber AS ACMConditionTermNumber,
  cped.PrcgConditionFormulaInputUUID AS PrcgConditionFormulaInputUUID,
  cped.ACMPrcgTermInputUUID AS ACMPrcgTermInputUUID,
  cped.PricingConditionTermFixedRate AS PricingConditionTermFixedRate,
  cped.PrcgConditionTermFixedRateCrcy AS PrcgConditionTermFixedRateCrcy,
  cped.PrcgConditionTermFixedRateQty AS PrcgConditionTermFixedRateQty,
  cped.PrcgCndnTermFixedRateQtyUnit AS PrcgCndnTermFixedRateQtyUnit,
  cped.DerivativeContrSpecification AS DerivativeContrSpecification,
  cped.ACMPricingMarketIdentifierCode AS ACMPricingMarketIdentifierCode,
  cped.MaturityKeyDate AS MaturityKeyDate,
  cped.PricingConditionQuotationKey AS PricingConditionQuotationKey,
  cped.CmmdtyMaturityMonthYear AS CmmdtyMaturityMonthYear,
  cped.ConditionTermExtensionUsage AS ConditionTermExtensionUsage,
  cped.ConditionTermQuantity AS ConditionTermQuantity,
  cped.ConditionTermUnit AS ConditionTermUnit,
  cped.ACMTermCalcType AS ACMTermCalcType,
  ConditionNumber.PrcgCndnTradingContrCurrency AS PrcgCndnTradingContrCurrency,
  cped.PrcgCndnTermConversionRsltUUID AS PrcgCndnTermConversionRsltUUID,
  cped.PrcgCndnTrmConversionInputUUID AS PrcgCndnTrmConversionInputUUID,
  cped.BasisID AS BasisID,
  cped.PriceQuotationType AS PriceQuotationType,
  cped.CmmdtyOrdReqDocExternalID AS CmmdtyOrdReqDocExternalID,
  cped.PrcgCndnFmlaFixedRateCurrency AS PrcgCndnFmlaFixedRateCurrency,
  cped.PrcgCndnFmlaFxdRateQtyUnit AS PrcgCndnFmlaFxdRateQtyUnit,
  cped.ACMPricingRate AS ACMPricingRate,
  cped.ACMFormulaUoM AS ACMFormulaUoM,
  ConditionNumber.PricingDocument AS PricingDocument
FROM I_ACMTrdgContrConditionNmbr AS ConditionNumber
INNER JOIN I_ACMMntnPrcgGrpAndFormulaDet AS cped ON /* join condition not captured in parsed metadata */
;

Learn More