I_SupDmndOvwPurchaseReqn

Basic View for Purchase Requisitions | view: ISUPDMNDOVWPR | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: EBANMARAMARC
Column Name Description
PurchaseRequisition Purchase Requisition Number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Price in Purchase Requisition
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity Purchase requisition quantity
OrderedQuantity Quantity ordered against this purchase requisition
OpenSupplyQuantity null
Column Name Description
SupplyDeliveryDate Item delivery date
RequestedDeliveryDate Item delivery date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
AssignedSupplyType ARun Stock Source Show values
SupAssgmtSource Assignment Source Show values
Column Name Description Domain name
StockSegment Stock Segment SGT_SRCA
CompanyCode Company Code of External System BUKRS
MaterialGoodsReceiptDuration Goods receipt processing time in days DEC3
NetPriceQuantity Price unit DEC5
GoodsReceiptDurationInDays Goods receipt processing time in days DEC3
CrossPlantConfigurableProduct Cross-Plant Configurable Material MATNR
RetailArticleColor Characteristic Value for Colors of Variants WRF_ATWRT
RetailArticleMainSize Characteristic Value for Main Sizes of Variants WRF_ATWRT
RetailArticleSecondSize Characteristic Value for Second Size for Variants WRF_ATWRT
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
InventorySpecialStockType Special Stock Indicator SOBKZ
Master Data Relations Join Conditions
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • I_SUPDMNDOVWPURCHASEREQN.ORDERQUANTITYUNIT == T006.MSEHI
  • I_SUPDMNDOVWPURCHASEREQN.BASEUNIT == T006.MSEHI
  • I_SUPDMNDOVWPURCHASEREQN.MANDT == T006.MANDT
Customer
  • Customer
  • Client
  • I_SUPDMNDOVWPURCHASEREQN.CUSTOMER == KNA1.KUNNR
  • I_SUPDMNDOVWPURCHASEREQN.MANDT == KNA1.MANDT
Currency Key
  • Client
  • Currency Key
  • I_SUPDMNDOVWPURCHASEREQN.MANDT == TCURC.MANDT
  • I_SUPDMNDOVWPURCHASEREQN.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • I_SUPDMNDOVWPURCHASEREQN.MANDT == MARA.MANDT
  • I_SUPDMNDOVWPURCHASEREQN.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_SUPDMNDOVWPURCHASEREQN.MANDT == T023.MANDT
  • I_SUPDMNDOVWPURCHASEREQN.MATERIALGROUP == T023.MATKL
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • I_SUPDMNDOVWPURCHASEREQN.ORDERQUANTITYUNIT == T006.MSEHI
  • I_SUPDMNDOVWPURCHASEREQN.BASEUNIT == T006.MSEHI
  • I_SUPDMNDOVWPURCHASEREQN.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • I_SUPDMNDOVWPURCHASEREQN.MANDT == T001W.MANDT
  • I_SUPDMNDOVWPURCHASEREQN.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • I_SUPDMNDOVWPURCHASEREQN.MANDT == T024.MANDT
  • I_SUPDMNDOVWPURCHASEREQN.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • I_SUPDMNDOVWPURCHASEREQN.PURCHASINGORGANIZATION == T024E.EKORG
  • I_SUPDMNDOVWPURCHASEREQN.MANDT == T024E.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • I_SUPDMNDOVWPURCHASEREQN.STORAGELOCATION == T001L.LGORT
  • I_SUPDMNDOVWPURCHASEREQN.MANDT == T001L.MANDT
  • I_SUPDMNDOVWPURCHASEREQN.PLANT == T001L.WERKS
Desired Vendor
  • Client
  • Desired Vendor
  • I_SUPDMNDOVWPURCHASEREQN.MANDT == LFA1.MANDT
  • I_SUPDMNDOVWPURCHASEREQN.SUPPLIER == LFA1.LIFNR