I_ACMMntnPrcgPrcFixGrpComp

DDL: I_ACMMNTNPRCGPRCFIXGRPCOMP Type: view_entity COMPOSITE
46 Fields 1 Data Sources

Price Fixation Group Component

I_ACMMntnPrcgPrcFixGrpComp is a Composite CDS View that provides data about "Price Fixation Group Component" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyPrcgPrcFixationGrpComp) and exposes 46 fields with key fields CmPrcgPrcFixationGrpCompUUID, CmmdtyPrcgPrcFixationGroupUUID, CmmdtyPrcgPriceFixationSetUUID, CmPrcgPrcFixationSetCompUUID.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyPrcgPrcFixationGrpComp prcFixGrpData from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Price Fixation Group Component view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY CmPrcgPrcFixationGrpCompUUID I_CmmdtyPrcgPrcFixationGrpComp CmPrcgPrcFixationGrpCompUUID Prc Fix Grp Comp ID
KEY CmmdtyPrcgPrcFixationGroupUUID I_CmmdtyPrcgPrcFixationGrpComp CmmdtyPrcgPrcFixationGroupUUID Price Fix Group ID
KEY CmmdtyPrcgPriceFixationSetUUID I_CmmdtyPrcgPrcFixationGrpComp CmmdtyPrcgPriceFixationSetUUID Price Fix Set GUID
KEY CmPrcgPrcFixationSetCompUUID I_CmmdtyPrcgPrcFixationGrpComp CmPrcgPrcFixationSetCompUUID Prc Fix Set Comp ID
ConditionType prcFixSetComp ConditionType Condition Type
PricingCndnTermExtensionGroup TermData PricingCndnTermExtensionGroup
PricingConditionSourceCurrency
PrcgCndnSourceQuantityUnit
PrcgCndnUsedSourceQuantityUnit UoM (From)
PricingDocument prcFixSetLink PricingDocument Document Condition
PricingDocumentItem prcFixSetLink PricingDocumentItem Item
PrcgConditionFormulaInputUUID formData PrcgConditionFormulaInputUUID Doc. Form. GUID
PrcgCndnFormulaAmountCurrency formData PrcgCndnFormulaAmountCurrency Doc. Currency
PricingConditionComponentType prcFixSetComp PricingConditionComponentType Quotation Key Type2
ACMPrcFixGrpID prcFixGrp CmmdtyPrcgPriceFixationGroupID Group ID
PriceFixationDocumentCurrency prcFixGrp PriceFixationDocumentCurrency Document Currency
PrcFxtnDocRateQuantityUnit prcFixGrp PrcFxtnDocRateQuantityUnit Document Unit
PrcFxtnDocumentRatePerQuantity prcFixGrp PrcFxtnDocumentRatePerQuantity Price Unit
PriceFixationTotalPrice prcFixGrp PriceFixationTotalPrice Price
ACMPriceFixationStatus Price Fixation Status
ACMConditionTermNumber TermData PricingConditionTerm Term Number
ConditionTermStatus TermData ConditionTermStatus Status
DocItmCmmdtyPrcgCndnUUID I_CmmdtyPrcgPrcFixationGrpComp DocItmCmmdtyPrcgCndnUUID Doc. Cond. Item GUID
ConditionTermRateCurrency TermData ConditionTermRateCurrency Document Currency
ConditionTermRateQuantityUnit TermData ConditionTermRateQuantityUnit Document UoM
DerivativeContrSpecification TermData DerivativeContrSpecification DCS ID
ACMPricingMarketIdentifierCode TermData MarketIdentifierCode MIC
MaturityKeyDate TermData MaturityKeyDate Maturity Key Date
PricingConditionQuotationKey Quotation Key Type
PrcgCndnTermCalculationType Calculation Type
ConditionTermExtensionUsage Extension Usage
ConditionTermQuantity TermData PricingConditionTermQuantity Quantity
ConditionTermUnit TermData PricingConditionTrmQtyUnit Unit
PrcgCndnTermCnvrsnSourceCrcy Source Currency
PrcgCndnTermCnvrsnTargetCrcy Target Currency
PrcgCndnUsedExchangeRate Prov FX
PrcgConditionFixedExchangeRate Fixed FX
BasisID BASIS ID
PriceQuotationType Quotation Type
PrcgCndnTrmActualQtanCurrency
PrcgCndnTrmActlQtanQtyUnit
PricingConditionTermFixedRate TermData PricingConditionTermFixedRate Price
PrcgConditionTermFixedRateQty TermData PrcgConditionTermFixedRateQty Rate
ACMPricingRate TermData ConditionTermRate Price (Doc Currency)
ACMFormulaUoM formData PrcgCndnFormulaQuantityUnit
CPEConditionTermStatusName

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_ACMMntnPrcgPrcFixGrpComp.
-- 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 I_ACMMntnPrcgPrcFixGrpComp AS
SELECT
  prcFixGrpData.CmPrcgPrcFixationGrpCompUUID AS CmPrcgPrcFixationGrpCompUUID,
  prcFixGrpData.CmmdtyPrcgPrcFixationGroupUUID AS CmmdtyPrcgPrcFixationGroupUUID,
  prcFixGrpData.CmmdtyPrcgPriceFixationSetUUID AS CmmdtyPrcgPriceFixationSetUUID,
  prcFixGrpData.CmPrcgPrcFixationSetCompUUID AS CmPrcgPrcFixationSetCompUUID,
  prcFixSetComp.ConditionType AS ConditionType,
  TermData.PricingCndnTermExtensionGroup AS PricingCndnTermExtensionGroup,
  TermData._CmmdtyPrcgCndnTrmCnvrsnInput.PricingConditionSourceCurrency AS PricingConditionSourceCurrency,
  TermData._CmmdtyPrcgCndnTrmCnvrsnInput.PrcgCndnSourceQuantityUnit AS PrcgCndnSourceQuantityUnit,
  TermData._CmmdtyPrcgCndnTrmCnvrsnRslt.PrcgCndnUsedSourceQuantityUnit AS PrcgCndnUsedSourceQuantityUnit,
  prcFixSetLink.PricingDocument AS PricingDocument,
  prcFixSetLink.PricingDocumentItem AS PricingDocumentItem,
  formData.PrcgConditionFormulaInputUUID AS PrcgConditionFormulaInputUUID,
  formData.PrcgCndnFormulaAmountCurrency AS PrcgCndnFormulaAmountCurrency,
  prcFixSetComp.PricingConditionComponentType AS PricingConditionComponentType,
  prcFixGrp.CmmdtyPrcgPriceFixationGroupID AS ACMPrcFixGrpID,
  prcFixGrp.PriceFixationDocumentCurrency AS PriceFixationDocumentCurrency,
  prcFixGrp.PrcFxtnDocRateQuantityUnit AS PrcFxtnDocRateQuantityUnit,
  prcFixGrp.PrcFxtnDocumentRatePerQuantity AS PrcFxtnDocumentRatePerQuantity,
  prcFixGrp.PriceFixationTotalPrice AS PriceFixationTotalPrice,
  cast(prcFixGrp._PrcFxtnGrpStsText[1: Language = $session.system_language ].CmmdtyPrcgPrcFxtnStatusName as /accgo/e_prcfix_stat) AS ACMPriceFixationStatus,
  TermData.PricingConditionTerm AS ACMConditionTermNumber,
  TermData.ConditionTermStatus AS ConditionTermStatus,
  prcFixGrpData.DocItmCmmdtyPrcgCndnUUID AS DocItmCmmdtyPrcgCndnUUID,
  TermData.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  TermData.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  TermData.DerivativeContrSpecification AS DerivativeContrSpecification,
  TermData.MarketIdentifierCode AS ACMPricingMarketIdentifierCode,
  TermData.MaturityKeyDate AS MaturityKeyDate,
  TermData._CmmdtyPrcgConditionRootTerm.PricingConditionQuotationKey AS PricingConditionQuotationKey,
  TermData._CmmdtyPrcgConditionRootTerm.PrcgCndnTermCalculationType AS PrcgCndnTermCalculationType,
  TermData._CmmdtyPrcgPrcFixationGrpComp._CmmdtyPrcgCndnExerciseTerm.ConditionTermExtensionUsage AS ConditionTermExtensionUsage,
  TermData.PricingConditionTermQuantity AS ConditionTermQuantity,
  TermData.PricingConditionTrmQtyUnit AS ConditionTermUnit,
  TermData._CmmdtyPrcgCndnTrmCnvrsnInput.PricingConditionSourceCurrency AS PrcgCndnTermCnvrsnSourceCrcy,
  TermData._CmmdtyPrcgCndnTrmCnvrsnRslt.PrcgCndnUsedTargetCurrency AS PrcgCndnTermCnvrsnTargetCrcy,
  TermData._CmmdtyPrcgCndnTrmCnvrsnRslt.PrcgCndnUsedExchangeRate AS PrcgCndnUsedExchangeRate,
  TermData._CmmdtyPrcgCndnTrmCnvrsnInput.PrcgConditionFixedExchangeRate AS PrcgConditionFixedExchangeRate,
  TermData._CmmdtyPrcgConditionRootTerm.BasisID AS BasisID,
  TermData._CmmdtyPrcgConditionRootTerm.PriceQuotationType AS PriceQuotationType,
  TermData._CmmdtyPrcgConditionRootTerm.PrcgCndnTrmActualQtanCurrency AS PrcgCndnTrmActualQtanCurrency,
  TermData._CmmdtyPrcgConditionRootTerm.PrcgCndnTrmActlQtanQtyUnit AS PrcgCndnTrmActlQtanQtyUnit,
  TermData.PricingConditionTermFixedRate AS PricingConditionTermFixedRate,
  TermData.PrcgConditionTermFixedRateQty AS PrcgConditionTermFixedRateQty,
  TermData.ConditionTermRate AS ACMPricingRate,
  formData.PrcgCndnFormulaQuantityUnit AS ACMFormulaUoM,
  cast( ' ' as cpet_status_text ) AS CPEConditionTermStatusName
FROM I_CmmdtyPrcgPrcFixationGrpComp AS prcFixGrpData
;

Learn More