I_ACMMntnPrcFutrNonHdgFmla

DDL: I_ACMMNTNPRCFUTRNONHDGFMLA SQL: IACMPRCGCPEDFNH Type: view COMPOSITE

ACM Maintain Pricing Futures Non-Hedge Formula Detail

I_ACMMntnPrcFutrNonHdgFmla is a Composite CDS View that provides data about "ACM Maintain Pricing Futures Non-Hedge Formula Detail" in SAP S/4HANA. It reads from 7 data sources and exposes 19 fields with key fields PrcgConditionFormulaInputUUID, ACMPricingDocItemUUID, ACMPrcgTermInputUUID, ACMPricingConditionType, PricingConditionTerm.

Data Sources (7)

SourceAliasJoin Type
I_ACMPricingCndnTypeMapping condmap inner
I_ACMFormulaGrpgGeneralResult formula_mm from
I_ACMFormulaGrpgGeneralResult formula_mm union
P_GetCPETermInputDataFuture P_GetCPETermInputDataFuture inner
P_GetCPETermInputDataNH P_GetCPETermInputDataNH inner
I_CmmdtyPrcgTrmGrpgGenRslt termgrpout inner
I_CmmdtyPrcgTrmGrpgGenRslt termgrpout inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IACMPRCGCPEDFNH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label ACM Maintain Pricing Futures Non-Hedge Formula Detail view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY PrcgConditionFormulaInputUUID I_CmmdtyPrcgTrmGrpgGenRslt PrcgConditionFormulaInputUUID Doc. Form. GUID
KEY ACMPricingDocItemUUID I_ACMFormulaGrpgGeneralResult ACMPricingDocItemUUID GUID
KEY ACMPrcgTermInputUUID terminput terminput_guid Term Input GUID
KEY ACMPricingConditionType I_ACMFormulaGrpgGeneralResult ACMPricingConditionType Condition Type
KEY PricingConditionTerm I_CmmdtyPrcgTrmGrpgGenRslt PricingConditionTerm Term Number
DerivativeContrSpecification terminput DerivativeContrSpecification DCS ID
ACMPricingMarketIdentifierCode terminput MarketIdentifierCode MIC
MaturityKeyDate terminput MaturityKeyDate Maturity Key Date
ACMPrcgFixationStatus terminput accgo_prc_fix_status Prc. Fix. Status
PrcgConditionFormulaInputUUID Doc. Form. GUID
KEY ACMPricingDocItemUUID I_ACMFormulaGrpgGeneralResult ACMPricingDocItemUUID GUID
KEY ACMPrcgTermInputUUID terminput terminput_guid Term Input GUID
KEY ACMPricingConditionType I_ACMFormulaGrpgGeneralResult ACMPricingConditionType Condition Type
KEY PricingConditionTerm I_CmmdtyPrcgTrmGrpgGenRslt PricingConditionTerm Term Number
DerivativeContrSpecification terminput DerivativeContrSpecification DCS ID
ACMPricingMarketIdentifierCode terminput MarketIdentifierCode MIC
MaturityKeyDate terminput MaturityKeyDate Maturity Key Date
ACMPrcgFixationStatus terminput accgo_prc_fix_status Prc. Fix. Status
CmmdtyOrderRequestStatus terminput accgo_cdote_status CDOTE Status

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_ACMMntnPrcFutrNonHdgFmla.
-- 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: IACMPRCGCPEDFNH

CREATE VIEW I_ACMMntnPrcFutrNonHdgFmla AS
SELECT
  termgrpout.PrcgConditionFormulaInputUUID AS PrcgConditionFormulaInputUUID,
  formula_mm.ACMPricingDocItemUUID AS ACMPricingDocItemUUID,
  terminput.terminput_guid AS ACMPrcgTermInputUUID,
  formula_mm.ACMPricingConditionType AS ACMPricingConditionType,
  termgrpout.PricingConditionTerm AS PricingConditionTerm,
  terminput.DerivativeContrSpecification AS DerivativeContrSpecification,
  terminput.MarketIdentifierCode AS ACMPricingMarketIdentifierCode,
  terminput.MaturityKeyDate AS MaturityKeyDate,
  terminput.accgo_prc_fix_status AS ACMPrcgFixationStatus,
  terminput.accgo_cdote_status AS CmmdtyOrderRequestStatus
FROM I_ACMFormulaGrpgGeneralResult AS formula_mm
INNER JOIN I_CmmdtyPrcgTrmGrpgGenRslt AS termgrpout ON /* join condition not captured in parsed metadata */
INNER JOIN P_GetCPETermInputDataFuture ON /* join condition not captured in parsed metadata */
INNER JOIN P_GetCPETermInputDataNH ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMPricingCndnTypeMapping AS condmap ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_ACMFormulaGrpgGeneralResult
;