I_ARunReleaseCheckLevel

DDL: I_ARUNRELEASECHECKLEVEL Type: view BASIC Package: VDM_ARUN_RELEASE_CHECK
68 Fields 1 Data Sources

Release Check level Calculation Query

I_ARunReleaseCheckLevel is a Basic CDS View that provides data about "Release Check level Calculation Query" in SAP S/4HANA. It reads from 1 data source (P_ARunReleaseCheckRun) and exposes 68 fields. Part of development package VDM_ARUN_RELEASE_CHECK.

Data Sources (1)

SourceAliasJoin Type
P_ARunReleaseCheckRun ReleaseLevel from

Annotations (9)

NameValueLevelField
EndUserText.label Release Check level Calculation Query view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IRELCHKLEVEL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (68)

KeyFieldSource TableSource FieldDescription
clientid P_ARunReleaseCheckRun clientid Editing Client
ARunReleaseCheckRunUUID P_ARunReleaseCheckRun ARunReleaseCheckRunUUID UUID
ARunReleaseCheckVariantUUID P_ARunReleaseCheckRun ARunReleaseCheckVariantUUID Release Check UUID
SupAssgmtExecutionMode P_ARunReleaseCheckRun SupAssgmtExecutionMode Run Mode
ARunReleaseCheckVariantName P_ARunReleaseCheckRun ARunReleaseCheckVariantName RC Variant
ARunReleaseCheckResultUUID P_ARunReleaseCheckRun ARunReleaseCheckResultUUID ARun Release Check Run Record UUID
RequirementDocumentNumber P_ARunReleaseCheckRun RequirementDocumentNumber Order Number
RequirementDocumentItem P_ARunReleaseCheckRun RequirementDocumentItem SO Item
RequirementType P_ARunReleaseCheckRun RequirementType RequirementType
RequestedDate P_ARunReleaseCheckRun RequestedDate Requested date
ProductAvailabilityDate P_ARunReleaseCheckRun ProductAvailabilityDate Mat.Avail.Date
SupplyAssignmentStatus P_ARunReleaseCheckRun SupplyAssignmentStatus ARun Status
PreviousSupplyAssignmentStatus P_ARunReleaseCheckRun PreviousSupplyAssignmentStatus Previous ARun Status
AssignedSupplyType P_ARunReleaseCheckRun AssignedSupplyType Stock Source
OrderQuantity P_ARunReleaseCheckRun OrderQuantity Quantity
ConfirmedRqmtQtyInBaseUnit P_ARunReleaseCheckRun ConfirmedRqmtQtyInBaseUnit Confirmed Qty
DeliveredQuantityInBaseUnit P_ARunReleaseCheckRun DeliveredQuantityInBaseUnit ItemQty Mat UoM
AssignedQuantityInBaseUnit P_ARunReleaseCheckRun AssignedQuantityInBaseUnit Assigned Qty
FixedQuantityInBaseUnit P_ARunReleaseCheckRun FixedQuantityInBaseUnit
OnHoldQuantityInBaseUnit P_ARunReleaseCheckRun OnHoldQuantityInBaseUnit
SupAssgmtReservedQtyInBaseUnit P_ARunReleaseCheckRun SupAssgmtReservedQtyInBaseUnit
UnassignedQtyInBaseUnit P_ARunReleaseCheckRun UnassignedQtyInBaseUnit
BaseUnit P_ARunReleaseCheckRun BaseUnit Unit of Measure
ARunMatlAvailyDateRelChkStatus P_ARunReleaseCheckRun ARunMatlAvailyDateRelChkStatus Result SL
ARunItemRelChkStatus P_ARunReleaseCheckRun ARunItemRelChkStatus Result Item
ARunGenericArticleRelChkStatus P_ARunReleaseCheckRun ARunGenericArticleRelChkStatus Result GA
ARunDelivGrpRelChkStatus P_ARunReleaseCheckRun ARunDelivGrpRelChkStatus Result Del. Grp
ARunHeaderRelChkStatus P_ARunReleaseCheckRun ARunHeaderRelChkStatus Result Document
ARunShipgGrpRelChkStatus P_ARunReleaseCheckRun ARunShipgGrpRelChkStatus Result
ARunDocItemGrpRelChkStatus P_ARunReleaseCheckRun ARunDocItemGrpRelChkStatus Result
ARunHdrGrpRelChkStatus P_ARunReleaseCheckRun ARunHdrGrpRelChkStatus Result
ARunMatlAvailyDateRelChkRule P_ARunReleaseCheckRun ARunMatlAvailyDateRelChkRule
ARunItemRelChkRule P_ARunReleaseCheckRun ARunItemRelChkRule
ARunGenericArticleRelChkRule P_ARunReleaseCheckRun ARunGenericArticleRelChkRule
ARunDelivGrpRelChkRule P_ARunReleaseCheckRun ARunDelivGrpRelChkRule
ARunHeaderRelChkRule P_ARunReleaseCheckRun ARunHeaderRelChkRule
ARunShipgGrpRelChkRule P_ARunReleaseCheckRun ARunShipgGrpRelChkRule
ARunDocItemGrpRelChkRule P_ARunReleaseCheckRun ARunDocItemGrpRelChkRule
ARunHdrGrpRelChkRule P_ARunReleaseCheckRun ARunHdrGrpRelChkRule
ARunDocumentItemGroupRuleUUID P_ARunReleaseCheckRun ARunDocumentItemGroupRuleUUID Doc Item Group UUID
ARunHeaderGroupRuleUUID P_ARunReleaseCheckRun ARunHeaderGroupRuleUUID Header Group UUID
LogHandle LogHandle LogsHandle
SupAssignRunIsSimulation SupAssignRunIsSimulation Simulation
ARunReleaseCheckGroupName ARunReleaseCheckGroupName ARun Release Check Variant Group
StartedByUser StartedByUser Version Created By
ARunRelChkStartUTCDateTime ARunRelChkStartUTCDateTime TS DT Started
AllocationRunStatus AllocationRunStatus Workflow Status
ARunMatlAvailyDateRelChkPct
ARunItemRelChkPct
ARunGenericArticleRelChkPct
ARunDelivGrpRelChkPct
ARunHeaderRelChkPct
ARunShipgGrpRelChkPct
ARunDocItemGrpRelChkPct
ARunHdrGrpRelChkPct
ARunMatlAvailyDateRelFlfmtPct
ARunItemRelFlfmtPct
ARunGenericArticleRelFlfmtPct
ARunDelivGrpRelFlfmtPct
ARunHeaderRelFlfmtPct
ARunShipgGrpRelFlfmtPct
ARunDocItemGrpRelChkFlfmtPct
ARunHdrGrpRelChkFlfmtPct
ARunRelChkMatAvailyDateCalcQty P_ARunReleaseCheckRun ARunRelChkConfirmedQuantity
NetAmount NetAmount Stated Amount
DocumentCurrency DocumentCurrency Document Currency
ARunRelChkRunDocItemGrpVal P_ARunReleaseCheckRun ARunRelChkRunDocItemGrpVal Item Group Counter
ARunRelChkRunHdrGrpVal P_ARunReleaseCheckRun ARunRelChkRunHdrGrpVal Header Group Counter

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_ARunReleaseCheckLevel.
-- 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_ARunReleaseCheckLevel AS
SELECT
  ReleaseLevel.clientid AS clientid,
  ReleaseLevel.ARunReleaseCheckRunUUID AS ARunReleaseCheckRunUUID,
  ReleaseLevel.ARunReleaseCheckVariantUUID AS ARunReleaseCheckVariantUUID,
  ReleaseLevel.SupAssgmtExecutionMode AS SupAssgmtExecutionMode,
  ReleaseLevel.ARunReleaseCheckVariantName AS ARunReleaseCheckVariantName,
  ReleaseLevel.ARunReleaseCheckResultUUID AS ARunReleaseCheckResultUUID,
  ReleaseLevel.RequirementDocumentNumber AS RequirementDocumentNumber,
  ReleaseLevel.RequirementDocumentItem AS RequirementDocumentItem,
  ReleaseLevel.RequirementType AS RequirementType,
  ReleaseLevel.RequestedDate AS RequestedDate,
  ReleaseLevel.ProductAvailabilityDate AS ProductAvailabilityDate,
  ReleaseLevel.SupplyAssignmentStatus AS SupplyAssignmentStatus,
  ReleaseLevel.PreviousSupplyAssignmentStatus AS PreviousSupplyAssignmentStatus,
  ReleaseLevel.AssignedSupplyType AS AssignedSupplyType,
  ReleaseLevel.OrderQuantity AS OrderQuantity,
  ReleaseLevel.ConfirmedRqmtQtyInBaseUnit AS ConfirmedRqmtQtyInBaseUnit,
  ReleaseLevel.DeliveredQuantityInBaseUnit AS DeliveredQuantityInBaseUnit,
  ReleaseLevel.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
  ReleaseLevel.FixedQuantityInBaseUnit AS FixedQuantityInBaseUnit,
  ReleaseLevel.OnHoldQuantityInBaseUnit AS OnHoldQuantityInBaseUnit,
  ReleaseLevel.SupAssgmtReservedQtyInBaseUnit AS SupAssgmtReservedQtyInBaseUnit,
  ReleaseLevel.UnassignedQtyInBaseUnit AS UnassignedQtyInBaseUnit,
  ReleaseLevel.BaseUnit AS BaseUnit,
  ReleaseLevel.ARunMatlAvailyDateRelChkStatus AS ARunMatlAvailyDateRelChkStatus,
  ReleaseLevel.ARunItemRelChkStatus AS ARunItemRelChkStatus,
  ReleaseLevel.ARunGenericArticleRelChkStatus AS ARunGenericArticleRelChkStatus,
  ReleaseLevel.ARunDelivGrpRelChkStatus AS ARunDelivGrpRelChkStatus,
  ReleaseLevel.ARunHeaderRelChkStatus AS ARunHeaderRelChkStatus,
  ReleaseLevel.ARunShipgGrpRelChkStatus AS ARunShipgGrpRelChkStatus,
  ReleaseLevel.ARunDocItemGrpRelChkStatus AS ARunDocItemGrpRelChkStatus,
  ReleaseLevel.ARunHdrGrpRelChkStatus AS ARunHdrGrpRelChkStatus,
  ReleaseLevel.ARunMatlAvailyDateRelChkRule AS ARunMatlAvailyDateRelChkRule,
  ReleaseLevel.ARunItemRelChkRule AS ARunItemRelChkRule,
  ReleaseLevel.ARunGenericArticleRelChkRule AS ARunGenericArticleRelChkRule,
  ReleaseLevel.ARunDelivGrpRelChkRule AS ARunDelivGrpRelChkRule,
  ReleaseLevel.ARunHeaderRelChkRule AS ARunHeaderRelChkRule,
  ReleaseLevel.ARunShipgGrpRelChkRule AS ARunShipgGrpRelChkRule,
  ReleaseLevel.ARunDocItemGrpRelChkRule AS ARunDocItemGrpRelChkRule,
  ReleaseLevel.ARunHdrGrpRelChkRule AS ARunHdrGrpRelChkRule,
  ReleaseLevel.ARunDocumentItemGroupRuleUUID AS ARunDocumentItemGroupRuleUUID,
  ReleaseLevel.ARunHeaderGroupRuleUUID AS ARunHeaderGroupRuleUUID,
  LogHandle,
  SupAssignRunIsSimulation,
  ARunReleaseCheckGroupName,
  StartedByUser,
  ARunRelChkStartUTCDateTime,
  AllocationRunStatus,
  cast(ReleaseLevel.ARunMatlAvailyDateRelChkPct as abap.int2) AS ARunMatlAvailyDateRelChkPct,
  cast(ReleaseLevel.ARunItemRelChkPct as abap.int2) AS ARunItemRelChkPct,
  cast(ReleaseLevel.ARunGenericArticleRelChkPct as abap.int2) AS ARunGenericArticleRelChkPct,
  cast(ReleaseLevel.ARunDelivGrpRelChkPct as abap.int2) AS ARunDelivGrpRelChkPct,
  cast(ReleaseLevel.ARunHeaderRelChkPct as abap.int2) AS ARunHeaderRelChkPct,
  cast(ReleaseLevel.ARunShipgGrpRelChkPct as abap.int2) AS ARunShipgGrpRelChkPct,
  cast(ReleaseLevel.ARunDocItemGrpRelChkPct as abap.int2) AS ARunDocItemGrpRelChkPct,
  cast(ReleaseLevel.ARunHdrGrpRelChkPct as abap.int2) AS ARunHdrGrpRelChkPct,
  cast(ReleaseLevel.ARunMatlAvailyDateRelFlfmtPct as abap.int2) AS ARunMatlAvailyDateRelFlfmtPct,
  cast(ReleaseLevel.ARunItemRelFlfmtPct as abap.int2) AS ARunItemRelFlfmtPct,
  cast(ReleaseLevel.ARunGenericArticleRelFlfmtPct as abap.int2) AS ARunGenericArticleRelFlfmtPct,
  cast(ReleaseLevel.ARunDelivGrpRelFlfmtPct as abap.int2) AS ARunDelivGrpRelFlfmtPct,
  cast(ReleaseLevel.ARunHeaderRelFlfmtPct as abap.int2) AS ARunHeaderRelFlfmtPct,
  cast(ReleaseLevel.ARunShipgGrpRelFlfmtPct as abap.int2) AS ARunShipgGrpRelFlfmtPct,
  cast(ReleaseLevel.ARunDocItemGrpRelChkFlfmtPct as abap.int2) AS ARunDocItemGrpRelChkFlfmtPct,
  cast(ReleaseLevel.ARunHdrGrpRelChkFlfmtPct as abap.int2) AS ARunHdrGrpRelChkFlfmtPct,
  ReleaseLevel.ARunRelChkConfirmedQuantity AS ARunRelChkMatAvailyDateCalcQty,
  NetAmount,
  DocumentCurrency,
  ReleaseLevel.ARunRelChkRunDocItemGrpVal AS ARunRelChkRunDocItemGrpVal,
  ReleaseLevel.ARunRelChkRunHdrGrpVal AS ARunRelChkRunHdrGrpVal
FROM P_ARunReleaseCheckRun AS ReleaseLevel
;

Learn More