I_SupDmndAllDocSupProt1C

DDL: I_SUPDMNDALLDOCSUPPROT1C Type: view COMPOSITE Package: VDM_ARUN_ANALYTICS_ALL
31 Fields 2 Data Sources 1 Associations

Supply Protection Assignment Details

I_SupDmndAllDocSupProt1C is a Composite CDS View (Cube) that provides data about "Supply Protection Assignment Details" in SAP S/4HANA. It reads from 2 data sources (P_ARunAssgmtSupType, I_SupDmndOvwPlant) and exposes 31 fields with key fields SupProtTimeBucketUUID, RequestedDate, ProductAvailabilityDate, StartDate, EndDate. It has 1 association to related views. Part of development package VDM_ARUN_ANALYTICS_ALL.

Data Sources (2)

SourceAliasJoin Type
P_ARunAssgmtSupType Assgmt from
I_SupDmndOvwPlant Plant inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _BaseUnit $projection.BaseUnit = _BaseUnit.UnitOfMeasure

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ISUPDMNDADSPT1C view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Supply Protection Assignment Details view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY SupProtTimeBucketUUID Demand SupProtTimeBucketUUID Supply Protection Time Bucket UUID
KEY RequestedDate P_ARunAssgmtSupType RequestedDate
KEY ProductAvailabilityDate P_ARunAssgmtSupType ProductAvailabilityDate Mat.Avail.Date
KEY StartDate Demand StartDate Time Bucket Start Date
KEY EndDate Demand EndDate Time Bucket End Date
KEY RequirementType Demand RequirementType Requirement Type
KEY AssignedSupplyType P_ARunAssgmtSupType AssignedSupplyType Supply Type
KEY SupAssgmtSource P_ARunAssgmtSupType SupAssgmtSource Supply Source
RequestedDeliveryDate Demand StartDate Requested Delivery Date
ARunTmpAssignedQuantityInBsUnt P_ARunAssgmtSupType ARunTmpAssignedQuantityInBsUnt Temporary Assigned Quantity
BaseUnit P_ARunAssgmtSupType BaseUnit Base Unit of Measure
CalendarYear CalDate CalendarYear Year
CalendarMonth CalDate CalendarMonth Month
CalendarMonthName CalMonth CalendarMonthName Month
CalendarWeek Week
CalendarDay CalDate CalendarDay Day
Material Demand Material Product
MaterialGroup Demand MaterialGroup Product Group
MaterialType Demand MaterialType Product Type
CrossPlantConfigurableProduct Demand CrossPlantConfigurableProduct Generic Article
SupplyProtectionName Demand SupplyProtectionName
Plant Demand Plant Valuation Area
SalesOrganization I_SupDmndOvwPlant SalesOrganization Sales Organization
DistributionChannel I_SupDmndOvwPlant DistributionChannel RefDistCh-Cust/Mat.
Division I_SupDmndOvwPlant Division Internal Division ID
SalesDistrict I_SupDmndOvwPlant SalesDistrict Sales District
Customer I_SupDmndOvwPlant PlantCustomer Stock customer
CompanyCode I_SupDmndOvwPlant CompanyCode Receiver Company Code
StorageLocation
SupAssgmtAggrgQtyUnit
_BaseUnit _BaseUnit

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_SupDmndAllDocSupProt1C.
-- 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.

CREATE VIEW I_SupDmndAllDocSupProt1C AS
SELECT
  Demand.SupProtTimeBucketUUID AS SupProtTimeBucketUUID,
  Assgmt.RequestedDate AS RequestedDate,
  Assgmt.ProductAvailabilityDate AS ProductAvailabilityDate,
  Demand.StartDate AS StartDate,
  Demand.EndDate AS EndDate,
  Demand.RequirementType AS RequirementType,
  Assgmt.AssignedSupplyType AS AssignedSupplyType,
  Assgmt.SupAssgmtSource AS SupAssgmtSource,
  Demand.StartDate AS RequestedDeliveryDate,
  Assgmt.ARunTmpAssignedQuantityInBsUnt AS ARunTmpAssignedQuantityInBsUnt,
  Assgmt.BaseUnit AS BaseUnit,
  CalDate.CalendarYear AS CalendarYear,
  CalDate.CalendarMonth AS CalendarMonth,
  CalMonth.CalendarMonthName AS CalendarMonthName,
  concat_with_space( ARunDisplayTimeUnitText, CalDate.CalendarWeek, 1) AS CalendarWeek,
  CalDate.CalendarDay AS CalendarDay,
  Demand.Material AS Material,
  Demand.MaterialGroup AS MaterialGroup,
  Demand.MaterialType AS MaterialType,
  Demand.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  Demand.SupplyProtectionName AS SupplyProtectionName,
  Demand.Plant AS Plant,
  Plant.SalesOrganization AS SalesOrganization,
  Plant.DistributionChannel AS DistributionChannel,
  Plant.Division AS Division,
  Plant.SalesDistrict AS SalesDistrict,
  Plant.PlantCustomer AS Customer,
  Plant.CompanyCode AS CompanyCode,
  cast( '' as lgort_d ) AS StorageLocation,
  cast( ' ' as meins ) AS SupAssgmtAggrgQtyUnit
FROM P_ARunAssgmtSupType AS Assgmt
INNER JOIN I_SupDmndOvwPlant AS Plant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
;

Learn More