C_ARunItmRsnCodeQuery

Query View for ARun Reason Code | view: CARUNRSNCODEQRY | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAK, VBAP, VBKD, EKKO, EKPO, EKPV, ARUN_BOP_REQ_LOG, EKET, VBEP, VBPA, VBPA, ATP_BOP_VARIANT, KNA1, KNA1, ARUN_RULE, ARUN_RULE_TEXT, ARUN_SIM_LOG, ATP_CHECK, ATP_FUP_RUN, ATP_SELD_FU_RQMT, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, T161T, TVAKT, MARA, MARC, KNVV, CVI_VEND_LINK, ATP_SELD_RQMT
Column Name Description
ATPCheckUUID Check ID
RequirementDocumentNumber Document Number
RequirementDocumentItem Line Item Number
RequestedDate Item delivery date
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):
RequestedRqmtQtyInBaseUnit null
Column Name Description
RequestedDate Item delivery date
Column Name Description
ABOPExecutionMode Indicates if ATP Check was a Simulation Show values
ABOPAssignmentPreviewIsActive Supply Assignment: Preview Show values
Column Name Description Domain name
ABOPVariantUUID BOP Variant UUID
ABOPVariantName Name for BOP Variant
StartedByUser User Name SYCHAR12
ATPCheckStatus null
ATPRlvtDocItmIsSupAssgmtRlvt null
SupAssgmtItemStatus Reason for Supply Assignment Status
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_ARUNITMRSNCODEQUERY.COMPANYCODE == T001.BUKRS
  • C_ARUNITMRSNCODEQUERY.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • C_ARUNITMRSNCODEQUERY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • C_ARUNITMRSNCODEQUERY.MANDT == MARA.MANDT
Customer Group
  • Customer Group
  • Client
  • C_ARUNITMRSNCODEQUERY.CUSTOMERGROUP == T151.KDGRP
  • C_ARUNITMRSNCODEQUERY.MANDT == T151.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • C_ARUNITMRSNCODEQUERY.SALESORGANIZATION == TVKOV.VKORG
  • C_ARUNITMRSNCODEQUERY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_ARUNITMRSNCODEQUERY.MANDT == TVKOV.MANDT
Division
  • Division
  • Client
  • C_ARUNITMRSNCODEQUERY.DIVISION == TSPA.SPART
  • C_ARUNITMRSNCODEQUERY.MANDT == TSPA.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • C_ARUNITMRSNCODEQUERY.MANDT == TCURC.MANDT
  • C_ARUNITMRSNCODEQUERY.DOCUMENTCURRENCY == TCURC.WAERS
Material Group
  • Client
  • Material Group
  • C_ARUNITMRSNCODEQUERY.MANDT == T023.MANDT
  • C_ARUNITMRSNCODEQUERY.MATERIALGROUP == T023.MATKL
Order type in order header
  • Sales Document Type
  • Client
  • C_ARUNITMRSNCODEQUERY.ORDERTYPE == TVAK.AUART
  • C_ARUNITMRSNCODEQUERY.MANDT == TVAK.MANDT
Fashion Collection
  • Season
  • Season Year
  • Fashion Collection
  • Client
Season
  • Season
  • Season Year
  • Client
  • C_ARUNITMRSNCODEQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • C_ARUNITMRSNCODEQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_ARUNITMRSNCODEQUERY.MANDT == FSH_SEASONS.MANDT
Season Year
  • Season
  • Season Year
  • Client
  • C_ARUNITMRSNCODEQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • C_ARUNITMRSNCODEQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_ARUNITMRSNCODEQUERY.MANDT == FSH_SEASONS.MANDT
Fashion Theme
  • Season
  • Season Year
  • Fashion Collection
  • Fashion Theme
  • Client
  • C_ARUNITMRSNCODEQUERY.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • C_ARUNITMRSNCODEQUERY.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • C_ARUNITMRSNCODEQUERY.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • C_ARUNITMRSNCODEQUERY.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • C_ARUNITMRSNCODEQUERY.MANDT == FSH_THEMES.MANDT
Sales District
  • Sales District
  • Client
  • C_ARUNITMRSNCODEQUERY.SALESDISTRICT == T171.BZIRK
  • C_ARUNITMRSNCODEQUERY.MANDT == T171.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_ARUNITMRSNCODEQUERY.SALESORGANIZATION == TVKO.VKORG
  • C_ARUNITMRSNCODEQUERY.MANDT == TVKO.MANDT