C_ARunRelChkDetailedAmtQuery

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