I_SupDmndAllDocPurReqnBsc

Basic View for Purchase Requisition | view: ISUPDMNDADPRB | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: EBANEBKNLFA1MARAMARC
Column Name Description
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Price in Purchase Requisition
Column Name Description
TotalQuantity null
OpenSupplyQuantity null
Column Name Description
SupplyDeliveryDate Item delivery date
ProductAvailabilityDate Item delivery date
RequestedDeliveryDate Item delivery date
Column Name Description
Column Name Description Domain name
SupplyNumber null
SupplyItem null
SupplyScheduleLine null
AssignedSupplyType null
SupAssgmtSource null
StockSegment Stock Segment SGT_SRCA
Batch Batch Number CHARG
StorageLocation Storage location LGORT
Supplier Desired Vendor LIFNR
CompanyCode Company Code of External System BUKRS
SalesOrder null
SalesOrderItem null
PurgReleaseSequenceStatus Release State FRGZU
Master Data Relations Join Conditions
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • I_SUPDMNDALLDOCPURREQNBSC.BASEUNIT == T006.MSEHI
  • I_SUPDMNDALLDOCPURREQNBSC.MANDT == T006.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_SUPDMNDALLDOCPURREQNBSC.MANDT == MARA.MANDT
  • I_SUPDMNDALLDOCPURREQNBSC.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer
  • Customer
  • Client
  • I_SUPDMNDALLDOCPURREQNBSC.CUSTOMER == KNA1.KUNNR
  • I_SUPDMNDALLDOCPURREQNBSC.MANDT == KNA1.MANDT
Currency Key
  • Currency Key
  • Client
  • I_SUPDMNDALLDOCPURREQNBSC.DOCUMENTCURRENCY == TCURC.WAERS
  • I_SUPDMNDALLDOCPURREQNBSC.MANDT == TCURC.MANDT
Material Number
  • Client
  • Material Number
  • I_SUPDMNDALLDOCPURREQNBSC.MANDT == MARA.MANDT
  • I_SUPDMNDALLDOCPURREQNBSC.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • I_SUPDMNDALLDOCPURREQNBSC.MATERIALGROUP == T023.MATKL
  • I_SUPDMNDALLDOCPURREQNBSC.MANDT == T023.MANDT
Material type
  • Client
  • Material type
  • I_SUPDMNDALLDOCPURREQNBSC.MANDT == T134.MANDT
  • I_SUPDMNDALLDOCPURREQNBSC.MATERIALTYPE == T134.MTART
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Client
  • ?
  • I_SUPDMNDALLDOCPURREQNBSC.ORDERTYPE == T161.BSART
  • I_SUPDMNDALLDOCPURREQNBSC.MANDT == T161.MANDT
  • I_SUPDMNDALLDOCPURREQNBSC.[column in domain "BSTYP"] == T161.BSTYP
Plant
  • Plant
  • Client
  • I_SUPDMNDALLDOCPURREQNBSC.PLANT == T001W.WERKS
  • I_SUPDMNDALLDOCPURREQNBSC.MANDT == T001W.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_SUPDMNDALLDOCPURREQNBSC.PURCHASINGGROUP == T024.EKGRP
  • I_SUPDMNDALLDOCPURREQNBSC.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_SUPDMNDALLDOCPURREQNBSC.PURCHASINGORGANIZATION == T024E.EKORG
  • I_SUPDMNDALLDOCPURREQNBSC.MANDT == T024E.MANDT