C_ARunReleaseCheckCompQuery
Release Check Comparison Query
C_ARunReleaseCheckCompQuery is a Consumption CDS View that provides data about "Release Check Comparison Query" in SAP S/4HANA. It reads from 1 data source (I_ARunReleaseCheckCube) and exposes 77 fields with key fields ARunReleaseCheckVariantUUID, ARunReleaseCheckRunUUID, ARunReleaseCheckResultUUID. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ARunReleaseCheckCube | Release | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_ARunReleaseCheckText | _ARunRCText | $projection.ARunReleaseCheckRunUUID = _ARunRCText.ARunReleaseCheckRunUUID |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CRELPERCENT_COMP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| EndUserText.label | Release Check Comparison Query | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ClientHandling.type | #INHERITED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AccessControl.personalData.blocking | #REQUIRED | view |
Fields (77)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ARunReleaseCheckVariantUUID | I_ARunReleaseCheckCube | ARunReleaseCheckVariantUUID | Release Check UUID |
| KEY | ARunReleaseCheckRunUUID | I_ARunReleaseCheckCube | ARunReleaseCheckRunUUID | Release Check Run ID |
| KEY | ARunReleaseCheckResultUUID | I_ARunReleaseCheckCube | ARunReleaseCheckResultUUID | |
| SupAssgmtExecutionMode | I_ARunReleaseCheckCube | SupAssgmtExecutionMode | ||
| ARunReleaseCheckVariantName | I_ARunReleaseCheckCube | ARunReleaseCheckVariantName | RC Variant | |
| RequirementDocumentNumber | I_ARunReleaseCheckCube | RequirementDocumentNumber | ||
| RequirementDocumentItem | I_ARunReleaseCheckCube | RequirementDocumentItem | ||
| RequirementType | I_ARunReleaseCheckCube | RequirementType | RequirementType | |
| RequestedDate | I_ARunReleaseCheckCube | RequestedDate | ||
| ProductAvailabilityDate | I_ARunReleaseCheckCube | ProductAvailabilityDate | Mat.Avail.Date | |
| SupplyAssignmentStatus | I_ARunReleaseCheckCube | SupplyAssignmentStatus | ||
| OrderQuantity | I_ARunReleaseCheckCube | OrderQuantity | Quantity | |
| ConfirmedRqmtQtyInBaseUnit | I_ARunReleaseCheckCube | ConfirmedRqmtQtyInBaseUnit | ||
| DeliveredQuantityInBaseUnit | I_ARunReleaseCheckCube | DeliveredQuantityInBaseUnit | ||
| AssignedQuantityInBaseUnit | I_ARunReleaseCheckCube | AssignedQuantityInBaseUnit | ||
| BaseUnit | I_ARunReleaseCheckCube | BaseUnit | Unit of Measure | |
| OrderType | I_ARunReleaseCheckCube | OrderType | Order Type | |
| SalesOrganization | I_ARunReleaseCheckCube | SalesOrganization | Sales Organization | |
| DistributionChannel | I_ARunReleaseCheckCube | DistributionChannel | RefDistCh-Cust/Mat. | |
| SalesGroup | I_ARunReleaseCheckCube | SalesGroup | Sales Group | |
| SalesOffice | I_ARunReleaseCheckCube | SalesOffice | Sales Office | |
| ShippingCondition | I_ARunReleaseCheckCube | ShippingCondition | Shipping Conditions | |
| SoldToParty | I_ARunReleaseCheckCube | SoldToParty | Sold-to Party | |
| SoldToPartyName | I_ARunReleaseCheckCube | SoldToPartyName | Sold-to Party Name | |
| CompanyCode | I_ARunReleaseCheckCube | CompanyCode | Receiver Company Code | |
| CompanyCodeName | I_ARunReleaseCheckCube | CompanyCodeName | Company Name | |
| CustomerReferenceNumber | I_ARunReleaseCheckCube | CustomerReferenceNumber | ||
| PartnerFunction | I_ARunReleaseCheckCube | PartnerFunction | Partner Functn | |
| ShipToParty | I_ARunReleaseCheckCube | ShipToParty | Ship-To Party (obsolete) | |
| ShipToPartyName | I_ARunReleaseCheckCube | ShipToPartyName | Ship-To Party Name | |
| SalesDocumentItemCategory | I_ARunReleaseCheckCube | SalesDocumentItemCategory | Item Category | |
| Division | I_ARunReleaseCheckCube | Division | Internal Division ID | |
| Material | I_ARunReleaseCheckCube | Material | Vehicle Model | |
| MaterialGroup | I_ARunReleaseCheckCube | MaterialGroup | Product Group | |
| DeliveryGroup | I_ARunReleaseCheckCube | DeliveryGroup | Delivery Group | |
| BusinessArea | I_ARunReleaseCheckCube | BusinessArea | Business Area | |
| ProfitCenter | I_ARunReleaseCheckCube | ProfitCenter | Profit Center | |
| DeliveryPriority | I_ARunReleaseCheckCube | DeliveryPriority | Delivery Prior. | |
| Plant | I_ARunReleaseCheckCube | Plant | Valuation Area | |
| PlantName | I_ARunReleaseCheckCube | PlantName | Plant Name | |
| StorageLocation | I_ARunReleaseCheckCube | StorageLocation | StorageLocation | |
| ShippingPoint | I_ARunReleaseCheckCube | ShippingPoint | Shipping Point | |
| NetPriceAmount | I_ARunReleaseCheckCube | NetPriceAmount | Net Price | |
| NetPriceQuantity | I_ARunReleaseCheckCube | NetPriceQuantity | Price Unit | |
| RequirementSegment | I_ARunReleaseCheckCube | RequirementSegment | Req. Segment | |
| ProductSeasonYear | I_ARunReleaseCheckCube | ProductSeasonYear | Season Year | |
| ProductSeason | I_ARunReleaseCheckCube | ProductSeason | Season | |
| ProductCollection | I_ARunReleaseCheckCube | ProductCollection | Collection | |
| ProductTheme | I_ARunReleaseCheckCube | ProductTheme | Theme | |
| CustomerGroup | I_ARunReleaseCheckCube | CustomerGroup | Customer Group | |
| SalesDistrict | I_ARunReleaseCheckCube | SalesDistrict | Sales District | |
| SupAssgmtOrdStatus | I_ARunReleaseCheckCube | SupAssgmtOrdStatus | ||
| CrossPlantConfigurableProduct | I_ARunReleaseCheckCube | CrossPlantConfigurableProduct | Cross-plant CP | |
| OrderTypeName | I_ARunReleaseCheckCube | OrderTypeName | ||
| FixedQuantityInBaseUnit | I_ARunReleaseCheckCube | FixedQuantityInBaseUnit | ||
| OnHoldQuantityInBaseUnit | I_ARunReleaseCheckCube | OnHoldQuantityInBaseUnit | ||
| SupAssgmtReservedQtyInBaseUnit | I_ARunReleaseCheckCube | SupAssgmtReservedQtyInBaseUnit | Reserved Quantity | |
| ARunReqdRqmtQtyFlfmtPercent | Assigned Requested Quantity % | |||
| ARunConfdReqdRqmtQtyRatioPct | Confirmed Requested Quantity % | |||
| ARunDlvrdReqdRqmtQtyRatioPct | Delivered Requested Quantity % | |||
| ARunFixedConfdRqmtQtyRatioPct | Ready for Delivery (F) Confirmed Quantity % | |||
| ARunOnResvnConfdQtyRatioPct | On Reservation(R) Confirmed Quantity % | |||
| ARunOnHoldConfdQtyRatioPct | On Hold For Delivery (H) Confirmed Quantity % | |||
| CalendarMonth | I_ARunReleaseCheckCube | CalendarMonth | Calendar Month | |
| CalendarWeek | I_ARunReleaseCheckCube | CalendarWeek | Calendar Week | |
| CalendarYear | I_ARunReleaseCheckCube | CalendarYear | Year | |
| CalendarMonthName | I_ARunReleaseCheckCube | CalendarMonthName | ||
| DocumentCurrency | I_ARunReleaseCheckCube | DocumentCurrency | Document Currency | |
| _ARunRCText | _ARunRCText | |||
| _MaterialText | _MaterialText | |||
| _MaterialGroup | _MaterialGroup | |||
| _CustomerGroup | _CustomerGroup | |||
| _SalesOrgText | _SalesOrgText | |||
| _DistributionChannel | _DistributionChannel | |||
| _Division | _Division | |||
| _SalesDist | _SalesDist | |||
| _SupRqmtType | _SupRqmtType |
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_ARunReleaseCheckCompQuery.
-- 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_ARunReleaseCheckCompQuery AS
SELECT
Release.ARunReleaseCheckVariantUUID AS ARunReleaseCheckVariantUUID,
Release.ARunReleaseCheckRunUUID AS ARunReleaseCheckRunUUID,
Release.ARunReleaseCheckResultUUID AS ARunReleaseCheckResultUUID,
Release.SupAssgmtExecutionMode AS SupAssgmtExecutionMode,
Release.ARunReleaseCheckVariantName AS ARunReleaseCheckVariantName,
Release.RequirementDocumentNumber AS RequirementDocumentNumber,
Release.RequirementDocumentItem AS RequirementDocumentItem,
Release.RequirementType AS RequirementType,
Release.RequestedDate AS RequestedDate,
Release.ProductAvailabilityDate AS ProductAvailabilityDate,
Release.SupplyAssignmentStatus AS SupplyAssignmentStatus,
Release.OrderQuantity AS OrderQuantity,
Release.ConfirmedRqmtQtyInBaseUnit AS ConfirmedRqmtQtyInBaseUnit,
Release.DeliveredQuantityInBaseUnit AS DeliveredQuantityInBaseUnit,
Release.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
Release.BaseUnit AS BaseUnit,
Release.OrderType AS OrderType,
Release.SalesOrganization AS SalesOrganization,
Release.DistributionChannel AS DistributionChannel,
Release.SalesGroup AS SalesGroup,
Release.SalesOffice AS SalesOffice,
Release.ShippingCondition AS ShippingCondition,
Release.SoldToParty AS SoldToParty,
Release.SoldToPartyName AS SoldToPartyName,
Release.CompanyCode AS CompanyCode,
Release.CompanyCodeName AS CompanyCodeName,
Release.CustomerReferenceNumber AS CustomerReferenceNumber,
Release.PartnerFunction AS PartnerFunction,
Release.ShipToParty AS ShipToParty,
Release.ShipToPartyName AS ShipToPartyName,
Release.SalesDocumentItemCategory AS SalesDocumentItemCategory,
Release.Division AS Division,
Release.Material AS Material,
Release.MaterialGroup AS MaterialGroup,
Release.DeliveryGroup AS DeliveryGroup,
Release.BusinessArea AS BusinessArea,
Release.ProfitCenter AS ProfitCenter,
Release.DeliveryPriority AS DeliveryPriority,
Release.Plant AS Plant,
Release.PlantName AS PlantName,
Release.StorageLocation AS StorageLocation,
Release.ShippingPoint AS ShippingPoint,
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.CustomerGroup AS CustomerGroup,
Release.SalesDistrict AS SalesDistrict,
Release.SupAssgmtOrdStatus AS SupAssgmtOrdStatus,
Release.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
Release.OrderTypeName AS OrderTypeName,
Release.FixedQuantityInBaseUnit AS FixedQuantityInBaseUnit,
Release.OnHoldQuantityInBaseUnit AS OnHoldQuantityInBaseUnit,
Release.SupAssgmtReservedQtyInBaseUnit AS SupAssgmtReservedQtyInBaseUnit,
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.CalendarMonth AS CalendarMonth,
Release.CalendarWeek AS CalendarWeek,
Release.CalendarYear AS CalendarYear,
Release.CalendarMonthName AS CalendarMonthName,
Release.DocumentCurrency AS DocumentCurrency
FROM I_ARunReleaseCheckCube AS Release
LEFT OUTER JOIN I_ARunReleaseCheckText AS _ARunRCText ON ARunReleaseCheckRunUUID = _ARunRCText.ARunReleaseCheckRunUUID -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA