Which tables does C_ContractacCBPCFO use?

C_ContractacCBPCFO reads from 1 data source(s): I_ContractAccountPartner.

How many fields does C_ContractacCBPCFO have?

C_ContractacCBPCFO has 26 fields. Key fields: ContractAccount, BusinessPartner.

C_ContractacCBPCFO

DDL: C_CONTRACTACCBPCFO SQL: CCONACCBPCFO Type: view CONSUMPTION Package: ODATA_O2C_FICA_CFO

Vertragskonto

C_ContractacCBPCFO is a Consumption CDS View that provides data about "Vertragskonto" in SAP S/4HANA. It reads from 1 data source (I_ContractAccountPartner) and exposes 26 fields with key fields ContractAccount, BusinessPartner. It has 2 associations to related views. Part of development package ODATA_O2C_FICA_CFO.

Data Sources (1)

Source	Alias	Join Type
I_ContractAccountPartner	ContractAccountPartner	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_CAChrgAndDiscByContrAcct	_CAChrgAndDiscByContrAcct	`$projection.BusinessPartner = _CAChrgAndDiscByContrAcct.BusinessPartner and $projection.ContractAccount = _CAChrgAndDiscByContrAcct.ContractAccount`
[1..1]	I_CABillgCycle	_BillgCycle	`$projection.CABillgCycle = _BillgCycle.CABillgCycle`

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	CCONACCBPCFO	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Vertragskonto	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view

Fields (26)

Key	Field	Source Table	Source Field	Description
KEY	ContractAccount	I_ContractAccountPartner	ContractAccount
KEY	BusinessPartner	I_ContractAccountPartner	BusinessPartner
	ContractAccountName	I_ContractAccountPartner	ContractAccountName
	CAPaymentMethodForIncgPayment
	CAFirstOutgoingPaytMethodText
	CASecondOutgoingPaytMethodText			Zweiter Ausgangszahlweg
	CAThirdOutgoingPaytMethodText			Dritter Ausgangszahlweg
	CAFourthOutgoingPaytMethodText			Vierter Ausgangszahlweg
	CAFifthOutgoingPaytMethodText			Fünfter Ausgangszahlweg
	OpenAmountInDisplayCrcy
	OpenDueAmountInDisplayCrcy			Fälliger Betrag (Saldo)
	CADunningProcedureName			Mahnverfahren
	CACollectionStrategyName			Collection Strategie
	CABillgCycle	I_ContractAccountPartner	CABillgCycle
	CABillgCycleText			Abrechnungszyklus
	Country	I_ContractAccountPartner	Country
	TransactionCurrency
	CAInvcgChargeAndDiscountKey	_CAChrgAndDiscByContrAcct	CAInvcgChargeAndDiscountKey	Skonto
	CAInvcgChrgAndDiscKeyText
	CAIncomingPaymentLockReason			Aktive Eingangszahlsperren
	CAOutgoingPaymentLockReason			Aktive Ausgangszahlsperren
	CADunningLockReason			Mahnsperren
	CAPostingLockReason			Aktive Buchungssperren
	CAInvcgLockReason			Aktive Fakturasperre
	CAAuthorizationGroup		CAAuthorizationGroup
	ContractAccountCategory	_ContrAcc	ContractAccountCategory

@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._CAIncomingPaymentMethod._Text[1:Language = $session.system_language].CAPaymentMethodName as CAPaymentMethodForIncgPayment,


      @UI: {
           lineItem: [{position: 30, importance: #HIGH, type: #STANDARD, label:'Erster Ausgangszahlweg'}]
         }
       ContractAccountPartner._CAFirstOutgoingPaymentMethod._Text[1:Language = $session.system_language].CAPaymentMethodName as CAFirstOutgoingPaytMethodText,
       
       @EndUserText.label:'Zweiter Ausgangszahlweg'
       ContractAccountPartner._CASecondOutgoingPaymentMethod._Text[1:Language = $session.system_language].CAPaymentMethodName as CASecondOutgoingPaytMethodText,
        
       @EndUserText.label:'Dritter Ausgangszahlweg'
       ContractAccountPartner._CAThirdOutgoingPaymentMethod._Text[1:Language = $session.system_language].CAPaymentMethodName as CAThirdOutgoingPaytMethodText,
       
       @EndUserText.label:'Vierter Ausgangszahlweg'
       ContractAccountPartner._CAFourthOutgoingPaymentMethod._Text[1:Language = $session.system_language].CAPaymentMethodName as CAFourthOutgoingPaytMethodText,
       
       @EndUserText.label:'Fünfter Ausgangszahlweg'
       ContractAccountPartner._CAFifthOutgoingPaymentMethod._Text[1:Language = $session.system_language].CAPaymentMethodName as CAFifthOutgoingPaytMethodText, 
        
//      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


}

Depth:

C_ContractacCBPCFO view

I_ContractAccountPartner view_entity