Posts

Showing posts with the label Data Dictionary in SAP : Part One

Using BAPI upload excel file for t-code AS02 in SAP

Using BAPI " BAPI_FIXEDASSET_CHANGE " create a zprogram to upload excel file for mass change fixed asset in SAP. REPORT  ZAS02_ASSET_CHANGE_UPLOAD . TYPE-POOLS :  truxs . " Structure for Excel data TYPES :  BEGIN  OF  ty_excel ,          anln1  TYPE  anln1 ,          bukrs  TYPE  bukrs ,          kostl  TYPE  kostl ,          werks  TYPE  werks ,          prctr  TYPE  prctr ,         END  OF  ty_excel . DATA :  lt_excel     TYPE  TABLE  OF  ty_excel ,       ls_excel     TYPE  ty_excel ,     ...

Data Dictionary in SAP : Part One

What is data dictionary in sap? SAP data dictionary is central repository for the development of object, SAP data dictionary is used to create & maintain metadata. SQL can be divided by two parts: DML - Data Manipulation language consist of SELECT ,INSERT, UPDATE, MODIFY, DELETE etc. DDL - Data Definition language consist of CREATE TABLE, DROP TABLE, ALTER TABLE, CREATE INDEX etc. Data Dictionaries function : Database tables. views Data Elements Domains Structures Search Helps Lock Objects T-Code is : SE11