Fclm_Mmphi_Hist

Purchasing Document History with Items | view: VFCLMMMPHIHIST | Extraction: Not supported | Component: SAP Cash Management
Tables used: EKKOEKPOEKBEEKBEHT163BT001T006
Column Name Description
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem FK Item Number of Purchasing Document
AccountAssignmentNumber Sequential Number of Account Assignment
PurchaseOrderTransactionType Transaction/event type, purchase order history Show values
MaterialDocumentYear Material Document Year
MaterialDocument Number of Material Document
MaterialDocumentItem Item in Material Document
Column Name Description
PurOrdAmountInCompanyCodeCrcy Amount in Local Currency
GRIRAcctClrgAmtInCoCodeCrcy GR/IR account clearing value in local currency
InvoiceAmtInCoCodeCrcy Invoice Value Entered (in Local Currency)
GRIRAcctClrgAmtInOrdTrnsacCrcy Clearing Value on GR/IR Account in PO Currency
InvoiceAmtInPurOrdTransacCrcy Invoice Amount in PO Currency
PurchaseOrderAmountCoCodeCrcy Net Order Value in PO Currency
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
💲 Currency Key (Currency):
PurchaseOrderAmount Amount in Document Currency
InvoiceAmountInFrgnCurrency Invoice Value in Foreign Currency
GRIRAcctClrgAmtInTransacCrcy Clearing value on GR/IR clearing account (transac. currency)
ExchangeRateDifferenceAmount Exchange Rate Difference Amount
Column Name Description
Quantity Quantity
QtyInPurchaseOrderPriceUnit Quantity in purchase order price unit
GdsRcptBlkdStkQtyInOrdQtyUnit Goods Receipt Blocked Stock in Order Unit
GdsRcptBlkdStkQtyInOrdPrcUnit Quantity in GR blocked stock in order price unit
QuantityInBaseUnit Quantity
VltdGdsRcptBlkdStkQtyInOrdUnit Valuated Goods Receipt Blocked Stock in Order Unit
VltdGdsRcptBlkdQtyInOrdPrcUnit Quantity in Valuated GR Blocked Stock in Order Price Unit
OrderQuantity Purchase Order Quantity
📏 Unit of Measure From Delivery Note (DeliveryQuantityUnit):
QuantityInDeliveryQtyUnit Quantity in Unit of Measure from Delivery Note
Column Name Description
PostingDate Posting Date in the Document
DocumentDate Document Date in Document
AccountingDocumentCreationDate Day On Which Accounting Document Was Entered
Column Name Description
PurchaseOrderTransactionType Transaction/event type, purchase order history Show values
DebitCreditCode Debit/Credit Indicator Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
SubsequentDebitCreditIsAllowed Indicator: subsequent debit/credit Show values
ValueBasedCommitment Value-based commitment indicator Show values
Column Name Description Domain name
ReferenceDocumentFiscalYear Fiscal Year of a Reference Document GJAHR
ReferenceDocument Document No. of a Reference Document BELNR
ReferenceDocumentItem Item of a Reference Document MBLPO
DocumentReferenceID Reference Document Number XBLNR1
OrdPriceUnitToOrderUnitDnmntr Denominator for Conv. of Order Price Unit into Order Unit UMBSN
OrderPriceUnitToOrderUnitNmrtr Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
NetPriceQuantity Price unit DEC5
Master Data Relations Join Conditions
Currency Key
  • Currency Key
  • Currency Key
  • Currency Key
  • Client
  • FCLM_MMPHI_HIST.COMPANYCODECURRENCY == TCURC.WAERS
  • FCLM_MMPHI_HIST.CURRENCY == TCURC.WAERS
  • FCLM_MMPHI_HIST.PURORDTRANSACTIONCURRENCY == TCURC.WAERS
  • FCLM_MMPHI_HIST.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Currency Key
  • Client
  • FCLM_MMPHI_HIST.COMPANYCODECURRENCY == TCURC.WAERS
  • FCLM_MMPHI_HIST.CURRENCY == TCURC.WAERS
  • FCLM_MMPHI_HIST.PURORDTRANSACTIONCURRENCY == TCURC.WAERS
  • FCLM_MMPHI_HIST.MANDT == TCURC.MANDT
Unit of Measure From Delivery Note
  • Unit of Measure From Delivery Note
  • Client
  • FCLM_MMPHI_HIST.DELIVERYQUANTITYUNIT == T006.MSEHI
  • FCLM_MMPHI_HIST.MANDT == T006.MANDT
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • FCLM_MMPHI_HIST.GOODSMOVEMENTTYPE == T156.BWART
  • FCLM_MMPHI_HIST.MANDT == T156.MANDT
Valuation Type
  • Valuation Type
  • Client
  • FCLM_MMPHI_HIST.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • FCLM_MMPHI_HIST.MANDT == T149D.MANDT
Material Number
  • Material Number
  • Client
  • FCLM_MMPHI_HIST.MATERIAL == MARA.MATNR
  • FCLM_MMPHI_HIST.MANDT == MARA.MANDT
Plant
  • Client
  • Plant
  • FCLM_MMPHI_HIST.MANDT == T001W.MANDT
  • FCLM_MMPHI_HIST.PLANT == T001W.WERKS
Purchase Order History Category
  • Purchase Order History Category
  • Client
  • FCLM_MMPHI_HIST.PURCHASEORDERHISTCATEGORY == T163B.BEWTP
  • FCLM_MMPHI_HIST.MANDT == T163B.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Currency Key
  • Client
  • FCLM_MMPHI_HIST.COMPANYCODECURRENCY == TCURC.WAERS
  • FCLM_MMPHI_HIST.CURRENCY == TCURC.WAERS
  • FCLM_MMPHI_HIST.PURORDTRANSACTIONCURRENCY == TCURC.WAERS
  • FCLM_MMPHI_HIST.MANDT == TCURC.MANDT