EKBE is a standard Purchasing Transparent Table in SAP MM application, which stores History per Purchasing Document data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for EKBE. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

EKBE — Meta Data

Description: History per Purchasing Document
Main Category: MM
Sub Category: Purchasing
Table type: Transparent Table (TRANSP)

EKBE — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 EBELN Purchasing Doc. X CHAR 10 EKKO
    3 EBELP ARIBA item number X NUMC 5 EKPO
    4 ZEKKN Sequential Number of Account Assignment X NUMC 2
    5 VGABE Transaction/Event Type X CHAR 1
    6 GJAHR Fiscal Year X NUMC 4
    7 BELNR Document Number X CHAR 10
    8 BUZEI Posting row X NUMC 4
    9 .INCLUDE 0
    10 BEWTP Updated information in related user data field CHAR 1 T163B
    11 BWART Movement Type (Inventory Management) CHAR 3 T156
    12 BUDAT Posting Date DATS 8
    13 MENGE Quantity in base unit of measure QUAN 13
    14 BPMNG Quantity in Purchase Order Price Unit QUAN 13
    15 DMBTR Amount in LC CURR 13
    16 WRBTR Amount CURR 13
    17 WAERS Currency CUKY 5 TCURC
    18 AREWR Updated information in related user data field CURR 13
    19 WESBS Updated information in related user data field QUAN 13
    20 BPWES Updated information in related user data field QUAN 13
    21 SHKZG Debit/Credit CHAR 1
    22 BWTAR Valuation Type CHAR 10 T149D
    23 ELIKZ Deliv. Compl. CHAR 1
    24 XBLNR Reference CHAR 16
    25 LFGJA Fiscal Year of Current Period NUMC 4
    26 LFBNR Document No. of a Reference Document CHAR 10
    27 LFPOS Item of a Reference Document NUMC 4
    28 GRUND Reason for goods movment NUMC 4 T157D
    29 CPUDT Entered on DATS 8
    30 CPUTM Time of Entry TIMS 6
    31 REEWR Updated information in related user data field CURR 13
    32 EVERE Compliance with Shipping Instructions CHAR 2 T027C
    33 REFWR Updated information in related user data field CURR 13
    34 MATNR Material CHAR 40 MARA
    35 WERKS Plant CHAR 4 T001W
    36 XWSBR Reversal of GR allowed for GR-based IV despite invoice CHAR 1
    37 ETENS Updated information in related user data field NUMC 4
    38 KNUMV Number of the document condition CHAR 10
    39 MWSKZ Tax code CHAR 2 *
    40 LSMNG Quantity in Unit of Measure from Delivery Note QUAN 13
    41 LSMEH Unit of Measure From Delivery Note UNIT 3 T006
    42 EMATN Material CHAR 40 MARA
    43 AREWW Updated information in related user data field CURR 13
    44 HSWAE Updated information in related user data field CUKY 5 TCURC
    45 BAMNG Quantity QUAN 13
    46 CHARG Batch CHAR 10 *
    47 BLDAT Document Date DATS 8
    48 XWOFF Calculation of val. open CHAR 1
    49 XUNPL Unplanned Account Assignment from Invoice Verification CHAR 1
    50 ERNAM Created by CHAR 12
    51 SRVPOS Activity Number CHAR 18 *
    52 PACKNO Package number NUMC 10 *
    53 INTROW Internal line number for limits NUMC 10
    54 BEKKN Updated information in related user data field NUMC 2
    55 LEMIN Returns Indicator CHAR 1
    56 AREWB Clearing Value on GR/IR Account in PO Currency CURR 13
    57 REWRB Invoice Amount in PO Currency CURR 13
    58 SAPRL SAP Release CHAR 4
    59 MENGE_POP Quantity QUAN 13
    60 BPMNG_POP Quantity in order price quantity unit QUAN 13
    61 DMBTR_POP CURR 13
    62 WRBTR_POP CURR 13
    63 WESBB Valuated Goods Receipt Blocked Stock in Order Unit QUAN 13
    64 BPWEB Quantity in Valuated GR Blocked Stock in Order Price Unit QUAN 13
    65 WEORA Updated information in related user data field CHAR 1
    66 AREWR_POP GR/IR account clearing value in local currency CURR 13
    67 KUDIF Exchange Rate Difference Amount CURR 13
    68 RETAMT_FC Retention Amount in Document Currency CURR 13
    69 RETAMT_LC Retention Amount in Company Code Currency CURR 13
    70 RETAMTP_FC Posted Retention Amount in Document Currency CURR 13
    71 RETAMTP_LC Posted Security Retention Amount in Company Code Currency CURR 13
    72 XMACC Multiple Account Assignment CHAR 1
    73 WKURS Exchange Rate DEC 9
    74 INV_ITEM_ORIGIN Origin of an Invoice Item CHAR 1
    75 VBELN_ST Delivery CHAR 10
    76 VBELP_ST Delivery Item NUMC 6
    77 SGT_SCAT Stock Segment CHAR 40
    78 _DATAAGING Data Filter Value for Data Aging DATS 8
    79 SESUOM UNIT 3 *
    80 LOGSY Logical System CHAR 10 *
    81 .INCLU--AP 0
    82 .INCLUDE 0
    83 FRBNR Number of Bill of Lading at Time of Goods Receipt CHAR 16
    84 OIA_IPMVAT Updated information in related user data field CHAR 1
    85 OIVATH Updated information in related user data field CURR 13
    86 OIVATF Updated information in related user data field CURR 13
    87 OIIMATV Internal material value CURR 13
    88 .INCLU--AP 0
    89 .INCLUDE 0
    90 OIMATCYC Updated information in related user data field NUMC 1 *
    91 .INCLU--AP 0
    92 .INCLUDE 0
    93 OITAXVAL Excise duty value in material inventory account CURR 13
    94 OITAXCON Updated information in related user data field CURR 13
    95 OIEDCL Excise duty clearing value CURR 13
    96 .INCLUDE 0
    97 ET_UPD Procedure for Updating the Schedule Line Quantity CHAR 1
    98 .INCLUDE 0
    99 /CWM/BAMNG Quantity in Parallel Unit of Measure QUAN 13
    100 /CWM/WESBS Goods Receipt Blocked Stock in Base/Parallel Unit of Measure QUAN 13
    101 /CWM/TY2TQ Type of Parallel Unit of Measure CHAR 1
    102 /CWM/WESBB QUAN 13
    103 .INCLU--AP 0
    104 J_SC_DIE_COMP_F Depreciation completion flag CHAR 1
    105 .INCLU--AP 0
    106 FSH_SEASON_YEAR Season Year CHAR 4
    107 FSH_SEASON Season CHAR 10
    108 FSH_COLLECTION Fashion Collection CHAR 10 *
    109 FSH_THEME Fashion Theme CHAR 10
    110 .INCLU--AP 0
    111 QTY_DIFF ATP: Confirmed Quantity QUAN 13
    112 .INCLU--AP 0
    113 WRF_CHARSTC1 Characteristic Value 1 CHAR 18
    114 WRF_CHARSTC2 Characteristic Value 2 CHAR 18
    115 WRF_CHARSTC3 Characteristic Value 3 CHAR 18

