I_CADOCUMENTHEADER

CDS View

Contract Accounting Document

I_CADOCUMENTHEADER is a CDS View in S/4HANA. Contract Accounting Document. It contains 23 fields. 31 CDS views read from this table.

Used by 31 CDS view(s) 23 fields

CDS Views using this table (31)

ViewTypeJoinVDMDescription
C_CADocumentHeaderValueHelp view from CONSUMPTION Belegnummer
C_CADocumentReversal view from CONSUMPTION Reverse Document
C_CAReturnPaymentDocumentVH view from CONSUMPTION Payment Document auf Return Wertehilfer
ESH_N_CADOCUMENTHEADER view from
I_CAClarificationDocumentVH view from COMPOSITE Value Help for Clarification Document
I_CADisputeCaseFllwUpPosting view left_outer COMPOSITE Disputed Follow Up Posting Document
I_CADisputedDocument view inner COMPOSITE Documents in Dispute Cases
I_CADisputedPayment view left_outer COMPOSITE Disputed Payment
I_CAInstallmentPlanVH view_entity from COMPOSITE Installment Plan Number
I_CAInterestNoticeHeader view from COMPOSITE View for Interest Notice Header Data
I_CANotDisputedClearedDoc view from COMPOSITE Not Disputed Cleared Doc
I_CANotDisputedClearedItem view inner COMPOSITE Not Disputed Cleared Items
I_CANotDisputedCredit view from COMPOSITE Not Disputed Credit
I_CANotDisputedOpenDoc view from COMPOSITE Not Disputed Open Doc
I_CANotDisputedOpenItem view inner COMPOSITE Not Disputed Open Items
I_CANotDisputedPayment view from COMPOSITE Not Disputed Payments
I_CAReturnDocumentValueHelp view from COMPOSITE Return Document Wertehilfer
I_CAReversalDocumentVH view from COMPOSITE Reversal Document
I_CAReversedDocumentVH view from COMPOSITE Reversed Document
I_CAScrtyDepRequestProcess view_entity left_outer COMPOSITE Document Process of a Specific Request
I_CASecurityDepositReqDoc view_entity left_outer COMPOSITE Security Deposit Request Document
I_CAWriteOffDocumentVH view from COMPOSITE Ausbuchungsbeleg
P_BOPFICA_BP_ITEM_2 view_entity from COMPOSITE FI-CA BP Item 2
P_BOPFICA_BP_ITEM_2 view_entity union COMPOSITE FI-CA BP Item 2
P_BOPFicaDoc0 view from COMPOSITE
P_CAClearingDocument view inner COMPOSITE Clearing Document
P_CANotDisputedDocumentSum view inner COMPOSITE Not Disputed Document
P_ContractAccountingLineItem view inner CONSUMPTION Items in Contract Accounting document
P_FR_AuditFECPaymentDocsInCA view inner CONSUMPTION France Audit FEC CA payment documents
P_SG_CAClrAmntCalc view inner COMPOSITE
P_SG_CAInvoiceTaxItem view inner COMPOSITE

Fields (23)

KeyField CDS FieldsUsed in Views
KEY CADocumentNumber CADocumentNumber 5
KEY CAReconciliationKey CAReconciliationKey 7
CAApplicationArea CAApplicationArea 2
CADocContainsCashFlowItems CADocContainsCashFlowItems 1
CADocumentClass CADocumentClass 1
CADocumentOriginCode CADocumentOriginCode 7
CADocumentOriginCodeName CADocumentOriginCodeName 4
CADocumentType CADocumentType 3
CADocumentTypeForGLTransfer CADocumentTypeForGLTransfer 1
CADocumentVersion CADocumentVersion 1
CAPostingDate CAPostingDate 9
CAReferenceDocument CAReferenceDocument 5
CAReversalDocumentNumber CAReversalDocumentNumber 6
CAReversedDocumentNumber CAReversedDocumentNumber 7
CASeparateDocIsCreatedInGL CASeparateDocIsCreatedInGL 1
CATaxCompanyCode CATaxCompanyCode 1
CreatedByUser CreatedByUser 8
CreationDate CreationDate 1
CreationTime CreationTime 1
DocumentDate DocumentDate 6
ReferenceDocumentType ReferenceDocumentType 1
TaxReportingDate TaxReportingDate 2
TransactionCurrency TransactionCurrency 1 
//workflow does not support V2 views, therefore we still need to use V1

@AbapCatalog: { sqlViewName: 'ICADOCHEADER', 
                preserveKey: true }

@AccessControl.authorizationCheck: #MANDATORY

