I_BatchTP

DDL: I_BATCHTP SQL: IBATCHTP Type: view TRANSACTIONAL Package: LO_BM_BATCH_BO_AI
43 Fields 1 Data Sources 4 Associations

Draft enabled Batch View

I_BatchTP is a Transactional CDS View that provides data about "Draft enabled Batch View" in SAP S/4HANA. It reads from 1 data source (I_Batch) and exposes 43 fields with key fields Plant, Material, Batch. It has 4 associations to related views. Part of development package LO_BM_BATCH_BO_AI.

Data Sources (1)

SourceAliasJoin Type
I_Batch I_Batch from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Plant _PlantForEdit $projection.PlantForEdit = _PlantForEdit.Plant
[0..1] I_Material _MaterialForEdit $projection.MaterialForEdit = _MaterialForEdit.Material
[0..1] I_BatchRestrictionStatus _BatchRestrictionStatus $projection.BatchRestrictionStatus = _BatchRestrictionStatus.BatchRestrictionStatus
[0..1] I_ChFiExBatchClfn _ChFiExBatchClfn $projection.Plant = _ChFiExBatchClfn.Plant and $projection.Material = _ChFiExBatchClfn.Material and $projection.Batch = _ChFiExBatchClfn.Batch

Annotations (22)

NameValueLevelField
AbapCatalog.sqlViewName IBATCHTP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Draft enabled Batch View view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence LOBM_BATCH_DRAFT view
ObjectModel.entityChangeStateId LastChangeDateTime view
ObjectModel.sapObjectNodeType.name Batch view
ObjectModel.representativeKey Batch view
VDM.private false view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY Plant Plant Valuation Area
KEY Material I_Batch Material Vehicle Model
KEY Batch Batch Lot No.
PlantForEdit Plant Valuation Area
MaterialForEdit I_Batch Material Vehicle Model
BatchForEdit Batch Lot No.
BatchIsMarkedForDeletion BatchIsMarkedForDeletion
MatlBatchIsInRstrcdUseStock MatlBatchIsInRstrcdUseStock Batch restr.
IsSubordinateBatch IsSubordinateBatch
Supplier Supplier Supplier
BatchBySupplier BatchBySupplier Supplier Batch
CountryOfOrigin I_Batch CountryOfOrigin Country/Region of Origin
RegionOfOrigin RegionOfOrigin Reg. of Origin
ShelfLifeExpirationDate ShelfLifeExpirationDate SLED/BBD
ManufactureDate ManufactureDate Date of Manuf.
NextInspectionDate NextInspectionDate
FreeDefinedDate1 FreeDefinedDate1
FreeDefinedDate2 FreeDefinedDate2
FreeDefinedDate3 FreeDefinedDate3
FreeDefinedDate4 FreeDefinedDate4
FreeDefinedDate5 FreeDefinedDate5
FreeDefinedDate6 FreeDefinedDate6
DefinitionOfBatchLevel DefinitionOfBatchLevel
BatchIdentifyingPlant BatchIdentifyingPlant Plant
BatchShortDescription
AuthorizationGroup _Product AuthorizationGroup AuthorizGroup
LastChangeDateTime I_Batch LastChangeDateTime Timestamp
MaterialETag Timestamp
MaterialETag _Product LastChangeDateTime Timestamp
ClfnObjectInternalID ClfnObjectInternalID
InventoryValuationType InventoryValuationType Valuation Type
LastGoodsReceiptDate LastGoodsReceiptDate
MatlBatchAvailabilityDate MatlBatchAvailabilityDate
ExportAndImportProductGroup ExportAndImportProductGroup
_Plant _Plant
_PlantForEdit _PlantForEdit
_Material _Material
_MaterialForEdit _MaterialForEdit
_Supplier _Supplier
_CountryOfOrigin _CountryOfOrigin
_RegionOfOrigin _RegionOfOrigin
_BatchRestrictionStatus _BatchRestrictionStatus
_ChFiExBatchClfn _ChFiExBatchClfn

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_BatchTP.
-- 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: IBATCHTP

CREATE VIEW I_BatchTP AS
SELECT
  Plant,
  I_Batch.Material AS Material,
  Batch,
  Plant AS PlantForEdit,
  I_Batch.Material AS MaterialForEdit,
  Batch AS BatchForEdit,
  BatchIsMarkedForDeletion,
  MatlBatchIsInRstrcdUseStock,
  IsSubordinateBatch,
  Supplier,
  BatchBySupplier,
  I_Batch.CountryOfOrigin AS CountryOfOrigin,
  RegionOfOrigin,
  ShelfLifeExpirationDate,
  ManufactureDate,
  NextInspectionDate,
  FreeDefinedDate1,
  FreeDefinedDate2,
  FreeDefinedDate3,
  FreeDefinedDate4,
  FreeDefinedDate5,
  FreeDefinedDate6,
  DefinitionOfBatchLevel,
  BatchIdentifyingPlant,
  cast(' ' as kztxt_batch preserving type) AS BatchShortDescription,
  _Product.AuthorizationGroup AS AuthorizationGroup,
  I_Batch.LastChangeDateTime AS LastChangeDateTime,
  _Product.LastChangeDateTime AS MaterialETag,
  ClfnObjectInternalID,
  InventoryValuationType,
  LastGoodsReceiptDate,
  MatlBatchAvailabilityDate,
  ExportAndImportProductGroup
FROM I_Batch
LEFT OUTER JOIN I_Plant AS _PlantForEdit ON PlantForEdit = _PlantForEdit.Plant  -- association [0..1]
LEFT OUTER JOIN I_Material AS _MaterialForEdit ON MaterialForEdit = _MaterialForEdit.Material  -- association [0..1]
LEFT OUTER JOIN I_BatchRestrictionStatus AS _BatchRestrictionStatus ON BatchRestrictionStatus = _BatchRestrictionStatus.BatchRestrictionStatus  -- association [0..1]
LEFT OUTER JOIN I_ChFiExBatchClfn AS _ChFiExBatchClfn ON Plant = _ChFiExBatchClfn.Plant AND Material = _ChFiExBatchClfn.Material AND Batch = _ChFiExBatchClfn.Batch  -- association [0..1]
;

Learn More