R_PrmtHbRpldPurOrdSrch

Central Purchase Order | view: RPRMTHBPOS | TRAN | Extraction: Not supported | Component: Central Purchase Order
Tables used: MMPUR_EXT_EKKO
Column Name Description
PurchaseOrder Purchasing Document Number
ExtSourceSystem Connected System ID
Column Name Description
💲 Currency Key (DocumentCurrency):
PurchaseOrderNetAmount Net Value in Document Currency
Column Name Description
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
Column Name Description Domain name
LastChangeDateTime Change Time Stamp TZNTSTMPL
CreatedByUser User of person who created a purchasing document USNAM
CreatedByUserName Full Name of Person TEXT80
PaymentTerms Terms of Payment Key ZTERM
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • R_PRMTHBRPLDPURORDSRCH.MANDT == T001.MANDT
  • R_PRMTHBRPLDPURORDSRCH.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • R_PRMTHBRPLDPURORDSRCH.MANDT == TCURC.MANDT
  • R_PRMTHBRPLDPURORDSRCH.DOCUMENTCURRENCY == TCURC.WAERS
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • Purchasing Document Category
  • R_PRMTHBRPLDPURORDSRCH.MANDT == T161.MANDT
  • R_PRMTHBRPLDPURORDSRCH.PURCHASEORDERTYPE == T161.BSART
  • R_PRMTHBRPLDPURORDSRCH.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • R_PRMTHBRPLDPURORDSRCH.PURCHASINGGROUP == T024.EKGRP
  • R_PRMTHBRPLDPURORDSRCH.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • R_PRMTHBRPLDPURORDSRCH.MANDT == T024E.MANDT
  • R_PRMTHBRPLDPURORDSRCH.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • R_PRMTHBRPLDPURORDSRCH.SUPPLIER == LFA1.LIFNR
  • R_PRMTHBRPLDPURORDSRCH.MANDT == LFA1.MANDT