I_AcceptedShortage

DDL: I_ACCEPTEDSHORTAGE SQL: IACCSHORTAGE Type: view BASIC Package: ODATA_PP_MRP
17 Fields 1 Data Sources 1 Associations

MRP Accepted Shortage

I_AcceptedShortage is a Basic CDS View that provides data about "MRP Accepted Shortage" in SAP S/4HANA. It reads from 1 data source (mrp_acc_shortage) and exposes 17 fields with key fields MRPPlant, Material, MRPArea, MaterialShortageProfile, MaterialShortageProfileCount. It has 1 association to related views. Part of development package ODATA_PP_MRP.

Data Sources (1)

SourceAliasJoin Type
mrp_acc_shortage mrp_acc_shortage from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_MRPAvailability _MRPAvailability $projection.MRPPlant = _MRPAvailability.MRPPlant and $projection.Material = _MRPAvailability.Material and $projection.MRPArea = _MRPAvailability.MRPArea and $projection.MRPPlanningSegment = _MRPAvailability.MRPPlanningSegment and $projection.MRPPlanningSegmentType = _MRPAvailability.MRPPlanningSegmentType and $projection.MaterialShortageProfile = _MRPAvailability.MaterialShortageProfile and $projection.MaterialShortageProfileCount = _MRPAvailability.MaterialShortageProfileCount and $projection.MaterialShortageStartDate <= _MRPAvailability.MRPElementAvailyOrRqmtDate and $projection.MaterialShortageEndDate >= _MRPAvailability.MRPElementAvailyOrRqmtDate

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IACCSHORTAGE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MRP Accepted Shortage view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY MRPPlant mrpplant Plant
KEY Material material Vehicle Model
KEY MRPArea mrparea MRP Area
KEY MaterialShortageProfile materialshortageprofile Shortage Prf.
KEY MaterialShortageProfileCount materialshortageprofilecount Counter
KEY MRPPlanningSegment mrpplanningsegmentnumber Plng Segmnt No.
KEY MRPPlanningSegmentType mrpplanningsegmenttype MRP segment
KEY AcceptedShortageUUID acceptshortageid GUID
CreatedByUser createdbyuser User Name
CreationDate creationdate Time Stamp
LastChangeDate lastchangedate Time Stamp
LastChangedByUser lastchangedbyuser User Name
MaterialShortageEndDate materialshortageenddate Time Stamp
MaterialShortageStartDate materialshortagestartdate Time Stamp
MinimumAvailableQuantity minavailableqtyatshortage Shortage Qty
AcceptedShortageNote acceptshortagenote Change Request Note
_MRPAvailability _MRPAvailability

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_AcceptedShortage.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IACCSHORTAGE

CREATE VIEW I_AcceptedShortage AS
SELECT
  MRPPlant,
  Material,
  MRPArea,
  MaterialShortageProfile,
  MaterialShortageProfileCount,
  mrpplanningsegmentnumber AS MRPPlanningSegment,
  MRPPlanningSegmentType,
  acceptshortageid AS AcceptedShortageUUID,
  CreatedByUser,
  CreationDate,
  LastChangeDate,
  LastChangedByUser,
  MaterialShortageEndDate,
  MaterialShortageStartDate,
  minavailableqtyatshortage AS MinimumAvailableQuantity,
  acceptshortagenote AS AcceptedShortageNote
FROM mrp_acc_shortage
LEFT OUTER JOIN I_MRPAvailability AS _MRPAvailability ON MRPPlant = _MRPAvailability.MRPPlant AND Material = _MRPAvailability.Material AND MRPArea = _MRPAvailability.MRPArea AND MRPPlanningSegment = _MRPAvailability.MRPPlanningSegment AND MRPPlanningSegmentType = _MRPAvailability.MRPPlanningSegmentType AND MaterialShortageProfile = _MRPAvailability.MaterialShortageProfile AND MaterialShortageProfileCount = _MRPAvailability.MaterialShortageProfileCount AND MaterialShortageStartDate <= _MRPAvailability.MRPElementAvailyOrRqmtDate AND MaterialShortageEndDate >= _MRPAvailability.MRPElementAvailyOrRqmtDate  -- association [0..*]
;

Learn More