@AbapCatalog.sqlViewName: 'zvtx_hbank'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'house bank data'
define view ztx_hbank
as select from t012
left outer join t001 on t001.bukrs = t012.bukrs
left outer join t012d on t012d.bukrs = t012.bukrs
and t012d.hbkid = t012.hbkid
{
key t012.bukrs as CompanyCode,
key t012.hbkid as HouseBankKey,
butxt as CompanyName,
banks as BankCountry,
bankl as BankInternalId,
t012d.dtbid as AlternativeBankId,
t012d.dtelz as BankNoReceiver,
dtkid as CustomerNumber,
dtfin as CompanyNumber,
edipn as PartnerNumber,
edisn as TypeOfSignature,
dtglz as BankNumber,
dtgbk as AccountNumber,
dtgko as ControlKey,
dtgis as IsoCurrencyCode,
dtaws as InstructionKey,
dtvta as LeadDays,
telf1 as Telephone,
stcd1 as TaxNumber,
name1 as NameOfContactPerson
}
@AbapCatalog.sqlViewName: 'zvtx_bank'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'bank master'
define view ztx_bank
with parameters
p_spras: sylangu
as select from bnka
association[0..*] to ztx_hbank as _hbank on $projection.BankCountry = _hbank.BankCountry
and $projection.BankInternalId = _hbank.BankInternalId
{
key banks as BankCountry,
key bankl as BankInternalId,
erdat as CreateOn,
ernam as CreateBy,
bnka.banka as BankName,
provz as Region,
stras as StreetName,
ort01 as BankCity,
bnka.swift as Swift,
bgrup as BankGroup,
xpgro as PostOfficeAccount,
bnklz as BankNumber,
@EndUserText.label: 'Homeland or not'
case when banks = 'CN' then
// 'Homeland'
cast( 'Homeland' as abap.char( 20 ))
else cast ('Foreign Country' as abap.char( 20 ))
end as Country,
_hbank.CompanyCode,
_hbank.CompanyName,
_hbank
}
DATA: lt_parameters TYPE if_sadl_public_types=>tt_entity_parameters,
ls_parameter LIKE LINE OF lt_parameters,
lt_para LIKE ls_parameter-parameters,
ls_para LIKE LINE OF lt_para.
DATA(lo_auth_provider) = cl_sadl_cond_prov_factory_pub=>create_for_authorization( ).
DATA(lv_target_set_name) = me->mr_request_details->*-target_entity_set.
IF me->mr_request_details->technical_request-navigation_path IS INITIAL.
CLEAR lv_target_set_name.
ENDIF.
CASE iv_entity_set.
WHEN 'BANKSet'.
lo_auth_provider->add_authorization_for_object(
EXPORTING
iv_authorization_object = 'F_BNKA_MAO'
it_activities = VALUE #( ( auth_field = 'ACTVT' value = '03' ) )
it_field_mapping = VALUE #( ( auth_field = 'BBANKS' view_field = 'BANKCOUNTRY' ) ) ).
ls_para-name = 'P_SPRAS'.
ls_para-value = sy-langu.
APPEND ls_para TO lt_para.
ls_parameter-entity_alias = iv_entity_set.
ls_parameter-parameters = lt_para.
APPEND ls_parameter TO lt_parameters.
io_query_options->set_entity_parameters( lt_parameters ).
WHEN OTHERS.
ENDCASE.
io_query_options->set_authority_provider( io_authority_provider = lo_auth_provider ).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
38 | |
19 | |
13 | |
13 | |
11 | |
10 | |
10 | |
10 | |
8 | |
8 |