C_ARunAnlytsPurgContrQry

Purchasing Contract Details Query | view: CARNANLYTSPCQ | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
Product FK Material Number
Plant FK Plant
Batch Batch Number
StorageLocation Storage location
SupplyNumber null
SupplyItem null
SupplyScheduleLine null
ProductAvailabilityDate Purchasing Document Date
AssignedSupplyType null
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
TotalQuantity null
OpenSupplyQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
ReleasedQuantity Target Quantity
Column Name Description
ProductAvailabilityDate Purchasing Document Date
RequestedDeliveryDate Purchasing Document Date
Column Name Description
Column Name Description Domain name
PreviewAssignedQuantityInBsUnt null
ARunTmpAssignedQuantityInBsUnt null
CalendarYear Calendar Year
CalendarMonth Calendar Month
CalendarMonthName Short Text for Fixed Values
CalendarWeek null
CalendarDay Calendar Day
SupAssgmtSource null
ProductType Material type
CrossPlantConfigurableProduct Cross-Plant Configurable Material MATNR
Customer null
CompanyCode null
PurchasingOrganization null
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_ARUNANLYTSPURGCONTRQRY.BASEUNIT == T006.MSEHI
  • C_ARUNANLYTSPURGCONTRQRY.MANDT == T006.MANDT
Distribution channel for intercompany billing
  • Distribution channel for intercompany billing
  • Client
  • C_ARUNANLYTSPURGCONTRQRY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_ARUNANLYTSPURGCONTRQRY.MANDT == TVTW.MANDT
Division for intercompany billing
  • Division for intercompany billing
  • Client
  • C_ARUNANLYTSPURGCONTRQRY.DIVISION == TSPA.SPART
  • C_ARUNANLYTSPURGCONTRQRY.MANDT == TSPA.MANDT
Currency Key
  • Currency Key
  • Client
  • C_ARUNANLYTSPURGCONTRQRY.DOCUMENTCURRENCY == TCURC.WAERS
  • C_ARUNANLYTSPURGCONTRQRY.MANDT == TCURC.MANDT
Plant
  • Plant
  • Client
  • C_ARUNANLYTSPURGCONTRQRY.PLANT == T001W.WERKS
  • C_ARUNANLYTSPURGCONTRQRY.MANDT == T001W.MANDT
Material Number
  • Material Number
  • Client
  • C_ARUNANLYTSPURGCONTRQRY.PRODUCT == MARA.MATNR
  • C_ARUNANLYTSPURGCONTRQRY.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_ARUNANLYTSPURGCONTRQRY.PRODUCTGROUP == T023.MATKL
  • C_ARUNANLYTSPURGCONTRQRY.MANDT == T023.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_ARUNANLYTSPURGCONTRQRY.PURCHASINGGROUP == T024.EKGRP
  • C_ARUNANLYTSPURGCONTRQRY.MANDT == T024.MANDT
Sales District
  • Sales District
  • Client
  • C_ARUNANLYTSPURGCONTRQRY.SALESDISTRICT == T171.BZIRK
  • C_ARUNANLYTSPURGCONTRQRY.MANDT == T171.MANDT
Sales Organization for Intercompany Billing
  • Sales Organization for Intercompany Billing
  • Client
  • C_ARUNANLYTSPURGCONTRQRY.SALESORGANIZATION == TVKO.VKORG
  • C_ARUNANLYTSPURGCONTRQRY.MANDT == TVKO.MANDT