@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Demo CDS View'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #S,
dataClass: #MIXED
}
define view entity zchau_acdoca as select from I_JournalEntryItem {
key CompanyCode as BUKRS,
key AccountingDocument as BELNR,
key FiscalYear as GJAHR,
key LedgerGLLineItem as DOCLN,
GLAccount as RACCT,
CostCenter as RCNTR,
ProfitCenter as PRCTR
}
where SourceLedger = '0L' and Ledger = '0L'
@EndUserText.label: 'Demo CDS Table function'
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
define table function zchau_cds_001 with parameters
@Environment.systemField: #CLIENT
p_date: mandt
returns {
key CLIENT : abap.clnt;
key RBUKRS : bukrs;
key DOC_NUM : belnr_d;
key GJAHR : gjahr;
key DOCLN : docln6;
RACCT : racct;
RCNTR : kostl;
PRCTR : prctr;
}
implemented by method ZCL_DEMO_AMDP=>GET_ACDOCA;
CLASS zcl_demo_amdp DEFINITION
PUBLIC
FINAL
CREATE PUBLIC .
PUBLIC SECTION.
INTERFACES if_amdp_marker_hdb .
CLASS-METHODS:
get_acdoca FOR TABLE FUNCTION zchau_cds_001.
PROTECTED SECTION.
PRIVATE SECTION.
ENDCLASS.
CLASS zcl_demo_amdp IMPLEMENTATION.
METHOD get_acdoca BY DATABASE FUNCTION FOR HDB LANGUAGE SQLSCRIPT OPTIONS READ-ONLY USING zchau_acdoca.
RETURN SELECT _raw.mandt as client,
_raw.bukrs as rbukrs,
_raw.belnr as doc_num,
_raw.gjahr as gjahr,
_raw.docln as docln,
_raw.RACCT as RACCT,
_raw.RCNTR as RCNTR,
_raw.PRCTR as PRCTR
from zchau_acdoca as _raw;
endmethod.
ENDCLASS.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |