I_CAInvcgRefPostgDocTypTxt

DDL: I_CAINVCGREFPOSTGDOCTYPTXT Type: view_entity BASIC

Ref.belegarten für Buchungsbel. (Texte)

Reference Document Types for Posting Documents (Texts)

I_CAInvcgRefPostgDocTypTxt (Basic)

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

CAInvcgRefPostgDocTypeTxt · Contract Accounting

I_CAInvcgRefPostgDocTypTxt is a Basic CDS View that provides data about "Ref.belegarten für Buchungsbel. (Texte)" in SAP S/4HANA. It reads from 1 data source (tfk2605t) and exposes 5 fields with key fields CAInvcgRefPostingDocType, Language. It has 2 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
tfk2605t _tfk2605t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CAInvcgRefPostgDocTyp _CAInvcgRefPostgDocType $projection.CAInvcgRefPostingDocType = _CAInvcgRefPostgDocType.CAInvcgRefPostingDocType
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataExtraction.enabled true view
EndUserText.label Ref.belegarten für Buchungsbel. (Texte) view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.representativeKey CAInvcgRefPostingDocType view
ObjectModel.sapObjectNodeType.name CAInvcgRefPostgDocTypeTxt view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CAInvcgRefPostingDocType Reference Document Type of Posting Document for Invoicing
KEY Language tfk2605t langu Primary lang.
CAInvcgRefPostgDocTypeTxt Name of Reference Document Type of Posting Document
_CAInvcgRefPostgDocType _CAInvcgRefPostgDocType
_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_CAInvcgRefPostgDocTypTxt.
-- 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_CAInvcgRefPostgDocTypTxt AS
SELECT
  cast(_tfk2605t.cadoctype as cadoctype_gfn_kk preserving type ) AS CAInvcgRefPostingDocType,
  _tfk2605t.langu AS Language,
  cast(_tfk2605t.text as cadoctype_txt_gfn_kk preserving type ) AS CAInvcgRefPostgDocTypeTxt
FROM tfk2605t AS _tfk2605t
LEFT OUTER JOIN I_CAInvcgRefPostgDocTyp AS _CAInvcgRefPostgDocType ON CAInvcgRefPostingDocType = _CAInvcgRefPostgDocType.CAInvcgRefPostingDocType  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;