C_BatRmngShelfLifeOrProdnDte

DDL: C_BATRMNGSHELFLIFEORPRODNDTE Type: view_entity CONSUMPTION Package: ODATA_MM_IM_OVP
14 Fields 1 Data Sources 1 OData Services

Determine Remaining Shelf Life or Prodcution Date

C_BatRmngShelfLifeOrProdnDte is a Consumption CDS View that provides data about "Determine Remaining Shelf Life or Prodcution Date" in SAP S/4HANA. It reads from 1 data source (I_BatRmngShelfLifeOrProdnDte) and exposes 14 fields with key fields Batch, Plant, StorageLocation, Material. It is exposed through 1 OData service (ASQL_F3366). Part of development package ODATA_MM_IM_OVP.

Data Sources (1)

SourceAliasJoin Type
I_BatRmngShelfLifeOrProdnDte I_BatRmngShelfLifeOrProdnDte from

Annotations (7)

NameValueLevelField
EndUserText.label Determine Remaining Shelf Life or Prodcution Date view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.private false view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3366 ASQL_F3366 C2 NOT_RELEASED

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Batch Batch Lot No.
KEY Plant Plant Valuation Area
KEY StorageLocation StorageLocation StorageLocation
KEY Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
MaterialName MaterialName Material Description
RemainingShelfLife RemainingShelfLife
NumberOfDaysSinceProduction NumberOfDaysSinceProduction
UnitOfMeasure Unit Protected Qty
MatlWrhsStkQtyInMatlBaseUnit MatlWrhsStkQtyInMatlBaseUnit Quantity
MaterialBaseUnit MaterialBaseUnit Valuation Unit
AuthorizationGroup AuthorizationGroup AuthorizGroup
ShelfLifeExpirationDate ShelfLifeExpirationDate SLED/BBD
ManufactureDate ManufactureDate Date of Manuf.

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 C_BatRmngShelfLifeOrProdnDte.
-- 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 C_BatRmngShelfLifeOrProdnDte AS
SELECT
  Batch,
  Plant,
  StorageLocation,
  Material,
  MaterialGroup,
  MaterialName,
  RemainingShelfLife,
  NumberOfDaysSinceProduction,
  cast(UnitOfMeasure as msehi) AS UnitOfMeasure,
  MatlWrhsStkQtyInMatlBaseUnit,
  MaterialBaseUnit,
  AuthorizationGroup,
  ShelfLifeExpirationDate,
  ManufactureDate
FROM I_BatRmngShelfLifeOrProdnDte
;

Learn More