What is I_SupDmndAllDocAssgmt in SAP S/4HANA?

I_SupDmndAllDocAssgmt is a composite CDS view in SAP S/4HANA. View for Assignment for all Modes It contains 41 fields.

Which tables does I_SupDmndAllDocAssgmt read from?

I_SupDmndAllDocAssgmt reads data from: I_ARunTimeUnitText, I_ARunAllAssignments, I_ARunCalendarDate, I_CalendarMonthName, I_SupDmndAllDocDemand and more.

What VDM layer is I_SupDmndAllDocAssgmt?

I_SupDmndAllDocAssgmt is classified as a Composite view that combines data from multiple basic views.

I_SupDmndAllDocAssgmt

DDL: I_SUPDMNDALLDOCASSGMT Type: view COMPOSITE Package: VDM_ARUN_ANALYTICS_ALL

41 Fields 6 Data Sources

View for Assignment for all Modes

I_SupDmndAllDocAssgmt is a Composite CDS View that provides data about "View for Assignment for all Modes" in SAP S/4HANA. It reads from 6 data sources and exposes 41 fields with key fields Plant, Material, StorageLocation, Batch, RequirementType. Part of development package VDM_ARUN_ANALYTICS_ALL.

Data Sources (6)

Source	Alias	Join Type
I_ARunTimeUnitText	ARunTimeUnitText	left_outer
I_ARunAllAssignments	Assgmt	from
I_ARunCalendarDate	CalDate	left_outer
I_CalendarMonthName	CalMonth	left_outer
I_SupDmndAllDocDemand	Demand	inner
I_SupDmndOvwPlant	Plant	left_outer

Annotations (11)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AbapCatalog.sqlViewName	ISUPDMNDADASGMTS	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XXL	view
EndUserText.label	View for Assignment for all Modes	view

Fields (41)

