R_BatchCharacteristicValueTP

DDL: R_BATCHCHARACTERISTICVALUETP Type: view_entity TRANSACTIONAL Package: LO_BM_BATCH_BO_RAP
26 Fields 2 Data Sources

Batch Characteristics Valuation

R_BatchCharacteristicValueTP is a Transactional CDS View that provides data about "Batch Characteristics Valuation" in SAP S/4HANA. It reads from 2 data sources (R_Batch, I_ClfnObjectCharcValForKeyDate) and exposes 26 fields with key fields Material, BatchIdentifyingPlant, Batch, CharcInternalID, ClfnCharcValuePositionNumber. Part of development package LO_BM_BATCH_BO_RAP.

Data Sources (2)

SourceAliasJoin Type
R_Batch Batch inner
I_ClfnObjectCharcValForKeyDate I_ClfnObjectCharcValForKeyDate from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Batch Characteristics Valuation view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Material R_Batch Material Vehicle Model
KEY BatchIdentifyingPlant R_Batch Plant Valuation Area
KEY Batch R_Batch Batch Lot No.
KEY CharcInternalID ObjectCharcValue CharcInternalID Characteristic Internal ID
KEY ClfnCharcValuePositionNumber ObjectCharcValue CharcValuePositionNumber
CharcValueIntervalType ObjectCharcValue CharcValueDependency Code
CharcValue ObjectCharcValue CharcValue Char. Value
CharcFromNumericValue ObjectCharcValue CharcFromNumericValue Value from
CharcFromNumericValueUnit ObjectCharcValue CharcFromNumericValueUnit Internal UoM
CharcToNumericValue ObjectCharcValue CharcToNumericValue Value to
CharcToNumericValueUnit ObjectCharcValue CharcToNumericValueUnit Internal UoM
CharcFromDecimalValue ObjectCharcValue CharcFromDecimalValue LowrBndry Nmrc
CharcToDecimalValue ObjectCharcValue CharcToDecimalValue UprBndry Nmrc
CharcFromAmount ObjectCharcValue CharcFromAmount LowrBndry Crcy
CharcToAmount ObjectCharcValue CharcToAmount UprBndry Crcy
Currency ObjectCharcValue Currency Valuation Crcy
CharcFromDate ObjectCharcValue CharcFromDate LowrBndry Date
CharcToDate ObjectCharcValue CharcToDate UprBndry Date
CharcFromTime ObjectCharcValue CharcFromTime LowrBndry Time
CharcToTime ObjectCharcValue CharcToTime UprBndry Time
CharcAuthor ObjectCharcValue CharacteristicAuthor
LastChangeDateTime R_Batch LastChangeDateTime Timestamp
_BatchCharacteristicTP _BatchCharacteristicTP
_BatchTP _BatchTP
ClassType
_ClfnCharacteristic ObjectCharcValue _Characteristic

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 R_BatchCharacteristicValueTP.
-- 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 R_BatchCharacteristicValueTP AS
SELECT
  Batch.Material AS Material,
  Batch.Plant AS BatchIdentifyingPlant,
  Batch.Batch AS Batch,
  ObjectCharcValue.CharcInternalID AS CharcInternalID,
  ObjectCharcValue.CharcValuePositionNumber AS ClfnCharcValuePositionNumber,
  ObjectCharcValue.CharcValueDependency AS CharcValueIntervalType,
  ObjectCharcValue.CharcValue AS CharcValue,
  ObjectCharcValue.CharcFromNumericValue AS CharcFromNumericValue,
  ObjectCharcValue.CharcFromNumericValueUnit AS CharcFromNumericValueUnit,
  ObjectCharcValue.CharcToNumericValue AS CharcToNumericValue,
  ObjectCharcValue.CharcToNumericValueUnit AS CharcToNumericValueUnit,
  ObjectCharcValue.CharcFromDecimalValue AS CharcFromDecimalValue,
  ObjectCharcValue.CharcToDecimalValue AS CharcToDecimalValue,
  ObjectCharcValue.CharcFromAmount AS CharcFromAmount,
  ObjectCharcValue.CharcToAmount AS CharcToAmount,
  ObjectCharcValue.Currency AS Currency,
  ObjectCharcValue.CharcFromDate AS CharcFromDate,
  ObjectCharcValue.CharcToDate AS CharcToDate,
  ObjectCharcValue.CharcFromTime AS CharcFromTime,
  ObjectCharcValue.CharcToTime AS CharcToTime,
  ObjectCharcValue.CharacteristicAuthor AS CharcAuthor,
  Batch.LastChangeDateTime AS LastChangeDateTime,
  ObjectCharcValue._Characteristic AS _ClfnCharacteristic
FROM I_ClfnObjectCharcValForKeyDate
INNER JOIN R_Batch AS Batch ON /* join condition not captured in parsed metadata */
;

Learn More