FNDEI_EKKO_FILTER

Filter View for table EKKO | view: FNDEIFEKKO | TRAN | Extraction: Not supported | Component: View Provisioning: Orchestration
Tables used: EKKO
Column Name Description
EBELN Purchasing Document Number
Column Name Description
💲 Currency Key (WAERS):
KTWRT Target Value for Header Area per Distribution
RLWRT Total value at time of release
DPAMT Down Payment Amount in Document Currency
OTB_VALUE Required Budget
OTB_RES_VALUE Reserved Budget for OTB-Relevant Purchasing Document
OTB_SPEC_VALUE Special Release Budget
Column Name Description
Column Name Description
AEDAT Creation Date of Purchasing Document
BEDAT Purchasing Document Date
KDATB Start of Validity Period
KDATE End of Validity Period
BWBDT Closing Date for Applications
ANGDT Deadline for Submission of Bid/Quotation
BNDDT Binding Period for Quotation
GWLDT Warranty Date
IHRAN Quotation Submission Date
DPDAT Due Date for Down Payment
RELEASE_DATE Release Date of Contract
QTN_ERLST_SUBMSN_DATE The date as of which Quotations can be submitted
/DMBE/PAYMENTDEEMED Deemed Payment Date
ZBAS_DATE Base Date
ZSTART_DAT Annexing start date
ZLIMIT_DAT Annexing limit date (purchasing)
HASHCAL_BDAT "The general acountant method" New base date.
DESP_DAT Date
PARE_DAT Date
EQ_EINDT Delivery Date Header: All Items Have Same Delivery Date
Column Name Description
BSTYP Purchasing Document Category Show values
BSAKZ Control indicator for purchasing document type Show values
STATU Status of Purchasing Document Show values
KUFIX Indicator for Fixed Exchange Rate Show values
AUTLF Complete Delivery Stipulated for Each Purchase Order Show values
WEAKT Indicator: Goods Receipt Message Show values
DISTRIBUTIONTYPE Distribution Type for Purchasing Document Show values
STAKO Document with time-dependent conditions Show values
FRGRL Release Not Yet Completely Effected Show values
LPHIS Indicator for scheduling agreement release documentation Show values
KORNR Correction of miscellaneous provisions Show values
MEMORY Purchase order not yet complete Show values
PROCSTAT Purchasing document processing state Show values
PROCESS_INDICATOR Process Indicator for Purchase Order Show values
CR_STAT Change Request Status Show values
MEMORYTYPE Category of Incompleteness Show values
RETTP Retention Indicator Show values
HIERARCHY_EXISTS Part of a Contract Hierarchy Show values
THRESHOLD_EXISTS Threshold Value for Exchange Rates Exists Show values
INTRA_REL Relevant for Intrastat Reporting Show values
INTRA_EXCL Exclude from Intrastat Reporting Show values
TOTAL_STATUS_PCS Product Compliance Supplier Check Status (All Items) Show values
TOTAL_STATUS_PMA Product Marketability Status (All Items) Show values
TOTAL_STATUS_DG Dangerous Goods Status (All Items) Show values
TOTAL_STATUS_SDS Safety Data Sheet Status (All Items) Show values
FOLLOWON_DOC_CAT Follow-On Purchasing Document Category Show values
ISEOPBLOCKED Business Purpose Completed Show values
ISAGED Document is aged Show values
FSH_OS_STG_CHANGE Order Scheduling Strategy Fields Changed Manually Show values
ZADATTYP Annexing Date Type Show values
ZINDANX indicator for annexed order type Show values
KNOWN_INDEX Known Index indicator in /ILE/T_ANNEXING_CALCULATION Func Show values
POHF_TYPE Document for Seasonal Purchase Order Processing Show values
FIXPO Firm Deal Indicator Show values
EKGRP_ALLOW Take Account of Purch. Group Show values
WERKS_ALLOW Take Account of Plants Show values
CONTRACT_ALLOW Take Account of Contracts Show values
PSTYP_ALLOW Take Account of Item Categories Show values
FIXPO_ALLOW Take Account of Fixed-Date Purchases Indicator Show values
KEY_ID_ALLOW Consider Budget Show values
AUREL_ALLOW Take Account of Alloc. Table Relevance Show values
DELPER_ALLOW Take Account of Dlvy Period Show values
EINDT_ALLOW Take Account of Delivery Date Show values
LTSNR_ALLOW Include Vendor Subrange Show values
OTB_LEVEL OTB Check Level Show values
OTB_STATUS OTB Check Status Show values
OTB_REASON Reason Indicator for OTB Check Status Show values
CHECK_TYPE Type of OTB Check Show values
CON_OTB_REQ OTB-Relevant Contract Show values
CON_PREBOOK_LEV OTB Indicator Level for Contracts Show values
CON_DISTR_LEV Distribution Using Target Value or Item Data Show values
Column Name Description Domain name
LOEKZ Deletion Indicator in Purchasing Document ELOEK
ERNAM User of person who created a purchasing document USNAM
LASTCHANGEDATETIME Change Time Stamp TZNTSTMPL
PINCR Item Number Interval PINCR
ZTERM Terms of payment key ZTERM
ZBD1T Cash (Prompt Payment) Discount Days ZBDXT
ZBD2T Cash (Prompt Payment) Discount Days ZBDXT
ZBD3T Cash (Prompt Payment) Discount Days ZBDXT
ZBD1P Cash discount percentage 1 PRZ23
ZBD2P Cash Discount Percentage 2 PRZ23
WKURS Exchange Rate KURSP
ANGNR Quotation Number ANGNR
IHREZ Your Reference TEXT12
VERKF Responsible Salesperson at Supplier's Office TEXT30
TELF1 Supplier's Telephone Number TEXT16
ACTIVE_ID Active Purchasing Document EBELN
ABGRU Field Not Used CHAR2
INCO2 Incoterms (Part 2) INCO2
SUBMI Collective Number CHAR10
KNUMV Number of the Document Condition KNUMV
STAFO Update Group for statistics update STAFO
UNSEZ Our Reference TEXT12
LOGSY Logical System LOGSYS
UPINC Item Number Interval for Subitems PINCR
FRGZU Release State FRGZU
ADRNR Address Number AD_ADDRNUM
STCEG_L Country/Region of Sales Tax ID Number LAND1
STCEG VAT Registration Number STCEG
ADDNR Document number for additional ADDI_BELNR
REVNO Version number in Purchasing REVNO
SCMPROC SCM Process That Created the Purchase Order CHAR1
REASON_CODE Goods Receipt Reason Code /SAPPSPRO/_GR_REASON_CODE
RETPC Retention in Percent PRZ32
DPTYP Down Payment Indicator ME_DPTYPE_DOMAIN
DPPCT Down Payment Percentage PRZ32
MSR_ID Process Identification Number MSR_PROCESS_ID
GROUPING_ID Grouping ID for Company Codes MMPUR_D_CC_GROUPING_ID
PARENT_ID ID of the Parent Document EBELN
LEGAL_CONTRACT Legal Contract Number CHAR040
DESCRIPTION Contract Name TEXT40
VSART Shipping Type VERSART
HANDOVERLOC Location for a physical handover of goods HANDOVER_LOC
SHIPCOND Shipping Conditions VSBED
INCO2_L Incoterms Location 1 INCO_L
INCO3_L Incoterms Location 2 INCO_L
INCO2_KEY Incoterm Location 1 - Place of Destination /SCMTMS/LOCUUID
INCO3_KEY Incoterm Location 2 - Place of Delivery /SCMTMS/LOCUUID
INCO4_KEY Incoterm - Deviating Place of Destination /SCMTMS/LOCUUID
FOLLOWON_DOC_TYPE Follow-On Purchasing Document Type BSART
DUMMY_EKKO_INCL_EEW_PS Data Element for Extensibility of Purchasing Document Header EKKO_INCL_EEW
EXTERNALSYSTEM ID of External Reference System SLD_BSKEY
EXTERNALREFERENCEID External Reference ID MMPUR_EXTREFID
EXT_REV_TMSTMP Timestamp for Revision of External Calls TZNTSTMPL
FORCE_ID Internal Key for Force Element SYSUUID_C
FORCE_CNT Internal (Version) Counter NUMC6
SOURCE_LOGSYS Logical system LOGSYS
FSH_TRANSACTION Transaction Number FSH_TRANSACTION
FSH_ITEM_GROUP Item Group FSH_ITEM_GROUP
FSH_VAS_LAST_ITEM Last VAS Item Number FSH_VAS_ITEM
TMS_REF_UUID Reference UUID of Transportation Management SYSUUID_22
/DMBE/DEALNUMBER Deal Number /DMBE/DM_SMART_ID
/DMBE/EVGIDRENEWAL Evergreen Renewal Period /DMBE/DM_EVERGREEN_ID
/DMBE/EVGIDCANCEL Evergreen Cancellation Period /DMBE/DM_EVERGREEN_ID
APCGK_EXTEND Extended key for annexing package NUMC10
Z_DEV deviation percentage /ILE/TDEC3_3
NUMERATOR IL Annexing Numerator CHAR20
HASHCAL Accountant general method /ILE/MTG_CHASHCAL
NEGATIVE Do not allow negative annexing /ILE/NEGATIVE_ANNEXING
HASHCAL_EXISTS Purchasing organization EKORG
POSTAT Flag for the S1POSTAT message ADSPC_FLAG
VZSKZ Interest Indicator VZSKZ
FSH_SNST_STATUS Snapshot Status FSH_SNST_STATUS
DESP Despatch TEXT100
PARE Assessment TEXT100
PFM_CONTRACT PTFM: Contract in Purchasing process PS_POSNR
EQ_WERKS Plant Header: All Items Have Same Receiving Plant WERKS
OTB_COND_TYPE OTB Condition Type KSCHL
KEY_ID Unique Number of Budget WRF_BUDG_KEY_ID
SPR_RSN_PROFILE Reason Profile for OTB Special Release WRF_POTB_SPR_RSN_PROFILE
BUDG_TYPE Budget Type WRF_BUDG_TYPE
Master Data Relations | to Other Relations ↓ Join Conditions
Reason for Cancellation
  • Client
  • Reason for Cancellation
  • FNDEI_EKKO_FILTER.MANDT == T165R.MANDT
  • FNDEI_EKKO_FILTER.ABSGR == T165R.ABSGR
