I_BatchManagedMaterialVH

DDL: I_BATCHMANAGEDMATERIALVH SQL: IBTCHMGMNTMAT Type: view COMPOSITE

Material Enabled for Batches

I_BatchManagedMaterialVH is a Composite CDS View that provides data about "Material Enabled for Batches" in SAP S/4HANA. It reads from 1 data source (I_Material) and exposes 16 fields with key field Material.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_Material I_Material from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IBTCHMGMNTMAT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Material Enabled for Batches view
AccessControl.authorizationCheck #CHECK view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Material view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private false view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Material I_Material Material
MaterialType MaterialType
MaterialGroup MaterialGroup
MaterialBaseUnit MaterialBaseUnit
MaterialGrossWeight MaterialGrossWeight
MaterialNetWeight MaterialNetWeight
MaterialWeightUnit MaterialWeightUnit
MaterialManufacturerNumber MaterialManufacturerNumber
MaterialManufacturerPartNumber MaterialManufacturerPartNumber
AuthorizationGroup AuthorizationGroup
_Text _Text
_MaterialType _MaterialType
_MaterialGroup _MaterialGroup
_BaseUnit _BaseUnit
_WeightUnit _WeightUnit
_MaterialPlant _MaterialPlant 
@AbapCatalog.sqlViewName: 'IBTCHMGMNTMAT'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Material Enabled for Batches'

@AccessControl.authorizationCheck: #CHECK

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'Material'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #M
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: false
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_BatchManagedMaterialVH 
as select from I_Material 
left outer to one join P_BatchManagedMaterialPlantVH on I_Material.Material = P_BatchManagedMaterialPlantVH.Material
{
    key I_Material.Material, 
          
        MaterialType,
        MaterialGroup,
        
        @Semantics.unitOfMeasure: true
        @ObjectModel.foreignKey.association: '_BaseUnit'
        MaterialBaseUnit,
                        
        @Semantics.quantity.unitOfMeasure: 'MaterialWeightUnit'              
        @DefaultAggregation: #NONE
        MaterialGrossWeight,
        
        @Semantics.quantity.unitOfMeasure: 'MaterialWeightUnit'
        @DefaultAggregation: #NONE
        MaterialNetWeight,  
                    
        @Semantics.unitOfMeasure: true
        @ObjectModel.foreignKey.association: '_WeightUnit'
        MaterialWeightUnit,
                      
        MaterialManufacturerNumber,
        MaterialManufacturerPartNumber, 
        AuthorizationGroup,
        
        _Text,
        _MaterialType,
        _MaterialGroup,
        _BaseUnit,
        _WeightUnit,
        _MaterialPlant
        
} where IsBatchManagementRequired = 'X' or P_BatchManagedMaterialPlantVH.Material is not null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIAL",
"P_BATCHMANAGEDMATERIALPLANTVH"
],
"ASSOCIATED":
[
"I_MATERIALGROUP",
"I_MATERIALPLANT",
"I_MATERIALTEXT",
"I_MATERIALTYPE",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_MATERIAL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More