V_MaterialLedgerPriceBasic2

DDL: V_MATERIALLEDGERPRICEBASIC2 SQL: VMLPriceBasic2 Type: view
13 Fields 1 Data Sources

Basic view 2 for material price

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

Data Sources (1)

SourceAliasJoin Type
V_MaterialLedgerPriceBasic1 V_MaterialLedgerPriceBasic1 from

Parameters (1)

NameTypeDefault
P_EndDate sydate

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName VMLPriceBasic2 view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Basic view 2 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 CostEstimate Cost EstimateNo
KEY Material Material Vehicle Model
KEY ValuationArea ValuationArea Valuation Area
KEY InventoryValuationType InventoryValuationType Valuation Type
KEY InventorySpecialStockType InventorySpecialStockType Special Stock Type
KEY InventorySpecialStockValnType InventorySpecialStockValnType Valuation
KEY IsSupplierStockValuation IsSupplierStockValuation Vendor stk val.
KEY InventorySpclStkSalesDocument InventorySpclStkSalesDocument SD Sched. Agmt
KEY InventorySpclStkSalesDocItm InventorySpclStkSalesDocItm WBS Element
KEY InventorySpecialStockSupplier InventorySpecialStockSupplier Vendor no.
KEY WBSElementInternalID WBSElementInternalID WBS Internal ID
CompanyCodeCurrency CompanyCodeCurrency Local 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_MaterialLedgerPriceBasic2.
-- 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: VMLPriceBasic2
-- Parameters: P_EndDate : sydate

CREATE VIEW V_MaterialLedgerPriceBasic2 AS
SELECT
  CostEstimate,
  Material,
  ValuationArea,
  InventoryValuationType,
  InventorySpecialStockType,
  InventorySpecialStockValnType,
  IsSupplierStockValuation,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InventorySpecialStockSupplier,
  WBSElementInternalID,
  CompanyCodeCurrency,
  max(FiscalYearPeriod) AS FiscalYearPeriod
FROM V_MaterialLedgerPriceBasic1
;

Learn More