I_SupDmndAllDocPurReqnCube

Cube View for Purchase Requisition Details | view: ISUPDMNDADPRC | TRAN | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
Material FK Material Number
Plant FK Plant
Batch Batch Number
StorageLocation Storage location
SupplyNumber null
SupplyItem null
SupplyScheduleLine null
ProductAvailabilityDate Item delivery date
AssignedSupplyType null
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Price in Purchase Requisition
Column Name Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
TotalQuantity null
OpenSupplyQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
Column Name Description
ProductAvailabilityDate Item delivery date
RequestedDeliveryDate Item delivery date
Column Name Description
Column Name Description Domain name
PreviewAssignedQuantityInBsUnt null
ARunTmpAssignedQuantityInBsUnt null
CalendarYear Calendar Year
CalendarMonth Calendar Month
CalendarMonthName Short Text for Fixed Values
CalendarWeek null
CalendarDay Calendar Day
SupAssgmtSource null
Customer null
CompanyCode null
PurchasingOrganization null
Master Data Relations Join Conditions
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • I_SUPDMNDALLDOCPURREQNCUBE.MANDT == T006.MANDT
  • I_SUPDMNDALLDOCPURREQNCUBE.BASEUNIT == T006.MSEHI
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_SUPDMNDALLDOCPURREQNCUBE.MANDT == MARA.MANDT
  • I_SUPDMNDALLDOCPURREQNCUBE.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Distribution channel for intercompany billing
  • Client
  • Distribution channel for intercompany billing
  • I_SUPDMNDALLDOCPURREQNCUBE.MANDT == TVTW.MANDT
  • I_SUPDMNDALLDOCPURREQNCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division for intercompany billing
  • Client
  • Division for intercompany billing
  • I_SUPDMNDALLDOCPURREQNCUBE.MANDT == TSPA.MANDT
  • I_SUPDMNDALLDOCPURREQNCUBE.DIVISION == TSPA.SPART
Currency Key
  • Client
  • Currency Key
  • I_SUPDMNDALLDOCPURREQNCUBE.MANDT == TCURC.MANDT
  • I_SUPDMNDALLDOCPURREQNCUBE.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • I_SUPDMNDALLDOCPURREQNCUBE.MANDT == MARA.MANDT
  • I_SUPDMNDALLDOCPURREQNCUBE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_SUPDMNDALLDOCPURREQNCUBE.MANDT == T023.MANDT
  • I_SUPDMNDALLDOCPURREQNCUBE.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • I_SUPDMNDALLDOCPURREQNCUBE.MANDT == T134.MANDT
  • I_SUPDMNDALLDOCPURREQNCUBE.MATERIALTYPE == T134.MTART
Plant
  • Client
  • Plant
  • I_SUPDMNDALLDOCPURREQNCUBE.MANDT == T001W.MANDT
  • I_SUPDMNDALLDOCPURREQNCUBE.PLANT == T001W.WERKS
Purchasing Group
  • Purchasing Group
  • Client
  • I_SUPDMNDALLDOCPURREQNCUBE.PURCHASINGGROUP == T024.EKGRP
  • I_SUPDMNDALLDOCPURREQNCUBE.MANDT == T024.MANDT
Sales District
  • Client
  • Sales District
  • I_SUPDMNDALLDOCPURREQNCUBE.MANDT == T171.MANDT
  • I_SUPDMNDALLDOCPURREQNCUBE.SALESDISTRICT == T171.BZIRK
Sales Organization for Intercompany Billing
  • Client
  • Sales Organization for Intercompany Billing
  • I_SUPDMNDALLDOCPURREQNCUBE.MANDT == TVKO.MANDT
  • I_SUPDMNDALLDOCPURREQNCUBE.SALESORGANIZATION == TVKO.VKORG