@AbapCatalog.sqlViewName: 'IMBKWITHTMPL'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #TRANSACTIONAL
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel: {
compositionRoot: true,
modelCategory: #BUSINESS_OBJECT,
transactionalProcessingEnabled: true,
writeDraftPersistence: 'IMBKWITHTMPLDF',
draftEnabled: true,
createEnabled: true,
updateEnabled: 'EXTERNAL_CALCULATION',
deleteEnabled: 'EXTERNAL_CALCULATION',
semanticKey: [ 'RepetitiveCodeFlowID'],
representativeKey: 'RepetitiveCodeFlowID',
usageType: {
sizeCategory: #M,
serviceQuality: #C,
dataClass: #ORGANIZATIONAL
}
}
@Search.searchable: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.allowExtensions: true
@EndUserText.label: 'BOPF View for Repetitive Code'
define view I_MakeBankTransferTemplateTP as select from P_MakeBankTransferTemplate as a
inner join I_CompanyCode as c on a.PayingCompanyCode = c.CompanyCode
// left outer to one join fclm_bam_aclink2 as _PayingHouseBank on a.PayingCompanyCode = _PayingHouseBank.bukrs
// and a.PayingHouseBank = _PayingHouseBank.hbkid
// and a.PayingHouseBankAccount = _PayingHouseBank.hktid
// and _PayingHouseBank.herku = ''
// and _PayingHouseBank.hbkid <> ''
// and _PayingHouseBank.hktid <> ''
// and _PayingHouseBank.is_reused = ''
// and _PayingHouseBank.revision = '0000'
left outer to one join I_HouseBankAccountLinkage as _PayingHouseBank on a.PayingCompanyCode = _PayingHouseBank.CompanyCode
and a.PayingHouseBank = _PayingHouseBank.HouseBank
and a.PayingHouseBankAccount = _PayingHouseBank.HouseBankAccount
// left outer to one join fclm_bam_amd as _PayingBankKey on _PayingHouseBank.acc_id = _PayingBankKey.acc_id
// and _PayingBankKey.revision = '0000'
// and _PayingBankKey.status <> '99'
left outer to one join I_BankAccount as _PayingBankAccount on _PayingHouseBank.BankAccountInternalID = _PayingBankAccount.BankAccountInternalID
// left outer to one join fclm_bam_amd_t as _PayingAccount on _PayingHouseBank.acc_id = _PayingAccount.acc_id
// and _PayingAccount.revision = '0000'
// and _PayingAccount.deleted_flag <> 'X'
// and _PayingAccount.langu = $session.system_language
// left outer to one join fclm_bam_aclink2 as _PayeeHouseBank on a.PayeeCompanyCode = _PayeeHouseBank.bukrs
// and a.HouseBank = _PayeeHouseBank.hbkid
// and a.HouseBankAccount = _PayeeHouseBank.hktid
// and _PayeeHouseBank.herku = ''
// and _PayeeHouseBank.hbkid <> ''
// and _PayeeHouseBank.hktid <> ''
// and _PayeeHouseBank.is_reused = ''
// and _PayeeHouseBank.revision = '0000'
left outer to one join I_HouseBankAccountLinkage as _PayeeHouseBank on a.PayeeCompanyCode = _PayeeHouseBank.CompanyCode
and a.HouseBank = _PayeeHouseBank.HouseBank
and a.HouseBankAccount = _PayeeHouseBank.HouseBankAccount
// left outer to one join fclm_bam_amd as _PayeeBankKey on _PayeeHouseBank.acc_id = _PayeeBankKey.acc_id
// and _PayeeBankKey.revision = '0000'
// and _PayeeBankKey.status <> '99'
left outer to one join I_BankAccount as _PayeeBankAccount on _PayeeHouseBank.BankAccountInternalID = _PayeeBankAccount.BankAccountInternalID
// left outer to one join fclm_bam_amd_t as _PayeeAccount on _PayeeHouseBank.acc_id = _PayeeAccount.acc_id
// and _PayeeAccount.revision = '0000'
// and _PayeeAccount.deleted_flag <> 'X'
// and _PayeeAccount.langu = $session.system_language
association [1..1] to I_CompanyCode as _PayingCompanyCode on $projection.PayingCompanyCode = _PayingCompanyCode.CompanyCode
association [1..1] to I_CompanyCode as _PayeeCompanyCode on $projection.PayeeCompanyCode = _PayeeCompanyCode.CompanyCode
association [0..1] to I_PaymentMethod as _PaymentMethod on $projection.Country = _PaymentMethod.Country
and $projection.PaymentMethod = _PaymentMethod.PaymentMethod
{
key RepetitiveCodeFlowID,
@Search.defaultSearchElement: true
a.RepetitiveCode,
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
@Search.defaultSearchElement: true
a.PayingCompanyCode,
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
@Search.defaultSearchElement: true
// _PayingBankKey.acc_num as PayingBankAccount,
_PayingBankAccount.BankAccountNumber as PayingBankAccount,
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
@Search.defaultSearchElement: true
// _PayingHouseBank.acc_id as PayingBankAccountInternalID,
_PayingHouseBank.BankAccountInternalID as PayingBankAccountInternalID,
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
// _PayingAccount.description as PayingBankAccountDescription,
_PayingHouseBank.BankAccountDescription as PayingBankAccountDescription,
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
@Search.defaultSearchElement: true
a.PayeeCompanyCode,
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
// @ObjectModel.mandatory: true
@Search.defaultSearchElement: true
// _PayeeBankKey.acc_num as PayeeBankAccount,
// a.PayeeBankAccount,
_PayeeBankAccount.BankAccountNumber as PayeeBankAccount,
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
// _PayeeHouseBank.acc_id as PayeeBankAccountInternalID,
_PayeeHouseBank.BankAccountInternalID as PayeeBankAccountInternalID,
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
// _PayeeAccount.description as PayeeBankAccountDescription,
_PayeeHouseBank.BankAccountDescription as PayeeBankAccountDescription,
@ObjectModel.mandatory: true
@Search.defaultSearchElement: true
a.PaymentMethod,
@ObjectModel.mandatory: true
@Search.defaultSearchElement: true
a.Currency,
a.RepetitiveCodeReferenceText,
a.HouseBank,
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
a.PayingHouseBank as PayingHouseBank,
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
// @ObjectModel.text.association: '_PayingHouseBankAccountText'
a.PayingHouseBankAccount,
a.BankCountry,
a.PayingBankKey,
// _PayeeBankKey.bankl as PayeeBankKey,
_PayeeBankAccount.Bank as PayeeBankKey,
a.PayeeHouseBank,
a.PayeeHouseBankAccount,
// @ObjectModel.text.association: '_PayeeHouseBankAccountText'
a.HouseBankAccount,
//
c.Country,
_PayingCompanyCode,
_PayeeCompanyCode,
_PaymentMethod
// _PayingHouseBankAccountText,
// _PayeeHouseBankAccountText
// _PayingDescription,
// _TargetDescription
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANKACCOUNT",
"I_COMPANYCODE",
"I_HOUSEBANKACCOUNTLINKAGE",
"P_MAKEBANKTRANSFERTEMPLATE"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_PAYMENTMETHOD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/