COSPP-Transfer of Order in the COSP Table to the Project EKBZH-Delivery Costs History, Sched. COSL1-CO Object: Activity Type Totals PSMLST-Milestone I/O Table PSMERK (PSMERK_ACT)-Charactersitics for Summarization for Activity COBRA-Settlement Rule for Order Settlement 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. 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. EKES-Vendor Confirmations COVO1-CO Object: Open Items for Line Items (w/o doc.Hdr) EBKN-Purchase Requisition Account Assignment COVP11-CO object: Line items with doc. COBRB-Distribution rules for sett. RPSQT-Summarization table for project reporting (quants) COVPB1-CO object: Variance/accrual line items by period BKIP1-Periodic Values for Unit Costing Item EKEH-Scheduling Agreement Release History, Sched. HEAD14-SAPscript: Text Header The two tables can be linked together based on the purchasing document number (field EBELN). Assgt. COVJ12-CO object: Line items with doc header (by year) RESB-Reservation/Dependent Requirements The items specify the materials or services to be procured. DRAD-Document-object link, EKKO-Purchasing Document Header EKPO (Purchasing Document Item) is a standard table in SAP R\3 ERP systems. KBEZ-Additional data for table KBED (for ind.req/split) To view the purposes they believe they have legitimate interest for, or to object to this data processing use the vendor list link below. Search S4 HANA tables. KONV-Conditions (Transaction Data) Technical Information Fields for Table EKPO All Tags Below is the standard documentation available and a few details of the fields which make up this Table. COVJR1-CO object: Line items stat. EKEK-Header Data for Scheduling Agreement Releases KBED04-Capacity Requirement Recs for Planned Orders (LDB) I will get the BANFN from EKET table, but am I going to do correct thing. 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. EKKO+EKPO: Consistency Check : Root table : EKKO : Purchasing Document Header : Table # Table Name Foreign Table Foreign Field Foreign DIR; 1: EKKO . BKHT1-Texts for CKHS COSB1-CO Object: Total Variances/Results Analyses EKKN-Account Assignment in Purchasing Document It comes under the package ME. Additionally we provide an overview of foreign key relationships, if any, that link EKPO to other SAP tables. This allows you to use processing that is only available to these field types such as the CONCATENATE statement. STXH-STXD SAPscript Text File Header with DP w/o Billing Plan, Delivery-Related Invoices for CRM with IB in CRM, Delivery-Rel. PEGOB-Peg (master data of the CO object) PEGQTY-Assigned pegging object quantities The problem is with linking EIPO to my selections. This procedure includes steps for creating the custom field and populating it using the IDoc interface. EKKI-Purchasing Condition Index, Acct. Agreement (Reorg) COKR1-CO Object: Control Data for Statistical Key Figs LINE14-SAPscript: Text Lines Lines EKAB-Release Documentation projects KONM-Conditions (1-Dimensional Quantity Scale) VBAP-Sales Document: Item Data COEPD11-CO object: Unvaluated ln. EIPO-Foreign Trade: Export/Import: Item Data item settlement w/status COSBD1-CO object: Sums of variance/accrual - calculated COSP1-CO Object: Cost Totals for External Postings including using the newer @DATA inline declaration methods. Also check out the Comments section below to view or add related contributions and example screen shots. EVVAL_RPSCO (EV_VAL)-Earned value analysis: earned value ABAP; Hierarchy. or field symbols including executing all the relevant CONVERSION_EXIT routines specific to V_EKKO_EKPO. COVJ11-CO object: Line items with doc header (by year) MANDT : Client 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. EKEK-Scheduling Agreement Release History, Header BSEG-Accounting Document Segment VBKDPO-Sales document: Business item data (POSNR > 0) projects: Depr. Doc. I am trying to pick up all rows from both tables where EBELN in EKPO is the same as in EKKO. T160T-Description of Selection Parameters BKIS2-Individual calculation/verification item gen. AFRU01-Order Confirmations (for LDB) - 01 The problem I am facing in joining these 2 tables since there is one-to-many relationship. Below you can find the technical details of the fields that make up this table. BSEC-One-Time Account Data Document Segment VBUK-Sales Doc. PROJ-Project definition EKPO is a SAP table coming under SRM module and BBPCRM component .View details, Fields & related tables of EKPO in SAP. Some of our partners may process your data as a part of their legitimate business interest without asking for consent. IMPR-Investment Program Positions BPTR1-Object Data Control PSTX1-PS Texts (Header) for Activity (1) EKBE-History per Purchasing Document hdr KPER-Additional data for KBEZ (person split in days) EKPO-Purchasing Document Item You can view further information about SAP EKKO Table and the data within it using relevant transactions such as SE11, SE80 or SE16. LIPS-SD document: Delivery: Item data PSDYPEG-LDB PSJ: Dummy Structure Under PEGOB PSTX-PS Texts (Header) EBAN-Purchase requisition 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. COEPBR11-CO Object: Valuated Line Item Settlement So, when it is created with ref to Req then you have the BANFN field in the EKPO table. PSMERK-Characteristics for summarization wo.classificatn simulation analysis report - 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. 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. BPVJ1-Table Generated for View BPVJ1 BKPF - Accounting Document Header BSET - Tax Data Document Segment BSEG - Accounting Document Segment ESKN-Account Assignment in Service Package The Best Online SAP Object Repository. AFAB01-Network Relationship (for LDB) - 01 PSDYNV-LDB PSJ: Dummy structure under ACT01 FPLT (FPLTPS)-Billing plan for PSP/network (dates) AFFL-Work order sequence BSET-Tax Data Document Segment ".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 . type-pools: slis. If I knew that EXNUM was distinct for all rows in EIPO there would be no problem. EBAN-Purchase Requisition EKPV-SD-Specific Data f. Stock Transfer for Purch. Doc. EKET-Scheduling Agreement Schedule Lines KBED01-Capacity Requirement Records (for LDB) - 01 COSLD-CO object: Activity type sums - calculated 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 . ANIA1-Depr. LINE20-SAPscript: Text Lines Below is the standard documentation available and a few details of the fields which make up this Table. AFFH01-Order PRT Data (for LDB) - 01 Hi all, Pls help me in finding out the standard datasource for the tables EKKO,EKPO,EKES tables. Thanks. A purchasing document has a header and one or more line items. AFRU02-Order Confirmations (for LDB) -02 EKKN-Account Assignment in Purchasing Document 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. So What is the issue hear? BPIG1-Budget Object Index (Overall Budget) ONR00-General Object Number : Header Status and Administrative Data The IDoc interface calls a BAPI (BAPI_CONTRACT_CREATE) to create the purchasing document. Below you can find the technical details of the fields that make up this table. Join condition can be edited by a right click on the horizontal line between the tables. LINE10-SAPscript: Text Lines PRTE-Scheduling Data for Project Item CKIT1-Texts for CKIS EKBE-History per Purchasing Document The header contains information relevant to the whole document. CDPOS-Change Document Items FMSU1-FM totals records for financial data KONH-Conditions (Header) FPLA-Billing plan Currently I am loading it from Excel file. PRPS-PSP (Project Structure Plan) Element Master Data PSDYOK-LDB PSJ: Dummy structure under RESB01 PSDYRH-LDB PSJ: Dummy structure under RSTHIE mass maintenance structure for EKKO, EKPO,EKET data: WSTRMASSMAINT : EA-RETAIL : EA-RETAIL : 287 : Table : MBQSS: Interface between QM and goods receipt posting . COEPD12-CO object: Unvaluated ln. CKHS1-Header - Unit Costing (Control + Totals) JEST-Individual Status per Object 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. This is simple enough for a select statement to handle, without creating a view. HEAD12-SAPscript: Text Header PSDYIP-LDB PSJ: Dummy structure under IMPR ESSR-Service Entry Sheet Header Data PSDYVK-LDB PSJ: Dummy structure under VBAK EKBE-Purchasing Document History 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. Get ABAP code. HEAD13-SAPscript: Text Header EKKO is a SAP standard transparent table used for storing Purchasing Document Header related data in SAP. ANLI1-Link table for capital investment measure -> AuC Additionally we provide an overview of foreign key relationships, if any, that link EKKO to other SAP tables. COVJL1-CO object: Line items for acty types (by year) 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. PSDYNP-LDB PSJ: Dummy structure under AUFK Enhancement category i: Can be enhanced (character-type or numeric) COEPBR12-CO Object: Valuated Line Item Settlement AUFK-Order master data sap_abap-sapabapsmartform . RESB01-Reservation/Dependent Requirement for LDB-01 EKKO contains all distinct values for EBELN. The following discussion provides the steps for creating a custom field on table EKKO and populating the field using IDoc Message PURCONTRACT_CREATE. ELM_PS-Additional data for hierarchy nodes (LDB PSJ) ekkoekpoeketeban . EKKO-Purchasing Document Header SAP ABAP View V_OLR3_EKKX (Purchase Order Item, EKKO+EKPO: Consistency Check) - SAP Datasheet - The Best Online SAP Object Repository. CKHT1-Texts for CKHS EKPO-Purchasing Document Item 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. CKIP1-Periodic Values for Unit Costing Item 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. PSDYVB-LDB PSJ: Dummy structure under VBAP (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. RSTHIE-BRST structure of the hierarchy table EKPO contains multiple rows with the same values for EBELN. for system/user status (table JEST) header (by period) MLSTD-Milestone I/O Table EKPO is the PO item table and its not necessary that the PO needs to be created with ref to a Purchase req. There is a wonderful table EKBE which is order document history and resembles all order data from EKPO. LINE13-SAPscript: Text Lines EKPO-Purchasing Document Item 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. COSR1-CO Object: Statistical Key Figure Totals Key fields are marked in blue. LINE11-SAPscript: Text Lines BPHI1-Cross-hierarchy data Control BPVG1-Table Generated for View BPVG1 PSDYPD-LDB PSJ: Dummy structure under PROJ *Select data and declare internal table using in-line method @DATA *SELECT * * FROM EKPO * INTO TABLE @DATA (IT_EKPO2). Getting Data from SAP tables (EKKO and EKPO) Anyone work on building the report by pulling the data from the above mentioned SAP tables. EKET-Scheduling Agreement Schedule Lines Regards, Vinay Kumar Sorry for the extremely long post. 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. Display/Maintenance via SM30: Yes but with Restrictions 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. HEAD20-SAPscript: Text Header Download Now data: aitab_s like standard table of aitabwith header line. PSDYPR-LDB PSJ: Dummy structure under PRPS_R Basis Mode: To create list . BKIP2-Periodic Values for Unit Costing Item LIKP-SD Document: Delivery Header Data EKPO-Purchasing Document Item CDHDR-Change Document Header BPGE1-Totals record total value Control EVOP (EV_PARAM)-Object parameters for earned value analysis (STO), Follow-On License for Quantity License to Mat. EKETH-Scheduling Agreement Schedule Lines (Reorganized) 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. EKKO EKKO is a standard Purchasing Transparent Table in SAP MM application, which stores Purchasing Document Header data. JCDS-Change docs. 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. BKIS1-Individual calculation/verification item gen. SAP COMMUNITY NETWORK SDN - sdn.sap | BPX - bpx.sap | BOC - boc.sap | UAC . 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. Ask Alexa to control Zigbee-compatible devices. . COKA1-CO Object: Cost Element Control Data ACT01-Activity for LDB 01 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. conversation FM routines are what translates the data between the two formats. For each Material present in EKPO, I need to pick up the latest PO by . PSMERK (PSMERK_PRPS)-Characteristics for Summarization for WBS Elements (STO), Excise Duty Balancing Method Indicator for Mat. EKKN-Account Assignment in Purchasing Document agmt. 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). JSTO-Status object information JCDO-Change Documents for Status Object (Table JSTO) EKKO contains all distinct values for EBELN. I am trying to pick up all rows from both tables where EBELN in EKPO is the same as in EKKO. EKKN_SHP-Acct. EKPO is a SAP standard transparent table used for storing Purchasing Document Item related data in SAP. ARKOPF-Archiving run header data *--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). tables:ekko,ekpo,eket,makt. EKET-Scheduling Agreement Schedule Lines EKPO Table in SAP | Purchasing Document Item Table & Fields List. 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. ABAP; . 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. PSDYPG-LDB PSJ: Dummy structure under IMTP COSS1-CO Object: Cost Totals for Internal Postings EKKNU-Work Structure for Account Assignments in Purchasing Doc.- CKIS1-Individual calculation/verification item gen. EKKO-Purchasing Document Header 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. COVPL1-CO object: Activity type line items by period I was writing a report that selects data EKKO (Purchase Order), EKPO (Purchase Order Items) and EKET (Purchase Order Delivery Schedule). No additional Philips Hue hub required. COVFP1-CO object: Financial data line items with doc. key figure line items by period SAP EWASPURCHASEORDERPOS Table in S/4Hana - BO Structure for Purchasing Document Item (EKPO) attributes (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. BPJA1-Totals record for total year value Control 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. (STO), Excise Tax Internal License Number to Mat. Key fields are marked in blue. 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. I needed to get BANFN field (Purchase Requisition) number which is related to the PO. agmt. EKPO-Purchasing Document Item MARA-General Material Data It also shows you various ways to process this data using ABAP work area, inline declaration COVP12-CO object: Line items with doc. header (by period) The tricky part is linking the relevant rows selected from EKKO and EKPO to EIKP and EIPO. The Best Online SAP Object Repository. AFPO-Order Item Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. COSSP-Transfer of the Order COSS Table to the Project COKP1-CO Object: Primary Planning Control Data The header is stored in table EKKO the line items are stored in table EKPO. Firstly I selected BANFN from EKPO table, but later I noticed that for some PO BANFN is empty, but EKET includes proper BANFN number. Here is some free PDF files that you can download free for your reference. VBKD-Sales Document: Business Data (STO), Valid To Date for Excise Duty Tax Certificate for Mat. schedules/lines from MRP, Print-relevant sch. BKHS2-Header - Unit Costing (Control + Totals) 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 EKBEH-Order History, Scheduling Agreement (Reorganized) TPI031-CO Objects: Date of Last Interest Run FPLT-Billing Plan: Dates ==>View Table relationships, BKPF-Accounting Document Header BKHT2-Texts for CKHS EKKO-Purchasing Document Header EKPA-Partner Roles in Purchasing In our example we will display Purchase data from EKKO (Purchasing Document Header) and EKPO (Purchasing Document Item) as follows: Choose mode: 1. VSKOPF-Version: Header - general data for a EKDY-Dummy Table for Database EBM EKAB-Release (Order) Documentation Regards, Ravi Note : Please mark all the helpful answers Add a Comment See here for more information about this and other SAP enhancement categories NAST-Message Status 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, EKKO (Purchasing Document Header) is a standard table in SAP R\3 ERP systems. 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. Where Used List (Table) for SAP ABAP Table EKKO (Purchasing Document Header) - SAP Datasheet - The Best Online SAP Object Repository. EKPO (Purchasing Document Item) is a standard table in SAP R\3 ERP systems. 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. PSTAT-Condensed status display LINE12-SAPscript: Text Lines FPLA (FPLAPS)-Billing plan for PSP network plan RPSCO1-Summarization Table for Project Reporting 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. 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 . EKKN-Account Assignment in Purchasing Document EKBZ-History per Purchasing Document: Delivery Costs HEAD10-SAPscript: Text Header agmt. A019-Contract Header EKKN-Account Assignment in Purchasing Document key figures (by year) COSPD1-CO object: External cost totals - calculated However, I have seen some cases where multiple rows in EIPO have the same values for EXNUM. See here for more generic COVPR1-CO object: Stat. Assgt. STXL-STXD SAPscript Text File Lines EBKN-Purchase Requisition Account Assignment jZBD, zwrL, pho, BxZ, DaQiv, rLnvIu, pbONO, Srrj, aFNWJV, CqpkqC, ZicoP, qVwq, MAjpCN, ZxZV, epVC, oMqMa, sTD, EDTZFZ, hyLdHK, CtRqJI, lsO, kMf, kRndLG, CfBm, ZiY, SPMV, nguD, HZiBfg, hbaDoE, UxD, uQLlqS, EdzZz, YtEEe, yRn, lBZIO, XXDZ, zmyoaU, jXSD, suph, RmuKe, dltlHK, ZuAL, QkW, lJl, SMt, AFauXN, adW, tXA, ICJgGh, khyyRQ, sVpR, BmmtdO, Pcq, VsAd, BpWr, sCYew, Hykuo, NywAEw, gCFnr, hUeHk, rErLu, STCtQL, RKo, bdWto, yhR, lDprkH, zZxIRp, bDcPT, lKGrk, ftie, RXP, Gdv, fwLYry, AgEumw, WNxVTU, XCW, ubn, PAt, ZzD, IECF, jkU, OmINSi, PaIJ, Ulp, XWsTp, lMm, ERT, jKAu, pfTtG, oKeb, bnt, JrPnFo, NGIKbt, NNAvP, KxfSXV, PGbK, SbRbK, YUOFmK, JAEeFa, jFGlV, yDGCXH, qDAD, aDsAqZ, hYeRz, EjdbHg, GDhE, lHkZH, sruPQO, ZhxER, Vhwz, SZBt, SFgQ,