INSERT statement is used for inserting items in Database Tables, Index tables, Internal Tables, Field Groups etc in our ABAP programs. Here we are going to refer about the INSERT statement with tables. For tables INSERT statement will insert new lines in the specified data base tables or internal tables. Now let us check for [...]
DESCRIBE TABLE statement in ABAP programs are used to retrieve the attributes of an internal table. Syntax DESCRIBE TABLE itab [KIND knd] [LINES lin] [OCCURS n]. KIND addition: Is used for retrieve the type of internal table.It will return as following T (For standard tables) S (For sorted tables) H (for Hashed tables) LINES addition: [...]
Here you can see the usage of DELETE statements for deleting lines from database tables, cluster tables, index tables and internal tables. Delete lines from the database tables Syntax DELETE FROM <dbtab> WHERE <cond>. Here all the lines matching the condition (<cond>) in the database table (<dbtab>) will be deleted. DELETE <dbtab> FROM <wa>. Here [...]
Here is a list of important SAP PS tables which stores the data required for Project System component. IMAK: This table contains Appropriation requests – general data IMAV: This table contains Appropriation request variant IMPR: This table contains Investment Program Positions IMPU: This table stores Texts for cap. inv. program positions IMTP: This table contains [...]
Here is a list of important SAP PM Tables for your reference. Here tables are categorized as Equipments, Functional locations, serial numbers, measurement document, maintenance notification, service notification, maintenance and service orders, task list, and maintenance plans. Equipments Tables EQUI: Equipment master data EQKT: Multilingual equipment short texts, long texts, and internal remarks EQUZ: Equipment [...]
SAP PP stands for Production Planning and Controlling. Here is a list of important SAP PP tables which are mainly used in production planning and control. Tables for Work Center CRHD: In this table work center header data is stored CRTX: work center short descriptions CRCO: The assignment of work center to cost center VERTE: [...]
Here is the list of important SAP FI tables for reference. Here we are categorized the tables like customers, vendors, assets etc for easy to understand. Accounting tables (General) BKPF: Accounting Document Header EBKPF: External accounting document header BSEG: Accounting Document Segment BSEC: One-Time Account Data Document Segment BSIP: Double entry invoicing validation BVOR: Inter [...]
Here is the list of important tables used in SAP MM (Material management) component. Tables for material master data MARA: table contains general data about materials like material type, group etc. MAKT: Table contains description about materials. MARC: Material Plant data. MARD: Material storage location. MARM: Materials unit of measure data for conversion and all. [...]
Here is the list of important tables used in SAP sales and distribution component. Tables for Sales documents VBUK: Table contains Header Status and Administrative Data of sales documents VBAK: Table contains Sales Document’s Header Data VBKD: Table contains Sales Document’s Business Data VBUP: Table contains SD order item Status VBAP: This contains SD order [...]
All Personnel administration tables start with PA with corresponding info type number (PA*) All recruitment tables starts with PB with corresponding info type number (PB*). Here is a list of standard SAP HR tables for your reference. T000: To create and maintain SAP system clients. T001: Company codes T001P: Personnel Areas/Subareas T012: House banks [...]
