P_SupDmndAllDocRetSlsOrdAssgmt

View for Return Sales Order with Temporary Assignments | view: PSUPDMNDRETORDAS | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAK, VBAP, VBEP, VBKD, VBPA, VBPA, ARUN_BDBS, ARUN_PREVIEW, ARUN_SDO_ALLDOC, 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
  • Client
  • Base Unit of Measure
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MANDT == T006.MANDT
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.BASEUNIT == T006.MSEHI
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MANDT == T001.MANDT
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.COMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MANDT == MARA.MANDT
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MANDT == TVKOV.MANDT
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.SALESORGANIZATION == TVKOV.VKORG
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • Division
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MANDT == TVTA.MANDT
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.SALESORGANIZATION == TVTA.VKORG
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.DIVISION == TVTA.SPART
SD Document Currency
  • Client
  • SD Document Currency
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MANDT == TCURC.MANDT
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.DOCUMENTCURRENCY == TCURC.WAERS
Material: order item
  • Material Number
  • Client
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MATERIAL == MARA.MATNR
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MANDT == T023.MANDT
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MANDT == T134.MANDT
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MATERIALTYPE == T134.MTART
Order type in order header
  • Client
  • Sales Document Type
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MANDT == TVAK.MANDT
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.ORDERTYPE == TVAK.AUART
Sales District
  • Sales District
  • Client
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.SALESDISTRICT == T171.BZIRK
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MANDT == T171.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MANDT == TVAG.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MANDT == TVKO.MANDT
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.SDDOCUMENTREASON == TVAU.AUGRU
  • P_SUPDMNDALLDOCRETSLSORDASSGMT.MANDT == TVAU.MANDT