I_ARunReleaseCheckRunAnalysis

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_ARunReleaseCheckRunAnalysis.
-- 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_ARunReleaseCheckRunAnalysis AS
SELECT
  Release.ARunReleaseCheckRunUUID AS ARunReleaseCheckRunUUID,
  Release.ARunReleaseCheckResultUUID AS ARunReleaseCheckResultUUID,
  Release.ARunReleaseCheckVariantUUID AS ARunReleaseCheckVariantUUID,
  Release.ARunReleaseCheckVariantName AS ARunReleaseCheckVariantName,
  Release.SupAssgmtExecutionMode AS SupAssgmtExecutionMode,
  Release.SupAssignRunIsSimulation AS SupAssignRunIsSimulation,
  Release.RequirementDocumentNumber AS RequirementDocumentNumber,
  Release.RequirementDocumentItem AS RequirementDocumentItem,
  Release.RequirementType AS RequirementType,
  Release.OrderType AS OrderType,
  Release.OrderTypeName AS OrderTypeName,
  Release.RequestedDate AS RequestedDate,
  Release.ProductAvailabilityDate AS ProductAvailabilityDate,
  Release.SupplyAssignmentStatus AS SupplyAssignmentStatus,
  Release.PreviousSupplyAssignmentStatus AS PreviousSupplyAssignmentStatus,
  Release.AssignedSupplyType AS AssignedSupplyType,
  Release.DeliveryGroup AS DeliveryGroup,
  Release.CompanyCode AS CompanyCode,
  Release.CompanyCodeName AS CompanyCodeName,
  Release.Plant AS Plant,
  Release.PlantName AS PlantName,
  Release.SalesOffice AS SalesOffice,
  Release.SalesGroup AS SalesGroup,
  Release.SalesDistrict AS SalesDistrict,
  Release.SalesOrganization AS SalesOrganization,
  Release.DistributionChannel AS DistributionChannel,
  Release.Division AS Division,
  Release.SoldToParty AS SoldToParty,
  Release.SoldToPartyName AS SoldToPartyName,
  Release.ShipToParty AS ShipToParty,
  Release.ShipToPartyName AS ShipToPartyName,
  Release.CustomerGroup AS CustomerGroup,
  Release.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  Release.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  Release.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  Release.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  Release.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  Release.CustomerReferenceNumber AS CustomerReferenceNumber,
  Release.PartnerFunction AS PartnerFunction,
  Release.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  Release.Material AS Material,
  Release.MaterialGroup AS MaterialGroup,
  Release.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  Release.ItemBillingBlockReason AS ItemBillingBlockReason,
  Release.BusinessArea AS BusinessArea,
  Release.ProfitCenter AS ProfitCenter,
  Release.DeliveryPriority AS DeliveryPriority,
  Release.StorageLocation AS StorageLocation,
  Release.ShippingCondition AS ShippingCondition,
  Release.ShippingPoint AS ShippingPoint,
  Release.DocumentCurrency AS DocumentCurrency,
  Release.NetAmount AS NetAmount,
  Release.NetPriceAmount AS NetPriceAmount,
  Release.NetPriceQuantity AS NetPriceQuantity,
  Release.RequirementSegment AS RequirementSegment,
  Release.ProductSeasonYear AS ProductSeasonYear,
  Release.ProductSeason AS ProductSeason,
  Release.ProductCollection AS ProductCollection,
  Release.ProductTheme AS ProductTheme,
  Release.FashionCancelDate AS FashionCancelDate,
  Release.ShippingGroupRule AS ShippingGroupRule,
  Release.ShippingGroupNumber AS ShippingGroupNumber,
  Release.ProductCharacteristic1 AS ProductCharacteristic1,
  Release.ProductCharacteristic2 AS ProductCharacteristic2,
  Release.ProductCharacteristic3 AS ProductCharacteristic3,
  Release.PaymentTerms AS PaymentTerms,
  Release.SupAssgmtOrdStatus AS SupAssgmtOrdStatus,
  Release.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  Release.FreeDefinedProductAttribute01 AS FreeDefinedProductAttribute01,
  Release.FreeDefinedProductAttribute02 AS FreeDefinedProductAttribute02,
  Release.FreeDefinedProductAttribute03 AS FreeDefinedProductAttribute03,
  Release.CalendarMonth AS CalendarMonth,
  Release.CalendarWeek AS CalendarWeek,
  Release.CalendarYear AS CalendarYear,
  Release.CalendarMonthName AS CalendarMonthName,
  Release.OrderQuantity AS OrderQuantity,
  Release.ConfirmedRqmtQtyInBaseUnit AS ConfirmedRqmtQtyInBaseUnit,
  Release.DeliveredQuantityInBaseUnit AS DeliveredQuantityInBaseUnit,
  Release.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
  Release.FixedQuantityInBaseUnit AS ARunRelChkRunFixedQtyInBsUnt,
  Release.OnHoldQuantityInBaseUnit AS ARunRelChkRunOnHoldQtyInBsUnt,
  Release.SupAssgmtReservedQtyInBaseUnit AS ARunRelChkRunRsrvdQtyInBsUnt,
  Release.UnassignedQtyInBaseUnit AS UnassignedQtyInBaseUnit,
  Release.BaseUnit AS BaseUnit,
  Release.ARunMatlAvailyDateRelChkStatus AS ARunMatlAvailyDateRelChkStatus,
  Release.ARunItemRelChkStatus AS ARunItemRelChkStatus,
  Release.ARunGenericArticleRelChkStatus AS ARunGenericArticleRelChkStatus,
  Release.ARunDelivGrpRelChkStatus AS ARunDelivGrpRelChkStatus,
  Release.ARunHeaderRelChkStatus AS ARunHeaderRelChkStatus,
  Release.ARunShipgGrpRelChkStatus AS ARunShipgGrpRelChkStatus,
  Release.ARunMatlAvailyDateRelChkRule AS ARunMatlAvailyDateRelChkRule,
  Release.ARunItemRelChkRule AS ARunItemRelChkRule,
  Release.ARunGenericArticleRelChkRule AS ARunGenericArticleRelChkRule,
  Release.ARunDelivGrpRelChkRule AS ARunDelivGrpRelChkRule,
  Release.ARunHeaderRelChkRule AS ARunHeaderRelChkRule,
  Release.ARunShipgGrpRelChkRule AS ARunShipgGrpRelChkRule,
  Release.ARunMatlAvailyDateRelChkPct AS ARunMatlAvailyDateRelChkPct,
  Release.ARunItemRelChkPct AS ARunItemRelChkPct,
  Release.ARunGenericArticleRelChkPct AS ARunGenericArticleRelChkPct,
  Release.ARunDelivGrpRelChkPct AS ARunDelivGrpRelChkPct,
  Release.ARunHeaderRelChkPct AS ARunHeaderRelChkPct,
  Release.ARunShipgGrpRelChkPct AS ARunShipgGrpRelChkPct,
  Release.ARunMatlAvailyDateRelFlfmtPct AS ARunMatlAvailyDateRelFlfmtPct,
  Release.ARunItemRelFlfmtPct AS ARunItemRelFlfmtPct,
  Release.ARunGenericArticleRelFlfmtPct AS ARunGenericArticleRelFlfmtPct,
  Release.ARunDelivGrpRelFlfmtPct AS ARunDelivGrpRelFlfmtPct,
  Release.ARunHeaderRelFlfmtPct AS ARunHeaderRelFlfmtPct,
  Release.ARunShipgGrpRelFlfmtPct AS ARunShipgGrpRelFlfmtPct,
  SupAssgmtAggrgQtyUnit
FROM I_ARunReleaseCheckCube AS Release
LEFT OUTER JOIN I_ARunNormal AS Normal ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ARunPreview AS Preview ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ARunSimulation AS Simulation ON /* join condition not captured in parsed metadata */
;