P_ACMContractPrcFixNonHedgeSts

DDL: P_ACMCONTRACTPRCFIXNONHEDGESTS SQL: PCTRPRCFIXNHSTS Type: view BASIC
7 Fields 8 Data Sources

Contract Price Fixation Non Hedge Status

P_ACMContractPrcFixNonHedgeSts is a Basic CDS View that provides data about "Contract Price Fixation Non Hedge Status" in SAP S/4HANA. It reads from 8 data sources and exposes 7 fields with key fields TradingContractNumber, TradingContractItem, PricingConditionTerm, ACMPricingAspect, ACMPricingAspectValue.

Data Sources (8)

SourceAliasJoin Type
I_ACMContrPrcAspectBridgeDets Bridge inner
P_ACMContractConditionNmbr ConditionNumber from
I_ACMPricingCndnTypeMapping ConditionTypeMap inner
I_ACMFormulaGrpgGeneralResult Formula_mm inner
I_ACMMappingDocItemData Guid inner
I_CmmdtyPrcgTrmGrpgGenRslt Termgrpout inner
I_CmmdtyPrcgTrmInptGenData Terminput inner
I_ACMMntnPrcgPrcFixNonHedge Terminput_nh inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PCTRPRCFIXNHSTS view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Contract Price Fixation Non Hedge Status view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber P_ACMContractConditionNmbr TradingContractNumber Trading Contract
KEY TradingContractItem P_ACMContractConditionNmbr TradingContractItem Item Number
KEY PricingConditionTerm I_CmmdtyPrcgTrmGrpgGenRslt PricingConditionTerm Term Number
KEY ACMPricingAspect I_ACMContrPrcAspectBridgeDets ACMPricingAspect Pricing Aspect
KEY ACMPricingAspectValue I_ACMContrPrcAspectBridgeDets ACMPricingAspectValue Aspect Counter
ContractMaterial P_ACMContractConditionNmbr ContractMaterial Vehicle Model
PrcgCndnTradingContrCurrency P_ACMContractConditionNmbr PrcgCndnTradingContrCurrency Term Currency

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 P_ACMContractPrcFixNonHedgeSts.
-- 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: PCTRPRCFIXNHSTS

CREATE VIEW P_ACMContractPrcFixNonHedgeSts AS
SELECT
  ConditionNumber.TradingContractNumber AS TradingContractNumber,
  ConditionNumber.TradingContractItem AS TradingContractItem,
  Termgrpout.PricingConditionTerm AS PricingConditionTerm,
  Bridge.ACMPricingAspect AS ACMPricingAspect,
  Bridge.ACMPricingAspectValue AS ACMPricingAspectValue,
  ConditionNumber.ContractMaterial AS ContractMaterial,
  ConditionNumber.PrcgCndnTradingContrCurrency AS PrcgCndnTradingContrCurrency
FROM P_ACMContractConditionNmbr AS ConditionNumber
INNER JOIN I_ACMMappingDocItemData AS Guid ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMFormulaGrpgGeneralResult AS Formula_mm ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyPrcgTrmGrpgGenRslt AS Termgrpout ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyPrcgTrmInptGenData AS Terminput ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMMntnPrcgPrcFixNonHedge AS Terminput_nh ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMContrPrcAspectBridgeDets AS Bridge ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMPricingCndnTypeMapping AS ConditionTypeMap ON /* join condition not captured in parsed metadata */
;

Learn More