Posts

A Financial Ledger Report

@AbapCatalog.sqlViewName: 'ZFINANCIAL_DATA' @AbapCatalog.compiler.compareFilter: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'Financial Data' define view ZFI_BALANCE as   select from acdoca as a   left outer join bkpf as b on a.belnr = b.belnr and a.budat = b.budat   left outer join t003t as t on a.blart = t.blart   left outer join skat as s on a.racct = s.saknr {   key a.belnr as DOC,   @EndUserText.label: 'Posting Date'   a.budat as BUDAT,   @EndUserText.label: 'Document Date'   a.bldat as BLDAT,   @EndUserText.label: 'Assignment'   a.zuonr as ZUONR,   @EndUserText.label: 'Item Text'   a.sgtxt as SGTXT,   @EndUserText.label: 'Document Type'   a.blart as BLART,   @EndUserText.label: 'GL Account'   a.racct as RACCT,   @EndUserText.label: 'Document Type Description'   t.ltext as VTYPE,   @EndUserText.label: 'GL Account Description'   s.txt50 as GL_DESCR,   @EndUserText.label: &#

CDS View Sales Order Information

@AbapCatalog.sqlViewName: 'ZSALESORDER' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #CHECK @EndUserText.label: 'Sales Order Information' define view ZTest1 as select from afko as salesOrderHeader   inner join afpo as salesOrderItem on salesOrderHeader.aufnr = salesOrderItem.aufnr   inner join resb as reservation on salesOrderHeader.rsnum = reservation.rsnum   inner join mara as materialMaster on reservation.matnr = materialMaster.matnr   inner join marc as plantSpecific on reservation.matnr = plantSpecific.matnr and salesOrderItem.dwerk = plantSpecific.werks   inner join mara as materialMasterPlanned on salesOrderHeader.plnbez = materialMasterPlanned.matnr   inner join t023t as materialTypeDescription on materialMasterPlanned.matkl = materialTypeDescription.matkl {   key salesOrderHeader.aufnr as SalesOrderNumber,       salesOrderHeader.plnbez as PlannedMaterialNumber,       salesOrderHeader.gamng as TotalO

Function Module Name for Retrieving Closing Balance

FUNCTION  zgl_bal . *"---------------------------------------------------------------------- *"*"Local Interface: *"  IMPORTING *"     REFERENCE(COMP) TYPE  BKPF-BUKRS *"     REFERENCE(DATE) TYPE  BKPF-BUDAT *"     REFERENCE(ACCT) TYPE  BSEG-HKONT *"  EXPORTING *"     REFERENCE(BALANCE) TYPE  BSEG-DMBTR *"----------------------------------------------------------------------    DATA  :  companycodeid  LIKE   bapi0002_2 - comp_code ,          posting_date   LIKE   bapi0002_4 - posting_date ,          fiscal_year    LIKE   bapi0002_4 - fiscal_year ,          fiscal_period  LIKE   bapi0002_4 - fiscal_period .    DATA  :  account_balances   TYPE  TABLE  OF  bapi3006_4  WITH  HEADER  LINE .    DATA  :  bal  TYPE  bseg - dmbtr .    DATA  :  iv_date              TYPE   d ,          ev_month_begin_date  TYPE   d ,          ev_month_end_date    TYPE   d .    DATA  :  companycode   LIKE   bapi3006_0 - comp_code ,          glacct        LIKE   bap

Excel Uploader SAP ABAP Program using field symbol

 REPORT zsd_uplode. TYPES  : BEGIN OF tab,            mandt  TYPE  mandt,            werks  TYPE werks_d,            lgort  TYPE lgort_d,            bldat  TYPE bldat,            pernr  TYPE persno,            zgross TYPE  zgross,            zfine  TYPE zfine,            zston  TYPE zston,            zglas  TYPE zglas,            zmisc  TYPE zmisc,            zleat  TYPE zleat,            zrubb  TYPE zrubb,            zplas  TYPE zplas,            zunit  TYPE erfme,            zally  TYPE zally,            zco11n TYPE  zco11n,            zglwt  TYPE zfine,            zglft  TYPE zfine,          END OF tab. DATA: gt_tab   TYPE STANDARD TABLE OF tab,       gt_tab1  TYPE STANDARD TABLE OF tab,       gt_tab_r TYPE STANDARD TABLE OF tab,       gs_tab   TYPE tab,       gs_tab_r TYPE tab,       gs_tab1  TYPE tab,       c_bcol   TYPE i       VALUE  1                      ,     "START COLUMN       c_brow   TYPE i       VALUE  2                      ,     "START ROW       c_ecol   TYPE

procurement reports

We Create Procurements Report for below reason Ensuring material availability for production Controlling procurement costs Improving supplier relationships Enhancing process efficiency Maintaining compliance Supporting strategic planning and decision-making. CDS View for Procurements Reports  @AbapCatalog.sqlViewName: 'ZCDSRK0002' @EndUserText.label: 'procurement reports' define view ZRKTEST_0002 as select from afko as salesOrderHeader   inner join afpo as salesOrderItem on salesOrderHeader.aufnr = salesOrderItem.aufnr   inner join resb as reservation on salesOrderHeader.rsnum = reservation.rsnum   inner join mara as materialMaster on reservation.matnr = materialMaster.matnr   inner join marc as plantSpecific on reservation.matnr = plantSpecific.matnr and salesOrderItem.dwerk = plantSpecific.werks   inner join mara as materialMasterPlanned on salesOrderHeader.plnbez = materialMasterPlanned.matnr   inner join t023t as materialTypeDescription on materialMasterPlanned.matk

Stock Reports

 <b>Inventory Management:</b> Track Stock Levels: Stock reports provide a clear picture of your current inventory levels across various materials, plants, and storage locations. This helps you avoid stockouts, which can lead to lost sales and customer dissatisfaction. Optimize Inventory Planning: By analyzing stock movement trends and identifying slow-moving or fast-selling items, you can optimize your inventory planning. This minimizes unnecessary holding costs for slow-moving items and ensures adequate stock levels for popular products. Improve Warehouse Efficiency: Reports can reveal inefficiencies in your warehousing operations, such as misplaced or damaged goods. This allows you to take corrective actions and improve overall warehouse efficiency. Financial Analysis and Decision Making: Cost Control: Monitoring stock levels helps you control inventory costs. You can identify overstocked items and adjust purchasing orders accordingly, thereby reducing unnecessary spendin

Range Table , How to create range table using and internal table SAP ABAP

Image
  Sometimes there is an issue with creating a range table and passing range selections on the screen. For this, we can create a range table.    DATA  :  s_vbeln5  TYPE  /iwbep/t_cod_select_options .   s_vbeln5  =  VALUE  # (  FOR  s_vbeln1  IN  s_vbeln[]                       LET s  =  s_vbeln1 - sign                            o  =  s_vbeln1 - option                        IN  sign  =  s                          option  =  o                     (  low  =  s_vbeln1 - low                      high  =  s_vbeln1 - high  )  ) . ********************************ROHINI KUMAR*********************************                                 Please support my work : sap.rohini988@gmail.com                                LinkedIn Link  :  https://www.linkedin.com/in/rohini-kumar-14647a13a/ ********************************************************************************