I_ARUNRELEASECHECKCUBE

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);