Sap Tables And Fields Description Pdf

When we need to maintain values for a custom table in a table maintenance generator, certain situations may arise where we need to automatically populate another field in a table depending on the value of one field. SAP Material Master Tables : MSTA - Material Master Status Tcode, ZMATERIAL_IDES - Material Master(IDES Demo) Tcode, J_1AINFMBW - Material Master - Inflation Tcode, T130Z - Use of material master views Tcode, MAEX - Material Master: Legal Control Tcode. Enter the term you are searching for in the Search For field. The list are categories by their functional modules. SAP MM Tables. ) 3 Navigational arrows Figure 3. Language key. Reports information about a database object (any object listed in sysobjects) and about system or user-defined datatypes, as well as computed columns and function-based indexes. Use the table below to provide the version number, the author implementing the version, the date of the version, the name of the person approving the version, the date that particular version was approved, and a brief description of the reason for creating the revised version. By default SAP does not add all the fields of KOMG to field catalogue. This new suite is built on our advanced in-memory platform, SAP HANA, and offers a personalized user experience with SAP Fiori. Link to download PDF document of SAP Note 2205846. Tables in CO Module Tables in FI Module. At the end of the document there are alphabetical and numerical listings of subjects and fields. The Material type is the highest level of categorization of material masters. The fields from these libraries are used in creation of a report. This new suite is built on our advanced in-memory platform, SAP HANA, and offers a personalized user experience with SAP Fiori. The existing DATA in the legacy system has to be manipulated in such a way that in becomes input for SAP. Selection fields: Table name. The Herbal Database is dedicated to the tea plant, Camellia sinensis, the source of commercial tea. Time 10 min Task Global Bike Inc. For mass correction refer to SAP Note 2127749. GRC is a SAP module coming under GRCFND_A component. 20 characters 50 characters Resource No. sap crm table relationship diagram. View complete list of tables & fields about Governance, Risk and Compliance. 5556 SAP Web Site. When we need to maintain values for a custom table in a table maintenance generator, certain situations may arise where we need to automatically populate another field in a table depending on the value of one field. Step 1 - Enter new table name Using transaction SE11, ensure the "Database table" radio button is selected and enter a name for your new table into the input box. No installation is required on your computer; you only need a connection to the internet to access SAP Fieldglass. For this example, fill in only the Title field, as shown in Figure 3. In the Name field, type in the name (or part of the name) followed by an asterix (*). Gardini (Table Description) SAP Field Name (Field Description) SAP Field Name (Field Description) Useful Fields Link Key One-to-One. The link is via the document number, field CHANGENR. The read modules reside on SLT system. 0 After workshop 2004-05-07 2. Now press enter or continue. Description. Reports information about a database object (any object listed in sysobjects) and about system or user-defined datatypes, as well as computed columns and function-based indexes. SAP ABAP Multiple Choice Questions and Answers pdf mcqs free SAP ABAP Multiple Choice Questions and Answers pdf Access the internal table fields within a. Local fields are new fields added to your existing reports in SAP. This list however, is not that extensive and some of the required SAP tables may not be listed in the Query Generator - Choose from list. There are 176 standard activities in SAP system in the ECC 6. What is the table name for G/L Master data, when we create centrally (T. For more information about the authorization function, see the online help for SAP Business One. 66 pages, E-book formats: EPUB, MOBI, PDF, online 2016-03, ISBN 978-1-4932-1398-6 From the book: Quality Management with SAP ERP Get the means to manage complaints and trace quality problems in SAP ERP with this E-Bite! Begin by configuring notification types and defining nonconformity costs. It looks for common elements that need further action, such as scanned text, form fields, tables, and images. This list however, is not that extensive and some of the required SAP tables may not be listed in the Query Generator - Choose from list. View complete list of tables & fields about Governance, Risk and Compliance. SAP R3 Tables - ABAP and Functional Modules Table A collection list of tables and their fields relationship which you are likely to used when you transact in the world of SAP. 70 exempt from levy. SD 1: Display Customer Master Record Exercise Use the SAP Easy Access Menu to display a customer. The definition shown now changes to Table_array. 20 characters 50 characters Resource No. If you want to create text table for any table, then just need to create table with the key fields of main table plus language key field (field of data type LANG) and a text field for the description. Internal tables are preferably used to store and format the content of database tables from within a program. SAP Pinnacle Awards 2019 Winner. Note: Your browser does not support JavaScript or it is turned off. List contains the table names with main field names and specific usage of that table. I added a filter criteria to each column – this allows you to search the Tcode descriptions for a particular word, for example, I searched for the word ‘asset’ to find all (well, not all, but almost 500) Tcodes related to Asset Accounting. For more detailed help, please see Additional Resources below. SAP has emphasized the product as pivotal to its cloud shift. You can run this action on all PDFs except dynamic forms (XFA documents) or portfolios. Note that we subsume Internet Application Components (IACs) and iViews (formerly called MiniApps) under the term Web. You can also display and create views of the tables in SE11. And click OK to run the report. Code - FS00)?. SAP Tips and Tricks: User Interface Shortcuts. After generating profiles, we change authorization data according to the requirement of security. View complete list of tables & fields about Governance, Risk and Compliance. It is very interesting. Identify Tables and Fields Names:. View the full list of Tables for Field Name. SAP PM Tables and related fields Made By: Deependra Shekhawat Email:[email protected] 'DBF': The column names are entered into the structure definition of the; DBF file. Furthermore, internal tables in connection with structures are an important means of defining complex data structures in an ABAP program. The SAP Support Portal page covering the SAP Support Knowledge Base Search (found in the SAP ONE Support Launchpad), My SAP Notes & KBAs, Guided Answers, Note Assistant, Important SAP Notes & KBAs and the Side-Effects of SAP Notes. E-Mail, ID, or Login Name. Total 2066 GRC tables are stored in our database. First we need to build a field catalog before displaying any output in the ALV. Provide a descriptive title for each reported period. If you use one or more of these fields in your BAPI you have to make two fields available for each of these fields in the BAPI interface: one field containing the SAP code and another containing its corresponding ISO code. Financial Accounting module helps one to get the real-time financial position of an enterprise in the market. Company Code. Appearance. SAP Employee number PA0001 PERNR Personnel number Value Table Reference Table/ Infotype Field Name Description Comments Inbound File Format SAP Data Source. SUPPLIER ADMINISTRATOR GUIDE 8 THE SAP FIELDGLASS APPLICATION Introduction SAP Fieldglass is a web-based application that runs from your internet browser. It looks for common elements that need further action, such as scanned text, form fields, tables, and images. CRMM_BUT_MIGRATE Migration Table: Fields. /BP Code field Move off the field to post a JE to a Control Account. On a PC, the icon name and keyboard shortcut are displayed when you place the mouse over the icon. It is usually one of the areas that are implemented in SAP, and often it goes in the same phase as all other Core Finance components: General Ledger, Accounts Payable, Accounts Receivable. By default SAP does not add all the fields of KOMG to field catalogue. This post contains frequently used transaction codes for Reporting in SAP Materials Management module. It is typically based on fields from tables that form the archiving object (we use standard field catalog SAP_BC_SBOOK01). 20 characters 50 characters Resource No. Sometimes the Command field is closed by default. A table can contain one or more fields, each defined with its data type and length. You will find a PDF for the list of SAP Tables. Detail Reference PDF material SAP System tables for Sales orders Name Description Uses LIKP. SAP ABAP Table Field RMCLM-KLBEZ (Class Description) - SAP Datasheet - The Best Online SAP Object Repository. Field name. This list however, is not that extensive and some of the required SAP tables may not be listed in the Query Generator - Choose from list. Page 1 of 7 Updated 21. Regardless of size, location, or industry, our solutions integrate seamlessly with existing systems and establish a framework for future requirements. Remember me ; Log On. Data Element Description. About related tables Related tables allow you to include fields from a number of SAP tables in your ACL table. from the report table, which you need for your Report Painter reports. You can edit the descriptions for each table by selecting the Description field and entering a new description. End User -GL Step by step training e. The wizard imports the definitions for the selected tables from the SAP application server, stores them in the SAP source module, and then displays the Summary and Import page. Entries in tables are grouped by Object Class (field OBJECTCLAS -- Change doc object). In my previous posts I have explained task list in sap pm and equipment task list. Want to know is there any single table which stores all the Technical field names used in SAP Vs Description of these fields? Like WERKS = PLANT. Date Approved. sap crm table relationship diagram. 39 Define Screen Layout at Document Level (Contracts) Menu path Implementation Guide for R/3. The Important tables of SAP FI tables as follows. Internal Tables D. To look for the table by its description in the Find field, double-click on the Description field title; this sorts the list alphabetically in an ascending order. The type of search varies from field to field. SAP Tips and Tricks: User Interface Shortcuts. Make sure the customer support is definitely there to aid you when you place Kids 3 Piece Rectangular Table And Chair Set By Fantasy Fields order with them. 5556 SAP Web Site. In an SAP System, ISO codes are currently supported for language, country, currency, and unit of measure fields. 2017 by Jan Durinda How to customize Business Partner screens and fields on SAP S/4HANA. TAB Upgrade code field based on name/description CTRL + TAB Move to the next field ignoring changes of the card name/item description in document. Just a list of tables that come in handy. This article teach you how to create SAP text table and assign to main table, text table have purposed to translated any description into several languages. In the pane, you’ll be able to rename the field and give it a description. In the beginning, you will find the main SAP SD Tables for Customer and Material Master Data. Dear SAP Community Member, In order to fully benefit from what the SAP Community Useful Tables - PM Module Functional Location Table. 2 2004-01-27 2. This is the basic transaction for understanding what you want to know. These relationships are displayed graphically as described below:. 20 characters 50 characters Business Partner Catalog No. SAP GUI Scripting API 620 9 Icons Icon Meaning Caution Example Note Recommendation Syntax Not supported in SAP GUI for Java Typographic Conventions Type Style Description Example text Words or characters that appear on the screen. Running Scripts There are 3 different ways to run a script: • A script may be double-clicked on the desktop. What is the table name for G/L Master data, when we create centrally (T. It is typically based on fields from tables that form the archiving object (we use standard field catalog SAP_BC_SBOOK01). ZSTSEARC: Attempt to locate C program calls SAP uses - report. By Madhavi. The table below ranks top online sap hana tutorial websites as well as online training and online hana courses. Once the report has run, click the drop-down. This new suite is built on our advanced in-memory platform, SAP HANA, and offers a personalized user experience with SAP Fiori. Tip: The table DDL03 has list of all fields used in a table. /BP Code field Move off the field to post a JE to a Control Account. The URL for each ABAP object is well formatted, and we can guess the location of your favorite object. Now that you know how to access the various transaction codes, it’s important to learn how to use the codes too. Also, when working in a SAP Business One on HANA system, the proper capitalization of the field name should be noted. In case of ITZ, use of Contracts and Scheduling agreements is very minimal so we have retained and used standard SAP document types Above linkage governs which type of PR can be referenced created while creating a particular Contract document type 1. SD 1: Display Customer Master Record Exercise Use the SAP Easy Access Menu to display a customer. Look up SAP terminology >. a "table join" function need to been used in order to read both tables "DD03L & DD04T". Old data is not lost when an infotype is updated. 00 ^page 1 ^field trans_date 2000-01-2 ^field description Description for item #2 ^field trans_type TYPE2 ^field trans_amount 11. Good Day everyone, I would like to know if there is a way, a function perhaps or anthing to retrieve the short description of a fieldname using only the fieldname itself w/o particularly knowing the , How to Retrieve the short description of a Fieldname using only the Fieldname, SAP Script ABAP Forum. SAP ECC not to be confused with SAP Business Suite. type, length, conversion exit). To begin your search, click on the link below. First we need to build a field catalog before displaying any output in the ALV. How to use this document? This document displays and describes the relationships and links between the various SAP database tables. A field name is always assigned directly to an input or output field and briefly describes the contents of this field. Important Tables in SAP FI & CO ( Controlling ) Its good to know about the important and frequently used tables in modules where we are working with. Transfer Structure RSTS Transfer Structure List RSTSFIELD Transfer Structure fields RSTSRULES Transfer Structure rules RSAROUTT Text name of Transfer Routine DD03T Text for R/3 Transfer structure Objects Update Rules RSUPDROUT Update rules List RSUPDDAT Update rules with routines RSUPDKEY Update rule key fields RSUPDINFO InfoProvider to Infosource correlation Embedded ABAP coding for Transfer…. Best regards, SAP Basis, ABAP Programming. Length of field. Consultancy for Customization and Configuration of SAP FI and MM at FBR enter information in the fields as specified in the table below: Field Name Description R. Adding long missing flexibility to SAP BW data models is essential and enabling agile data warehousing capabilities was also long overdue. Good Day everyone, I would like to know if there is a way, a function perhaps or anthing to retrieve the short description of a fieldname using only the fieldname itself w/o particularly knowing the , How to Retrieve the short description of a Fieldname using only the Fieldname, SAP Script ABAP Forum. By default SAP does not add all the fields of KOMG to field catalogue. 20 characters 50 characters User Code 8 characters 25 characters Mfr. I work with SAP NetWeaver (Release 730, Version 7300. You can set properties that apply formatting, determine how the form field information relates to other form fields, impose limitations on what the user can enter in the form field, trigger custom scripts, and so on. Description Optional table with column names for the individual columns. KEYBOARD SHORTCUTS Instead of an SAP icon button, you can use a keyboard shortcut. Financial Accounting module helps one to get the real-time financial position of an enterprise in the market. For more detailed help, please see Additional Resources below. Field names appear flat and in proportional typeface on the screen. ② If blinding is single or double, then the roles blinded must be specified. I think there's a way to do that using the SELECT statement. As which of the following join types does the text join act in this context? Please choose the correct answer. This is the area where SAP expects us to fill in the field names, their data types or data elements and also specify if this field is a key for the table or not. To use a transaction code, start by placing your cursor in the command line field. Similarly, there may be table for field description as well, is my opinion. The table array is the table of information containing the data we want to retrieve into our worksheet. Dear SAP Community Member, In order to fully benefit from what the SAP Community Useful Tables - PM Module Functional Location Table. - A field in the Material Master record used to store longer text description for the item Client - A grouping or combination of legal, organizational, business and/or administrative units with a common purpose; a self-contained unit in an SAP system with separate master records and its own set of tables ("The State of Louisiana"). I have to manually extract the data and run each report macro individually. Find SAP tables without table authorization group Hi people, another common finding of audits is, that not all (of your customer-) tables are assigned to a table authorization group — allowing everyone with S_TABU_DIS and DICBERCLS = "&NC&" to access them. From Sybase online documentation on the sp_help system procedure:. GRC is a SAP module coming under GRCFND_A component. sp_help is what you're looking for. The character font can set by the user and applies to all field names. How to Create and Maintain Info Objects Using Eclipse Data Modelling for SAP BW 7. And how do you run this code, in order to get to the “ ABAPer Telescope ” Blue screen where you can make all your entries regarding the “Tables, Fields, Modules. Views : - View is a logical table that extracts the data from table at run time. DD02L/T/V SAP Tables (se11) DD03L/T Table Fields (View: DD03VT) DD04L Data elements D020S/T Screen Short Description TSE05 ABAP Editor insert commands. As we need the table name, so remove the all tick without Table Fields. Also, when working in a SAP Business One on HANA system, the proper capitalization of the field name should be noted. The wizard imports the definitions for the selected tables from the SAP application server, stores them in the SAP source module, and then displays the Summary and Import page. org web site content is based on our knowledge of SAP system, and it is constantly reviewed to avoid errors; well we cannot warrant full correctness of all content. On a PC, the icon name and keyboard shortcut are displayed when you place the mouse over the icon. There can be various other. Short description. Which T-Code would you goto, and paste the ABAP code. SAP is no different. Provide short description, delivery class (A), Display Maintenance Allowed and select fields tab. This is the area where SAP expects us to fill in the field names, their data types or data elements and also specify if this field is a key for the table or not. SAP ABAP Table Field RMCLM-KLBEZ (Class Description) - SAP Datasheet - The Best Online SAP Object Repository. Stay on SAP Training Shop United States of America or choose another country or region. Sometimes you are looking for transactions "around your currently known transactions". These codes are provided in command field. SAP – Frequently Used Buttons – Quick Reference Standard Toolbar Buttons Button Keyboard Shortcut Description Button Keyboard Shortcut Description Button Keyboard Shortcut Description Enter key Enter/Continue Ctrl P Print Page Down Next page Ctrl S Save to database Ctrl F Find Ctrl Page Down Last page F3 Back Ctrl G Continue Search (Mac. It contains the description of the fields, their Data Element, which is the semantic meaning of the field, and the Domain, which is the technical descripiton. All reports will have the Design file (. It looks for common elements that need further action, such as scanned text, form fields, tables, and images. Only one element can go in a row so you have experience building web pages a dozen years ago you'll be a pro. Now press enter or continue. By default SAP does not add all the fields of KOMG to field catalogue. Delivered by SAP Community members for SAP Community members, Community Talks are 20-minute sessions (followed by 5 to 8 minutes for Q&A) where speakers have the opportunity to talk about their SAP career journey, lessons learned during SAP-related projects or tasks, tips they can share with their peers, or how to build their brand in the. TBRG Table. Get Request ID for a GRC request from GRACREQ Table. Command Field The Command field is used to enter transaction codes that take you directly to a system task with-out using menus. Searching in SAP Quick Reference Guide This guide describes the various ways to search or select an item in a SAP transaction screen. This is one of the best site have seen for SAP Basis Security Concepts. If you knew the customer then enter ##* for Material description: Sales Order Process. To learn more about our company, visit SAP SE. Appearance. SAP Table Relations version 1. The standard activity list is stored in the TACT standard table. At the end of the document there are alphabetical and numerical listings of subjects and fields. ] Version # Implemented. In order to display a customer, follow the SAP Easy Access menu path:. SAP Reports - Work Orders Reviewing PM (work orders) charges to your Cost Object SAP Screen Shots The University of Mississippi End User Documentation - Enterprise 2005 09/2007 SAP Support: 662. Tables are used to store data. These codes are provided in command field. Best regards, SAP Basis, ABAP Programming. org web site content is based on our knowledge of SAP system, and it is constantly reviewed to avoid errors; well we cannot warrant full correctness of all content. Because of this, no rights can be derived from this chart on individual screens or menu entries. Field Catalog Structure There are separate field catalogs for each condition. Now switch to the Fields tab. In this article I will try to illustrate which fields in the SAP ECC Customer master correspond to which fields in SAP CRM. Find SAP tables without table authorization group Hi people, another common finding of audits is, that not all (of your customer-) tables are assigned to a table authorization group — allowing everyone with S_TABU_DIS and DICBERCLS = "&NC&" to access them. I next push the button "Insert Table" in order to add my first table (BUT000). The code below retrieves the table names and various field properties fine but fails to show the field description. Tables are used to store data. Data preview: Shows a preview of the fields and data of the selected table. There are 176 standard activities in SAP system in the ECC 6. This tutorial is 7000 words+. by Prakash Palani (Prakash. A SAP B1 (Business One) ERP (Enterprise Resource Planning) system table definition and reference Welcome to SAP Tables. org web site content is based on our knowledge of SAP system, and it is constantly reviewed to avoid errors; well we cannot warrant full correctness of all content. Introduction; Dedication; Things SAP cannot do; OM - PA Integration; Company in SAP; Time constraints in SAP; Features; Dynamic Actions; List of HR Infotypes; List of HR Tables; List of Transaction Codes; List of HR Table fields; List of HR functions; List of ABAP functions; Tips; Technical information. Step 1: Click on Texts tab. This license comparison chart is provided as a high level document to provide guidance when selecting user types. The SAP system is a software built by German-based SAP-SE to streamline several key functions of business organizations. Creating a basic database table within your R/3 SAP system is a very straight forward process and can be done in a few minutes following the below steps. Vendor ID, Name. 0, ABAP, SAP ECC 6. The next part covers the Sales and Distribution Tables for Sales Document, Delivery, Billing, Shipping and Pricing Tables related to SAP SD Module. Each table can only be assigned to a single Table Auth. we can’t use field exit for this). It is a part of database and contains various fields. In SAP MM some short-cut codes are provided to save time and effort. The authorization concept is to help establish maximum security, sufficient privileges for end users to fulfil their job duties, and easy user maintenance. Fixed Assets is an important part of the accounting. Just a list of tables that come in handy. The following example defines an internal table with two fields with the format of database table. SAP ABAP Table Field RMCLM-KLBEZ (Class Description) - SAP Datasheet - The Best Online SAP Object Repository. SSURGO Metadata – Tables and Columns Report (PDF; 289 KB): This report includes table attributes? Table Physical Name Table Label Table Description. To display the description of the database fields in the "Field Explorer" in Crystal Reports: In Crystal Reports designer, under the menu "File", select "Options" In the "Options" window, select the tab "Database". You can use SQVI or SE16 to get data from these tables. SAP HANA for Beginners from a Beginner. Every field needs a name. Sometimes you are looking for transactions "around your currently known transactions". Below is the standard documentation available and a few details of the fields which make up this Table. Creating a SAP HANA table using the graphical method. View the full list of Tables for Material Description. If necessary, you can change the class type on the following screen, where you assign the material to one or more classes. com View all posts by Jayanth. Author: SAP Development RF Cookbook - Part I Description History Version Status Date 1. in Higher points will be rewarded for the useful inputs. net The home of table descriptions for SAP. MRP profiles (field contents) MKOP - Consignment price segment (old Release Strategies T16FT - Descriptions of Release. In field Data Element you should specify the data element used for the field in the check table of the characteristic you want to use. A listing of herbs, spices, and medicinal plants & some clues to their uses. On a PC, the icon name and keyboard shortcut are displayed when you place the mouse over the icon. So, as you can imagine these tables get huge. It looks for common elements that need further action, such as scanned text, form fields, tables, and images. You can check a table's group via SE54 or directly via SE16 (table TTDAT, field CCLASS): The purpose of a Table Authorization Group (or at least its humble description) can be found in table TBRGT (go for BROBJ = "S_TABU_DIS", BRGRU = and check the BEZEI field):. type, length, conversion exit). rptdesign) and the Library file (. Offsetting Account Description in Organizations using SAP which need an additional field to be displayed in FBL3N & FAGLL03 reports. If you use one or more of these fields in your BAPI you have to make two fields available for each of these fields in the BAPI interface: one field containing the SAP code and another containing its corresponding ISO code. After generating profiles, we change authorization data according to the requirement of security. Selection fields: Table name. You create an attribute view by joining these two tables using a text join. Define the SAP Data Requirements (Technical) These define in detail the SAP Data structures, tables and fields. Offsetting Account Description in FBL3N & FAGLL03 – GL Line Item Organizations using SAP which need an additional field to be displayed in FBL3N & FAGLL03. The list are categories by their functional modules. A big preference is given to tutorial sites with good and rich content. In an Access database, table properties are attributes of a table that affect the appearance or behavior of the table as a whole. Specify a description for the information structure, archiving object and field catalog. When the table is selected, the name of the table is written below the table description, on the right hand side of the window. net The home of table descriptions for SAP. From the table page you will get details about each table and the fields of that table. SAP Material Master Tables : MSTA - Material Master Status Tcode, ZMATERIAL_IDES - Material Master(IDES Demo) Tcode, J_1AINFMBW - Material Master - Inflation Tcode, T130Z - Use of material master views Tcode, MAEX - Material Master: Legal Control Tcode. 3 Create User Defined Fields (UDF) As we have two parameters in the query, it is necessary to create two user defined fields in the table. Field name. These tables will provide the information about the attachments in the GRC request. You can edit the descriptions for each table by selecting the Description field and entering a new description. It contains the description of the fields, their Data Element, which is the semantic meaning of the field, and the Domain, which is the technical descripiton. I thought to arrange the list in one palace with a title of important SAP EWM tables. Description. As a SAP fico consultant it is mandatory you should to know the table in the SAP software and its data structure. Old data is not lost when an infotype is updated. The definition shown now changes to Table_array. SAP 101 - BEGINNERS SAP The University of Mississippi End User Documentation 4/2014 SAP Support: 662. Table definitions for SAP Business One 9. The Material type is the highest level of categorization of material masters. Every field needs a name. 2 2004-01-27 2. Field Name R/O/C/D/ Description Basic Data 1 R Material master record view containing data common to all parts of the organization such as the material number and description. If you have multiple people editing your reports, this is a great way for everyone to understand what fields they should use and how measures are being calculated. The SAP system is a software built by German-based SAP-SE to streamline several key functions of business organizations. It contains the description of the fields, their Data Element, which is the semantic meaning of the field, and the Domain, which is the technical descripiton. … SAP Business One has naming conventions … for all the tables it uses. By Approval. 3 Create User Defined Fields (UDF) As we have two parameters in the query, it is necessary to create two user defined fields in the table. These are the tables which every SAP Security Consultant should be aware o. Define the SAP Data Requirements (Technical) These define in detail the SAP Data structures, tables and fields. SAP has emphasized the product as pivotal to its cloud shift. The table name is stored in the header of each library. Views can be defined using one or more multiple tables. Command Field The Command field is used to enter transaction codes that take you directly to a system task with-out using menus. I have to manually extract the data and run each report macro individually. SAP Table Relations version 1. Offsetting Account Description in Organizations using SAP which need an additional field to be displayed in FBL3N & FAGLL03 reports. Details showing important Tables in SAP FI and CO Modules Table Name: Description: Important Fields: but I publish a list with FI-AA Tables and fields (Link. Use Stored Procedures in SAP Business One Query Steps to follow 3.