How to display all purchase order line items with their status whether they are blocked or unblocked.? As i am an abap'er and i have to develop a code report for the above scenario.
So all experts please provide me with some guidelines. There is a field called blocked reason in EKPO table. Based on that field values you can fetch the line item details.
Can you please provide me some sample code to display the purchase order with their status. Some name 8. Tech Sign In Page. Forgot Password? Don't have an account? Sign up. Hi, How to display all purchase order line items with their status whether they are blocked or unblocked.?
Follow Tech Sign In Page. Mahesh Ubale. January 30, AM. Something went wrong on our end. Please try again later.
SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables
Regards, Jyotsna. Hope this works. Regards, Suresh. Thanks Experts. Sign In to Post a Comment. Sign In. Hide Comments View Comments. Looking for more? Search the archive of solutions and how-to's. Ask a new question to a community of peers. Mass Activation of Assets in Company Code. Bill to Address Modification.Questions: First: Are there any problem if we use Delivery schedule without use Scheduling agreement???
You can use the 'delivery schedule TAB' to communicate the 'multiple delivery date' to the vendor. No problem as long as your vendor 'translate the PO details' as you want.
But in the PO output you can specify as you want. That's true? In PO, I created one line item with qty. When you create a PO, the price from info. So you can't achieve it. Enterprise Software. Tech Sign In Page. Forgot Password? Don't have an account? Sign up. Thanks a lot. Hi, when you says Delivery Schedule, are you means ME38? March 24, PM. Something went wrong on our end. Please try again later. Hi, so it is Delivery Schedule tab at Line Item.
Eduardo, You can use the 'delivery schedule TAB' to communicate the 'multiple delivery date' to the vendor. Hope it helps you March 25, PM. Espinosa, E. How can I acheive this? March 28, AM. I think its not possible on single line item. Use multiple line items or separate PO. PM, When you create a PO, the price from info.Does SAP have this functionality? You can enter this transaction ME2M and put the in the Selection parameters field WE and put in the Delivery date field the date you want and leave the material plank and press execute.
You will fild the purchase orders still opened according to the delivery date you put. Thanks Mosab, but the output from ME2M doesn't include the delivery date. While it is good to see what orders are open, I also want to be able to see the delivery dates for the open orders.
SAP Purchase Order tables
This helps when providing open order reports to our customers so that they can better understand our current supply chain. Is the only way to get the delivery date by opening the purchase order? This is very time consuming when you have hundreds of open orders. I had the same problem, I don't know any SAP standard report which is user friendly. For this reason I created a query consisting of the tables ekpo, ekko and ekbe. Then I get the information I need.
We have two variants of this - one is just for materials and also includes table MARC to get material master planning data e. Go to ME2N and execute that report and next click on delivery schedule.
It shows you line by line schedules. Enter a material number if you want to look it up by material number 2. Change the scope of list to? Everything no changes docs? Selection parameters to? Open goods receipt? You can leave in? Enter the plant that you are dealing with we will use?????? Put in your delivery dates range 6. For best result enter Material Group????? This transaction doesn't give you part numbers only P.How to Default the Values in Purchase order at Header and Item level -SAP MM BAsic Videos
Some name. Tech Sign In Page. Forgot Password? Don't have an account? Sign up. Follow Tech Sign In Page. The SAP do this function. June 04, AM. Something went wrong on our end.Our operation is facing problems with the vendors' delayed deliveries. Hence, our management would like to implement penalty system for these delays. At the moment, our current practice is to update the Delivery Date in the Line Item whenever our vendor informs us on any delay in deliveries.
This change is then reflected in the Item Changes record. You can make the necessary update of both quantity and delivery date using the standard functionality of "Vendor confirmation". Thanks to the configuration setting of confirmation control key, you can build the list of confirmation category keys you are going to use for updating your shipment status. U can check changes in P.
O via header level and line iteam level. To generate the urging letter, you should run Transaction ME92F.
If you're looking for PO change history, any of the standard PO reports can show you that. What's nice about it is that you can double click any of the PO's and get to the display ME23N directly. If you have change capability, you can switch to change mode, make changes, save, and return to the original list. It is very useful - we have used it for years. Regards, SOP Enterprise Software.
Tech Sign In Page. Forgot Password? Don't have an account? Sign up. Delivery Date. Is there any standard SAP report that I may use? Any advice and opinion is very appreciated.Can anyone please tell me what table the delivery address is stored on the PO line item delivery address tab? If the person entering the purchase order manually inputs a new delivery address for the PO item on the delivery address tab, where is this address stored?
I was expecting there to be an address number on ekpo, then i could look up the address in ADRC This can then be used as the key in the ADRC table. For master data addresses detais can be added via transaction MEAN and would have a key of ME01 delivery address master data against the record.
Hello, I have the same question. It is displayed on the screen but all the above fields are blank. Enterprise Software. Tech Sign In Page. Forgot Password? Don't have an account? Sign up. Follow Tech Sign In Page. In SE16 can you see a value in this field? Regards, Martin. Martin Blood. October 14, AM. Something went wrong on our end. Please try again later. Holly Grasch. November 19, AM. Sign In to Post a Comment. Sign In. Hide Comments View Comments. Looking for more? Search the archive of solutions and how-to's.
Ask a new question to a community of peers. Mainframes, DevOps, and Ansible.That should not be surprising considering that users will be confronted by no less than 10 date fields during normal order maintenance.
That number can rise to more than 15 depending on how you slice the numbers. In this article, I will explore these date fields and how they impact other activities.
Read on for more on Sales Document Date Fields. Since sales document date fields appear on all three layers of the Sales Order — Header, Item, and Schedule Line — and since there is a lot of overlap between many of these fields, it makes sense to organize this discussion by function.
The Created On date is the date that the sales order was saved to the database. Not much else to say on that one. The primary function of this date is to control when a sales document appears in management reports. Typically this date is set to the Creation date. The PO fields are typically some of the first fields entered during order entry.
PO Date fields exist at both the header and item levels. In most cases, SAP will still expect you to have a PO number and date on the header, but you can change the item-level dates on the Item OverviewSalesor Procurement tabs. Traditionally, the PO date will correspond to the date that the customer created the PO in their system. You input the date and SAP saves it. In any event, the user can manually overwrite the default pricing date on the order.
This, however, should probably be discouraged unless a valid reason exists for making this sort of manual change. The Pricing Date is automatically adopted by the invoice in the billing process.
In most cases, this should default to the current date, but controls exist to change that proposal. This is located on the order type configuration screen in the IMG. As each item is entered, the ATP process will run to see whether or not the date can be met. If so, the single schedule line is confirmed. If not, then secondary schedule lines are created with dates on which the product CAN be confirmed.
These proposed dates are dependent upon several factors. It is possible for SAP to determine several additional schedule line dates.
In this example, you would see three separate schedule lines with three different dates. This value simply corresponds to the first schedule line date for the item. As you may have guessed, changing the First Date value on the main sales screen will just change that schedule line date.
Nothing too magical. You can double-click a schedule line to pull up the schedule line details. The Shipping tab reveals some additional dates used for logistics planning. These dates and times all deal with lead times for the performing of specific shipping tasks.
A basic example would be a trucking company that requires at least 5 days notice before committing to a pick-up. This is the date on which picking should begin in order to meet the subsequent deadlines.
The amount of loading time can be determined from a combination of the Shipping Point configuration, the Loading Group of the material, and the Route. Since the route is a major input to this date, SAP will assume zero lead time if a route is not specified. The Goods Issue Date is the date on which the goods must physically leave the shipping point. This primarily takes into consideration the customer requested delivery date and the transit time required for the delivery. The latter of which is dependent upon the route.
If no route is determined on the sales order, SAP assumes zero transit time. Lastly, you arrive at the Delivery Date.They have a high data density and therefore convey an immediate feeling of complexity.
Try the following instead:. It supports touch devices, but is not optimized for small screens. This renders less white space for each item. Note that the condensed content density has always to be set in addition to compact. Do not use condensed on its own. Do not mix condensed with cozy. Furthermore, condensed mode is not available for Internet Explorer 9. If condensed mode is to be used, please provide a fallback. For more information on cozy and compact modes, see content density.
The column header provides the label for the corresponding column and access to the column header menu. TreeTable, property: enableColumnReordering. TreeTable, property: rowHeight. In rare casesshow actions within the line item. An exception to this is if the action trigger belongs to a link. Each cell provides one data point. It can contain one of the following controls to display the data point:. While it is technically possible to also use other controls, doing so could lead to issues in regards to alignment, condensed mode, screen reader support, and keyboard support.
Text, property: wrapping, value: false. A tree cell is a cell inside the tree column.