Fclm_Mmphi_All

Purchasing doc history and dcost with items | view: VFCLMMMPHIALL | Extraction: Not supported | Component: SAP Cash Management
Tables used: EKKOEKPOEKBEEKBEHEKBZEKBZHT163BT163BT001T006
Column Name Description
Column Name Description
PurchaseOrderNetAmount Net Order Value in PO Currency
NonDeductibleInputTax Non-deductible input tax
GoodsReceiptAmountInDspCrcy null
InvoiceAmtInDisplayCurrency null
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
IsFinallyInvoiced Final Invoice Indicator Show values
IsReturnsItem Returns Item Show values
Column Name Description Domain name
po_item_cat null
PurchasingDocumentItem Item Number of Purchasing Document EBELP
AccountAssignmentNumber null
ConditionStep null
ConditionCount null
PurchaseOrderTransactionType null
PurchaseOrderHistCategory null
InvoicePlanNumber Invoicing plan number CHAR10
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • FCLM_MMPHI_ALL.MANDT == T001.MANDT
  • FCLM_MMPHI_ALL.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • FCLM_MMPHI_ALL.MANDT == TCURC.MANDT
  • FCLM_MMPHI_ALL.COMPANYCODECURRENCY == TCURC.WAERS
  • FCLM_MMPHI_ALL.DOCUMENTCURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • FCLM_MMPHI_ALL.MANDT == TCURC.MANDT
  • FCLM_MMPHI_ALL.COMPANYCODECURRENCY == TCURC.WAERS
  • FCLM_MMPHI_ALL.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • FCLM_MMPHI_ALL.MANDT == MARA.MANDT
  • FCLM_MMPHI_ALL.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • FCLM_MMPHI_ALL.MANDT == T023.MANDT
  • FCLM_MMPHI_ALL.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • FCLM_MMPHI_ALL.MANDT == T001W.MANDT
  • FCLM_MMPHI_ALL.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • FCLM_MMPHI_ALL.MANDT == T163.MANDT
  • FCLM_MMPHI_ALL.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Document Type
  • Purchasing Document Category
  • Client
  • Purchasing Document Type
  • FCLM_MMPHI_ALL.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • FCLM_MMPHI_ALL.MANDT == T161.MANDT
  • FCLM_MMPHI_ALL.PURCHASINGDOCUMENTTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • FCLM_MMPHI_ALL.PURCHASINGGROUP == T024.EKGRP
  • FCLM_MMPHI_ALL.MANDT == T024.MANDT