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 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 
@AbapCatalog.sqlViewName: 'ICAINVDOCREV'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Stornoauftrag für Fakt.belege'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_CAInvcgDocReversalRequest
  as select from dfkkinvdoc_rev as invdoc_rev
  association [1..1] to I_CAApplicationArea        as _CAApplicationArea        on  $projection.CAApplicationArea = _CAApplicationArea.CAApplicationArea

  // 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
{
  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,
      @Semantics.currencyCode: true
      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,

      _CAApplicationArea,
      _CAInvcgDocReversalReason,
      _CAReversalRequestStatus,
      _CAInvcgProcess,
      _CAInvcgType,
      _CAInvcgCategory,
      _CAInvcgMasterDataType,
      _CAInvcgPeriodCat
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAAPPLICATIONAREA",
"DFKKINVDOC_REV"
],
"ASSOCIATED":
[
"I_CAAPPLICATIONAREA",
"I_CAINVCGCATEGORY",
"I_CAINVCGDOCREVERSALREASON",
"I_CAINVCGMASTERDATATYPE",
"I_CAINVCGPERIODCAT",
"I_CAINVCGPROCESS",
"I_CAINVCGTYPE",
"I_CAREVERSALREQUESTSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More