P_SupDmndAllDocRetsSup

View for Return PO | view: PSUPDMNDADRETSSP | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: EKKO, EKPO, EKET, ARUN_BDBS, ARUN_PREVIEW, ARUN_SDO_ALLDOC, MARA, MARC
Column Name Description
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
RequestedRqmtQtyInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
DeliveredQuantityInBaseUnit null
OpenDemandQuantity null
Column Name Description
RequestedDate Item delivery date
ProductAvailabilityDate Item delivery date
RequestedDeliveryDate Item delivery date
Column Name Description
SegmentationStrategyScope Segmentation Strategy Scope Show values
Column Name Description Domain name
RequirementDocumentItem null
RequirementType null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
PreviewAssignedQuantityInBsUnt null
RequirementSegment Requirement Segment SGT_SRCA
PurgReleaseSequenceStatus Release State FRGZU
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_SUPDMNDALLDOCRETSSUP.BASEUNIT == T006.MSEHI
  • P_SUPDMNDALLDOCRETSSUP.MANDT == T006.MANDT
Company Code
  • Client
  • Company Code
  • P_SUPDMNDALLDOCRETSSUP.MANDT == T001.MANDT
  • P_SUPDMNDALLDOCRETSSUP.COMPANYCODE == T001.BUKRS
Currency Key
  • Currency Key
  • Client
  • P_SUPDMNDALLDOCRETSSUP.DOCUMENTCURRENCY == TCURC.WAERS
  • P_SUPDMNDALLDOCRETSSUP.MANDT == TCURC.MANDT
Material Number
  • Client
  • Material Number
  • P_SUPDMNDALLDOCRETSSUP.MANDT == MARA.MANDT
  • P_SUPDMNDALLDOCRETSSUP.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_SUPDMNDALLDOCRETSSUP.MANDT == T023.MANDT
  • P_SUPDMNDALLDOCRETSSUP.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • P_SUPDMNDALLDOCRETSSUP.MANDT == T134.MANDT
  • P_SUPDMNDALLDOCRETSSUP.MATERIALTYPE == T134.MTART
Purchasing Document Type
  • Purchasing Document Type
  • ?
  • Client
  • P_SUPDMNDALLDOCRETSSUP.ORDERTYPE == T161.BSART
  • P_SUPDMNDALLDOCRETSSUP.[column in domain "BSTYP"] == T161.BSTYP
  • P_SUPDMNDALLDOCRETSSUP.MANDT == T161.MANDT
Plant
  • Client
  • Plant
  • P_SUPDMNDALLDOCRETSSUP.MANDT == T001W.MANDT
  • P_SUPDMNDALLDOCRETSSUP.PLANT == T001W.WERKS
Purchasing Group
  • Purchasing Group
  • Client
  • P_SUPDMNDALLDOCRETSSUP.PURCHASINGGROUP == T024.EKGRP
  • P_SUPDMNDALLDOCRETSSUP.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • P_SUPDMNDALLDOCRETSSUP.MANDT == T024E.MANDT
  • P_SUPDMNDALLDOCRETSSUP.PURCHASINGORGANIZATION == T024E.EKORG
Segmentation Strategy
  • Client
  • ?
  • Segmentation Strategy
  • P_SUPDMNDALLDOCRETSSUP.MANDT == SGT_COVS_T.MANDT
  • P_SUPDMNDALLDOCRETSSUP.[column in domain "WERKS_D"] == SGT_COVS_T.WERKS
  • P_SUPDMNDALLDOCRETSSUP.SEGMENTATIONSTRATEGY == SGT_COVS_T.SGT_COVS
Storage location
  • Storage location
  • Client
  • Plant
  • P_SUPDMNDALLDOCRETSSUP.STORAGELOCATION == T001L.LGORT
  • P_SUPDMNDALLDOCRETSSUP.MANDT == T001L.MANDT
  • P_SUPDMNDALLDOCRETSSUP.PLANT == T001L.WERKS