C_CABillgDocInvcgDocSource

DDL: C_CABILLGDOCINVCGDOCSOURCE Type: view_entity CONSUMPTION
18 Fields 1 Data Sources 1 Associations

Fakturierungsbeleg Quellen

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

Data Sources (1)

SourceAliasJoin Type
I_CAInvcgDocSource _CAInvDocSource from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CAInvcgDocHeader _CAInvcgDocHeader $projection.CAInvoicingDocument = _CAInvcgDocHeader.CAInvoicingDocument

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.query.implementedBy ABAP:CL_CINV_RAP_QRY_BILLDOC_DSP view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
EndUserText.label Fakturierungsbeleg Quellen view

Fields (18)

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

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_CABillgDocInvcgDocSource.
-- 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_CABillgDocInvcgDocSource 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,
  cast( '' as billdocno_kk ) AS CABillgDocument,
  _CAInvcgSourceDocCat._CAInvcgSourceDocCatText[1: Language=$session.system_language].CAInvcgSourceDocCatText AS CAInvcgSourceDocCatText,
  _CAInvcgSourceDocType._CAInvcgSourceDocTypeText[1: Language=$session.system_language].CAInvcgSourceDocTypeText AS CAInvcgSourceDocTypeText
FROM I_CAInvcgDocSource AS _CAInvDocSource
LEFT OUTER JOIN I_CAInvcgDocHeader AS _CAInvcgDocHeader ON CAInvoicingDocument = _CAInvcgDocHeader.CAInvoicingDocument  -- association [0..1]
;

Learn More