P_PrepaymentDocumentFixedVal

DDL: P_PREPAYMENTDOCUMENTFIXEDVAL SQL: PPPMGDOCFXDVAL Type: view COMPOSITE

Document Fixed Pricing

P_PrepaymentDocumentFixedVal is a Composite CDS View that provides data about "Document Fixed Pricing" in SAP S/4HANA. It reads from 4 data sources (I_PreAgrmtTradingContract, I_PreAgrmtTradingContractStat, I_PreAgrmtTradingContractItem, I_PrepaymentDocFixedValData) and exposes 20 fields with key fields TradingContract, TradingContractItem, PrepaymentRefDocCondition, DocItemCommodityPricingUUID.

4 data source(s) 20 fields

Data Sources (4)

SourceAliasJoin Type
I_PreAgrmtTradingContract Contract from
I_PreAgrmtTradingContractStat ContractApplicationStatus inner
I_PreAgrmtTradingContractItem ContractItem inner
I_PrepaymentDocFixedValData PricingVal inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPPMGDOCFXDVAL view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Document Fixed Pricing view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY TradingContract I_PreAgrmtTradingContract TradingContract
KEY TradingContractItem I_PreAgrmtTradingContractItem TradingContractItem
KEY PrepaymentRefDocCondition I_PreAgrmtTradingContract PrepaymentRefDocCondition
KEY DocItemCommodityPricingUUID I_PrepaymentDocFixedValData DocItemCommodityPricingUUID
PrepaymentRefDocFixedPrice
PrepaymentRefDocFixedPriceCrcy I_PrepaymentDocFixedValData PrepaymentRefDocFixedPriceCrcy
PrcgCndnTermFixationOptnStatus I_PrepaymentDocFixedValData PrcgCndnTermFixationOptnStatus
ConditionTermExtensionUsage
PrepaymentDocCmmdtyMarketQty
PrepaymentDocCmmdtyMktQtyUnit I_PrepaymentDocFixedValData PrepaymentDocCmmdtyMktQtyUnit
PrepaymentRefDocMarketPrice
PrepaymentRefDocMarketPrcCrcy I_PrepaymentDocFixedValData PrepaymentRefDocMarketPrcCrcy
PrepaymentRefDocFuturePrice
PrepaymentRefDocBasisPrice
MarketPriceQuotationPricefromCPEtables
ConditionTermRate
ConditionTermRateCurrency I_PrepaymentDocFixedValData ConditionTermRateCurrency
MTMCalculationGroupBBasis
MTMCalculationGroup
PrepaymentWrkCtrDocPricingOptn I_PrepaymentDocFixedValData PrepaymentWrkCtrDocPricingOptn 
@AbapCatalog.sqlViewName: 'PPPMGDOCFXDVAL'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm                   : #SESSION_VARIABLE
@VDM.private                                : true
@VDM.viewType                               : #COMPOSITE
@ObjectModel.usageType.sizeCategory         : #L
@ObjectModel.usageType.serviceQuality       : #C
@ObjectModel.usageType.dataClass            : #TRANSACTIONAL
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Document Fixed Pricing'
define view P_PrepaymentDocumentFixedVal
  as select from I_PreAgrmtTradingContract     as Contract
  -- Trading Contract Status
    inner join   I_PreAgrmtTradingContractStat as ContractApplicationStatus on ContractApplicationStatus.ContractApplicationStatus = Contract.TrdgContrApplicationStatus
    inner join   I_PreAgrmtTradingContractItem as ContractItem on ContractItem.TradingContract = Contract.TradingContract
    inner join   I_PrepaymentDocFixedValData   as PricingVal   on  PricingVal.PrepaymentRefDocCondition     = Contract.PrepaymentRefDocCondition
                                                               and PricingVal.TradingContract = Contract.TradingContract
                                                               and PricingVal.PrepaymentRefDocConditionItem = ContractItem.TradingContractItem

{
  key Contract.TradingContract               as TradingContract,
  key ContractItem.TradingContractItem       as TradingContractItem,
  key Contract.PrepaymentRefDocCondition     as PrepaymentRefDocCondition,
  key PricingVal.DocItemCommodityPricingUUID as DocItemCommodityPricingUUID,

      --      ACMPrcgCndnTermInputPrice: Fixed Price maintained in Document, in Document Currency
      @Semantics.amount.currencyCode: 'PrepaymentRefDocFixedPriceCrcy'
      PricingVal.PrepaymentRefDocFixedPrice,
      PricingVal.PrepaymentRefDocFixedPriceCrcy,
      PricingVal.PrcgCndnTermFixationOptnStatus,
      --      ConditionTermExtensionUsage: A = Reminder Unpriced Quantity (NPE)
      --                                   B = Fixed Pricing Quantity (FLAT/NFE/NBE)
      PricingVal.ConditionTermExtensionUsage,
      --      PrcgCndnTermFixationOptnStatus: A = No Pricing for this Item
      --                                      B = Partial Pricing for this Item
      --                                      C = Full Pricing for this Item
      @Semantics.quantity.unitOfMeasure: 'PrepaymentDocCmmdtyMktQtyUnit'
      PricingVal.PrepaymentDocCmmdtyMarketQty,
      PricingVal.PrepaymentDocCmmdtyMktQtyUnit,

      --      Market Price/Quotation Price from Quotation tables
      @Semantics.amount.currencyCode: 'PrepaymentRefDocMarketPrcCrcy'
      PricingVal.PrepaymentRefDocMarketPrice,
      PricingVal.PrepaymentRefDocMarketPrcCrcy,

      --      Market Price/Quotation Price from Quotation tables: Future
      @Semantics.amount.currencyCode: 'PrepaymentRefDocFixedPriceCrcy'
      PricingVal.PrepaymentRefDocFuturePrice,

      --      Market Price/Quotation Price from Quotation tables: Basis
      @Semantics.amount.currencyCode: 'PrepaymentRefDocFixedPriceCrcy'
      PricingVal.PrepaymentRefDocBasisPrice,

      --      Market Price/Quotation Price from CPE tables, uncoverted
      @Semantics.amount.currencyCode: 'ConditionTermRateCurrency'
      PricingVal.ConditionTermRate,
      PricingVal.ConditionTermRateCurrency,

      --      MTMCalculationGroup: B = Basis, F = Future
      PricingVal.MTMCalculationGroup,
      cast( case when PricingVal.PrcgCndnTermFixationOptnStatus = 'C'
                 then 'X'
                 else '' end  as boole_d )   as PrepaymentTotalAmtIsFixedPrice,

      PricingVal.PrepaymentWrkCtrDocPricingOptn

}

Learn More