P_PurchaseOrderHistDetail

PurchaseOrderHistDetail | view: PURORDHISTDET | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKPO, EKBZ, EKBZH, EKBE, EKBEH, T001, TKA02, T163B
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem FK Item Number of Purchase Order
PurchaseOrderTransactionType Transaction/event type, purchase order history Show values
Column Name Description
PurOrdAmountInCompanyCodeCrcy Amount in Local Currency
TotalInvoiceAmountInCoCodeCrcy null
💲 Currency Key (PurOrdTransactionCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
Quantity Quantity
Column Name Description
PostingDate Posting Date in the Document
Column Name Description
PurchaseOrderTransactionType Transaction/event type, purchase order history Show values
PurchasingDocumentCategory Purchasing Document Category Show values
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_PURCHASEORDERHISTDETAIL.MANDT == TCURC.MANDT
  • P_PURCHASEORDERHISTDETAIL.COMPANYCODECURRENCY == TCURC.WAERS
  • P_PURCHASEORDERHISTDETAIL.PURORDTRANSACTIONCURRENCY == TCURC.WAERS
Plant
  • Client
  • Plant
  • P_PURCHASEORDERHISTDETAIL.MANDT == T001W.MANDT
  • P_PURCHASEORDERHISTDETAIL.PLANT == T001W.WERKS
Purchase Order History Category
  • Purchase Order History Category
  • Client
  • P_PURCHASEORDERHISTDETAIL.PURCHASEORDERHISTCATEGORY == T163B.BEWTP
  • P_PURCHASEORDERHISTDETAIL.MANDT == T163B.MANDT
Purchase Order Type
  • Client
  • Purchasing Document Category
  • Purchase Order Type
  • P_PURCHASEORDERHISTDETAIL.MANDT == T161.MANDT
  • P_PURCHASEORDERHISTDETAIL.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_PURCHASEORDERHISTDETAIL.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURCHASEORDERHISTDETAIL.MANDT == T024.MANDT
  • P_PURCHASEORDERHISTDETAIL.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURCHASEORDERHISTDETAIL.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURCHASEORDERHISTDETAIL.MANDT == T024E.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_PURCHASEORDERHISTDETAIL.MANDT == TCURC.MANDT
  • P_PURCHASEORDERHISTDETAIL.COMPANYCODECURRENCY == TCURC.WAERS
  • P_PURCHASEORDERHISTDETAIL.PURORDTRANSACTIONCURRENCY == TCURC.WAERS