
Sap Material Table Name Code Field In
In the following screenshot, you see that I hovered over the Customer code field in A/R invoice, and if check the bottom tab you may see that the. And check the bottom tab to view the String Info, Table, and Column codes. Know hover over on any document in SAP Business One such A/R Invoice, Journal Entries, Business Partner Master Data.
Configure SAP Material ListingLook up in table mara or when you display it using mm03 it will be at the top in the information bar. For the purpose of this tutorial, we will limit our discussion to material listing functionality. When checking a sales order, SAP checks for material exclusions first, then proceeds to check the material listing table. For this, a material exclusion may be maintained for each customer. For example, a chemical production company may have a set of customers who are legally ineligible to purchase volatile chemicals.
Sap Material Table Name Full Program Example
Select Activate Listing/Exclusion ActivityAssign the standard material listing procedure A00001 to the relevant sales document types as shown below:Hit Enter then Save. Material Extension Full Program Example in SAP ABAP.To configure material determination use the customizing path below in transaction code SPRO:Sales and Distribution – Basic Functions – Listing/ExclusionSelect the first activity from the list: Activate listing/exclusion by sales document type. First we will list the main Table for purchasing Info Record, then the list of important Infot record transaction code and finally, you will find the standard report for info Record.Check for the available structure BAPITE
These combinations are customizable. Select the radial button next to the key combination that relates to the way you want to maintain the material listing. We will walk through these steps in the following sections.Create Material Listing Master Record Menu pathLogistics > Sales and Distribution > Master Data > Products > Listing/Exclusion > CreateEnter the listing type A001 as shown below:Press Enter to continue. Then, the sales order can be created and the material list is produced.

Since the entered materials are part of the material listing, the system accepts them with no error message:Now let’s try to enter a material which was not part of our listing. In our example, we enter a line for each of our two listed material numbers, 5006575701, with a requested delivery date of as shown below:Once all data is entered, hit Enter to trigger the material listing. First, let’s see what happens when listed materials are entered. Enter all the details for the sales order, taking care to use the customer you created the listing for and a delivery date that falls within the range you set up in the master data. In our example, we use ZDEM as shown below:Hit Enter to proceed to enter sales order data.
Hit Enter then Save to post the sales order. The system produces an error that the material is not listed for the customer as indicated below:To process the sales order further, remove the material which is not included in the listing.
