V_MaterialLedgerPriceBasic1

DDL: V_MATERIALLEDGERPRICEBASIC1 SQL: VMLPRICEBASIC1 Type: view
13 Fields 5 Data Sources

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.

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 ProdCostEst.No.
KEY Material ckmlhd matnr Vehicle Model
KEY ValuationArea ckmlhd bwkey Valuation Area
KEY InventoryValuationType ckmlhd bwtar Valuation Type
KEY InventorySpecialStockType ckmlhd sobkz Special Stock
KEY InventorySpecialStockValnType ckmlhd kzbws Valuation
KEY IsSupplierStockValuation ckmlhd xobew Vendor stk val.
KEY InventorySpclStkSalesDocument ckmlhd vbeln SD Sched. Agmt
KEY InventorySpclStkSalesDocItm ckmlhd posnr WBS Element
KEY InventorySpecialStockSupplier ckmlhd lifnr Vendor no.
KEY WBSElementInternalID ckmlhd pspnr WBS Element
CompanyCodeCurrency t001 waers Transaction Currency
FiscalYearPeriod

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 V_MaterialLedgerPriceBasic1.
-- 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.
-- SQL view name: VMLPRICEBASIC1
-- Parameters: P_EndDate : sydate

CREATE VIEW V_MaterialLedgerPriceBasic1 AS
SELECT
  hd.kalnr AS CostEstimate,
  hd.matnr AS Material,
  hd.bwkey AS ValuationArea,
  hd.bwtar AS InventoryValuationType,
  hd.sobkz AS InventorySpecialStockType,
  hd.kzbws AS InventorySpecialStockValnType,
  hd.xobew AS IsSupplierStockValuation,
  hd.vbeln AS InventorySpclStkSalesDocument,
  hd.posnr AS InventorySpclStkSalesDocItm,
  hd.lifnr AS InventorySpecialStockSupplier,
  hd.pspnr AS WBSElementInternalID,
  t.waers AS CompanyCodeCurrency,
  concat(cr.bdatj,cr.poper) AS FiscalYearPeriod
FROM ckmlhd AS hd
INNER JOIN t001k AS tk ON /* join condition not captured in parsed metadata */
INNER JOIN t001 AS t ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_period AS fp ON /* join condition not captured in parsed metadata */
INNER JOIN ckmlcr AS cr ON /* join condition not captured in parsed metadata */
;

Learn More