P_INVOICEPRICEVARIANCE2

CDS View

P_INVOICEPRICEVARIANCE2 is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_InvoicePriceVariance view from CONSUMPTION 
@AbapCatalog.sqlViewName: 'PMMINVPRCVARC2'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType : #CONSUMPTION
@VDM.private: true
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view P_InvoicePriceVariance2
with parameters 
      P_DisplayCurrency : displaycurrency,
      P_Material        : matnr,
      P_StartDate       : vdm_validitystart,
      P_EndDate         : vdm_validityend 
 
as select from P_InvoicePriceVariance1( P_Material : $parameters.P_Material, P_StartDate: $parameters.P_StartDate,
                                                         P_EndDate: $parameters.P_EndDate    ) as InvoicePriceVariance
association [0..1] to I_BR_Domain  as _DocText   on $projection.DocNumber               = _DocText.DomainValue
                                                           and _DocText.Name            = 'MM_A_DOCTYPE'
                                                           and _DocText.Language        = $session.system_language

{
       
    key InvoicePriceVariance.PurchaseOrder,
    key InvoicePriceVariance.PurchaseOrderItem, 
    key InvoicePriceVariance.MaterialDocumentYear,
    key InvoicePriceVariance.MaterialDocument,
    key InvoicePriceVariance.MaterialDocumentItem,
        
    InvoicePriceVariance.PostingDate,
    PurchasingOrganization,
    PurchasingGroup,
    PurchaseOrderType,
    InvoicePriceVariance.CompanyCode,
    Supplier,

    Material,
    MaterialGroup,
    Plant,
    
    cast('04' as mm_a_doctype ) as DocNumber,
    
    Currency,
    cast( :P_DisplayCurrency as displaycurrency ) as DisplayCurrency,
    
    @Semantics.unitOfMeasure: true
    BaseUnit,
    @Semantics.unitOfMeasure: true
    OrderPriceUnit,

    QtyInPurchaseOrderPricUnit,
    


    
    QtyInPurchaseOrderPriceUnit,
        
   cast(currency_conversion( 
       amount             => NetPriceAmount,
       source_currency    => Currency,
       target_currency    =>  :P_DisplayCurrency,
       exchange_rate_date => PostingDate,
       exchange_rate_type => 'M',
       error_handling => 'FAIL_ON_ERROR' 
    ) as mm_pur_ana_de_invoice_amount) as NetPriceAmount,    
     
   InvoicePriceVariance.InvoiceAmountInDocCurrency,     
   cast(currency_conversion( 
       amount             => InvoicePriceVariance.InvoiceAmountInDocCurrency,
       source_currency    => InvoicePriceVariance.Currency,
       target_currency    =>  :P_DisplayCurrency,
       exchange_rate_date => InvoicePriceVariance.PostingDate,
       exchange_rate_type => 'M',
       error_handling => 'FAIL_ON_ERROR' 
    ) as mm_pur_ana_de_invoice_amount) as InvoiceAmtInDisplayCurrency,
    
    NetPriceQuantity,
    Quantity,
    @Semantics.unitOfMeasure: true
    PurchaseOrderQuantityUnit,
    
      _Material,
      _MaterialGroup,
      _Plant,
      _Supplier,
      _PurchasingOrganization,
      _PurchasingGroup,
      _CompanyCode,
      _DocText
    

}              
where PostingDate between $parameters.P_StartDate and $parameters.P_EndDate

Learn More