C_ARunOvwConfStrgyQuery

Query View ARun Confirmation Strategy | view: CARUNOSTRGYQUERY | 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
ABOPConfirmationStrategy Confirmation Strategy
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
  • Client
  • Company Code to Be Billed
  • C_ARUNOVWCONFSTRGYQUERY.MANDT == T001.MANDT
  • C_ARUNOVWCONFSTRGYQUERY.COMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • C_ARUNOVWCONFSTRGYQUERY.MANDT == MARA.MANDT
  • C_ARUNOVWCONFSTRGYQUERY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Group
  • Customer Group
  • Client
  • C_ARUNOVWCONFSTRGYQUERY.CUSTOMERGROUP == T151.KDGRP
  • C_ARUNOVWCONFSTRGYQUERY.MANDT == T151.MANDT
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • C_ARUNOVWCONFSTRGYQUERY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_ARUNOVWCONFSTRGYQUERY.MANDT == TVKOV.MANDT
  • C_ARUNOVWCONFSTRGYQUERY.SALESORGANIZATION == TVKOV.VKORG
Division
  • Client
  • Division
  • C_ARUNOVWCONFSTRGYQUERY.MANDT == TSPA.MANDT
  • C_ARUNOVWCONFSTRGYQUERY.DIVISION == TSPA.SPART
SD Document Currency
  • SD Document Currency
  • Client
  • C_ARUNOVWCONFSTRGYQUERY.DOCUMENTCURRENCY == TCURC.WAERS
  • C_ARUNOVWCONFSTRGYQUERY.MANDT == TCURC.MANDT
Material Group
  • Client
  • Material Group
  • C_ARUNOVWCONFSTRGYQUERY.MANDT == T023.MANDT
  • C_ARUNOVWCONFSTRGYQUERY.MATERIALGROUP == T023.MATKL
Order type in order header
  • Client
  • Sales Document Type
  • C_ARUNOVWCONFSTRGYQUERY.MANDT == TVAK.MANDT
  • C_ARUNOVWCONFSTRGYQUERY.ORDERTYPE == TVAK.AUART
Fashion Collection
  • Fashion Collection
  • Client
  • Season
  • Season Year
Season
  • Client
  • Season
  • Season Year
  • C_ARUNOVWCONFSTRGYQUERY.MANDT == FSH_SEASONS.MANDT
  • C_ARUNOVWCONFSTRGYQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • C_ARUNOVWCONFSTRGYQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Season Year
  • Client
  • Season
  • Season Year
  • C_ARUNOVWCONFSTRGYQUERY.MANDT == FSH_SEASONS.MANDT
  • C_ARUNOVWCONFSTRGYQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • C_ARUNOVWCONFSTRGYQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Fashion Theme
  • Fashion Theme
  • Fashion Collection
  • Client
  • Season
  • Season Year
  • C_ARUNOVWCONFSTRGYQUERY.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • C_ARUNOVWCONFSTRGYQUERY.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • C_ARUNOVWCONFSTRGYQUERY.MANDT == FSH_THEMES.MANDT
  • C_ARUNOVWCONFSTRGYQUERY.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • C_ARUNOVWCONFSTRGYQUERY.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
Sales District
  • Sales District
  • Client
  • C_ARUNOVWCONFSTRGYQUERY.SALESDISTRICT == T171.BZIRK
  • C_ARUNOVWCONFSTRGYQUERY.MANDT == T171.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • C_ARUNOVWCONFSTRGYQUERY.MANDT == TVKO.MANDT
  • C_ARUNOVWCONFSTRGYQUERY.SALESORGANIZATION == TVKO.VKORG