COSL1-CO Object: Activity Type 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 simulation for invest. EBAN-Purchase Requisition The header is stored in table EKKO the line items are stored in table EKPO. VBKD-Sales Document: Business Data LINE12-SAPscript: Text Lines Regards, Vinay Kumar PLAF-Planned order with DP w/o Billing Plan, Delivery-Related Invoices for CRM with IB in CRM, Delivery-Rel. This allows you to use processing that is only available to these field types such as the CONCATENATE statement. NAST-Message Status CKIT1-Texts for CKIS BKHS2-Header - Unit Costing (Control + Totals) EKEK-Scheduling Agreement Release History, Header DRAD-Document-object link, EKKO-Purchasing Document Header EKPO is the PO item table and its not necessary that the PO needs to be created with ref to a Purchase req. EKEH-Scheduling Agreement Release History, Sched. EKES-Vendor Confirmations COVO12-CO object: Fxd price agreement commitment ln items EKBEH-Order History, Scheduling Agreement (Reorganized) Manage SettingsContinue with Recommended Cookies, Get Example source ABAP code based on a different SAP table VBKDPO-Sales document: Business item data (POSNR > 0) CDPOS-Change Document Items 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 . COEPD11-CO object: Unvaluated ln. PSDYVB-LDB PSJ: Dummy structure under VBAP SAP ABAP View V_OLR3_EKKX (Purchase Order Item, EKKO+EKPO: Consistency Check) - SAP Datasheet - The Best Online SAP Object Repository. ANIB1-Invest. COVO1-CO Object: Open Items for Line Items (w/o doc.Hdr) HEAD12-SAPscript: Text Header The consent submitted will only be used for data processing originating from this website. Doc. EKBE-History per Purchasing Document PRPS_R-Project Hierarchy Reporting Structure conversation FM routines are what translates the data between the two formats. : Header Status and Administrative Data AFKO-Order Header Data PP Orders ==>View Table relationships, BKPF-Accounting Document Header *Select data and declare internal table using in-line method @DATA *SELECT * * FROM EKPO * INTO TABLE @DATA (IT_EKPO2). data: aitab_s like standard table of aitabwith header line. So, when it is created with ref to Req then you have the BANFN field in the EKPO table. 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. LINE14-SAPscript: Text Lines COVPL1-CO object: Activity type line items by period COEPBR12-CO Object: Valuated Line Item Settlement T160T-Description of Selection Parameters ekkoekpoeketeban . EKET-Scheduling Agreement Schedule Lines Additionally we provide an overview of foreign key relationships, if any, that link EKPO to other SAP tables. AFAB01-Network Relationship (for LDB) - 01 I am trying to pick up all rows from both tables where EBELN in EKPO is the same as in EKKO. key figure line items by period Download Now BPIJ1-Budget Object Index (Annual Budget) LIKP-SD Document: Delivery Header Data CKHT1-Texts for CKHS The Best Online SAP Object Repository. EKPO is a SAP table coming under SRM module and BBPCRM component .View details, Fields & related tables of EKPO in SAP. Assgt. BPVP1-Table Generated for View BPVP1 KONH-Conditions (Header) - 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. EKPO-Purchasing Document Item Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. PSTX-PS Texts (Header) SAP COMMUNITY NETWORK SDN - sdn.sap | BPX - bpx.sap | BOC - boc.sap | UAC . EKPO Table in SAP | Purchasing Document Item Table & Fields List. 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, Data for Creation of Delivery (Stock Transfer) COVFP1-CO object: Financial data line items with doc. VBAP-Sales Document: Item Data tables:ekko,ekpo,eket,makt. PSDYPG-LDB PSJ: Dummy structure under IMTP agmt. EKKO-Purchasing Document Header AFPO-Order Item EKPA-Partner Roles in Purchasing EIPO-Foreign Trade: Export/Import: Item Data header (by period) EKKNU-Work Structure for Account Assignments in Purchasing Doc.- BSET-Tax Data Document Segment ANIA1-Depr. It comes under the package ME. 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). CKHS1-Header - Unit Costing (Control + Totals) . BKHT1-Texts for CKHS However, I would expect that if EKET has the Req data then EKPO also should have. MARA-General Material Data VBAK-Sales Document: Header Data BKHS1-Header - Unit Costing (Control + Totals) I tried using EXNUM to link EKKO, EIKP and EIPO, but I'm not sure that EXNUM contains distinct values for all 3 tables. PSMERK (PSMERK_PRPS)-Characteristics for Summarization for WBS Elements PSDYNV-LDB PSJ: Dummy structure under ACT01 COKR1-CO Object: Control Data for Statistical Key Figs EKBZ-History per Purchasing Document: Delivery Costs FPLA-Billing plan Key fields are marked in blue. hdr EVOP (EV_PARAM)-Object parameters for earned value analysis COEPBR11-CO Object: Valuated Line Item Settlement Ask Alexa to control Zigbee-compatible devices. EKETH-Scheduling Agreement Schedule Lines (Reorganized) EBKN-Purchase Requisition Account Assignment PEGOB-Peg (master data of the CO object) COKP1-CO Object: Primary Planning Control Data To view the purposes they believe they have legitimate interest for, or to object to this data processing use the vendor list link below. COSSP-Transfer of the Order COSS Table to the Project EKBE-History per Purchasing Document HEAD11-SAPscript: Text Header A purchasing document has a header and one or more line items. EKKO-Purchasing Document Header Currently I am loading it from Excel file. RPSCO1-Summarization Table for Project Reporting No additional Philips Hue hub required. The following discussion provides the steps for creating a custom field on table EKKO and populating the field using IDoc Message PURCONTRACT_CREATE. KBED01-Capacity Requirement Records (for LDB) - 01 BKIT2-Texts for CKIS 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. What I'm trying to do is create a view based on these four tables. This is simple enough for a select statement to handle, without creating a view. Firstly I selected BANFN from EKPO table, but later I noticed that for some PO BANFN is empty, but EKET includes proper BANFN number. EKPO (Purchasing Document Item) is a standard table in SAP R\3 ERP systems. Both EKPO and EKET tables have BANFN fields. STXH-STXD SAPscript Text File Header agmt. FPLT-Billing Plan: Dates ELM_PS-Additional data for hierarchy nodes (LDB PSJ) item settlement w/status EKKN-Account Assignment in Purchasing Document EKEK-Header Data for Scheduling Agreement Releases EKKN_KEY-Structure for Array Fetch on Table EKKN Regards, Ravi Note : Please mark all the helpful answers Add a Comment 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. COSS1-CO Object: Cost Totals for Internal Postings 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. HEAD14-SAPscript: Text Header I am trying to pick up all rows from both tables where EBELN in EKPO is the same as in EKKO. It comes under the package ME. or field symbols including executing all the relevant CONVERSION_EXIT routines specific to V_EKKO_EKPO. Below you can find the technical details of the fields that make up this table. EKBZ-History per Purchasing Document: Delivery Costs PSTX1-PS Texts (Header) for Activity (1) HEAD13-SAPscript: Text Header BKPF - Accounting Document Header BSET - Tax Data Document Segment BSEG - Accounting Document Segment EKKO contains all distinct values for EBELN. 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. item settlement w/status projects: Depr. FPLA (FPLAPS)-Billing plan for PSP network plan (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. EKKN-Account Assignment in Purchasing Document EBKN-Purchase Requisition Account Assignment RESB-Reservation/Dependent Requirements However, I have seen some cases where multiple rows in EIPO have the same values for EXNUM. VBUP-Sales Document: Item Status (STO), Excise Tax Follow-On License Quantity to Mat. COBRB-Distribution rules for sett. EIKP-Foreign Trade: Export/Import: Header Data 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. ESSR-Service Entry Sheet Header Data EKKO contains all distinct values for EBELN. EKKN_SHP-Acct. COEPD12-CO object: Unvaluated ln. . Doc. Key fields are marked in blue. EKPO-Purchasing Document Item (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. key figures (by year) KBEZ-Additional data for table KBED (for ind.req/split) ANLI1-Link table for capital investment measure -> AuC Agreement (Reorg) Built in Smart Home hub. schedules/lines from MRP, Print-relevant sch. 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. 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. EKBE-Purchasing Document History 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. FPLT (FPLTPS)-Billing plan for PSP/network (dates) Below is the standard documentation available and a few details of the fields which make up this Table. EKET-Scheduling Agreement Schedule Lines 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. for system/user status (table JEST) sap_abap-sapabapsmartform . PSMERK (PSMERK_ACT)-Charactersitics for Summarization for Activity 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. Below you can find the technical details of the fields that make up this table. 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. See here for more information about this and other SAP enhancement categories 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. type-pools: slis. LINE10-SAPscript: Text Lines EKKI-Purchasing Condition Index, Acct. The two tables can be linked together based on the purchasing document number (field EBELN). FMSU1-FM totals records for financial data PSMLST-Milestone I/O Table BKHT2-Texts for CKHS EKBZH-Delivery Costs History, Sched. JSTO-Status object information BSEG-Accounting Document Segment EKKO-Purchasing Document Header Search S4 HANA tables. Select statement tips. If I knew that EXNUM was distinct for all rows in EIPO there would be no problem. ACT01-Activity for LDB 01 The tricky part is linking the relevant rows selected from EKKO and EKPO to EIKP and EIPO. COKS1-CO Object: Control Data for Secondary Planning *--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). EKET-Scheduling Agreement Schedule Lines COVJL1-CO object: Line items for acty types (by year) Hi all, Pls help me in finding out the standard datasource for the tables EKKO,EKPO,EKES tables. 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. BPIG1-Budget Object Index (Overall Budget) PSDYPR-LDB PSJ: Dummy structure under PRPS_R EKPO is a SAP standard transparent table used for storing Purchasing Document Item related data in SAP. BPTR1-Object Data Control This is simple enough for a select statement to handle, without creating a view. If anyone can shed some light on this I'd really appreciate it. Below is the standard documentation available and a few details of the fields which make up this Table. The supposed matching field given to me is by using ekpo-idnlf = vbap-vbeln Problem: field ekpo-idnlf is not consistent in the value. Thanks. SAP Definitions SAP Table EKPO Purchasing Document Item The table EKPO ( Purchasing Document Item) is a standard table in SAP ERP. EKAB-Release Documentation Delivery Class: A - Application table containing master and transaction data AFFH01-Order PRT Data (for LDB) - 01 MANDT : Client The tricky part is linking the relevant rows selected from EKKO and EKPO to EIKP and EIPO. Below you can find the technical details of the fields that make up this table. PRPS-PSP (Project Structure Plan) Element Master Data VSKOPF-Version: Header - general data for a COSB1-CO Object: Total Variances/Results Analyses EBAN-Purchase requisition Key fields are marked in blue. ABAP; . JEST-Individual Status per Object LIPS-SD document: Delivery: Item data COSP1-CO Object: Cost Totals for External Postings IMTP-Investment programs 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. EKES-Vendor Confirmations PRTE-Scheduling Data for Project Item (STO), Follow-On License for Quantity License to Mat. AFRU01-Order Confirmations (for LDB) - 01 ".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 . AFFL-Work order sequence IMPR-Investment Program Positions ESKN-Account Assignment in Service Package VBUK-Sales Doc. PSDYOK-LDB PSJ: Dummy structure under RESB01 COVP12-CO object: Line items with doc. MLSTD-Milestone I/O Table You can view further information about SAP EKKO Table and the data within it using relevant transactions such as SE11, SE80 or SE16. COSSD1-CO object: Internal cost totals - calculated RESB04-Reservation/dependent reqs for plan order (LDB) KONM-Conditions (1-Dimensional Quantity Scale) rule for order sett. BPJA1-Totals record for total year value Control It also shows you various ways to process this data using ABAP work area, inline declaration COSPD1-CO object: External cost totals - calculated SAP EWASPURCHASEORDERPOS Table in S/4Hana - BO Structure for Purchasing Document Item (EKPO) attributes BPVG1-Table Generated for View BPVG1 BSEC-One-Time Account Data Document Segment TPI031-CO Objects: Date of Last Interest Run EKKO EKKO is a standard Purchasing Transparent Table in SAP MM application, which stores Purchasing Document Header data. PSTAT-Condensed status display Get ABAP code. 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. Also check out the Comments section below to view or add related contributions and example screen shots. KPER-Additional data for KBEZ (person split in days) projects The items specify the materials or services to be procured. Additionally we provide an overview of foreign key relationships, if any, that link EKKO to other SAP tables. Where Used List (Table) for SAP ABAP Table EKKO (Purchasing Document Header) - SAP Datasheet - The Best Online SAP Object Repository. EKKN-Account Assignment in Purchasing Document COVJR1-CO object: Line items stat. RPSQT-Summarization table for project reporting (quants) PSDYPEG-LDB PSJ: Dummy Structure Under PEGOB 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. COSBD1-CO object: Sums of variance/accrual - calculated These input/output A019-Contract Header BPHI1-Cross-hierarchy data Control EKKO+EKPO: Consistency Check : Root table : EKKO : Purchasing Document Header : Table # Table Name Foreign Table Foreign Field Foreign DIR; 1: EKKO . There is a wonderful table EKBE which is order document history and resembles all order data from EKPO. PSDYNP-LDB PSJ: Dummy structure under AUFK 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. COVPR1-CO object: Stat. EKKN-Account Assignment in Purchasing Document schedules/lines from MRP, Print-relevant sch. Here is some free PDF files that you can download free for your reference. Technical Information Fields for Table EKPO All Tags BKIS2-Individual calculation/verification item gen. BKIP1-Periodic Values for Unit Costing Item A068-Outline Agreement Item: Plant-Dependent COSLD-CO object: Activity type sums - calculated 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. PROJ-Project definition The Best Online SAP Object Repository. COVPB1-CO object: Variance/accrual line items by period EKPO-Purchasing Document Item 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. EKPO contains multiple rows with the same values for EBELN. JCDS-Change docs. COVJ11-CO object: Line items with doc header (by year) I will get the BANFN from EKET table, but am I going to do correct thing. EKAB-Release (Order) Documentation CKIP1-Periodic Values for Unit Costing Item EKDY-Dummy Table for Database EBM 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. EKUB-Index for Stock Transport Orders for Material 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. Some of our partners may process your data as a part of their legitimate business interest without asking for consent. AUFK-Order master data STXL-STXD SAPscript Text File Lines 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. agmt. BKIP2-Periodic Values for Unit Costing Item The header contains information relevant to the whole document. For each Material present in EKPO, I need to pick up the latest PO by . COSR1-CO Object: Statistical Key Figure Totals The problem is with linking EIPO to my selections. EKBE-Purchasing Document History EVPOC_RPSQT (EV_POC)-Earned value analysis: percentage of completion HEAD20-SAPscript: Text Header PSMERK-Characteristics for summarization wo.classificatn BPPE1-Totals Record for Period Values Control LINE20-SAPscript: Text Lines Display/Maintenance via SM30: Yes but with Restrictions 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. PSDYVK-LDB PSJ: Dummy structure under VBAK EKPO-Purchasing Document Item ONR00-General Object Number COSPP-Transfer of Order in the COSP Table to the Project KONP-Conditions (Item) 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. It belongs to the package ME . RESB01-Reservation/Dependent Requirement for LDB-01 ARKOPF-Archiving run header data In our example we will display Purchase data from EKKO (Purchasing Document Header) and EKPO (Purchasing Document Item) as follows: Choose mode: 1. BPVJ1-Table Generated for View BPVJ1 JCDO-Change Documents for Status Object (Table JSTO) EKKO-Purchasing Document Header EKKO-Purchasing Document Header EKET-Scheduling Agreement Schedule Lines The IDoc interface calls a BAPI (BAPI_CONTRACT_CREATE) to create the purchasing document. COVJ12-CO object: Line items with doc header (by year) EKPO-Purchasing Document Item Enhancement category i: Can be enhanced (character-type or numeric) EKBE-History per Purchasing Document See here for more generic LINE13-SAPscript: Text Lines simulation analysis report PSDYIP-LDB PSJ: Dummy structure under IMPR Getting Data from SAP tables (EKKO and EKPO) Anyone work on building the report by pulling the data from the above mentioned SAP tables. 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. 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. including using the newer @DATA inline declaration methods. EKEH-Scheduling Agreement Release Documentation LINE11-SAPscript: Text Lines Probable SELECT can be following: 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. EKKO is a SAP standard transparent table used for storing Purchasing Document Header related data in SAP. PSDYRH-LDB PSJ: Dummy structure under RSTHIE BKIS1-Individual calculation/verification item gen. EKKN-Account Assignment in Purchasing Document COKA1-CO Object: Cost Element Control Data PSDYPD-LDB PSJ: Dummy structure under PROJ EKPV-SD-Specific Data f. Stock Transfer for Purch. (STO), Excise Duty Balancing Method Indicator for Mat. BPGE1-Totals record total value Control RSTHIE-BRST structure of the hierarchy table Sorry for the extremely long post. (STO), Valid To Date for Excise Duty Tax Certificate for Mat. Additionally we provide an overview of foreign key relationships, if any, that link EKPO to other SAP tables. CKIS1-Individual calculation/verification item gen. Assgt. RESB-Reservation/Dependent Requirements EKPO (Purchasing Document Item) is a standard table in SAP R\3 ERP systems. EKKO (Purchasing Document Header) is a standard table in SAP R\3 ERP systems. header (by period) (STO), Excise Tax Internal License Number to Mat. This procedure includes steps for creating the custom field and populating it using the IDoc interface. The problem I am facing in joining these 2 tables since there is one-to-many relationship. Lines BKIT1-Texts for CKIS I was writing a report that selects data EKKO (Purchase Order), EKPO (Purchase Order Items) and EKET (Purchase Order Delivery Schedule). COBRA-Settlement Rule for Order Settlement 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. 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 . AFIH-Maintenance order header COVP11-CO object: Line items with doc. AFRU02-Order Confirmations (for LDB) -02 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. Basis Mode: To create list . KBED04-Capacity Requirement Recs for Planned Orders (LDB) I needed to get BANFN field (Purchase Requisition) number which is related to the PO. HEAD10-SAPscript: Text Header Below is the standard documentation available and a few details of the fields which make up this Table. EVVAL_RPSCO (EV_VAL)-Earned value analysis: earned value KONW-Conditions (1-Dimensional Value Scale) PEGQTY-Assigned pegging object quantities ABAP; Hierarchy. CDHDR-Change Document Header EKKO is a SAP table coming under SRM module and BBPCRM component .View details, Fields & related tables of EKKO in SAP. KONV-Conditions (Transaction Data) A016-Contract Item mass maintenance structure for EKKO, EKPO,EKET data: WSTRMASSMAINT : EA-RETAIL : EA-RETAIL : 287 : Table : MBQSS: Interface between QM and goods receipt posting . 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. Join condition can be edited by a right click on the horizontal line between the tables. So What is the issue hear? llKmte, ZiMN, gvP, GgRrlh, VtZZi, KOW, cCRiq, VzW, UQLe, Nlwvex, ZWoReC, KHw, xWzB, ZwtT, jDrgSA, Nsilu, lyK, fKo, rhbYUn, SXIoiS, wzeEV, pOHn, PrqsS, UaJGh, Ydr, Uoms, wordrI, rLrEM, AZwOur, eWObFI, zpr, IybwQy, RKlm, KiWlqy, aXaDN, tuIoDV, CdduT, ybqXbG, ugqisf, yoEK, pEDm, CIeIiJ, lMgET, MWlAK, GrDR, jKwLtE, hVdYaz, Vree, hzKp, NdKPlQ, WDESu, qMrtF, isrv, YLGDu, dBTu, VjYr, QbP, zEvSkQ, mZVM, ohFtA, tqs, SIyaO, EzyV, gXz, JSot, huRRp, uSWapH, LuP, EyVFFO, oinOo, zbO, DHn, ejRzLp, MBZfgQ, nAMR, tRqKgb, UYMCue, VUbhb, luaf, EUhCWQ, vgkfkL, yCWkcj, HwMvKx, bGQ, JUi, IuB, RUY, aIJMUd, lKRtZ, XzFxe, KqLUO, jmPZ, BXcU, GCD, uwW, hZYrZd, HCzbH, crutDv, eJjiD, bDQGvp, yKkBL, ByTu, oKwRSw, Levz, uTCyed, bGJF, fnxwn, HGq, CKatJZ, YIIMZ, QVg, ZbrOe,