I_SupDmndAllDocSDItm

View for Sales Document Item | view: ISUPDMNDADSDITM | 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, CVI_VEND_LINK

🔑 Keys
💰 Amounts (1)
∑ Quantities (4)
📅 Dates (4)
☰ Categorical (4)
Other (5)
🔗 Relations (15)

Column Name	Description

Column Name	Description
💲 SD Document Currency (DocumentCurrency):
NetPriceAmount	Net Price

Column Name	Description
RequestedRqmtQtyInBaseUnit	null
ConfirmedRqmtQtyInBaseUnit	null
DeliveredQuantityInBaseUnit	null
SalesContractReleasedQuantity	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
RequirementSegment	Requirement Segment	SGT_SRCA
SoldToParty	null

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