Purchasing Document Type
  • Purchasing Document Category
  • Purchasing Document Type
  • Client
  • FNDEI_EKKO_FILTER.BSTYP == T161.BSTYP
  • FNDEI_EKKO_FILTER.BSART == T161.BSART
  • FNDEI_EKKO_FILTER.MANDT == T161.MANDT
Company Code
  • Client
  • Company Code
  • FNDEI_EKKO_FILTER.MANDT == T001.MANDT
  • FNDEI_EKKO_FILTER.BUKRS == T001.BUKRS
Purchasing Group
  • Client
  • Purchasing Group
  • FNDEI_EKKO_FILTER.MANDT == T024.MANDT
  • FNDEI_EKKO_FILTER.EKGRP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • FNDEI_EKKO_FILTER.MANDT == T024E.MANDT
  • FNDEI_EKKO_FILTER.EKORG == T024E.EKORG
Release group
  • Client
  • Release group
  • FNDEI_EKKO_FILTER.MANDT == T16FG.MANDT
  • FNDEI_EKKO_FILTER.FRGGR == T16FG.FRGGR
Release Indicator: Purchasing Document
  • Release Indicator: Purchasing Document
  • Client
  • FNDEI_EKKO_FILTER.FRGKE == T16FB.FRGKE
  • FNDEI_EKKO_FILTER.MANDT == T16FB.MANDT