Key	Field	Source Table	Source Field	Description
KEY	Plant	I_ARunAllAssignments	Plant	Valuation Area
KEY	Material	I_ARunAllAssignments	Material	Vehicle Model
KEY	StorageLocation	I_ARunAllAssignments	StorageLocation	StorageLocation
KEY	Batch	I_ARunAllAssignments	Batch	Lot No.
KEY	RequirementType	I_ARunAllAssignments	RequirementType	RequirementType
KEY	RequirementDocumentNumber	I_ARunAllAssignments	RequirementDocumentNumber
KEY	RequirementDocumentItem	I_ARunAllAssignments	RequirementDocumentItem
KEY	SupProtTimeBucketUUID	I_ARunAllAssignments	SupProtTimeBucketUUID	Time Bucket UUID
KEY	AssignedSupplyType	I_ARunAllAssignments	AssignedSupplyType	Supply Type
KEY	SupAssgmtSource	I_ARunAllAssignments	SupAssgmtSource	Stock Source
KEY	SupplyNumber	I_ARunAllAssignments	SupplyNumber
KEY	SupplyItem	I_ARunAllAssignments	SupplyItem
KEY	SupplyScheduleLine	I_ARunAllAssignments	SupplyScheduleLine
KEY	RequestedDate	I_ARunAllAssignments	RequestedDate	Valid From
KEY	ProductAvailabilityDate	I_ARunAllAssignments	ProductAvailabilityDate	Mat.Avail.Date
KEY	SupplyDeliveryDate	I_ARunAllAssignments	SupplyDeliveryDate
KEY	SupplyAssignmentStatus	I_ARunAllAssignments	SupplyAssignmentStatus	ARun Status
	RequestedDeliveryDate	I_SupDmndAllDocDemand	RequestedDeliveryDate	Requested Delivery Date
	NumberOfDays	I_ARunAllAssignments	NumberOfDays	Number of Days
	CalendarYear	I_ARunCalendarDate	CalendarYear	Year
	CalendarMonth	I_ARunCalendarDate	CalendarMonth	Calendar Month
	CalendarMonthName	I_CalendarMonthName	CalendarMonthName	Short text
	CalendarWeek
	CalendarDay	I_ARunCalendarDate	CalendarDay	Occur Day in a Month
	AssignedQuantityInBaseUnit	I_ARunAllAssignments	AssignedQuantityInBaseUnit	Assigned Qty
	NormalAssignedQuantityInBsUnt	I_ARunAllAssignments	NormalAssignedQuantityInBsUnt	Assigned Qty
	PreviewAssignedQuantityInBsUnt	I_ARunAllAssignments	PreviewAssignedQuantityInBsUnt	Assigned Qty
	ARunTmpAssignedQuantityInBsUnt	I_ARunAllAssignments	ARunTmpAssignedQuantityInBsUnt	Assigned Qty
	BaseUnit	I_ARunAllAssignments	BaseUnit	Unit of Measure
	MaterialGroup	I_SupDmndAllDocDemand	MaterialGroup	Product Group
	MaterialType	I_SupDmndAllDocDemand	MaterialType	Material Type
	RequirementSegment	I_SupDmndAllDocDemand	RequirementSegment	Req. Segment
	CrossPlantConfigurableProduct	I_SupDmndAllDocDemand	CrossPlantConfigurableProduct	Cross-plant CP
	SupplyProtectionName	I_SupDmndAllDocDemand	SupplyProtectionName
	SalesOrganizationendasSalesOrganization
	DivisionendasDivision
	SalesDistrictendasSalesDistrict
	CustomeraskunnrendasCustomer
	CompanyCodeendasCompanyCode
	NetPriceAmount	I_SupDmndAllDocDemand	NetPriceAmount	Net Price
	DocumentCurrency	I_SupDmndAllDocDemand	DocumentCurrency	Document Currency

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_SupDmndAllDocAssgmt.
-- 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_SupDmndAllDocAssgmt AS
SELECT
  Assgmt.Plant AS Plant,
  Assgmt.Material AS Material,
  Assgmt.StorageLocation AS StorageLocation,
  Assgmt.Batch AS Batch,
  Assgmt.RequirementType AS RequirementType,
  Assgmt.RequirementDocumentNumber AS RequirementDocumentNumber,
  Assgmt.RequirementDocumentItem AS RequirementDocumentItem,
  Assgmt.SupProtTimeBucketUUID AS SupProtTimeBucketUUID,
  Assgmt.AssignedSupplyType AS AssignedSupplyType,
  Assgmt.SupAssgmtSource AS SupAssgmtSource,
  Assgmt.SupplyNumber AS SupplyNumber,
  Assgmt.SupplyItem AS SupplyItem,
  Assgmt.SupplyScheduleLine AS SupplyScheduleLine,
  Assgmt.RequestedDate AS RequestedDate,
  Assgmt.ProductAvailabilityDate AS ProductAvailabilityDate,
  Assgmt.SupplyDeliveryDate AS SupplyDeliveryDate,
  Assgmt.SupplyAssignmentStatus AS SupplyAssignmentStatus,
  Demand.RequestedDeliveryDate AS RequestedDeliveryDate,
  Assgmt.NumberOfDays AS NumberOfDays,
  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,
  Assgmt.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
  Assgmt.NormalAssignedQuantityInBsUnt AS NormalAssignedQuantityInBsUnt,
  Assgmt.PreviewAssignedQuantityInBsUnt AS PreviewAssignedQuantityInBsUnt,
  Assgmt.ARunTmpAssignedQuantityInBsUnt AS ARunTmpAssignedQuantityInBsUnt,
  Assgmt.BaseUnit AS BaseUnit,
  Demand.MaterialGroup AS MaterialGroup,
  Demand.MaterialType AS MaterialType,
  Demand.RequirementSegment AS RequirementSegment,
  Demand.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  Demand.SupplyProtectionName AS SupplyProtectionName,
  case when Demand.SalesOrganization is initial then coalesce( Plant.SalesOrganization, '' ) else Demand.SalesOrganization end as SalesOrganization AS SalesOrganizationendasSalesOrganization,
  case when Demand.Division is initial then coalesce( Plant.Division, '' ) else Demand.Division end as Division AS DivisionendasDivision,
  case when Demand.SalesDistrict is initial then coalesce( Plant.SalesDistrict, '' ) else Demand.SalesDistrict end as SalesDistrict AS SalesDistrictendasSalesDistrict,
  case when Demand.Customer is initial then cast( coalesce( Plant.PlantCustomer, '' ) as kunnr ) else cast( Demand.Customer as kunnr ) end as Customer AS CustomeraskunnrendasCustomer,
  case when Demand.CompanyCode is initial then coalesce( Plant.CompanyCode, '' ) else Demand.CompanyCode end as CompanyCode AS CompanyCodeendasCompanyCode,
  Demand.NetPriceAmount AS NetPriceAmount,
  Demand.DocumentCurrency AS DocumentCurrency
FROM I_ARunAllAssignments AS Assgmt
LEFT OUTER JOIN I_SupDmndOvwPlant AS Plant ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupDmndAllDocDemand AS Demand ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ARunCalendarDate AS CalDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarMonthName AS CalMonth ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ARunTimeUnitText AS ARunTimeUnitText ON /* join condition not captured in parsed metadata */
;

Depth:

I_SupDmndAllDocAssgmt view