Posts

TMS Mini Project - Step - 1 - TMS Master data

Image
Scenario:   This application will help to set up the initial TMS Master data, primarily maintaining the cost objects and linking the same with Vendors and projects. Approach:  First, i have created Project master table, Vendor master table, custom EKKO table ( to store PO details ). Project Master table: Vendor Master table: Material master table: TMS Master table: table in which report data is stored Master report: TOP include: *&---------------------------------------------------------------------* *& Include ZREP_MAS_ALL_TOP *&---------------------------------------------------------------------* TYPES: BEGIN OF ty_final, projno TYPE zdt_demo_mas-projno, projname TYPE zprojmas-projname, zvendno TYPE zdt_demo_mas-zvendno, zvendname TYPE zvendmas-zvendname, service TYPE zdt_demo_mas-service, projph TYPE zdt_demo_mas-projph, ebeln TYPE zdt_demo_mas-ebeln, pacde...
Post a Comment
Read more

Interactive ALV report using ALV IDA

Image
Scenario: Create an interactive ALV report which will display Customer data, Sales data data upon double clicking customer number in Customer data ALV report. Approach:      I have initially created simple CDS views of KNA1 and VBAK tables. @AbapCatalog.sqlViewName: 'ZCDSVRKNA1' @AbapCatalog.compiler.compareFilter: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'demo view kna1' @Metadata.ignorePropagatedAnnotations: true define view ZCDS_VR_KNA1 as select from kna1 { key kunnr as CUSTOMER_NO, land1 as COUNTRY, name1 as NAME, ort01 as CITY, erdat as CREATED_ON, ernam as CREATED_BY, lifnr as SUPPLIER } @AbapCatalog.sqlViewName: 'ZCDSVRVBAK' @AbapCatalog.compiler.compareFilter: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'demo view vbak' @Metadata.ignorePropagatedAnnotations: true define view ZCDS_VR_VBAK as select from vbak { key vbeln as SALES_DOC, erdat as CREAT...
Post a Comment
Read more

Select options in AMDP

Image
Scenario - Create a report which will take in Customer ID (select options) as input and give Loan data. Table used for this requirement: ZDLOAN Below is code implemented in the AMDP class: CLASS zcl_demo_amdp_so1 DEFINITION PUBLIC FINAL CREATE PUBLIC . PUBLIC SECTION. INTERFACES if_amdp_marker_hdb . TYPES: it_loan TYPE TABLE OF zdloan. METHODS: get_loan_data IMPORTING VALUE(im_mandt) TYPE mandt VALUE(im_custid) TYPE string EXPORTING VALUE(ep_LOAN) TYPE it_loan. PROTECTED SECTION. PRIVATE SECTION. ENDCLASS. CLASS zcl_demo_amdp_so1 IMPLEMENTATION. METHOD get_loan_data BY DATABASE PROCEDURE FOR HDB LANGUAGE SQLSCRIPT OPTIONS READ-ONLY USING zdloan. IT_LOAN = select * from ZDLOAN where mandt = IM_MANDT; EP_loan = APPLY_FILTER (:IT_LOAN, :IM_CUSTID); ENDMETHOD. ENDCLASS. Below is the code implemented in the driver program: *&--------------------...
Post a Comment
Read more