V_MaterialLedgerPriceBasic1

DDL: V_MATERIALLEDGERPRICEBASIC1 SQL: VMLPRICEBASIC1 Type: view

Basic view 1 for material price

V_MaterialLedgerPriceBasic1 is a CDS View that provides data about "Basic view 1 for material price" in SAP S/4HANA. It reads from 5 data sources (ckmlcr, finsc_period, ckmlhd, t001, t001k) and exposes 13 fields with key fields CostEstimate, Material, ValuationArea, InventoryValuationType, InventorySpecialStockType.

5 data source(s) 13 fields

Data Sources (5)

SourceAliasJoin Type
ckmlcr cr inner
finsc_period fp inner
ckmlhd hd from
t001 t inner
t001k tk inner

Parameters (1)

NameTypeDefault
P_EndDate sydate

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName VMLPRICEBASIC1 view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Basic view 1 for material price view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate ckmlhd kalnr
KEY Material ckmlhd matnr
KEY ValuationArea ckmlhd bwkey
KEY InventoryValuationType ckmlhd bwtar
KEY InventorySpecialStockType ckmlhd sobkz
KEY InventorySpecialStockValnType ckmlhd kzbws
KEY IsSupplierStockValuation ckmlhd xobew
KEY InventorySpclStkSalesDocument ckmlhd vbeln
KEY InventorySpclStkSalesDocItm ckmlhd posnr
KEY InventorySpecialStockSupplier ckmlhd lifnr
KEY WBSElementInternalID ckmlhd pspnr
CompanyCodeCurrency t001 waers
FiscalYearPeriod 
@AbapCatalog.sqlViewName: 'VMLPRICEBASIC1'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Basic view 1 for material price'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
define view V_MaterialLedgerPriceBasic1 

  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_EndDate : sydate

  as select from ckmlhd       as hd

    inner join   t001k        as tk on hd.bwkey = tk.bwkey

    inner join   t001         as t  on tk.bukrs = t.bukrs

    inner join   finsc_period as fp on  fp.fiscal_year_variant      = t.periv
                                    and fp.fiscal_period_start_date <= $parameters.P_EndDate
                                    and fp.fiscal_period_end_date   >= $parameters.P_EndDate
                                    and fp.is_special_period        = ''

    inner join   ckmlcr       as cr on  hd.kalnr  =  cr.kalnr
                                    and cr.untper =  '000'
                                    and cr.curtp  =  '10'
                                    and (
       cr.bdatj                                   =  fp.fiscal_year
       and cr.poper                               =  fp.fiscal_period
       or cr.bdatj                                =  fp.fiscal_year
       and cr.poper                               <= fp.fiscal_period
       or cr.bdatj                                <  fp.fiscal_year
     )

{
  key hd.kalnr                  as CostEstimate,
  key hd.matnr                  as Material,
  key hd.bwkey                  as ValuationArea,
  key hd.bwtar                  as InventoryValuationType,
  key hd.sobkz                  as InventorySpecialStockType,
  key hd.kzbws                  as InventorySpecialStockValnType,
  key hd.xobew                  as IsSupplierStockValuation,
  key hd.vbeln                  as InventorySpclStkSalesDocument,
  key hd.posnr                  as InventorySpclStkSalesDocItm,
  key hd.lifnr                  as InventorySpecialStockSupplier,
  key hd.pspnr                  as WBSElementInternalID,

      t.waers                   as CompanyCodeCurrency,

      concat(cr.bdatj,cr.poper) as FiscalYearPeriod
      
}  
where ( cr.sdm_version is initial )

Learn More