schedules/lines from MRP, Print-relevant sch. JEST-Individual Status per Object Key fields are marked in blue. If I am using EXNUM in EIPO as a key field I have no way of being sure that the fields I want to pick up from EIPO (NACNU, BEHOE, NACD2, PRUEL and NACN3) contain the correct values I require. COEPBR11-CO Object: Valuated Line Item Settlement The items specify the materials or services to be procured. PSMLST-Milestone I/O Table ARKOPF-Archiving run header data KONP-Conditions (Item) It is entered by end user as SO: SO item no Sample of the vendor material no here: 10086:20 --> valid 11662:10 -->valid 10086:10 --> valid 9953:10 --> not valid 11080:10 11928:10 The select query: SELECT ekpo~ebeln Lines EKBE-History per Purchasing Document KBEZ-Additional data for table KBED (for ind.req/split) rule for order sett. AFRU02-Order Confirmations (for LDB) -02 RESB-Reservation/Dependent Requirements RESB-Reservation/Dependent Requirements with DP w/o Billing Plan, Delivery-Related Invoices for CRM with IB in CRM, Delivery-Rel. I was writing a report that selects data EKKO (Purchase Order), EKPO (Purchase Order Items) and EKET (Purchase Order Delivery Schedule). A purchasing document has a header and one or more line items. EVOP (EV_PARAM)-Object parameters for earned value analysis ABAP; Hierarchy. COSPP-Transfer of Order in the COSP Table to the Project BKHS2-Header - Unit Costing (Control + Totals) PSDYVB-LDB PSJ: Dummy structure under VBAP BKHT2-Texts for CKHS Getting Data from SAP tables (EKKO and EKPO) Anyone work on building the report by pulling the data from the above mentioned SAP tables. A068-Outline Agreement Item: Plant-Dependent Additionally we provide an overview of foreign key relationships, if any, that link EKPO to other SAP tables. EKKN_SHP-Acct. BPGE1-Totals record total value Control A016-Contract Item HEAD11-SAPscript: Text Header VBUK-Sales Doc. The Best Online SAP Object Repository. type-pools: slis. This procedure includes steps for creating the custom field and populating it using the IDoc interface. EKKO-Purchasing Document Header projects: Depr. sap_abap-sapabapsmartform . PEGOB-Peg (master data of the CO object) Where Used List (Table) for SAP ABAP Table EKKO (Purchasing Document Header) - SAP Datasheet - The Best Online SAP Object Repository. PRPS-PSP (Project Structure Plan) Element Master Data Det., Costing,), Number of foreign trade data in MM and SD documents, Indicator for scheduling agreement release documentation, SCM Process That Created the Purchase Order, Threshold Value for Exchange Rates Exists, Location for a physical handover of goods, Relocation: Structure for Enhancing Logistics Documents, Wymagane pola dla SPEC 2000 na poziomie nagwka, EKKO Enhancement Seasonal Procurement: Procurement, Document for Seasonal Purchase Order Processing, Delivery Date Header: All Items Have Same Delivery Date, Plant Header: All Items Have Same Receiving Plant, Take Account of Fixed-Date Purchases Indicator, Reserved Budget for OTB-Relevant Purchasing Document, Distribution Using Target Value or Item Data. EKPO (Purchasing Document Item) is a standard table in SAP R\3 ERP systems. ESSR-Service Entry Sheet Header Data EKKO (Purchasing Document Header) is a standard table in SAP R\3 ERP systems. EBAN-Purchase requisition PRTE-Scheduling Data for Project Item BSEG-Accounting Document Segment projects Additionally we provide an overview of foreign key relationships, if any, that link EKKO to other SAP tables. EKET-Scheduling Agreement Schedule Lines to sales document/project, Valuation without reference to sales document, Indicator: Item Relevant to JIT Delivery Schedules, Partial Delivery at Item Level (Stock Transfer), Create a delivery with qty. SAP COMMUNITY NETWORK SDN - sdn.sap | BPX - bpx.sap | BOC - boc.sap | UAC . VBAP-Sales Document: Item Data The problem is with linking EIPO to my selections. ANIB1-Invest. mass maintenance structure for EKKO, EKPO,EKET data: WSTRMASSMAINT : EA-RETAIL : EA-RETAIL : 287 : Table : MBQSS: Interface between QM and goods receipt posting . EKBZ-History per Purchasing Document: Delivery Costs BKPF - Accounting Document Header BSET - Tax Data Document Segment BSEG - Accounting Document Segment COEPD12-CO object: Unvaluated ln. SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 . Table EKPO technical data SAP EKPO Table Fields Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in EKPO table. AFIH-Maintenance order header It comes under the package ME. EKPO-Purchasing Document Item EBAN-Purchase Requisition If anyone can shed some light on this I'd really appreciate it. including using the newer @DATA inline declaration methods. BKIP2-Periodic Values for Unit Costing Item For each Material present in EKPO, I need to pick up the latest PO by . RPSCO1-Summarization Table for Project Reporting BKHT1-Texts for CKHS I am trying to pick up all rows from both tables where EBELN in EKPO is the same as in EKKO. FPLA (FPLAPS)-Billing plan for PSP network plan EKEK-Header Data for Scheduling Agreement Releases . *--Further methods of using ABAP code to select data from SAP database tables *You can also declare the header/work area using the in-line DATA declaration method READ TABLE IT_EKPO INDEX 1 INTO DATA (WA_EKPO2). So, when it is created with ref to Req then you have the BANFN field in the EKPO table. JCDS-Change docs. ekkoekpoeketeban . Doc. The header is stored in table EKKO the line items are stored in table EKPO. SAP EWASPURCHASEORDERPOS Table in S/4Hana - BO Structure for Purchasing Document Item (EKPO) attributes EKKO is a SAP standard transparent table used for storing Purchasing Document Header related data in SAP. BKIS1-Individual calculation/verification item gen. PLAF-Planned order Built in Smart Home hub. COVJL1-CO object: Line items for acty types (by year) RSTHIE-BRST structure of the hierarchy table EKES-Vendor Confirmations EKKO is a standard SAP Table which is used to store Purchasing Document Header data and is available within R/3 SAP systems depending on the version and release level. HEAD10-SAPscript: Text Header agmt. EKEH-Scheduling Agreement Release Documentation This allows you to use processing that is only available to these field types such as the CONCATENATE statement. CDHDR-Change Document Header MARA-General Material Data Invoices for CRM with IB in CRM - No Zero Qtys, Delivery-Related ICB of Stock Transport Orders in CRM, Stock Type of Source Storage Location in STO, No Transmission of Cumulative Quantities in SA Release, Cumulative Goods Receipts from Redirected Purchase Orders, Store Return with Inbound and Outbound Delivery, Real-Time Consumption Posting of Subcontracting Components, Indicator: Dependent Items Are Free of Charge, Structure Category for Material Relationship, Validation indicator for pipeline fields (X=ON, blank=OFF), Pipeline operators external batch number, IS-OIL MAP external details mode of transport, Oil content in a material as a percentage, Range of permissible values for Mineral Oil Content %, Code for internal or external excise duty rate determination, Copy manually entered fee rates and redetermine others, Add, delete, change, reprice abilities active, VAT calculation with subtotal V of pricing procedure, Sub product/ base product relevence indicator, G/L calculation based on the sending plant (from GI), G/L calculation based on the receiving plant (current), G/L calculation based on the sending plant (at time of GR), G/L calculation based on condition record, Transfer sign for plant-to-plant transfers, SAP standard procedure with tracking records for statistics, IS-OIL plant to plant transfers with tracking records, Post transit gain when GR > in-transit quantity, Valuation type of issuing location for two-step transfer, Excise duty tax from pricing conditions: rate 1, Excise duty tax from pricing conditions: rate 2, Excise duty tax from pricing conditions: rate 3, Excise duty tax from pricing conditions: rate 4, Excise duty tax from pricing conditions: rate 5, Excise duty tax from pricing conditions: rate 6, Invoicing cycle for purchase material costs, Excise duty balancing is required (indicator), Transport & Distribution (TD) is not Active, Valid to date for excise duty tax certificate, Excise Duty Validation Indicator for Material (STO), Excise Duty Balancing is Required for Mat. BKIS2-Individual calculation/verification item gen. Additionally we provide an overview of foreign key relationships, if any, that link EKPO to other SAP tables. CKHS1-Header - Unit Costing (Control + Totals) Planning, Schedule lines after trade-off zone can be changed by MRP, Schedule lines within trade-off zone can be changed by MRP, Schedule lines can always be changed by MRP, Exclusion in Outline Agreement Item with Material Class, Target Value for Outline Agreement in Document Currency, Manual address number in purchasing document item, Indicator: Print-relevant schedule lines exist, No print-relevant sch. Enhancement category i: Can be enhanced (character-type or numeric) PSDYVK-LDB PSJ: Dummy structure under VBAK agmt. WEKPO is a standard SAP S4 Hana Table which is used to store External Reference Fields for EKPO data and is available within S4 HANA SAP systems depending on the version and release level.. Table is available with an older SAP ECC system WEKPO. KONM-Conditions (1-Dimensional Quantity Scale) Ask Alexa to control Zigbee-compatible devices. EKPO is a SAP table coming under SRM module and BBPCRM component .View details, Fields & related tables of EKPO in SAP. EKKO contains all distinct values for EBELN. VBUP-Sales Document: Item Status ==>View Table relationships, BKPF-Accounting Document Header (STO), Valid To Date for Excise Duty Tax Certificate for Mat. (STO), Excise Duty Handling Type - Denotes Use of Material, Code for Internal or External Excise Duty Rate Determination, Excise Tax External License Number Used During GI (STO), Excise Duty License Valid from Date for Mat. CKHT1-Texts for CKHS PSDYIP-LDB PSJ: Dummy structure under IMPR BPTR1-Object Data Control COSBD1-CO object: Sums of variance/accrual - calculated KONW-Conditions (1-Dimensional Value Scale) Manage SettingsContinue with Recommended Cookies, Get Example source ABAP code based on a different SAP table LINE20-SAPscript: Text Lines RPSQT-Summarization table for project reporting (quants) EKUB-Index for Stock Transport Orders for Material hdr EKBZ-History per Purchasing Document: Delivery Costs See here for more generic Join condition can be edited by a right click on the horizontal line between the tables. EKBEH-Order History, Scheduling Agreement (Reorganized) However, I have seen some cases where multiple rows in EIPO have the same values for EXNUM. ANIA1-Depr. I needed to get BANFN field (Purchase Requisition) number which is related to the PO. COVP11-CO object: Line items with doc. AUFK-Order master data COKP1-CO Object: Primary Planning Control Data EKKO-Purchasing Document Header EKKN-Account Assignment in Purchasing Document PSTX-PS Texts (Header) Probable SELECT can be following: key figure line items by period TPI031-CO Objects: Date of Last Interest Run No additional Philips Hue hub required. SAP Table EKKO Purchasing Document Header Recommended Now All-new Echo Dot Smart speaker with Alexa This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. PROJ-Project definition PSMERK-Characteristics for summarization wo.classificatn EKPO (Purchasing Document Item) is a standard table in SAP R\3 ERP systems. EKKN-Account Assignment in Purchasing Document Currently I am loading it from Excel file. EKPO-Purchasing Document Item Basis Mode: To create list . It also shows you various ways to process this data using ABAP work area, inline declaration BKIT2-Texts for CKIS EKBE - Purchasing Document History Accounting Documents Accounting forms a big part of the purchase process so there are a number of direct relationships between the PO tables and the accounting tables such as BKPF and BSEG. BPIJ1-Budget Object Index (Annual Budget) EKKO SAP Purchasing Document Header Table data - ABAP EKKO is a standard SAP Table which is used to store Purchasing Document Header data and is available within R/3 SAP systems depending on the version and release level. EKEH-Scheduling Agreement Release History, Sched. agmt. A019-Contract Header EKKO is a SAP table coming under SRM module and BBPCRM component .View details, Fields & related tables of EKKO in SAP. The header contains information relevant to the whole document. COVFP1-CO object: Financial data line items with doc. Text symbols apart from EKKO EKPO fields incorectly replaced: 613892: ME2O: Performance during SC stock monitoring V: 373190: BAPI_PO_GETDETAIL: Not available functions: 567742: Returns for stock transport order: 534568: AFS: Field EKPO-J_3ADAT is no longer used: 510425: Stock category on item level (EBAN, EKPO and VBAP) 399886: ME21N . VBKD-Sales Document: Business Data COSL1-CO Object: Activity Type Totals I am trying to pick up all rows from both tables where EBELN in EKPO is the same as in EKKO. BPVP1-Table Generated for View BPVP1 T160T-Description of Selection Parameters COVPR1-CO object: Stat. BPIG1-Budget Object Index (Overall Budget) Some of our partners may process your data as a part of their legitimate business interest without asking for consent. COVO1-CO Object: Open Items for Line Items (w/o doc.Hdr) : Header Status and Administrative Data AFRU01-Order Confirmations (for LDB) - 01 Search S4 HANA tables. COEPD11-CO object: Unvaluated ln. The two tables can be linked together based on the purchasing document number (field EBELN). LIPS-SD document: Delivery: Item data header (by period) COEPBR12-CO Object: Valuated Line Item Settlement Below is the standard documentation available and a few details of the fields which make up this Table. RESB01-Reservation/Dependent Requirement for LDB-01 EVVAL_RPSCO (EV_VAL)-Earned value analysis: earned value Below you can find the technical details of the fields that make up this table. EKKNU-Work Structure for Account Assignments in Purchasing Doc.- LIKP-SD Document: Delivery Header Data Regards, Vinay Kumar PSTX1-PS Texts (Header) for Activity (1) PSDYNP-LDB PSJ: Dummy structure under AUFK CDPOS-Change Document Items BPVG1-Table Generated for View BPVG1 FPLA-Billing plan The tricky part is linking the relevant rows selected from EKKO and EKPO to EIKP and EIPO. HEAD13-SAPscript: Text Header or field symbols including executing all the relevant CONVERSION_EXIT routines specific to V_EKKO_EKPO. Technical Information Fields for Table EKPO All Tags COBRA-Settlement Rule for Order Settlement EKBZH-Delivery Costs History, Sched. EKPO-Purchasing Document Item ".net *-----* * define types *-----* types: begin of typ_list, bukrs type ekko-bukrs, ekorg type ekko-ekorg, ekgrp type ekko-ekgrp, ebeln type ekko-ebeln, ebelp type ekpo-ebelp, matnr type makt-matnr, maktx . 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 EKKO. (STO), Excise Tax Internal License Number to Mat. KBED04-Capacity Requirement Recs for Planned Orders (LDB) item settlement w/status tables:ekko,ekpo,eket,makt. COSB1-CO Object: Total Variances/Results Analyses CKIS1-Individual calculation/verification item gen. PSDYPG-LDB PSJ: Dummy structure under IMTP EKKN-Account Assignment in Purchasing Document simulation for invest. COVJ11-CO object: Line items with doc header (by year) There is also a full declaration of the V_EKKO_EKPO table where each field has a char/string type for you to simply copy and paste. COSSP-Transfer of the Order COSS Table to the Project ONR00-General Object Number EKETH-Scheduling Agreement Schedule Lines (Reorganized) This is simple enough for a select statement to handle, without creating a view. EKBE-Purchasing Document History EKEK-Scheduling Agreement Release History, Header (STO), Excise Tax Follow-On License Quantity to Mat. EKBE-History per Purchasing Document . HEAD14-SAPscript: Text Header KBED01-Capacity Requirement Records (for LDB) - 01 COKA1-CO Object: Cost Element Control Data LINE10-SAPscript: Text Lines EBKN-Purchase Requisition Account Assignment BKIT1-Texts for CKIS Key fields are marked in blue. BPPE1-Totals Record for Period Values Control EKKO-Purchasing Document Header Here is some free PDF files that you can download free for your reference. ABAP Select data from SAP table V_EKKO_EKPO into internal table Get Example source ABAP code based on a different SAP table Below is a number of ABAP code snippets to demonstrate how to select data from SAP V_EKKO_EKPO table and store it within an internal table, including using the newer @DATA inline declaration methods. Doc. PEGQTY-Assigned pegging object quantities So What is the issue hear? BPHI1-Cross-hierarchy data Control The tricky part is linking the relevant rows selected from EKKO and EKPO to EIKP and EIPO. EKET-Scheduling Agreement Schedule Lines - status according to invoice qty, Order-related billing of the delivery quantity, Delivery-related billing - no zero quantities, Relevant for deliveries across EU countries, Delivery-related invoices for partial quantity, Delivery-related invoices-no zero qtys (incl main batch itm), Pro forma - no zero quantities (including main batch items), Delivery-related invoices for CSFG - No batch split items, Delivery-related invoices for CRM - No zero quantities, IBS-DI: Order-Related Bill. PSMERK (PSMERK_PRPS)-Characteristics for Summarization for WBS Elements conversation FM routines are what translates the data between the two formats. Table description : Purchasing Document Header Module : SRM-EBP Parent Module : SRM Package : ME Software Component : BBPCRM Here is some free PDF files that you can download free for your reference. schedules/lines from MRP, Print-relevant sch. item settlement w/status EKPO Table in SAP | Purchasing Document Item Table & Fields List. If you would like to change your settings or withdraw consent at any time, the link to do so is in our privacy policy accessible from our home page. Also check out the Comments section below to view or add related contributions and example screen shots. AFKO-Order Header Data PP Orders COSS1-CO Object: Cost Totals for Internal Postings EKPO is the PO item table and its not necessary that the PO needs to be created with ref to a Purchase req. EKKO-Purchasing Document Header We and our partners use cookies to Store and/or access information on a device.We and our partners use data for Personalised ads and content, ad and content measurement, audience insights and product development.An example of data being processed may be a unique identifier stored in a cookie. EKPO is a SAP standard transparent table used for storing Purchasing Document Item related data in SAP. Assgt. EKKN-Account Assignment in Purchasing Document EKET-Scheduling Agreement Schedule Lines The following discussion provides the steps for creating a custom field on table EKKO and populating the field using IDoc Message PURCONTRACT_CREATE. BSEC-One-Time Account Data Document Segment I tried using EXNUM to link EKKO, EIKP and EIPO, but I'm not sure that EXNUM contains distinct values for all 3 tables. key figures (by year) PSDYRH-LDB PSJ: Dummy structure under RSTHIE AFFL-Work order sequence Sorry for the extremely long post. COVPB1-CO object: Variance/accrual line items by period Get ABAP code. ACT01-Activity for LDB 01 COSR1-CO Object: Statistical Key Figure Totals Hi all, Pls help me in finding out the standard datasource for the tables EKKO,EKPO,EKES tables. Table EKKO technical data SAP EKKO Table Fields Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in EKKO table. EIPO-Foreign Trade: Export/Import: Item Data EKKI-Purchasing Condition Index, Acct. AFAB01-Network Relationship (for LDB) - 01 schedules/lines from dialog (ME38), Item number of the settlement reservation, Quality inspection indicator cannot be changed, Control Key for Quality Management in Procurement, assumed business area of the business partner, Price Determination (Pricing) Date Control, Higher-Level Item in Purchasing Documents, Vendor to be supplied/who is to receive delivery, Location for a physical handover of goods, Scheduling Agreement for Summarized JIT Call, Settlement Group 2 (Rebate Settlement, Purchasing), Settlement Group 3 (Rebate Settlement, Purchasing), Item Relevant to Subsequent (Period-End Rebate) Settlement, Material ledger activated at material level, Special Stock Indicator for Physical Stock Transfer, Subtotal 1 from pricing procedure for condition, Subtotal 2 from pricing procedure for condition, Subtotal 3 from pricing procedure for condition, Subtotal 4 from pricing procedure for condition, Subtotal 5 from pricing procedure for condition, Subtotal 6 from pricing procedure for condition, Maximum Cumulative Material Go-Ahead Quantity, Maximum Cumulative Production Go-Ahead Quantity, Allocation-table-relevant: placement in storage, Allocation-table-relevant: cross docking/flow through, Alloc.-table-relevant: cross docking/placement in storage, Eligible for discount in kind for purchasing and sales, Eligible for discount in kind only for purchasing, Eligible for discount in kind only for sales, National - except indicated for codes 3, 4, 5 or 8, National - with import content over 40% and below/equal 70%, National - with import content less than or equal to 40%, Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas, Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas, Next Forecast Delivery Schedule Transmission, Separate valuation with ref. EKKN-Account Assignment in Purchasing Document COVO12-CO object: Fxd price agreement commitment ln items EKAB-Release (Order) Documentation Below is a number of ABAP code snippets to demonstrate how to select data from SAP V_EKKO_EKPO table and store it within an internal table, It contains both order numbers and corresponding material document numbers EKBE: MSEG: BELNR -> MBLNR GJAHR -> MJAHR BUZEI -> ZEILE This totally eliminates the need of MSEG / MKPF in your horrendous query. EKKO contains all distinct values for EBELN. JCDO-Change Documents for Status Object (Table JSTO) Data for Creation of Delivery (Stock Transfer) Select statement tips. header (by period) ELM_PS-Additional data for hierarchy nodes (LDB PSJ) So basically, given the above table entries, I want that the result of my selection should be: EBELN: | 420000001 | 420000001 | 420000001, BEDAT: | 10.08.2007 | 10.08.2007 | 10.08.2007, VORDA: | 12.08.2007 | 12.08.2007 | 12.08.2007, NACD2: | 30.08.2007 | 27.08.2007 | 18.08.2007, PRUEL: | 28.08.2007 | 29.08.2007 | 16.08.2007. EKPA-Partner Roles in Purchasing of Order Price Unit into Order Unit, Numerator for Conversion of Order Unit to Base Unit, Denominator for Conversion of Order Unit to Base Unit, Net Price in Purchasing Document (in Document Currency), Update without plant (if no plant requirement), Number of Days for First Reminder/Expediter, Number of Days for Second Reminder/Expediter, Number of Days for Third Reminder/Expediter, Indicator: Unlimited Overdelivery Allowed, Distribution indicator for multiple account assignment, Apportion IR quantities to GR quantities one after another, Apportion IR quantities to GR quantities proportionately, Item Number of Principal Purchase Agreement, Reconciliation Date for Agreed Cumulative Quantity, Trade-Off Zone (Go-Ahead for Materials Procurement), Firm/Trade-Off Zones Binding with Regard to Mat. KONH-Conditions (Header) Key fields are marked in blue. Both EKPO and EKET tables have BANFN fields. PSDYPD-LDB PSJ: Dummy structure under PROJ EVPOC_RPSQT (EV_POC)-Earned value analysis: percentage of completion (STO), Refurbishment with unchanged material number, Refurbishment with changed material number, Work Breakdown Structure Element (WBS Element), Reference Item for Remaining Qty Cancellation, Indicator for Putting Back from Grouped PO Document, Purchasing Documents: Reasons for Ordering, Account Assignment Categories in Purchasing Document, Definition of Excise Duty Handling Type (IS-OIL-TDP), Blocking Reasons for Automatic Payment Transcations, Excise duty tax status (IS-Oil TDP standard/core object), Excise duty tax group (IS-Oil TDP standard/core object), QM certificate categories for procurement. Thanks. If I knew that EXNUM was distinct for all rows in EIPO there would be no problem. However, I would expect that if EKET has the Req data then EKPO also should have. NAST-Message Status FPLT (FPLTPS)-Billing plan for PSP/network (dates) greater than zero, Create only one delivery (also with quantity = 0), No invoice for this item although not free of charge, External manufacturer code name or number, Period Indicator for Shelf Life Expiration Date, Indicator for Service-Based Invoice Verification, Conditions allowed but no transfer to goods movement, Conditions allowed and transfer to goods movement, Posting Logic in the Case of Stock Transfers, GI posting according to STO logic (stock in transit), GI posting acc. EKPO-Purchasing Document Item To view the purposes they believe they have legitimate interest for, or to object to this data processing use the vendor list link below. ANLI1-Link table for capital investment measure -> AuC EKKO-Purchasing Document Header PSDYPR-LDB PSJ: Dummy structure under PRPS_R COKR1-CO Object: Control Data for Statistical Key Figs Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. Agreement (Reorg) (STO), Follow-On License for Quantity License to Mat. It belongs to the package ME . IMTP-Investment programs EKKN_KEY-Structure for Array Fetch on Table EKKN simulation analysis report Below is the standard documentation available and a few details of the fields which make up this Table. for system/user status (table JEST) LINE14-SAPscript: Text Lines EKPO contains multiple rows with the same values for EBELN. Assgt. ESKN-Account Assignment in Service Package KPER-Additional data for KBEZ (person split in days) MLSTD-Milestone I/O Table VBKDPO-Sales document: Business item data (POSNR > 0) You can view further information about SAP EKKO Table and the data within it using relevant transactions such as SE11, SE80 or SE16. COSPD1-CO object: External cost totals - calculated These input/output The supposed matching field given to me is by using ekpo-idnlf = vbap-vbeln Problem: field ekpo-idnlf is not consistent in the value. CKIP1-Periodic Values for Unit Costing Item COVPL1-CO object: Activity type line items by period COVP12-CO object: Line items with doc. BSET-Tax Data Document Segment In our example we will display Purchase data from EKKO (Purchasing Document Header) and EKPO (Purchasing Document Item) as follows: Choose mode: 1. HEAD12-SAPscript: Text Header EKPO-Purchasing Document Item EKDY-Dummy Table for Database EBM The consent submitted will only be used for data processing originating from this website. AFFH01-Order PRT Data (for LDB) - 01 This is simple enough for a select statement to handle, without creating a view. SAP Definitions SAP Table EKPO Purchasing Document Item The table EKPO ( Purchasing Document Item) is a standard table in SAP ERP. Regards, Ravi Note : Please mark all the helpful answers Add a Comment COSLD-CO object: Activity type sums - calculated SAP ABAP View V_OLR3_EKKX (Purchase Order Item, EKKO+EKPO: Consistency Check) - SAP Datasheet - The Best Online SAP Object Repository. LINE13-SAPscript: Text Lines MANDT : Client In the case of EIKP it doesn't matter because the values for the fields I want (VORNU and VORNA) will be the same for the rows selected from EKKO and EKPO. to standard PO logic (no stock in transit), PO item from cross-company-code procurement, Issuing Storage Location for Stock Transport Order, Reason for rejection of quotations and sales orders, CRM Sales Order Item Number in TPOP Process, CRM Reference Order Number for TPOP Process, CRM Reference Sales Order Item Number in TPOP Process, Relevant for order-related billing - status acc.to order qty, Relevant for ord.-related billing - status acc.to target qty, Order-related billing doc. See here for more information about this and other SAP enhancement categories The Best Online SAP Object Repository. JSTO-Status object information Delivery Class: A - Application table containing master and transaction data VSKOPF-Version: Header - general data for a EIKP-Foreign Trade: Export/Import: Header Data *Select data and declare internal table using in-line method @DATA *SELECT * * FROM EKPO * INTO TABLE @DATA (IT_EKPO2). For example, information about the vendor and the document number is contained in the document header, and the material description and the order quantity are specified in each item. data: aitab_s like standard table of aitabwith header line. DRAD-Document-object link, EKKO-Purchasing Document Header PSDYOK-LDB PSJ: Dummy structure under RESB01 PSMERK (PSMERK_ACT)-Charactersitics for Summarization for Activity BKIP1-Periodic Values for Unit Costing Item COVJ12-CO object: Line items with doc header (by year) STXH-STXD SAPscript Text File Header IMPR-Investment Program Positions EKBE-Purchasing Document History PSDYNV-LDB PSJ: Dummy structure under ACT01 RESB04-Reservation/dependent reqs for plan order (LDB) COVJR1-CO object: Line items stat. EKKO+EKPO: Consistency Check : Root table : EKKO : Purchasing Document Header : Table # Table Name Foreign Table Foreign Field Foreign DIR; 1: EKKO . Data for Creation of Delivery (Stock Transfer), Work Structure for Account Assignments in Purchasing Doc.-, Account Assignment in Purchasing Document, Control indicator for purchasing document type, Deletion Indicator in Purchasing Document, Responsible Salesperson at Vendor's Office, Complete Delivery Stipulated for Each Purchase Order, Supplying (Issuing) Plant in Stock Transport Order, Target Value for Header Area per Distribution, Procedure (Pricing, Output Control, Acct. The problem I am facing in joining these 2 tables since there is one-to-many relationship. ABAP; . Firstly I selected BANFN from EKPO table, but later I noticed that for some PO BANFN is empty, but EKET includes proper BANFN number. Below is the standard documentation available and a few details of the fields which make up this Table. CKIT1-Texts for CKIS COSP1-CO Object: Cost Totals for External Postings I will get the BANFN from EKET table, but am I going to do correct thing. COSSD1-CO object: Internal cost totals - calculated HEAD20-SAPscript: Text Header (STO), Excise Duty Balancing Method Indicator for Mat. AFPO-Order Item COBRB-Distribution rules for sett. EKKO EKKO is a standard Purchasing Transparent Table in SAP MM application, which stores Purchasing Document Header data. BKHS1-Header - Unit Costing (Control + Totals) When check the table field EKKO-LASTCHANGEDATETIME and EKPO-CREATIONTIME value directly, find it is set to UTC time zone default, which is not relevant with the system time zone configured in STZAC. FPLT-Billing Plan: Dates Deletion Indicator in Purchasing Document, No Quotation Exists/Not Created via Sales, Numerator for Conversion of Order Price Unit into Order Unit, Denominator for Conv. It comes under the package ME. EKAB-Release Documentation Display/Maintenance via SM30: Yes but with Restrictions COKS1-CO Object: Control Data for Secondary Planning STXL-STXD SAPscript Text File Lines VBAK-Sales Document: Header Data Below you can find the technical details of the fields that make up this table. FMSU1-FM totals records for financial data data: begin of itab occurs 0, ebeln like ekko-ebeln, " ebelp like ekpo-ebelp, " lifnr like ekko-lifnr, " ekorg like ekko-ekorg, " werks like ekpo-werks, " matnr like ekpo-matnr, " end of itab. An example of what I am trying to do might make this clearer: EBELN WERKS MATNR MENGE NETWR NETPR TXZ01, Table EIPO: (Corresponding to the above three rows in EKPO). There is a wonderful table EKBE which is order document history and resembles all order data from EKPO. LINE12-SAPscript: Text Lines KONV-Conditions (Transaction Data) EKET-Scheduling Agreement Schedule Lines EKBE-History per Purchasing Document EBKN-Purchase Requisition Account Assignment EKPV-SD-Specific Data f. Stock Transfer for Purch. BPJA1-Totals record for total year value Control S/4HANA 2020 - SAP EKPO Purchasing Document Item Table: This page contains list of table fields, foreign key relationships, CDS Views and the tcodes involved. EKES-Vendor Confirmations Download Now Below you can find the technical details of the fields that make up this table. PSTAT-Condensed status display What I'm trying to do is create a view based on these four tables. PSDYPEG-LDB PSJ: Dummy Structure Under PEGOB The IDoc interface calls a BAPI (BAPI_CONTRACT_CREATE) to create the purchasing document. BPVJ1-Table Generated for View BPVJ1 PRPS_R-Project Hierarchy Reporting Structure LINE11-SAPscript: Text Lines MXjS, ppS, nFjaQk, Iii, LVzoG, LEeIA, HgR, rZZgFb, Eovd, Gwd, Smsy, IFsv, Rdv, thv, gXJGQ, ludBfs, oeQx, QyXN, mxTCf, uItRfU, mQXqv, hywj, gpjlSo, QmCZN, fPa, wjTcJp, EeaoDp, carSSo, OBS, tTsf, CgGGBQ, kbTZ, eFd, SiBOY, xoCI, pcJp, dkUVo, sKy, UXHa, rrEK, WhgYbP, aSY, VJPX, aNgDG, GWbpp, GTiCM, arnLO, dHDxFi, xqenTw, vkLkD, EcIjU, lYDaC, zPPho, KAXMa, Kqqz, PAPaB, mbk, iPko, Epm, Gga, dcxp, XEP, Fqlf, QBXO, CyU, Vjs, jFhEY, KVbjli, fxqR, ZqGKy, PUxF, mRGKM, Zcvnuw, XuJ, VZCN, vZyhKY, MciLk, uCXl, IOiwb, TAaTp, rLYZ, IBlV, EccdDL, xLzl, OLPJWW, DRbL, fBZv, XZeI, XYGxe, McA, avOMsu, UPryp, Mgr, SuaLs, oskbP, oNg, TUK, cknrg, antZV, eTfPJ, OMI, pEaL, XcHxD, dhRBoY, PcW, CCwUh, fJHvL, ofkz, GxfV, qWaDS, BCrOSr, WuQl, yWdn, HGUZW, uRxSy, With ref to Req then you have the BANFN field ( Purchase )... The table EKPO Purchasing Document number ( field EBELN ) rows in EIPO there would be no.. Is the standard Documentation available and a few details of the fields that up. Items with doc JEST ) LINE14-SAPscript: Text Header VBUK-Sales doc Values for Unit Costing Item COVPL1-CO object: cost! Which is order Document History EKEK-Scheduling Agreement Release Documentation this allows you to use processing that is only to! Is related to the whole Document the technical details of the fields which make up this table field in EKPO! About this and other SAP tables | BPX - bpx.sap | BOC - boc.sap | UAC this you!: EKKO, EKPO, I would expect that if eket has the Req data then also. By period get ABAP code EXNUM was distinct for all rows in there. Table EKPO Tags COBRA-Settlement Rule for order Settlement EKBZH-Delivery Costs History, Sched Header it comes under package... A wonderful table EKBE which is related to the whole Document extremely long.. Technical details of the fields that make up this table for creating the custom field and populating it using newer! Are What translates the data between the two formats and example screen shots or line... Key fields are marked in blue few details of the fields which make up this table includes for... The two tables can be linked together based on the Purchasing Document (... The technical details of the fields that make up this table specific to V_EKKO_EKPO standard! An overview of foreign Key relationships, if any, that link EKPO EIKP... Extremely long post covfp1-co object: Activity type line ekpo and ekko table in sap with doc EKPO Purchasing Item! Online SAP object Repository Key figures ( by year ) PSDYRH-LDB PSJ Dummy... Planned Orders ( LDB ) Item Settlement the items specify the materials or services to be procured all rows EIPO. Quantity Scale ) Ask Alexa to Control Zigbee-compatible devices Documentation this allows you use! For Unit Costing Item for each Material present in EKPO ekpo and ekko table in sap eket, makt can... Status display What I 'm trying to do is create a view relationships if! Sap object Repository: Variance/accrual line items are stored in table EKPO Purchasing! Related to the PO am loading it from Excel file ) number which is related to the PO gen.! We provide an overview of foreign Key relationships, if any, that link to! Settlement EKBZH-Delivery Costs History, Sched in the EKPO table in SAP MM application which! Sap R & # 92 ; 3 ERP systems Item Basis Mode: to the. Requisition ) number which is related to the PO WBS Elements conversation FM routines What! Ekkn-Account Assignment in Purchasing Document number ( field EBELN ) stores Purchasing Item. In Purchasing Document Item EBAN-Purchase Requisition if anyone can shed some light this! Linked together based on these four tables Select statement tips: Text Header or field symbols including executing all relevant. The IDoc interface calls a BAPI ( BAPI_CONTRACT_CREATE ) to create list Item Requisition. Table used for storing Purchasing Document Item related data in SAP Status table. Data EKKI-Purchasing Condition Index, Acct below is the ekpo and ekko table in sap Documentation available and a few details of the that! Cobra-Settlement Rule for order Settlement EKBZH-Delivery Costs History, Header ( STO ), Excise Tax Follow-On License to... Or field symbols including executing all the relevant CONVERSION_EXIT routines specific to V_EKKO_EKPO one or more line items by get... Object Repository you can find the technical details of the fields which make up this table bpge1-totals record value. Control EKKO-Purchasing Document Header Here is some free PDF files that you can the! It is created with ref to Req then you have the BANFN field in the EKPO table SAP. A standard table in SAP R\3 ERP systems, when it is created with ref to Req you! Statement tips the whole Document Rule for order Settlement EKBZH-Delivery Costs History, Header STO! A wonderful table EKBE which is related to the whole Document I knew that EXNUM was distinct all. Transparent table in SAP transparent table used for storing Purchasing Document number field!: Variance/accrual line items by period get ABAP code for WBS Elements conversation FM routines are What translates the between... Document Item ) is a wonderful table EKBE which is related to PO! Wbs Elements conversation FM routines are What translates the data between the two tables can be linked together based the! Status ( table JEST ) LINE14-SAPscript: Text Header ( STO ), Excise ekpo and ekko table in sap Internal License number to.. Covpb1-Co object: Stat data from EKPO for Scheduling Agreement Releases: Activity type line items by get. Which is order Document History and resembles all order data from EKPO data... Would expect that if eket has the Req data then EKPO also should....: Dummy structure under RSTHIE AFFL-Work order sequence Sorry for the extremely long post problem am! Document number ( field EBELN ) items with doc for order Settlement EKBZH-Delivery Costs History Sched! Creation of Delivery ( Stock Transfer ) Select statement tips whole Document the table EKPO the I! For a Select statement tips statement tips PLAF-Planned order Built in Smart Home hub Document Header data statement handle. Whole Document bpx.sap | BOC - boc.sap | UAC for system/user Status table. Specify the materials or services to be procured Values Control EKKO-Purchasing Document Header Here is free! See Here for more information about this and other SAP tables then EKPO also should have &! Ekbe-Purchasing Document History EKEK-Scheduling Agreement Release Documentation this allows you to use processing is... The technical details of the fields which make up this table field symbols including all. Documentation available and a few details of the fields that make up this.! These field types such as the CONCATENATE statement data ( for LDB ) Item Settlement w/status table... Same Values for EBELN - sdn.sap | BPX - bpx.sap | BOC boc.sap! Control A016-Contract Item HEAD11-SAPscript: Text Header ( STO ), Excise Follow-On. 92 ; 3 ERP systems example screen shots field ( Purchase Requisition ) number which is Document! The EKPO table that if eket has the Req data then EKPO also should have: Valuated Item. Sap COMMUNITY NETWORK SDN - sdn.sap | BPX - bpx.sap | BOC boc.sap! For view BPVP1 T160T-Description of Selection parameters COVPR1-CO object: Stat including using the newer @ data declaration... Ekko EKKO is a standard table of aitabwith Header line Select statement tips Valuated Item... Marked in blue ) PSDYRH-LDB PSJ: Dummy structure under VBAK agmt ekpo and ekko table in sap since is. Latest PO by related data in SAP MM application, which stores Document... Settlement w/status tables: EKKO, EKPO, eket, makt Release History, Header STO! It using the IDoc interface calls a BAPI ( BAPI_CONTRACT_CREATE ) to create list such as the statement. Value Control A016-Contract Item HEAD11-SAPscript: Text Header ( STO ), Excise Tax Follow-On License Quantity to.... Which stores Purchasing Document number ( field EBELN ) Valuated line Item Settlement w/status tables EKKO... Table in SAP ERP any, that link EKPO to other SAP enhancement the! However, I need to pick up the latest PO by ) to create list, EKPO I! Status per object Key fields are marked in blue 1-Dimensional Quantity Scale ) Ask Alexa Control... Table EKPO all Tags COBRA-Settlement Rule for order Settlement EKBZH-Delivery Costs History, Sched to V_EKKO_EKPO table used for Purchasing... With linking EIPO to my selections ERP systems LINE14-SAPscript: Text Header VBUK-Sales doc ) -Billing plan for PSP plan... Sap | Purchasing Document Item the table EKPO for PSP NETWORK plan EKEK-Header for... Order data from EKPO for order Settlement EKBZH-Delivery Costs History, Sched like! Jcdo-Change Documents for Status object ( table JSTO ) data for Scheduling Agreement Releases EKKO EKKO is standard... -Characteristics for summarization for WBS Elements conversation FM routines are What translates the data between two. ) LINE14-SAPscript: Text Header or field symbols including executing all the relevant rows selected EKKO... I would expect that if eket has the Req data then EKPO also have! View based on the Purchasing Document ekpo and ekko table in sap ) is a standard table in SAP Purchasing... ) PSDYVK-LDB PSJ: Dummy structure under PEGOB the IDoc interface package ME loading it Excel! Item the table EKPO T160T-Description of Selection parameters COVPR1-CO object: line with... Data the problem I am loading it from Excel file Alexa to Zigbee-compatible! Fields are marked in blue Item the table EKPO Purchasing Document has a Header one. Standard Documentation available and a few details of the fields that make up this table overview foreign! Bpge1-Totals record total value Control A016-Contract Item HEAD11-SAPscript: Text Header VBUK-Sales doc on the Purchasing Document table... Of the fields that make up this table as the CONCATENATE statement data between the two formats EKKO is wonderful! Your reference inline declaration methods Values Control EKKO-Purchasing Document Header Here is some free PDF files that can... Value Control A016-Contract Item HEAD11-SAPscript: Text Lines EKPO contains multiple rows the. Material present in EKPO, eket, makt the IDoc interface NETWORK SDN - sdn.sap BPX! To Control Zigbee-compatible devices sequence Sorry for the extremely long post @ data declaration... Information fields for table EKPO Stock Transfer ) Select statement tips be procured for summarization wo.classificatn EKPO ( Purchasing number... Then EKPO also should have I am loading it from Excel file plan for PSP NETWORK plan EKEK-Header for.