Fclm_Mmpi_All

Purchasing doc item with IP and SCH | view: VFCLMMMPIALL | Extraction: Not supported | Component: SAP Cash Management
Tables used: EKKOPRCD_ELEMENTSEKETEKKOEKPOFPLAFPLTT001T006
Column Name Description
po_item_cat null
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem Item Number of Purchasing Document
ConditionStep null
ConditionCount null
ScheduleLine null
InvoicePlanNumber Invoicing plan number
InvoicePlanItem null
Column Name Description
PurchaseOrderNetAmount Net Order Value in PO Currency
PurchaseOrderNetAmountSchDis null
Column Name Description
PurchaseOrderQty Purchase Order Quantity
Column Name Description
SchedLineStscDeliveryDate Statistics-Relevant Delivery Date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
ValueBasedCommitment Value-based commitment indicator Show values
GoodsReceiptNonValuated Goods Receipt, Non-Valuated Show values
IsReturnsItem Returns Item Show values
Column Name Description Domain name
InvoicePlanStatus null
PaymentTerms Terms of payment key ZTERM
CashDiscount1Days Cash (Prompt Payment) Discount Days ZBDXT
CashDiscount2Days Cash (Prompt Payment) Discount Days ZBDXT
NetPaymentDays Cash (Prompt Payment) Discount Days ZBDXT
CashDiscount1Percent Cash discount percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • FCLM_MMPI_ALL.COMPANYCODE == T001.BUKRS
  • FCLM_MMPI_ALL.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • FCLM_MMPI_ALL.MANDT == TCURC.MANDT
  • FCLM_MMPI_ALL.CURRENCY == TCURC.WAERS
  • FCLM_MMPI_ALL.COMPANYCODECURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • FCLM_MMPI_ALL.MANDT == TCURC.MANDT
  • FCLM_MMPI_ALL.CURRENCY == TCURC.WAERS
  • FCLM_MMPI_ALL.COMPANYCODECURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • FCLM_MMPI_ALL.MANDT == MARA.MANDT
  • FCLM_MMPI_ALL.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • FCLM_MMPI_ALL.MATERIALGROUP == T023.MATKL
  • FCLM_MMPI_ALL.MANDT == T023.MANDT
Plant
  • Client
  • Plant
  • FCLM_MMPI_ALL.MANDT == T001W.MANDT
  • FCLM_MMPI_ALL.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • FCLM_MMPI_ALL.MANDT == T024.MANDT
  • FCLM_MMPI_ALL.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • FCLM_MMPI_ALL.MANDT == T024E.MANDT
  • FCLM_MMPI_ALL.PURCHASINGORGANIZATION == T024E.EKORG
Vendor's account number
  • Client
  • Vendor's account number
  • FCLM_MMPI_ALL.MANDT == LFA1.MANDT
  • FCLM_MMPI_ALL.SUPPLIER == LFA1.LIFNR