C_CAInvcgDocSource

DDL: C_CAINVCGDOCSOURCE Type: view_entity CONSUMPTION
20 Fields 1 Data Sources 3 Associations

Fakturierungsbeleg Quellen

C_CAInvcgDocSource is a Consumption CDS View that provides data about "Fakturierungsbeleg Quellen" in SAP S/4HANA. It reads from 1 data source (R_CAInvcgDocSourceTP) and exposes 20 fields with key fields CAInvoicingDocument, CAInvcgSourceDocumentNumber, CAInvcgSourceDocumentCat. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_CAInvcgDocSourceTP _CAInvDocSource from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_CAInvcgDocHeader _CAInvcgDocHeader $projection.CAInvoicingDocument = _CAInvcgDocHeader.CAInvoicingDocument -- required for in-app navigation
[0..1] C_CAInvcgDocHeader _CAInvcgReversalDocument $projection.CAInvcgReversalDocument = _CAInvcgReversalDocument.CAInvoicingDocument
[0..1] C_CAInvcgDocHeader _CAInvcgReversedDocument $projection.CAInvcgReversedDocument = _CAInvcgReversedDocument.CAInvoicingDocument

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
EndUserText.label Fakturierungsbeleg Quellen view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CAInvoicingDocument R_CAInvcgDocSourceTP CAInvoicingDocument Invoic. Doc.
KEY CAInvcgSourceDocumentNumber R_CAInvcgDocSourceTP CAInvcgSourceDocumentNumber Source Document Number
KEY CAInvcgSourceDocumentCat R_CAInvcgDocSourceTP CAInvcgSourceDocumentCat Source Document Category
CAInvcgSourceDocumentSemObj
CAInvcgSourceDocumentType R_CAInvcgDocSourceTP CAInvcgSourceDocumentType Source Doc.Type
CAInvcgIsDocumentSimulated R_CAInvcgDocSourceTP CAInvcgIsDocumentSimulated Doc. Simulated
CAInvcgIsDocumentPreliminary R_CAInvcgDocSourceTP CAInvcgIsDocumentPreliminary Preliminary Invoice
LogicalSystem R_CAInvcgDocSourceTP LogicalSystem Logical System
CAApplicationArea R_CAInvcgDocSourceTP CAApplicationArea ApplicationArea
CAInvcgIsDocumentPosted R_CAInvcgDocSourceTP CAInvcgIsDocumentPosted Document Posted
CAInvcgReversalDocument R_CAInvcgDocSourceTP CAInvcgReversalDocument Reversal Doc.
CAInvcgReversedDocument R_CAInvcgDocSourceTP CAInvcgReversedDocument Reversed Invoicing Doc
CAInvcgCreationDate R_CAInvcgDocSourceTP CAInvcgCreationDate Invoiced On
CAInvcgSourceDocCatText
CAInvcgSourceDocTypeText
_CAInvcgDocHeader _CAInvcgDocHeader
_CAInvcgSourceDocCat _CAInvcgSourceDocCat
_CAInvcgSourceDocType _CAInvcgSourceDocType
_CAInvcgReversalDocument _CAInvcgReversalDocument
_CAInvcgReversedDocument _CAInvcgReversedDocument

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 C_CAInvcgDocSource.
-- 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 C_CAInvcgDocSource AS
SELECT
  _CAInvDocSource.CAInvoicingDocument AS CAInvoicingDocument,
  _CAInvDocSource.CAInvcgSourceDocumentNumber AS CAInvcgSourceDocumentNumber,
  _CAInvDocSource.CAInvcgSourceDocumentCat AS CAInvcgSourceDocumentCat,
  _CAInvDocSource._CAInvcgSourceDocCat.CAInvcgSourceDocumentSemObj AS CAInvcgSourceDocumentSemObj,
  _CAInvDocSource.CAInvcgSourceDocumentType AS CAInvcgSourceDocumentType,
  _CAInvDocSource.CAInvcgIsDocumentSimulated AS CAInvcgIsDocumentSimulated,
  _CAInvDocSource.CAInvcgIsDocumentPreliminary AS CAInvcgIsDocumentPreliminary,
  _CAInvDocSource.LogicalSystem AS LogicalSystem,
  _CAInvDocSource.CAApplicationArea AS CAApplicationArea,
  _CAInvDocSource.CAInvcgIsDocumentPosted AS CAInvcgIsDocumentPosted,
  _CAInvDocSource.CAInvcgReversalDocument AS CAInvcgReversalDocument,
  _CAInvDocSource.CAInvcgReversedDocument AS CAInvcgReversedDocument,
  _CAInvDocSource.CAInvcgCreationDate AS CAInvcgCreationDate,
  _CAInvcgSourceDocCat._CAInvcgSourceDocCatText[1: Language=$session.system_language].CAInvcgSourceDocCatText AS CAInvcgSourceDocCatText,
  _CAInvcgSourceDocType._CAInvcgSourceDocTypeText[1: Language=$session.system_language].CAInvcgSourceDocTypeText AS CAInvcgSourceDocTypeText
FROM R_CAInvcgDocSourceTP AS _CAInvDocSource
LEFT OUTER JOIN C_CAInvcgDocHeader AS _CAInvcgDocHeader ON CAInvoicingDocument = _CAInvcgDocHeader.CAInvoicingDocument  -- association [1..1]
LEFT OUTER JOIN C_CAInvcgDocHeader AS _CAInvcgReversalDocument ON CAInvcgReversalDocument = _CAInvcgReversalDocument.CAInvoicingDocument  -- association [0..1]
LEFT OUTER JOIN C_CAInvcgDocHeader AS _CAInvcgReversedDocument ON CAInvcgReversedDocument = _CAInvcgReversedDocument.CAInvoicingDocument  -- association [0..1]
;

Learn More