I_CAInvcgSourceDocTypeText

DDL: I_CAINVCGSOURCEDOCTYPETEXT Type: view_entity BASIC

Quellbelegarten (Texte)

Source Document Types (Texts)

I_CAInvcgSourceDocTypeText (Basic)

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

ContrAcctgInvcgSrceDocTypeText · Contract Accounting

I_CAInvcgSourceDocTypeText is a Basic CDS View that provides data about "Quellbelegarten (Texte)" in SAP S/4HANA. It reads from 1 data source (tfk2605sct) and exposes 7 fields with key fields CAInvcgSourceDocumentType, CAInvcgSourceDocumentCat, Language. It has 3 associations to related views.

SAP API Hub

StateC1
Line of BusinessContract Accounting
Application ComponentFI-CA-INV
CapabilitiesData Source for Defining CDS Entities, Association Target for Defining CDS Entities, Language-Dependent Text, Data Source for Data Extraction, Data Source in SQL Select
PackageContract Accounting for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
tfk2605sct _tfk2605sct from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_CAInvcgSourceDocCat _CAInvcgSourceDocCat $projection.CAInvcgSourceDocumentCat = _CAInvcgSourceDocCat.CAInvcgSourceDocumentCat
[0..1] I_CAInvcgSourceDocType _CAInvcgSourceDocType $projection.CAInvcgSourceDocumentType = _CAInvcgSourceDocType.CAInvcgSourceDocumentType and $projection.CAInvcgSourceDocumentCat = _CAInvcgSourceDocType.CAInvcgSourceDocumentCat

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataExtraction.enabled true view
EndUserText.label Quellbelegarten (Texte) view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.representativeKey CAInvcgSourceDocumentType view
ObjectModel.sapObjectNodeType.name ContrAcctgInvcgSrceDocTypeText view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CAInvcgSourceDocumentType tfk2605sct srcdoctype Type of Source Document to Be Invoiced
KEY CAInvcgSourceDocumentCat tfk2605sct srcdoccat Category of Source Document To Be Invoiced
KEY Language tfk2605sct langu Primary lang.
CAInvcgSourceDocTypeText Text for Source Document Type
_CAInvcgSourceDocCat _CAInvcgSourceDocCat
_CAInvcgSourceDocType _CAInvcgSourceDocType
_Language _Language

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_CAInvcgSourceDocTypeText.
-- 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_CAInvcgSourceDocTypeText AS
SELECT
  _tfk2605sct.srcdoctype AS CAInvcgSourceDocumentType,
  _tfk2605sct.srcdoccat AS CAInvcgSourceDocumentCat,
  _tfk2605sct.langu AS Language,
  cast( _tfk2605sct.text as srcdoctype_txt_gfn_kk preserving type ) AS CAInvcgSourceDocTypeText
FROM tfk2605sct AS _tfk2605sct
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgSourceDocCat AS _CAInvcgSourceDocCat ON CAInvcgSourceDocumentCat = _CAInvcgSourceDocCat.CAInvcgSourceDocumentCat  -- association [1..1]
LEFT OUTER JOIN I_CAInvcgSourceDocType AS _CAInvcgSourceDocType ON CAInvcgSourceDocumentType = _CAInvcgSourceDocType.CAInvcgSourceDocumentType AND CAInvcgSourceDocumentCat = _CAInvcgSourceDocType.CAInvcgSourceDocumentCat  -- association [0..1]
;