C_ARunCompareAssgmtQuery

ARun Compare Assignments Query View | view: CARUNCOMPQUERY | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAK, VBAP, VBKD, EKKO, EKPO, EKPV, VBPA, VBPA, ATP_BOP_VARIANT, KNA1, KNA1, ARUN_RULE, ARUN_RULE_TEXT, ARUN_SIMULATION, ATP_CHECK, ATP_FUP_RUN, ATP_SELD_FU_RQMT, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, T161T, TVAKT, MARA, MARC, ARUN_BDBS, ARUN_PREVIEW, KNVV, CVI_VEND_LINK, ATP_SELD_RQMT
Column Name Description
ATPCheckUUID Check ID
RequirementDocumentNumber Document Number
RequirementDocumentItem Line Item Number
RequirementType Category of a Document Included in ATP Checks
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetPriceAmount Net Price
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Unit (BaseUnit):
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
PreviewAssignedQuantityInBsUnt null
Column Name Description
Column Name Description
ABOPExecutionMode Indicates if ATP Check was a Simulation Show values
Column Name Description Domain name
ABOPVariantUUID BOP Variant UUID
ABOPVariantName Name for BOP Variant
StartedByUser User Name SYCHAR12
ATPCheckStatus null
Material Material Number
Plant Plant WERKS
RequirementSegment Requirement Segment SGT_SRCA
OrderTypeName Sales Document Type Description
SoldToParty Sold-to Party
ShipToParty Customer Number
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
NetPriceQuantity Condition Pricing Unit KPEIN
Master Data Relations Join Conditions
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • C_ARUNCOMPAREASSGMTQUERY.COMPANYCODE == T001.BUKRS
  • C_ARUNCOMPAREASSGMTQUERY.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • C_ARUNCOMPAREASSGMTQUERY.MANDT == MARA.MANDT
  • C_ARUNCOMPAREASSGMTQUERY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Group
  • Customer Group
  • Client
  • C_ARUNCOMPAREASSGMTQUERY.CUSTOMERGROUP == T151.KDGRP
  • C_ARUNCOMPAREASSGMTQUERY.MANDT == T151.MANDT
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_ARUNCOMPAREASSGMTQUERY.MANDT == TVKOV.MANDT
  • C_ARUNCOMPAREASSGMTQUERY.SALESORGANIZATION == TVKOV.VKORG
  • C_ARUNCOMPAREASSGMTQUERY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Client
  • Division
  • C_ARUNCOMPAREASSGMTQUERY.MANDT == TSPA.MANDT
  • C_ARUNCOMPAREASSGMTQUERY.DIVISION == TSPA.SPART
SD Document Currency
  • Client
  • SD Document Currency
  • C_ARUNCOMPAREASSGMTQUERY.MANDT == TCURC.MANDT
  • C_ARUNCOMPAREASSGMTQUERY.DOCUMENTCURRENCY == TCURC.WAERS
Material Group
  • Client
  • Material Group
  • C_ARUNCOMPAREASSGMTQUERY.MANDT == T023.MANDT
  • C_ARUNCOMPAREASSGMTQUERY.MATERIALGROUP == T023.MATKL
Order type in order header
  • Sales Document Type
  • Client
  • C_ARUNCOMPAREASSGMTQUERY.ORDERTYPE == TVAK.AUART
  • C_ARUNCOMPAREASSGMTQUERY.MANDT == TVAK.MANDT
Fashion Collection
  • Fashion Collection
  • Season
  • Season Year
  • Client
Season
  • Season
  • Season Year
  • Client
  • C_ARUNCOMPAREASSGMTQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • C_ARUNCOMPAREASSGMTQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_ARUNCOMPAREASSGMTQUERY.MANDT == FSH_SEASONS.MANDT
Season Year
  • Season
  • Season Year
  • Client
  • C_ARUNCOMPAREASSGMTQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • C_ARUNCOMPAREASSGMTQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_ARUNCOMPAREASSGMTQUERY.MANDT == FSH_SEASONS.MANDT
Fashion Theme
  • Fashion Collection
  • Season
  • Season Year
  • Client
  • Fashion Theme
  • C_ARUNCOMPAREASSGMTQUERY.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • C_ARUNCOMPAREASSGMTQUERY.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • C_ARUNCOMPAREASSGMTQUERY.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • C_ARUNCOMPAREASSGMTQUERY.MANDT == FSH_THEMES.MANDT
  • C_ARUNCOMPAREASSGMTQUERY.PRODUCTTHEME == FSH_THEMES.FSH_THEME
Sales District
  • Client
  • Sales District
  • C_ARUNCOMPAREASSGMTQUERY.MANDT == T171.MANDT
  • C_ARUNCOMPAREASSGMTQUERY.SALESDISTRICT == T171.BZIRK
Sales organization in order header
  • Client
  • Sales Organization
  • C_ARUNCOMPAREASSGMTQUERY.MANDT == TVKO.MANDT
  • C_ARUNCOMPAREASSGMTQUERY.SALESORGANIZATION == TVKO.VKORG