MMPUR_ANA_EKET

Analytical Data for Schedule Lines | #transactional | Component: Purchasing
Column Name Description
MANDT FK Client
EBELN FK Purchasing Document Number
EBELP FK Item Number of Purchasing Document
ETENR Schedule Line Number
BE_SOURCE_SYS Connected System ID
Column Name Description
💲 Currency Key (MMPUR_ANA_REPCUR.REP_WAERS):
NETWR_SL_REPCURR1 Net Amount (in Reporting Currency 1)
NETWR_SL_REPCURR2 Net Amount (in Reporting Currency 2)
OBMNG_NETWR_REPCURR1 Open Amount (in Reporting Currency 1)
OBMNG_NETWR_REPCURR2 Open Amount (in Reporting Currency 2)
NETPR_REPCURR1 Net Price: Reporting Currency 1
NETPR_REPCURR2 Net Price: Reporting Currency 2
💲 Currency Key (EKKO.WAERS):
NETWR Net Order Value in PO Currency
NETWR_BASE Net Amount in Company Currency
OBMNG_NETWR_BASE Open Amount (in Company Currency)
OBMNG_NETWR Open Amount (in Document Currency)
NETPR_BASE Net Price: Company Currency
NETPR Net Price in Purchasing Document (in Document Currency)
Column Name Description
📏 Purchase Order Unit of Measure (EKPO.MEINS):
OBMNG Open Quantity
MENGE_EKPO Purchase Order Quantity
MENGE Scheduled Quantity
AMENG Previous Quantity (Delivery Schedule Lines)
WEMNG Quantity of goods received
WAMNG Issued Quantity
MNG02 Committed Quantity
📏 Purchase Order Unit of Measure (MEINS_EKPO):
TOTALEXPECTEDQUANTITY Expected Quantity
LASTEXPECTEDQUANTITY Expected Quantity
Column Name Description
AEDAT Last Changed On
BEDAT_POHDR Purchasing Document Date
FIRSTGRPOSTINGDATE First Goods Receipt Date
FINALGRPOSTINGDATE Final Goods Receipt Date
EINDT Item delivery date
SLFDT Statistics-Relevant Delivery Date
UZEIT Delivery Date Time-Spot
BEDAT Order date of schedule line
DAT01 Committed date
ALTDT Previous delivery date
MBDAT Material Staging/Availability Date
MBUHR Material Staging Time (Local, Relating to a Plant)
LDDAT Loading Date
LDUHR Loading Time (Local Time Relating to a Shipping Point)
TDDAT Transportation Planning Date
TDUHR Transp. Planning Time (Local, Relating to a Shipping Point)
WADAT Goods Issue Date
WAUHR Time of Goods Issue (Local, Relating to a Plant)
ELDAT Goods Receipt End Date
ELUHR Goods Receipt End Time (Local, Relating to a Plant)
STARTDATE Start Date for Period of Performance
ENDDATE End Date for Period of Performance
_DATAAGING Data Filter Value for Data Aging
BUDAT Posting Date in the Document
Column Name Description
ZERO_VAL_REPCURR_IND Reporting Currency Show values
ELIKZ "Delivery Completed" Indicator Show values
WEPOS Goods Receipt Indicator Show values
LOEKZ Asset class marked for deletion Show values
MEMORY Purchase order not yet complete Show values
BSTYP Purchasing Document Category Show values
VRTKZ Distribution Indicator for Multiple Account Assignment Show values
STATU Status of Purchasing Document Show values
PROCSTAT Purchasing document processing state Show values
ISAGED Document is aged Show values
RETPO Returns Item Show values
FRGRL Release Not Yet Completely Effected Show values
FINALSCHEDULELINE Final Schedule Line for the Purchase Order Item Show values
NDD Indicator for Next Delivery Line Show values
LOEKZ_POHDR Asset class marked for deletion Show values
WEBRE Indicator: GR-Based Invoice Verification Show values
ESTKZ Creation indicator (purchase requisition/schedule lines) Show values
FIXKZ Schedule Line is "Fixed" Show values
ABART Scheduling agreement release type Show values
Column Name Description Domain name
UNIQUEID Schedule line id(Concatenation of EBELN, EBELP, EETEN) PURGDOCSCHEDULELINEUNIQUEID
EKORG Purchasing organization EKORG
EKGRP Purchasing Group EKGRP
BUKRS Company Code BUKRS
WERKS Plant WERKS
LIFNR Account Number of Supplier LIFNR
MATNR Material Number MATNR
MATKL Material Group MATKL
SERVICEPERFORMER Service Performer BU_PARTNER
BSART Order Type (Purchasing) BSART
PSTYP Item category in purchasing document PSTYP
KTPNR Item number of principal purchase agreement EBELP
KNTTP Account Assignment Category KNTTP
KONNR Number of principal purchase agreement EBELN
ERNAM Name of Person Responsible for Creating the Object USNAM
LASTCHANGEDATETIME Change Time Stamp TZNTSTMPL
BPUMZ Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
BPUMN Denominator for Conv. of Order Price Unit into Order Unit UMBSN
PEINH Price unit DEC5
PRODUCTTYPE Product Type Group CHAR2
TIMEVARIANCESCORE Variance Score for Statistical Delivery Date
TIMEVARIANCESCOREBYDELIVDATE MM_A_TIMEVARC_SCORE_DELIV_DATE
TIMEVARIANCEINDAYS Overdue days
TIMEVARIANCEINPCT Variance % for Statistical Delivery Date
TIMEVARIANCEINPCTBYDELIVDATE Variance for Delivery Date DEC
UMREZ Numerator for Conversion of Order Unit to Base Unit UMBSZ
UMREN Denominator for Conversion of Order Unit to Base Unit UMBSN
RESWK Supplying (issuing) plant in case of stock transport order WERKS
BANFN Purchase Requisition Number BANFN
MAHNZ No. of Reminders/Expediters for Schedule Line PACK2
GJAHR Material Document Year GJAHR
BELNR Number of Material Document BELNR
BUZEI Item in Material Document MBLPO
DUMMY_EKKO_INCL_EEW_PS Data Element for Extensibility of Purchasing Document Header EKKO_INCL_EEW
DUMMY_EKPO_INCL_EEW_PS Data Element for Extensibility of Purchasing Document Item EKPO_INCL_EEW
Master Data Relations Join Conditions
Client MMPUR_ANA_EKET.MANDT == T000.MANDT
Other Relations Join Conditions
Category of delivery date
  • Category of delivery date
  • Client
  • ?
  • MMPUR_ANA_EKET.LPEIN == TPRG.PRGBZ
  • MMPUR_ANA_EKET.MANDT == TPRG.MANDT
  • MMPUR_ANA_EKET.[column in domain "SPRAS"] == TPRG.SPRAS