I_BatchDistinct

DDL: I_BATCHDISTINCT SQL: IBATCHDISTINCT Type: view COMPOSITE Package: LO_BM_BATCH_DB

Batch information by batch key

I_BatchDistinct is a Composite CDS View (Dimension) that provides data about "Batch information by batch key" in SAP S/4HANA. It reads from 1 data source (R_Batch) and exposes 38 fields with key fields Plant, Material, Batch. Part of development package LO_BM_BATCH_DB.

1 data source(s) 38 fields

Data Sources (1)

SourceAliasJoin Type
R_Batch R_Batch from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IBATCHDISTINCT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Batch information by batch key view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey Batch view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY Plant Plant
KEY Material Material
KEY Batch Batch
BatchIsMarkedForDeletion BatchIsMarkedForDeletion
MatlBatchIsInRstrcdUseStock MatlBatchIsInRstrcdUseStock
Supplier Supplier
BatchBySupplier BatchBySupplier
CountryOfOrigin CountryOfOrigin
RegionOfOrigin RegionOfOrigin
MatlBatchAvailabilityDate MatlBatchAvailabilityDate
ShelfLifeExpirationDate ShelfLifeExpirationDate
ManufactureDate ManufactureDate
NextInspectionDate NextInspectionDate
LastGoodsReceiptDate LastGoodsReceiptDate
FreeDefinedDate1 FreeDefinedDate1
FreeDefinedDate2 FreeDefinedDate2
FreeDefinedDate3 FreeDefinedDate3
FreeDefinedDate4 FreeDefinedDate4
FreeDefinedDate5 FreeDefinedDate5
FreeDefinedDate6 FreeDefinedDate6
DefinitionOfBatchLevel DefinitionOfBatchLevel
BatchCertificationDate BatchCertificationDate
CreationDateTime CreationDateTime
LastChangeDateTime LastChangeDateTime
ClfnObjectInternalID ClfnObjectInternalID
BatchExtWhseMgmtInternalId BatchExtWhseMgmtInternalId
StockSegment StockSegment
ExportAndImportProductGroup ExportAndImportProductGroup
InventoryValuationType InventoryValuationType
_Plant _Plant
_Material _Material
_Supplier _Supplier
_CountryOfOrigin _CountryOfOrigin
_RegionOfOrigin _RegionOfOrigin
_Product _Product
_ClfnObjectClassForKeyDate _ClfnObjectClassForKeyDate
_ClfnObjectCharcValForKeyDate _ClfnObjectCharcValForKeyDate
_BatchDistinctText _BatchDistinctText 
@AbapCatalog.sqlViewName: 'IBATCHDISTINCT'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Batch information by batch key'


@AccessControl.authorizationCheck: #CHECK

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass:#MASTER
@ObjectModel.representativeKey: 'Batch'
@ObjectModel.supportedCapabilities: [
  #SQL_DATA_SOURCE,
  #CDS_MODELING_DATA_SOURCE,
  #CDS_MODELING_ASSOCIATION_TARGET,
  #ANALYTICAL_DIMENSION
]

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API 

@Analytics.dataCategory: #DIMENSION

@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations:true

define view I_BatchDistinct as 
select from R_Batch 
{
    @ObjectModel.foreignKey.association: '_Plant'
    key Plant,
    @ObjectModel.foreignKey.association: '_Product'
    key Material,
    @ObjectModel.text.association: '_BatchDistinctText'
    key Batch,
     
    BatchIsMarkedForDeletion,

    MatlBatchIsInRstrcdUseStock,

   
    @ObjectModel.foreignKey.association: '_Supplier'
    Supplier,
    BatchBySupplier,
    @ObjectModel.foreignKey.association: '_CountryOfOrigin'
    CountryOfOrigin,
    @ObjectModel.foreignKey.association: '_RegionOfOrigin'
    RegionOfOrigin,
    
    MatlBatchAvailabilityDate,
    ShelfLifeExpirationDate,
    ManufactureDate,
    NextInspectionDate,
    LastGoodsReceiptDate,
    FreeDefinedDate1,
    FreeDefinedDate2,
    FreeDefinedDate3,
    FreeDefinedDate4,
    FreeDefinedDate5,
    FreeDefinedDate6,
    DefinitionOfBatchLevel,
    BatchCertificationDate,
    @Semantics.systemDateTime.createdAt: true
    CreationDateTime,
    @Semantics.systemDateTime.lastChangedAt: true
    LastChangeDateTime,
    
    ClfnObjectInternalID,
    BatchExtWhseMgmtInternalId,
    StockSegment,
    ExportAndImportProductGroup,
    InventoryValuationType,
 
    _Plant,
    _Material,
    _Supplier,
    _CountryOfOrigin,
    _RegionOfOrigin,
    _Product,
    _ClfnObjectClassForKeyDate,
    _ClfnObjectCharcValForKeyDate,
    _BatchDistinctText
}

Learn More