C_SupDmndOvwPgExcessRqmtsQ

Query View for Excess Requirements | view: CSDOPEXCRQMTQ | 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

🔑 Keys (3)
💰 Amounts
∑ Quantities (4)
📅 Dates (1)
☰ Categorical
Other (2)
🔗 Relations (12)

Column Name	Description
RequirementDocumentNumber FK	Sales Document
RequirementDocumentItem	Sales Document Item
RequirementType	null

Column Name	Description

Column Name	Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
OpenForConfQtyInBaseUnit	null
OpenContrRefQtyInBsUnt	null
OpenForAssignmentQtyInBsUnt	null
OpenForDeliveryQtyInBsUnt	null

Column Name	Description
RequestedDeliveryDate	null

Column Name	Description

Column Name	Description	Domain name
Plant	Plant (Own or External)	WERKS
RequirementSegment	Requirement Segment	SGT_SRCA

Master Data Relations	Join Conditions
Base Unit of Measure Base Unit of Measure Client	`C_SUPDMNDOVWPGEXCESSRQMTSQ.BASEUNIT == T006.MSEHI` `C_SUPDMNDOVWPGEXCESSRQMTSQ.MANDT == T006.MANDT`
Company Code to Be Billed Company Code to Be Billed Client	`C_SUPDMNDOVWPGEXCESSRQMTSQ.COMPANYCODE == T001.BUKRS` `C_SUPDMNDOVWPGEXCESSRQMTSQ.MANDT == T001.MANDT`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`C_SUPDMNDOVWPGEXCESSRQMTSQ.MANDT == MARA.MANDT` `C_SUPDMNDOVWPGEXCESSRQMTSQ.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR`
Sold-to Party Sold-to Party Client	`C_SUPDMNDOVWPGEXCESSRQMTSQ.CUSTOMER == KNA1.KUNNR` `C_SUPDMNDOVWPGEXCESSRQMTSQ.MANDT == KNA1.MANDT`
Customer Group Client Customer Group	`C_SUPDMNDOVWPGEXCESSRQMTSQ.MANDT == T151.MANDT` `C_SUPDMNDOVWPGEXCESSRQMTSQ.CUSTOMERGROUP == T151.KDGRP`
Distribution channel in order header Distribution Channel Client Sales Organization	`C_SUPDMNDOVWPGEXCESSRQMTSQ.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `C_SUPDMNDOVWPGEXCESSRQMTSQ.MANDT == TVKOV.MANDT` `C_SUPDMNDOVWPGEXCESSRQMTSQ.SALESORGANIZATION == TVKOV.VKORG`
Division in order header Distribution Channel Client Division Sales Organization	`C_SUPDMNDOVWPGEXCESSRQMTSQ.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `C_SUPDMNDOVWPGEXCESSRQMTSQ.MANDT == TVTA.MANDT` `C_SUPDMNDOVWPGEXCESSRQMTSQ.DIVISION == TVTA.SPART` `C_SUPDMNDOVWPGEXCESSRQMTSQ.SALESORGANIZATION == TVTA.VKORG`
Material: order item Material Number Client	`C_SUPDMNDOVWPGEXCESSRQMTSQ.MATERIAL == MARA.MATNR` `C_SUPDMNDOVWPGEXCESSRQMTSQ.MANDT == MARA.MANDT`
Material Group Material Group Client	`C_SUPDMNDOVWPGEXCESSRQMTSQ.MATERIALGROUP == T023.MATKL` `C_SUPDMNDOVWPGEXCESSRQMTSQ.MANDT == T023.MANDT`
Sales District Sales District Client	`C_SUPDMNDOVWPGEXCESSRQMTSQ.SALESDISTRICT == T171.BZIRK` `C_SUPDMNDOVWPGEXCESSRQMTSQ.MANDT == T171.MANDT`
Sales organization in order header Client Sales Organization	`C_SUPDMNDOVWPGEXCESSRQMTSQ.MANDT == TVKO.MANDT` `C_SUPDMNDOVWPGEXCESSRQMTSQ.SALESORGANIZATION == TVKO.VKORG`