A_CADocumentHeader

DDL: A_CADOCUMENTHEADER Type: view_entity CONSUMPTION

Contract Accounting Document

A_CADocumentHeader is a Consumption CDS View that provides data about "Contract Accounting Document" in SAP S/4HANA. It reads from 1 data source (R_CADocumentTP) and exposes 35 fields with key field CADocumentNumber.

Data Sources (1)

SourceAliasJoin Type
R_CADocumentTP R_CADocumentTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Contract Accounting Document view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey CADocumentNumber view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
OData.entityType.name CADocHeader_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber Document Number
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CATaxCompanyCode CATaxCompanyCode Tax comp. code
CATaxCodeWasExchanged CATaxCodeWasExchanged New Tax Code
TaxReportingDate TaxReportingDate Tax Reporting Date
CAReconciliationKey CAReconciliationKey Reconcil. Key
CASeparateDocIsCreatedInGL CASeparateDocIsCreatedInGL Single Document
CARequestedPeriodForGLTransfer CARequestedPeriodForGLTransfer Special Period
CAApplicationArea CAApplicationArea ApplicationArea
CADocumentType CADocumentType Document Type
CADocumentOriginCode CADocumentOriginCode Document Origin
TransactionCurrency TransactionCurrency Transaction Currency
DocumentDate DocumentDate Journal Entry Date
CAPostingDate CAPostingDate Posting Date
ExchangeRateDate ExchangeRateDate Translatn Date
CAReferenceDocument CAReferenceDocument Reference
CAReturnReason CAReturnReason Return Reason
CAPostingReason CAPostingReason Posting Reason
ReferenceDocumentType ReferenceDocumentType Reference Document Type
OriginalReferenceDocument OriginalReferenceDocument Reference Key
CAReversedDocumentNumber CAReversedDocumentNumber Rev. Doc. For
CAClearingInformation CAClearingInformation Clearing Info
CAReversalDocumentNumber CAReversalDocumentNumber Revers.document
CADocumentSupplements CADocumentSupplements Doc supps
LogicalSystem LogicalSystem Logical System
CAWorkflowCheckReason CAWorkflowCheckReason Check Reason
CAWorkflowCheckProcess CAWorkflowCheckProcess Process
CADocumentTransactionClass CADocumentTransactionClass Transact.type
CADocContainsCashFlowItems CADocContainsCashFlowItems Cash Flow
CADocumentClass CADocumentClass Document Class
CADocumentVersion CADocumentVersion Version
IsIndividualPosting IsIndividualPosting Indiv. Posting
CADocumentIsAged CADocumentIsAged Data Aging

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 A_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 A_CADocumentHeader AS
SELECT
  CADocumentNumber,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CATaxCompanyCode,
  CATaxCodeWasExchanged,
  TaxReportingDate,
  CAReconciliationKey,
  CASeparateDocIsCreatedInGL,
  CARequestedPeriodForGLTransfer,
  CAApplicationArea,
  CADocumentType,
  CADocumentOriginCode,
  TransactionCurrency,
  DocumentDate,
  CAPostingDate,
  ExchangeRateDate,
  CAReferenceDocument,
  CAReturnReason,
  CAPostingReason,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  CAReversedDocumentNumber,
  CAClearingInformation,
  CAReversalDocumentNumber,
  CADocumentSupplements,
  LogicalSystem,
  CAWorkflowCheckReason,
  CAWorkflowCheckProcess,
  CADocumentTransactionClass,
  CADocContainsCashFlowItems,
  CADocumentClass,
  CADocumentVersion,
  IsIndividualPosting,
  CADocumentIsAged
FROM R_CADocumentTP
;