C_AcceptedShortage

DDL: C_ACCEPTEDSHORTAGE SQL: CACCSHORTAGE Type: view CONSUMPTION
17 Fields 1 Data Sources 1 Associations

MRP Accepted Shortage

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

Data Sources (1)

SourceAliasJoin Type
I_AcceptedShortage I_AcceptedShortage from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Material _Material $projection.Material = _Material.Material

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CACCSHORTAGE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label MRP Accepted Shortage view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.deleteEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.writeActivePersistence mrp_acc_shortage view
VDM.viewType #CONSUMPTION 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 MRPPlanningSegment Plng Segmnt No.
KEY MRPPlanningSegmentType MRPPlanningSegmentType MRP segment
KEY MaterialShortageStartDate MaterialShortageStartDate Time Stamp
KEY MaterialShortageEndDate MaterialShortageEndDate Time Stamp
AcceptedShortageUUID AcceptedShortageUUID GUID
AcceptedShortageNote AcceptedShortageNote Change Request Note
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
MinimumAvailableQuantity MinimumAvailableQuantity Shortage Qty
MaterialBaseUnit _Material MaterialBaseUnit Valuation Unit

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 C_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: CACCSHORTAGE

CREATE VIEW C_AcceptedShortage AS
SELECT
  MRPPlant,
  Material,
  MRPArea,
  MaterialShortageProfile,
  MaterialShortageProfileCount,
  MRPPlanningSegment,
  MRPPlanningSegmentType,
  MaterialShortageStartDate,
  MaterialShortageEndDate,
  AcceptedShortageUUID,
  AcceptedShortageNote,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  LastChangeDate,
  MinimumAvailableQuantity,
  _Material.MaterialBaseUnit AS MaterialBaseUnit
FROM I_AcceptedShortage
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
;

Learn More