What is I_CADocumentHeader in SAP S/4HANA?

I_CADocumentHeader is a basic CDS view in SAP S/4HANA. Contract Accounting Document It contains 65 fields.

Which tables does I_CADocumentHeader read from?

I_CADocumentHeader reads data from: I_CADocument.

What VDM layer is I_CADocumentHeader?

I_CADocumentHeader is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_CADocumentHeader

DDL: I_CADOCUMENTHEADER Type: view BASIC

65 Fields 1 Data Sources 3 Associations

Contract Accounting Document

I_CADocumentHeader (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Contract Accounting Document · Contract Accounting

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 65 fields with key field CADocumentNumber. It has 3 associations to related views.

SAP Help Documentation

Category	CDS Views for Transaction Data

Purpose
This CDS view represents the line item in Contract Accounting . The most important data in the line item structure of the Contract Accounting document is comprised of the document number, the reconciliation key, company code, the G/L account, the amounts in transaction and local currencies, and tax details. This CDS view provides the prerequisites for answering the following business questions: Which general ledger accounts are posted to in Contract Accounting ? In which transaction currencies are Contract Accounting documents posted?

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Contract Accounting
Application Component	FI-CA
Capabilities	Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Data Extraction
Package	Contract Accounting for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view represents the line item in Contract Accounting.</p> <p>The most important data in the line item structure of the Contract Accounting document is comprised of the document number, the reconciliation key, company code, the G/L account, the amounts in transaction and local currencies, and tax details.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which general ledger accounts are posted to in Contract Accounting?</p></li> <li><p>In which transaction currencies are Contract Accounting documents posted?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_CADocument	I_CADocument	from

Associations (3)

Cardinality	Target	Alias	Condition
[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 (14)

Name	Value	Level
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.sapObjectNodeType.name	ContrAcctgDocument	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#BASIC	view

Fields (65)

Key	Field	Source Field	Description
KEY	CADocumentNumber	CADocumentNumber	Number of a FI-CA Document
	CAReconciliationKey	CAReconciliationKey	Reconciliation Key for General Ledger
	CAApplicationArea	CAApplicationArea	Application Area
	CADocumentType	CADocumentType	Document Type
	CADocumentOriginCode	CADocumentOriginCode	Document Origin Key
	CreatedByUser	CreatedByUser	Created By
	CreationDate	CreationDate	Creation Date
	CreationTime	CreationTime	Time of Change
	TransactionCurrency	TransactionCurrency	Transaction Currency
	DocumentDate	DocumentDate	Journal Entry Date
	CAPostingDate	CAPostingDate	Posting Date in the Document
	ExchangeRateDate	ExchangeRateDate	Exchange Rate Date
	CAReferenceDocument	CAReferenceDocument	Reference document number
	CAReturnReason	CAReturnReason	Return Reason
	CAPostingReason	CAPostingReason	Posting Reason (For Write-Offs And Transfer Postings)
	CASeparateDocIsCreatedInGL	CASeparateDocIsCreatedInGL	Create Separate Document in General Ledger
	ReferenceDocumentType	ReferenceDocumentType	Reference Document Type
	OriginalReferenceDocument	OriginalReferenceDocument	Reference Key
	CAReversedDocumentNumber	CAReversedDocumentNumber	Number of Reversed Document
	CADocumentClass	CADocumentClass	Document Class
	CAClearingInformation	CAClearingInformation	Clearing Information
	CATaxCompanyCode	CATaxCompanyCode	Tax Company Code
	CAReversalDocumentNumber	CAReversalDocumentNumber	Reversal Document
	CADocumentSupplements	CADocumentSupplements	Existing document supplements
	LogicalSystem	LogicalSystem	Logical system of source document
	CADocumentVersion	CADocumentVersion	Version Number
	CAWorkflowCheckReason	CAWorkflowCheckReason	Check Reason for Workflows Acc. to Dual Control Principle
	CAWorkflowCheckProcess	CAWorkflowCheckProcess	Editing Process To Be Confirmed
	CADocumentTransactionClass	CADocumentTransactionClass	Transaction Class of Document
	CADocumentTypeForGLTransfer	CADocumentTypeForGLTransfer	Document Type for Transfer to General Ledger
	CADocContainsCashFlowItems	CADocContainsCashFlowItems	Document Contains Assignments from Cash Flows
	CATaxCodeWasExchanged	CATaxCodeWasExchanged	Tax Codes Were Exchanged
	TaxReportingDate	TaxReportingDate	Tax Reporting Date
	TaxFulfillmentDate	TaxFulfillmentDate	Tax Settlement Date
	CARequestedPeriodForGLTransfer	CARequestedPeriodForGLTransfer	Requested Special Period for Transfer to General Ledger
	IsIndividualPosting	IsIndividualPosting	Individual Posting
	CADocumentIsAged	CADocumentIsAged	Data Aging: Document was already in historical area
	LastChangeDate	LastChangeDate	Last Changed On
	LastChangeTime	LastChangeTime	Time at Which the Object Was Last Changed
	CAInvcgRefPostingDocType	CAInvcgRefPostingDocType	Reference Document Type of Posting Document for Invoicing
	CAInvoicingDocument	CAInvoicingDocument	Number of Invoicing Document
	CA1stCountrySpecificReference	CA1stCountrySpecificReference	Country/Region-Specific Reference 1 in Document
	CAFirstCountrySpecificDate	CAFirstCountrySpecificDate	Country-/Region-Specific Date 1 in Document
	CADocumentOriginCodeName		Description of Document Origin
	_DocBPItem	_DocBPItem
	_PostingReasonText	_PostingReasonText
	_AccountingDocType	_AccountingDocType
	_ApplArea	_ApplArea
	_CAClearingInformation	_CAClearingInformation
	_CADocTransactionClass	_CADocTransactionClass
	_CADocumentClass	_CADocumentClass
	_CADocumentSupplement	_CADocumentSupplement
	_CADocumentVersion	_CADocumentVersion
	_CAInvcgDocument	_CAInvcgDocument
	_CAInvcgRefPostgDocType	_CAInvcgRefPostgDocType
	_CAPostingReason	_CAPostingReason
	_CAReturnReason	_CAReturnReason
	_CARequestedSpecialPeriod	_CARequestedSpecialPeriod
	_CATaxSupplementStorageLoc	_CATaxSupplementStorageLoc
	_CompCode	_CompCode
	_Currency	_Currency
	_DocType	_DocType
	_DocOriginCode	_DocOriginCode
	_WorkflowCheckProcess	_WorkflowCheckProcess
	_WorkflowCheckReason	_WorkflowCheckReason

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CADocumentHeader.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_CADocumentHeader AS
SELECT
  CADocumentNumber,
  CAReconciliationKey,
  CAApplicationArea,
  CADocumentType,
  CADocumentOriginCode,
  CreatedByUser,
  CreationDate,
  CreationTime,
  TransactionCurrency,
  DocumentDate,
  CAPostingDate,
  ExchangeRateDate,
  CAReferenceDocument,
  CAReturnReason,
  CAPostingReason,
  CASeparateDocIsCreatedInGL,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  CAReversedDocumentNumber,
  CADocumentClass,
  CAClearingInformation,
  CATaxCompanyCode,
  CAReversalDocumentNumber,
  CADocumentSupplements,
  LogicalSystem,
  CADocumentVersion,
  CAWorkflowCheckReason,
  CAWorkflowCheckProcess,
  CADocumentTransactionClass,
  CADocumentTypeForGLTransfer,
  CADocContainsCashFlowItems,
  CATaxCodeWasExchanged,
  TaxReportingDate,
  TaxFulfillmentDate,
  CARequestedPeriodForGLTransfer,
  IsIndividualPosting,
  CADocumentIsAged,
  LastChangeDate,
  LastChangeTime,
  CAInvcgRefPostingDocType,
  CAInvoicingDocument,
  CA1stCountrySpecificReference,
  CAFirstCountrySpecificDate,
  _DocOriginCode._Text[1:Language = $session.system_language].CADocumentOriginCodeName AS CADocumentOriginCodeName
FROM I_CADocument
LEFT OUTER JOIN I_CADocumentBPItemLogical AS _DocBPItem ON CADocumentNumber = _DocBPItem.CADocumentNumber  -- association [1..*]
LEFT OUTER JOIN I_CAPostingReasonText AS _PostingReasonText ON CADocumentOriginCode = _PostingReasonText.CADocumentOriginCode AND CAPostingReason = _PostingReasonText.CAPostingReason  -- association [0..*]
LEFT OUTER JOIN E_CADocumentHeader AS _Extension ON CADocumentNumber = _Extension.CADocumentNumber  -- association [1..1]
;

Depth:

I_CADocumentHeader view

I_CADocument view_entity