I_SupDmndOvwPgCustRetsC

Cube View for Customer Returns | view: ISDOPCUSTRETSC | TRAN | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
Material FK Material Number
Plant Plant (Own or External)
Batch Batch Number
StorageLocation Storage location
SupplyNumber null
SupplyItem null
SupplyScheduleLine null
ProductAvailabilityDate Material Staging/Availability Date
AssignedSupplyType null
Column Name Description
💲 SD Document Currency (DocumentCurrency):
ActlAmt Net Value in Document Currency
💲 Display Currency (DisplayCurrency):
TotActualAmtInDisplayCurrency Net Value in Display Currency
Column Name Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
TotalQuantity Overall confirmed sales order schedule lines: quantity
OpenSupplyQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
Column Name Description
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate Material Staging/Availability Date
Column Name Description
Column Name Description Domain name
SupAssgmtSource null
PreviewAssignedQuantityInBsUnt null
ARunTmpAssignedQuantityInBsUnt null
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarMonthName Short Text for Fixed Values DDTEXT
CalendarWeek null
CalendarDay Calendar Day NUM2
StockSegment Requirement Segment SGT_SRCA
SalesOrganization null
DistributionChannel null
Division null
SalesDistrict null
Customer null
CompanyCode null
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_SUPDMNDOVWPGCUSTRETSC.MANDT == T006.MANDT
  • I_SUPDMNDOVWPGCUSTRETSC.BASEUNIT == T006.MSEHI
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_SUPDMNDOVWPGCUSTRETSC.MANDT == MARA.MANDT
  • I_SUPDMNDOVWPGCUSTRETSC.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
SD Document Currency
  • Client
  • SD Document Currency
  • I_SUPDMNDOVWPGCUSTRETSC.MANDT == TCURC.MANDT
  • I_SUPDMNDOVWPGCUSTRETSC.DOCUMENTCURRENCY == TCURC.WAERS
Material: order item
  • Material Number
  • Client
  • I_SUPDMNDOVWPGCUSTRETSC.MATERIAL == MARA.MATNR
  • I_SUPDMNDOVWPGCUSTRETSC.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_SUPDMNDOVWPGCUSTRETSC.MATERIALGROUP == T023.MATKL
  • I_SUPDMNDOVWPGCUSTRETSC.MANDT == T023.MANDT
Material type
  • Client
  • Material type
  • I_SUPDMNDOVWPGCUSTRETSC.MANDT == T134.MANDT
  • I_SUPDMNDOVWPGCUSTRETSC.MATERIALTYPE == T134.MTART
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • I_SUPDMNDOVWPGCUSTRETSC.MANDT == TVAG.MANDT
  • I_SUPDMNDOVWPGCUSTRETSC.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • I_SUPDMNDOVWPGCUSTRETSC.SDDOCUMENTREASON == TVAU.AUGRU
  • I_SUPDMNDOVWPGCUSTRETSC.MANDT == TVAU.MANDT