I_SupDmndAllDocSDItmBsc

Basic View for Sales Document | view: ISUPDMNDADSDITMB | 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, TVEP, CVI_VEND_LINK

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

Column Name	Description

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

Column Name	Description
ScheduleLineOrderQuantity	Requested Requirement Quantity in Base Unit
ConfdOrderQtyByMatlAvailCheck	Confirmed Requirement Quantity in Base Unit
DeliveredQuantityInBaseUnit	null
SalesContractReleasedQuantity	null

Column Name	Description
RequestedDate	Schedule line date
ProductAvailabilityDate	Material Staging/Availability Date
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

Column Name	Description	Domain name
RequirementDocumentNumber	Sales Document	VBELN
RequirementDocumentItem	Sales Document Item	POSNR
RequirementType	null
Plant	Plant (Own or External)	WERKS
RequirementSegment	Requirement Segment	SGT_SRCA
SoldToParty	null

Master Data Relations	Join Conditions
Base Unit of Measure Client Base Unit of Measure	`I_SUPDMNDALLDOCSDITMBSC.MANDT == T006.MANDT` `I_SUPDMNDALLDOCSDITMBSC.BASEUNIT == T006.MSEHI`
Company Code to Be Billed Client Company Code to Be Billed	`I_SUPDMNDALLDOCSDITMBSC.MANDT == T001.MANDT` `I_SUPDMNDALLDOCSDITMBSC.COMPANYCODE == T001.BUKRS`
Distribution channel in order header Client Distribution Channel Sales Organization	`I_SUPDMNDALLDOCSDITMBSC.MANDT == TVKOV.MANDT` `I_SUPDMNDALLDOCSDITMBSC.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `I_SUPDMNDALLDOCSDITMBSC.SALESORGANIZATION == TVKOV.VKORG`
Division in order header Client Distribution Channel Division Sales Organization	`I_SUPDMNDALLDOCSDITMBSC.MANDT == TVTA.MANDT` `I_SUPDMNDALLDOCSDITMBSC.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `I_SUPDMNDALLDOCSDITMBSC.DIVISION == TVTA.SPART` `I_SUPDMNDALLDOCSDITMBSC.SALESORGANIZATION == TVTA.VKORG`
SD Document Currency Client SD Document Currency	`I_SUPDMNDALLDOCSDITMBSC.MANDT == TCURC.MANDT` `I_SUPDMNDALLDOCSDITMBSC.DOCUMENTCURRENCY == TCURC.WAERS`
Material: order item Client Material Number	`I_SUPDMNDALLDOCSDITMBSC.MANDT == MARA.MANDT` `I_SUPDMNDALLDOCSDITMBSC.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`I_SUPDMNDALLDOCSDITMBSC.MANDT == T023.MANDT` `I_SUPDMNDALLDOCSDITMBSC.MATERIALGROUP == T023.MATKL`
Order type in order header Client Sales Document Type	`I_SUPDMNDALLDOCSDITMBSC.MANDT == TVAK.MANDT` `I_SUPDMNDALLDOCSDITMBSC.ORDERTYPE == TVAK.AUART`
Item category in purchasing document Client Item category in purchasing document	`I_SUPDMNDALLDOCSDITMBSC.MANDT == T163.MANDT` `I_SUPDMNDALLDOCSDITMBSC.REFERENCESCHEDULELINECATEGORY == T163.PSTYP`
Sales District Client Sales District	`I_SUPDMNDALLDOCSDITMBSC.MANDT == T171.MANDT` `I_SUPDMNDALLDOCSDITMBSC.SALESDISTRICT == T171.BZIRK`
Sales organization in order header Client Sales Organization	`I_SUPDMNDALLDOCSDITMBSC.MANDT == TVKO.MANDT` `I_SUPDMNDALLDOCSDITMBSC.SALESORGANIZATION == TVKO.VKORG`
Schedule line category Schedule line category Client	`I_SUPDMNDALLDOCSDITMBSC.SCHEDULELINECATEGORY == TVEP.ETTYP` `I_SUPDMNDALLDOCSDITMBSC.MANDT == TVEP.MANDT`
Storage location Client Storage location Plant (Own or External)	`I_SUPDMNDALLDOCSDITMBSC.MANDT == T001L.MANDT` `I_SUPDMNDALLDOCSDITMBSC.STORAGELOCATION == T001L.LGORT` `I_SUPDMNDALLDOCSDITMBSC.PLANT == T001L.WERKS`