I_SupDmndAllDocSupAmtCube

Cube view for Amount in Display Currency | view: ISUPDALLDOCSCUBE | TRAN | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
ActlAmt Net Value in Document Currency
💲 null (DisplayCurrency):
TotActualAmtInDisplayCurrency Net Value in Display Currency
Column Name Description
TotalQuantity null
OpenSupplyQuantity null
Column Name Description
ProductAvailabilityDate Purchasing Document Date
RequestedDeliveryDate Purchasing Document Date
Column Name Description
Column Name Description Domain name
Batch Batch Number CHARG
StorageLocation Storage location LGORT
SupplyNumber null
SupplyItem null
SupplyScheduleLine null
AssignedSupplyType null
SupAssgmtSource null
MaterialType Material type MTART
StockSegment Stock Segment SGT_SRCA
CrossPlantConfigurableProduct Cross-Plant Configurable Material MATNR
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
SalesDistrict Sales District BZIRK
SalesOrder Sales and Distribution Document Number VBELN
SalesOrderItem Item number of the SD document POSNR
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • I_SUPDMNDALLDOCSUPAMTCUBE.MANDT == T006.MANDT
  • I_SUPDMNDALLDOCSUPAMTCUBE.BASEUNIT == T006.MSEHI
Company Code
  • Client
  • Company Code
  • I_SUPDMNDALLDOCSUPAMTCUBE.MANDT == T001.MANDT
  • I_SUPDMNDALLDOCSUPAMTCUBE.COMPANYCODE == T001.BUKRS
Customer
  • Client
  • Customer
  • I_SUPDMNDALLDOCSUPAMTCUBE.MANDT == KNA1.MANDT
  • I_SUPDMNDALLDOCSUPAMTCUBE.CUSTOMER == KNA1.KUNNR
Currency Key
  • Currency Key
  • Client
  • I_SUPDMNDALLDOCSUPAMTCUBE.DOCUMENTCURRENCY == TCURC.WAERS
  • I_SUPDMNDALLDOCSUPAMTCUBE.MANDT == TCURC.MANDT
Material Number
  • Client
  • Material Number
  • I_SUPDMNDALLDOCSUPAMTCUBE.MANDT == MARA.MANDT
  • I_SUPDMNDALLDOCSUPAMTCUBE.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • I_SUPDMNDALLDOCSUPAMTCUBE.MATERIALGROUP == T023.MATKL
  • I_SUPDMNDALLDOCSUPAMTCUBE.MANDT == T023.MANDT
Plant
  • Client
  • Plant
  • I_SUPDMNDALLDOCSUPAMTCUBE.MANDT == T001W.MANDT
  • I_SUPDMNDALLDOCSUPAMTCUBE.PLANT == T001W.WERKS
Purchasing Group
  • Purchasing Group
  • Client
  • I_SUPDMNDALLDOCSUPAMTCUBE.PURCHASINGGROUP == T024.EKGRP
  • I_SUPDMNDALLDOCSUPAMTCUBE.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • I_SUPDMNDALLDOCSUPAMTCUBE.MANDT == T024E.MANDT
  • I_SUPDMNDALLDOCSUPAMTCUBE.PURCHASINGORGANIZATION == T024E.EKORG