C_ARunReleaseCheckCompQuery

Release Check Comparison Query | view: CRELPERCENT_COMP | 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
ARunReleaseCheckVariantUUID ARun Release Check Variant UUID
ARunReleaseCheckRunUUID ARun Release Check Run UUID
ARunReleaseCheckResultUUID ARun Release Check Run Record UUID
Column Name Description
💲 SD Document Currency (DocumentCurrency):
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
📏 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)
Column Name Description
SupAssgmtExecutionMode Execution Mode of Supply Assignment (ARun) Show values
RequirementType Requirement Type Show values
SupplyAssignmentStatus ARun Status Show values
Column Name Description Domain name
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
SoldToParty Sold-to Party KUNNR
SoldToPartyName Name of Customer TEXT80
CompanyCodeName Name of Company Code or Company TEXT25
CustomerReferenceNumber Customer Reference BSTNK
ShipToParty Customer Number KUNNR
ShipToPartyName Name of Customer TEXT80
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
ProfitCenter Profit Center PRCTR
Plant Plant (Own or External) WERKS
PlantName Plant Name TEXT30
NetPriceQuantity Condition Pricing Unit KPEIN
RequirementSegment Requirement Segment SGT_SRCA
SupAssgmtOrdStatus null
OrderTypeName Sales Document Type Description TEXT20
CalendarMonth Calendar Month NUM2
CalendarWeek null
CalendarYear Calendar Year NUM4
CalendarMonthName Short Text for Fixed Values DDTEXT
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == TGSB.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.BUSINESSAREA == TGSB.GSBER
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == T001.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.COMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == MARA.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Group
  • Customer Group
  • Client
  • C_ARUNRELEASECHECKCOMPQUERY.CUSTOMERGROUP == T151.KDGRP
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == T151.MANDT
Delivery Priority
  • Client
  • Delivery Priority
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == TPRIO.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.DELIVERYPRIORITY == TPRIO.LPRIO
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == TVKOV.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_ARUNRELEASECHECKCOMPQUERY.SALESORGANIZATION == TVKOV.VKORG
Division
  • Client
  • Division
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == TSPA.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.DIVISION == TSPA.SPART
SD Document Currency
  • Client
  • SD Document Currency
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == TCURC.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.DOCUMENTCURRENCY == TCURC.WAERS
Material: order item
  • Client
  • Material Number
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == MARA.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == T023.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.MATERIALGROUP == T023.MATKL
Order type in order header
  • Client
  • Sales Document Type
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == TVAK.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.ORDERTYPE == TVAK.AUART
Partner function - Document partner
  • Client
  • Partner Function
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == TPAR.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.PARTNERFUNCTION == TPAR.PARVW
Fashion Collection
  • Season
  • Client
  • Season Year
  • Fashion Collection
Season
  • Season
  • Client
  • Season Year
  • C_ARUNRELEASECHECKCOMPQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == FSH_SEASONS.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Season Year
  • Season
  • Client
  • Season Year
  • C_ARUNRELEASECHECKCOMPQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == FSH_SEASONS.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Fashion Theme
  • Season
  • Client
  • Season Year
  • Fashion Collection
  • Fashion Theme
  • C_ARUNRELEASECHECKCOMPQUERY.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == FSH_THEMES.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • C_ARUNRELEASECHECKCOMPQUERY.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • C_ARUNRELEASECHECKCOMPQUERY.PRODUCTTHEME == FSH_THEMES.FSH_THEME
Sales District
  • Sales District
  • Client
  • C_ARUNRELEASECHECKCOMPQUERY.SALESDISTRICT == T171.BZIRK
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == T171.MANDT
Sales document item category
  • Client
  • Sales document item category
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == TVPT.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Sales group
  • Client
  • Sales group
  • Sales office
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == TVBVK.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.SALESGROUP == TVBVK.VKGRP
  • C_ARUNRELEASECHECKCOMPQUERY.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == TVKO.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.SALESORGANIZATION == TVKO.VKORG
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == TVSB.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == TVST.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Client
  • Plant (Own or External)
  • Storage location
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == T001L.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.PLANT == T001L.WERKS
  • C_ARUNRELEASECHECKCOMPQUERY.STORAGELOCATION == T001L.LGORT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Distribution Channel
  • Sales Organization
  • Division
  • Sales office
  • C_ARUNRELEASECHECKCOMPQUERY.MANDT == TVKBZ.MANDT
  • C_ARUNRELEASECHECKCOMPQUERY.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_ARUNRELEASECHECKCOMPQUERY.SALESORGANIZATION == TVKBZ.VKORG
  • C_ARUNRELEASECHECKCOMPQUERY.DIVISION == TVKBZ.SPART
  • C_ARUNRELEASECHECKCOMPQUERY.SALESOFFICE == TVKBZ.VKBUR