I_ARunReleaseCheckRunDetail

DDL: I_ARUNRELEASECHECKRUNDETAIL Type: view BASIC Package: VDM_ARUN_RELEASE_CHECK

Release Check Run Details

I_ARunReleaseCheckRunDetail is a Basic CDS View that provides data about "Release Check Run Details" in SAP S/4HANA. It reads from 1 data source (arun_rc_run_detl) and exposes 27 fields with key fields ARunReleaseCheckRunUUID, ARunReleaseCheckResultUUID. Part of development package VDM_ARUN_RELEASE_CHECK.

Data Sources (1)

SourceAliasJoin Type
arun_rc_run_detl detail from

Annotations (10)

NameValueLevelField
EndUserText.label Release Check Run Details view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IRELCHKRUNDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ARunReleaseCheckRunUUID arun_rc_run_detl runid UUID
KEY ARunReleaseCheckResultUUID arun_rc_run_detl recordid ARun Release Check Run Record UUID
RequirementDocumentNumber arun_rc_run_detl order_number Order Number
RequirementDocumentItem arun_rc_run_detl order_item SO Item
RequirementType arun_rc_run_detl req_ind Requirement Type
RequestedDate arun_rc_run_detl requested_date Requested date
ProductAvailabilityDate arun_rc_run_detl material_avail_date Mat.Avail.Date
SupplyAssignmentStatus arun_rc_run_detl arun_status ARun Status
PreviousSupplyAssignmentStatus arun_rc_run_detl arun_old_status Previous ARun Status
AssignedSupplyType arun_rc_run_detl stock_source Stock Source
OrderQuantity arun_rc_run_detl order_qty PO Quantity
ConfirmedRqmtQtyInBaseUnit arun_rc_run_detl confirmed_qty Confirmed Qty
DeliveredQuantityInBaseUnit arun_rc_run_detl delivered_qty ItemQty Mat UoM
AssignedQuantityInBaseUnit arun_rc_run_detl alloc_qty Assigned Qty
BaseUnit arun_rc_run_detl material_baseunit Base Unit
ARunMatlAvailyDateRelChkStatus arun_rc_run_detl status_sl Result SL
ARunItemRelChkStatus arun_rc_run_detl status_itm Result Item
ARunGenericArticleRelChkStatus arun_rc_run_detl status_ga Result GA
ARunDelivGrpRelChkStatus arun_rc_run_detl status_dg Result Del. Grp
ARunHeaderRelChkStatus arun_rc_run_detl status_doc Result Document
ARunShipgGrpRelChkStatus arun_rc_run_detl status_psst Result
ARunDocItemGrpRelChkStatus arun_rc_run_detl status_doc_grp Result
ARunHdrGrpRelChkStatus arun_rc_run_detl status_hdr_grp Result
NetAmount arun_rc_run_detl net_amount Tax-Exclusive Amount
DocumentCurrency arun_rc_run_detl doc_currency Document Currency
ARunRelChkRunDocItemGrpVal arun_rc_run_detl arunrelchkrundocitemgrpval Item Group Counter
ARunRelChkRunHdrGrpVal arun_rc_run_detl 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_ARunReleaseCheckRunDetail.
-- 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_ARunReleaseCheckRunDetail AS
SELECT
  detail.runid AS ARunReleaseCheckRunUUID,
  detail.recordid AS ARunReleaseCheckResultUUID,
  detail.order_number AS RequirementDocumentNumber,
  detail.order_item AS RequirementDocumentItem,
  detail.req_ind AS RequirementType,
  detail.requested_date AS RequestedDate,
  detail.material_avail_date AS ProductAvailabilityDate,
  detail.arun_status AS SupplyAssignmentStatus,
  detail.arun_old_status AS PreviousSupplyAssignmentStatus,
  detail.stock_source AS AssignedSupplyType,
  detail.order_qty AS OrderQuantity,
  detail.confirmed_qty AS ConfirmedRqmtQtyInBaseUnit,
  detail.delivered_qty AS DeliveredQuantityInBaseUnit,
  detail.alloc_qty AS AssignedQuantityInBaseUnit,
  detail.material_baseunit AS BaseUnit,
  detail.status_sl AS ARunMatlAvailyDateRelChkStatus,
  detail.status_itm AS ARunItemRelChkStatus,
  detail.status_ga AS ARunGenericArticleRelChkStatus,
  detail.status_dg AS ARunDelivGrpRelChkStatus,
  detail.status_doc AS ARunHeaderRelChkStatus,
  detail.status_psst AS ARunShipgGrpRelChkStatus,
  detail.status_doc_grp AS ARunDocItemGrpRelChkStatus,
  detail.status_hdr_grp AS ARunHdrGrpRelChkStatus,
  detail.net_amount AS NetAmount,
  detail.doc_currency AS DocumentCurrency,
  detail.arunrelchkrundocitemgrpval AS ARunRelChkRunDocItemGrpVal,
  detail.arunrelchkrunhdrgrpval AS ARunRelChkRunHdrGrpVal
FROM arun_rc_run_detl AS detail
;