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, ...

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

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

 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,       ...