MMPUR_ANAEXTEKET

Consoludated Table for Central PO, Item, Scheduleline | #transactional | Component: Reporting
Column Name Description
MANDT Client
EBELN Purchasing Document Number
EBELP 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
Column Name Description
AEDAT Last Changed On
BEDAT_POHDR Purchasing Document 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 Indicator for Delivery Completion 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
LOEKZ_POHDR Asset class marked for deletion 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
USERDESCRIPTION Full Name of Person TEXT80
EXTRACTIONDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
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_EXT_EKPO_INCL_EEW_PS Data Element for Extensibility of Purchasing Document Item EKPO_INCL_EEW
DUMMY_EXTN_EKKO_INCL_EEW_PS Data Element for Extensibility of Purchasing Document Header EKKO_INCL_EEW
DUMMY_EXT_EKKO_INCL_EEW_PS Data Element for Extensibility of Purchasing Document Header EKKO_INCL_EEW
Other Relations Join Conditions
Category of delivery date
  • Category of delivery date
  • Client
  • ?
  • MMPUR_ANAEXTEKET.LPEIN == TPRG.PRGBZ
  • MMPUR_ANAEXTEKET.MANDT == TPRG.MANDT
  • MMPUR_ANAEXTEKET.[column in domain "SPRAS"] == TPRG.SPRAS