I_MATERIALPLANT

CDS View

Material Plant

I_MATERIALPLANT is a CDS View in S/4HANA. Material Plant. It contains 5 fields. 27 CDS views read from this table.

Used by 27 CDS view(s) 5 fields

CDS Views using this table (27)

ViewTypeJoinVDMDescription
C_InspPlanMatlPlantVH view from CONSUMPTION Material-Plant Value Help
C_InvtryTurnoverAnlysDets view from CONSUMPTION Inventory Turnover Analysis Details
C_MaintCompPlantWithStockVH view_entity from CONSUMPTION Plant with stock
C_MassUpdtMaterialVH view inner CONSUMPTION Material Value Help
C_MfgMaterialVH view from CONSUMPTION Mfg Material Value Help
C_MM_MaterialValueHelp view from CONSUMPTION Material Value Help
C_MngProdnRtgPlantMaterialVH view_entity from CONSUMPTION Plant Materials of a Shop Floor Routing
C_ProdnVersMatlPlntVH view from CONSUMPTION Material Plant Value Help
C_PurOrdMaintainUoMValHelp view left_outer CONSUMPTION Value Help Unit of measure
C_ResvnDocMaterialByPlantVH view from CONSUMPTION Material by Plant Value Help
C_RptvManufacturingProductVH view inner CONSUMPTION Repetitive Manufacturing Product
C_SalesDocumentItemPlantVH view from CONSUMPTION Plant
C_SSPProductVH view inner CONSUMPTION Product (Material) Value help for SSP PR
C_SubcontrgBatchVH view inner CONSUMPTION Batch Value Help
I_BatchVH view inner COMPOSITE Batch
I_EvaltCapWrkCtrGrpAreaOfRespy view_entity inner COMPOSITE Work Center Group Area of Responsibility
I_JITMaterialPlant view from COMPOSITE Material Plant info for JIT calls
I_MaterialStorLocMRPArea view from COMPOSITE Material Storage Location MRP Area Assignment
I_PlantMaterialCount view from COMPOSITE Count of materials in plant
I_RO_SAFTProduct view inner COMPOSITE RO SAFT Products
I_WrkCtrCapByAreaOfRespy view inner COMPOSITE Work Center By Area Of Responsibility
P_DDOrderDetails view inner CONSUMPTION
P_JITStockAvailabilityAnlys view from COMPOSITE
P_MaterialPlantAreaOfRespy view_entity from COMPOSITE Material and Plant data
P_MaterialPriceVariance view inner CONSUMPTION Material Price Variance
P_SchedProdnAORIndustryType view inner COMPOSITE
P_SpecAssignedMatlForKeyDate view left_outer COMPOSITE

Fields (5)

KeyField CDS FieldsUsed in Views
KEY Material Material 8
KEY Plant Plant 16
_Material _Material 1
MaterialSafetyStockQty MaterialSafetyStockQty 1
MRPController MRPController 1 
@AbapCatalog: {
  sqlViewName: 'IMATERIALPLANT',
  preserveKey: true
}
@Analytics: { dataCategory: #DIMENSION }
@VDM.viewType: #BASIC
@EndUserText.label: 'Material Plant'
@ObjectModel.representativeKey: 'Plant'
@Search.searchable: true
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl: {
    authorizationCheck: #CHECK,
    privilegedAssociations: '_MRPController'
}
@Metadata.allowExtensions:true


define view I_MaterialPlant
  as select from marc
  association [1..1] to I_Material                  as _Material                      on  $projection.Material = _Material.Material
  association [0..1] to I_MRPController             as _MRPController                 on  $projection.Plant         = _MRPController.Plant
                                                                                      and $projection.MRPController = _MRPController.MRPController
  association [0..*] to I_MaterialText              as _MaterialText                  on  $projection.Material = _MaterialText.Material
  association [0..1] to I_Matlabcclassification     as _MaterialABCClassification     on  $projection.MaterialABCClassification = _MaterialABCClassification.MaterialABCClassification

  association [0..*] to I_Matlabcclassificationtext as _MaterialABCClassificationDesc on  $projection.MaterialABCClassification = _MaterialABCClassificationDesc.MaterialABCClassification

{
      //--[ GENERATED:012:GFBfhxvv7jY4jTYbPy8kum

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_MaterialStdVH',
                     element: 'Material' }
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_Material'
      @ObjectModel.text.association: '_MaterialText'
  key marc.matnr as Material,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
  key marc.werks as Plant,

      dispo      as MRPController,
      eisbe      as MaterialSafetyStockQty,
      lgfsb      as DfltStorLocForExtProcmt,
      sauft      as RptvMfgIsAllwd,
         
      //ABC Classification

      @ObjectModel.foreignKey.association: '_MaterialABCClassification'
      maabc      as MaterialABCClassification,
      _MaterialABCClassification,
      _MRPController,
      _MaterialText,
      _MaterialABCClassificationDesc,
      _Material

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARC"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_MATERIALTEXT",
"I_MATLABCCLASSIFICATION",
"I_MATLABCCLASSIFICATIONTEXT",
"I_MRPCONTROLLER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More