C_CAInvcgChargeAndDiscount

DDL: C_CAINVCGCHARGEANDDISCOUNT SQL: CCACHGDISC Type: view CONSUMPTION

Zu- und Abschläge

C_CAInvcgChargeAndDiscount is a Consumption CDS View that provides data about "Zu- und Abschläge" in SAP S/4HANA. It reads from 1 data source (I_ConAcctPrtnInvcgChrgAndDisc) and exposes 12 fields with key fields ContractAccount, BusinessPartner, CAInvcgChargeAndDiscountKey, CAInvcgChrgAndDiscKeyStartDate. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ConAcctPrtnInvcgChrgAndDisc _ConAcctPrtnInvcgChrgAndDisc from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CAInvcgChrgAndDiscKey _CAInvcgChrgAndDiscKey $projection.CAInvcgChargeAndDiscountKey = _CAInvcgChrgAndDiscKey.CAInvcgChargeAndDiscountKey and $projection.CAApplicationArea = _CAInvcgChrgAndDiscKey.CAApplicationArea
[0..*] I_CAInvcgChrgAndDiscKeyText _CAInvcgChrgAndDiscKeyText $projection.CAInvcgChargeAndDiscountKey = _CAInvcgChrgAndDiscKeyText.CAInvcgChargeAndDiscountKey and $projection.CAApplicationArea = _CAInvcgChrgAndDiscKeyText.CAApplicationArea

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCACHGDISC view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Zu- und Abschläge view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
UI.headerInfo.typeName Zu- und Abschlag view
UI.headerInfo.typeNamePlural Zu- und Abschläge view
UI.presentationVariant.sortOrder.by CAInvcgChrgAndDiscKeyStartDate view
UI.presentationVariant.sortOrder.direction #DESC view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ContractAccount I_ConAcctPrtnInvcgChrgAndDisc ContractAccount
KEY BusinessPartner I_ConAcctPrtnInvcgChrgAndDisc BusinessPartner
KEY CAInvcgChargeAndDiscountKey I_ConAcctPrtnInvcgChrgAndDisc CAInvcgChargeAndDiscountKey
KEY CAInvcgChrgAndDiscKeyStartDate I_ConAcctPrtnInvcgChrgAndDisc CAInvcgChrgAndDiscKeyStartDate
CAInvcgChrgAndDiscKeyEndDate I_ConAcctPrtnInvcgChrgAndDisc CAInvcgChrgAndDiscKeyEndDate
CAApplicationArea _ContractAccount CAApplicationArea
_ApplArea _ContractAccount _ApplArea
_BusinessPartner _BusinessPartner
_ContractAccount _ContractAccount
_ContractAccountPartner _ContractAccountPartner
_CAInvcgChrgAndDiscKey _CAInvcgChrgAndDiscKey
_CAInvcgChrgAndDiscKeyText _CAInvcgChrgAndDiscKeyText
@AbapCatalog.sqlViewName: 'CCACHGDISC'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Zu- und Abschläge'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK
@UI:{
  headerInfo:{
    typeName: 'Zu- und Abschlag',
    typeNamePlural: 'Zu- und Abschläge'
  },
  presentationVariant.sortOrder: { by: 'CAInvcgChrgAndDiscKeyStartDate', direction: #DESC }
}
define view C_CAInvcgChargeAndDiscount
  as select from I_ConAcctPrtnInvcgChrgAndDisc as _ConAcctPrtnInvcgChrgAndDisc

  // ADDITIONAL DATA


  association [0..1] to I_CAInvcgChrgAndDiscKey     as _CAInvcgChrgAndDiscKey     on  $projection.CAInvcgChargeAndDiscountKey = _CAInvcgChrgAndDiscKey.CAInvcgChargeAndDiscountKey
                                                                                  and $projection.CAApplicationArea           = _CAInvcgChrgAndDiscKey.CAApplicationArea
  association [0..*] to I_CAInvcgChrgAndDiscKeyText as _CAInvcgChrgAndDiscKeyText on  $projection.CAInvcgChargeAndDiscountKey = _CAInvcgChrgAndDiscKeyText.CAInvcgChargeAndDiscountKey
                                                                                  and $projection.CAApplicationArea           = _CAInvcgChrgAndDiscKeyText.CAApplicationArea

{
      //VKONT

      @Consumption.semanticObject: 'ContractAccount'
  key _ConAcctPrtnInvcgChrgAndDisc.ContractAccount,

      //GPART

      @Consumption.semanticObject: 'CAContractPartner'
  key _ConAcctPrtnInvcgChrgAndDisc.BusinessPartner,

      //CHGKEY

      @UI.lineItem:       { position: 10, importance: #HIGH}
      @ObjectModel.foreignKey.association: '_CAInvcgChrgAndDiscKey'
      @ObjectModel.text.association: '_CAInvcgChrgAndDiscKeyText'
      //@ObjectModel.text.element: 'CAInvcgChrgAndDiscKeyText'

  key _ConAcctPrtnInvcgChrgAndDisc.CAInvcgChargeAndDiscountKey,

      //CHGDISC_DATE_FR

      @UI.lineItem:       { position: 20, importance: #HIGH}
  key _ConAcctPrtnInvcgChrgAndDisc.CAInvcgChrgAndDiscKeyStartDate,

      //CHGDISC_DATE_TO

      @UI.lineItem:       { position: 30, importance: #HIGH}
      _ConAcctPrtnInvcgChrgAndDisc.CAInvcgChrgAndDiscKeyEndDate,

      @Consumption.hidden: true
      _ContractAccount.CAApplicationArea as CAApplicationArea,
      @Consumption.hidden: true
      _ContractAccount._ApplArea,

      _BusinessPartner,
      _ContractAccount,
      _ContractAccountPartner,
      _CAInvcgChrgAndDiscKey,
      _CAInvcgChrgAndDiscKeyText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONACCTPRTNINVCGCHRGANDDISC",
"I_CONTRACTACCOUNTHEADER"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CAAPPLICATIONAREA",
"I_CAINVCGCHRGANDDISCKEY",
"I_CAINVCGCHRGANDDISCKEYTEXT",
"I_CONTRACTACCOUNTHEADER",
"I_CONTRACTACCOUNTPARTNER"
],
"BASE":
[
"I_CONACCTPRTNINVCGCHRGANDDISC",
"I_CONTRACTACCOUNTHEADER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/