Discover the world with our lifehacks

What is info record table in SAP?

What is info record table in SAP?

EINA (Purchasing Info Record: General Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue. Additionally we provide an overview of foreign key relationships, if any, that link EINA to other SAP tables.

How do I view table details in SAP?

Go to T-code se11. Enter table name ZSI_CHECK_TABLE….The data element of primary key table and foreign key table must be same.

  1. Double click on data element, and again double click on domain the below screen will visible.
  2. select value range tab.
  3. provide fixed values and short description as per requirement.

How do I view an information record in SAP?

Step 1)

  1. Enter transaction ME11 in command prompt.
  2. Key for creating the info record is Vendor/Material combination. You can enter purchasing organization and/or Plant.
  3. You have to choose an info category for desired procurement type. Press ENTER to proceed to the next screen.

What is Eine table in SAP?

EINE is a standard Purchasing Transparent Table in SAP MM application, which stores Purchasing Info Record: Purchasing Organization Data data.

What are the different info record types?

Standard − Standard info record has information on standard orders (orders include details of vendor and material). This info record will include vendors price for supplying the particular material. Subcontracting − Subcontracting info record has information on subcontract orders.

What is the use of PIR in SAP MM?

Serves as a source of information for Purchasing. The purchasing info record (also referred to in abbreviated form as the “info record”) contains information on a specific material and a vendor supplying the material. For example, the vendor’s current pricing is stored in the info record.

What is SE16N used for?

The SAP TCode SE16N is used for the task : General Table Display. The TCode belongs to the WUSL package.

How do I list all tables in SAP?

Use t-code SE16 and click f4 on table name, then click on info system and put * in table name. Don’t have access to SAP at the moment, but I believe that the table which contains a list of the tables is DD02T. Use SE16 to look at the table.

What is the use of info record?

The info record contains quotation and ordering data. The data in the info record (prices for example) is also used as default data for purchase orders. For instance, you can store the current and future quotation conditions (discounts, fixed costs etc.) in the info record, in order to be able to copy them into Pos.

What is the TCode for info record?

SAP Info Record Transaction Codes

# TCODE Description
1 ME11 Create Purchasing info record
2 ME12 Change Purchasing info record
3 ME13 Display Purchasing info record
4 ME1M info records per Material

How do you use Mara tables in SAP?

You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition….SAP Table: MARA – General Material Data

  1. Logistics – General.
  2. Logistics Basic Data.
  3. Material Master.
  4. MARA.

What is the use of source list in SAP MM?

The source list is used in the administration of sources of supply. It specifies the allowed (and disallowed) sources of a material for a certain plant within a predefined period. Each source is defined by means of a source list record.

SAP Info Record Table, Tcodes and Report regroup all the important elements you need to know when you deal with Purchasing Info Record. 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.

What are the SAP user name tables and fields?

For example, if you want to retrieve the SAP user Name, use the table ADRP. The ADRP-NAME_FIRST and ADRP-NAME_LAST store the first name and the last name of the SAP user. Hence T=the full SAP user name can be found in the ADRP-NAME_TEXT. So SAP user Name Tables and Fields are: ADRP-NAME_FIRST: First name. ADRP-NAME_LAST: Last Name.

What are the sap address tables?

The main list of SAP Address Tables are: SAP ADDRESS TABLE DESCRIPTION ADR3 Fax Numbers (Business Address Services) ADR6 E-Mail Addresses (Business Address Servi ADR7 Remote Mail Addresses ( SAP – Communicat ADR8 X.400 Numbers (Business Address Services

How to get a list of all tables in SAP?

The easy way to get a list is to use SAP’s ‘Application Hierarchy’, transaction SE81 (select all HR modes in the tree that you are want a list of tables for, click on the ‘Information System’ button, under Abap Dictionary –> Basic Objs, double click on ‘database tables’, increase your ‘maximun no. of hits’ and execute).