C_ARunReleaseCheckRunQuery

Release Check Calculate Query | view: CRELPERCENT | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAK, VBAP, VBKD, EKKO, EKPO, EKPV, SCAL_TT_DATE, ARUN_RC_RUN_DETL, ARUN_RC_RUN_HEAD, VBPA, VBPA, ARUN_DGROUP_RULE, ARUN_DGRP_RULET, KNA1, KNA1, CVI_CUST_CT_LINK, BUT000, T001, TKA02, KNA1, CVI_CUST_LINK, T001W, T161T, TVAKT, MARA, MARC, KNVV, CVI_VEND_LINK
Column Name Description
ARunReleaseCheckRunUUID ARun Release Check Run UUID
ARunReleaseCheckResultUUID ARun Release Check Run Record UUID
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetAmount Net Value of the Order Item in Document Currency
NetPriceAmount Net Price
Column Name Description
OrderQuantity Order Quantity in Base Unit of Measure
ConfirmedRqmtQtyInBaseUnit Confirmed/Committed Quantity in Base Unit of Measure
DeliveredQuantityInBaseUnit Delivered Quantity
AssignedQuantityInBaseUnit Assigned Quantity by ARun
FixedQuantityInBaseUnit Assigned Quantity by ARun
OnHoldQuantityInBaseUnit Assigned Quantity by ARun
SupAssgmtReservedQtyInBaseUnit Assigned Quantity by ARun
UnassignedQtyInBaseUnit Assigned Quantity by ARun
📏 Base Unit of Measure (BaseUnit):
ARunReqdRqmtQtyFlfmtPercent Assigned Quantity by ARun
ARunConfdReqdRqmtQtyRatioPct Assigned Quantity by ARun
ARunDlvrdReqdRqmtQtyRatioPct Assigned Quantity by ARun
ARunFixedConfdRqmtQtyRatioPct Assigned Quantity by ARun
ARunOnResvnConfdQtyRatioPct Assigned Quantity by ARun
ARunOnHoldConfdQtyRatioPct Assigned Quantity by ARun
Column Name Description
RequestedDate Requested date
ProductAvailabilityDate Material availability date (used for MRP)
FashionCancelDate Cancellation Date
Column Name Description
SupAssgmtExecutionMode Execution Mode of Supply Assignment (ARun) Show values
SupAssignRunIsSimulation Indicates if Release Check Run was a Simulation or Update Show values
RequirementType Requirement Type Show values
SupplyAssignmentStatus ARun Status Show values
PreviousSupplyAssignmentStatus Previous ARun Status Show values
AssignedSupplyType ARun Stock Source Show values
ARunMatlAvailyDateRelChkStatus Result Status for Item Material Availability Date(s) Show values
ARunItemRelChkStatus ARUN: Result Status for Articles Show values
ARunGenericArticleRelChkStatus ARUN: Result Status for Generic Articles Show values
ARunDelivGrpRelChkStatus ARUN: Result Status for Delivery Group Show values
ARunHeaderRelChkStatus ARUN: Result Status for Document Show values
ARunShipgGrpRelChkStatus ARUN: Result Status for PSST Show values
ARunDocItemGrpRelChkStatus ARUN: Result Status of Flexible Document Group Show values
ARunHdrGrpRelChkStatus ARUN: Result Status of Flexible Header Group Show values
Column Name Description Domain name
ARunReleaseCheckVariantUUID ARun Release Check Variant UUID SYSUUID
ARunReleaseCheckVariantName Name for ARun Release Check Variant ARUN_RC_VARIANT
ARunDocumentItemUniqueID Unique Identification for Supply Assignment Document Item
DocumentItemConcatenatedID Unique Identification for Supply Assignment Document Item CHAR17
RequirementDocumentNumber ARun Order Number ARUN_AUFN
RequirementDocumentItem ARun Order Item Number ARUN_POSN
OrderTypeName Sales Document Type Description TEXT20
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
CompanyCodeName Name of Company Code or Company TEXT25
Plant Plant (Own or External) WERKS
PlantName Plant Name TEXT30
SoldToParty Sold-to Party KUNNR
SoldToPartyName Name of Customer TEXT80
ShipToParty Customer Number KUNNR
ShipToPartyName Name of Customer TEXT80
CustomerReferenceNumber Customer Reference BSTNK
ProfitCenter Profit Center PRCTR
NetPriceQuantity Condition Pricing Unit KPEIN
RequirementSegment Requirement Segment SGT_SRCA
ShippingGroupRule PSST Grouping Rule RFM_PSST_RULE
ShippingGroupNumber PSST Group RFM_PSST_GROUP_ID
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
PaymentTerms Terms of payment key ZTERM
SupAssgmtOrdStatus null
CalendarMonth Calendar Month NUM2
CalendarWeek null
CalendarYear Calendar Year NUM4
CalendarMonthName Short Text for Fixed Values DDTEXT
ARunMatlAvailyDateRelChkRule ARun Release Rule Extended
ARunItemRelChkRule ARun Release Rule Extended
ARunGenericArticleRelChkRule ARun Release Rule Extended
ARunDelivGrpRelChkRule ARun Release Rule Extended
ARunHeaderRelChkRule ARun Release Rule Extended
ARunShipgGrpRelChkRule ARun Release Rule Extended
ARunDocItemGrpRelChkRule ARun Release Rule Extended
ARunHdrGrpRelChkRule ARun Release Rule Extended
ARunMatlAvailyDateRelChkPct null
ARunItemRelChkPct null
ARunGenericArticleRelChkPct null
ARunDelivGrpRelChkPct null
ARunHeaderRelChkPct null
ARunShipgGrpRelChkPct null
ARunDocItemGrpRelChkPct null
ARunHdrGrpRelChkPct null
ARunMatlAvailyDateRelFlfmtPct null
ARunItemRelFlfmtPct null
ARunGenericArticleRelFlfmtPct null
ARunDelivGrpRelFlfmtPct null
ARunHeaderRelFlfmtPct null
ARunShipgGrpRelFlfmtPct null
ARunDocItemGrpRelChkFlfmtPct null
ARunHdrGrpRelChkFlfmtPct null
ARunRelChkRunDocItemGrpVal ARun Document Item Group Counter INT4
ARunRelChkRunHdrGrpVal ARun Document Header Group Counter INT4
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVV1.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVV2.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVV3.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVV4.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVV5.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Business Area
  • Client
  • Business Area
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TGSB.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.BUSINESSAREA == TGSB.GSBER
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • C_ARUNRELEASECHECKRUNQUERY.COMPANYCODE == T001.BUKRS
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == MARA.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Group
  • Client
  • Customer Group
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == T151.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.CUSTOMERGROUP == T151.KDGRP
Delivery Priority
  • Client
  • Delivery Priority
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TPRIO.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.DELIVERYPRIORITY == TPRIO.LPRIO
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVKOV.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.SALESORGANIZATION == TVKOV.VKORG
  • C_ARUNRELEASECHECKRUNQUERY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Client
  • Division
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TSPA.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.DIVISION == TSPA.SPART
SD Document Currency
  • Client
  • SD Document Currency
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TCURC.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.DOCUMENTCURRENCY == TCURC.WAERS
Billing Block for Item
  • Client
  • Billing Block for Item
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVFS.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
Material: order item
  • Client
  • Material Number
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == MARA.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == T023.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.MATERIALGROUP == T023.MATKL
Order type in order header
  • Client
  • Sales Document Type
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVAK.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.ORDERTYPE == TVAK.AUART
Partner function - Document partner
  • Client
  • Partner Function
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TPAR.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.PARTNERFUNCTION == TPAR.PARVW
Fashion Collection
  • Client
  • Season Year
  • Season
  • Fashion Collection
