C_SupAssgmtDmndMntrAssgmtDets

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_SupAssgmtDmndMntrAssgmtDets.
-- 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 C_SupAssgmtDmndMntrAssgmtDets AS
SELECT
  ARunUUID,
  SupplyNumber,
  SupplyItem,
  SupplyScheduleLine,
  Batch,
  StorageLocation,
  AssignedSupplyType,
  ARunDocumentItemUniqueID,
  RequirementType,
  Material,
  Plant,
  SupplyAssignmentStatus,
  SupplyDeliveryDate,
  RequirementDocumentNumber,
  RequirementDocumentItem,
  AssignedQuantityInBaseUnit,
  BaseUnit,
  RequirementSegment,
  StockSegment,
  cast ('' as abap.char( 120 )) AS InternalComment,
  cast ( '000' as arun_dalpct_by ) AS QtyToBeUnassignedInPct,
  cast( 0 as arun_dalmng_by) AS ToBeUnassignedQtyInBaseUnit,
  cast ('' as abap.char( 1 )) AS RqmtDocItemsAreSelected,
  cast ('' as abap.sstring( 1332 )) AS RqmtDocItemInclsnListValue,
  cast ('' as abap.sstring( 1332 )) AS RqmtDocItemExclsnListValue,
  cast ('' as abap.char( 1 )) AS SupAssignmentsAreSelected,
  cast ('' as abap.sstring( 1332 )) AS SupAssgmtInclusionListValue,
  cast ('' as abap.sstring( 1332 )) AS SupAssgmtExclusionListValue,
  _Demand.RequestedDeliveryDate AS RequestedDeliveryDate,
  _Demand.Customer AS Customer,
  cast('' as abap.char( 4 )) AS Issue,
  cast( '' as sit2_de_st_id ) AS SitnDefinitionID,
  _Demand.SupAssgmtSupAvailySts AS SupAssgmtSupAvailySts,
  _Demand.FashionCancelDate AS FashionCancelDate,
  _Demand.FashionCancelDateHorizon AS FashionCancelDateHorizon,
  _Demand.MaterialGroup AS MaterialGroup,
  _Demand.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  _Demand.SalesOrganization AS SalesOrganization,
  _Demand.DistributionChannel AS DistributionChannel,
  _Demand.Division AS Division,
  _Demand.SalesDistrict AS SalesDistrict,
  _Demand.CompanyCode AS CompanyCode,
  _Demand.CustomerGroup AS CustomerGroup,
  _Demand.ProductSeason AS ProductSeason,
  _Demand.ProductSeasonYear AS ProductSeasonYear,
  _Demand.ProductCollection AS ProductCollection,
  _Demand.ProductTheme AS ProductTheme,
  _Demand.PurchasingDocument AS PurchasingDocument,
  _Demand.Supplier AS Supplier,
  _Demand.PurchasingDocument AS PurchaseOrder,
  _SupText.AssignedSupplyTypeName AS AssignedSupplyTypeName,
  _RqmtText.RequirementTypeName AS RequirementTypeName,
  _ARunStsTxt.SupplyAssignmentStatusName AS SupplyAssignmentStatusName,
  _ProductText.ProductName AS ProductName,
  _Plant.PlantName AS PlantName
FROM I_SupAssgmtDmndMntrAssgmtDets AS Assgmt
LEFT OUTER JOIN C_SupAssgmtDmndMntr AS _DmndMntr ON RequirementDocumentNumber = _DmndMntr.RequirementDocumentNumber AND RequirementDocumentItem = _DmndMntr.RequirementDocumentItem AND RequirementType = _DmndMntr.RequirementType  -- association [1..1]
LEFT OUTER JOIN I_SupDmndRqmtTypeText AS _RqmtText ON RequirementType = _RqmtText.RequirementType AND _RqmtText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SupDmndAssgdSupTypeText AS _SupText ON AssignedSupplyType = _SupText.AssignedSupplyType AND _SupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ARunStatusText AS _ARunStsTxt ON SupplyAssignmentStatus = _ARunStsTxt.SupplyAssignmentStatus AND _ARunStsTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Material = _ProductText.Product AND _ProductText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;