P_PurchaseOrderHistoryDetail

Purchase order history details | view: PPURORDHISDETAIL | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, EKKO, EKPO, EKBZ, EKBZH, EKBE, EKBEH, T001, TKA02, T163B
Column Name Description
Column Name Description
TotalInvoiceAmountInDisCrcy null
Column Name Description
Column Name Description
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentStatus Status of Purchasing Document Show values
Column Name Description Domain name
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarWeek Calendar Week NUM2
NumberOfDeliveries null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_PURCHASEORDERHISTORYDETAIL.COMPANYCODE == T001.BUKRS
  • P_PURCHASEORDERHISTORYDETAIL.MANDT == T001.MANDT
Plant
  • Client
  • Plant
  • P_PURCHASEORDERHISTORYDETAIL.MANDT == T001W.MANDT
  • P_PURCHASEORDERHISTORYDETAIL.PLANT == T001W.WERKS
Purchase Order Type
  • Purchase Order Type
  • Purchasing Document Category
  • Client
  • P_PURCHASEORDERHISTORYDETAIL.PURCHASEORDERTYPE == T161.BSART
  • P_PURCHASEORDERHISTORYDETAIL.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_PURCHASEORDERHISTORYDETAIL.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURCHASEORDERHISTORYDETAIL.PURCHASINGGROUP == T024.EKGRP
  • P_PURCHASEORDERHISTORYDETAIL.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURCHASEORDERHISTORYDETAIL.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURCHASEORDERHISTORYDETAIL.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_PURCHASEORDERHISTORYDETAIL.SUPPLIER == LFA1.LIFNR
  • P_PURCHASEORDERHISTORYDETAIL.MANDT == LFA1.MANDT