I_SupAssgmtDetails

DDL: I_SUPASSGMTDETAILS Type: view COMPOSITE Package: ARUN_DEMAND_MONITOR
23 Fields 1 Data Sources 1 Associations

Supply Assignment Mapping Details

I_SupAssgmtDetails is a Composite CDS View that provides data about "Supply Assignment Mapping Details" in SAP S/4HANA. It reads from 1 data source (P_SupAssgmtDetailsByOrdItem) and exposes 23 fields with key fields SupplyNumber, SupplyItem, SupplyScheduleLine, Batch, StorageLocation. It has 1 association to related views. Part of development package ARUN_DEMAND_MONITOR.

Data Sources (1)

SourceAliasJoin Type
P_SupAssgmtDetailsByOrdItem Assgmt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] P_SupAssgmtDmndDets _Demand $projection.RequirementDocumentNumber = _Demand.RequirementDocumentNumber and $projection.RequirementDocumentItem = _Demand.RequirementDocumentItem and $projection.RequirementType = _Demand.RequirementType

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISUPASSGMTDETS 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 Supply Assignment Mapping Details view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY SupplyNumber SupplyNumber
KEY SupplyItem SupplyItem
KEY SupplyScheduleLine SupplyScheduleLine
KEY Batch Batch Lot No.
KEY StorageLocation StorageLocation StorageLocation
KEY AssignedSupplyType AssignedSupplyType
KEY RequirementDocumentNumber RequirementDocumentNumber
KEY RequirementDocumentItem RequirementDocumentItem
KEY RequirementType RequirementType RequirementType
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
SupplyDeliveryDate SupplyDeliveryDate
FashionCancelDate _Demand FashionCancelDate
NumberOfDays
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit
FixedQuantityInBaseUnit FixedQuantityInBaseUnit
SupAssgmtReservedQtyInBaseUnit SupAssgmtReservedQtyInBaseUnit
OnHoldQuantityInBaseUnit OnHoldQuantityInBaseUnit
ReadyForReleaseQtyInBaseUnit ReadyForReleaseQtyInBaseUnit
InboundAssignedQuantityInBsUnt InboundAssignedQuantityInBsUnt
BaseUnit BaseUnit Unit of Measure
RequirementSegment RequirementSegment Req. Segment
StockSegment StockSegment Stock Segment

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_SupAssgmtDetails.
-- 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_SupAssgmtDetails AS
SELECT
  SupplyNumber,
  SupplyItem,
  SupplyScheduleLine,
  Batch,
  StorageLocation,
  AssignedSupplyType,
  RequirementDocumentNumber,
  RequirementDocumentItem,
  RequirementType,
  Material,
  Plant,
  SupplyDeliveryDate,
  _Demand.FashionCancelDate AS FashionCancelDate,
  dats_days_between( _Demand.FashionCancelDate, SupplyDeliveryDate ) AS NumberOfDays,
  AssignedQuantityInBaseUnit,
  FixedQuantityInBaseUnit,
  SupAssgmtReservedQtyInBaseUnit,
  OnHoldQuantityInBaseUnit,
  ReadyForReleaseQtyInBaseUnit,
  InboundAssignedQuantityInBsUnt,
  BaseUnit,
  RequirementSegment,
  StockSegment
FROM P_SupAssgmtDetailsByOrdItem AS Assgmt
LEFT OUTER JOIN P_SupAssgmtDmndDets AS _Demand ON RequirementDocumentNumber = _Demand.RequirementDocumentNumber AND RequirementDocumentItem = _Demand.RequirementDocumentItem AND RequirementType = _Demand.RequirementType  -- association [1..1]
;

Learn More