I_SupDmndAllDocSD

View for Sales Document | view: ISUPDMNDADSD | Extraction: Not supported | Component: Order Allocation Run

Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, VBPA, VBPA, EKPO, MATDOC, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, TVAK, TVEP, MARA, MARC, ARUN_BDBS, ARUN_PREVIEW, CVI_VEND_LINK

🔑 Keys
💰 Amounts
∑ Quantities (6)
📅 Dates (4)
☰ Categorical (4)
Other (6)
🔗 Relations (13)

Column Name	Description

Column Name	Description

Column Name	Description
RequestedRqmtQtyInBaseUnit	null
ConfirmedRqmtQtyInBaseUnit	null
DeliveredQuantityInBaseUnit	null
OpenDemandQuantity	null
AssignedQuantityInBaseUnit	null
NormalAssignedQuantityInBsUnt	null

Column Name	Description
RequestedDate	Material Staging/Availability Date
ProductAvailabilityDate	Material Staging/Availability Date
RequestedDeliveryDate	null
FashionCancelDate	Cancellation Date

Column Name	Description
SDDocumentCategory	SD Document Category	Show values
DeliveryBlockStatus	Delivery Block Status (Item)	Show values
TotalBlockStatus	Overall Block Status (Header)	Show values
SegmentationStrategyScope	Segmentation Strategy Scope	Show values

Column Name	Description	Domain name
RequirementDocumentNumber	Sales Document	VBELN
RequirementDocumentItem	Sales Document Item	POSNR
RequirementType	null
PreviewAssignedQuantityInBsUnt	null
SoldToParty	null
RequirementSegment	Requirement Segment	SGT_SRCA

Master Data Relations	Join Conditions
Base Unit of Measure Client Base Unit of Measure	`I_SUPDMNDALLDOCSD.MANDT == T006.MANDT` `I_SUPDMNDALLDOCSD.BASEUNIT == T006.MSEHI`
Company Code to Be Billed Company Code to Be Billed Client	`I_SUPDMNDALLDOCSD.COMPANYCODE == T001.BUKRS` `I_SUPDMNDALLDOCSD.MANDT == T001.MANDT`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`I_SUPDMNDALLDOCSD.MANDT == MARA.MANDT` `I_SUPDMNDALLDOCSD.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR`
Distribution channel in order header Distribution Channel Client Sales Organization	`I_SUPDMNDALLDOCSD.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `I_SUPDMNDALLDOCSD.MANDT == TVKOV.MANDT` `I_SUPDMNDALLDOCSD.SALESORGANIZATION == TVKOV.VKORG`
Division in order header Division Distribution Channel Client Sales Organization	`I_SUPDMNDALLDOCSD.DIVISION == TVTA.SPART` `I_SUPDMNDALLDOCSD.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `I_SUPDMNDALLDOCSD.MANDT == TVTA.MANDT` `I_SUPDMNDALLDOCSD.SALESORGANIZATION == TVTA.VKORG`
Material Number Material Number Client	`I_SUPDMNDALLDOCSD.MATERIAL == MARA.MATNR` `I_SUPDMNDALLDOCSD.MANDT == MARA.MANDT`
Material Group Material Group Client	`I_SUPDMNDALLDOCSD.MATERIALGROUP == T023.MATKL` `I_SUPDMNDALLDOCSD.MANDT == T023.MANDT`
Order type in order header Client Sales Document Type	`I_SUPDMNDALLDOCSD.MANDT == TVAK.MANDT` `I_SUPDMNDALLDOCSD.ORDERTYPE == TVAK.AUART`
Plant Client Plant	`I_SUPDMNDALLDOCSD.MANDT == T001W.MANDT` `I_SUPDMNDALLDOCSD.PLANT == T001W.WERKS`
Sales District Sales District Client	`I_SUPDMNDALLDOCSD.SALESDISTRICT == T171.BZIRK` `I_SUPDMNDALLDOCSD.MANDT == T171.MANDT`
Sales organization in order header Client Sales Organization	`I_SUPDMNDALLDOCSD.MANDT == TVKO.MANDT` `I_SUPDMNDALLDOCSD.SALESORGANIZATION == TVKO.VKORG`
Segmentation Strategy Segmentation Strategy ? Client	`I_SUPDMNDALLDOCSD.SEGMENTATIONSTRATEGY == SGT_COVS_T.SGT_COVS` `I_SUPDMNDALLDOCSD.[column in domain "WERKS_D"] == SGT_COVS_T.WERKS` `I_SUPDMNDALLDOCSD.MANDT == SGT_COVS_T.MANDT`
Storage location Storage location Client Plant	`I_SUPDMNDALLDOCSD.STORAGELOCATION == T001L.LGORT` `I_SUPDMNDALLDOCSD.MANDT == T001L.MANDT` `I_SUPDMNDALLDOCSD.PLANT == T001L.WERKS`