I_ARunRelChkSimlnRunDmndDocs

DDL: I_ARUNRELCHKSIMLNRUNDMNDDOCS SQL: IARUNDMNDOCSSIMU Type: view COMPOSITE Package: ARUN_RELEASE_CHECK
29 Fields 3 Data Sources

Demand Docs with Simulated Assignments

I_ARunRelChkSimlnRunDmndDocs is a Composite CDS View that provides data about "Demand Docs with Simulated Assignments" in SAP S/4HANA. It reads from 3 data sources (P_ARunRelChkATPResultReqmt, P_ARunDmnd, I_ARunRelChkSimlnRunAssgmt) and exposes 29 fields. Part of development package ARUN_RELEASE_CHECK.

Data Sources (3)

SourceAliasJoin Type
P_ARunRelChkATPResultReqmt _ARunATPResultRequirement from
P_ARunDmnd _DemandDocument inner
I_ARunRelChkSimlnRunAssgmt _SupplyAssgnSimulation left_outer

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Demand Docs with Simulated Assignments view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IARUNDMNDOCSSIMU view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (29)

KeyFieldSource TableSource FieldDescription
ATPCheckUUID P_ARunRelChkATPResultReqmt ATPCheckUUID Check ID
RequirementDocumentNumber P_ARunDmnd RequirementDocumentNumber
RequirementDocumentItem P_ARunDmnd RequirementDocumentItem
RequestedDate I_ARunRelChkSimlnRunAssgmt RequestedDate
ProductAvailabilityDate I_ARunRelChkSimlnRunAssgmt ProductAvailabilityDate Mat.Avail.Date
RequestedRqmtQtyInBaseUnit I_ARunRelChkSimlnRunAssgmt RequestedRqmtQtyInBaseUnit
DeliveredQuantityInBaseUnit I_ARunRelChkSimlnRunAssgmt DeliveredQuantityInBaseUnit
ConfirmedRqmtQtyInBaseUnit I_ARunRelChkSimlnRunAssgmt ConfirmedRqmtQtyInBaseUnit
SalesOrganization P_ARunDmnd SalesOrganization Sales Organization
DistributionChannel P_ARunDmnd DistributionChannel RefDistCh-Cust/Mat.
Division P_ARunDmnd Division Internal Division ID
OrderType P_ARunDmnd OrderType Order Type
SoldToParty P_ARunDmnd SoldToParty Sold-to Party
ShipToParty P_ARunDmnd ShipToParty Ship-To Party (obsolete)
DeliveryGroup P_ARunDmnd DeliveryGroup Delivery Group
ShippingGroupNumber P_ARunDmnd ShippingGroupNumber PSST Group
ARunSupplyAssgmtReleaseRule P_ARunDmnd ARunSupplyAssgmtReleaseRule Release Rule
NetPriceAmount P_ARunDmnd NetPriceAmount Net Price
DocumentCurrency P_ARunDmnd DocumentCurrency Document Currency
ARunUUID I_ARunRelChkSimlnRunAssgmt ARunUUID
Plant I_ARunRelChkSimlnRunAssgmt Plant Valuation Area
Material I_ARunRelChkSimlnRunAssgmt Material Vehicle Model
CrossPlantConfigurableProduct P_ARunDmnd CrossPlantConfigurableProduct Cross-plant CP
SupplyAssignmentStatus I_ARunRelChkSimlnRunAssgmt SupplyAssignmentStatus
RequirementType P_ARunDmnd RequirementType RequirementType
AssignedSupplyType I_ARunRelChkSimlnRunAssgmt AssignedSupplyType
AssignedQuantityInBaseUnit I_ARunRelChkSimlnRunAssgmt AssignedQuantityInBaseUnit
BaseUnit I_ARunRelChkSimlnRunAssgmt BaseUnit Unit of Measure
SupAssgmtExecutionMode I_ARunRelChkSimlnRunAssgmt SupAssgmtExecutionMode

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_ARunRelChkSimlnRunDmndDocs.
-- 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: IARUNDMNDOCSSIMU

CREATE VIEW I_ARunRelChkSimlnRunDmndDocs AS
SELECT
  _ARunATPResultRequirement.ATPCheckUUID AS ATPCheckUUID,
  _DemandDocument.RequirementDocumentNumber AS RequirementDocumentNumber,
  _DemandDocument.RequirementDocumentItem AS RequirementDocumentItem,
  _SupplyAssgnSimulation.RequestedDate AS RequestedDate,
  _SupplyAssgnSimulation.ProductAvailabilityDate AS ProductAvailabilityDate,
  _SupplyAssgnSimulation.RequestedRqmtQtyInBaseUnit AS RequestedRqmtQtyInBaseUnit,
  _SupplyAssgnSimulation.DeliveredQuantityInBaseUnit AS DeliveredQuantityInBaseUnit,
  _SupplyAssgnSimulation.ConfirmedRqmtQtyInBaseUnit AS ConfirmedRqmtQtyInBaseUnit,
  _DemandDocument.SalesOrganization AS SalesOrganization,
  _DemandDocument.DistributionChannel AS DistributionChannel,
  _DemandDocument.Division AS Division,
  _DemandDocument.OrderType AS OrderType,
  _DemandDocument.SoldToParty AS SoldToParty,
  _DemandDocument.ShipToParty AS ShipToParty,
  _DemandDocument.DeliveryGroup AS DeliveryGroup,
  _DemandDocument.ShippingGroupNumber AS ShippingGroupNumber,
  _DemandDocument.ARunSupplyAssgmtReleaseRule AS ARunSupplyAssgmtReleaseRule,
  _DemandDocument.NetPriceAmount AS NetPriceAmount,
  _DemandDocument.DocumentCurrency AS DocumentCurrency,
  _SupplyAssgnSimulation.ARunUUID AS ARunUUID,
  _SupplyAssgnSimulation.Plant AS Plant,
  _SupplyAssgnSimulation.Material AS Material,
  _DemandDocument.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  _SupplyAssgnSimulation.SupplyAssignmentStatus AS SupplyAssignmentStatus,
  _DemandDocument.RequirementType AS RequirementType,
  _SupplyAssgnSimulation.AssignedSupplyType AS AssignedSupplyType,
  _SupplyAssgnSimulation.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
  _SupplyAssgnSimulation.BaseUnit AS BaseUnit,
  _SupplyAssgnSimulation.SupAssgmtExecutionMode AS SupAssgmtExecutionMode
FROM P_ARunRelChkATPResultReqmt AS _ARunATPResultRequirement
INNER JOIN P_ARunDmnd AS _DemandDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ARunRelChkSimlnRunAssgmt AS _SupplyAssgnSimulation ON /* join condition not captured in parsed metadata */
;

Learn More