I_SupDmndAllDocRetSlsOrd

View for Return Sales Orders | view: ISUPDMNDADRETSO | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAK, VBAP, VBEP, VBKD, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, KNA1, MARA, MARC, CVI_VEND_LINK
Column Name Description
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetPriceAmount Net Price
Column Name Description
TotalQuantity Overall confirmed sales order schedule lines: quantity
OpenSupplyQuantity null
Column Name Description
SupplyDeliveryDate Material Staging/Availability Date
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate Material Staging/Availability Date
Column Name Description
Column Name Description Domain name
SupplyNumber null
SupplyItem null
SupplyScheduleLine null
AssignedSupplyType null
SupAssgmtSource null
Plant Plant (Own or External) WERKS
StockSegment Requirement Segment SGT_SRCA
PurchasingOrganization Purchasing organization EKORG
PurchasingGroup Purchasing Group EKGRP
Batch Batch Number CHARG
StorageLocation Storage location LGORT
Customer null
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_SUPDMNDALLDOCRETSLSORD.BASEUNIT == T006.MSEHI
  • I_SUPDMNDALLDOCRETSLSORD.MANDT == T006.MANDT
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • I_SUPDMNDALLDOCRETSLSORD.MANDT == T001.MANDT
  • I_SUPDMNDALLDOCRETSLSORD.COMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_SUPDMNDALLDOCRETSLSORD.MANDT == MARA.MANDT
  • I_SUPDMNDALLDOCRETSLSORD.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • I_SUPDMNDALLDOCRETSLSORD.SALESORGANIZATION == TVKOV.VKORG
  • I_SUPDMNDALLDOCRETSLSORD.MANDT == TVKOV.MANDT
  • I_SUPDMNDALLDOCRETSLSORD.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Sales Organization
  • Client
  • Division
  • Distribution Channel
  • I_SUPDMNDALLDOCRETSLSORD.SALESORGANIZATION == TVTA.VKORG
  • I_SUPDMNDALLDOCRETSLSORD.MANDT == TVTA.MANDT
  • I_SUPDMNDALLDOCRETSLSORD.DIVISION == TVTA.SPART
  • I_SUPDMNDALLDOCRETSLSORD.DISTRIBUTIONCHANNEL == TVTA.VTWEG
SD Document Currency
  • SD Document Currency
  • Client
  • I_SUPDMNDALLDOCRETSLSORD.DOCUMENTCURRENCY == TCURC.WAERS
  • I_SUPDMNDALLDOCRETSLSORD.MANDT == TCURC.MANDT
Material: order item
  • Material Number
  • Client
  • I_SUPDMNDALLDOCRETSLSORD.MATERIAL == MARA.MATNR
  • I_SUPDMNDALLDOCRETSLSORD.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_SUPDMNDALLDOCRETSLSORD.MATERIALGROUP == T023.MATKL
  • I_SUPDMNDALLDOCRETSLSORD.MANDT == T023.MANDT
Material type
  • Client
  • Material type
  • I_SUPDMNDALLDOCRETSLSORD.MANDT == T134.MANDT
  • I_SUPDMNDALLDOCRETSLSORD.MATERIALTYPE == T134.MTART
Order type in order header
  • Sales Document Type
  • Client
  • I_SUPDMNDALLDOCRETSLSORD.ORDERTYPE == TVAK.AUART
  • I_SUPDMNDALLDOCRETSLSORD.MANDT == TVAK.MANDT
Sales District
  • Sales District
  • Client
  • I_SUPDMNDALLDOCRETSLSORD.SALESDISTRICT == T171.BZIRK
  • I_SUPDMNDALLDOCRETSLSORD.MANDT == T171.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • I_SUPDMNDALLDOCRETSLSORD.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • I_SUPDMNDALLDOCRETSLSORD.MANDT == TVAG.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_SUPDMNDALLDOCRETSLSORD.SALESORGANIZATION == TVKO.VKORG
  • I_SUPDMNDALLDOCRETSLSORD.MANDT == TVKO.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • I_SUPDMNDALLDOCRETSLSORD.SDDOCUMENTREASON == TVAU.AUGRU
  • I_SUPDMNDALLDOCRETSLSORD.MANDT == TVAU.MANDT