Season
  • Client
  • Season Year
  • Season
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == FSH_SEASONS.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_ARUNRELEASECHECKRUNQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Season Year
  • Client
  • Season Year
  • Season
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == FSH_SEASONS.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_ARUNRELEASECHECKRUNQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Fashion Theme
  • Client
  • Season Year
  • Season
  • Fashion Collection
  • Fashion Theme
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == FSH_THEMES.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • C_ARUNRELEASECHECKRUNQUERY.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • C_ARUNRELEASECHECKRUNQUERY.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • C_ARUNRELEASECHECKRUNQUERY.PRODUCTTHEME == FSH_THEMES.FSH_THEME
Sales District
  • Client
  • Sales District
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == T171.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.SALESDISTRICT == T171.BZIRK
Sales document item category
  • Client
  • Sales document item category
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVPT.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVAG.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Sales group
  • Client
  • Sales office
  • Sales group
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVBVK.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.SALESOFFICE == TVBVK.VKBUR
  • C_ARUNRELEASECHECKRUNQUERY.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVKO.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.SALESORGANIZATION == TVKO.VKORG
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVSB.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVST.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Client
  • Plant (Own or External)
  • Storage location
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == T001L.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.PLANT == T001L.WERKS
  • C_ARUNRELEASECHECKRUNQUERY.STORAGELOCATION == T001L.LGORT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales office
  • Sales Organization
  • Distribution Channel
  • C_ARUNRELEASECHECKRUNQUERY.MANDT == TVKBZ.MANDT
  • C_ARUNRELEASECHECKRUNQUERY.DIVISION == TVKBZ.SPART
  • C_ARUNRELEASECHECKRUNQUERY.SALESOFFICE == TVKBZ.VKBUR
  • C_ARUNRELEASECHECKRUNQUERY.SALESORGANIZATION == TVKBZ.VKORG
  • C_ARUNRELEASECHECKRUNQUERY.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG