To create a context, we start with ordinary tasks: as far as the database is concerned, these are stored in SAP® in the tables EKKO (command head) and EKPO (command position). If you want to track it, you can use z.B. the table browser SE16 to view the contents of the table. Orders to unlock value and quantity contracts are included in a separate table called EKAB. SAP® SE16 transaction can be used to display items. The screenshot below shows the release commands in the EAKB table, filtered by “our” quantity contract 46000000062 of the first example. A framework agreement can be of the following two types: Well, with the agreements, the foundations of a structured long-term supply are laid. But what about individual buying on the concrete basis of an agreement? We are also talking about call-offs. These are specific specific markets, in reference to the framework agreement. How you can determine these searches by analyzing the data, the tables in which they are recorded, and whether the information about goods and invoices is relevant or relevant in this context – this is something for the next post in the series. It`s a little more technical, but here, for the sake of completeness, a screenshot of the document type table with customizing settings in SAP® if they are needed for data analysis purposes. The circles of numbers for the corresponding types of proofs, z.B. Field selection parameters, etc., are included in this table: It`s now exciting (at least for data analysts): encoding agreements such as volume contracts, value contracts and delivery plans are not stored in their own tables, but also in the EKKO and EKPO tables.
So don`t get confused by names or take them too literally. Fig. 4 – Shared order document for a volume contract in the EKAB Data Model table – Orders and framework agreements Step 2 – Include the name of the creditor, the type of contract, the purchase organization, the buying group and the factory with the date of the contract. How do you see the difference between SAP® whether it is a normal order or a framework agreement – and, if so, what kind of agreement? Experienced SAP users® among you will of course cite the LaPi Site, which is quite true. Nevertheless, it is worth having a more detailed look. Step 4 – Indicate delivery date and target quantity. Click Save. The planning lines are now maintained for the delivery plan.