SHSM_M_MBANC

Purchase Requn for Procuring Plant | view: SHSMMMBANC | Extraction: Not supported | Component: Purchasing
Tables used: EBAN
Column Name Description
ekgrp FK Purchasing Group
werks FK Plant
reswk Supplying (issuing) plant in case of stock transport order
beswk FK Procuring Plant
banpr Requisition Processing State Show values
banfn Purchase Requisition Number
bnfpo Item number of purchase requisition
Column Name Description
Column Name Description
Column Name Description
Column Name Description
banpr Requisition Processing State Show values
iseopblocked Business Purpose Completed Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Procuring Plant
  • Client
  • Procuring Plant
  • SHSM_M_MBANC.MANDT == T001W.MANDT
  • SHSM_M_MBANC.BESWK == T001W.WERKS
Purchase Requisition Document Type
  • ?
  • Client
  • Purchase Requisition Document Type
  • SHSM_M_MBANC.[column in domain "BSTYP"] == T161.BSTYP
  • SHSM_M_MBANC.MANDT == T161.MANDT
  • SHSM_M_MBANC.BSART == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • SHSM_M_MBANC.MANDT == T024.MANDT
  • SHSM_M_MBANC.EKGRP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • SHSM_M_MBANC.EKORG == T024E.EKORG
  • SHSM_M_MBANC.MANDT == T024E.MANDT
Plant
  • Client
  • Plant
  • SHSM_M_MBANC.MANDT == T001W.MANDT
  • SHSM_M_MBANC.WERKS == T001W.WERKS