I_CAINVCGDOCREVERSALREQUEST

CDS View

Stornoauftrag für Fakt.belege

I_CAINVCGDOCREVERSALREQUEST is a CDS View in S/4HANA. Stornoauftrag für Fakt.belege. It contains 24 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 24 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CAInvcgDocReversalRequest view_entity from CONSUMPTION Stornoauftrag für Fakt.belege

Fields (24)

KeyField CDS FieldsUsed in Views
KEY CAInvoicingDocument CAInvoicingDocument 1
KEY CARvslTsk CARvslTsk 1
BusinessPartner BusinessPartner 1
CAAmountInTransactionCurrency CAAmountInTransactionCurrency 1
CABusinessPartnerDocRlvt CABusinessPartnerDocRlvt 1
CAContractAccountDocRlvt CAContractAccountDocRlvt 1
CADeletionDate CADeletionDate 1
CAInvcgCategory CAInvcgCategory 1
CAInvcgCreationDate CAInvcgCreationDate 1
CAInvcgCreationTime CAInvcgCreationTime 1
CAInvcgDocPeriodCategory CAInvcgDocPeriodCategory 1
CAInvcgDocPeriodDate CAInvcgDocPeriodDate 1
CAInvcgDocumentReversalReason CAInvcgDocumentReversalReason 1
CAInvcgMasterDataType CAInvcgMasterDataType 1
CAInvcgProcess CAInvcgProcess 1
CAInvcgType CAInvcgType 1
CANetDueDate CANetDueDate 1
CAReversalRequestDate CAReversalRequestDate 1
CAReversalRequestStatus CAReversalRequestStatus 1
ContractAccount ContractAccount 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreationTime CreationTime 1
TransactionCurrency TransactionCurrency 1 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Stornoauftrag für Fakt.belege'
@VDM.viewType: #BASIC
@ObjectModel: {
  usageType: {
    serviceQuality: #A,
    sizeCategory: #XL,
    dataClass: #TRANSACTIONAL
  }
}
define view entity I_CAInvcgDocReversalRequest
  as select from dfkkinvdoc_rev as invdoc_rev
  association [0..1] to I_CAApplicationArea        as _CAApplicationArea        on  $projection.CAApplicationArea = _CAApplicationArea.CAApplicationArea
  association [0..1] to I_CAInvcgDocHeader         as _CAInvcgDocHeader         on  $projection.CAInvoicingDocument = _CAInvcgDocHeader.CAInvoicingDocument

  // Fix value help

  association [0..1] to I_CAInvcgDocReversalReason as _CAInvcgDocReversalReason on  $projection.CAInvcgDocumentReversalReason = _CAInvcgDocReversalReason.CAInvcgDocumentReversalReason
  association [0..1] to I_CAReversalRequestStatus  as _CAReversalRequestStatus  on  $projection.CAReversalRequestStatus = _CAReversalRequestStatus.CAReversalRequestStatus
  association [0..1] to I_CAInvcgProcess           as _CAInvcgProcess           on  $projection.CAInvcgProcess    = _CAInvcgProcess.CAInvcgProcess
                                                                                and $projection.CAApplicationArea = _CAInvcgProcess.CAApplicationArea
  association [0..1] to I_CAInvcgType              as _CAInvcgType              on  $projection.CAInvcgType       = _CAInvcgType.CAInvcgType
                                                                                and $projection.CAApplicationArea = _CAInvcgType.CAApplicationArea
  association [0..1] to I_CAInvcgCategory          as _CAInvcgCategory          on  $projection.CAInvcgCategory = _CAInvcgCategory.CAInvcgCategory
  association [0..1] to I_CAInvcgMasterDataType    as _CAInvcgMasterDataType    on  $projection.CAInvcgMasterDataType = _CAInvcgMasterDataType.CAInvcgMasterDataType
  association [0..1] to I_CAInvcgPeriodCat         as _CAInvcgPeriodCat         on  $projection.CAInvcgDocPeriodCategory = _CAInvcgPeriodCat.CAInvcgPeriodCategory
{
      @ObjectModel.foreignKey.association: '_CAInvcgDocHeader'
  key invdocno                             as CAInvoicingDocument,
  key revtask                              as CARvslTsk,
      status                               as CAReversalRequestStatus,
      revreason                            as CAInvcgDocumentReversalReason,
      stodt                                as CAReversalRequestDate,
      inv_type                             as CAInvcgType,
      inv_process                          as CAInvcgProcess,
      inv_category                         as CAInvcgCategory,
      gpart                                as BusinessPartner,
      gpart_sel                            as CABusinessPartnerDocRlvt,
      vkont                                as ContractAccount,
      vkont_sel                            as CAContractAccountDocRlvt,
      mdcat                                as CAInvcgMasterDataType,
      invdoc_crdate                        as CAInvcgCreationDate,
      invdoc_crtime                        as CAInvcgCreationTime,
      invpercat                            as CAInvcgDocPeriodCategory,
      invperiod                            as CAInvcgDocPeriodDate,
      faedn                                as CANetDueDate,
      total_curr                           as TransactionCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      total_amt                            as CAAmountInTransactionCurrency,
      crname                               as CreatedByUser,
      crdate                               as CreationDate,
      crtime                               as CreationTime,
      loedt                                as CADeletionDate,

      //APPLK

      @UI.hidden: true
      @ObjectModel.foreignKey.association: '_CAApplicationArea'
      _CAApplicationArea.CAApplicationArea as CAApplicationArea,

      _CAInvcgDocHeader,
      _CAApplicationArea,
      _CAInvcgDocReversalReason,
      _CAReversalRequestStatus,
      _CAInvcgProcess,
      _CAInvcgType,
      _CAInvcgCategory,
      _CAInvcgMasterDataType,
      _CAInvcgPeriodCat
}

Learn More