I_ARunRelChkAmountCube

For Release Check compare amount view | view: IRELCHKAMTCUBE | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAK, VBAP, VBKD, EKKO, EKPO, EKPV, ARUN_RC_RUN_HEAD, 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
ActlAmt Net Value in Document Currency
NetPriceAmount Net Price
💲 Display Currency (DisplayCurrency):
TotActualAmtInDisplayCurrency Open Sales Orders for Ord.Reltd Billing Net Amount IDC
Column Name Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
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
OpenDemandQuantity Assigned Quantity by ARun
Column Name Description
ProductAvailabilityDate Material Staging/Availability Date
FashionCancelDate Cancellation Date
Column Name Description
SupAssgmtExecutionMode Execution Mode of Supply Assignment (ARun) 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
SupAssignRunIsSimulation Indicates if Release Check Run was a Simulation or Update Show values
Column Name Description Domain name
ARunReleaseCheckVariantUUID ARun Release Check Variant UUID SYSUUID
ARunReleaseCheckVariantName Name for ARun Release Check Variant ARUN_RC_VARIANT
RequirementDocumentNumber ARun Order Number ARUN_AUFN
RequirementDocumentItem ARun Order Item Number ARUN_POSN
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
ARunMatlAvailyDateRelChkPct null
ARunItemRelChkPct null
ARunGenericArticleRelChkPct null
ARunDelivGrpRelChkPct null
ARunHeaderRelChkPct null
ARunShipgGrpRelChkPct null
SoldToParty Sold-to Party KUNNR
RequestedDeliveryDate null
CustomerReferenceNumber Customer Reference BSTNK
ShipToParty Customer Number KUNNR
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
ProfitCenter Profit Center PRCTR
Plant Plant (Own or External) WERKS
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
OrderTypeName Sales Document Type Description TEXT20
CalendarMonth Calendar Month
CalendarWeek null
CalendarYear Calendar Year NUM4
CalendarMonthName Short Text for Fixed Values DDTEXT
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVV5.MANDT
Business Area
  • Business Area
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.BUSINESSAREA == TGSB.GSBER
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TGSB.MANDT
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.COMPANYCODE == T001.BUKRS
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == MARA.MANDT
Customer Group
  • Customer Group
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.CUSTOMERGROUP == T151.KDGRP
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == T151.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TPRIO.MANDT
Distribution channel in order header
  • Distribution Channel
  • Sales Organization
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_ARUNRELCHKAMOUNTCUBE.SALESORGANIZATION == TVKOV.VKORG
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVKOV.MANDT
Division
  • Client
  • Division
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TSPA.MANDT
  • I_ARUNRELCHKAMOUNTCUBE.DIVISION == TSPA.SPART
SD Document Currency
  • Client
  • SD Document Currency
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TCURC.MANDT
  • I_ARUNRELCHKAMOUNTCUBE.DOCUMENTCURRENCY == TCURC.WAERS
Billing Block for Item
  • Billing Block for Item
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVFS.MANDT
Material: order item
  • Client
  • Material Number
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == MARA.MANDT
  • I_ARUNRELCHKAMOUNTCUBE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == T023.MANDT
  • I_ARUNRELCHKAMOUNTCUBE.MATERIALGROUP == T023.MATKL
Order type in order header
  • Sales Document Type
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.ORDERTYPE == TVAK.AUART
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVAK.MANDT
Partner function - Document partner
  • Partner Function
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.PARTNERFUNCTION == TPAR.PARVW
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TPAR.MANDT
Fashion Collection
  • Season Year
  • Fashion Collection
  • Season
  • Client
Season
  • Season Year
  • Season
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_ARUNRELCHKAMOUNTCUBE.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == FSH_SEASONS.MANDT
Season Year
  • Season Year
  • Season
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_ARUNRELCHKAMOUNTCUBE.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == FSH_SEASONS.MANDT
Fashion Theme
  • Season Year
  • Fashion Collection
  • Fashion Theme
  • Season
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_ARUNRELCHKAMOUNTCUBE.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_ARUNRELCHKAMOUNTCUBE.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • I_ARUNRELCHKAMOUNTCUBE.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == FSH_THEMES.MANDT
Sales District
  • Sales District
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.SALESDISTRICT == T171.BZIRK
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == T171.MANDT
Sales document item category
  • Sales document item category
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVPT.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVAG.MANDT
Sales group
  • Sales office
  • Sales group
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.SALESOFFICE == TVBVK.VKBUR
  • I_ARUNRELCHKAMOUNTCUBE.SALESGROUP == TVBVK.VKGRP
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVBVK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.SALESORGANIZATION == TVKO.VKORG
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVKO.MANDT
Shipping Conditions
  • Client
  • Shipping Conditions
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVSB.MANDT
  • I_ARUNRELCHKAMOUNTCUBE.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.SHIPPINGPOINT == TVST.VSTEL
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVST.MANDT
Storage location
  • Storage location
  • Plant (Own or External)
  • Client
  • I_ARUNRELCHKAMOUNTCUBE.STORAGELOCATION == T001L.LGORT
  • I_ARUNRELCHKAMOUNTCUBE.PLANT == T001L.WERKS
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == T001L.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Distribution Channel
  • Sales Organization
  • Sales office
  • Client
  • Division
  • I_ARUNRELCHKAMOUNTCUBE.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_ARUNRELCHKAMOUNTCUBE.SALESORGANIZATION == TVKBZ.VKORG
  • I_ARUNRELCHKAMOUNTCUBE.SALESOFFICE == TVKBZ.VKBUR
  • I_ARUNRELCHKAMOUNTCUBE.MANDT == TVKBZ.MANDT
  • I_ARUNRELCHKAMOUNTCUBE.DIVISION == TVKBZ.SPART