SHSM_M_MBANA

DDL for Search Help MBANA | view: SHSMMMBANA | Extraction: Not supported | Component: Purchasing
Tables used: EBANEBKN
Column Name Description
anln1 FK Main Asset Number
anln2 FK Asset Subnumber
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
Asset Subnumber
  • Asset Subnumber
  • ?
  • Client
  • Main Asset Number
  • SHSM_M_MBANA.ANLN2 == ANLA.ANLN2
  • SHSM_M_MBANA.[column in domain "BUKRS"] == ANLA.BUKRS
  • SHSM_M_MBANA.MANDT == ANLA.MANDT
  • SHSM_M_MBANA.ANLN1 == ANLA.ANLN1
Purchase Requisition Document Type
  • Client
  • ?
  • Purchase Requisition Document Type
  • SHSM_M_MBANA.MANDT == T161.MANDT
  • SHSM_M_MBANA.[column in domain "BSTYP"] == T161.BSTYP
  • SHSM_M_MBANA.BSART == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • SHSM_M_MBANA.EKGRP == T024.EKGRP
  • SHSM_M_MBANA.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • SHSM_M_MBANA.EKORG == T024E.EKORG
  • SHSM_M_MBANA.MANDT == T024E.MANDT
Plant
  • Client
  • Plant
  • SHSM_M_MBANA.MANDT == T001W.MANDT
  • SHSM_M_MBANA.WERKS == T001W.WERKS