I_SupDmndAllDocRetsSupC

Cube View for Returns from PO/STO | view: ISUPDMNDADRETSPC | TRAN | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
RequirementDocumentNumber FK Purchasing Document Number
RequirementDocumentItem null
RequestedDate Item delivery date
ProductAvailabilityDate Item delivery date
RequirementType null
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
RequestedRqmtQtyInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
DeliveredQuantityInBaseUnit null
OpenDemandQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
Column Name Description
RequestedDate Item delivery date
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
CompanyCode null
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • I_SUPDMNDALLDOCRETSSUPC.BASEUNIT == T006.MSEHI
  • I_SUPDMNDALLDOCRETSSUPC.MANDT == T006.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_SUPDMNDALLDOCRETSSUPC.MANDT == MARA.MANDT
  • I_SUPDMNDALLDOCRETSSUPC.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Number of Plant
  • Client
  • Customer Number of Plant
  • I_SUPDMNDALLDOCRETSSUPC.MANDT == KNA1.MANDT
  • I_SUPDMNDALLDOCRETSSUPC.CUSTOMER == KNA1.KUNNR
Distribution channel for intercompany billing
  • Client
  • Distribution channel for intercompany billing
  • I_SUPDMNDALLDOCRETSSUPC.MANDT == TVTW.MANDT
  • I_SUPDMNDALLDOCRETSSUPC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division for intercompany billing
  • Client
  • Division for intercompany billing
  • I_SUPDMNDALLDOCRETSSUPC.MANDT == TSPA.MANDT
  • I_SUPDMNDALLDOCRETSSUPC.DIVISION == TSPA.SPART
Currency Key
  • Client
  • Currency Key
  • I_SUPDMNDALLDOCRETSSUPC.MANDT == TCURC.MANDT
  • I_SUPDMNDALLDOCRETSSUPC.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • I_SUPDMNDALLDOCRETSSUPC.MANDT == MARA.MANDT
  • I_SUPDMNDALLDOCRETSSUPC.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_SUPDMNDALLDOCRETSSUPC.MANDT == T023.MANDT
  • I_SUPDMNDALLDOCRETSSUPC.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • I_SUPDMNDALLDOCRETSSUPC.MANDT == T134.MANDT
  • I_SUPDMNDALLDOCRETSSUPC.MATERIALTYPE == T134.MTART
Plant
  • Client
  • Plant
  • I_SUPDMNDALLDOCRETSSUPC.MANDT == T001W.MANDT
  • I_SUPDMNDALLDOCRETSSUPC.PLANT == T001W.WERKS
Sales District
  • Client
  • Sales District
  • I_SUPDMNDALLDOCRETSSUPC.MANDT == T171.MANDT
  • I_SUPDMNDALLDOCRETSSUPC.SALESDISTRICT == T171.BZIRK
Sales Organization for Intercompany Billing
  • Client
  • Sales Organization for Intercompany Billing
  • I_SUPDMNDALLDOCRETSSUPC.MANDT == TVKO.MANDT
  • I_SUPDMNDALLDOCRETSSUPC.SALESORGANIZATION == TVKO.VKORG
Storage location
  • Client
  • Storage location
  • Plant
  • I_SUPDMNDALLDOCRETSSUPC.MANDT == T001L.MANDT
  • I_SUPDMNDALLDOCRETSSUPC.STORAGELOCATION == T001L.LGORT
  • I_SUPDMNDALLDOCRETSSUPC.PLANT == T001L.WERKS