I_ARUNRELEASECHECKCUBE
Cube view for Release Check
I_ARUNRELEASECHECKCUBE is a CDS View in S/4HANA. Cube view for Release Check. It contains 118 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ARunRelChkActlVsExpdQty | view | from | CONSUMPTION | Release Check Actual Vs Expected Query |
| C_ARunReleaseCheckCompFltr | view | from | CONSUMPTION | Filter for Release Check Comparison |
| C_ARunReleaseCheckCompQuery | view | from | CONSUMPTION | Release Check Comparison Query |
| C_ARunReleaseCheckRunQuery | view | from | CONSUMPTION | Release Check Calculate Query |
| I_ARunRelChkAmountCube | view | from | COMPOSITE | For Release Check compare amount view |
| I_ARunRelChkDetailedAmountCube | view | from | COMPOSITE | Detailed Analysis amount cube view |
| I_ARunReleaseCheckRunAnalysis | view | from | COMPOSITE | Release Run Analysis cube view |
Fields (118)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ARunReleaseCheckResultUUID | ARunReleaseCheckResultUUID | 4 |
| KEY | ARunReleaseCheckRunUUID | ARunReleaseCheckRunUUID | 4 |
| KEY | ARunReleaseCheckVariantUUID | ARunReleaseCheckVariantUUID | 4 |
| AdditionalCustomerGroup1 | AdditionalCustomerGroup1 | 3 | |
| AdditionalCustomerGroup2 | AdditionalCustomerGroup2 | 3 | |
| AdditionalCustomerGroup3 | AdditionalCustomerGroup3 | 3 | |
| AdditionalCustomerGroup4 | AdditionalCustomerGroup4 | 3 | |
| AdditionalCustomerGroup5 | AdditionalCustomerGroup5 | 3 | |
| ARunDelivGrpRelChkPct | ARunDelivGrpRelChkPct | 3 | |
| ARunDelivGrpRelChkRule | ARunDelivGrpRelChkRule | 3 | |
| ARunDelivGrpRelChkStatus | ARunDelivGrpRelChkStatus | 3 | |
| ARunDelivGrpRelFlfmtPct | ARunDelivGrpRelFlfmtPct | 3 | |
| ARunDocItemGrpRelChkFlfmtPct | ARunDocItemGrpRelChkFlfmtPct | 1 | |
| ARunDocItemGrpRelChkPct | ARunDocItemGrpRelChkPct | 1 | |
| ARunDocItemGrpRelChkRule | ARunDocItemGrpRelChkRule | 1 | |
| ARunDocItemGrpRelChkStatus | ARunDocItemGrpRelChkStatus | 1 | |
| ARunGenericArticleRelChkPct | ARunGenericArticleRelChkPct | 3 | |
| ARunGenericArticleRelChkRule | ARunGenericArticleRelChkRule | 3 | |
| ARunGenericArticleRelChkStatus | ARunGenericArticleRelChkStatus | 3 | |
| ARunGenericArticleRelFlfmtPct | ARunGenericArticleRelFlfmtPct | 3 | |
| ARunHdrGrpRelChkFlfmtPct | ARunHdrGrpRelChkFlfmtPct | 1 | |
| ARunHdrGrpRelChkPct | ARunHdrGrpRelChkPct | 1 | |
| ARunHdrGrpRelChkRule | ARunHdrGrpRelChkRule | 1 | |
| ARunHdrGrpRelChkStatus | ARunHdrGrpRelChkStatus | 1 | |
| ARunHeaderRelChkPct | ARunHeaderRelChkPct | 3 | |
| ARunHeaderRelChkRule | ARunHeaderRelChkRule | 3 | |
| ARunHeaderRelChkStatus | ARunHeaderRelChkStatus | 3 | |
| ARunHeaderRelFlfmtPct | ARunHeaderRelFlfmtPct | 3 | |
| ARunItemRelChkPct | ARunItemRelChkPct | 3 | |
| ARunItemRelChkRule | ARunItemRelChkRule | 3 | |
| ARunItemRelChkStatus | ARunItemRelChkStatus | 3 | |
| ARunItemRelFlfmtPct | ARunItemRelFlfmtPct | 3 | |
| ARunMatlAvailyDateRelChkPct | ARunMatlAvailyDateRelChkPct | 3 | |
| ARunMatlAvailyDateRelChkRule | ARunMatlAvailyDateRelChkRule | 3 | |
| ARunMatlAvailyDateRelChkStatus | ARunMatlAvailyDateRelChkStatus | 3 | |
| ARunMatlAvailyDateRelFlfmtPct | ARunMatlAvailyDateRelFlfmtPct | 3 | |
| ARunRelChkRunDocItemGrpVal | ARunRelChkRunDocItemGrpVal | 1 | |
| ARunRelChkRunHdrGrpVal | ARunRelChkRunHdrGrpVal | 1 | |
| ARunReleaseCheckVariantName | ARunReleaseCheckVariantName | 4 | |
| ARunShipgGrpRelChkPct | ARunShipgGrpRelChkPct | 3 | |
| ARunShipgGrpRelChkRule | ARunShipgGrpRelChkRule | 3 | |
| ARunShipgGrpRelChkStatus | ARunShipgGrpRelChkStatus | 3 | |
| ARunShipgGrpRelFlfmtPct | ARunShipgGrpRelFlfmtPct | 3 | |
| AssignedQuantityInBaseUnit | AssignedQuantityInBaseUnit | 4 | |
| AssignedSupplyType | AssignedSupplyType | 3 | |
| BaseUnit | BaseUnit | 4 | |
| BusinessArea | BusinessArea | 4 | |
| CalendarMonth | CalendarMonth | 4 | |
| CalendarMonthName | CalendarMonthName | 4 | |
| CalendarWeek | CalendarWeek | 4 | |
| CalendarYear | CalendarYear | 4 | |
| CompanyCode | CompanyCode | 4 | |
| CompanyCodeName | CompanyCodeName | 4 | |
| ConfirmedRqmtQtyInBaseUnit | ConfirmedRqmtQtyInBaseUnit | 4 | |
| CrossPlantConfigurableProduct | CrossPlantConfigurableProduct | 4 | |
| CustomerGroup | CustomerGroup | 4 | |
| CustomerReferenceNumber | CustomerReferenceNumber | 4 | |
| DeliveredQuantityInBaseUnit | DeliveredQuantityInBaseUnit | 4 | |
| DeliveryGroup | DeliveryGroup | 4 | |
| DeliveryPriority | DeliveryPriority | 4 | |
| DistributionChannel | DistributionChannel | 4 | |
| Division | Division | 4 | |
| DocumentCurrency | DocumentCurrency | 3 | |
| FashionCancelDate | FashionCancelDate | 3 | |
| FixedQuantityInBaseUnit | ARunRelChkRunFixedQtyInBsUnt,FixedQuantityInBaseUnit | 4 | |
| FreeDefinedProductAttribute01 | FreeDefinedProductAttribute01 | 3 | |
| FreeDefinedProductAttribute02 | FreeDefinedProductAttribute02 | 3 | |
| FreeDefinedProductAttribute03 | FreeDefinedProductAttribute03 | 3 | |
| ItemBillingBlockReason | ItemBillingBlockReason | 3 | |
| Material | Material | 4 | |
| MaterialGroup | MaterialGroup | 4 | |
| NetAmount | NetAmount | 2 | |
| NetPriceAmount | NetPriceAmount | 3 | |
| NetPriceQuantity | NetPriceQuantity | 3 | |
| OnHoldQuantityInBaseUnit | ARunRelChkRunOnHoldQtyInBsUnt,OnHoldQuantityInBaseUnit | 4 | |
| OrderQuantity | OrderQuantity | 4 | |
| OrderType | OrderType | 4 | |
| OrderTypeName | OrderTypeName | 4 | |
| PartnerFunction | PartnerFunction | 4 | |
| PaymentTerms | PaymentTerms | 3 | |
| Plant | Plant | 4 | |
| PlantName | PlantName | 4 | |
| PreviousSupplyAssignmentStatus | PreviousSupplyAssignmentStatus | 3 | |
| ProductAvailabilityDate | ProductAvailabilityDate | 4 | |
| ProductCharacteristic1 | ProductCharacteristic1 | 3 | |
| ProductCharacteristic2 | ProductCharacteristic2 | 3 | |
| ProductCharacteristic3 | ProductCharacteristic3 | 3 | |
| ProductCollection | ProductCollection | 4 | |
| ProductSeason | ProductSeason | 4 | |
| ProductSeasonYear | ProductSeasonYear | 4 | |
| ProductTheme | ProductTheme | 4 | |
| ProfitCenter | ProfitCenter | 4 | |
| RequestedDate | RequestedDate | 4 | |
| RequirementDocumentItem | RequirementDocumentItem | 4 | |
| RequirementDocumentNumber | RequirementDocumentNumber | 4 | |
| RequirementSegment | RequirementSegment | 4 | |
| RequirementType | RequirementType | 4 | |
| SalesDistrict | SalesDistrict | 4 | |
| SalesDocumentItemCategory | SalesDocumentItemCategory | 4 | |
| SalesDocumentRjcnReason | SalesDocumentRjcnReason | 3 | |
| SalesGroup | SalesGroup | 4 | |
| SalesOffice | SalesOffice | 4 | |
| SalesOrganization | SalesOrganization | 4 | |
| ShippingCondition | ShippingCondition | 4 | |
| ShippingGroupNumber | ShippingGroupNumber | 3 | |
| ShippingGroupRule | ShippingGroupRule | 3 | |
| ShippingPoint | ShippingPoint | 4 | |
| ShipToParty | ShipToParty | 4 | |
| ShipToPartyName | ShipToPartyName | 4 | |
| SoldToParty | SoldToParty | 4 | |
| SoldToPartyName | SoldToPartyName | 4 | |
| StorageLocation | StorageLocation | 4 | |
| SupAssgmtExecutionMode | SupAssgmtExecutionMode | 4 | |
| SupAssgmtOrdStatus | SupAssgmtOrdStatus | 4 | |
| SupAssgmtReservedQtyInBaseUnit | ARunRelChkRunRsrvdQtyInBsUnt,SupAssgmtReservedQtyInBaseUnit | 4 | |
| SupAssignRunIsSimulation | SupAssignRunIsSimulation | 3 | |
| SupplyAssignmentStatus | SupplyAssignmentStatus | 4 | |
| UnassignedQtyInBaseUnit | UnassignedQtyInBaseUnit | 3 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Cube view for Release Check
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ARUNRELEASECHECKCUBE (
ARUNRELEASECHECKRESULTUUID,
ARUNRELEASECHECKRUNUUID,
ARUNRELEASECHECKVARIANTUUID,
ADDITIONALCUSTOMERGROUP1,
ADDITIONALCUSTOMERGROUP2,
ADDITIONALCUSTOMERGROUP3,
ADDITIONALCUSTOMERGROUP4,
ADDITIONALCUSTOMERGROUP5,
ARUNDELIVGRPRELCHKPCT,
ARUNDELIVGRPRELCHKRULE,
ARUNDELIVGRPRELCHKSTATUS,
ARUNDELIVGRPRELFLFMTPCT,
ARUNDOCITEMGRPRELCHKFLFMTPCT,
ARUNDOCITEMGRPRELCHKPCT,
ARUNDOCITEMGRPRELCHKRULE,
ARUNDOCITEMGRPRELCHKSTATUS,
ARUNGENERICARTICLERELCHKPCT,
ARUNGENERICARTICLERELCHKRULE,
ARUNGENERICARTICLERELCHKSTATUS,
ARUNGENERICARTICLERELFLFMTPCT,
ARUNHDRGRPRELCHKFLFMTPCT,
ARUNHDRGRPRELCHKPCT,
ARUNHDRGRPRELCHKRULE,
ARUNHDRGRPRELCHKSTATUS,
ARUNHEADERRELCHKPCT,
ARUNHEADERRELCHKRULE,
ARUNHEADERRELCHKSTATUS,
ARUNHEADERRELFLFMTPCT,
ARUNITEMRELCHKPCT,
ARUNITEMRELCHKRULE,
ARUNITEMRELCHKSTATUS,
ARUNITEMRELFLFMTPCT,
ARUNMATLAVAILYDATERELCHKPCT,
ARUNMATLAVAILYDATERELCHKRULE,
ARUNMATLAVAILYDATERELCHKSTATUS,
ARUNMATLAVAILYDATERELFLFMTPCT,
ARUNRELCHKRUNDOCITEMGRPVAL,
ARUNRELCHKRUNHDRGRPVAL,
ARUNRELEASECHECKVARIANTNAME,
ARUNSHIPGGRPRELCHKPCT,
ARUNSHIPGGRPRELCHKRULE,
ARUNSHIPGGRPRELCHKSTATUS,
ARUNSHIPGGRPRELFLFMTPCT,
ASSIGNEDQUANTITYINBASEUNIT,
ASSIGNEDSUPPLYTYPE,
BASEUNIT,
BUSINESSAREA,
CALENDARMONTH,
CALENDARMONTHNAME,
CALENDARWEEK,
CALENDARYEAR,
COMPANYCODE,
COMPANYCODENAME,
CONFIRMEDRQMTQTYINBASEUNIT,
CROSSPLANTCONFIGURABLEPRODUCT,
CUSTOMERGROUP,
CUSTOMERREFERENCENUMBER,
DELIVEREDQUANTITYINBASEUNIT,
DELIVERYGROUP,
DELIVERYPRIORITY,
DISTRIBUTIONCHANNEL,
DIVISION,
DOCUMENTCURRENCY,
FASHIONCANCELDATE,
FIXEDQUANTITYINBASEUNIT,
FREEDEFINEDPRODUCTATTRIBUTE01,
FREEDEFINEDPRODUCTATTRIBUTE02,
FREEDEFINEDPRODUCTATTRIBUTE03,
ITEMBILLINGBLOCKREASON,
MATERIAL,
MATERIALGROUP,
NETAMOUNT,
NETPRICEAMOUNT,
NETPRICEQUANTITY,
ONHOLDQUANTITYINBASEUNIT,
ORDERQUANTITY,
ORDERTYPE,
ORDERTYPENAME,
PARTNERFUNCTION,
PAYMENTTERMS,
PLANT,
PLANTNAME,
PREVIOUSSUPPLYASSIGNMENTSTATUS,
PRODUCTAVAILABILITYDATE,
PRODUCTCHARACTERISTIC1,
PRODUCTCHARACTERISTIC2,
PRODUCTCHARACTERISTIC3,
PRODUCTCOLLECTION,
PRODUCTSEASON,
PRODUCTSEASONYEAR,
PRODUCTTHEME,
PROFITCENTER,
REQUESTEDDATE,
REQUIREMENTDOCUMENTITEM,
REQUIREMENTDOCUMENTNUMBER,
REQUIREMENTSEGMENT,
REQUIREMENTTYPE,
SALESDISTRICT,
SALESDOCUMENTITEMCATEGORY,
SALESDOCUMENTRJCNREASON,
SALESGROUP,
SALESOFFICE,
SALESORGANIZATION,
SHIPPINGCONDITION,
SHIPPINGGROUPNUMBER,
SHIPPINGGROUPRULE,
SHIPPINGPOINT,
SHIPTOPARTY,
SHIPTOPARTYNAME,
SOLDTOPARTY,
SOLDTOPARTYNAME,
STORAGELOCATION,
SUPASSGMTEXECUTIONMODE,
SUPASSGMTORDSTATUS,
SUPASSGMTRESERVEDQTYINBASEUNIT,
SUPASSIGNRUNISSIMULATION,
SUPPLYASSIGNMENTSTATUS,
UNASSIGNEDQTYINBASEUNIT,
PRIMARY KEY (ARUNRELEASECHECKRESULTUUID, ARUNRELEASECHECKRUNUUID, ARUNRELEASECHECKVARIANTUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- 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
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA