SAP PM - PRT table creation

How To Create PRT (Production Resources/Tools) in SAP PM Module How to access the transaction using menu:SAP Menu -> Logistics -> Plan Maintenance -> Management of Technical Objects -> Environment -> Production Resources/Tools -> Production Resources/Tools -> PRT Master (Others) -> CreateHow to access the transaction using TCODE: CF01 1. Prod.resources/tools: Is a resources required to do some operations such as tools, crane or other instruments for quality inspection. (M) 2. Press enter to continue. 1. Description: Explain about the PRT you want to create. 2. Status: The PRT status, e.g. 01 (Created on), 02 (Released for PRT usage planning), 03 (Released for production) 3. Task list usage: Explain what task list is used for the PRT. 000 no task list categories 001 only routings 002 only inspection plans 003 only networks 004 only maintenance task lists 005 Production rate planning 007 Only rate routings 008 Master recipe + Process Order 009 All task list types 010 Rough-cut planning 4. Base unit of measure: The unit of measure for the PRT. Click “Default” after you have filled the required information. Click enter and CTRL+S to save the PRT Master.

SAP SD Tables

Here you can find a list of SAP SD tables for various TCODE, I hope it will be useful for you.
Table          Table Description
VBAK            Sales Document: Header Data
VBAP            Sales Document: Item Data
VBKD            Sales Document: Business Data
VBPA            Sales Document: Partner
VBFA            Sales Document Flow
TROLZ          Routes: Determination in Deliveries
KNA1            General Data in Customer Master
KNVV           Customer Master Sales Data
KNVP           Customer Master Partner Functions
KNKK           Customer master credit management: Control area data
KNKA           Customer master credit management: Central data
KNKKF1      Credit Management: FI Status Data
KNKKF2      Credit Management: Open Items by Days in Arrears
LIKP             SD Document: Delivery Header Data
LIPS              SD Document: Delivery: Item data
VBRK           Billing Document: Header Data
VBRP           Billing Document: Item Data
KONP           Conditions (Item)
KONV          Conditions (Transaction Data)
VBUK          Sales Document: Header Status and Administrative Data
VBUP          Sales Document: Item Status
KNBK          Customer Master (Bank Details)
TKUKL        Customers: Customer Classifications
T016           Industries
TBRC           Industry Code (Customer Master)
TVGF          Legal Status (Customer Master)
KNVA        Customer Master Loading Points
KNVK        Customer Master Contact Partner
T502T       Marital Status Designators
T171           Customers: Sales Districts
TVBUR     Organizational Unit: Sales Offices
TVBVK     Organizational Unit: Sales Groups per Sales Office
T151          Customers: Customer Groups
TCURC      Currency Codes
TCURV     Exchange rate types for currency translation
TVKD        Customer Pricing Procedures
T188         Conditions: Groups for Customer Classifications
T189         Conditions: Price List Categories
TVSD        Customers: Statistics groups
TPAR        Business Partner: Functions

Creating Search Help In SAP

Today we will learn how to create search help in SAP, so what is search help? Search help is an object that we create using tcode se11, it’s one of the data dictionaries object in SAP. Using search help we can make a search to a particular data much easier, because it will create a pop up window that contains all the data related with our search.
There are 2 types of search help, the first one is elementary and the second one is collective, elementary search help usually only requires one table to create it, while the collective search help is a collection of more than one search helps.
Now we want to create an elementary search help.
Let’s execute tcode se11. Choose the Search help option and Type in the search help name that we want to create, in this example I’ll name it as ZSEARCHHELP, after that click create button.

In the popup window selection, choose the Elemetary search help, click ok.

Type in the search help description, in this case I named it as Customer search help.
Click the selection method button and choose search for database tables because we want to display data from the customer table.

Now type the KNA1 table on the given textbox.

Now you only need to determine which columns from the KNA1 table that you want to display in your search help, in this case I want to display 3 columns, KUNNR, NAME1, STRAS. You also have to set the IMP, EXP, LPOS, SPOS columns, just do it as the pictures illustrated below.

Save, Activate and test (F8) Your search help is ready to use.

Insert Update and Delete Row In Transparent Table

Insert Update and Delete Row In Transparent Table Here’s a sample code to insert, update and delete row in transparent table. This syntax is relatively simple, remember that this is a transparant table and not internal table so the changes will be directly reflected on your tables. But first you have to create a transparent table first. Here’s the Abap code sample. REPORT Z_TransparentTable_SQL. data wa type ztable1. START-OF-SELECTION. "Insert new row to transparant table. wa-custid = '0001'. wa-custnm = 'ABC'. insert ztable1 from wa. "Modify data in transparant table "Using modify statement, the system will "automatically search the index key "if found similar key then it will update "the value and not adding new row wa-custid = '0001'. wa-custnm = 'CDE'. Modify ztable1 from wa. "delete row from transparant table wa-custid = '0001'. delete ztable1 from wa.

SAP Authorization Object Tables

SAP Authorization Object Tables List

Here’s a list of SAP authorization Object tables for your reference.
You can execute TCODE SE11 and see more details of each table, such as column description, field type, etc.
Table Name    Description
TOBJ        Authorization Objects
TACT        Activities which can be Protected
TACTZ        Valid Activities for each authorization object
TDDAT        Maintenance Areas for tables
TSTC         SAP Transaction Codes
TPGP        ABAP/4 Authorization groups
USOBT        Relation transaction > Authorization Object
USOBX        Check table for table USOBT
USOBT_C        Relation Transaction   > Auth. Object (Customer)
USOBX_C        Check table for table USOBT_C

SAP Purchasing Tables

SAP Purchasing Tables

Here’s the list of SAP Purchasing Tables, use this as your reference. Use TCODE SE11 for more details of the table.

Table Name	Table Description
A501	Plant/Material
EBAN	Purchase Requisition
EBKN	Purchase Requisition Account Assignment
EKAB	Release Documentation
EKBE	History per Purchasing Document
EKET	Scheduling Agreement Schedule Lines
EKKO	Purchasing Document Header
EKPO	Purchasing Document Item
IKPF	Header- Physical Inventory Document
ISEG	Physical Inventory Document Items
LFA1	Vendor Master (General section)
LFB1	Vendor Master (Company Code)
NRIV	Number range intervals
RESB	Reservation/dependent requirements
T024	Texts for Purchasing Document Types
T156	Movement Type
T157H	Help Texts for Movement Types

•SAP MM Tables

SAP MM Tables – List Of MM Tables 


Here’s the list of SAP Material Management (MM) tables, use this as your reference. You can use TCODE SE11 to see more details information of the table.

Table Name	Table Description
EINA	Purchasing Info Record- General Data
EINE	Purchasing Info Record- Purchasing Organization Data
MAKT	Material Descriptions
MARA	General Material Data
MARC	Plant Data for Material
MARD	Storage Location Data for Material
MAST	Material to BOM Link
MBEW	Material Valuation
MKPF	Header- Material Document
MSEG	Document Segment- Material
MVER	Material Consumption
MVKE	Sales Data for materials
RKPF	Document Header- Reservation
T023	Mat. groups
T024	Purchasing Groups
T156	Movement Type
T157H	Help Texts for Movement Types