C_ACMMntnPrcLotPrcMethDets

DDL: C_ACMMNTNPRCLOTPRCMETHDETS Type: view_entity CONSUMPTION
25 Fields 1 Data Sources

Consumption for Price Lot Pricing method details

C_ACMMntnPrcLotPrcMethDets is a Consumption CDS View that provides data about "Consumption for Price Lot Pricing method details" in SAP S/4HANA. It reads from 1 data source (I_TrdgContrPrcFixPrcMethDet) and exposes 25 fields with key fields TradingContractNumber, TradingContractItem, PricingConditionTerm, ACMPriceMethodProgramID.

Data Sources (1)

SourceAliasJoin Type
I_TrdgContrPrcFixPrcMethDet PriceMeth from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Consumption for Price Lot Pricing method details view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber I_TrdgContrPrcFixPrcMethDet TradingContractNumber Trading Contract Number
KEY TradingContractItem I_TrdgContrPrcFixPrcMethDet TradingContractItem Trading Contract Item
KEY PricingConditionTerm I_TrdgContrPrcFixPrcMethDet PricingConditionTerm TermNumber
KEY ACMPriceMethodProgramID ACMPriceMethodProgramID Program ID
ACMPriceMethodProgram ACMPriceMethodProgram Program Name
ACMPriceMethodProgramFamily ACMPriceMethodProgramFamily Program Family
ACMPriceMethodProgramType ACMPriceMethodProgramType Program Type
ACMPrcMethSignUpStartDate ACMPrcMethSignUpStartDate SignUp Start Date
ACMPrcMethSignUpEndDate ACMPrcMethSignUpEndDate SignUp End Date
StartDate StartDate Pricing Start Date
EndDate EndDate Pricing End Date
DerivativeContractMaturityCode I_TrdgContrPrcFixPrcMethDet DerivativeContractMaturityCode Contract Maturity Code
ACMPrcMethCropYear ACMPrcMethCropYear Crop year
ACMPrcMethMarketingTiming ACMPrcMethMarketingTiming Market Timing
ACMPrcMethPriceFutures ACMPrcMethPriceFutures Futures Pricing
ACMPrcMethTargetAmount ACMPrcMethTargetAmount Target Price
ACMPricingMethodStatus ACMPricingMethodStatus Status
ACMPricingMethodStatusName ACMPricingMethodStatusName Short Description
ACMPrcMethCropYearName ACMPrcMethCropYearName
ACMPriceMethodProgramTypeName ACMPriceMethodProgramTypeName
ACMPriceMethodProgramName ACMPriceMethodProgramName
ACMPricingMethodMinPrice ACMPricingMethodMinPrice Minimum Price
ACMPricingMethodMaxPrice ACMPricingMethodMaxPrice Maximum Price
ACMFutureValueUnitCurrency ACMFutureValueUnitCurrency
ACMSemanticColor ACMSemanticColor

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_ACMMntnPrcLotPrcMethDets.
-- 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.

CREATE VIEW C_ACMMntnPrcLotPrcMethDets AS
SELECT
  PriceMeth.TradingContractNumber AS TradingContractNumber,
  PriceMeth.TradingContractItem AS TradingContractItem,
  PriceMeth.PricingConditionTerm AS PricingConditionTerm,
  ACMPriceMethodProgramID,
  ACMPriceMethodProgram,
  ACMPriceMethodProgramFamily,
  ACMPriceMethodProgramType,
  ACMPrcMethSignUpStartDate,
  ACMPrcMethSignUpEndDate,
  StartDate,
  EndDate,
  PriceMeth.DerivativeContractMaturityCode AS DerivativeContractMaturityCode,
  ACMPrcMethCropYear,
  ACMPrcMethMarketingTiming,
  ACMPrcMethPriceFutures,
  ACMPrcMethTargetAmount,
  ACMPricingMethodStatus,
  ACMPricingMethodStatusName,
  ACMPrcMethCropYearName,
  ACMPriceMethodProgramTypeName,
  ACMPriceMethodProgramName,
  ACMPricingMethodMinPrice,
  ACMPricingMethodMaxPrice,
  ACMFutureValueUnitCurrency,
  ACMSemanticColor
FROM I_TrdgContrPrcFixPrcMethDet AS PriceMeth
;

Learn More