I_DEMANDDRIVENMATERIALDATA

CDS View

Data related to materials

I_DEMANDDRIVENMATERIALDATA is a CDS View in S/4HANA. Data related to materials. It contains 2 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 2 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_DemandDrivenBOMComponents view from CONSUMPTION Lists out BOM Components
C_DmndDrivenSupDmndList view from CONSUMPTION Lists out Demand Driven MRP Elements
C_DmndDrivenSupOrder view from CONSUMPTION CRUD operation in DDMRP
C_MRPSupplyOrder view from CONSUMPTION MRP Supply Order

Fields (2)

KeyField CDS FieldsUsed in Views
MRPController MRPController 2
MRPType MRPType 1 
@AbapCatalog.sqlViewName: 'IDDMATDATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Data related to materials'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #X, sizeCategory: #XXL, dataClass: #MIXED}
define view I_DemandDrivenMaterialData as select from I_MaterialMRPArea as _mdma
association [1..1] to I_BufferedMaterialPlant as _MaterialPlant on  $projection.Material = _MaterialPlant.Material
                                                                and $projection.Plant    = _MaterialPlant.Plant
{
    key _mdma.Material as Material,
    key _mdma.Plant as Plant,
    key _mdma.MRPArea as MRPArea,
    MRPGroup,
    MRPType,
    MRPController,
    LotSizingProcedure,
    MinimumLotSizeQuantity,
    PlanningTimeFence,
    MaterialMaxStockLevelQuantity,
    ReorderThresholdQuantity,
    SafetyStockQuantity,
    cast ( 'X' as abap.char(1)) as IsMRPAreaExisting,
    _MaterialPlant.PurchasingGroup as PurchasingGroup,
    _MaterialPlant.GoodsReceiptDuration,
    PlannedDeliveryDurationInDays,
    IsPlannedDeliveryTime,
    MaximumLotSizeQuantity,
    LotSizeRoundingQuantity,
    RoundingProfile,
    DeletionIndicator,
    MaterialProcurementProfile,
    cast('' as lgfsb) as DfltStorLocForExtProcmt,
    _Material,
    _MRPType
}
where
  DeletionIndicator <> 'X'
union all select from I_BufferedMaterialPlant as _marc {
    key _marc.Material as Material,
    key _marc.Plant as Plant,
    key _marc.Plant as MRPArea,
    MRPGroup,
    MRPType,
    MRPController,
    LotSizingProcedure,
    MinimumLotSizeQuantity,
    PlanningTimeFence,
    MaterialMaxStockLevelQuantity,
    ReorderThresholdQuantity,
    SafetyStockQuantity,
    IsMRPAreaExisting,
    PurchasingGroup,
    GoodsReceiptDuration,
    PlannedDeliveryDurationInDays,
    '' as IsPlannedDeliveryTime,
    MaximumLotSizeQuantity,
    LotSizeRoundingQuantity,
    RoundingProfile,
    '' as DeletionIndicator,
    MaterialProcurementProfile,
    DfltStorLocForExtProcmt,
    _Material,
    _MRPType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUFFEREDMATERIALPLANT",
"I_MATERIALMRPAREA"
],
"ASSOCIATED":
[
"I_BUFFEREDMATERIALPLANT",
"I_MRPTYPE",
"I_PRODUCT"
],
"BASE":
[
"I_MATERIALMRPAREA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More