S140

Product Allocations | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
KONOB FK Product allocation object
VKORG FK Sales Organization
VTWEG FK Distribution Channel
KDGRP FK Customer Group
KUNNR FK Sold-to Party
Column Name Description
Column Name Description
📏 Base Unit of Measure (BASME):
AEMENGE Incoming Orders Quantity
KCREQ Customer requirements
KCQTY Product allocation qty
KUDMD Requirements not covered
KLTBK Open product allocation qty
KCUBL Default division
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
KOFLG Indicator Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
Master Data Relations Join Conditions
Base Unit of Measure
  • S140.MANDT == T006.MANDT
  • S140.BASME == T006.MSEHI
Customer Group
  • Customer Group
  • Client
  • S140.KDGRP == T151.KDGRP
  • S140.MANDT == T151.MANDT
Product allocation object
  • Product allocation object
  • Client
  • S140.KONOB == T190O.KONOB
  • S140.MANDT == T190O.MANDT
Sold-to Party
  • S140.MANDT == KNA1.MANDT
  • S140.KUNNR == KNA1.KUNNR
Client S140.MANDT == T000.MANDT
Sales organization in order header
  • S140.MANDT == TVKO.MANDT
  • S140.VKORG == TVKO.VKORG
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • S140.VKORG == TVKOV.VKORG
  • S140.MANDT == TVKOV.MANDT
  • S140.VTWEG == TVKOV.VTWEG