SHSM_M_MBANM

Purchase Requisitions per Material | view: SHSMMMBANM | Extraction: Not supported | Component: Purchasing
Tables used: EBAN
Column Name Description
matnr FK Material Number
werks FK Plant
bsart FK Purchase Requisition Document Type
ekgrp FK Purchasing Group
banfn Purchase Requisition Number
bnfpo Item number of purchase requisition
Column Name Description
Column Name Description
Column Name Description
Column Name Description
iseopblocked Business Purpose Completed Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • ?
  • Client
  • SHSM_M_MBANM.BSART == T161.BSART
  • SHSM_M_MBANM.[column in domain "BSTYP"] == T161.BSTYP
  • SHSM_M_MBANM.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • SHSM_M_MBANM.EKGRP == T024.EKGRP
  • SHSM_M_MBANM.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • SHSM_M_MBANM.EKORG == T024E.EKORG
  • SHSM_M_MBANM.MANDT == T024E.MANDT
Material Number
  • Client
  • Material Number
  • SHSM_M_MBANM.MANDT == MARA.MANDT
  • SHSM_M_MBANM.MATNR == MARA.MATNR
Plant
  • Plant
  • Client
  • SHSM_M_MBANM.WERKS == T001W.WERKS
  • SHSM_M_MBANM.MANDT == T001W.MANDT