I_SUPDMNDMATERIALPLANT

CDS View

Basic View for Material Plant

I_SUPDMNDMATERIALPLANT is a CDS View in S/4HANA. Basic View for Material Plant. It contains 16 fields. 42 CDS views read from this table.

Used by 42 CDS view(s) 16 fields

CDS Views using this table (42)

ViewTypeJoinVDMDescription
I_ARunAnlytsSalesReturns view inner COMPOSITE Return Sales Order
I_ARunAnlytsSlsOrdRejection view inner COMPOSITE Sales Order Rejection
I_ARunOvwSDItem view inner BASIC Basic View for Sales Document Item
I_ARunOvwSTOItem view inner BASIC Basic View for Stock Transport Order Item
I_ARunPriority view inner COMPOSITE Supply Assignment Priority - Basic View
I_ARunSalesOrderItem view inner BASIC ARun relevant Sales Document Item
I_ARunSTOItem view inner BASIC ARun relevant Stock Transport Item
I_ARunSupplyProtection view inner BASIC Supply Protection relevant for Supply Assignment
I_ARunSupProtCnsmpn view inner BASIC Supply Protection Consumption Details
I_SupAssgmtDmndSitn view inner COMPOSITE Supply Assignment Demand Situations
I_SupDmndAllDocCnsmpnCube view inner COMPOSITE Cube View for Planned Independent Requirement Consumption
I_SupDmndAllDocConfBsc view inner BASIC Basic View for Supplier Confirmations
I_SupDmndAllDocGdsIssdDeliv view inner BASIC View for Goods Issued Deliveries
I_SupDmndAllDocOpenDeliveries view inner BASIC View for Open Deliveries
I_SupDmndAllDocPhysStk view inner COMPOSITE View for Physical Stock
I_SupDmndAllDocPlndIndepRqmts view inner BASIC View for Planned Independent Requirements
I_SupDmndAllDocPlndOrdBsc view inner BASIC Basic View for Planned Order
I_SupDmndAllDocPlndOrdComp view inner BASIC View for Planned Order Components
I_SupDmndAllDocPOBsc view inner BASIC Basic View for Purchase Order
I_SupDmndAllDocProdnOrdBsc view inner BASIC Basic View for Production Order
I_SupDmndAllDocProdnOrdCompBsc view inner BASIC Basic View for Production Order Components
I_SupDmndAllDocPurgContr view inner BASIC View for Purchasing Contract
I_SupDmndAllDocPurReqnBsc view inner BASIC Basic View for Purchase Requisition
I_SupDmndAllDocPurReqnComp view inner BASIC View for Sub Contracting Purchase Requisition Components
I_SupDmndAllDocRetDeliv view inner BASIC View for Return Deliveries
I_SupDmndAllDocRetSlsOrd view inner BASIC View for Return Sales Orders
I_SupDmndAllDocRetsSup view inner BASIC View for Returns from PO/STO
I_SupDmndAllDocStkTransptReqn view inner BASIC View for Stock Transport Requisition
I_SupDmndAllDocSTOItmBsc view inner BASIC Basic View for Stock Transport Order
I_SupDmndOvwBatch view inner COMPOSITE Basic view for Assign batches
I_SupDmndOvwDelivery view inner BASIC Basic View for Open Deliveries
I_SupDmndOvwInboundDelivery view inner COMPOSITE Basic View for Confirmations
I_SupDmndOvwNoBatch view inner COMPOSITE Basic View for Non batch fix
I_SupDmndOvwPO view inner BASIC Basic View for Purchase Orders
I_SupDmndOvwPurchaseReqn view inner BASIC Basic View for Purchase Requisitions
I_SupDmndOvwReservation view inner COMPOSITE Basic View for Reservations
I_SupDmndOvwSDItem view inner COMPOSITE Basic View for Sales Document Item
I_SupDmndOvwSTO view inner COMPOSITE Basic View for STO
I_SupDmndOvwTotalSupply view inner COMPOSITE Basic View for Supply Overview
P_SupDmndAllDocDelivComp view inner BASIC
P_SupDmndMntrOvwSD view inner COMPOSITE
P_SupDmndMntrOvwSTO view inner COMPOSITE

Fields (16)

KeyField CDS FieldsUsed in Views
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 30
Division Division 9
FreeDefinedProductAttribute01 FreeDefinedProductAttribute01,FreeDefinedProductAttribute02,FreeDefinedProductAttribute03 8
FreeDefinedProductAttribute02 FreeDefinedProductAttribute02 7
FreeDefinedProductAttribute03 FreeDefinedProductAttribute03 7
IsInternalBatchManaged IsInternalBatchManaged 9
Material Material,Product 3
MaterialGroup MaterialGroup,ProductGroup 16
MaterialType MaterialType,ProductType 22
Plant Plant 3
ProdAvailabilityCheckGroup ProdAvailabilityCheckGroup 1
RetailArticleColor RetailArticleColor 8
RetailArticleMainSize RetailArticleMainSize 8
RetailArticleSecondSize RetailArticleSecondSize 8
SegmentationStrategy SegmentationStrategy 8
SegmentationStrategyScope SegmentationStrategyScope 8 
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Basic View for Material Plant'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ISUPDMNDMAT',
  compiler.compareFilter: true,
  preserveKey:true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL ,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
define view I_SupDmndMaterialPlant
  as select from mara as SupDmndMaterial
    inner join   marc as marc on SupDmndMaterial.matnr = marc.matnr

{
  key marc.matnr                 as Material,
  key marc.werks                 as Plant,
      SupDmndMaterial.mtart      as MaterialType,
      SupDmndMaterial.spart      as Division,
      SupDmndMaterial.fsh_mg_at1 as FreeDefinedProductAttribute01,
      SupDmndMaterial.fsh_mg_at1 as FreeDefinedProductAttribute02,
      SupDmndMaterial.fsh_mg_at1 as FreeDefinedProductAttribute03,
      SupDmndMaterial.color      as RetailArticleColor,
      SupDmndMaterial.size1      as RetailArticleMainSize,
      SupDmndMaterial.size2      as RetailArticleSecondSize,
      SupDmndMaterial.satnr      as CrossPlantConfigurableProduct,
      matkl                      as MaterialGroup,
      marc.xchpf                 as MaterialIsBatchManaged,
      arun_fix_batch             as IsInternalBatchManaged,
      sgt_covs                   as SegmentationStrategy,
      marc.sgt_scope             as SegmentationStrategyScope,
      marc.mtvfp                 as ProdAvailabilityCheckGroup,
      marc.ladgr                 as LoadingGroup
}
where
  (
       SupDmndMaterial.attyp = '00' -- item category
    or SupDmndMaterial.attyp = ' '
    or SupDmndMaterial.attyp = '02'
    or SupDmndMaterial.attyp = '10'
    or SupDmndMaterial.attyp = '11'
    or SupDmndMaterial.attyp = '12'
  )
  and  marc.fsh_mg_arun_req  = '1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARA",
"MARC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More