P_PrcFixationOptnCnvrsnSlsNew

DDL: P_PRCFIXATIONOPTNCNVRSNSLSNEW Type: view_entity COMPOSITE Package: LOG_CMM_PRC_FIX_OPT
15 Fields 4 Data Sources

Price Fixation Option Conversion (sCPE) Sales

P_PrcFixationOptnCnvrsnSlsNew is a Composite CDS View that provides data about "Price Fixation Option Conversion (sCPE) Sales" in SAP S/4HANA. It reads from 4 data sources (I_CmmdtyPrcgConditionFormula, cped_knumvtoguid, vbak, vbap) and exposes 15 fields with key fields SalesDocument, SalesDocumentItem, ConditionType, ConditionTermNumber. Part of development package LOG_CMM_PRC_FIX_OPT.

Data Sources (4)

SourceAliasJoin Type
I_CmmdtyPrcgConditionFormula formula from
cped_knumvtoguid knumvtoguid inner
vbak vbak inner
vbap vbap inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument vbak vbeln SD Sched. Agmt
KEY SalesDocumentItem vbap posnr WBS Element
KEY ConditionType I_CmmdtyPrcgConditionFormula ConditionType Condition type
KEY ConditionTermNumber term PricingConditionTerm Term Number
DocItmCmmdtyPrcgCndnUUID termconv DocItmCmmdtyPrcgCndnUUID Doc. Cond. Item GUID
PricingConditionTerm termconv PricingConditionTerm Term Number
PrcgConditionConversionPlace termconv PrcgConditionConversionPlace Conv. Place
PrcgCndnUsedExchangeRate termconv PrcgCndnUsedExchangeRate
PrcgCndnTermCnvrsnSourceCrcy termconv PrcgCndnUsedSourceCurrency
PrcgCndnTermCnvrsnTargetCrcy termconv PrcgCndnUsedTargetCurrency
PrcgConditionUsedSourceFactor termconv PrcgConditionUsedSourceFactor
PrcgCndnUsedSourceQuantityUnit termconv PrcgCndnUsedSourceQuantityUnit
PrcgConditionUsedTargetFactor termconv PrcgConditionUsedTargetFactor
PrcgCndnUsedTargetQuantityUnit termconv PrcgCndnUsedTargetQuantityUnit
PrcgCndnCnvrsnQtyAdjmtFactor termconv PrcgCndnCnvrsnQtyAdjmtFactor

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_PrcFixationOptnCnvrsnSlsNew.
-- 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 P_PrcFixationOptnCnvrsnSlsNew AS
SELECT
  vbak.vbeln AS SalesDocument,
  vbap.posnr AS SalesDocumentItem,
  formula.ConditionType AS ConditionType,
  term.PricingConditionTerm AS ConditionTermNumber,
  termconv.DocItmCmmdtyPrcgCndnUUID AS DocItmCmmdtyPrcgCndnUUID,
  termconv.PricingConditionTerm AS PricingConditionTerm,
  termconv.PrcgConditionConversionPlace AS PrcgConditionConversionPlace,
  termconv.PrcgCndnUsedExchangeRate AS PrcgCndnUsedExchangeRate,
  termconv.PrcgCndnUsedSourceCurrency AS PrcgCndnTermCnvrsnSourceCrcy,
  termconv.PrcgCndnUsedTargetCurrency AS PrcgCndnTermCnvrsnTargetCrcy,
  termconv.PrcgConditionUsedSourceFactor AS PrcgConditionUsedSourceFactor,
  termconv.PrcgCndnUsedSourceQuantityUnit AS PrcgCndnUsedSourceQuantityUnit,
  termconv.PrcgConditionUsedTargetFactor AS PrcgConditionUsedTargetFactor,
  termconv.PrcgCndnUsedTargetQuantityUnit AS PrcgCndnUsedTargetQuantityUnit,
  termconv.PrcgCndnCnvrsnQtyAdjmtFactor AS PrcgCndnCnvrsnQtyAdjmtFactor
FROM I_CmmdtyPrcgConditionFormula AS formula
INNER JOIN cped_knumvtoguid AS knumvtoguid ON /* join condition not captured in parsed metadata */
INNER JOIN vbak ON /* join condition not captured in parsed metadata */
INNER JOIN vbap ON /* join condition not captured in parsed metadata */
;

Learn More