I_CADocumentHeader

DDL: I_CADOCUMENTHEADER Type: view BASIC

Contract Accounting Document

I_CADocumentHeader is a Basic CDS View that provides data about "Contract Accounting Document" in SAP S/4HANA. It reads from 1 data source (I_CADocument) and exposes 56 fields with key field CADocumentNumber. It has 3 associations to related views.

1 data source(s) 56 fields

Data Sources (1)

SourceAliasJoin Type
I_CADocument CADoc from

Associations (3)

CardinalityTargetAliasCondition
[1..*] I_CADocumentBPItemLogical _DocBPItem $projection.CADocumentNumber = _DocBPItem.CADocumentNumber
[0..*] I_CAPostingReasonText _PostingReasonText $projection.CADocumentOriginCode = _PostingReasonText.CADocumentOriginCode and $projection.CAPostingReason = _PostingReasonText.CAPostingReason
[1..1] E_CADocumentHeader _Extension $projection.CADocumentNumber = _Extension.CADocumentNumber

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ICADOCHEADER view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataExtraction.enabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Contract Accounting Document view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey CADocumentNumber view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber I_CADocument CADocumentNumber
CAReconciliationKey I_CADocument CAReconciliationKey
CAApplicationArea I_CADocument CAApplicationArea
CADocumentType I_CADocument CADocumentType
CADocumentOriginCode I_CADocument CADocumentOriginCode
CreatedByUser I_CADocument CreatedByUser
CreationDate I_CADocument CreationDate
CreationTime I_CADocument CreationTime
TransactionCurrency I_CADocument TransactionCurrency
DocumentDate I_CADocument DocumentDate
CAPostingDate I_CADocument CAPostingDate
ExchangeRateDate I_CADocument ExchangeRateDate
CAReferenceDocument I_CADocument CAReferenceDocument
CAReturnReason I_CADocument CAReturnReason
CAPostingReason I_CADocument CAPostingReason
CASeparateDocIsCreatedInGL I_CADocument CASeparateDocIsCreatedInGL
ReferenceDocumentType I_CADocument ReferenceDocumentType
OriginalReferenceDocument I_CADocument OriginalReferenceDocument
CAReversedDocumentNumber I_CADocument CAReversedDocumentNumber
CADocumentClass I_CADocument CADocumentClass
CAClearingInformation I_CADocument CAClearingInformation
CATaxCompanyCode I_CADocument CATaxCompanyCode
CAReversalDocumentNumber I_CADocument CAReversalDocumentNumber
CADocumentSupplements I_CADocument CADocumentSupplements
LogicalSystem I_CADocument LogicalSystem
CADocumentVersion I_CADocument CADocumentVersion
CAWorkflowCheckReason I_CADocument CAWorkflowCheckReason
CAWorkflowCheckProcess I_CADocument CAWorkflowCheckProcess
CADocumentTransactionClass I_CADocument CADocumentTransactionClass
CADocumentTypeForGLTransfer I_CADocument CADocumentTypeForGLTransfer
CADocContainsCashFlowItems I_CADocument CADocContainsCashFlowItems
CATaxCodeWasExchanged I_CADocument CATaxCodeWasExchanged
TaxReportingDate I_CADocument TaxReportingDate
CARequestedPeriodForGLTransfer I_CADocument CARequestedPeriodForGLTransfer
IsIndividualPosting I_CADocument IsIndividualPosting
CADocumentIsAged I_CADocument CADocumentIsAged
CADocumentOriginCodeName
_DocBPItem _DocBPItem
_PostingReasonText _PostingReasonText
_AccountingDocType I_CADocument _AccountingDocType
_ApplArea I_CADocument _ApplArea
_CAClearingInformation I_CADocument _CAClearingInformation
_CADocTransactionClass I_CADocument _CADocTransactionClass
_CADocumentClass I_CADocument _CADocumentClass
_CADocumentSupplement I_CADocument _CADocumentSupplement
_CADocumentVersion I_CADocument _CADocumentVersion
_CAPostingReason I_CADocument _CAPostingReason
_CAReturnReason I_CADocument _CAReturnReason
_CARequestedSpecialPeriod I_CADocument _CARequestedSpecialPeriod
_CATaxSupplementStorageLoc I_CADocument _CATaxSupplementStorageLoc
_CompCode I_CADocument _CompCode
_Currency I_CADocument _Currency
_DocType I_CADocument _DocType
_DocOriginCode I_CADocument _DocOriginCode
_WorkflowCheckProcess I_CADocument _WorkflowCheckProcess
_WorkflowCheckReason I_CADocument _WorkflowCheckReason 
//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