I_BatchWithValuationVH

DDL: I_BATCHWITHVALUATIONVH Type: view_entity COMPOSITE
32 Fields 1 Data Sources

Batches in Physical Inventory

I_BatchWithValuationVH is a Composite CDS View that provides data about "Batches in Physical Inventory" in SAP S/4HANA. It reads from 1 data source (P_BatchWithValuationVH) and exposes 32 fields with key fields DefinitionOfBatchLevel, Plant, Material, Batch.

Data Sources (1)

SourceAliasJoin Type
P_BatchWithValuationVH P_BatchWithValuationVH from

Annotations (16)

NameValueLevelField
EndUserText.label Batches in Physical Inventory view
AbapCatalog.dataMaintenance #RESTRICTED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey Batch view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #NONE view
Search.searchable true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Consumption.ranked true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY DefinitionOfBatchLevel DefinitionOfBatchLevel
KEY Plant Plant Valuation Area
KEY Material Material Vehicle Model
KEY Batch Batch Lot No.
ValuationType ValuationType Valuation Type
BatchIsMarkedForDeletion BatchIsMarkedForDeletion
MatlBatchIsInRstrcdUseStock MatlBatchIsInRstrcdUseStock Batch restr.
Supplier Supplier Supplier
BatchBySupplier BatchBySupplier Supplier Batch
CountryOfOrigin CountryOfOrigin Country/Region of Origin
RegionOfOrigin RegionOfOrigin Reg. of Origin
MatlBatchAvailabilityDate MatlBatchAvailabilityDate
ShelfLifeExpirationDate ShelfLifeExpirationDate SLED/BBD
ManufactureDate ManufactureDate Date of Manuf.
FreeDefinedDate1 FreeDefinedDate1
FreeDefinedDate2 FreeDefinedDate2
FreeDefinedDate3 FreeDefinedDate3
FreeDefinedDate4 FreeDefinedDate4
FreeDefinedDate5 FreeDefinedDate5
FreeDefinedDate6 FreeDefinedDate6
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
ClfnObjectInternalID ClfnObjectInternalID
BatchExtWhseMgmtInternalId BatchExtWhseMgmtInternalId
_Plant _Plant
_Material _Material
_Supplier _Supplier
_CountryOfOrigin _CountryOfOrigin
_RegionOfOrigin _RegionOfOrigin
_Product _Product
_ClfnObjectClassForKeyDate _ClfnObjectClassForKeyDate
_ClfnObjectCharcValForKeyDate _ClfnObjectCharcValForKeyDate

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 I_BatchWithValuationVH.
-- 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.

CREATE VIEW I_BatchWithValuationVH AS
SELECT
  DefinitionOfBatchLevel,
  Plant,
  Material,
  Batch,
  ValuationType,
  BatchIsMarkedForDeletion,
  MatlBatchIsInRstrcdUseStock,
  Supplier,
  BatchBySupplier,
  CountryOfOrigin,
  RegionOfOrigin,
  MatlBatchAvailabilityDate,
  ShelfLifeExpirationDate,
  ManufactureDate,
  FreeDefinedDate1,
  FreeDefinedDate2,
  FreeDefinedDate3,
  FreeDefinedDate4,
  FreeDefinedDate5,
  FreeDefinedDate6,
  CreationDateTime,
  LastChangeDateTime,
  ClfnObjectInternalID,
  BatchExtWhseMgmtInternalId
FROM P_BatchWithValuationVH
;

Learn More