I_ARunRelChkDetailedAmountCube

Detailed Analysis amount cube view | view: IRELAMTCUBE | 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
ActlAmt Net Value in Document Currency
💲 Display Currency (DisplayCurrency):
TotActualAmtInDisplayCurrency Sales Plan Amount in Display Currency
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
UnassignedQtyInBaseUnit 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
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
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
ARunMatlAvailyDateRelChkPct null
ARunItemRelChkPct null
ARunGenericArticleRelChkPct null
ARunDelivGrpRelChkPct null
ARunHeaderRelChkPct null
ARunShipgGrpRelChkPct null
ARunMatlAvailyDateRelFlfmtPct null
ARunItemRelFlfmtPct null
ARunGenericArticleRelFlfmtPct null
ARunDelivGrpRelFlfmtPct null
ARunHeaderRelFlfmtPct null
ARunShipgGrpRelFlfmtPct null
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVV3.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVV4.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVV5.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Business Area
  • Client
  • Business Area
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TGSB.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.BUSINESSAREA == TGSB.GSBER
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.COMPANYCODE == T001.BUKRS
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == MARA.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Group
  • Client
  • Customer Group
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == T151.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.CUSTOMERGROUP == T151.KDGRP
Delivery Priority
  • Client
  • Delivery Priority
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TPRIO.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.DELIVERYPRIORITY == TPRIO.LPRIO
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVKOV.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.SALESORGANIZATION == TVKOV.VKORG
Division
  • Client
  • Division
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TSPA.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.DIVISION == TSPA.SPART
SD Document Currency
  • Client
  • SD Document Currency
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TCURC.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.DOCUMENTCURRENCY == TCURC.WAERS
Billing Block for Item
  • Client
  • Billing Block for Item
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVFS.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
Material: order item
  • Client
  • Material Number
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == MARA.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == T023.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MATERIALGROUP == T023.MATKL
Order type in order header
  • Client
  • Sales Document Type
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVAK.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.ORDERTYPE == TVAK.AUART
Partner function - Document partner
  • Client
  • Partner Function
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TPAR.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.PARTNERFUNCTION == TPAR.PARVW
Fashion Collection
  • Client
  • Fashion Collection
  • Season
  • Season Year
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == FSH_COLLECTIONS.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.PRODUCTCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.PRODUCTSEASON == FSH_COLLECTIONS.FSH_SEASON
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.PRODUCTSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR
Season
  • Client
  • Season
  • Season Year
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == FSH_SEASONS.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Season Year
  • Client
  • Season
  • Season Year
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == FSH_SEASONS.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Fashion Theme
  • Client
  • Fashion Collection
  • Season
  • Fashion Theme
  • Season Year
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == FSH_THEMES.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
Sales District
  • Client
  • Sales District
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == T171.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.SALESDISTRICT == T171.BZIRK
Sales document item category
  • Client
  • Sales document item category
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVPT.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVAG.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Sales group
  • Client
  • Sales group
  • Sales office
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVBVK.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.SALESGROUP == TVBVK.VKGRP
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVKO.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.SALESORGANIZATION == TVKO.VKORG
Shipping Conditions
  • Client
  • Shipping Conditions
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVSB.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVST.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Client
  • Plant (Own or External)
  • Storage location
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == T001L.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.PLANT == T001L.WERKS
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.STORAGELOCATION == T001L.LGORT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Distribution Channel
  • Sales office
  • Sales Organization
  • Division
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.MANDT == TVKBZ.MANDT
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.SALESOFFICE == TVKBZ.VKBUR
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.SALESORGANIZATION == TVKBZ.VKORG
  • I_ARUNRELCHKDETAILEDAMOUNTCUBE.DIVISION == TVKBZ.SPART