SAP Help, Wiki Resources, and Forum Discussions on EKBE

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
EKPO Purchasing Document Item MM - Purchasing
EKET Scheduling Agreement Schedule Lines MM - Purchasing
MKPF Header: Material Document MM - Inventory Management
EKKN Account Assignment in Purchasing Document MM - Purchasing
MARA General Material Data Logistics - Material Master
EBAN Purchase Requisition MM - Purchasing
BSEG Accounting Document Segment FI - Financial Accounting

Transaction Codes for SAP Table EKBE

TCODE Description Functional Area
MIRO Enter Incoming Invoice MM - Invoice Verification
MIGO Goods Movement MM - Inventory Management
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
ME23N Display Purchase Order MM - Purchasing
ME2N Purchase Orders by PO Number MM - Purchasing
ME21N Create Purchase Order MM - Purchasing
ME80FN General Analyses (F) MM - Purchasing
MB51 Material Doc. List MM - Inventory Management

FMs for SAP Table EKBE

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer
BAPI_PO_GETDETAIL Display Purchase Order Details MM - Basic Functions
BAPI_TRANSACTION_COMMIT Execute external Commit when using BAPIs Basis - ALE Integration Technology
REUSE_ALV_VARIANT_F4 Display variant selection dialog box BC - SAP List Viewer

ABAP Reports for SAP Table EKBE

ABAP REPORT Description Functional Area
RSCONN01 SAPconnect: Start Send Process Basis - Communication Services: Mail, Fax, SMS, Telephony
SPRSL TEXT 630 - Workbench Tools: Editors
RM07DOCS Material Document List MM - Inventory Management
RMBESTK3 Tool for Rebuilding Purchase Orders MM - External Services
RMESSRK2 Analysis and Rebuild of Entry Sheets MM - External Services
SAPMM07M Module Pool for Goods Movements MM - Inventory Management
SAPLKKBL Dynamic List Display
EXTRACT Include EXTRACT Logistics - Product Data Management

BW Datasources for SAP Table EKBE

BW DATASOURCE Description Functional Area
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management
2LIS_02_SCL Purchasing Data (Schedule Line Level) MM - Materials Management
2LIS_02_SGR Produced Activity: Delivery of Schedule Lines MM - Materials Management
2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management
2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management
2LIS_02_HDR Purchasing Data (Header Level) MM - Materials Management
0FI_AP_4 Vendors: Line Items with Delta Extrcation FI - Accounts Payable
2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management

Authorization Objects for SAP Table EKBE

AUTHORIZATION OBJECT Description Functional Area
E_GRID Authorization Object for Grid
M_MATE_WRK Material Master: Plants
C_SIGN Authorization for Digital Signature
S_TCODE Transaction Code Check at Transaction Start
M_BEST_WRK Plant in Purchase Order
M_BEST_EKO Purchasing Organization in Purchase Order
P_PERNR HR: Master Data - Personnel Number Check