I_SDMAREAOFRESPONSIBILITY

CDS View

MRP SDM Area of Responsibility

I_SDMAREAOFRESPONSIBILITY is a CDS View in S/4HANA. MRP SDM Area of Responsibility. It contains 3 fields. 48 CDS views read from this table.

Used by 48 CDS view(s) 3 fields

CDS Views using this table (48)

ViewTypeJoinVDMDescription
C_BufBelowReorderPtIndCht view_entity inner CONSUMPTION Replenishment Planning Card
C_BufBelowSftyStkIndCht view_entity inner CONSUMPTION Replenishment Execution Card
C_CacheMRPMfgOrder view inner CONSUMPTION MRP Manufacturing Orders
C_ConvertPlannedOrder view inner CONSUMPTION Convert Planned Orders
C_DemandDrivenBOMComponents view inner CONSUMPTION Lists out BOM Components
C_DemandDrivenReplnmt view inner CONSUMPTION Demand Driven Replenishment
C_DmndDrivenSupDmndList view inner CONSUMPTION Lists out Demand Driven MRP Elements
C_MaterialCoverage view inner CONSUMPTION MRP Material Coverage Net Segment
C_MaterialCoverageIndivSegment view inner CONSUMPTION MRP Material Coverage Individual Segment
C_MRPAreaValHelp view_entity inner CONSUMPTION MRP Area Value Help
C_MRPChangeRequestList view_entity inner CONSUMPTION List of MRP Change Requests
C_MRPControllerByAreaOfRespyVH view_entity from CONSUMPTION MRP Controller By Area of Responsibility
C_MRPGroupValHelp view_entity inner CONSUMPTION MRP Group Value Help
C_MRPPurReqForHandoverSts view inner CONSUMPTION MRP PurchRequisition for Handover Status
C_PlannedOrderMRPAreaVH view_entity inner CONSUMPTION MRP Area
C_PlannedOrders view inner CONSUMPTION Manage Planned Orders
C_PlannedOrderTP view_entity inner CONSUMPTION Manage Planned Orders
C_PlannedOrderWBSElementVH view_entity inner CONSUMPTION Planned Order WBS Element
C_PlannedOrderWorkCenterVH view_entity inner CONSUMPTION Work Center for Planned Order
C_PlantByAreaOfRespyVH view_entity inner CONSUMPTION Plant By Area Of Responsibility VH
C_PlndOrdMRPControllerByAORVH view_entity from CONSUMPTION MRP Controller by Area of Responsibility
C_PlndOrdPlantByAreaOfRespyVH view_entity inner CONSUMPTION Plant by Area of Responsibility
C_ProductInformation view inner CONSUMPTION Product Information of Materials
C_SchedProdnMRPAreaVH view_entity inner CONSUMPTION Value Help for MRP Area
C_SchedProdnMRPControllerVH view_entity from CONSUMPTION Value Help for MRP Controller
C_SchedProdnOpSetupGroupVH view inner CONSUMPTION Value Help for Setup Group
C_SchedProdnPlantVH view_entity inner CONSUMPTION Value Help for Plant
C_SchedProdnProductGroupVH view_entity inner CONSUMPTION Value Help for Product Group
C_SchedProdnProductVH view inner CONSUMPTION VH - Product
C_SchedProdnSetupGrpCategoryVH view inner CONSUMPTION Value Help for Setup Group Category
C_SDMAreaOfResponsibility view_entity from CONSUMPTION MRP SDM Area of Responsibility
I_CapEvalByAreaOfRespy view inner COMPOSITE Work Center By Area Of Responsibility
I_DDHistlBufferedProduct view_entity from COMPOSITE DD Buffered Products
I_DDHistlBufferedProduct view_entity union_all COMPOSITE DD Buffered Products
I_MassMaintCapAreaOfRespy view_entity inner COMPOSITE Work Center Capacity AOR
I_MassMaintCapAreaOfRespyPlant view_entity union COMPOSITE Unique plants Workcenter Capacity AOR
I_MaterialTimeDependentStock view_entity inner COMPOSITE List of Time Dependent Stock Materials
I_SchedWorklistOperation view inner COMPOSITE Operations worklist for Sched Prodn
P_AreaOfRespyBOOOperation view_entity inner COMPOSITE Area Of Responsibility BOO Operation
P_DDMATERIAL view inner COMPOSITE Demand Driven Material
P_DemandDrivenExtdProduct view_entity inner COMPOSITE Demand Driven Product Details
P_MaterialPlantAreaOfRespy view_entity inner COMPOSITE Material and Plant data
P_MntrWrkCtrByAreaOfRespy view_entity inner COMPOSITE Work Centers By Area Of Responsibility
P_MRPAreaByAreaOfRespy view_entity from CONSUMPTION MRP Areas By Area of Responsibility
P_MRPAreaByAreaOfRespy2 view_entity from CONSUMPTION MRP Area of Responsibility
P_SchedProdnAORIndustryType view inner COMPOSITE To determine industry type of user's AOR
P_SchedProdnOperationBasic view inner COMPOSITE Operation Basic Data
P_WrkCtrMntrAlternateWrkCtr view_entity inner CONSUMPTION Work Centers By Area Of Responsibility

Fields (3)

KeyField CDS FieldsUsed in Views
KEY MRPController MRPController 7
KEY Plant MRPArea,Plant 7
KEY UserID UserID 4 
@AbapCatalog.sqlViewName: 'ISDMAOR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_MRPController']
@EndUserText.label: 'MRP SDM Area of Responsibility'
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #S, dataClass: #CUSTOMIZING }
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view I_SDMAreaOfResponsibility 
 as select from sdm_aor

  association [1..1] to I_MRPController as _MRPController on  $projection.Plant         = _MRPController.Plant
                                                          and $projection.MRPController = _MRPController.MRPController
{
  key sdm_aor.werks as Plant,
  key sdm_aor.dispo as MRPController,
  key sdm_aor.uname as UserID,
      
      _MRPController
}  where sdm_aor.dispo  != ''

Learn More