Release Strategy
  • Client
  • Release Strategy
  • Release group
  • FNDEI_EKKO_FILTER.MANDT == T16FS.MANDT
  • FNDEI_EKKO_FILTER.FRGSX == T16FS.FRGSX
  • FNDEI_EKKO_FILTER.FRGGR == T16FS.FRGGR
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • FNDEI_EKKO_FILTER.INCO1 == TINC.INCO1
  • FNDEI_EKKO_FILTER.MANDT == TINC.MANDT
Incoterms Version
  • Client
  • Incoterms Version
  • FNDEI_EKKO_FILTER.MANDT == TINCV.MANDT
  • FNDEI_EKKO_FILTER.INCOV == TINCV.INCOV
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • FNDEI_EKKO_FILTER.KALSM == T683.KALSM
  • FNDEI_EKKO_FILTER.[column in domain "KAPPL"] == T683.KAPPL
  • FNDEI_EKKO_FILTER.[column in domain "KVEWE"] == T683.KVEWE
  • FNDEI_EKKO_FILTER.MANDT == T683.MANDT
Customer Number
  • Client
  • Customer Number
  • FNDEI_EKKO_FILTER.MANDT == KNA1.MANDT
  • FNDEI_EKKO_FILTER.KUNNR == KNA1.KUNNR
Country/Region for Tax Report
  • Client
  • Country/Region for Tax Report
  • FNDEI_EKKO_FILTER.MANDT == T005.MANDT
  • FNDEI_EKKO_FILTER.LANDS == T005.LAND1
Field not used
  • Field not used
  • Client
  • FNDEI_EKKO_FILTER.LBLIF == LFA1.LIFNR
  • FNDEI_EKKO_FILTER.MANDT == LFA1.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • FNDEI_EKKO_FILTER.LIFNR == LFA1.LIFNR
  • FNDEI_EKKO_FILTER.MANDT == LFA1.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • FNDEI_EKKO_FILTER.LIFRE == LFA1.LIFNR
  • FNDEI_EKKO_FILTER.MANDT == LFA1.MANDT
Goods Supplier
  • Goods Supplier
  • Client
  • FNDEI_EKKO_FILTER.LLIEF == LFA1.LIFNR
  • FNDEI_EKKO_FILTER.MANDT == LFA1.MANDT
Relocation ID
  • Relocation ID
  • Client
Relocation Step ID
  • Client
  • Relocation Step ID
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • FNDEI_EKKO_FILTER.MANDT == T001W.MANDT
  • FNDEI_EKKO_FILTER.RESWK == T001W.WERKS
Language Key FNDEI_EKKO_FILTER.SPRAS == T002.SPRAS
Currency Key
  • Client
  • Currency Key
  • FNDEI_EKKO_FILTER.MANDT == TCURC.MANDT
  • FNDEI_EKKO_FILTER.WAERS == TCURC.WAERS
Annexing package key
  • Annexing package key
  • Extended key for annexing package
  • Client
  • FNDEI_EKKO_FILTER.ZAPCGK == /ILE/TV01.APCGK
  • FNDEI_EKKO_FILTER.APCGK_EXTEND == /ILE/TV01.APCGK_EXTEND
  • FNDEI_EKKO_FILTER.MANDT == /ILE/TV01.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Legal competence
  • Client
  • Legal competence
Adjustment/contest
  • Adjustment/contest
  • Client
Contract
  • Contract
  • Client
Job
  • Client
  • Job
Miscellaneous
  • Client
  • Miscellaneous
Job
  • Client
  • Job