P_ProductMasterLeadTime

DDL: P_PRODUCTMASTERLEADTIME SQL: PPRDMASTERLT Type: view CONSUMPTION

Lead Time Details from Product Master

P_ProductMasterLeadTime is a Consumption CDS View that provides data about "Lead Time Details from Product Master" in SAP S/4HANA. It reads from 5 data sources (I_BufferedMaterialPlant, I_BufferedMaterialPlant, I_MaterialMRPArea, I_MatlProcurementProfile, I_MatlProcurementProfile) and exposes 6 fields with key fields Material, ProductionPlant, MRPArea, ProductionPlant, MRPArea.

5 data source(s) 6 fields

Data Sources (5)

SourceAliasJoin Type
I_BufferedMaterialPlant _marc from
I_BufferedMaterialPlant _marc union_all
I_MaterialMRPArea _mdma inner
I_MatlProcurementProfile _prfl left_outer
I_MatlProcurementProfile _prfl left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPRDMASTERLT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Lead Time Details from Product Master view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Material I_BufferedMaterialPlant Material
KEY ProductionPlant I_BufferedMaterialPlant Plant
KEY MRPArea I_MaterialMRPArea MRPArea
MaterialasMaterial
KEY ProductionPlant I_BufferedMaterialPlant Plant
KEY MRPArea I_BufferedMaterialPlant Plant 
@AbapCatalog.sqlViewName: 'PPRDMASTERLT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Lead Time Details from Product Master'
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ClientHandling: {algorithm: #SESSION_VARIABLE }
define view P_ProductMasterLeadTime as select from    I_BufferedMaterialPlant           as _marc
    inner join      I_MaterialMRPArea        as _mdma on  _marc.Material = _mdma.Material
                                                      and _marc.Plant   = _mdma.Plant
    left outer join I_MatlProcurementProfile as _prfl on  _marc.Plant                      = _prfl.Plant
                                                      and _marc.MaterialProcurementProfile = _prfl.MaterialProcurementProfile
{
  key _marc.Material          as Material,
  key _marc.Plant            as ProductionPlant,
  key _mdma.MRPArea          as MRPArea,
      case
       when _marc.ProcurementType = 'F'
       then
        case
        when _prfl.MaterialProcurementExtType = '7'
        then 'T'
        else
        'B'
        end
       else
       'M'
      end                    as ReplenishmentType,

      case
              when _marc.ProcurementType = 'F'
              then
                case
                when _mdma.PlannedDeliveryDurationInDays is not null
                 and _mdma.PlannedDeliveryDurationInDays <> 0
                then
                _mdma.PlannedDeliveryDurationInDays
                else
                 _marc.PlannedDeliveryDurationInDays
                end
              else
              _marc.MaterialPlannedProductionDurn
      end                    as IndividualLeadTime

}
union all select from I_BufferedMaterialPlant           as _marc
  left outer join     I_MatlProcurementProfile as _prfl on  _marc.Plant                      = _prfl.Plant
                                                        and _marc.MaterialProcurementProfile = _prfl.MaterialProcurementProfile
{
  key _marc.Material          as Material,
  key _marc.Plant            as ProductionPlant,
  key _marc.Plant            as MRPArea,
      case
       when _marc.ProcurementType = 'F'
       then
        case
        when _prfl.MaterialProcurementExtType = '7'
        then 'T'
        else
        'B'
        end
       else
       'M'
      end                    as ReplenishmentType,

      case
              when _marc.ProcurementType = 'F'
              then
                 _marc.PlannedDeliveryDurationInDays
              else
              _marc.MaterialPlannedProductionDurn
      end                    as IndividualLeadTime
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUFFEREDMATERIALPLANT",
"I_MATERIALMRPAREA",
"I_MATLPROCUREMENTPROFILE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More