Fclm_Mm_Ekko

Purchasing Document | view: VFCLMMMEKKO | Extraction: Not supported | Component: SAP Cash Management
Tables used: EKKO
Column Name Description
Column Name Description
💲 Currency Key (DocumentCurrency):
TargetAmount Target Value for Header Area per Distribution
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
PurchasingDocumentOrderDate Purchasing Document Date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchasingCompletenessStatus Purchase order not yet complete Show values
Column Name Description Domain name
PurchasingDocument Purchasing Document Number EBELN
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
CreatedByUser User of person who created a purchasing document USNAM
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
SupplierAddressID Address Number AD_ADDRNUM
ManualSupplierAddressID Address Number AD_ADDRNUM
ExchangeRate Exchange Rate KURSP
IncotermsTransferLocation Incoterms (Part 2) INCO2
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
PurchasingDocumentCondition Number of the Document Condition KNUMV
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • FCLM_MM_EKKO.COMPANYCODE == T001.BUKRS
  • FCLM_MM_EKKO.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • FCLM_MM_EKKO.DOCUMENTCURRENCY == TCURC.WAERS
  • FCLM_MM_EKKO.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • FCLM_MM_EKKO.INCOTERMSCLASSIFICATION == TINC.INCO1
  • FCLM_MM_EKKO.MANDT == TINC.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • FCLM_MM_EKKO.INVOICINGPARTY == LFA1.LIFNR
  • FCLM_MM_EKKO.MANDT == LFA1.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • FCLM_MM_EKKO.PRICINGPROCEDURE == T683.KALSM
  • FCLM_MM_EKKO.[column in domain "KAPPL"] == T683.KAPPL
  • FCLM_MM_EKKO.[column in domain "KVEWE"] == T683.KVEWE
  • FCLM_MM_EKKO.MANDT == T683.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • FCLM_MM_EKKO.PURCHASINGDOCUMENTTYPE == T161.BSART
  • FCLM_MM_EKKO.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • FCLM_MM_EKKO.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • FCLM_MM_EKKO.PURCHASINGGROUP == T024.EKGRP
  • FCLM_MM_EKKO.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • FCLM_MM_EKKO.PURCHASINGORGANIZATION == T024E.EKORG
  • FCLM_MM_EKKO.MANDT == T024E.MANDT
Release Indicator: Purchasing Document
  • Release Indicator: Purchasing Document
  • Client
  • FCLM_MM_EKKO.RELEASECODE == T16FB.FRGKE
  • FCLM_MM_EKKO.MANDT == T16FB.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • FCLM_MM_EKKO.SUPPLIER == LFA1.LIFNR
  • FCLM_MM_EKKO.MANDT == LFA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Client
  • FCLM_MM_EKKO.SUPPLYINGPLANT == T001W.WERKS
  • FCLM_MM_EKKO.MANDT == T001W.MANDT
Goods Supplier
  • Goods Supplier
  • Client
  • FCLM_MM_EKKO.SUPPLYINGSUPPLIER == LFA1.LIFNR
  • FCLM_MM_EKKO.MANDT == LFA1.MANDT