C_CAInvcgDocContractAccount

DDL: C_CAINVCGDOCCONTRACTACCOUNT Type: view_entity CONSUMPTION Package: ODATA_O2C_CI_INVDOC

Fakturierungsbelege je Vertragskonto

C_CAInvcgDocContractAccount is a Consumption CDS View that provides data about "Fakturierungsbelege je Vertragskonto" in SAP S/4HANA. It reads from 1 data source (C_CAInvcgDocContractAccount0) and exposes 10 fields with key fields ContractAccount, CAInvoicingDocument. It has 2 associations to related views. Part of development package ODATA_O2C_CI_INVDOC.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
C_CAInvcgDocContractAccount0 C_CAInvcgDocContractAccount0 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ContractAccountHeader _ContractAccountHeader $projection.ContractAccount = _ContractAccountHeader.ContractAccount
[0..1] C_CAInvcgDocHeader _CAInvcgDocHeader $projection.CAInvoicingDocument = _CAInvcgDocHeader.CAInvoicingDocument

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Fakturierungsbelege je Vertragskonto view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ContractAccount _CAInvcgDocContractAccount ContractAccount
KEY CAInvoicingDocument _CAInvcgDocContractAccount CAInvoicingDocument
BusinessPartner _CAInvcgDocContractAccount BusinessPartner
CAAmountInTransactionCurrency _CAInvcgDocContractAccount CAAmountInTransactionCurrency Betrag
TransactionCurrency _CAInvcgDocContractAccount TransactionCurrency
CAInvcgCreationDate _CAInvcgDocContractAccount CAInvcgCreationDate
CAInvcgCreationTime _CAInvcgDocContractAccount CAInvcgCreationTime
_ContractAccountHeader _ContractAccountHeader
_ContractAccountPartner _ContractAccountPartner
_CAInvcgDocHeader _CAInvcgDocHeader 
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Fakturierungsbelege je Vertragskonto'

@UI.chart:[{
      chartType: #COLUMN,
      measures:[ 'CAAmountInTransactionCurrency' ],
      dimensions: [ 'CAInvoicingDocument', 'CAInvcgCreationDate', 'CAInvcgCreationTime' ]
//      dimensions: [ 'CAInvoicingDocument' ]

    }]

@UI.presentationVariant: [ {sortOrder: [ { by: 'CAInvcgCreationDate', direction: #DESC },
                                         { by: 'CAInvcgCreationTime', direction: #DESC }] }]
define view entity C_CAInvcgDocContractAccount
  as select from C_CAInvcgDocContractAccount0 ( P_KeyDate: $session.system_date,
                                                P_CAInvcgTrggrDiffOfMnths: -12 ) as _CAInvcgDocContractAccount
  // ADDITIONAL DATA

  association [0..1] to I_ContractAccountHeader as _ContractAccountHeader on $projection.ContractAccount = _ContractAccountHeader.ContractAccount
  association [0..1] to C_CAInvcgDocHeader      as _CAInvcgDocHeader      on $projection.CAInvoicingDocument = _CAInvcgDocHeader.CAInvoicingDocument
{
         // VKONT

         @UI.lineItem: [{ position: 10, importance: #HIGH }]
         @Consumption.semanticObject: 'ContractAccount'
  key    _CAInvcgDocContractAccount.ContractAccount,

         //INVDOCNO

         @UI.lineItem: [{ position: 20, importance: #HIGH }]
  key    _CAInvcgDocContractAccount.CAInvoicingDocument,

         @UI.hidden: true
         _CAInvcgDocContractAccount.BusinessPartner,

         // Amount

         @Semantics.amount.currencyCode: 'TRANSACTIONCURRENCY'
         @UI.lineItem: [{ position: 30, importance: #HIGH }]
         @DefaultAggregation: #SUM

         @EndUserText.label: 'Betrag'
         _CAInvcgDocContractAccount.CAAmountInTransactionCurrency,

         // Currency

         _CAInvcgDocContractAccount.TransactionCurrency,

         // CRDATE

         @UI.lineItem: [{ position: 40, importance: #HIGH }]
         @Semantics.businessDate.at: true
         _CAInvcgDocContractAccount.CAInvcgCreationDate,

         // CRTIME

         _CAInvcgDocContractAccount.CAInvcgCreationTime,

         _ContractAccountHeader,
         _ContractAccountPartner,
         _CAInvcgDocHeader
}

Learn More