I_SupDmndOvwPgExcessRqmtsC

Cube View for Excess Requirements | view: ISDOPEXCRQMTC | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAP, VBAK, EKKO, EKPO, EKKO, EKPO, EKPV, EKET, VBAK, VBAP, VBKD, VBPA, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, VBFA, ARUN_BDBS, KNA1, KNVV, TVEP, MARC, TVAK, MARC, MARA, LFA1
Column Name Description
RequirementDocumentNumber FK Sales Document
RequirementDocumentItem Sales Document Item
Column Name Description
Column Name Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
OpenForConfQtyInBaseUnit null
OpenForAssignmentQtyInBsUnt null
OpenContrRefQtyInBsUnt null
OpenForDeliveryQtyInBsUnt null
Column Name Description
RequestedDeliveryDate null
Column Name Description
Column Name Description Domain name
RequirementType null
Plant Plant (Own or External) WERKS
RequirementSegment Requirement Segment SGT_SRCA
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_SUPDMNDOVWPGEXCESSRQMTSC.MANDT == T006.MANDT
  • I_SUPDMNDOVWPGEXCESSRQMTSC.BASEUNIT == T006.MSEHI
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • I_SUPDMNDOVWPGEXCESSRQMTSC.MANDT == T001.MANDT
  • I_SUPDMNDOVWPGEXCESSRQMTSC.COMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_SUPDMNDOVWPGEXCESSRQMTSC.MANDT == MARA.MANDT
  • I_SUPDMNDOVWPGEXCESSRQMTSC.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Sold-to Party
  • Sold-to Party
  • Client
  • I_SUPDMNDOVWPGEXCESSRQMTSC.CUSTOMER == KNA1.KUNNR
  • I_SUPDMNDOVWPGEXCESSRQMTSC.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • I_SUPDMNDOVWPGEXCESSRQMTSC.MANDT == T151.MANDT
  • I_SUPDMNDOVWPGEXCESSRQMTSC.CUSTOMERGROUP == T151.KDGRP
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • I_SUPDMNDOVWPGEXCESSRQMTSC.MANDT == TVKOV.MANDT
  • I_SUPDMNDOVWPGEXCESSRQMTSC.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SUPDMNDOVWPGEXCESSRQMTSC.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • Division
  • I_SUPDMNDOVWPGEXCESSRQMTSC.MANDT == TVTA.MANDT
  • I_SUPDMNDOVWPGEXCESSRQMTSC.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SUPDMNDOVWPGEXCESSRQMTSC.SALESORGANIZATION == TVTA.VKORG
  • I_SUPDMNDOVWPGEXCESSRQMTSC.DIVISION == TVTA.SPART
Material: order item
  • Client
  • Material Number
  • I_SUPDMNDOVWPGEXCESSRQMTSC.MANDT == MARA.MANDT
  • I_SUPDMNDOVWPGEXCESSRQMTSC.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_SUPDMNDOVWPGEXCESSRQMTSC.MANDT == T023.MANDT
  • I_SUPDMNDOVWPGEXCESSRQMTSC.MATERIALGROUP == T023.MATKL
Sales District
  • Client
  • Sales District
  • I_SUPDMNDOVWPGEXCESSRQMTSC.MANDT == T171.MANDT
  • I_SUPDMNDOVWPGEXCESSRQMTSC.SALESDISTRICT == T171.BZIRK
Sales organization in order header
  • Client
  • Sales Organization
  • I_SUPDMNDOVWPGEXCESSRQMTSC.MANDT == TVKO.MANDT
  • I_SUPDMNDOVWPGEXCESSRQMTSC.SALESORGANIZATION == TVKO.VKORG