I_SupDmndAllDocSupProtCnsmpnC

DDL: I_SUPDMNDALLDOCSUPPROTCNSMPNC Type: view COMPOSITE Package: VDM_ARUN_ANALYTICS_ALL
32 Fields 2 Data Sources 1 Associations

Suppy Protection Consumption Details

I_SupDmndAllDocSupProtCnsmpnC is a Composite CDS View (Cube) that provides data about "Suppy Protection Consumption Details" in SAP S/4HANA. It reads from 2 data sources (I_SupDmndOvwPlant, I_ARunSupProtCnsmpn) and exposes 32 fields with key field SupProtPermConsumptionUUID. It has 1 association to related views. Part of development package VDM_ARUN_ANALYTICS_ALL.

Data Sources (2)

SourceAliasJoin Type
I_SupDmndOvwPlant Plant inner
I_ARunSupProtCnsmpn SUPCnsmpn from

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 ISUPDMNDADSPCNSC 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 Suppy Protection Consumption Details view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY SupProtPermConsumptionUUID SupProtPermConsumptionUUID
SupplyProtectionUUID SupplyProtectionUUID UUID
SupplyProtectionName SupplyProtectionName Supply Protection Name
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
ProductAvailabilityDate ProductAvailabilityDate Mat.Avail.Date
StartDate StartDate Time Bucket Start Date
EndDate EndDate Time Bucket End Date
RequirementType RequirementType Requirement Type
SupProtAssignedDocument SupProtAssignedDocument Requirement Document Number
SupProtAssignedDocumentItem SupProtAssignedDocumentItem Requirement Document Item
SupplyProtectionDocumentType SupplyProtectionDocumentType Requirement Type
SupProtConsumedQuantity SupProtConsumedQuantity Consumed Protected Quantity
BaseUnit BaseUnit Base Unit of Measure
CalendarYear CalDate CalendarYear Year
CalendarMonth CalDate CalendarMonth Month
CalendarMonthName CalMonth CalendarMonthName Month
CalendarWeek Week
CalendarDay CalDate CalendarDay Day
Material Material Product
Plant I_ARunSupProtCnsmpn Plant Valuation Area
MaterialGroup I_ARunSupProtCnsmpn MaterialGroup Product Group
MaterialType I_ARunSupProtCnsmpn MaterialType Product Type
CrossPlantConfigurableProduct I_ARunSupProtCnsmpn CrossPlantConfigurableProduct Generic Article
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_SupDmndAllDocSupProtCnsmpnC.
-- 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_SupDmndAllDocSupProtCnsmpnC AS
SELECT
  SupProtPermConsumptionUUID,
  SupplyProtectionUUID,
  SupplyProtectionName,
  RequestedDeliveryDate,
  ProductAvailabilityDate,
  StartDate,
  EndDate,
  RequirementType,
  SupProtAssignedDocument,
  SupProtAssignedDocumentItem,
  SupplyProtectionDocumentType,
  SupProtConsumedQuantity,
  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,
  Material,
  SUPCnsmpn.Plant AS Plant,
  SUPCnsmpn.MaterialGroup AS MaterialGroup,
  SUPCnsmpn.MaterialType AS MaterialType,
  SUPCnsmpn.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  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 I_ARunSupProtCnsmpn AS SUPCnsmpn
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