SHSM_M_MBANG

Purchase Requisitions per Order | view: SHSMMMBANG | TRAN | Extraction: Not supported | Component: Purchasing
Tables used: EBANEBKN
Column Name Description
aufnr FK Order Number
banfn Purchase Requisition Number
bnfpo Item number of purchase requisition
zebkn Serial number for PReq account assignment segment
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
Order Number
  • Client
  • Order Number
  • SHSM_M_MBANG.MANDT == AUFK.MANDT
  • SHSM_M_MBANG.AUFNR == AUFK.AUFNR
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Client
  • ?
  • SHSM_M_MBANG.BSART == T161.BSART
  • SHSM_M_MBANG.MANDT == T161.MANDT
  • SHSM_M_MBANG.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • SHSM_M_MBANG.EKGRP == T024.EKGRP
  • SHSM_M_MBANG.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • SHSM_M_MBANG.MANDT == T024E.MANDT
  • SHSM_M_MBANG.EKORG == T024E.EKORG
Plant
  • Client
  • Plant
  • SHSM_M_MBANG.MANDT == T001W.MANDT
  • SHSM_M_MBANG.WERKS == T001W.WERKS