@AbapCatalog.sqlViewName: 'CCONACCBPCFO'
@ClientHandling.algorithm:#SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck:#CHECK
@EndUserText.label: 'Vertragskonto'
// #CHECK
@ObjectModel: {
usageType.dataClass: #MIXED,
usageType.serviceQuality: #D,
usageType.sizeCategory: #XL
}
@UI.presentationVariant: {
sortOrder: [ { by: 'ContractAccount', direction: #ASC } ]
}
define view C_ContractacCBPCFO
as select from I_ContractAccountPartner as ContractAccountPartner
association [0..1] to I_CAChrgAndDiscByContrAcct as _CAChrgAndDiscByContrAcct on $projection.BusinessPartner = _CAChrgAndDiscByContrAcct.BusinessPartner
and $projection.ContractAccount = _CAChrgAndDiscByContrAcct.ContractAccount
association [1..1] to I_CABillgCycle as _BillgCycle on $projection.CABillgCycle = _BillgCycle.CABillgCycle
//association[0..1] to I_Canmbroflocksperpartner as _Canmbroflocksperpartner on $projection.BusinessPartner = _Canmbroflocksperpartner.BusinessPartner and
// $projection.ContractAccount = _Canmbroflocksperpartner.ContractAccount
//
//association [0..*] to I_Caactivelockbp as _Caactivelockbp on $projection.BusinessPartner = _Caactivelockbp.BusinessPartner and
// $projection.ContractAccount = _Caactivelockbp.ContractAccount
{
@UI: {
lineItem: [{position: 10, importance: #HIGH, type: #STANDARD}
]
}
@ObjectModel: { text.element: ['ContractAccountName']}
@Consumption.semanticObject: 'ContractAccount'
key ContractAccountPartner.ContractAccount,
@UI.hidden: true
key ContractAccountPartner.BusinessPartner,
@UI.hidden: true
ContractAccountPartner.ContractAccountName,
@UI: {
lineItem: [{position: 20, importance: #HIGH, type: #STANDARD, label:'Eingangszahlweg'}]
}
// ContractAccountPartner.CAPaymentMethodForIncgPayment,
ContractAccountPartner._PaytMethodIncg._Text[1:Language = $session.system_language].CAPaymentMethodName as CAPaymentMethodForIncgPayment,
@UI: {
lineItem: [{position: 30, importance: #HIGH, type: #STANDARD, label:'Ausgangszahlweg'}]
}
case length( ContractAccountPartner.CAPaymentMethodForOutgPayment )
when 0
then' '
when 1
then ContractAccountPartner._PaytMethodOutg._Text[1:Language = $session.system_language].CAPaymentMethodName
else
'multiple' // Modified in ABAP
end as CAPaymentMethodForOutgPayment,
// ContractAccountPartner.CAPaymentMethodForOutgPayment,
// ContractAccountPartner._PaytMethodOutg._Text[1:Language = $session.system_language].CAPaymentMethodName as CAPaymentMethodName,
@UI: {
lineItem: [{position: 40, importance: #HIGH, type: #STANDARD, label:'Offener Betrag (Saldo)'}]
}
@Semantics.amount.currencyCode: 'TransactionCurrency'
cast( 0 as betrw_kk ) as OpenAmountInDisplayCrcy,
// @UI: {
// lineItem: [{position: 50, importance: #LOW, type: #STANDARD, label:'Due Amount (Balance)'}]
// }
@Semantics.amount.currencyCode: 'TransactionCurrency'
// _ContrAcctSeperatedAmtsInDC.OpenDueAmountInDisplayCrcy,
@EndUserText.label:'Fälliger Betrag (Saldo)'
cast( 0 as betrw_kk ) as OpenDueAmountInDisplayCrcy,
// @UI: {
// lineItem: [{position: 60, importance: #LOW, type: #STANDARD, label:'Dunning Procedure'}]
// }
// ContractAccountPartner.CADunningProcedure,
@EndUserText.label:'Mahnverfahren'
ContractAccountPartner._DunningProcedure._Text[1:Language = $session.system_language].CADunningProcedureName,
// @UI: {
// lineItem: [{position: 70, importance: #LOW, type: #STANDARD, label: 'Collection Strategy'}]
// }
// ContractAccountPartner.CACollectionStrategy,
@EndUserText.label:'Collection Strategie'
ContractAccountPartner._CollectionStrategy._Text[1:Language = $session.system_language].CACollectionStrategyName,
// @UI: {
// lineItem: [{position: 80, importance: #LOW, type: #STANDARD}]
// }
@UI.hidden : true
ContractAccountPartner.CABillgCycle,
@EndUserText.label:'Abrechnungszyklus'
_BillgCycle._CABillgCycleText[1:Language = $session.system_language].CABillgCycleText,
@UI.hidden: true
ContractAccountPartner.Country,
@Semantics.currencyCode: true
@UI.hidden: true
// _ContractAcctOpenAmtPerCrcy.TransactionCurrency,
cast( 'EUR' as waers_kk ) as TransactionCurrency,
// @UI: {
// lineItem: [{position: 90, importance: #LOW, type: #STANDARD, label: 'Discounts'}]
// }
@ObjectModel: { text.element: ['CAInvcgChrgAndDiscKeyText']}
@EndUserText.label:'Skonto'
_CAChrgAndDiscByContrAcct.CAInvcgChargeAndDiscountKey,
@UI.hidden: true
_CAChrgAndDiscByContrAcct._ChrgAndDiscKey._CAInvcgChrgAndDiscKeyText[1:Language = $session.system_language].CAInvcgChrgAndDiscKeyText,
@EndUserText.label:'Aktive Eingangszahlsperren'
@EndUserText.quickInfo: 'Aktive Eingangszahlsperren'
cast ( ' ' as char50 ) as CAIncomingPaymentLockReason,
@EndUserText.label:'Aktive Ausgangszahlsperren'
@EndUserText.quickInfo: 'Aktive Ausgangszahlsperren'
cast ( ' ' as char50 ) as CAOutgoingPaymentLockReason,
@EndUserText.label:'Mahnsperren'
@EndUserText.quickInfo: 'Mahnsperren'
cast ( ' ' as char50 ) as CADunningLockReason,
@EndUserText.label:'Aktive Buchungssperren'
@EndUserText.quickInfo: 'Aktive Buchungssperren'
cast ( ' ' as char50 ) as CAPostingLockReason,
@EndUserText.label:'Aktive Fakturasperre'
@EndUserText.quickInfo: 'Aktive Fakturasperre'
cast ( ' ' as char50 ) as CAInvcgLockReason,
@UI.hidden: true
CAAuthorizationGroup,
@UI.hidden: true
CAStandardCompanyCode,
@UI.hidden: true
_ContrAcc.ContractAccountCategory
// @UI: {
// lineItem: [{position: 100, importance: #LOW, type: #STANDARD, label: 'Active Locks'}]
// }
// @EndUserText.label:'Active Locks'
// case
// when _Canmbroflocksperpartner.CABusinessProcess > 1
// then 'multiple'
// else
// case
// when _Caactivelockbp.CABusinessProcess = '01'
// then 'Dunning Lock'
// when _Caactivelockbp.CABusinessProcess = '02'
// then 'Incoming Payment Lock'
// when _Caactivelockbp.CABusinessProcess = '03'
// then 'Outgoing Payment Lock'
// when _Caactivelockbp.CABusinessProcess = '09'
// then 'Posting Lock'
// end
// end as CABusinessLockObject
//Associations
// ContractAccountPartner._PaytMethodIncg,
// ContractAccountPartner._PaytMethodOutg,
// ContractAccountPartner._DunningProcedure,
// ContractAccountPartner._CollectionStrategy
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CABILLGCYCLE",
"I_CABILLGCYCLETEXT",
"I_CACHRGANDDISCBYCONTRACCT",
"I_CACOLLECTIONSTRATEGY",
"I_CACOLLECTIONSTRATEGYTEXT",
"I_CADUNNINGPROCEDURE",
"I_CADUNNINGPROCEDURETEXT",
"I_CAINVCGCHRGANDDISCKEY",
"I_CAINVCGCHRGANDDISCKEYTEXT",
"I_CAPAYMENTMETHOD",
"I_CAPAYMENTMETHODTEXT",
"I_CONTRACTACCOUNTHEADER",
"I_CONTRACTACCOUNTPARTNER"
],
"ASSOCIATED":
[
"I_CABILLGCYCLE",
"I_CACHRGANDDISCBYCONTRACCT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/