@Analytics.dataExtraction.enabled: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Contract Accounting Document'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: { modelingPattern: #NONE,
                representativeKey: 'CADocumentNumber',
                supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
                                         #SQL_DATA_SOURCE,
                                         #CDS_MODELING_DATA_SOURCE,
                                         #EXTRACTION_DATA_SOURCE  ],
                usageType: { serviceQuality: #A,
                             sizeCategory: #XXL,
                             dataClass: #TRANSACTIONAL } }

@VDM.viewType: #BASIC


define view I_CADocumentHeader
  as select from I_CADocument as CADoc

  association [1..*] to I_CADocumentBPItemLogical as _DocBPItem         on  $projection.CADocumentNumber = _DocBPItem.CADocumentNumber
  association [0..*] to I_CAPostingReasonText     as _PostingReasonText on  $projection.CADocumentOriginCode = _PostingReasonText.CADocumentOriginCode
                                                                        and $projection.CAPostingReason      = _PostingReasonText.CAPostingReason

  association [1..1] to E_CADocumentHeader        as _Extension         on  $projection.CADocumentNumber = _Extension.CADocumentNumber

{
  key CADoc.CADocumentNumber,

      CADoc.CAReconciliationKey,
      CADoc.CAApplicationArea,
      CADoc.CADocumentType,
      CADoc.CADocumentOriginCode,
      CADoc.CreatedByUser,
      CADoc.CreationDate,
      CADoc.CreationTime,
      CADoc.TransactionCurrency,
      CADoc.DocumentDate,
      CADoc.CAPostingDate,
      CADoc.ExchangeRateDate,
      CADoc.CAReferenceDocument,
      CADoc.CAReturnReason,
      CADoc.CAPostingReason,
      CADoc.CASeparateDocIsCreatedInGL,
      CADoc.ReferenceDocumentType,
      CADoc.OriginalReferenceDocument,
      CADoc.CAReversedDocumentNumber,
      CADoc.CADocumentClass,
      CADoc.CAClearingInformation,
      CADoc.CATaxCompanyCode,
      CADoc.CAReversalDocumentNumber,
      CADoc.CADocumentSupplements,
      CADoc.LogicalSystem,
      CADoc.CADocumentVersion,
      CADoc.CAWorkflowCheckReason,
      CADoc.CAWorkflowCheckProcess,
      CADoc.CADocumentTransactionClass,
      CADoc.CADocumentTypeForGLTransfer,
      CADoc.CADocContainsCashFlowItems,
      CADoc.CAStorageLocationOfTaxSuplmnt,
      CADoc.CATaxCodeWasExchanged,
      CADoc.TaxReportingDate,
      CADoc.CARequestedPeriodForGLTransfer,
      CADoc.IsIndividualPosting,
      CADoc.CADocumentIsAged,

      _DocOriginCode._Text[1:Language = $session.system_language].CADocumentOriginCodeName,
      
      /* Own Associations */
      _DocBPItem,
      _PostingReasonText,

      /* Associations from I_CADocument */
      CADoc._AccountingDocType,
      CADoc._ApplArea,
      CADoc._CAClearingInformation,
      CADoc._CADocTransactionClass,
      CADoc._CADocumentClass,
      CADoc._CADocumentSupplement,
      CADoc._CADocumentVersion,
      CADoc._CAPostingReason,
      CADoc._CAReturnReason,
      CADoc._CARequestedSpecialPeriod,
      CADoc._CATaxSupplementStorageLoc,
      CADoc._CompCode,
      CADoc._Currency,
      CADoc._DocType,
      CADoc._DocOriginCode,
      CADoc._WorkflowCheckProcess,
      CADoc._WorkflowCheckReason
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CADOCUMENT",
"I_CADOCUMENTORIGINCODE",
"I_CADOCUMENTORIGINCODETEXT"
],
"ASSOCIATED":
[
"E_CADOCUMENTHEADER",
"I_ACCOUNTINGDOCUMENTTYPE",
"I_CAAPPLICATIONAREA",
"I_CACLEARINGINFORMATION",
"I_CADOCTRANSACTIONCLASS",
"I_CADOCUMENTBPITEMLOGICAL",
"I_CADOCUMENTCLASS",
"I_CADOCUMENTORIGINCODE",
"I_CADOCUMENTSUPPLEMENT",
"I_CADOCUMENTTYPE",
"I_CADOCUMENTVERSION",
"I_CAPOSTINGREASON",
"I_CAPOSTINGREASONTEXT",
"I_CAREQUESTEDSPECIALPERIOD",
"I_CARETURNREASON",
"I_CATAXSUPPLEMENTSTORAGELOC",
"I_CAWORKFLOWCHECKPROCESS",
"I_CAWORKFLOWCHECKREASON",
"I_COMPANYCODE",
"I_CURRENCY"
],
"BASE":
[
"I_CADOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More