SAP ABAP

@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: &#

@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  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

 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