ESH_N_PRMTHB_RPLD_PO

Anchor view -PRMTHB_RPLD_PO | view: ESH_L_PRMTHBRPPO | TRAN | Extraction: Not supported | Component: Central Purchase Order
Tables used: MMPUR_EXT_EKKO, MMPUR_EXT_EKPO, T002, MMPUR_EXT_MARA, MMPUR_EXT_MAKT, MMPUR_EXT_T161, MMPUR_EXT_T161T, MMPUR_EXT_LFA1, MMPUR_C_BE_CCREG, MMPUR_C_BE_SYREG, MMPUR_EXT_TVZBT, MMPUR_EXT_T024, MMPUR_C_BE_PORGR
Column Name Description
EXTSOURCESYSTEM Connected System ID
PURCHASEORDER Purchasing Document Number
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
ISENDOFPURPOSEBLOCKED Business Purpose Completed Show values
Column Name Description Domain name
COMPANYCODENAME Name of Company Code or Company TEXT25
CREATEDBYUSER User of person who created a purchasing document USNAM
CREATEDBYUSERNAME Full Name of Person TEXT80
LASTCHANGEDATETIME Change Time Stamp TZNTSTMPL
MATERIALNAME Material Description TEXT40
PAYMENTTERMS Terms of Payment Key ZTERM
PAYMENTTERMSNAME Description of terms of payment TEXT30
PROCMTHUBPURGORGNAME Connected Purchasing Organisation Name
PROCMTHUBSUPPLIERNAME Name 1 NAME
PROCUREMENTHUBSOURCESYSTEMNAME Connected System Name TEXT30
PURCHASINGDOCUMENTTYPENAME Short Description of Purchasing Document Type TEXT20
PURCHASINGGROUPNAME Description of purchasing group TEXT18
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • ESH_N_PRMTHB_RPLD_PO.COMPANYCODE == T001.BUKRS
  • ESH_N_PRMTHB_RPLD_PO.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • ESH_N_PRMTHB_RPLD_PO.DOCUMENTCURRENCY == TCURC.WAERS
  • ESH_N_PRMTHB_RPLD_PO.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • ESH_N_PRMTHB_RPLD_PO.MATERIAL == MARA.MATNR
  • ESH_N_PRMTHB_RPLD_PO.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • ESH_N_PRMTHB_RPLD_PO.MATERIALGROUP == T023.MATKL
  • ESH_N_PRMTHB_RPLD_PO.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • ESH_N_PRMTHB_RPLD_PO.PLANT == T001W.WERKS
  • ESH_N_PRMTHB_RPLD_PO.MANDT == T001W.MANDT
Purchasing Document Type
  • ?
  • Purchasing Document Type
  • Client
  • ESH_N_PRMTHB_RPLD_PO.[column in domain "BSTYP"] == T161.BSTYP
  • ESH_N_PRMTHB_RPLD_PO.PURCHASEORDERTYPE == T161.BSART
  • ESH_N_PRMTHB_RPLD_PO.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • ESH_N_PRMTHB_RPLD_PO.PURCHASINGGROUP == T024.EKGRP
  • ESH_N_PRMTHB_RPLD_PO.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • ESH_N_PRMTHB_RPLD_PO.PURCHASINGORGANIZATION == T024E.EKORG
  • ESH_N_PRMTHB_RPLD_PO.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • ESH_N_PRMTHB_RPLD_PO.SUPPLIER == LFA1.LIFNR
  • ESH_N_PRMTHB_RPLD_PO.MANDT == LFA1.MANDT