I_CANOTDISPUTEDDOCUMENT

CDS View

Not Disputed Document

I_CANOTDISPUTEDDOCUMENT is a CDS View in S/4HANA. Not Disputed Document. It contains 32 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 32 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_CANotDisputedCreditMemo view from CONSUMPTION Not disputed credit memo
C_CANotDisputedDocument view from CONSUMPTION Not Disputed Document

Fields (32)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 2
KEY CAClearingReason CAClearingReason 2
KEY CADocumentNumber CADocumentNumber 2
KEY CAMainTransaction CAMainTransaction 2
KEY CASubTransaction CASubTransaction 2
KEY ContractAccount ContractAccount 2
CAAmountInTransactionCurrency CAAmountInTransactionCurrency 2
CAAuthorizationGroup CAAuthorizationGroup 2
CAClearingDate CAClearingDate 2
CAClearingReasonName CAClearingReasonName 2
CAContract CAContract 2
CADeferralDate CADeferralDate 2
CADocumentOriginCode CADocumentOriginCode 2
CADocumentOriginCodeName CADocumentOriginCodeName 2
CADocumentTypeName CADocumentTypeName 2
CAMainTransactionName CAMainTransactionName 2
CANetDueDate CANetDueDate 2
CAPostingDate CAPostingDate 2
CAReconciliationKey CAReconciliationKey 2
CAReferenceDocument CAReferenceDocument 2
CAReversalDocumentNumber CAReversalDocumentNumber 2
CAReversedDocumentNumber CAReversedDocumentNumber 2
CASubApplication CASubApplication 2
CASubTransactionName CASubTransactionName 2
CompanyCode CompanyCode 2
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
CreationTime CreationTime 2
DocumentDate DocumentDate 2
OpenAmountInTransCrcy OpenAmountInTransCrcy 2
ReferenceDocumentType ReferenceDocumentType 2
TransactionCurrency TransactionCurrency 2 
@AbapCatalog.sqlViewName: 'ICANOTDISDOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {
        sizeCategory: #M,
        serviceQuality: #C,
        dataClass: #TRANSACTIONAL
    }
@ClientHandling.algorithm: #SESSION_VARIABLE    
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Not Disputed Document'
define view I_CANotDisputedDocument as select from P_CANotDisputedDocumentSum as _NotDisputedDoc
  association [1..1] to I_ContractAccountPartner    as _CAPartner            on  $projection.BusinessPartner = _CAPartner.BusinessPartner
                                                                             and $projection.ContractAccount = _CAPartner.ContractAccount
  association [0..1] to I_User                      as _CreatedBy            on  $projection.CreatedByUser   = _CreatedBy.UserID
{
  key _NotDisputedDoc.CADocumentNumber,
  key _NotDisputedDoc.BusinessPartner,
  key _NotDisputedDoc.ContractAccount,
  key _NotDisputedDoc.CAMainTransaction,
  key _NotDisputedDoc.CASubTransaction, 
  key _NotDisputedDoc.CAClearingReason, 
      _NotDisputedDoc.CAContract,
      _NotDisputedDoc.CompanyCode,
      _NotDisputedDoc.CASubApplication,
      _NotDisputedDoc.CANetDueDate,
      _NotDisputedDoc.CADeferralDate,
      _NotDisputedDoc.CAClearingDate,
      _NotDisputedDoc.CAApplicationArea,
      @Semantics.currencyCode
      _NotDisputedDoc.TransactionCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'      
      _NotDisputedDoc.CAAmountInTransactionCurrency,
      _NotDisputedDoc.CreationDate, 
      _NotDisputedDoc.CreationTime,
      _NotDisputedDoc.CAPostingDate,
      _NotDisputedDoc.CAReferenceDocument,
      _NotDisputedDoc.ReferenceDocumentType,
      _NotDisputedDoc.CADocumentTypeName,
      _NotDisputedDoc.DocumentDate,
      _NotDisputedDoc.CAReconciliationKey,
      _NotDisputedDoc.CADocumentOriginCodeName,
      _NotDisputedDoc.CreatedByUser,
      _CreatedBy.UserDescription as CreatedByUserName,
      _NotDisputedDoc.CADocumentOriginCode,
      _NotDisputedDoc.CAReversalDocumentNumber,
      _NotDisputedDoc.CAReversedDocumentNumber,          
      _NotDisputedDoc.CAClearingReasonName,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      cast(_NotDisputedDoc.OpenAmountInTransCrcy as obetw_gfn_kk) as OpenAmountInTransCrcy,
      _NotDisputedDoc.CAMainTransactionName,
      _NotDisputedDoc.CASubTransactionName,
      _CAPartner.CAAuthorizationGroup,
      _NotDisputedDoc.CAClearingDocumentNumber,
      @Semantics.dateTime: true
      cast(dats_tims_to_tstmp(CreationDate,
                              CreationTime,
                              abap_system_timezone($session.client, 'NULL'),
                              $session.client, 'NULL') as vdm_creationdatetime) as CreationDateTime,      
      _CAPartner
}

Learn More