I_ARunRelChkSimlnRunAssgmtBsc

DDL: I_ARUNRELCHKSIMLNRUNASSGMTBSC SQL: ISUPASSGMTSIMUBS Type: view BASIC Package: ARUN_RELEASE_CHECK
14 Fields 1 Data Sources

Simulation Assignments

I_ARunRelChkSimlnRunAssgmtBsc is a Basic CDS View that provides data about "Simulation Assignments" in SAP S/4HANA. It reads from 1 data source (P_SupAssgmtSimulation) and exposes 14 fields. Part of development package ARUN_RELEASE_CHECK.

Data Sources (1)

SourceAliasJoin Type
P_SupAssgmtSimulation _SupplyAssgnSimulation from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISUPASSGMTSIMUBS view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Simulation Assignments view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
ATPCheckUUID P_SupAssgmtSimulation ATPCheckUUID Check ID
ARunUUID P_SupAssgmtSimulation ARunID ARun ID
Plant P_SupAssgmtSimulation Plant Valuation Area
Material P_SupAssgmtSimulation Material Vehicle Model
RequirementDocumentNumber P_SupAssgmtSimulation RequirementDocumentNumber
RequirementDocumentItem P_SupAssgmtSimulation RequirementDocumentItem
RequestedDate P_SupAssgmtSimulation RequestedDate Requested date
ProductAvailabilityDate P_SupAssgmtSimulation ProductAvailabilityDate Mat.Avail.Date
SupplyAssignmentStatus P_SupAssgmtSimulation SupplyAssignmentStatus ARun Status
RequirementType P_SupAssgmtSimulation RequirementType RequirementType
AssignedSupplyType P_SupAssgmtSimulation AssignedSupplyType Stock Source
AssignedQuantityInBaseUnit P_SupAssgmtSimulation AssignedQuantityInBaseUnit Assigned Qty
BaseUnit P_SupAssgmtSimulation BaseUnitOfMeasure Base Unit
SupAssgmtExecutionMode P_SupAssgmtSimulation SupplyAssignmentRunMode ARun Mode

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_ARunRelChkSimlnRunAssgmtBsc.
-- 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.
-- SQL view name: ISUPASSGMTSIMUBS

CREATE VIEW I_ARunRelChkSimlnRunAssgmtBsc AS
SELECT
  _SupplyAssgnSimulation.ATPCheckUUID AS ATPCheckUUID,
  _SupplyAssgnSimulation.ARunID AS ARunUUID,
  _SupplyAssgnSimulation.Plant AS Plant,
  _SupplyAssgnSimulation.Material AS Material,
  _SupplyAssgnSimulation.RequirementDocumentNumber AS RequirementDocumentNumber,
  _SupplyAssgnSimulation.RequirementDocumentItem AS RequirementDocumentItem,
  _SupplyAssgnSimulation.RequestedDate AS RequestedDate,
  _SupplyAssgnSimulation.ProductAvailabilityDate AS ProductAvailabilityDate,
  _SupplyAssgnSimulation.SupplyAssignmentStatus AS SupplyAssignmentStatus,
  _SupplyAssgnSimulation.RequirementType AS RequirementType,
  _SupplyAssgnSimulation.AssignedSupplyType AS AssignedSupplyType,
  _SupplyAssgnSimulation.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
  _SupplyAssgnSimulation.BaseUnitOfMeasure AS BaseUnit,
  _SupplyAssgnSimulation.SupplyAssignmentRunMode AS SupAssgmtExecutionMode
FROM P_SupAssgmtSimulation AS _SupplyAssgnSimulation
;

Learn More