R_BatchTextTP

DDL: R_BATCHTEXTTP Type: view_entity TRANSACTIONAL
7 Fields 1 Data Sources 1 Associations

Batch Description

R_BatchTextTP is a Transactional CDS View that provides data about "Batch Description" in SAP S/4HANA. It reads from 1 data source (R_BatchText) and exposes 7 fields with key fields Material, BatchIdentifyingPlant, Batch, Language. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_BatchText _BatchText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Batch Description view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #TEXT view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY BatchIdentifyingPlant BatchIdentifyingPlant Plant
KEY Batch Batch Lot No.
KEY Language Language Report Text Language
BatchDescription BatchDescription Batch Description
_BatchTP _BatchTP
_Language _Language

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_BatchTextTP.
-- 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_BatchTextTP AS
SELECT
  Material,
  BatchIdentifyingPlant,
  Batch,
  Language,
  BatchDescription
FROM R_BatchText AS _BatchText
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [1..1]
;

Learn More