P_CmmdtyPrcFixationExerSlsNew

DDL: P_CMMDTYPRCFIXATIONEXERSLSNEW Type: view_entity COMPOSITE

P_CmmdtyPrcFixationExerSlsNew is a Composite CDS View in SAP S/4HANA. It reads from 5 data sources (I_CmmdtyPrcgConditionFormula, cped_knumvtoguid, I_CmmdtyPricingConditionTerm, vbak, vbap) and exposes 16 fields with key fields SalesDocument, SalesDocumentItem, ConditionType, PricingCndnTermExtensionGroup, PricingConditionTerm.

5 data source(s) 16 fields

Data Sources (5)

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

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true 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 (16)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument vbak vbeln
KEY SalesDocumentItem vbap posnr
KEY ConditionType I_CmmdtyPrcgConditionFormula ConditionType
KEY PricingCndnTermExtensionGroup I_CmmdtyPricingConditionTerm PricingCndnTermExtensionGroup
KEY PricingConditionTerm I_CmmdtyPricingConditionTerm PricingConditionTerm
PrcgConditionFormulaInputUUID I_CmmdtyPricingConditionTerm PrcgConditionFormulaInputUUID
PricingConditionTermFixedRate I_CmmdtyPricingConditionTerm PricingConditionTermFixedRate
PrcgConditionTermFixedRateCrcy I_CmmdtyPricingConditionTerm PrcgConditionTermFixedRateCrcy
PrcgConditionTermFixedRateQty I_CmmdtyPricingConditionTerm PrcgConditionTermFixedRateQty
PrcgCndnTermFixedRateQtyUnit I_CmmdtyPricingConditionTerm PrcgCndnTermFixedRateQtyUnit
ConditionTermExtensionUsage I_CmmdtyPricingConditionTerm ConditionTermExtensionUsage
PricingConditionTermQuantity I_CmmdtyPricingConditionTerm PricingConditionTermQuantity
PricingConditionTrmQtyUnit I_CmmdtyPricingConditionTerm PricingConditionTrmQtyUnit
PrcgCndnTermCnvrsnSourceCrcy termconvout PrcgCndnUsedSourceCurrency
PrcgCndnTermCnvrsnTargetCrcy termconvout PrcgCndnUsedTargetCurrency
PrcgCndnTermCnvrsnFxdExchRate termconvin PrcgConditionFixedExchangeRate 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

@VDM.viewType                               : #COMPOSITE
@VDM.private: true

@ObjectModel.usageType.sizeCategory         : #L
@ObjectModel.usageType.serviceQuality       : #B
@ObjectModel.usageType.dataClass            : #TRANSACTIONAL

define view entity P_CmmdtyPrcFixationExerSlsNew // Basic Exercise - Item

  as select from           I_CmmdtyPricingConditionTerm     as term

    inner join             I_CmmdtyPrcgConditionFormula     as formula      on term.DocItmCmmdtyPrcgCndnUUID              = formula.DocItmCmmdtyPrcgCndnUUID

    inner join             cped_knumvtoguid                 as knumvtoguid  on knumvtoguid.docitem_guid                   = formula.DocItmCmmdtyPrcgCndnUUID

    inner join             vbak                             as vbak         on vbak.knumv                                 = knumvtoguid.knumv

    inner join             vbap                             as vbap         on  vbap.vbeln                                = vbak.vbeln
                                                                            and vbap.posnr                                = knumvtoguid.kposn

    left outer to many join I_CmmdtyPrcgCndnTermConversion  as termconvout  on  termconvout.DocItmCmmdtyPrcgCndnUUID      = term.DocItmCmmdtyPrcgCndnUUID 
                                                                            and termconvout.PricingConditionTerm          = term.PricingConditionTerm
                                                                            and termconvout.PrcgConditionConversionPlace  = '0062'
                                                                            and termconvout.PricingConditionTermKey       = term.PricingConditionTermKey
//                                                                            and termconvout.ConditionType                 = term.ConditionType


    left outer to one join I_CmmdtyPrcgCndnTermConversion   as termconvin   on  termconvin.DocItmCmmdtyPrcgCndnUUID       = term.DocItmCmmdtyPrcgCndnUUID 
                                                                            and termconvin.PricingConditionTerm           = term.PricingConditionTerm
                                                                            and termconvin.PrcgConditionConversionPlace   = '0062'
                                                                            and termconvin.PricingConditionTermKey        = termconvout.PricingConditionTermKey
//                                                                            and termconvin.ConditionType                  = termconvout.ConditionType

                                                                            and termconvin.PricingConditionSourceCurrency = termconvout.PricingConditionSourceCurrency
                                                                            and termconvin.PrcgCndnSourceQuantityUnit     = termconvout.PrcgCndnSourceQuantityUnit
                                                                            and termconvin.PricingConditionTargetCurrency = termconvout.PricingConditionTargetCurrency
                                                                            and termconvin.PrcgCndnTargetQuantityUnit     = termconvout.PrcgCndnTargetQuantityUnit
{
  key  vbak.vbeln                                           as SalesDocument,
  key  vbap.posnr                                           as SalesDocumentItem,
  key  formula.ConditionType,
  key  term.PricingCndnTermExtensionGroup,
  key  term.PricingConditionTerm,
       term.PrcgConditionFormulaInputUUID,
       term.PricingConditionTermFixedRate,
       term.PrcgConditionTermFixedRateCrcy,
       term.PrcgConditionTermFixedRateQty,
       term.PrcgCndnTermFixedRateQtyUnit,
       term.ConditionTermExtensionUsage,
       @Semantics: { quantity : {unitOfMeasure: 'PricingConditionTrmQtyUnit'} }
       term.PricingConditionTermQuantity,
       term.PricingConditionTrmQtyUnit,
       termconvout.PrcgCndnUsedSourceCurrency               as PrcgCndnTermCnvrsnSourceCrcy,
       termconvout.PrcgCndnUsedTargetCurrency               as PrcgCndnTermCnvrsnTargetCrcy,
       termconvin.PrcgConditionFixedExchangeRate            as PrcgCndnTermCnvrsnFxdExchRate
}
where
  term.ConditionTermExtensionUsage = 'B'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMMDTYPRCGCNDNTERMCONVERSION",
"I_CMMDTYPRCGCONDITIONFORMULA",
"I_CMMDTYPRICINGCONDITIONTERM",
"CPED_KNUMVTOGUID",
"VBAK",
"VBAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More