C_ARunReleaseCheckRunQuery

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_ARunReleaseCheckRunQuery.
-- 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_ARunReleaseCheckRunQuery 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 FixedQuantityInBaseUnit,
  Release.OnHoldQuantityInBaseUnit AS OnHoldQuantityInBaseUnit,
  Release.SupAssgmtReservedQtyInBaseUnit AS SupAssgmtReservedQtyInBaseUnit,
  Release.UnassignedQtyInBaseUnit AS UnassignedQtyInBaseUnit,
  Release.BaseUnit AS BaseUnit,
  cast ( 0 as arun_alloc_qty ) AS ARunReqdRqmtQtyFlfmtPercent,
  cast ( 0 as arun_alloc_qty ) AS ARunConfdReqdRqmtQtyRatioPct,
  cast ( 0 as arun_alloc_qty ) AS ARunDlvrdReqdRqmtQtyRatioPct,
  cast ( 0 as arun_alloc_qty ) AS ARunFixedConfdRqmtQtyRatioPct,
  cast ( 0 as arun_alloc_qty ) AS ARunOnResvnConfdQtyRatioPct,
  cast ( 0 as arun_alloc_qty ) AS ARunOnHoldConfdQtyRatioPct,
  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.ARunDocItemGrpRelChkStatus AS ARunDocItemGrpRelChkStatus,
  Release.ARunHdrGrpRelChkStatus AS ARunHdrGrpRelChkStatus,
  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.ARunDocItemGrpRelChkRule AS ARunDocItemGrpRelChkRule,
  Release.ARunHdrGrpRelChkRule AS ARunHdrGrpRelChkRule,
  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.ARunDocItemGrpRelChkPct AS ARunDocItemGrpRelChkPct,
  Release.ARunHdrGrpRelChkPct AS ARunHdrGrpRelChkPct,
  Release.ARunMatlAvailyDateRelFlfmtPct AS ARunMatlAvailyDateRelFlfmtPct,
  Release.ARunItemRelFlfmtPct AS ARunItemRelFlfmtPct,
  Release.ARunGenericArticleRelFlfmtPct AS ARunGenericArticleRelFlfmtPct,
  Release.ARunDelivGrpRelFlfmtPct AS ARunDelivGrpRelFlfmtPct,
  Release.ARunHeaderRelFlfmtPct AS ARunHeaderRelFlfmtPct,
  Release.ARunShipgGrpRelFlfmtPct AS ARunShipgGrpRelFlfmtPct,
  Release.ARunDocItemGrpRelChkFlfmtPct AS ARunDocItemGrpRelChkFlfmtPct,
  Release.ARunHdrGrpRelChkFlfmtPct AS ARunHdrGrpRelChkFlfmtPct,
  Release.ARunRelChkRunDocItemGrpVal AS ARunRelChkRunDocItemGrpVal,
  Release.ARunRelChkRunHdrGrpVal AS ARunRelChkRunHdrGrpVal
FROM I_ARunReleaseCheckCube AS Release
;